Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Student Reporting View Reports

Banner Operational Data Store
Reporting View Target: STUDENT_COURSE

Description Contains detail data for student courses recorded in the system. Courses taken by the student may be registered (in progress course), graded (institutional history), and transferred (transfer credit granted) courses. This reporting view shows all courses associated with the student in a single reporting view. Indicators permit the report user to identify groupings of courses for selected reporting needs.
Key & Frequency One row per person per academic period per course reference number.
Recommended Search Columns PERSON_UID, ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER, IN_PROGRESS_COURSE_IND
PERSON_UID, TRANSFER_COURSE_IND
PERSON_UID, ACADEMIC_PERIOD, INSTITUTION_COURSE_IND
ACADEMIC_PERIOD
PERSON_UID, ACADEMIC_PERIOD, COURSE_LEVEL
PERSON_UID, COURSE_IDENTIFICATION
PERSON_UID, ACADEMIC_PERIOD, COURSE_IDENTIFICATION
COURSE_IDENTIFICATION, ACADEMIC_PERIOD
GRADE_VALUE, ACADEMIC_PERIOD

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