| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
DEMOGRAPHIC_KEY
|
Key for the demographic dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
POST SECONDARY SCHOOL
|
|
HIGHEST_DEGREE_AWARDED_IND
|
Identifies the highest award, certificate or degree earned by the person.
|
NUMBER
|
FUNCTION
|
ROW_NUMBER() OVER (PARTITION BY DRIVER.PERSON_UID ORDER BY DRIVER.POST_SECONDARY_DEGREE_DATE DESC NULLS LAST, DRIVER.AWARD_CATEGORY DESC NULLS LAST, DRIVER.POST_SECONDARY_ATTEND_FROM DESC N
|
NO
|
NO
|
POST SECONDARY SCHOOL
|
|
INSTITUTION_KEY
|
Key for the institution dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
POST SECONDARY SCHOOL
|
|
LAST_POST_SECONDARY_IND
|
Identifies this post secondary school is that latest school attended by this person.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
POST SECONDARY SCHOOL
|
|
MULTI_SOURCE_KEY
|
Key for the multi source dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
POST SECONDARY SCHOOL
|
|
OUTCOME_AWARD_IND
|
First degree date associated with post secondary institution.
|
NUMBER
|
PREVIOUS_EDUCATION PREVIOUS_EDUCATION
|
POST_SECONDARY_DEGREE_DATE POST_SECONDARY_DEGREE_DATE
|
NO NO
|
NO
|
POST SECONDARY SCHOOL, POST SECONDARY SCHOOL POST SECONDARY SCHOOL, POST SECONDARY SCHOOL
|
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
ACADEMIC_OUTCOME PREVIOUS_EDUCATION PREVIOUS_EDUCATION
|
PERSON_UID PERSON_UID PERSON_UID
|
NO NO NO
|
NO
|
POST SECONDARY SCHOOL POST SECONDARY SCHOOL, POST SECONDARY SCHOOL POST SECONDARY SCHOOL, POST SECONDARY SCHOOL
|
|
POST_SECONDARY_ATTEND_FROM
|
Previous education first date of attendance.
|
DATE
|
PREVIOUS_EDUCATION PREVIOUS_EDUCATION
|
ATTEND_FROM_DATE ATTEND_FROM_DATE
|
NO NO
|
NO
|
POST SECONDARY SCHOOL, POST SECONDARY SCHOOL POST SECONDARY SCHOOL, POST SECONDARY SCHOOL
|
|
POST_SECONDARY_ATTEND_TO
|
Previous education last date of attendance.
|
DATE
|
PREVIOUS_EDUCATION
|
ATTEND_TO_DATE
|
NO
|
NO
|
POST SECONDARY SCHOOL
|
|
POST_SECONDARY_DEGREE_DATE
|
Identifies the first degree date associated with post secondary institution.
|
DATE
|
PREVIOUS_EDUCATION PREVIOUS_EDUCATION
|
POST_SECONDARY_DEGREE_DATE POST_SECONDARY_DEGREE_DATE
|
NO NO
|
NO
|
POST SECONDARY SCHOOL, POST SECONDARY SCHOOL POST SECONDARY SCHOOL, POST SECONDARY SCHOOL
|
|
POST_SECONDARY_GPA
|
Person's post secondary institution average or GPA.
|
NUMBER
|
ACADEMIC_OUTCOME
|
GPA
|
NO
|
NO
|
POST SECONDARY SCHOOL
|
|
POST_SECONDARY_NUMBER_KEY
|
Key for the post secondary school joined with the sequence number dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
POST SECONDARY SCHOOL
|
|
POST_SECONDARY_SCHOOL_GRP_KEY
|
Unique identifier for all the post secondary schools recorded for this person.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
POST SECONDARY SCHOOL
|
|
POST_SECONDARY_SCHOOL_KEY
|
Key for the post secondary school dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
POST SECONDARY SCHOOL
|
|
POST_SECONDARY_TRANS_CREDITS
|
Number of transfer credits received from the previous post secondary institution.
|
NUMBER
|
PREVIOUS_EDUCATION PREVIOUS_EDUCATION
|
TOTAL_TRANSFER_CREDITS TOTAL_TRANSFER_CREDITS
|
NO NO
|
NO
|
POST SECONDARY SCHOOL, POST SECONDARY SCHOOL POST SECONDARY SCHOOL, POST SECONDARY SCHOOL
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
POST SECONDARY SCHOOL
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL GENERATED
|
NA
|
NO
|
NO
|
POST SECONDARY SCHOOL
|