Target Column	Business Definition	Database Data Type	Source Name	Source Column
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
ACADEMIC_PERIOD_DESC	Description of the academic period.	VARCHAR2(30)	STVTERM	STVTERM_DESC
ACADEMIC_YEAR	Academic year associated with the academic period.	VARCHAR2(4)	STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC	Description for this academic year.	VARCHAR2(30)	STVACYR	STVACYR_DESC
COURSE_IDENTIFICATION	Course subject and course number combined.	VARCHAR2(9)
COURSE_NUMBER	Course number associated with the subject for the course.	VARCHAR2(5)	SHRTCKN	SHRTCKN_CRSE_NUMB
COURSE_REFERENCE_NUMBER	Computer assigned internal unique number for the schedule offering.	VARCHAR2(5)	SHRTCKN	SHRTCKN_CRN
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 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 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 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 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)
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
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
FINAL_GRADE	Assigned student final grade.	VARCHAR2(6)	SHRTCKG	SHRTCKG_GRDE_CODE_FINAL
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
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	Date associated with this grade.	DATE	SHRTCKG	SHRTCKG_FINAL_GRDE_CHG_DATE
GRADE_CHANGE_REASON	Institution defined grade change reason associated with this grade for this course.	VARCHAR2(2)	SHRTCKG	SHRTCKG_GCHG_CODE
GRADE_CHANGE_REASON_DESC	Grade change reason description.	VARCHAR2(30)	STVGCHG	STVGCHG_DESC
GRADE_COMMENT	Value for the grade comment or result code added for this course.	VARCHAR2(7)	SHRTCKG	SHRTCKG_GCMT_CODE
GRADE_COMMENT_DESC	Grade comment descriptive text.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
GRADE_TYPE	Grade mode associated with this section or offering of the course.	VARCHAR2(1)	SHRTCKG	SHRTCKG_GMOD_CODE
GRADE_TYPE_DESC	Grade type description.	VARCHAR2(30)	STVGMOD	STVGMOD_DESC
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
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
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
PERSON_UID	System generated unique internal identification number assigned to this person.	NUMBER	SHRTCKG	SHRTCKG_PIDM
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	Identifies the main instructional subject area for this course.	VARCHAR2(4)	SHRTCKN	SHRTCKN_SUBJ_CODE
SUBJECT_DESC	Description for the subject code.	VARCHAR2(30)	STVSUBJ	STVSUBJ_DESC
SUB_ACADEMIC_PERIOD	Identifies a session, portion or part of the academic period.	VARCHAR2(3)	SHRTCKN	SHRTCKN_PTRM_CODE
SUB_ACADEMIC_PERIOD_DESC	Description of the sub academic period.	VARCHAR2(30)	STVPTRM	STVPTRM_DESC
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

Ver: