RETURN TO REPORTING VIEW REPORTS LIST
Common Reporting View Reports

SGHE 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(94)

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: 3.1