| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
ATTENDED_FROM_MONTH
|
Attended From Month.
|
NUMBER
|
|
|
|
NO
|
|
|
ATTENDED_FROM_YEAR
|
Attended From Year.
|
NUMBER
|
|
|
|
NO
|
|
|
ATTENDED_TO_MONTH
|
Attended To Month.
|
NUMBER
|
|
|
|
NO
|
|
|
ATTENDED_TO_YEAR
|
Attended To Year.
|
NUMBER
|
|
|
|
NO
|
|
|
DEMOGRAPHIC_KEY
|
Key for the demographic dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
PROSPECTIVE STUDENT
|
|
GEOGRAPHIC_REGION_KEY
|
Key for the geographic region dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
PROSPECTIVE STUDENT
|
|
INSTITUTION_GROUP_KEY
|
Institution Group KEY.
|
NUMBER
|
|
|
|
NO
|
|
|
INSTITUTION_KEY
|
Key for the institution dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
PROSPECTIVE STUDENT
|
|
MULTI_SOURCE_KEY
|
Key for the multi source dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
PROSPECTIVE STUDENT
|
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
PERSON_UID PERSON_UID
|
NO NO
|
NO
|
PROSPECTIVE STUDENT PROSPECTIVE STUDENT
|
|
POSTAL_KEY
|
Key for the postal dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
PROSPECTIVE STUDENT
|
|
PROSPECTIVE_STUDENT_GROUP_KEY
|
Prospective Student Group KEY.
|
NUMBER
|
|
|
|
NO
|
|
|
RACE_GROUP_KEY
|
Key for the set of race dimension keys.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
PROSPECTIVE STUDENT
|
|
SECONDARY_SCHOOL_GPA
|
Person's secondary institution average or GPA.
|
NUMBER
|
PREVIOUS_EDUCATION
|
SCHOOL_GPA
|
NO
|
NO
|
PROSPECTIVE STUDENT
|
|
SECONDARY_SCHOOL_GRAD_DATE
|
Date the person graduated.
|
DATE
|
PREVIOUS_EDUCATION
|
SECONDARY_SCHOOL_GRAD_DATE
|
NO
|
NO
|
PROSPECTIVE STUDENT
|
|
SECONDARY_SCHOOL_GRAD_IND
|
Secondary School Grad Ind.
|
NUMBER
|
|
|
|
NO
|
|
|
SECONDARY_SCHOOL_KEY
|
Key for the secondary school dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
PROSPECTIVE STUDENT
|
|
SECONDARY_SCHOOL_PERCENTILE
|
Person's class percentile as related to class rank and size.
|
NUMBER
|
PREVIOUS_EDUCATION
|
PERCENTILE
|
NO
|
NO
|
PROSPECTIVE STUDENT
|
|
SECONDARY_SCHOOL_RANK
|
Person's secondary school class rank.
|
NUMBER
|
PREVIOUS_EDUCATION
|
SCHOOL_RANK
|
NO
|
NO
|
PROSPECTIVE STUDENT
|
|
SECONDARY_SCHOOL_SIZE
|
Person's secondary school class size.
|
NUMBER
|
PREVIOUS_EDUCATION
|
SCHOOL_SIZE
|
NO
|
NO
|
PROSPECTIVE STUDENT
|
|
SET_PRIMARY_HS_MANUALLY_IND
|
Set Primary Hs Manually Ind.
|
NUMBER
|
|
|
|
NO
|
|
|
STREET_LINE_KEY
|
Key of the street line dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
PROSPECTIVE STUDENT
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
PROSPECTIVE STUDENT
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL GENERATED
|
NA
|
NO
|
NO
|
PROSPECTIVE STUDENT
|