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)	SHRTCKN	SHRTCKN_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(30)	STVTERM	STVTERM_DESC
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(4)	STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(30)	STVACYR	STVACYR_DESC
CAMPUS_RESTRICT_OVERRIDE_IND		VARCHAR2(1)
CAPACITY_OVERRIDE_IND		VARCHAR2(1)
CHARGES_WAIVED_IND		CHAR(1)
CLASS_RESTRICT_OVERRIDE_IND		VARCHAR2(1)
COLLEGE_RESTRICT_OVERRIDE_IND		VARCHAR2(1)
COREQUISITE_OVERRIDE_IND		VARCHAR2(1)
COUNT_IN_GPA_IND	Indicates whether this course should be used in the calculation of the GPA.	VARCHAR2(1)	SHRGRDE	SHRGRDE_GPA_IND
COURSE_ATTEMPTED_IND		VARCHAR2(1)
COURSE_BILLING_CREDITS	Billing units associated with this section or schedule offering.	NUMBER	SFRSTCR	SFRSTCR_BILL_HR
COURSE_BILLING_HOLD	Identifies the number of billing units that are being held for potential reinstatement.	NUMBER	SFRSTCR	SFRSTCR_BILL_HR_HOLD
COURSE_CAMPUS	Campus the student attended this schedule offering or section.	VARCHAR2(3)	SHRTCKN	SHRTCKN_CAMP_CODE
COURSE_CAMPUS_DESC	Institution campus description.	VARCHAR2(30)	STVCAMP	STVCAMP_DESC
COURSE_COLLEGE	College, faculty or school provide this section instruction.	VARCHAR2(2)	SHRTCKN	SHRTCKN_COLL_CODE
COURSE_COLLEGE_DESC	College description.	VARCHAR2(30)	STVCOLL	STVCOLL_DESC
COURSE_CREDITS	Credits associated with this course.	NUMBER	SHRTCKG	SHRTCKG_CREDIT_HOURS
COURSE_CREDITS_HOLD	Identifies the number of credits that are being held for potential reinstatement.	NUMBER	SFRSTCR	SFRSTCR_BILL_HR_HOLD
COURSE_DEPARTMENT	Department providing this instruction.	VARCHAR2(4)	SHRTCKN	SHRTCKN_DEPT_CODE
COURSE_DEPARTMENT_DESC	Department providing this instruction.	VARCHAR2(30)	STVDEPT	STVDEPT_DESC
COURSE_DIVISION	Division providing this instruction.	VARCHAR2(4)	SHRTCKN	SHRTCKN_DIVS_CODE
COURSE_DIVISION_DESC	Division description.	VARCHAR2(30)	STVDIVS	STVDIVS_DESC
COURSE_EARNED_IND		VARCHAR2(1)
COURSE_FAILED_IND		CHAR(1)
COURSE_IDENTIFICATION	Course subject and course number combined.	VARCHAR2(9)
COURSE_LEVEL	Level of academic study satisfied by this course. For example, undergraduate, graduate, credit, etc.	VARCHAR2(2)	SHRTCKL	SHRTCKL_LEVL_CODE
COURSE_LEVEL_DESC	Course level description.	VARCHAR2(30)	STVLEVL	STVLEVL_DESC
COURSE_NUMBER	Course number associated with the subject for the course.	VARCHAR2(5)	SHRTCKN	SHRTCKN_CRSE_NUMB
COURSE_PASSED_IND		VARCHAR2(1)
COURSE_REFERENCE_NUMBER	Computer assigned internal unique number for the schedule offering.	VARCHAR2(5)	SHRTCKN	SHRTCKN_CRN
COURSE_REGISTER_IND		VARCHAR2(1)
COURSE_SECTION_NUMBER	Sequence number used to associated the information about the unique course for the student.	VARCHAR2(3)	SHRTCKN	SHRTCKN_SEQ_NUMB
COURSE_SEQ_NO	Sequence number used to associated the information about the unique course for the student.	NUMBER	SHRTCKN	SHRTCKN_SEQ_NO
COURSE_TITLE_LONG	Long title for the course.	VARCHAR2(100)	SHRTCKN	SHRTCKN_LONG_COURSE_TITLE
COURSE_TITLE_SHORT	Short title for the course.	VARCHAR2(30)	SHRTCKN	SHRTCKN_CRSE_TITLE
COURSE_VERSION_NO	Course version number.	VARCHAR2(0)	NA	NA
CREDITS_ATTEMPTED	Credits attempted as defined by the grading rules of the institution. In-progress or transfer courses may be defined not to add to the credits attempted.	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)
CREDIT_FOR_GPA_IND		VARCHAR2(1)
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DEGREE_RESTRICT_OVERRIDE_IND		VARCHAR2(1)
DEPARTMENT_RESTRICT_OVER_IND		VARCHAR2(1)
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
DUPLICATE_COURSE_OVERRIDE_IND		VARCHAR2(1)
EFF_ACADEMIC_PERIOD_OF_GRADE	Earliest academic period for which grade is used.	VARCHAR2(6)	SHRGRDE	SHRGRDE_TERM_CODE_EFFECTIVE
END_DATE	Date on which the instruction ended. It is either stored specifically for the open learning student or taken from the end date on the offering.	DATE	CALCULATION	NVL(SHRTCKN_REG_COMPLETION_DATE,SOKODSF.F_GET_COURSE_DATES(SHRTCKN_PIDM,SHRTCKN_TERM_CODE,SHRTCKN_CRN,SHRTCKN_PTRM_CODE,'E'))
EXTENSIONS	Number of extensions granted to an open learning student to complete the instruction.	NUMBER	CALCULATION	NVL(SHRTCKN_NUMBER_OF_EXTENSIONS, SOKODSF.F_GET_COURSE_EXTENSIONS(SHRTCKN_PIDM,SHRTCKN_TERM_CODE,SHRTCKN_CRN))
FINALIZED_COMPLETION_DATE	Date a student completed their study for this subject or course. This might be the final completion date for an open learning course or it might be the end date from the sub academic period end date associated with a section.	DATE	FUNCTION	SOKODSF.F_GET_COURSE_DATES
FINAL_GRADE	Final grade earned by the student for this course.	VARCHAR2(6)	SHRTCKG	SHRTCKG_GRDE_CODE_FINAL
FINAL_GRADE_DATE	Date associated with this grade.	DATE	SHRTCKG	SHRTCKG_FINAL_GRDE_CHG_DATE
FINAL_GRADE_ROLL_IND	Indicates whether the final grade has been rolled to the history tables where applicable.	VARCHAR2(1)	CALCULATION	DECODE(SFRSTCR_GRDE_DATE,NULL,'N','Y')
GRADABLE_IND	Indicates whether the course can be graded.	VARCHAR2(1)	SSBSECT	SSBSECT_GRADABLE_IND
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		VARCHAR2(7)
GRADE_COMMENT_DESC		VARCHAR2(200)
GRADE_TYPE	Grade mode associated with this COURSE REFERENCE NUMBER.	VARCHAR2(1)	SHRTCKG	SHRTCKG_GMOD_CODE
GRADE_TYPE_DESC	Grade type description.	VARCHAR2(30)	STVGMOD	STVGMOD_DESC
GRADE_VALUE	Numeric value assigned to a grade symbol to be used to measure course performance statistics. This will only be present if a final grade has been recorded for either in progress or grades rolled to history for the student course.	NUMBER	SHRGRDE	SHRGRDE_NUMERIC_VALUE
HOURS_ATTENDED	Number of hours the student attended this class.	NUMBER	SFRSTCR	SFRSTCR_ATTEND_HR
INCOMPLETE_EXT_DATE	Specifies the date at which the extension for the course becomes an incomplete grade.	DATE	SHRTCKG	SHRTCKG_INCOMPLETE_EXT_DATE
INCOMPLETE_GRADE_IND		VARCHAR2(1)
INSTITUTION_COURSE_IND	Indicates whether the subject or course was taken at this institution and is in academic history.	VARCHAR2(1)	CONSTANT	'Y'
INSTRUCTION_METHOD	Instructional method associated with the course.	VARCHAR2(5)	STVSCHD	STVSCHD_INSM_CODE
INSTRUCTION_METHOD_DESC	Instructional method description associated with the course.	VARCHAR2(30)	GTVINSM	GTVINSM_DESC
INTEGRATION_PARTNER	Institution defined integration code that identifies an external partner used for instruction of this schedule offering.	VARCHAR2(5)	SSBSECT	SSBSECT_INTG_CDE
INTEGRATION_PARTNER_DESC	Instruction integration partner description.	VARCHAR2(30)	GORINTG	GORINTG_DESC
INTEGRATION_PARTNER_SYSTEM	Institution defined integration system code that identifies an external partner systen used for instruction of this schedule offering.	VARCHAR2(5)	GORINTG	GORINTG_INTP_CODE
INTEGRATION_PARTNER_SYS_DESC	Instruction integration partner system description.	VARCHAR2(30)	GORINTG	GTVINTP_DESC
IN_PROGRESS_COURSE_IND	Indicates whether the course is in progress and not yet graded.	VARCHAR2(1)	CONSTANT	'N'
LAST_ATTEND_DATE	Identifies the date on which the instruction ended.	DATE	SFRSTCR	SFRSTCR_LAST_ATTEND
LAST_DATE_ATTEND_REQUIRED_IND		VARCHAR2(1)
LEVEL_RESTRICT_OVERRIDE_IND		VARCHAR2(1)
LINK_OVERRIDE_IND		VARCHAR2(1)
MAJOR_RESTRICT_OVERRIDE_IND		VARCHAR2(1)
MID_TERM_GRADE	Mid-term grade code associated with this COURSE REFERENCE NUMBER.	VARCHAR2(6)	SFRSTCR	SFRSTCR_GRDE_CODE_MID
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
MUTUTAL_EXCLUSION_OVERRIDE_IND		VARCHAR2(1)
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SHRTCKN	SHRTCKN_PIDM
PREREQUISITE_OVERRIDE_IND		VARCHAR2(1)
PROGRAM_RESTRICT_OVERRIDE_IND		VARCHAR2(1)
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)
REGISTER_CENSUS_DATE1_IND		CHAR(1)
REGISTER_CENSUS_DATE2_IND		CHAR(1)
REGISTRATION_ERROR_FLAG	Indicates an error is associated with this section registration.	VARCHAR2(1)	SFRSTCR	SFRSTCR_ERROR_FLAG
REGISTRATION_OVERRIDE_IND		CHAR(1)
REGISTRATION_SEQUENCE_NUMBER	Sequence number system assigned to the student registration in the section.	NUMBER	SHRTCKN	SHRTCKN_REG_SEQ
REGISTRATION_STATUS	Course registration status associated with this section.	VARCHAR2(2)	SFRSTCR	SFRSTCR_RSTS_CODE
REGISTRATION_STATUS_DATE	Date associated with the course registration status of this section.	DATE	SFRSTCR	SFRSTCR_RSTS_DATE
REGISTRATION_STATUS_DESC	Course registration status description.	VARCHAR2(30)	STVRSTS	STVRSTS_DESC
REGISTRATION_USER_ID	Person user identification number who processed the registration request for this section.	VARCHAR2(30)	SFRSTCR	SFRSTCR_USER
REPEAT_COURSE_CREDIT_OVER_IND		VARCHAR2(1)
REPEAT_COURSE_IND	Indicates whether this course was registered in more than one academic period by the student.	VARCHAR2(1)	SHRTCKN	SHRTCKN_REPEAT_COURSE_IND
REPEAT_COURSE_OVERRIDE_IND		VARCHAR2(1)
REPEAT_EVALUATE_IND		VARCHAR2(1)
SCHEDULE_TYPE	Instructional method or delivery type associated with the course.	VARCHAR2(3)	SHRTCKN	SHRTCKN_SCHD_CODE
SCHEDULE_TYPE_DESC	Schedule type description.	VARCHAR2(30)	STVSCHD	STVSCHD_DESC
SECTION_ADD_DATE	Date the student registered in this section.	DATE	SFRSTCR	SFRSTCR_ADD_DATE
SPECIAL_APPROVAL_IND	Indicates whether special approval was received to register in this section.	VARCHAR2(1)	SFRSTCR	SFRSTCR_APPR_RECEIVED_IND
SPECIAL_APPROVAL_OVERRIDE_IND		VARCHAR2(1)
START_DATE	Date the instruction for this course began for this student.	DATE	FUNCTION	SOKODSF.F_GET_COURSE_DATES
STUDENT_ATTRIBUTE_OVERRIDE_IND		VARCHAR2(1)
STUDENT_COHORT_OVERRIDE_IND		VARCHAR2(1)
STUDY_PATH_SEQUENCE		NUMBER
SUBJECT	Main instructional subject area for this course.	VARCHAR2(4)	SHRTCKN	SHRTCKN_SUBJ_CODE
SUBJECT_DESC	Subject code description.	VARCHAR2(30)	STVSUBJ	STVSUBJ_DESC
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.	VARCHAR2(3)	SHRTCKN	SHRTCKN_PTRM_CODE
SUB_ACADEMIC_PERIOD_DESC	Sub academic period description.	VARCHAR2(30)	STVPTRM	STVPTRM_DESC
TEST_SCORE_OVERRIDE_IND		VARCHAR2(1)
TIME_CONFLICT_OVERRIDE_IND		VARCHAR2(1)
TRADITIONAL_IND	Indicates whether this grade symbol is considered a traditional type of grade.	VARCHAR2(1)	NA	NA
TRANSFER_COURSE_IND	Indicates whether this course was taken at and transferred from another post secondary institution. This is no when this is an institutional history course.	VARCHAR2(1)	CONSTANT	'N'
TRANSFER_COURSE_INSTITUTION	Identifies the post secondary institution where the transfer course was taken.	VARCHAR2(0)	NA	NA
TRANSFER_COURSE_INST_DESC	Name of the post secondary transfer institution.	VARCHAR2(0)	NA	NA
TRANSFER_COURSE_INST_SEQ_NO	Specifies the sequence number for the institution where the course was transferred.	NUMBER	NA	NA
WAITLIST_IND		VARCHAR2(1)
WITHDRAWN_IND		VARCHAR2(1)
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: