Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Common Reporting View Reports

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 Name Business Definition Database Data Type Source Name Source Column
ACTIVITY_DATE Activity Date Date record was inserted or updated. DATE

NA

SYSDATE

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

NA

NA

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

GURMAIL

GURMAIL_LETR_CODE

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

GURMAIL

GURMAIL_LETR_CODE

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

GURMAIL

GURMAIL_LETR_CODE

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

GURMAIL

GURMAIL_LETR_CODE

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

GURMAIL

GURMAIL_LETR_CODE

COMMUNICATION_DESC1 Communication Description 1 Communication description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

COMMUNICATION_DESC2 Communication Description 2 Communication description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

COMMUNICATION_DESC3 Communication Description 3 Communication description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

COMMUNICATION_DESC4 Communication Description 4 Communication description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

COMMUNICATION_DESC5 Communication Description 5 Communication description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

GURMAIL

GURMAIL_CPLN_CODE

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

GURMAIL

GURMAIL_CPLN_CODE

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

GURMAIL

GURMAIL_CPLN_CODE

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

GURMAIL

GURMAIL_CPLN_CODE

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

GURMAIL

GURMAIL_CPLN_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

COMMUNICATION_PLAN_DESC5 Communication Plan Description 5 Description of communication plan used to add the material or letter. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

COMMUNICATION_RULE 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 Communication Source 1 Department or office responsible for performing, scheduling and/or sending this communication. VARCHAR2(63)

GURMAIL

GURMAIL_MODULE_CODE

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

GURMAIL

GURMAIL_MODULE_CODE

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

GURMAIL

GURMAIL_MODULE_CODE

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

GURMAIL

GURMAIL_MODULE_CODE

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

GURMAIL

GURMAIL_MODULE_CODE

COMMUNICATION_SOURCE_DESC1 Communication Source Description 1 Communication source description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GURMAIL_MODULE_CODE_DESC

COMMUNICATION_SOURCE_DESC2 Communication Source Description 2 Communication source description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GURMAIL_MODULE_CODE_DESC

COMMUNICATION_SOURCE_DESC3 Communication Source Description 3 Communication source description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GURMAIL_MODULE_CODE_DESC

COMMUNICATION_SOURCE_DESC4 Communication Source Description 4 Communication source description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GURMAIL_MODULE_CODE_DESC

COMMUNICATION_SOURCE_DESC5 Communication Source Description 5 Communication source description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GURMAIL_MODULE_CODE_DESC

COMMUNICATION_TYPE1 Communication Type 1 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 Communication Type 2 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 Communication Type 3 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 Communication Type 4 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 Communication Type 5 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 1 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 2 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 3 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 4 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 5 Communication type description. VARCHAR2(255)

CALCULATION

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

DATE_INITIATED1 Date Initiated 1 Date the communication or material was initiated or scheduled. DATE

GURMAIL

GURMAIL_DATE_INIT

DATE_INITIATED2 Date Initiated 2 Date the communication or material was initiated or scheduled. DATE

GURMAIL

GURMAIL_DATE_INIT

DATE_INITIATED3 Date Initiated 3 Date the communication or material was initiated or scheduled. DATE

GURMAIL

GURMAIL_DATE_INIT

DATE_INITIATED4 Date Initiated 4 Date the communication or material was initiated or scheduled. DATE

GURMAIL

GURMAIL_DATE_INIT

DATE_INITIATED5 Date Initiated 5 Date the communication or material was initiated or scheduled. DATE

GURMAIL

GURMAIL_DATE_INIT

DATE_PRINTED1 Date Printed 1 Date the communication or material was completed. DATE

GURMAIL

GURMAIL_DATE_PRINTED

DATE_PRINTED2 Date Printed 2 Date the communication or material was completed. DATE

GURMAIL

GURMAIL_DATE_PRINTED

DATE_PRINTED3 Date Printed 3 Date the communication or material was completed. DATE

GURMAIL

GURMAIL_DATE_PRINTED

DATE_PRINTED4 Date Printed 4 Date the communication or material was completed. DATE

GURMAIL

GURMAIL_DATE_PRINTED

DATE_PRINTED5 Date Printed 5 Date the communication or material was completed. DATE

GURMAIL

GURMAIL_DATE_PRINTED

DATE_SENT1 Date Sent 1 Date the communication or material was sent. DATE

CALCULATION

NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED)

DATE_SENT2 Date Sent 2 Date the communication or material was sent. DATE

CALCULATION

NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED)

DATE_SENT3 Date Sent 3 Date the communication or material was sent. DATE

CALCULATION

NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED)

DATE_SENT4 Date Sent 4 Date the communication or material was sent. DATE

CALCULATION

NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED)

DATE_SENT5 Date Sent 5 Date the communication or material was sent. DATE

CALCULATION

NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED)

ID ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

MATERIAL1 Material 1 The Materials code. VARCHAR2(63)

GURMAIL

GURMAIL_MATL_CODE_MOD

MATERIAL2 Material 2 The Materials code. VARCHAR2(63)

GURMAIL

GURMAIL_MATL_CODE_MOD

MATERIAL3 Material 3 The Materials code. VARCHAR2(63)

GURMAIL

GURMAIL_MATL_CODE_MOD

MATERIAL4 Material 4 The Materials code. VARCHAR2(63)

GURMAIL

GURMAIL_MATL_CODE_MOD

MATERIAL5 Material 5 The Materials code. VARCHAR2(63)

GURMAIL

GURMAIL_MATL_CODE_MOD

MATERIAL_DESC1 Material Description 1 This field specifies the recruiting material associated with the material code. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

MATERIAL_DESC2 Material Description 2 This field specifies the recruiting material associated with the material code. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

MATERIAL_DESC3 Material Description 3 This field specifies the recruiting material associated with the material code. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

MATERIAL_DESC4 Material Description 4 This field specifies the recruiting material associated with the material code. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

MATERIAL_DESC5 Material Description 5 This field specifies the recruiting material associated with the material code. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

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

NA

NA

NAME 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 Pending Letter Indicator 1 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 Pending Letter Indicator 2 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 Pending Letter Indicator 3 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 Pending Letter Indicator 4 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 Pending Letter Indicator 5 Indicates whether the communication material is pending or it has been completed. VARCHAR2(1)

CALCULATION

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

PERSON_UID Person UID System generated, unique, internal identification number assigned to this person. NUMBER

GURMAIL

GURMAIL_PIDM

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

PROFILE_CODE 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 1 System indicator associated with the communication material. VARCHAR2(63)

GURMAIL

GURMAIL_SYSTEM_IND

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

GURMAIL

GURMAIL_SYSTEM_IND

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

GURMAIL

GURMAIL_SYSTEM_IND

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

GURMAIL

GURMAIL_SYSTEM_IND

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

GURMAIL

GURMAIL_SYSTEM_IND

SYSTEM_DESC1 System Description 1 System initating communication description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SYSTEM_DESC2 System Description 2 System initating communication description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SYSTEM_DESC3 System Description 3 System initating communication description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SYSTEM_DESC4 System Description 4 System initating communication description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SYSTEM_DESC5 System Description 5 System initating communication description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC



Ver: 9.2