Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
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(6)
|
SHRTCKG
|
SHRTCKG_TERM_CODE
|
NO
|
NO
|
ACADEMIC_PERIOD_DESC
|
Description of the academic period.
|
VARCHAR2(30)
|
STVTERM
|
STVTERM_DESC
|
NO
|
NO
|
ACADEMIC_YEAR
|
Academic year associated with the academic period.
|
VARCHAR2(4)
|
STVTERM
|
STVTERM_ACYR_CODE
|
NO
|
NO
|
ACADEMIC_YEAR_DESC
|
Description for this academic year.
|
VARCHAR2(30)
|
STVACYR
|
STVACYR_DESC
|
NO
|
NO
|
COURSE_IDENTIFICATION
|
Course subject and course number combined.
|
VARCHAR2(9)
|
|
|
|
NO
|
COURSE_NUMBER
|
Course number associated with the subject for the course.
|
VARCHAR2(5)
|
SHRTCKN
|
SHRTCKN_CRSE_NUMB
|
NO
|
NO
|
COURSE_REFERENCE_NUMBER
|
Computer assigned internal unique number for the schedule offering.
|
VARCHAR2(5)
|
SHRTCKN
|
SHRTCKN_CRN
|
NO
|
NO
|
COURSE_SEQUENCE_NUMBER
|
Sequence number used to associated the information about the unique course for the student.
|
NUMBER
|
SHRTCKG
|
SHRTCKG_TCKN_SEQ_NO
|
NO
|
NO
|
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)
|
NO
|
NO
|
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)
|
NO
|
NO
|
CREDITS_FOR_GPA
|
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)
|
NO
|
NO
|
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)
|
NO
|
NO
|
CURRENT_DATE
|
System current date (sysdate) or date the data was extracted.
|
DATE
|
NA
|
SYSDATE
|
NO
|
NO
|
DOMAIN_VALUE
|
The institution value of the organization-oriented identifier for the record used to determine access authorization to this record.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
FINAL_GRADE
|
Assigned student final grade.
|
VARCHAR2(6)
|
SHRTCKG
|
SHRTCKG_GRDE_CODE_FINAL
|
NO
|
NO
|
FINAL_GRADE_CHANGE_USER
|
Institutional Course Grade Change User. User-id of user who posted the grade.
|
VARCHAR2(255)
|
SHRTCKG
|
SHRTCKG_FINAL_GRDE_CHG_USER
|
NO
|
NO
|
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
|
NO
|
NO
|
GRADE_CHANGE_DATE
|
Date associated with this grade.
|
DATE
|
SHRTCKG
|
SHRTCKG_FINAL_GRDE_CHG_DATE
|
NO
|
NO
|
GRADE_CHANGE_REASON
|
Institution defined grade change reason associated with this grade for this course.
|
VARCHAR2(2)
|
SHRTCKG
|
SHRTCKG_GCHG_CODE
|
NO
|
NO
|
GRADE_CHANGE_REASON_DESC
|
Grade change reason description.
|
VARCHAR2(30)
|
STVGCHG
|
STVGCHG_DESC
|
NO
|
NO
|
GRADE_COMMENT
|
Value for the grade comment or result code added for this course.
|
VARCHAR2(7)
|
SHRTCKG
|
SHRTCKG_GCMT_CODE
|
NO
|
NO
|
GRADE_COMMENT_DESC
|
Grade comment descriptive text.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
GRADE_TYPE
|
Grade mode associated with this section or offering of the course.
|
VARCHAR2(1)
|
SHRTCKG
|
SHRTCKG_GMOD_CODE
|
NO
|
NO
|
GRADE_TYPE_DESC
|
Grade type description.
|
VARCHAR2(30)
|
STVGMOD
|
STVGMOD_DESC
|
NO
|
NO
|
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
|
SHRTCKG
|
SHRTCKG_INCOMPLETE_EXT_DATE
|
NO
|
NO
|
MIF_DESC
|
The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.
|
VARCHAR2(30)
|
NA
|
NA
|
NO
|
NO
|
MIF_VALUE
|
The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
PERSON_UID
|
System generated unique internal identification number assigned to this person.
|
NUMBER
|
SHRTCKG
|
SHRTCKG_PIDM
|
NO
|
NO
|
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)
|
NO
|
NO
|
SUBJECT
|
Identifies the main instructional subject area for this course.
|
VARCHAR2(4)
|
SHRTCKN
|
SHRTCKN_SUBJ_CODE
|
NO
|
NO
|
SUBJECT_DESC
|
Description for the subject code.
|
VARCHAR2(30)
|
STVSUBJ
|
STVSUBJ_DESC
|
NO
|
NO
|
SUB_ACADEMIC_PERIOD
|
Identifies a session, portion or part of the academic period.
|
VARCHAR2(3)
|
SHRTCKN
|
SHRTCKN_PTRM_CODE
|
NO
|
NO
|
SUB_ACADEMIC_PERIOD_DESC
|
Description of the sub academic period.
|
VARCHAR2(30)
|
STVPTRM
|
STVPTRM_DESC
|
NO
|
NO
|
ZONE_VALUE
|
The institution value of the process-oriented identifier for the record used to determine access authorization to this record.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|