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
|
SECONDARY SCHOOL SUBJECT
|
INSTITUTION_KEY
|
Key for the institution dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
SECONDARY SCHOOL SUBJECT
|
MULTI_SOURCE_KEY
|
Key for the multi source dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
SECONDARY SCHOOL SUBJECT
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
SECONDARY_SCHOOL_SUBJECT
|
PERSON_UID
|
NO
|
NO
|
SECONDARY SCHOOL SUBJECT
|
SECONDARY_SCHOOL_SUBJECT_GPA
|
Number of secondary school years the person took this subject.
|
NUMBER
|
SECONDARY_SCHOOL_SUBJECT
|
GPA
|
NO
|
NO
|
SECONDARY SCHOOL SUBJECT
|
SECONDARY_SCHOOL_SUBJECT_KEY
|
Key for the secondary school subject dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
SECONDARY SCHOOL SUBJECT
|
SEC_SCHOOL_SUBJECT_GROUP_KEY
|
Key for the secondary school subject group.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
SECONDARY SCHOOL SUBJECT
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
SECONDARY SCHOOL SUBJECT
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL GENERATED
|
NA
|
NO
|
NO
|
SECONDARY SCHOOL SUBJECT
|
YEARS_TAKEN
|
Calculated grade point average or average for a set of courses completed by the person at their secondary school.
|
NUMBER
|
SECONDARY_SCHOOL_SUBJECT
|
YEARS_TAKEN
|
NO
|
NO
|
SECONDARY SCHOOL SUBJECT
|