Target Column	Business Definition	Database Data Type	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	CALCULATION	DECODE(GURMAIL_MISC_DATE,NULL,GURMAIL_DATE_PRINTED)
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: