Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACADEMIC_PERIOD		Academic period or time frame associated with the communication or material sent to the person.	VARCHAR2(6)		GURMAIL	GURMAIL_TERM_CODE
ACADEMIC_PERIOD_DESC		Academic period description.	VARCHAR2(30)		STVTERM	STVTERM_DESC
ACADEMIC_YEAR		Academic year associated with the academic period on this record.	VARCHAR2(4)		STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC		Academic year description.	VARCHAR2(30)		STVACYR	STVACYR_DESC
ACTIVITY_DATE		Date the record was created or last updated.	DATE		GURMAIL	GURMAIL_ACTIVITY_DATE
AID_YEAR		Aid year associated with this record. For example, aid year 0304 or aid year 0405.	VARCHAR2(4)		GURMAIL	GURMAIL_AIDY_CODE
AID_YEAR_DESC		Financial aid year name.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
APPLICATION_NUMBER		Application number for the admission application record for a specific academic period.	NUMBER(2)		GURMAIL	GURMAIL_ADMIN_IDENTIFIER
COMMUNICATION		Letter, email, web notice or material, etc. communication type associated with this record.	VARCHAR2(15)		GURMAIL	GURMAIL_LETR_CODE
COMMUNICATION_DESC		Communication description.	VARCHAR2(30)		GTVLETR	GTVLETR_DESC
COMMUNICATION_PLAN		Communication plan used to add the communication material or letter.	VARCHAR2(4)		GURMAIL	GURMAIL_CPLN_CODE
COMMUNICATION_PLAN_DESC		Communication plan description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
COMMUNICATION_SOURCE		Department or office responsible for performing, scheduling and/or sending this communication.	VARCHAR2(1)		GURMAIL	GURMAIL_MODULE_CODE
COMMUNICATION_SOURCE_DESC		Communication source description.	VARCHAR2(30)		GURMAIL	GURMAIL_MODULE_CODE
COMMUNICATION_TYPE		Type of communication represented in this record. It may be a pre-printed, published material or a generated material or action, etc.	VARCHAR2(1)		GURMAIL	GURMAIL_PUB_GEN
COMMUNICATION_TYPE_DESC		Communication type description.	VARCHAR2(40)		CALCULATION	DECODE(GURMAIL_PUB_GEN,'P','PRE-PRINTED OR PUBLISHED MATERIAL','G','GENERATED MATERIAL')
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DATE_INITIATED		Date the communication or material was initiated or scheduled.	DATE		GURMAIL	GURMAIL_DATE_INIT
DATE_PRINTED		Date the communication or material was completed.	DATE		GURMAIL	GURMAIL_DATE_PRINTED
DATE_SENT		Date the communication or material was sent.	DATE
DEGREE		Degree or award code associated with the academic study.	VARCHAR2(0)		NA	NA
DEGREE_DESC		Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.	VARCHAR2(0)		NA	NA
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
MAJOR		Major for the curriculum associated with the communication material.	VARCHAR2(0)		NA	NA
MAJOR_DESC		Major or subject area description.	VARCHAR2(0)		NA	NA
MATERIAL		Material code (if any) associated with the communication material.	VARCHAR2(4)		GURMAIL	GURMAIL_MATL_CODE_MOD
MATERIAL_DESC		Material code description.	VARCHAR2(30)		STVMATL	STVMATL_DESC
MIF_DESC		Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE		Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
PENDING_LETTER_IND		Indicates whether the communication material is pending or it has been completed.	VARCHAR2(1)		CALCULATION	DECODE(GURMAIL_DATE_PRINTED,NULL,'Y','N')
PERSON_UID		System generated, unique, internal identification number assigned to this person.	NUMBER(8)		GURMAIL	GURMAIL_PIDM
PROGRAM		Curriculum program associated with the communication material.	VARCHAR2(0)		NA	NA
PROGRAM_DESC		Curriculum program description.	VARCHAR2(0)		NA	NA
QUANTITY		Quantity of materials, letters or other correspondence tracked.	NUMBER(3)		GURMAIL	GURMAIL_QTY
SUB_ACADEMIC_PERIOD		A session, portion or part of the academic period.	VARCHAR2(0)		NA	NA
SUB_ACADEMIC_PERIOD_DESC		Sub academic period description.	VARCHAR2(0)		NA	NA
SYSTEM		Business area that initiated the communication or material to be sent to the person.	VARCHAR2(2)		GURMAIL	GURMAIL_SYSTEM_IND
SYSTEM_DESC		System initating communication description.	VARCHAR2(30)		GTVSYSI	GTVSYSI_DESC
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: