| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
BANNER_COMMUNICATION_KEY
|
Key to the Banner communication dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
BANNER COMMUNICATION, STUDENT PROGRESS
|
|
COMMUNICATION
|
Letter, email, web notice or material, etc. communication type associated with this record.
|
VARCHAR2(255)
|
COMMUNICATION
|
COMMUNICATION
|
NO
|
NO
|
BANNER COMMUNICATION, STUDENT PROGRESS
|
|
COMMUNICATION_LD
|
Long description for a particular communication.
|
VARCHAR2(255)
|
COMMUNICATION
|
COMMUNICATION_DESC
|
NO
|
NO
|
BANNER COMMUNICATION, STUDENT PROGRESS
|
|
COMMUNICATION_PLAN
|
Communication plan used to add the communication material or letter.
|
VARCHAR2(255)
|
COMMUNICATION
|
COMMUNICATION_PLAN
|
NO
|
NO
|
BANNER COMMUNICATION, STUDENT PROGRESS
|
|
COMMUNICATION_PLAN_LD
|
Long description for the communication plan used to add a specific communication.
|
VARCHAR2(255)
|
COMMUNICATION
|
COMMUNICATION_PLAN_DESC
|
NO
|
NO
|
BANNER COMMUNICATION, STUDENT PROGRESS
|
|
COMMUNICATION_PLAN_SD
|
Short description for the communication plan used to add a specific communication.
|
VARCHAR2(255)
|
COMMUNICATION
|
COMMUNICATION_PLAN_DESC
|
NO
|
NO
|
BANNER COMMUNICATION, STUDENT PROGRESS
|
|
COMMUNICATION_SD
|
Short description for a particular communication.
|
VARCHAR2(255)
|
COMMUNICATION
|
COMMUNICATION_DESC
|
NO
|
NO
|
BANNER COMMUNICATION, STUDENT PROGRESS
|
|
COMMUNICATION_SOURCE
|
Department or office responsible for performing, scheduling and/or sending this communication.
|
VARCHAR2(255)
|
COMMUNICATION
|
COMMUNICATION_SOURCE
|
NO
|
NO
|
BANNER COMMUNICATION, STUDENT PROGRESS
|
|
COMMUNICATION_SOURCE_LD
|
Long description of the department or office responsible for this communication.
|
VARCHAR2(255)
|
COMMUNICATION
|
COMMUNICATION_SOURCE_DESC
|
NO
|
NO
|
BANNER COMMUNICATION, STUDENT PROGRESS
|
|
COMMUNICATION_SOURCE_SD
|
Short description of the department or office responsible for this communication.
|
VARCHAR2(255)
|
COMMUNICATION
|
COMMUNICATION_SOURCE_DESC
|
NO
|
NO
|
BANNER COMMUNICATION, STUDENT PROGRESS
|
|
COMMUNICATION_TYPE
|
Type of communication represented in this record. It may be a pre-printed, published material or a generated material or action, etc.
|
VARCHAR2(255)
|
COMMUNICATION
|
COMMUNICATION_TYPE
|
NO
|
NO
|
BANNER COMMUNICATION, STUDENT PROGRESS
|
|
COMMUNICATION_TYPE_LD
|
Long description for the type of communication represented by this record.
|
VARCHAR2(255)
|
COMMUNICATION
|
COMMUNICATION_TYPE_DESC
|
NO
|
NO
|
BANNER COMMUNICATION, STUDENT PROGRESS
|
|
COMMUNICATION_TYPE_SD
|
Short description for the type of communication represented by this record.
|
VARCHAR2(255)
|
COMMUNICATION
|
COMMUNICATION_TYPE_DESC
|
NO
|
NO
|
BANNER COMMUNICATION, STUDENT PROGRESS
|
|
MATERIAL
|
Material code (if any) associated with the communication material.
|
VARCHAR2(255)
|
COMMUNICATION
|
MATERIAL
|
NO
|
NO
|
BANNER COMMUNICATION, STUDENT PROGRESS
|
|
MATERIAL_LD
|
Long description for the material associated with the communication.
|
VARCHAR2(255)
|
COMMUNICATION
|
MATERIAL_DESC
|
NO
|
NO
|
BANNER COMMUNICATION, STUDENT PROGRESS
|
|
MATERIAL_SD
|
Short description for the material associated with the communication.
|
VARCHAR2(255)
|
COMMUNICATION
|
MATERIAL_DESC
|
NO
|
NO
|
BANNER COMMUNICATION, STUDENT PROGRESS
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
BANNER COMMUNICATION, STUDENT PROGRESS
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL GENERATED
|
NA
|
NO
|
NO
|
BANNER COMMUNICATION, STUDENT PROGRESS
|