ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ACTIVITY_DATE	Date record was inserted or updated			NA	SYSDATE
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
COMMUNICATION1	Letter, email, web notice or material, etc. communication type associated with this record.			GURMAIL	GURMAIL_LETR_CODE
COMMUNICATION2	Letter, email, web notice or material, etc. communication type associated with this record.			GURMAIL	GURMAIL_LETR_CODE
COMMUNICATION3	Letter, email, web notice or material, etc. communication type associated with this record.			GURMAIL	GURMAIL_LETR_CODE
COMMUNICATION4	Letter, email, web notice or material, etc. communication type associated with this record.			GURMAIL	GURMAIL_LETR_CODE
COMMUNICATION5	Letter, email, web notice or material, etc. communication type associated with this record.			GURMAIL	GURMAIL_LETR_CODE
COMMUNICATION_DESC1	Communication description.			FUNCTION	GOKODSF.F_GET_DESC
COMMUNICATION_DESC2	Communication description.			FUNCTION	GOKODSF.F_GET_DESC
COMMUNICATION_DESC3	Communication description.			FUNCTION	GOKODSF.F_GET_DESC
COMMUNICATION_DESC4	Communication description.			FUNCTION	GOKODSF.F_GET_DESC
COMMUNICATION_DESC5	Communication description.			FUNCTION	GOKODSF.F_GET_DESC
COMMUNICATION_PLAN1	Communication plan used to add the material or letter.			GURMAIL	GURMAIL_CPLN_CODE
COMMUNICATION_PLAN2	Communication plan used to add the material or letter.			GURMAIL	GURMAIL_CPLN_CODE
COMMUNICATION_PLAN3	Communication plan used to add the material or letter.			GURMAIL	GURMAIL_CPLN_CODE
COMMUNICATION_PLAN4	Communication plan used to add the material or letter.			GURMAIL	GURMAIL_CPLN_CODE
COMMUNICATION_PLAN5	Communication plan used to add the material or letter.			GURMAIL	GURMAIL_CPLN_CODE
COMMUNICATION_PLAN_DESC1	Description of communication plan used to add the material or letter.			FUNCTION	GOKODSF.F_GET_DESC
COMMUNICATION_PLAN_DESC2	Description of communication plan used to add the material or letter.			FUNCTION	GOKODSF.F_GET_DESC
COMMUNICATION_PLAN_DESC3	Description of communication plan used to add the material or letter.			FUNCTION	GOKODSF.F_GET_DESC
COMMUNICATION_PLAN_DESC4	Description of communication plan used to add the material or letter.			FUNCTION	GOKODSF.F_GET_DESC
COMMUNICATION_PLAN_DESC5	Description of communication plan used to add the material or letter.			FUNCTION	GOKODSF.F_GET_DESC
COMMUNICATION_RULE	COMMUNICATION_RULE is stored as MGRSDAX_INTERNAL_CODE column and is used to define a specific hierarchy or sequence for display of the values in a slotted reporting view. This may be used to specify the values for each slot or to select data through a reporting tool selection criteria.			MGRSDAX	MGRSDAX_INTERNAL_CODE
COMMUNICATION_SOURCE1	Department or office responsible for performing, scheduling and/or sending this communication.			GURMAIL	GURMAIL_MODULE_CODE
COMMUNICATION_SOURCE2	Department or office responsible for performing, scheduling and/or sending this communication.			GURMAIL	GURMAIL_MODULE_CODE
COMMUNICATION_SOURCE3	Department or office responsible for performing, scheduling and/or sending this communication.			GURMAIL	GURMAIL_MODULE_CODE
COMMUNICATION_SOURCE4	Department or office responsible for performing, scheduling and/or sending this communication.			GURMAIL	GURMAIL_MODULE_CODE
COMMUNICATION_SOURCE5	Department or office responsible for performing, scheduling and/or sending this communication.			GURMAIL	GURMAIL_MODULE_CODE
COMMUNICATION_SOURCE_DESC1	Communication source description.			FUNCTION	GOKODSF.F_GURMAIL_MODULE_CODE_DESC
COMMUNICATION_SOURCE_DESC2	Communication source description.			FUNCTION	GOKODSF.F_GURMAIL_MODULE_CODE_DESC
COMMUNICATION_SOURCE_DESC3	Communication source description.			FUNCTION	GOKODSF.F_GURMAIL_MODULE_CODE_DESC
COMMUNICATION_SOURCE_DESC4	Communication source description.			FUNCTION	GOKODSF.F_GURMAIL_MODULE_CODE_DESC
COMMUNICATION_SOURCE_DESC5	Communication source description.			FUNCTION	GOKODSF.F_GURMAIL_MODULE_CODE_DESC
COMMUNICATION_TYPE1	Type of communication represented in this record. It may be a pre-printed, published material or a generated material or action, etc.			GURMAIL	GURMAIL_PUB_GEN
COMMUNICATION_TYPE2	Type of communication represented in this record. It may be a pre-printed, published material or a generated material or action, etc.			GURMAIL	GURMAIL_PUB_GEN
COMMUNICATION_TYPE3	Type of communication represented in this record. It may be a pre-printed, published material or a generated material or action, etc.			GURMAIL	GURMAIL_PUB_GEN
COMMUNICATION_TYPE4	Type of communication represented in this record. It may be a pre-printed, published material or a generated material or action, etc.			GURMAIL	GURMAIL_PUB_GEN
COMMUNICATION_TYPE5	Type of communication represented in this record. It may be a pre-printed, published material or a generated material or action, etc.			GURMAIL	GURMAIL_PUB_GEN
COMMUNICATION_TYPE_DESC1	Communication type description.			CALCULATION	DECODE(GURMAIL_PUB_GEN,'P','PRE-PRINTED OR PUBLISHED MATERIAL','G','GENERATED MATERIAL')
COMMUNICATION_TYPE_DESC2	Communication type description.			CALCULATION	DECODE(GURMAIL_PUB_GEN,'P','PRE-PRINTED OR PUBLISHED MATERIAL','G','GENERATED MATERIAL')
COMMUNICATION_TYPE_DESC3	Communication type description.			CALCULATION	DECODE(GURMAIL_PUB_GEN,'P','PRE-PRINTED OR PUBLISHED MATERIAL','G','GENERATED MATERIAL')
COMMUNICATION_TYPE_DESC4	Communication type description.			CALCULATION	DECODE(GURMAIL_PUB_GEN,'P','PRE-PRINTED OR PUBLISHED MATERIAL','G','GENERATED MATERIAL')
COMMUNICATION_TYPE_DESC5	Communication type description.			CALCULATION	DECODE(GURMAIL_PUB_GEN,'P','PRE-PRINTED OR PUBLISHED MATERIAL','G','GENERATED MATERIAL')
DATE_INITIATED1	Date the communication or material was initiated or scheduled.			GURMAIL	GURMAIL_DATE_INIT
DATE_INITIATED2	Date the communication or material was initiated or scheduled.			GURMAIL	GURMAIL_DATE_INIT
DATE_INITIATED3	Date the communication or material was initiated or scheduled.			GURMAIL	GURMAIL_DATE_INIT
DATE_INITIATED4	Date the communication or material was initiated or scheduled.			GURMAIL	GURMAIL_DATE_INIT
DATE_INITIATED5	Date the communication or material was initiated or scheduled.			GURMAIL	GURMAIL_DATE_INIT
DATE_PRINTED1	Date the communication or material was completed.			GURMAIL	GURMAIL_DATE_PRINTED
DATE_PRINTED2	Date the communication or material was completed.			GURMAIL	GURMAIL_DATE_PRINTED
DATE_PRINTED3	Date the communication or material was completed.			GURMAIL	GURMAIL_DATE_PRINTED
DATE_PRINTED4	Date the communication or material was completed.			GURMAIL	GURMAIL_DATE_PRINTED
DATE_PRINTED5	Date the communication or material was completed.			GURMAIL	GURMAIL_DATE_PRINTED
DATE_SENT1	Date the communication or material was sent.			CALCULATION	NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED)
DATE_SENT2	Date the communication or material was sent.			CALCULATION	NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED)
DATE_SENT3	Date the communication or material was sent.			CALCULATION	NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED)
DATE_SENT4	Date the communication or material was sent.			CALCULATION	NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED)
DATE_SENT5	Date the communication or material was sent.			CALCULATION	NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED)
ID	Person's identification number used to access the records associated with the person.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
MATERIAL1	The Materials code.			GURMAIL	GURMAIL_MATL_CODE_MOD
MATERIAL2	The Materials code.			GURMAIL	GURMAIL_MATL_CODE_MOD
MATERIAL3	The Materials code.			GURMAIL	GURMAIL_MATL_CODE_MOD
MATERIAL4	The Materials code.			GURMAIL	GURMAIL_MATL_CODE_MOD
MATERIAL5	The Materials code.			GURMAIL	GURMAIL_MATL_CODE_MOD
MATERIAL_DESC1	This field specifies the recruiting material associated with the material code.			FUNCTION	GOKODSF.F_GET_DESC
MATERIAL_DESC2	This field specifies the recruiting material associated with the material code.			FUNCTION	GOKODSF.F_GET_DESC
MATERIAL_DESC3	This field specifies the recruiting material associated with the material code.			FUNCTION	GOKODSF.F_GET_DESC
MATERIAL_DESC4	This field specifies the recruiting material associated with the material code.			FUNCTION	GOKODSF.F_GET_DESC
MATERIAL_DESC5	This field specifies the recruiting material associated with the material code.			FUNCTION	GOKODSF.F_GET_DESC
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.			NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.			NA	NA
NAME	Combination of the person's last, first, and middle initial into one value.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PENDING_LETTER_IND1	Indicates whether the communication material is pending or it has been completed.			CALCULATION	DECODE(GURMAIL_DATE_PRINTED,NULL,'Y','N')
PENDING_LETTER_IND2	Indicates whether the communication material is pending or it has been completed.			CALCULATION	DECODE(GURMAIL_DATE_PRINTED,NULL,'Y','N')
PENDING_LETTER_IND3	Indicates whether the communication material is pending or it has been completed.			CALCULATION	DECODE(GURMAIL_DATE_PRINTED,NULL,'Y','N')
PENDING_LETTER_IND4	Indicates whether the communication material is pending or it has been completed.			CALCULATION	DECODE(GURMAIL_DATE_PRINTED,NULL,'Y','N')
PENDING_LETTER_IND5	Indicates whether the communication material is pending or it has been completed.			CALCULATION	DECODE(GURMAIL_DATE_PRINTED,NULL,'Y','N')
PERSON_UID	System generated, unique, internal identification number assigned to this person.			GURMAIL	GURMAIL_PIDM
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
PROFILE_CODE	This BUSNIESS PROFILE code is stored as MGRSDAX_PROFILE_CODE column and is used to set up display rules specific to an institution office or role. This may be used to define security for the rows of data available to a reporting user, or to select data through a reporting tool selection criteria.			MGRSDAX	MGRSDAX_PROFILE_CODE
SYSTEM1	System indicator associated with the communication material.			GURMAIL	GURMAIL_SYSTEM_IND
SYSTEM2	System indicator associated with the communication material.			GURMAIL	GURMAIL_SYSTEM_IND
SYSTEM3	System indicator associated with the communication material.			GURMAIL	GURMAIL_SYSTEM_IND
SYSTEM4	System indicator associated with the communication material.			GURMAIL	GURMAIL_SYSTEM_IND
SYSTEM5	System indicator associated with the communication material.			GURMAIL	GURMAIL_SYSTEM_IND
SYSTEM_DESC1	System initating communication description.			FUNCTION	GOKODSF.F_GET_DESC
SYSTEM_DESC2	System initating communication description.			FUNCTION	GOKODSF.F_GET_DESC
SYSTEM_DESC3	System initating communication description.			FUNCTION	GOKODSF.F_GET_DESC
SYSTEM_DESC4	System initating communication description.			FUNCTION	GOKODSF.F_GET_DESC
SYSTEM_DESC5	System initating communication description.			FUNCTION	GOKODSF.F_GET_DESC

Ver: 8.3