Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACADEMIC_TIME_KEY	Key for the academic time dimension.	NUMBER	ETL GENERATED	NA	NO	NO	BANNER COMMUNICATION
BANNER_COMMUNICATION_COUNT_KEY	Unique key for the count of Banner communications by academic period, Person UID, Communication or Material and communication initiate date.	NUMBER	ETL GENERATED	NA	NO	NO	BANNER COMMUNICATION
BANNER_COMMUNICATION_GROUP_KEY	Key for the Banner communication group for this person.	NUMBER	ETL GENERATED	NA	NO	NO	BANNER COMMUNICATION
BANNER_COMMUNICATION_KEY	Key for the Banner communication dimension.	NUMBER	ETL GENERATED	NA	NO	NO	BANNER COMMUNICATION
COMMUNICATION_INIT_DATE	Date the communication or material was scheduled to be sent to the person.	DATE	COMMUNICATION	DATE_INITIATED	NO	NO	BANNER COMMUNICATION
COMMUNICATION_PRINT_DATE	Date the communication or material was printed.	DATE	COMMUNICATION	DATE_PRINTED	NO	NO	BANNER COMMUNICATION
COMMUNICATION_SENT_DATE	Date the communication or material was sent to the person.	DATE	COMMUNICATION	DATE_SENT	NO	NO	BANNER COMMUNICATION
DEMOGRAPHIC_KEY	Key for the demographic dimension.	NUMBER	ETL GENERATED	NA	NO	NO	BANNER COMMUNICATION
FINANCIAL_AID_YEAR_KEY	Key to the financial aid year dimension table.	NUMBER	ETL GENERATED	NA	NO	NO	BANNER COMMUNICATION
FIRST_COMMUNICATION_IND	Identifies this is the first communication from the institution to the person.	NUMBER	CALCULATION	DECODE(ROW_NUMBER() OVER (PARTITION BY A.PERSON_UID ORDER BY DATE_INITIATED ASC),1,1,0)	NO	NO	BANNER COMMUNICATION
LATEST_COMMUNICATION_IND	Identifies this as the last or latest communication from the institution to the person.	NUMBER	CALCULATION	DECODE(ROW_NUMBER() OVER (PARTITION BY PERSON_UID ORDER BY A.DATE_INITIATED DESC),1,1,0) DEL BASELINE MAPPING	NO	NO
MULTI_SOURCE_KEY	Key for the multi source dimension.	NUMBER	ETL GENERATED	NA	NO	NO	BANNER COMMUNICATION
PENDING_LETTER_IND	Identifies whether or not the communication is still pending or has been sent.	NUMBER	CALCULATION	DECODE(PENDING_LETTER_IND,'Y',1,0)	NO	NO	BANNER COMMUNICATION
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	COMMUNICATION	PERSON_UID	NO	NO	BANNER COMMUNICATION
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
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	BANNER COMMUNICATION

Ver: 9.0