| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
CALENDAR_DATE
|
Date - for example 22-JUL-2007.
|
DATE
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION DECISION, APPLICATION REQUIREMENT, CONTACT, HOLD, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, STUDENT, TEST
|
|
CALENDAR_DAY
|
Day number of a month - for example 01, 02 through 31.
|
VARCHAR2(63)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION DECISION, APPLICATION REQUIREMENT, CONTACT, HOLD, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, STUDENT, TEST
|
|
CALENDAR_DAY_OF_WEEK
|
Day of the week - for example Monday, Tuesday, etc.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION DECISION, APPLICATION REQUIREMENT, CONTACT, HOLD, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, STUDENT, TEST
|
|
CALENDAR_MONTH
|
Month - for example 01, 02 .. 12.
|
VARCHAR2(63)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION DECISION, APPLICATION REQUIREMENT, CONTACT, HOLD, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, STUDENT, TEST
|
|
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
|
NA
|
NO
|
NO
|
ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION DECISION, APPLICATION REQUIREMENT, CONTACT, HOLD, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, STUDENT, TEST
|
|
CALENDAR_MONTH_LD
|
Long description for the calendar month - for example January.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION DECISION, APPLICATION REQUIREMENT, CONTACT, HOLD, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, STUDENT, TEST
|
|
CALENDAR_MONTH_SD
|
Short description for the calendar month - for example Jan.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION DECISION, APPLICATION REQUIREMENT, CONTACT, HOLD, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, STUDENT, TEST
|
|
CALENDAR_QUARTER
|
Quarter - for example 1,2,3,4.
|
VARCHAR2(63)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION DECISION, APPLICATION REQUIREMENT, CONTACT, HOLD, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, STUDENT, TEST
|
|
CALENDAR_WEEK_OF_YEAR
|
Week number of a year - for example 01, 02 through 52.
|
VARCHAR2(63)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION DECISION, APPLICATION REQUIREMENT, CONTACT, HOLD, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, STUDENT, TEST
|
|
CALENDAR_YEAR
|
Year - for example 2007.
|
VARCHAR2(63)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION DECISION, APPLICATION REQUIREMENT, CONTACT, HOLD, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, STUDENT, TEST
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION DECISION, APPLICATION REQUIREMENT, CONTACT, HOLD, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, STUDENT, TEST
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION DECISION, APPLICATION REQUIREMENT, CONTACT, HOLD, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, STUDENT, TEST
|