Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
ACADEMIC_TIME_KEY
|
Key for the academic time dimension.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
GRADE CHANGE
|
COURSE_IDENTIFICATION
|
Course subject and course number combined.
|
VARCHAR2(63)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
GRADE CHANGE
|
COURSE_REFERENCE_NUMBER_KEY
|
Key for the course reference number dimension.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
GRADE CHANGE
|
CREDITS_ATTEMPTED
|
Credits attempted as defined by the grading rules of the institution.
|
NUMBER
|
STUDENT_COURSE_GRADE_CHANGE
|
CREDITS_ATTEMPTED
|
NO
|
NO
|
GRADE CHANGE
|
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
|
STUDENT_COURSE_GRADE_CHANGE
|
CREDITS_EARNED
|
NO
|
NO
|
GRADE CHANGE
|
CREDITS_FOR_GPA
|
Credits used in the calculation of the average or GPA based on the rules of the institution.
|
NUMBER
|
STUDENT_COURSE_GRADE_CHANGE
|
CREDITS_FOR_GPA
|
NO
|
NO
|
GRADE CHANGE
|
CREDITS_PASSED
|
Credits passed 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
|
STUDENT_COURSE_GRADE_CHANGE
|
CREDITS_PASSED
|
NO
|
NO
|
GRADE CHANGE
|
DEMOGRAPHIC_KEY
|
Key for the demographic dimension.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
GRADE CHANGE
|
FINAL_GRADE_IND
|
Identifies this grade as the last or latest change to the final grade for the student course.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
GRADE CHANGE
|
GRADE
|
Final grade assigned to the student for the work completed in this course section in this academic period.
|
VARCHAR2(63)
|
STUDENT_COURSE_GRADE_CHANGE
|
FINAL_GRADE
|
NO
|
NO
|
GRADE CHANGE
|
GRADE_CHANGE_DATE
|
Date this grade change was recorded in the system.
|
DATE
|
STUDENT_COURSE_GRADE_CHANGE
|
GRADE_CHANGE_DATE
|
NO
|
NO
|
GRADE CHANGE
|
GRADE_CHANGE_GROUP_KEY
|
Key for the grade change group dimension.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
GRADE CHANGE
|
GRADE_CHANGE_KEY
|
Key for the grade change dimension.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
GRADE CHANGE
|
GRADE_SEQUENCE_NUMBER
|
Sequence number used to associated the information about the unique course for the student.
|
NUMBER
|
STUDENT_COURSE_GRADE_CHANGE
|
FINAL_GRADE_SEQUENCE_NUMBER
|
NO
|
NO
|
GRADE CHANGE
|
INCOMPLETE_EXT_DATE
|
Extension date associated with an incomplete grade to determine when the student must have completed any missing work for the course.
|
DATE
|
STUDENT_COURSE_GRADE_CHANGE
|
INCOMPLETE_EXT_DATE
|
NO
|
NO
|
GRADE CHANGE
|
MULTI_SOURCE_KEY
|
Key for the multi source dimension.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
GRADE CHANGE
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
STUDENT_COURSE_GRADE_CHANGE
|
PERSON_UID
|
NO
|
NO
|
GRADE CHANGE
|
QUALITY_POINTS
|
Quality points associated with the grade.
|
NUMBER
|
STUDENT_COURSE_GRADE_CHANGE
|
QUALITY_POINTS
|
NO
|
NO
|
GRADE CHANGE
|
SUB_ACADEMIC_PERIOD_KEY
|
Key for the sub academic dimension.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
GRADE CHANGE
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
GRADE CHANGE
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
GRADE CHANGE
|