Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
CALENDAR_DATE	Date - for example 20-JUL-2007	DATE	ETL GENERATED FINAID_APPLICANT_STATUS	NA PACKAGE_COMPLETE_DATE	NO NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION DECISION, APPLICATION REQUIREMENT, CONTACT, HOLD, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, TEST  FINANCIAL AID APPLICATION
CALENDAR_DAY	Day number of a month - for example 01, 02 , 31	VARCHAR2(63)	ETL GENERATED ETL_GENERATED	NA NA	NO NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION DECISION, APPLICATION REQUIREMENT, CONTACT, HOLD, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, TEST  FINANCIAL AID APPLICATION
CALENDAR_DAY_OF_WEEK	Day of the week - for example Monday, Tuesday, etc.	VARCHAR2(255)	ETL GENERATED ETL_GENERATED	NA NA	NO NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION DECISION, APPLICATION REQUIREMENT, CONTACT, HOLD, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, TEST  FINANCIAL AID APPLICATION
CALENDAR_MONTH	Month - for example 01, 02 .. 12	VARCHAR2(63)	ETL GENERATED ETL_GENERATED	NA NA	NO NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION DECISION, APPLICATION REQUIREMENT, CONTACT, HOLD, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, TEST  FINANCIAL AID APPLICATION
CALENDAR_MONTH_DATE	Calendar month - for example Jan joined with the day 1 in year 1990. Column is used so that the calendar month will sort in the correct order.	DATE	ETL GENERATED ETL_GENERATED	NA NA	NO NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION DECISION, APPLICATION REQUIREMENT, CONTACT, HOLD, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, TEST  FINANCIAL AID APPLICATION
CALENDAR_MONTH_LD	Long description for the calendar month - for example January	VARCHAR2(255)	ETL GENERATED ETL_GENERATED	NA NA	NO NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION DECISION, APPLICATION REQUIREMENT, CONTACT, HOLD, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, TEST  FINANCIAL AID APPLICATION
CALENDAR_MONTH_SD	Short description for the calendar month - for example Jan	VARCHAR2(255)	ETL GENERATED ETL_GENERATED	NA NA	NO NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION DECISION, APPLICATION REQUIREMENT, CONTACT, HOLD, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, TEST  FINANCIAL AID APPLICATION
CALENDAR_QUARTER	Quarter - for example 1,2,3,4.	VARCHAR2(63)	ETL GENERATED ETL_GENERATED	NA NA	NO NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION DECISION, APPLICATION REQUIREMENT, CONTACT, HOLD, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, TEST  FINANCIAL AID APPLICATION
CALENDAR_WEEK_OF_YEAR	Week number of a year - for example 01, 02 , 52	VARCHAR2(63)	ETL GENERATED ETL_GENERATED	NA NA	NO NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION DECISION, APPLICATION REQUIREMENT, CONTACT, HOLD, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, TEST  FINANCIAL AID APPLICATION
CALENDAR_YEAR	Year - for example 2007.	VARCHAR2(63)	ETL GENERATED ETL_GENERATED	NA NA	NO NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION DECISION, APPLICATION REQUIREMENT, CONTACT, HOLD, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, TEST  FINANCIAL AID APPLICATION
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED ETL_GENERATED	NA NA	NO NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION DECISION, APPLICATION REQUIREMENT, CONTACT, HOLD, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, TEST  FINANCIAL AID APPLICATION
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED ETL_GENERATED	NA NA	NO NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION DECISION, APPLICATION REQUIREMENT, CONTACT, HOLD, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, TEST  FINANCIAL AID APPLICATION

Ver: 8.1