Reporting View Target: COMMUNICATION

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Common Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: COMMUNICATION_SLOT

Description Uses data from the COMMUNICATION reporting view. Displays up to 5 sets of values based on the defined display rule(s) with an internal group of MAIL and a delivered or institution defined internal code. Delivered internal codes of RECRLETR (not like 'ALUM%') may be used independently by the institution.
Key & Frequency One row per person per profile code per communication rule.
Recommended Search Columns PERSON_UID, PROFILE_CODE, COMMUNICATION_RULE
ACTIVITY_DATE

Target Column Business Definition Database Data Type Source Name Source Column

ACTIVITY_DATE Date record was inserted or updated DATE
NA

SYSDATE

ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

COMMUNICATION1 Letter, email, web notice or material, etc. communication type associated with this record. VARCHAR2(63)
GURMAIL

GURMAIL_LETR_CODE

COMMUNICATION2 Letter, email, web notice or material, etc. communication type associated with this record. VARCHAR2(63)
GURMAIL

GURMAIL_LETR_CODE

COMMUNICATION3 Letter, email, web notice or material, etc. communication type associated with this record. VARCHAR2(63)
GURMAIL

GURMAIL_LETR_CODE

COMMUNICATION4 Letter, email, web notice or material, etc. communication type associated with this record. VARCHAR2(63)
GURMAIL

GURMAIL_LETR_CODE

COMMUNICATION5 Letter, email, web notice or material, etc. communication type associated with this record. VARCHAR2(63)
GURMAIL

GURMAIL_LETR_CODE

COMMUNICATION_DESC1 Communication description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

COMMUNICATION_DESC2 Communication description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

COMMUNICATION_DESC3 Communication description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

COMMUNICATION_DESC4 Communication description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

COMMUNICATION_DESC5 Communication description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

COMMUNICATION_PLAN1 Communication plan used to add the material or letter. VARCHAR2(63)
GURMAIL

GURMAIL_CPLN_CODE

COMMUNICATION_PLAN2 Communication plan used to add the material or letter. VARCHAR2(63)
GURMAIL

GURMAIL_CPLN_CODE

COMMUNICATION_PLAN3 Communication plan used to add the material or letter. VARCHAR2(63)
GURMAIL

GURMAIL_CPLN_CODE

COMMUNICATION_PLAN4 Communication plan used to add the material or letter. VARCHAR2(63)
GURMAIL

GURMAIL_CPLN_CODE

COMMUNICATION_PLAN5 Communication plan used to add the material or letter. VARCHAR2(63)
GURMAIL

GURMAIL_CPLN_CODE

COMMUNICATION_PLAN_DESC1 Description of communication plan used to add the material or letter. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

COMMUNICATION_PLAN_DESC2 Description of communication plan used to add the material or letter. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

COMMUNICATION_PLAN_DESC3 Description of communication plan used to add the material or letter. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

COMMUNICATION_PLAN_DESC4 Description of communication plan used to add the material or letter. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

COMMUNICATION_PLAN_DESC5 Description of communication plan used to add the material or letter. VARCHAR2(255)
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. VARCHAR2(63)
MGRSDAX

MGRSDAX_INTERNAL_CODE

COMMUNICATION_SOURCE1 Department or office responsible for performing, scheduling and/or sending this communication. VARCHAR2(63)
GURMAIL

GURMAIL_MODULE_CODE

COMMUNICATION_SOURCE2 Department or office responsible for performing, scheduling and/or sending this communication. VARCHAR2(63)
GURMAIL

GURMAIL_MODULE_CODE

COMMUNICATION_SOURCE3 Department or office responsible for performing, scheduling and/or sending this communication. VARCHAR2(63)
GURMAIL

GURMAIL_MODULE_CODE

COMMUNICATION_SOURCE4 Department or office responsible for performing, scheduling and/or sending this communication. VARCHAR2(63)
GURMAIL

GURMAIL_MODULE_CODE

COMMUNICATION_SOURCE5 Department or office responsible for performing, scheduling and/or sending this communication. VARCHAR2(63)
GURMAIL

GURMAIL_MODULE_CODE

COMMUNICATION_SOURCE_DESC1 Communication source description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GURMAIL_MODULE_CODE_DESC

COMMUNICATION_SOURCE_DESC2 Communication source description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GURMAIL_MODULE_CODE_DESC

COMMUNICATION_SOURCE_DESC3 Communication source description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GURMAIL_MODULE_CODE_DESC

COMMUNICATION_SOURCE_DESC4 Communication source description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GURMAIL_MODULE_CODE_DESC

COMMUNICATION_SOURCE_DESC5 Communication source description. VARCHAR2(255)
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. VARCHAR2(63)
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. VARCHAR2(63)
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. VARCHAR2(63)
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. VARCHAR2(63)
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. VARCHAR2(63)
GURMAIL

GURMAIL_PUB_GEN

COMMUNICATION_TYPE_DESC1 Communication type description. VARCHAR2(255)
CALCULATION

DECODE(GURMAIL_PUB_GEN,'P','PRE-PRINTED OR PUBLISHED MATERIAL','G','GENERATED MATERIAL')

COMMUNICATION_TYPE_DESC2 Communication type description. VARCHAR2(255)
CALCULATION

DECODE(GURMAIL_PUB_GEN,'P','PRE-PRINTED OR PUBLISHED MATERIAL','G','GENERATED MATERIAL')

COMMUNICATION_TYPE_DESC3 Communication type description. VARCHAR2(255)
CALCULATION

DECODE(GURMAIL_PUB_GEN,'P','PRE-PRINTED OR PUBLISHED MATERIAL','G','GENERATED MATERIAL')

COMMUNICATION_TYPE_DESC4 Communication type description. VARCHAR2(255)
CALCULATION

DECODE(GURMAIL_PUB_GEN,'P','PRE-PRINTED OR PUBLISHED MATERIAL','G','GENERATED MATERIAL')

COMMUNICATION_TYPE_DESC5 Communication type description. VARCHAR2(255)
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. DATE
GURMAIL

GURMAIL_DATE_INIT

DATE_INITIATED2 Date the communication or material was initiated or scheduled. DATE
GURMAIL

GURMAIL_DATE_INIT

DATE_INITIATED3 Date the communication or material was initiated or scheduled. DATE
GURMAIL

GURMAIL_DATE_INIT

DATE_INITIATED4 Date the communication or material was initiated or scheduled. DATE
GURMAIL

GURMAIL_DATE_INIT

DATE_INITIATED5 Date the communication or material was initiated or scheduled. DATE
GURMAIL

GURMAIL_DATE_INIT

DATE_PRINTED1 Date the communication or material was completed. DATE
GURMAIL

GURMAIL_DATE_PRINTED

DATE_PRINTED2 Date the communication or material was completed. DATE
GURMAIL

GURMAIL_DATE_PRINTED

DATE_PRINTED3 Date the communication or material was completed. DATE
GURMAIL

GURMAIL_DATE_PRINTED

DATE_PRINTED4 Date the communication or material was completed. DATE
GURMAIL

GURMAIL_DATE_PRINTED

DATE_PRINTED5 Date the communication or material was completed. DATE
GURMAIL

GURMAIL_DATE_PRINTED

DATE_SENT1 Date the communication or material was sent. DATE
CALCULATION

NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED)

DATE_SENT2 Date the communication or material was sent. DATE
CALCULATION

NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED)

DATE_SENT3 Date the communication or material was sent. DATE
CALCULATION

NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED)

DATE_SENT4 Date the communication or material was sent. DATE
CALCULATION

NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED)

DATE_SENT5 Date the communication or material was sent. DATE
CALCULATION

NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED)

ID Person's identification number used to access the records associated with the person. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

MATERIAL1 The Materials code. VARCHAR2(63)
GURMAIL

GURMAIL_MATL_CODE_MOD

MATERIAL2 The Materials code. VARCHAR2(63)
GURMAIL

GURMAIL_MATL_CODE_MOD

MATERIAL3 The Materials code. VARCHAR2(63)
GURMAIL

GURMAIL_MATL_CODE_MOD

MATERIAL4 The Materials code. VARCHAR2(63)
GURMAIL

GURMAIL_MATL_CODE_MOD

MATERIAL5 The Materials code. VARCHAR2(63)
GURMAIL

GURMAIL_MATL_CODE_MOD

MATERIAL_DESC1 This field specifies the recruiting material associated with the material code. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

MATERIAL_DESC2 This field specifies the recruiting material associated with the material code. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

MATERIAL_DESC3 This field specifies the recruiting material associated with the material code. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

MATERIAL_DESC4 This field specifies the recruiting material associated with the material code. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

MATERIAL_DESC5 This field specifies the recruiting material associated with the material code. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)
NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

NAME Combination of the person's last, first, and middle initial into one value. VARCHAR2(255)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PENDING_LETTER_IND1 Indicates whether the communication material is pending or it has been completed. VARCHAR2(1)
CALCULATION

DECODE(GURMAIL_DATE_PRINTED,NULL,'Y','N')

PENDING_LETTER_IND2 Indicates whether the communication material is pending or it has been completed. VARCHAR2(1)
CALCULATION

DECODE(GURMAIL_DATE_PRINTED,NULL,'Y','N')

PENDING_LETTER_IND3 Indicates whether the communication material is pending or it has been completed. VARCHAR2(1)
CALCULATION

DECODE(GURMAIL_DATE_PRINTED,NULL,'Y','N')

PENDING_LETTER_IND4 Indicates whether the communication material is pending or it has been completed. VARCHAR2(1)
CALCULATION

DECODE(GURMAIL_DATE_PRINTED,NULL,'Y','N')

PENDING_LETTER_IND5 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
GURMAIL

GURMAIL_PIDM

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
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. VARCHAR2(63)
MGRSDAX

MGRSDAX_PROFILE_CODE

SYSTEM1 System indicator associated with the communication material. VARCHAR2(63)
GURMAIL

GURMAIL_SYSTEM_IND

SYSTEM2 System indicator associated with the communication material. VARCHAR2(63)
GURMAIL

GURMAIL_SYSTEM_IND

SYSTEM3 System indicator associated with the communication material. VARCHAR2(63)
GURMAIL

GURMAIL_SYSTEM_IND

SYSTEM4 System indicator associated with the communication material. VARCHAR2(63)
GURMAIL

GURMAIL_SYSTEM_IND

SYSTEM5 System indicator associated with the communication material. VARCHAR2(63)
GURMAIL

GURMAIL_SYSTEM_IND

SYSTEM_DESC1 System initating communication description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

SYSTEM_DESC2 System initating communication description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

SYSTEM_DESC3 System initating communication description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

SYSTEM_DESC4 System initating communication description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

SYSTEM_DESC5 System initating communication description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

Ver: 8.1

Description	Uses data from the COMMUNICATION reporting view. Displays up to 5 sets of values based on the defined display rule(s) with an internal group of MAIL and a delivered or institution defined internal code. Delivered internal codes of RECRLETR (not like 'ALUM%') may be used independently by the institution.
Key & Frequency	One row per person per profile code per communication rule.
Recommended Search Columns	PERSON_UID, PROFILE_CODE, COMMUNICATION_RULE ACTIVITY_DATE

Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACTIVITY_DATE	Date record was inserted or updated	DATE	NA	SYSDATE
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
COMMUNICATION1	Letter, email, web notice or material, etc. communication type associated with this record.	VARCHAR2(63)	GURMAIL	GURMAIL_LETR_CODE
COMMUNICATION2	Letter, email, web notice or material, etc. communication type associated with this record.	VARCHAR2(63)	GURMAIL	GURMAIL_LETR_CODE
COMMUNICATION3	Letter, email, web notice or material, etc. communication type associated with this record.	VARCHAR2(63)	GURMAIL	GURMAIL_LETR_CODE
COMMUNICATION4	Letter, email, web notice or material, etc. communication type associated with this record.	VARCHAR2(63)	GURMAIL	GURMAIL_LETR_CODE
COMMUNICATION5	Letter, email, web notice or material, etc. communication type associated with this record.	VARCHAR2(63)	GURMAIL	GURMAIL_LETR_CODE
COMMUNICATION_DESC1	Communication description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
COMMUNICATION_DESC2	Communication description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
COMMUNICATION_DESC3	Communication description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
COMMUNICATION_DESC4	Communication description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
COMMUNICATION_DESC5	Communication description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
COMMUNICATION_PLAN1	Communication plan used to add the material or letter.	VARCHAR2(63)	GURMAIL	GURMAIL_CPLN_CODE
COMMUNICATION_PLAN2	Communication plan used to add the material or letter.	VARCHAR2(63)	GURMAIL	GURMAIL_CPLN_CODE
COMMUNICATION_PLAN3	Communication plan used to add the material or letter.	VARCHAR2(63)	GURMAIL	GURMAIL_CPLN_CODE
COMMUNICATION_PLAN4	Communication plan used to add the material or letter.	VARCHAR2(63)	GURMAIL	GURMAIL_CPLN_CODE
COMMUNICATION_PLAN5	Communication plan used to add the material or letter.	VARCHAR2(63)	GURMAIL	GURMAIL_CPLN_CODE
COMMUNICATION_PLAN_DESC1	Description of communication plan used to add the material or letter.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
COMMUNICATION_PLAN_DESC2	Description of communication plan used to add the material or letter.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
COMMUNICATION_PLAN_DESC3	Description of communication plan used to add the material or letter.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
COMMUNICATION_PLAN_DESC4	Description of communication plan used to add the material or letter.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
COMMUNICATION_PLAN_DESC5	Description of communication plan used to add the material or letter.	VARCHAR2(255)	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.	VARCHAR2(63)	MGRSDAX	MGRSDAX_INTERNAL_CODE
COMMUNICATION_SOURCE1	Department or office responsible for performing, scheduling and/or sending this communication.	VARCHAR2(63)	GURMAIL	GURMAIL_MODULE_CODE
COMMUNICATION_SOURCE2	Department or office responsible for performing, scheduling and/or sending this communication.	VARCHAR2(63)	GURMAIL	GURMAIL_MODULE_CODE
COMMUNICATION_SOURCE3	Department or office responsible for performing, scheduling and/or sending this communication.	VARCHAR2(63)	GURMAIL	GURMAIL_MODULE_CODE
COMMUNICATION_SOURCE4	Department or office responsible for performing, scheduling and/or sending this communication.	VARCHAR2(63)	GURMAIL	GURMAIL_MODULE_CODE
COMMUNICATION_SOURCE5	Department or office responsible for performing, scheduling and/or sending this communication.	VARCHAR2(63)	GURMAIL	GURMAIL_MODULE_CODE
COMMUNICATION_SOURCE_DESC1	Communication source description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GURMAIL_MODULE_CODE_DESC
COMMUNICATION_SOURCE_DESC2	Communication source description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GURMAIL_MODULE_CODE_DESC
COMMUNICATION_SOURCE_DESC3	Communication source description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GURMAIL_MODULE_CODE_DESC
COMMUNICATION_SOURCE_DESC4	Communication source description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GURMAIL_MODULE_CODE_DESC
COMMUNICATION_SOURCE_DESC5	Communication source description.	VARCHAR2(255)	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.	VARCHAR2(63)	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.	VARCHAR2(63)	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.	VARCHAR2(63)	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.	VARCHAR2(63)	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.	VARCHAR2(63)	GURMAIL	GURMAIL_PUB_GEN
COMMUNICATION_TYPE_DESC1	Communication type description.	VARCHAR2(255)	CALCULATION	DECODE(GURMAIL_PUB_GEN,'P','PRE-PRINTED OR PUBLISHED MATERIAL','G','GENERATED MATERIAL')
COMMUNICATION_TYPE_DESC2	Communication type description.	VARCHAR2(255)	CALCULATION	DECODE(GURMAIL_PUB_GEN,'P','PRE-PRINTED OR PUBLISHED MATERIAL','G','GENERATED MATERIAL')
COMMUNICATION_TYPE_DESC3	Communication type description.	VARCHAR2(255)	CALCULATION	DECODE(GURMAIL_PUB_GEN,'P','PRE-PRINTED OR PUBLISHED MATERIAL','G','GENERATED MATERIAL')
COMMUNICATION_TYPE_DESC4	Communication type description.	VARCHAR2(255)	CALCULATION	DECODE(GURMAIL_PUB_GEN,'P','PRE-PRINTED OR PUBLISHED MATERIAL','G','GENERATED MATERIAL')
COMMUNICATION_TYPE_DESC5	Communication type description.	VARCHAR2(255)	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.	DATE	GURMAIL	GURMAIL_DATE_INIT
DATE_INITIATED2	Date the communication or material was initiated or scheduled.	DATE	GURMAIL	GURMAIL_DATE_INIT
DATE_INITIATED3	Date the communication or material was initiated or scheduled.	DATE	GURMAIL	GURMAIL_DATE_INIT
DATE_INITIATED4	Date the communication or material was initiated or scheduled.	DATE	GURMAIL	GURMAIL_DATE_INIT
DATE_INITIATED5	Date the communication or material was initiated or scheduled.	DATE	GURMAIL	GURMAIL_DATE_INIT
DATE_PRINTED1	Date the communication or material was completed.	DATE	GURMAIL	GURMAIL_DATE_PRINTED
DATE_PRINTED2	Date the communication or material was completed.	DATE	GURMAIL	GURMAIL_DATE_PRINTED
DATE_PRINTED3	Date the communication or material was completed.	DATE	GURMAIL	GURMAIL_DATE_PRINTED
DATE_PRINTED4	Date the communication or material was completed.	DATE	GURMAIL	GURMAIL_DATE_PRINTED
DATE_PRINTED5	Date the communication or material was completed.	DATE	GURMAIL	GURMAIL_DATE_PRINTED
DATE_SENT1	Date the communication or material was sent.	DATE	CALCULATION	NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED)
DATE_SENT2	Date the communication or material was sent.	DATE	CALCULATION	NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED)
DATE_SENT3	Date the communication or material was sent.	DATE	CALCULATION	NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED)
DATE_SENT4	Date the communication or material was sent.	DATE	CALCULATION	NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED)
DATE_SENT5	Date the communication or material was sent.	DATE	CALCULATION	NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED)
ID	Person's identification number used to access the records associated with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
MATERIAL1	The Materials code.	VARCHAR2(63)	GURMAIL	GURMAIL_MATL_CODE_MOD
MATERIAL2	The Materials code.	VARCHAR2(63)	GURMAIL	GURMAIL_MATL_CODE_MOD
MATERIAL3	The Materials code.	VARCHAR2(63)	GURMAIL	GURMAIL_MATL_CODE_MOD
MATERIAL4	The Materials code.	VARCHAR2(63)	GURMAIL	GURMAIL_MATL_CODE_MOD
MATERIAL5	The Materials code.	VARCHAR2(63)	GURMAIL	GURMAIL_MATL_CODE_MOD
MATERIAL_DESC1	This field specifies the recruiting material associated with the material code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
MATERIAL_DESC2	This field specifies the recruiting material associated with the material code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
MATERIAL_DESC3	This field specifies the recruiting material associated with the material code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
MATERIAL_DESC4	This field specifies the recruiting material associated with the material code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
MATERIAL_DESC5	This field specifies the recruiting material associated with the material code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Combination of the person's last, first, and middle initial into one value.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PENDING_LETTER_IND1	Indicates whether the communication material is pending or it has been completed.	VARCHAR2(1)	CALCULATION	DECODE(GURMAIL_DATE_PRINTED,NULL,'Y','N')
PENDING_LETTER_IND2	Indicates whether the communication material is pending or it has been completed.	VARCHAR2(1)	CALCULATION	DECODE(GURMAIL_DATE_PRINTED,NULL,'Y','N')
PENDING_LETTER_IND3	Indicates whether the communication material is pending or it has been completed.	VARCHAR2(1)	CALCULATION	DECODE(GURMAIL_DATE_PRINTED,NULL,'Y','N')
PENDING_LETTER_IND4	Indicates whether the communication material is pending or it has been completed.	VARCHAR2(1)	CALCULATION	DECODE(GURMAIL_DATE_PRINTED,NULL,'Y','N')
PENDING_LETTER_IND5	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	GURMAIL	GURMAIL_PIDM
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	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.	VARCHAR2(63)	MGRSDAX	MGRSDAX_PROFILE_CODE
SYSTEM1	System indicator associated with the communication material.	VARCHAR2(63)	GURMAIL	GURMAIL_SYSTEM_IND
SYSTEM2	System indicator associated with the communication material.	VARCHAR2(63)	GURMAIL	GURMAIL_SYSTEM_IND
SYSTEM3	System indicator associated with the communication material.	VARCHAR2(63)	GURMAIL	GURMAIL_SYSTEM_IND
SYSTEM4	System indicator associated with the communication material.	VARCHAR2(63)	GURMAIL	GURMAIL_SYSTEM_IND
SYSTEM5	System indicator associated with the communication material.	VARCHAR2(63)	GURMAIL	GURMAIL_SYSTEM_IND
SYSTEM_DESC1	System initating communication description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
SYSTEM_DESC2	System initating communication description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
SYSTEM_DESC3	System initating communication description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
SYSTEM_DESC4	System initating communication description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
SYSTEM_DESC5	System initating communication description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC