Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
ACADEMIC_PERIOD
|
Academic Period
|
Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year.
|
VARCHAR2(63)
|
SHRTCKG
|
SHRTCKG_TERM_CODE
|
ACADEMIC_PERIOD_DESC
|
Academic Period Description
|
Description of the academic period.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
ACADEMIC_YEAR
|
Academic Year
|
Academic year associated with the academic period.
|
VARCHAR2(63)
|
STVTERM
|
STVTERM_ACYR_CODE
|
ACADEMIC_YEAR_DESC
|
Academic Year Description
|
Description for this academic year.
|
VARCHAR2(255)
|
STVACYR
|
STVACYR_DESC
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
COURSE_IDENTIFICATION
|
Course ID
|
Course subject and course number combined.
|
VARCHAR2(63)
|
CALCULATION
|
SHRTCKN_SUBJ_CODE||SHRTCKN_CRSE_NUMB
|
COURSE_NUMBER
|
Course Number
|
Course number associated with the subject for the course.
|
VARCHAR2(63)
|
SHRTCKN
|
SHRTCKN_CRSE_NUMB
|
COURSE_REFERENCE_NUMBER
|
Course Reference Number
|
Computer assigned internal unique number for the schedule offering.
|
VARCHAR2(63)
|
SHRTCKN
|
SHRTCKN_CRN
|
COURSE_SEQUENCE_NUMBER
|
Course Sequence Number
|
Sequence number used to associated the information about the unique course for the student.
|
NUMBER
|
SHRTCKG
|
SHRTCKG_TCKN_SEQ_NO
|
CREDITS_ATTEMPTED
|
Credits Attempted
|
Credits attempted as defined by the grading rules of the institution.
|
NUMBER
|
CALCULATION
|
SHRTCKG_CREDIT_HOURS*DECODE(SHRGRDE_ATTEMPTED_IND,'Y',1,0)
|
CREDITS_EARNED
|
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
|
CALCULATION
|
SHRTCKG_CREDIT_HOURS*DECODE(SHRGRDE_COMPLETED_IND,'Y',1,0)*DECODE(SHRTCKN_REPEAT_COURSE_IND,'A',0,'E',0,1)
|
CREDITS_FOR_GPA
|
Credits For GPA - Grade Point Average or Average
|
Credits used in the calculation of the average or GPA based on the rules of the institution.
|
NUMBER
|
CALCULATION
|
SHRTCKG_CREDIT_HOURS*DECODE(SHRGRDE_GPA_IND,'Y',1,0)*DECODE(SHRTCKN_REPEAT_COURSE_IND,'E',0,1)
|
CREDITS_PASSED
|
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
|
CALCULATION
|
SHRTCKG_CREDIT_HOURS*DECODE(SHRGRDE_PASSED_IND,'Y',1,0)*DECODE(SHRTCKN_REPEAT_COURSE_IND,'A',0,'E',0,1)
|
FINAL_GRADE
|
Final Grade
|
Assigned student final grade.
|
VARCHAR2(63)
|
SHRTCKG
|
SHRTCKG_GRDE_CODE_FINAL
|
FINAL_GRADE_CHANGE_USER
|
Final Grade Change user
|
Institutional Course Grade Change User.
|
VARCHAR2(255)
|
SHRTCKG
|
SHRTCKG_FINAL_GRDE_CHG_USER
|
FINAL_GRADE_SEQUENCE_NUMBER
|
Final Grade Sequence Number
|
System assigned sequence number assigned as the grade for a course is changed. The highest number is the last grade change recorded and will display on the STUDENT_COURSE reporting view.
|
NUMBER
|
SHRTCKG
|
SHRTCKG_SEQ_NO
|
GRADE_CHANGE_DATE
|
Grade Change Date
|
Date associated with this grade.
|
DATE
|
SHRTCKG
|
SHRTCKG_FINAL_GRDE_CHG_DATE
|
GRADE_CHANGE_REASON
|
Grade Change Reason
|
Institution defined grade change reason associated with this grade for this course.
|
VARCHAR2(63)
|
SHRTCKG
|
SHRTCKG_GCHG_CODE
|
GRADE_CHANGE_REASON_DESC
|
Grade Change Reason Description
|
Grade change reason description.
|
VARCHAR2(255)
|
STVGCHG
|
STVGCHG_DESC
|
GRADE_COMMENT
|
Grade Comment
|
Value for the grade comment or result code added for this course.
|
VARCHAR2(63)
|
SHRTCKG
|
SHRTCKG_GCMT_CODE
|
GRADE_COMMENT_DESC
|
Grade Comment Description
|
Grade comment descriptive text.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
GRADE_TYPE
|
Grade Type
|
Grade mode associated with this section or offering of the course.
|
VARCHAR2(63)
|
SHRTCKG
|
SHRTCKG_GMOD_CODE
|
GRADE_TYPE_DESC
|
Grade Type Description
|
Grade type description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
ID
|
ID
|
Identification number assigned to a person that is used externally for all communication and correspondence with the person.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
INCOMPLETE_EXT_DATE
|
Incomplete Extension Date
|
Extension date associated with an incomplete grade to determine when the student must have completed any missing work for the course.
|
DATE
|
SHRTCKG
|
SHRTCKG_INCOMPLETE_EXT_DATE
|
MULTI_SOURCE
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NAME
|
Name
|
Combination of the person's last, first, and middle initial into one value.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
PERSON_UID
|
Person UID
|
System generated unique internal identification number assigned to this person.
|
NUMBER
|
SHRTCKG
|
SHRTCKG_PIDM
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
QUALITY_POINTS
|
Quality Points
|
Quality points associated with the grade.
|
NUMBER
|
CALCULATION
|
SHRTCKG_CREDIT_HOURS*SHRGRDE_QUALITY_POINTS*DECODE(SHRGRDE_GPA_IND,'Y',1,0)*DECODE(SHRTCKN_REPEAT_COURSE_IND,'E',0,1)
|
SUBJECT
|
Subject
|
Identifies the main instructional subject area for this course.
|
VARCHAR2(63)
|
SHRTCKN
|
SHRTCKN_SUBJ_CODE
|
SUBJECT_DESC
|
Subject Description
|
Description for the subject code.
|
VARCHAR2(255)
|
STVSUBJ
|
STVSUBJ_DESC
|
SUB_ACADEMIC_PERIOD
|
Sub Academic Period
|
Identifies a session, portion or part of the academic period.
|
VARCHAR2(63)
|
SHRTCKN
|
SHRTCKN_PTRM_CODE
|
SUB_ACADEMIC_PERIOD_DESC
|
Sub Academic Period Description
|
Description of the sub academic period.
|
VARCHAR2(255)
|
STVPTRM
|
STVPTRM_DESC
|