| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
ACADEMIC_TIME_END_KEY
|
Key of the Academic Time dimension.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
STUDENT COHORT
|
|
ACADEMIC_TIME_KEY
|
Key of the Academic Time dimension.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
STUDENT COHORT
|
|
ACADEMIC_TIME_START_KEY
|
Key of the Academic Time dimension.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
STUDENT COHORT
|
|
COHORT_ACAD_TIME_END_KEY
|
Key of the Academic Time dimension.
|
NUMBER
|
STUDENT_COHORT
|
COHORT_END_ACADEMIC_PERIOD
|
NO
|
NO
|
STUDENT COHORT
|
|
COHORT_ACAD_TIME_START_KEY
|
Key of the Academic Time dimension.
|
NUMBER
|
STUDENT_COHORT
|
COHORT_START_ACADEMIC_PERIOD
|
NO
|
NO
|
STUDENT COHORT
|
|
COHORT_EXPECTED_GRADUATION_HC
|
Headcount of students with an academic period end equal to the report academic period.
|
NUMBER
|
ETL_GENERATED
|
DECODE(MST_STUDENT COHORT.ACADEMIC_PERIOD_END)
|
NO
|
NO
|
STUDENT COHORT
|
|
COHORT_GRADUATION_STATUS
|
Identifies the student cohort graduation status for this person as not expected, expected or past expected to graduate in this academic period. When the report academic period is equal to the student cohort end academic period value, the student cohort graduation status is expected to graduate.
|
VARCHAR2(63)
|
FUNCTION
|
???
|
NO
|
NO
|
STUDENT COHORT
|
|
DEMOGRAPHIC_KEY
|
Key for the demographic dimension.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
STUDENT COHORT
|
|
MULTI_SOURCE_KEY
|
Key for the multi source dimension.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
STUDENT COHORT
|
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
PERSON
|
PERSON_UID
|
NO
|
NO
|
STUDENT COHORT
|
|
STUDENT_COHORT_ACTIVE_IND
|
Identifies the student cohort as active.
|
NUMBER
|
ADMISSIONS_COHORT
|
COHORT_ACTIVE_IND
|
NO
|
NO
|
STUDENT COHORT
|
|
STUDENT_COHORT_COUNT_KEY
|
Student Cohort unique count key.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
STUDENT COHORT
|
|
STUDENT_COHORT_GROUP_KEY
|
Key for the group of student cohort codes for the person.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
STUDENT COHORT
|
|
STUDENT_COHORT_KEY
|
System generated, unique, internal primary key for a cohort.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
STUDENT COHORT
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
STUDENT COHORT
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
STUDENT COHORT
|