Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
ACADEMIC_OUTCOME_COUNT_KEY
|
Count for the academic outcomes for the person.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC OUTCOME
|
ACADEMIC_OUTCOME_GROUP_KEY
|
Key for the academic outcome group for the person.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC OUTCOME
|
ACADEMIC_OUTCOME_KEY
|
Key for the academic outcome dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC OUTCOME
|
ACADEMIC_OUTCOME_RECORD_KEY
|
Key for the academic outcome dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC OUTCOME
|
ACADEMIC_STUDY_KEY
|
Key for the academic study dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC OUTCOME
|
ACADEMIC_TIME_KEY
|
Key for the academic time dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC OUTCOME
|
ACAD_OUTCOME_HONOR_GROUP_KEY
|
Key for the academic study dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC OUTCOME
|
CREDITS_ATTEMPTED
|
Sum of credits attempted by a student for this academic outcome.
|
NUMBER
|
ACADEMIC_OUTCOME
|
CREDITS_ATTEMPTED
|
NO
|
NO
|
ACADEMIC OUTCOME
|
CREDITS_EARNED
|
Credits earned as defined by the grading rules of the institution. This number must be calculated by the system after the final grade is recorded for the student.
|
NUMBER
|
ACADEMIC_OUTCOME
|
CREDITS_EARNED
|
NO
|
NO
|
ACADEMIC OUTCOME
|
CREDITS_PASSED
|
Sum of credits passed by a student for this academic outcome.
|
NUMBER
|
ACADEMIC_OUTCOME
|
CREDITS_PASSED
|
NO
|
NO
|
ACADEMIC OUTCOME
|
CURRICULUM_ORDER
|
Unique sequence number that identifies this academic study or program for the student.
|
NUMBER
|
ACADEMIC_OUTCOME
|
CURRICULUM_ORDER
|
NO
|
NO
|
ACADEMIC OUTCOME
|
CURRICULUM_PRIORITY
|
Identifies the significant ranking for a curricula as assigned by the institution.
|
NUMBER
|
ACADEMIC_OUTCOME
|
CURRICULUM_PRIORITY_NUMBER
|
NO
|
NO
|
ACADEMIC OUTCOME
|
DEMOGRAPHIC_KEY
|
Key for the demographic dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC OUTCOME
|
DEPARTMENTAL_HONOR_GROUP_KEY
|
Key for the group of departmental honor assigned to this outcome.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC OUTCOME
|
GPA
|
Calculated grade point average or average for the set of courses completed.
|
NUMBER
|
ACADEMIC_OUTCOME
|
GPA
|
NO
|
NO
|
ACADEMIC OUTCOME
|
GPA_CREDITS
|
Credits used to calculate the average or grade point average for the courses used to complete the outcome requirements.
|
NUMBER
|
ACADEMIC_OUTCOME
|
GPA_CREDITS
|
NO
|
NO
|
ACADEMIC OUTCOME
|
GRADUATION_ACADEMIC_TIME_KEY
|
Key for the graduation academic time dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC OUTCOME
|
INSTITUTIONAL_HONOR_GROUP_KEY
|
Key for the group of institutional honor assigned to this outcome.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC OUTCOME
|
MULTI_SOURCE_KEY
|
Key for the multi source dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC OUTCOME
|
OUTCOME_APPLICATION_DATE
|
Date that the student applied for graduation in this academic outcome.
|
DATE
|
ACADEMIC_OUTCOME
|
OUTCOME_APPLICATION_DATE
|
NO
|
NO
|
ACADEMIC OUTCOME
|
OUTCOME_GRADUATION_DATE
|
Date for the formal graduation for this academic outcome. This is the date that the completion of this degree or award is confirmed.
|
DATE
|
ACADEMIC_OUTCOME
|
OUTCOME_GRADUATION_DATE
|
NO
|
NO
|
ACADEMIC OUTCOME
|
OUTCOME_NUMBER
|
Outcome sequence number.
|
NUMBER
|
ACADEMIC_OUTCOME
|
OUTCOME_NUMBER
|
NO
|
NO
|
ACADEMIC OUTCOME
|
PERSON_UID
|
System generated, unique, internal identification number assigned to the person.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC OUTCOME
|
QUALITY_POINTS
|
Quality points used to calculate the grade point average for this academic outcome.
|
NUMBER
|
ACADEMIC_OUTCOME
|
QUALITY_POINTS
|
NO
|
NO
|
ACADEMIC OUTCOME
|
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
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC OUTCOME
|