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)	SFRSTCR SHRTCKN SHRTRCE	SFRSTCR_TERM_CODE SHRTCKN_TERM_CODE SHRTRCE_TERM_CODE_EFF
ACADEMIC_PERIOD_DESC	Academic Period Description	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
ACADEMIC_YEAR	Academic Year	Academic year associated with the academic period on this record.	VARCHAR2(63)	FUNCTION	GOKODSF.F_GET_DESC
ACADEMIC_YEAR_DESC	Academic Year Description	Academic year description.	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
BLOCK_REGISTRATION	Block Registration	Identifies the block registration code that was assigned to the student that had the student register for this student course.	VARCHAR2(63)	SFRSTCR	SFRSTCR_BLCK_CODE
BLOCK_REGISTRATION_DESC	Block Registration Description	Description for the block registration code.	VARCHAR2(255)	STVBLCK	STVBLCK_DESC
BLOCK_REG_SEQUENCE_NUMBER	Block Registration Sequence Number	Sequence number that uniquely identifies the rule for block assignment.	NUMBER	SFRSTCR	SFRSTCR_BRDH_SEQ_NUM
CAMPUS	Campus	Campus associated with this record. Campus for the course section, student course, student, applied for on the admission application, etc.	VARCHAR2(63)	SFRSTCR SSBOVRR	SFRSTCR_CAMP_CODE SSBOVRR_CAMP_CODE
CAMPUS_DESC	Campus Description	Institution campus name.	VARCHAR2(255)	STVCAMP	STVCAMP_DESC
CAMPUS_RESTRICT_OVERRIDE_IND	Campus Restrict Override Indicator	Indicates the campus restriction was overridden.	VARCHAR2(1)	CALCULATION	NVL(SFRSTCR_CAMP_OVER,'N')
CAPACITY_OVERRIDE_IND	Capacity Override Indicator	Indicates the course capacity restriction was overridden. Course capacity indicates the number of seats available in a course.	VARCHAR2(1)	CALCULATION	NVL(SFRSTCR_CAPC_OVER,'N')
CHARGES_WAIVED_IND	Charges Waived Ind	Indicates the fee rules from the Banner fee assessment rules do not get applied to this section.	VARCHAR2(1)	CALCULATION	CASE WHEN SFRSTCR_WAIV_HRS
CLASS_RESTRICT_OVERRIDE_IND	Class Restrict Override Indicator	Indicates the class restriction was overridden.	VARCHAR2(1)	CALCULATION	NVL(SFRSTCR_CLAS_OVER,'N')
COLLEGE	College	First level of the institution organization structure that owns the student or the academic instruction for a student course.	VARCHAR2(63)	SCBCRSE SHRTCKN SSBOVRR	SCBCRSE_COLL_CODE SHRTCKN_COLL_CODE SSBOVRR_COLL_CODE
COLLEGE_DESC	College Description	College, faculty or school name.	VARCHAR2(255)	STVCOLL	STVCOLL_DESC
COLLEGE_RESTRICT_OVERRIDE_IND	College Restrict Override Indicator	Indicates the college restriction was overridden.	VARCHAR2(1)	CALCULATION	NVL(SFRSTCR_COLL_OVER,'N')
COREQUISITE_OVERRIDE_IND	Corequisite Override Indicator	Indicates the co requisite restriction was overridden. Co requisite means that two courses are normally taken together. For example, a physics and a math class.	VARCHAR2(1)	CALCULATION	NVL(SFRSTCR_CORQ_OVER,'N')
COUNT_IN_GPA_IND	Count IN GPA - Grade Point Average or Average Indicator	Indicates whether this course should be used in the calculation of the GPA.	VARCHAR2(1)	SHRGRDE SHRTRCE	SHRGRDE_GPA_IND SHRTRCE_COUNT_IN_GPA_IND
COURSE_ATTEMPTED_IND	Course Attempted Ind	Indicates the course section counts as a course attempted and the course credits are added the credits attempted based on the final grade assigned to the person.	VARCHAR2(1)	CALCULATION CALCULATION CALCULATION	CASE WHEN SFRSTCR_GRDE_CODE CASE WHEN SHRTCKG_GRDE_CODE_FINAL CASE WHEN SHRTRCE_GRDE_CODE
COURSE_ATTRIBUTES_COUNT	Course Attributes Count	Number of course attributes associated with this course for this student.	NUMBER	FUNCTION FUNCTION	MSKFUNC.F_COUNT_COURSE_ATTRIBUTES MSKFUNC.F_COUNT_STUDENT_COURSE_ATTR
COURSE_BILLING_CREDITS	Course Billing Credits	Billing units associated with this section or schedule offering.	NUMBER	SFRSTCR	SFRSTCR_BILL_HR
COURSE_BILLING_HOLD	Course Billing Hold	Identifies the number of billing units that are being held for potential reinstatement.	NUMBER	SFRSTCR	SFRSTCR_BILL_HR_HOLD
COURSE_COMMENT	COURSE comment	This field identifies the course comment.	VARCHAR2(255)	SHRTCKN	SHRTCKN_COURSE_COMMENT
COURSE_CREDITS	Course Credits	Credits associated with this course.	NUMBER	SFRSTCR SHRTCKG SHRTRCE	SFRSTCR_CREDIT_HR SHRTCKG_CREDIT_HOURS SHRTRCE_CREDIT_HOURS
COURSE_CREDITS_HOLD	Course Credits Hold	Identifies the number of credits that are being held for potential reinstatement.	NUMBER	SFRSTCR	SFRSTCR_BILL_HR_HOLD
COURSE_EARNED_IND	Course Earned Ind	Indicates the course credits were counted in credits earned.	VARCHAR2(1)	CALCULATION CALCULATION CALCULATION	CASE WHEN SFRSTCR_GRDE_CODE CASE WHEN SHRTCKG_GRDE_CODE_FINAL CASE WHEN SHRTRCE_GRDE_CODE
COURSE_FAILED_IND	Course Failed Ind	Indicates the course section counts as a failed course and the course credits are added to the failed credits based on the final grade assigned to the person.	VARCHAR2(1)	CALCULATION CALCULATION CALCULATION	CASE WHEN SFRSTCR_GRDE_CODE CASE WHEN SHRGRDE_ATTEMPTED_IND CASE WHEN SHRTCKG_GRDE_CODE_FINAL CASE WHEN SHRGRDE_ATTEMPTED_IND CASE WHEN SHRTRCE_GRDE_CODE CASE WHEN SHRGRDE_ATTEMPTED_IND
COURSE_IDENTIFICATION	Course ID	Course subject and course number combined.	VARCHAR2(63)	CALCULATION CALCULATION CALCULATION	SFRSTCR_SUBJ_CODE||SFRSTCR_CRSE_NUMB SHRTCKN_SUBJ_CODE||SHRTCKN_CRSE_NUMB SHRTRCE_SUBJ_CODE||SHRTRCE_CRSE_NUMB
COURSE_LEVEL	Course Level	Level of academic study satisfied by this course. For example, undergraduate, graduate, credit, etc.	VARCHAR2(63)	SFRSTCR SHRTATC SHRTCKL SHRTRCE	SFRSTCR_LEVL_CODE SHRTATC_TLVL_CODE SHRTCKL_LEVL_CODE SHRTRCE_LEVL_CODE
COURSE_LEVEL_DESC	Course Level Description	Course level description.	VARCHAR2(255)	STVLEVL	STVLEVL_DESC
COURSE_NUMBER	Course Number	Course number associated with the subject for the course.	VARCHAR2(63)	SHRTCKN SHRTRCE SSBSECT	SHRTCKN_CRSE_NUMB SHRTRCE_CRSE_NUMB SSBSECT_CRSE_NUMB
COURSE_PASSED_IND	Course Passed Ind	Indicates the course section counts as a passed course and the course credits are added to the passed credits based on the final grade assigned to the person.	VARCHAR2(1)	CALCULATION CALCULATION CALCULATION	CASE WHEN SFRSTCR_GRDE_CODE CASE WHEN SHRTCKG_GRDE_CODE_FINAL CASE WHEN SHRTRCE_GRDE_CODE
COURSE_REFERENCE_NUMBER	Course Reference Number	Computer assigned internal unique number for the schedule offering.	VARCHAR2(63)	CALCULATION SFRSTCR SHRTCKN	SHRTRCE_TRIT_SEQ_NO||TO_CHAR(SHRTRCE_TRAM_SEQ_NO,'FM09')||TO_CHAR(NVL(SHRTRCE_TRCR_SEQ_NO,0),'FM009')||TO_CHAR(SHRTRCE_SEQ_NO,'FM009') SFRSTCR_CRN SHRTCKN_CRN
COURSE_REGISTER_IND	Course Registered Ind	Indicates whether the student counts as registered in the course section.	VARCHAR2(1)	STVRSTS	STVRSTS_INCL_SECT_ENRL
COURSE_SECTION_NUMBER	Course Section Number	Sequence number used to associate the information about the unique course for the student.	VARCHAR2(63)	SHRTCKN SHRTRCE SSBSECT	SHRTCKN_SEQ_NUMB SHRTRCE_SEQ_NO SSBSECT_SEQ_NUMB
COURSE_TITLE_LONG	Course Title Long	Long title for the course.	VARCHAR2(255)	FUNCTION SHRTCKN SSRSYLN	SOKODSF.F_GET_CRSE_LONG_TITLE SHRTCKN_LONG_COURSE_TITLE SSRSYLN_LONG_COURSE_TITLE
COURSE_TITLE_SHORT	Course Title Short	Short title for the course.	VARCHAR2(63)	SHRTCKN SHRTRCE SSBSECT	SHRTCKN_CRSE_TITLE SHRTRCE_CRSE_TITLE SSBSECT_CRSE_TITLE
COURSE_VERSION	Course Version	Course version number.	VARCHAR2(255)	NA	NA
CREDITS_ATTEMPTED	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	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)
CREDIT_FOR_GPA_IND	Course Credit For GPA Ind	Indicates the course credits were counted in credits for GPA.	VARCHAR2(1)	CALCULATION CALCULATION CALCULATION	CASE WHEN SFRSTCR_GRDE_CODE CASE WHEN SHRTCKG_GRDE_CODE_FINAL CASE WHEN SHRTRCE_GRDE_CODE
DEGREE_RESTRICT_OVERRIDE_IND	Degree Restrict Override Indicator	Indicates the degree restriction was overridden.	VARCHAR2(1)	CALCULATION	NVL(SFRSTCR_DEGC_OVER,'N')
DEPARTMENT	Department	Department responsible for the major subject area of a student course or associated with the major within the student academic study.	VARCHAR2(63)	SCBCRSE SHRTCKN SSBOVRR	SCBCRSE_DEPT_CODE SHRTCKN_DEPT_CODE SSBOVRR_DEPT_CODE
DEPARTMENT_DESC	Department Description	Department name.	VARCHAR2(255)	STVDEPT	STVDEPT_DESC
DEPARTMENT_RESTRICT_OVER_IND	Department Restrict Over Indicator	Indicates the department restriction was overridden.	VARCHAR2(1)	CALCULATION	NVL(SFRSTCR_DEPT_OVER,'N')
DIVISION	Division	Division responsible for the instructional delivery of this course or section.	VARCHAR2(255)	SCBCRSE SHRTCKN SSBOVRR	SCBCRSE_DIVS_CODE SHRTCKN_DIVS_CODE SSBOVRR_DIVS_CODE
DIVISION_DESC	Division Description	Name of the division.	VARCHAR2(255)	STVDIVS	STVDIVS_DESC
DUPLICATE_COURSE_OVERRIDE_IND	Duplicate Course Override Indicator	Indicates the duplicate course restriction was overridden. Duplicate course means that you are trying to take the exact same course in the same academic period.	VARCHAR2(1)	CALCULATION	NVL(SFRSTCR_DUPL_OVER,'N')
EFF_ACADEMIC_PERIOD_OF_GRADE	Eff Academic Period Of Grade	Earliest academic period for which grade is used.	VARCHAR2(63)	SHRGRDE	SHRGRDE_TERM_CODE_EFFECTIVE
END_DATE	End Date	Date the student completes the coursework in the section. This is either recorded for the individual student in the course or taken from the overall section end date.	DATE	FUNCTION SFRAREG SSBSECT	SOKODSF.F_GET_COURSE_DATES SFRAREG_COMPLETION_DATE SSBSECT_PTRM_END_DATE
EXTENSIONS	Extensions	Number of extensions granted for the student to complete the required work for this section.	NUMBER	FUNCTION SFRAREG	SOKODSF.F_GET_COURSE_EXTENSIONS SFRAREG_EXTENSION_NUMBER
FEEDBACK_DETAIL_EXISTS_IND	Feedback Detail Exists Indicator	Indicates the student has faculty feedback for this feedback session, academic period and course reference number.	VARCHAR2(1)	DECODE OR FUNCTION	DECODE(F.PERSON_UID,NULL,'N','Y')
FINALIZED_COMPLETION_DATE	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	Final grade earned by the student for this course.	VARCHAR2(63)	SFRSTCR SHRTCKG SHRTRCE	SFRSTCR_GRDE_CODE SHRTCKG_GRDE_CODE_FINAL SHRTRCE_GRDE_CODE
FINAL_GRADE_DATE	Final Grade Date	Date associated with this grade.	DATE	SFRSTCR SHRTCKG	SFRSTCR_GRDE_DATE SHRTCKG_FINAL_GRDE_CHG_DATE
FINAL_GRADE_ROLL_IND	Final Grade Roll Indicator	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	Gradable Indicator	Indicates whether the course can be graded.	VARCHAR2(1)	SSBSECT	SSBSECT_GRADABLE_IND
GRADE_CHANGE_COUNT	Grade Change Count	Number of grade changes recorded for this student for this course.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_GRADE_CHANGE
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	Coded comment for why the grade was assigned to this student in this course section.	VARCHAR2(63)	SFRSTCR SHRTCKG	SFRSTCR_GCMT_CODE SHRTCKG_GCMT_CODE
GRADE_COMMENT_DESC	Grade Comment Description	Final grade comment description.	VARCHAR2(255)	STVGCMT	STVGCMT_DESCRIPTION
GRADE_TYPE	Grade Type	Grade mode associated with this CRN.	VARCHAR2(63)	SFRSTCR SHRTCKG	SFRSTCR_GMOD_CODE SHRTCKG_GMOD_CODE
GRADE_TYPE_DESC	Grade Type Description	Grading mode (e.g., pass/fail, audit, normal grading mode) associated with the grading mode code.	VARCHAR2(255)	STVGMOD	STVGMOD_DESC
GRADE_VALUE	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	Hours Attended	Number of hours the student attended this class.	NUMBER	SFRSTCR	SFRSTCR_ATTEND_HR
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	Specifies the latest date the student has to complete any missing course work before they are assigned an incomplete grade for the course.	DATE	SHRTCKG	SHRTCKG_INCOMPLETE_EXT_DATE
INCOMPLETE_GRADE_IND	Incomplete Grade Ind	Indicates the grade is an incomplete grade.	VARCHAR2(1)	CALCULATION CALCULATION CALCULATION	CASE WHEN SFRSTCR_GRDE_CODE CASE WHEN SHRTCKG_GRDE_CODE_FINAL CASE WHEN SHRTRCE_GRDE_CODE
INSTITUTION_COURSE_IND	Institution Course Indicator	Indicates whether the subject or course was taken at this institution and is in academic history.	VARCHAR2(1)	CALCULATION CONSTANT CONSTANT	DECODE(SFRSTCR_PIDM,NULL,'Y','N') 'N' 'Y'
INSTRUCTION_METHOD	Instruction Method	Instructional method used for the section.	VARCHAR2(63)	STVSCHD	STVSCHD_INSM_CODE
INSTRUCTION_METHOD_DESC	Instruction Method Description	Instructional method description associated with the course.	VARCHAR2(255)	GTVINSM	GTVINSM_DESC
INTEGRATION_PARTNER	Integration Partner	Institution defined integration code that identifies an external partner used for instruction of this schedule offering.	VARCHAR2(63)	SSBSECT	SSBSECT_INTG_CDE
INTEGRATION_PARTNER_DESC	Integration Partner Description	Instruction integration partner description.	VARCHAR2(255)	GORINTG	GORINTG_DESC
INTEGRATION_PARTNER_SYSTEM	Integration Partner System	Institution defined integration system code that identifies an external partner systen used for instruction of this schedule offering.	VARCHAR2(63)	GORINTG	GORINTG_INTP_CODE
INTEGRATION_PARTNER_SYS_DESC	Integration Partner System Description	Instruction integration partner system description.	VARCHAR2(255)	GORINTG	GTVINTP_DESC
IN_PROGRESS_COURSE_IND	IN Progress Course Indicator	Indicates whether the course is in progress and not yet graded.	VARCHAR2(1)	CALCULATION CONSTANT	DECODE(SFRSTCR_PIDM,NULL,'N','Y') 'N'
LAST_ATTEND_DATE	Last Attend Date	Identifies the date on which the instruction ended.	DATE	SFRSTCR	SFRSTCR_LAST_ATTEND
LAST_DATE_ATTEND_REQUIRED_IND	Last Date Attended Required Ind	Indicates the last date of attendance is required for the grade.	VARCHAR2(1)	CALCULATION CALCULATION CALCULATION	CASE WHEN SFRSTCR_GRDE_CODE CASE WHEN SHRTCKG_GRDE_CODE_FINAL CASE WHEN SHRTRCE_GRDE_CODE
LEVEL_RESTRICT_OVERRIDE_IND	Level Restrict Override Indicator	Indicates the student level restriction was overridden.	VARCHAR2(1)	CALCULATION	NVL(SFRSTCR_LEVL_OVER,'N')
LINK_OVERRIDE_IND	Link Override Indicator	Indicates the corequisite restriction was overridden. Corequisite means that two courses are normally taken together. For example, a physics and a math class.	VARCHAR2(1)	CALCULATION	NVL(SFRSTCR_LINK_OVER,'N')
MAJOR_RESTRICT_OVERRIDE_IND	Major Restrict Override Indicator	Indicates the major restriction was overridden.	VARCHAR2(1)	CALCULATION	NVL(SFRSTCR_MAJR_OVER,'N')
MID_TERM_GRADE	Mid Academic Period Grade	Mid-term grade code associated with this CRN.	VARCHAR2(63)	SFRSTCR	SFRSTCR_GRDE_CODE_MID
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
MUTUTAL_EXCLUSION_OVERRIDE_IND	Mututal Exclusion Override Indicator	Indicates the mutual exclusion restriction was overridden.	VARCHAR2(1)	CALCULATION	NVL(SFRSTCR_MEXC_OVER,'N')
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	SFRSTCR	SFRSTCR_PIDM
PREREQUISITE_OVERRIDE_IND	Prerequisite Override Indicator	Indicates the prerequisite restriction was overridden. Prerequisite means that one course is required prior to taking another course.	VARCHAR2(1)	CALCULATION	NVL(SFRSTCR_PREQ_OVER,'N')
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PROGRAM_RESTRICT_OVERRIDE_IND	Program Restrict Override Indicator	Indicates the program restriction was overridden.	VARCHAR2(1)	CALCULATION	NVL(SFRSTCR_PROG_OVER,'N')
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)
REGISTER_CENSUS_DATE1_IND	Register by Census Date 1	Indicates a registration course status that identifies the person counts in the course section headcount was recorded prior to the census date.	VARCHAR2(1)	CALCULATION	CASE WHEN SSBSECT_CENSUS_ENROLL
REGISTER_CENSUS_DATE2_IND	Registered by Census Date 2	Indicates a registration course status that identifies the person counts in the course section headcount was recorded prior to the census date 2.	VARCHAR2(1)	CALCULATION	CASE WHEN SSBSECT_CENSUS_2_DATE
REGISTRATION_ACT_DATE	Registration Activity Date	This identifies the activity date of the registration request.	DATE	SFRSTCR	SFRSTCR_ACTIVITY_DATE
REGISTRATION_ERROR_FLAG	Registration Error Indicator	Indicates an error is associated with this section registration.	VARCHAR2(1)	SFRSTCR	SFRSTCR_ERROR_FLAG
REGISTRATION_OVERRIDE_IND	Registration Override Indicator	Indicates this person required an override to get into this course section.	VARCHAR2(1)	CALCULATION FUNCTION	CASE STATEMENT TO BE FILLED IN BY DEVELOPER
REGISTRATION_SEQUENCE_NUMBER	Registration Sequence Number	Sequence number system assigned to the student registration in the section.	NUMBER	SFRSTCR SHRTCKN	SFRSTCR_REG_SEQ SHRTCKN_REG_SEQ
REGISTRATION_STATUS	Registration Status	Course registration status associated with this section.	VARCHAR2(63)	SFRSTCR	SFRSTCR_RSTS_CODE
REGISTRATION_STATUS_DATE	Registration Status Date	Date associated with the course registration status of this section.	DATE	SFRSTCR	SFRSTCR_RSTS_DATE
REGISTRATION_STATUS_DESC	Registration Status Description	Course registration status description.	VARCHAR2(255)	STVRSTS	STVRSTS_DESC
REGISTRATION_USER_ID	Registration User ID	Person user identification number who processed the registration request for this section.	VARCHAR2(63)	SFRSTCR	SFRSTCR_USER
REPEAT_COURSE_CREDIT_OVER_IND	Repeat Course Credit Over Indicator	Indicates the repeat course maximum credit restriction was overridden.	VARCHAR2(1)	CALCULATION	NVL(SFRSTCR_RPTH_OVER,'N')
REPEAT_COURSE_IND	Repeat Course Indicator	Student courses that are graded, rolled to history are checked to identify any that appear in more than one academic period for the student. When the repeat process is run, the valid values will be null or blank when course has not been repeated or 'E' exclude in any calculations, 'I' include in all calculations, or 'A' average in all calculations when the course has been repeated.	VARCHAR2(1)	SHRTCKN	SHRTCKN_REPEAT_COURSE_IND
REPEAT_COURSE_OVERRIDE_IND	Repeat Course Override Indicator	Indicates the repeat course restriction was overridden.	VARCHAR2(1)	CALCULATION	NVL(SFRSTCR_REPT_OVER,'N')
REPEAT_EVALUATE_IND	Repeat Evaluate Ind	Indicates this grade should be considered in the repeat process when running the repeat process.	VARCHAR2(1)	CALCULATION CALCULATION CALCULATION	CASE WHEN SFRSTCR_GRDE_CODE CASE WHEN SHRTCKG_GRDE_CODE_FINAL CASE WHEN SHRTRCE_GRDE_CODE
SCHEDULE_TYPE	Schedule Type	Instructional method or delivery type associated with the course.	VARCHAR2(63)	SHRTCKN SSBSECT	SHRTCKN_SCHD_CODE SSBSECT_SCHD_CODE
SCHEDULE_TYPE_DESC	Schedule Type Description	Schedule type description.	VARCHAR2(255)	STVSCHD	STVSCHD_DESC
SECTION_ADD_DATE	Section Add Date	Date the student registered in this section.	DATE	SFRSTCR	SFRSTCR_ADD_DATE
SPECIAL_APPROVAL_IND	Special Approval Indicator	Indicates whether special approval was received to register in this section.	VARCHAR2(1)	SFRSTCR	SFRSTCR_APPR_RECEIVED_IND
SPECIAL_APPROVAL_OVERRIDE_IND	Special Approval Override Indicator	Indicates the special approval for this class was overridden.	VARCHAR2(1)	CALCULATION	NVL(SFRSTCR_APPR_OVER,'N')
START_DATE	Start Date	Date the instruction for this course began for this student. This is either recorded for the individual student in the course or taken from the overall section begin date.	DATE	FUNCTION SFRAREG	SOKODSF.F_GET_COURSE_DATES SFRAREG_START_DATE
STUDENT_ATTRIBUTE_OVERRIDE_IND	Student Attribute Override Indicator	Indicates the student attribute restriction was overridden.	VARCHAR2(1)	CALCULATION	NVL(SFRSTCR_ATTS_OVER,'N')
STUDENT_COHORT_OVERRIDE_IND	Student Cohort Override Indicator	Indicates the student cohort restriction was overridden.	VARCHAR2(1)	CALCULATION	NVL(SFRSTCR_CHRT_OVER,'N')
STUDY_PATH_SEQUENCE	Study Path Sequence	Sequence number of the study path for which the course reference number is registered.	NUMBER	SFRSTCR	SFRSTCR_STSP_KEY_SEQUENCE
SUBJECT	Subject	Main instructional subject area for this course.	VARCHAR2(63)	SHRTCKN SHRTRCE SSBSECT	SHRTCKN_SUBJ_CODE SHRTRCE_SUBJ_CODE SSBSECT_SUBJ_CODE
SUBJECT_DESC	Subject Description	Subject code description.	VARCHAR2(255)	STVSUBJ	STVSUBJ_DESC
SUB_ACADEMIC_PERIOD	Sub Academic Period	A session, portion or part of the academic period.	VARCHAR2(63)	SFRSTCR SHRTCKN	SFRSTCR_PTRM_CODE SHRTCKN_PTRM_CODE
SUB_ACADEMIC_PERIOD_DESC	Sub Academic Period Description	Sub academic period description.	VARCHAR2(255)	STVPTRM	STVPTRM_DESC
TEST_SCORE_OVERRIDE_IND	Test Score Override Indicator	Indicates the test score restriction was overridden.	VARCHAR2(1)	CALCULATION	NVL(SFRSTCR_TEST_OVER,'N')
TIME_CONFLICT_OVERRIDE_IND	Time Conflict Override Indicator	Indicates the time conflict restriction was overridden. Time conflict means that you can have two courses scheduled at the same time.	VARCHAR2(1)	CALCULATION	NVL(SFRSTCR_TIME_OVER,'N')
TRADITIONAL_IND	Traditional Indicator	Indicates whether this grade symbol is considered a traditional type of grade.	VARCHAR2(1)	SHRGRDE	SHRGRDE_TRADITIONAL_IND
TRANSFER_COURSE_IND	Transfer Course Indicator	Indicates whether this course was taken at and transferred from another post secondary institution.	VARCHAR2(1)	CALCULATION	DECODE(SHRTRCE_PIDM,NULL,'N','Y')
TRANSFER_COURSE_INSTITUTION	Transfer Course Institution	Identifies the post secondary institution where the transfer course was taken.	VARCHAR2(255)	SHRTRIT	SHRTRIT_SBGI_CODE
TRANSFER_COURSE_INST_DESC	Transfer Course Inst Description	Name of the post secondary transfer institution.	VARCHAR2(255)	STVSBGI	STVSBGI_DESC
WAITLIST_AVAILABLE	WAITLIST AVAILABLE	It displays a running total of remaining available waitlist seats by subtracting the waitlist actual enrollment from the maximum waitlist enrollment for the section.	NUMBER	SSBSECT	SSBSECT_WAIT_AVAIL
WAITLIST_CAPACITY	WAITLIST CAPACITY	This field stores the maximum waitlist enrollment for a section.	NUMBER	SSBSECT	SSBSECT_WAIT_CAPACITY
WAITLIST_COUNT	WAITLIST COUNT	It displays a running total of enrollments in the section which have course status with a waitlist flag set to Y on the Registration Status Code Validation Form - STVRSTS.	NUMBER	SSBSECT	SSBSECT_WAIT_COUNT
WAITLIST_IND	Waitlist Ind	Indicates the student is waitlisted for the course.	VARCHAR2(1)	STVRSTS	STVRSTS_WAIT_IND
WAITLIST_PRIORITY	WAITLIST PRIORITY	This field indicates the Waitlist priority.	NUMBER	SFRSTCR	SFRSTCR_WL_PRIORITY
WAITLIST_PRIORITY_ORIG	WAITLIST PRIORITY ORIGIN	This field indicates the waitlist priority origin. Valid values are S-system originated, M-manually originated.	VARCHAR2(1)	SFRSTCR	SFRSTCR_WL_PRIORITY_ORIG
WITHDRAWN_IND	Withdrawn Ind	Indicates whether the associated course registration validation code denotes a student's withdrawal from a section.	VARCHAR2(1)	STVRSTS	STVRSTS_WITHDRAW_IND

Ver: 9.2