Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACADEMIC_PERIOD		Academic period or time frame this degree course attribute applied to this course.	VARCHAR2(6)		SHRTCKG	SHRTCKG_TERM_CODE
ACADEMIC_PERIOD_DESC		Description of the academic period.	VARCHAR2(30)		STVTERM	STVTERM_DESC
ACADEMIC_YEAR	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		Combined subject code and course number that identifies the instructional content of this course.	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(2)		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_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(2)		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(8)		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: