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

NA

SYSDATE

NO

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

NA

NA

NO

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

GURMAIL

GURMAIL_LETR_CODE

NO

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

GURMAIL

GURMAIL_LETR_CODE

NO

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

GURMAIL

GURMAIL_LETR_CODE

NO

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

GURMAIL

GURMAIL_LETR_CODE

NO

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

GURMAIL

GURMAIL_LETR_CODE

NO

NO
COMMUNICATION_DESC1 Communication description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
COMMUNICATION_DESC2 Communication description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
COMMUNICATION_DESC3 Communication description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
COMMUNICATION_DESC4 Communication description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
COMMUNICATION_DESC5 Communication description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

GURMAIL

GURMAIL_CPLN_CODE

NO

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

GURMAIL

GURMAIL_CPLN_CODE

NO

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

GURMAIL

GURMAIL_CPLN_CODE

NO

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

GURMAIL

GURMAIL_CPLN_CODE

NO

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

GURMAIL

GURMAIL_CPLN_CODE

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
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

NO

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

GURMAIL

GURMAIL_MODULE_CODE

NO

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

GURMAIL

GURMAIL_MODULE_CODE

NO

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

GURMAIL

GURMAIL_MODULE_CODE

NO

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

GURMAIL

GURMAIL_MODULE_CODE

NO

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

GURMAIL

GURMAIL_MODULE_CODE

NO

NO
COMMUNICATION_SOURCE_DESC1 Communication source description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GURMAIL_MODULE_CODE_DESC

NO

NO
COMMUNICATION_SOURCE_DESC2 Communication source description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GURMAIL_MODULE_CODE_DESC

NO

NO
COMMUNICATION_SOURCE_DESC3 Communication source description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GURMAIL_MODULE_CODE_DESC

NO

NO
COMMUNICATION_SOURCE_DESC4 Communication source description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GURMAIL_MODULE_CODE_DESC

NO

NO
COMMUNICATION_SOURCE_DESC5 Communication source description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GURMAIL_MODULE_CODE_DESC

NO

NO
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

NO

NO
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

NO

NO
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

NO

NO
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

NO

NO
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

NO

NO
COMMUNICATION_TYPE_DESC1 Communication type description. VARCHAR2(255)

CALCULATION

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

NO

NO
COMMUNICATION_TYPE_DESC2 Communication type description. VARCHAR2(255)

CALCULATION

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

NO

NO
COMMUNICATION_TYPE_DESC3 Communication type description. VARCHAR2(255)

CALCULATION

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

NO

NO
COMMUNICATION_TYPE_DESC4 Communication type description. VARCHAR2(255)

CALCULATION

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

NO

NO
COMMUNICATION_TYPE_DESC5 Communication type description. VARCHAR2(255)

CALCULATION

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

NO

NO
DATE_INITIATED1 Date the communication or material was initiated or scheduled. DATE

GURMAIL

GURMAIL_DATE_INIT

NO

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

GURMAIL

GURMAIL_DATE_INIT

NO

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

GURMAIL

GURMAIL_DATE_INIT

NO

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

GURMAIL

GURMAIL_DATE_INIT

NO

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

GURMAIL

GURMAIL_DATE_INIT

NO

NO
DATE_PRINTED1 Date the communication or material was completed. DATE

GURMAIL

GURMAIL_DATE_PRINTED

NO

NO
DATE_PRINTED2 Date the communication or material was completed. DATE

GURMAIL

GURMAIL_DATE_PRINTED

NO

NO
DATE_PRINTED3 Date the communication or material was completed. DATE

GURMAIL

GURMAIL_DATE_PRINTED

NO

NO
DATE_PRINTED4 Date the communication or material was completed. DATE

GURMAIL

GURMAIL_DATE_PRINTED

NO

NO
DATE_PRINTED5 Date the communication or material was completed. DATE

GURMAIL

GURMAIL_DATE_PRINTED

NO

NO
DATE_SENT1 Date the communication or material was sent. DATE

CALCULATION

NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED)

NO

NO
DATE_SENT2 Date the communication or material was sent. DATE

CALCULATION

NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED)

NO

NO
DATE_SENT3 Date the communication or material was sent. DATE

CALCULATION

NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED)

NO

NO
DATE_SENT4 Date the communication or material was sent. DATE

CALCULATION

NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED)

NO

NO
DATE_SENT5 Date the communication or material was sent. DATE

CALCULATION

NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED)

NO

NO
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

NO

NO
MATERIAL1 The Materials code. VARCHAR2(63)

GURMAIL

GURMAIL_MATL_CODE_MOD

NO

NO
MATERIAL2 The Materials code. VARCHAR2(63)

GURMAIL

GURMAIL_MATL_CODE_MOD

NO

NO
MATERIAL3 The Materials code. VARCHAR2(63)

GURMAIL

GURMAIL_MATL_CODE_MOD

NO

NO
MATERIAL4 The Materials code. VARCHAR2(63)

GURMAIL

GURMAIL_MATL_CODE_MOD

NO

NO
MATERIAL5 The Materials code. VARCHAR2(63)

GURMAIL

GURMAIL_MATL_CODE_MOD

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

NA

NA

NO

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

NA

NA

NO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
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')

NO

NO
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')

NO

NO
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')

NO

NO
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')

NO

NO
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')

NO

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

GURMAIL

GURMAIL_PIDM

NO

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

NA

NA

NO

NO
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

NO

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

GURMAIL

GURMAIL_SYSTEM_IND

NO

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

GURMAIL

GURMAIL_SYSTEM_IND

NO

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

GURMAIL

GURMAIL_SYSTEM_IND

NO

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

GURMAIL

GURMAIL_SYSTEM_IND

NO

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

GURMAIL

GURMAIL_SYSTEM_IND

NO

NO
SYSTEM_DESC1 System initating communication description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
SYSTEM_DESC2 System initating communication description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
SYSTEM_DESC3 System initating communication description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
SYSTEM_DESC4 System initating communication description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
SYSTEM_DESC5 System initating communication description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO


Ver: 9.2