RETURN TO STUDENT META DATA REPORTS

SCHEDULE_OFFERING - Report
Data Element Business Definition Data Type Source Name Source Data Element Form Name
ACADEMIC_YEAR ACADEMIC YEAR ASSOCIATED THIS RECORD. STVTERM STVTERM_ACYR_CODE UNKNOWN
ACADEMIC_YEAR_DESC DESCRIPTION OF THE ACADEMIC YEAR ASSOCIATED WITH THIS RECORD. STVACYR STVACYR_DESC UNKNOWN
ACADEMIC_PERIOD IDENTIFIES THE ACADEMIC PERIOD OR TERM ASSOCIATED WITH THIS INFORMATION. SSBSECT SSBSECT_TERM_CODE UNKNOWN
ACADEMIC_PERIOD_DESC DESCRIPTION OF THE ACADEMIC PERIOD ASSOCIATED THIS RECORD. STVTERM STVTERM_DESC UNKNOWN
SUB_ACADEMIC_PERIOD IDENTIFIES THE SUB ACADEMIC PERIOD OR PART OF TERM ASSOCIATED WITH THE INFORMATION. SSBSECT SSBSECT_PTRM_CODE UNKNOWN
SUB_ACADEMIC_PERIOD_DESC DESCRIPTION OF THE SUB ACADEMIC PERIOD OR SESSION. STVPTRM STVPTRM_DESC UNKNOWN
START_DATE DATE THE SKILL WAS LEARNED. SSBSECT SSBSECT PTRM START DATE UNKNOWN
END_DATE DATE THE SKILL WAS ENDED. SSBSECT SSBSECT PTRM END DATE UNKNOWN
DURATION P FOR PERMANENT OR T FOR TEMPORARY. OLR ? UNKNOWN
DURATION_UNITS SPECIFIES THE NUMBER OF DURATION UNITS FOR THIS OFFERING. (E.G. 10 WOULD BE MULTIPLIED BY DURATION UNIT ABOVE (WEEKS) TO CALCULATE INSTRUCTION IS 10 WEEKS LONG.) OLR ? UNKNOWN
EXTENSIONS_PERMITTED SPECIFIES THE NUMBER OF EXTENSIONS PERMITTED TO A STUDENT BEYOND THE NORMAL END DATE FOR THE INSTRUCTION. OLR ? UNKNOWN
EXTENSIONS_MAX_DATE SPECIFIES THE LATEST DATE FOR INSTRUCTION AS CALCULATED BY AN EXTENSION GRANTED TO A STUDENT. OLR ? UNKNOWN
REGISTRATION_START_DATE EARLIEST DATE ON WHICH A STUDENT MAY ENROLL IN THIS OFFERING. OLR ? UNKNOWN
REGISTRATION_END_DATE LATEST DATE ON WHICH A STUDENT MAY ENROLL AND START INSTRUCTION FOR THIS OFFERING. OLR ? UNKNOWN
COURSE_IDENTIFICATION COURSE SUBJECT AND COURSE NUMBER COMBINED FUNCTION ? UNKNOWN
SUBJECT SUBJECT CODE THAT THE ATTRIBUTE IS ASSOCIATED WITH SCBCRSE SCBCRSE_SUBJ_CODE UNKNOWN
SUBJECT_DESC HIGH SCHOOL SUBJECT DESCRIPTION STVSUBJ STVSUBJ_DESC UNKNOWN
COURSE_NUMBER COURSE NUMBER PORTION OF THIS SUBJECT IDENTIFICATION. SCBCRSE SCBCRSE_CRSE_NUMBER UNKNOWN
COURSE_VERSION IDENTIFIES THE COURSE VERSION NUMBER. NA NOT AVAILABLE UNKNOWN
COURSE_REFERENCE_NUMBER COURSE REFERENCE NUMBER. SSBSECT SSBSECT_CRN UNKNOWN
OFFERING_NUMBER SSBSECT NOT AVAILABLE UNKNOWN
ACTIVE_OFFERING_IND INDICATES THIS SCHEDULE OFFERING CAN HAVE STUDENTS ENROLLING. FUNCTION F_ACTIVE_SECTION_IND UNKNOWN
STATUS STATUS OF THE ACADEMIC OUTCOME AND IDENTIFIES THOSE OUTCOMES THAT ARE PENDING OR AWARDED. SSBSECT SSBSECT_SSTS_CODE UNKNOWN
STATUS_DESC DESCRIPTION FOR THE STATUS CODE . STVSSTS STVSSTS_DESC UNKNOWN
COURSE_CLASS_LEVEL NORMAL YEAR IN SCHOOL FOR STUDENT WHO TAKE THIS CLASS (FIRST YEAR, SECOND YEAR, ETC.). ETL PROCESSING MIGHT BE MODIFIED TO PULL INFORMATION AS DEFINED BY THE INSTITUTION IF APPROPRIATE OTHERWISE NOT POPULATED. NA NOT AVAILABLE UNKNOWN
COURSE_CLASS_LEVEL_DESC INSTITUTIONAL DESCRIPTION OF THE YEAR IN SCHOOL. STVATTR STVATTR_DESC UNKNOWN
NON_TRADITIONAL_IND INDICATES IF THIS ACADEMIC STUDY IS OR IS NOT A TRADITIONAL TYPE OF STUDY. (E.G. NON-DEGREE GRANTING OR ACCELERATED.) NA NOT AVAILABLE UNKNOWN
TITLE_SHORT_DESC DISPLAYS THE SHORT TITLE OF THE COURSE. SCBCRSE SCBCRSE_TITLE UNKNOWN
TITLE_LONG_DESC DISPLAYS THE LONG TITLE OF THE COURSE. SHRTCKN SHRTCKN_LONG_COURSE_TITLE UNKNOWN
MIN_CREDITS THIS FIELD IS USED TO SPECIFY THE MINIMUM NUMBER OF CREDIT HOURS FOR WHICH A COURSE MAY BE OFFERED. SSBSECT SSBSECT_CREDIT_HRS UNKNOWN
MAX_CREDITS THIS FIELD IS USED EITHER TO DEFINE A SECOND VALID CREDIT HOUR VALUE OR TO DEFINE THE HIGH CREDIT HOUR VALUE WITHIN A RANGE. SSBSECT SSBSECT_CREDIT_HRS UNKNOWN
TOTAL_CREDITS THIS FIELD IS SYSTEM MAINTAINED. IT WILL DISPLAY A RUNNING TOTAL OF ALL ENROLLED CREDIT HOURS IN THE OFFERING. SSBSECT SSBSECT_TOT_CREDIT_HRS UNKNOWN
MIN_BILLING THIS FIELD IS USED TO SPECIFY THE MINIMUM NUMBER OF BILLING HOURS FOR WHICH A COURSE MAY BE OFFERED. SSBSECT SSBSECT_BILL_HRS UNKNOWN
MAX_BILLING THIS FIELD IS USED EITHER TO DEFINE A SECOND VALID BILLING HOUR VALUE OR TO DEFINE THE HIGH BILLING HOUR VALUE WITHIN A RANGE. SSBSECT SSBSECT_BILL_HRS UNKNOWN
MIN_LECTURE_HOURS THIS FIELD IS USED TO SPECIFY THE MINIMUM NUMBER OF LECTURE HOURS FOR WHICH A COURSE MAY BE OFFERED. SSBSECT SSBSECT_LAB_HRS UNKNOWN
MAX_LECTURE_HOURS THIS FIELD IS USED EITHER TO DEFINE A SECOND VALID LECTURE HOUR VALUE OR TO DEFINE THE HIGH LECTURE HOUR VALUE WITHIN A RANGE. SSBSECT SSBSECT_LAB_HRS UNKNOWN
MIN_LAB_HOURS THIS FIELD IS USED TO SPECIFY THE MINIMUM NUMBER OF LAB HOURS FOR WHICH A COURSE MAY BE OFFERED. SSBSECT SSBSECT_LAB_HRS UNKNOWN
MAX_LAB_HOURS THIS FIELD IS USED EITHER TO DEFINE A SECOND VALID LAB HOUR VALUE OR TO DEFINE THE HIGH LAB HOUR VALUE WITHIN A RANGE. SSBSECT SSBSECT_LAB_HRS UNKNOWN
MIN_OTHER_HOURS DEFINES THE MINIMUM NUMBER OF NON LECTURE AND NON LAB CONTACT HOURS FOR THIS COURSE. SSBSECT SSBSECT_OTH_HRS UNKNOWN
MAX_OTHER_HOURS DEFINES THE MAXIMUM NUMBER OF NON LECTURE AND NON LAB CONTACT HOURS FOR THIS COURSE. SSBSECT SSBSECT_OTH_HRS UNKNOWN
MIN_CONTACT_HOURS THIS FIELD IS USED TO SPECIFY THE MINIMUM NUMBER OF CONTACT HOURS FOR WHICH A COURSE MAY BE OFFERED. SSBSECT SSBSECT_CONT_HRS UNKNOWN
MAX_CONTACT_HOURS THIS FIELD IS USED EITHER TO DEFINE A SECOND VALID CONTACT HOUR VALUE OR TO DEFINE THE HIGH CONTACT HOUR VALUE WITHIN A RANGE. SSBSECT SSBSECT_CONT_HRS UNKNOWN
REGISTRATION_PERMIT_IND SPECIFIES WHETHER OR NOT REGISTRATION FOR THE OFFERING CAN BE OFFERED. OLR ? UNKNOWN
CAMPUS IDENTIFIES THE CAMPUS ASSOCIATED WITH THE RECORD. SSBSECT SSBSECT_CAMP_CODE UNKNOWN
CAMPUS_DESC NAME OF THE CAMPUS ASSOCIATED WITH THE RECORD. STVCAMP STVCAMP_DESC UNKNOWN
SCHEDULE "TEACHING METHOD FOR THE INSTRUCTION IN THIS SCHEDULED OFFERING. EXAMPLES MAY INCLUDE LECTURE, LAB, INTERNET, ETC.." SSBSECT SSBSECT_SCHD_CODE UNKNOWN
SCHEDULE_DESC DESCRIPTION OF THE SCHEDULE OR INSTRUCTION TYPE FOR A COURSE. STVSCHD STVSCHD_DESC UNKNOWN
SCHEDULE_COUNT NUMBER OF SCHEDULE TYPES OR INSTRUCTIONAL MODES ASSOCIATED WITH THE COURSE. FUNCTION F_STUDENT_CHECK_FOR_MORE UNKNOWN
GRADE_TYPE_COUNT NUMBER OF GRADE SCHEMES ASSOCIATED WITH THE SCHEDULE OFFERING. THIS WILL EITHER BE ONE IF SPECIFIED ON THE SECTION FUNCTION ? UNKNOWN
GRADABLE_IND THIS FIELD IS USED TO SPECIFY WHETHER OR NOT THE OFFERING IS GRADABLE. IT IS A REQUIRED FIELD AND Y - YES SSBSECT SSBSECT_GRADABLE_IND UNKNOWN
ACADEMIC_PERIOD_WEEKS NUMBER OF WEEKS OF INSTRUCTION IN THIS ACADEMIC PERIOD AND SUB ACADEMIC PERIOD. SSBSECT SSBSECT_PTRM_WEEKS UNKNOWN
SPECIAL_APPROVAL THIS FIELD CAN BE USED TO SPECIFY THE TYPE OF SPECIAL APPROVAL A STUDENT MUST HAVE TO REGISTER. SSBSECT SSBSECT_SAPR_CODE UNKNOWN
SPECIAL_APPROVAL_DESC DESCRIPTION FOR THE SPECIAL APPROVAL TYPE REQUIRED. STVSAPR STVSAPR_DESC UNKNOWN
CENSUS_ENROLLMENT1 THIS FIELD IS SYSTEM MAINTAINED. IT WILL DISPLAY THE RUNNING TOTAL OF STUDENTS REGISTERED FOR THE OFFERING PRIOR TO THE CENSUS DATE DEFINED FOR THE PART OF ACADEMIC PERIOD. SSBSECT SSBSECT_CENSUS_ENRL UNKNOWN
CENSUS_ENROLLMENT_DATE1 THIS FIELD IS DEFINED IN THE CENSUS FIELD. SSBSECT SSBSECT_CENSUS_ENRL_DATE UNKNOWN
CENSUS_ENROLLMENT2 THIS FIELD IS SYSTEM MAINTAINED. IT WILL DISPLAY THE RUNNING TOTAL OF STUDENTS REGISTERED FOR THE OFFERING PRIOR TO THE CENSUS DATE DEFINED FOR THE PART OF ACADEMIC PERIOD. SSBSECT SSBSECT_CENSUS_ENRL UNKNOWN
CENSUS_ENROLLMENT_DATE2 THIS FIELD IS DEFINED IN THE CENSUS FIELD. SSBSECT SSBSECT_CENSUS_ENRL_DATE UNKNOWN
TARGET_ENROLLMENT SSBSECT ? UNKNOWN
MINIMUM_ENROLLMENT THIS FIELD IS USED TO SET THE MINIMUM ENROLLMENT FOR AN OFFERING. NA NOT AVAILABLE UNKNOWN
MAXIMUM_ENROLLMENT THIS FIELD IS USED TO SET THE MAXIMUM ENROLLMENT FOR AN OFFERING. WHEN THE CAPACITY SEVERITY SWITCH IS SET TO W OR F. SSBSECT SSBSECT_MAX_ENRL UNKNOWN
ACTUAL_ENROLLMENT DISPLAYS A RUNNING TOTAL OF ENROLLMENTS IN THE OFFERING THAT IS SYSTEM MAINTAINED. SSBSECT SSBSECT_ENRL UNKNOWN
GENERATED_CREDITS THIS FIELD IS THE NUMBER OF ENROLLED STUDENTS TIMES THE NUMBER OF CREDITS THE OFFERING IS WORTH. FUNCTION ? UNKNOWN
PRIOR_ENROLLMENT THIS FIELD IS SYSTEM MAINTAINED. IT IS USED TO CREATE OFFERING ENTRIES BASED ON A PREVIOUS ACADEMIC PERIOD'S OFFERINGS SSBSECT SSBSECT_PRIOR_ENRL UNKNOWN
SEATS_AVAILABLE THIS FIELD IS SYSTEM MAINTAINED. IT WILL DISPLAY A RUNNING TOTAL OF REMAINING AVAILABLE SEATS IN THE OFFERING BY SUBTRACTING THE ACTUAL ENROLLMENT FIELD FROM THE MAXIMUM ENROLLMENT FIELD SSBSECT SSBSECT_SEATS_AVAIL UNKNOWN
OFFERING_COREQ_COUNT NUMBER OF COREQUISITES ASSOCIATED WITH THIS COURSE OFFERING. FUNCTION ? UNKNOWN
OFFERING_PREREQ_COUNT NUMBER OF PREREQUISITES ASSOCIATED WITH THIS COURSE OFFERING. FUNCTION ? UNKNOWN
LINK_IDENTIFIER SSBSECT NOT AVAILABLE UNKNOWN
COLLEGE FIRST LAYER OF THE INSTITUTION ORGANIZATION. SSBOVRR SSBOVRR_COLL_CODE UNKNOWN
COLLEGE_DESC NAME OF THE FIRST LAYER (COLLEGE) OF THE INSTITUTION ORGANIZATION. STVCOLL STVCOLL_DESC UNKNOWN
DIVISION SECOND LAYER OF THE INSTITUTION ORGANIZATION. SSBOVRR SSBOVRR_DIVS_CODE UNKNOWN
DIVISION_DESC NAME OF THE SECOND LAYER (DIVISION) OF THE INSTITUTION ORGANIZATION. STVDIVS STVDIVS_DESC UNKNOWN
DEPARTMENT SYSTEM GENERATED NUMBER THAT IS INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON. SSBOVRR SSBOVRR_DEPT_CODE UNKNOWN
DEPARTMENT_DESC NAME OF THE THIRD LAYER (DEPARTMENT) OF THE INSTITUTION ORGANIZATION. STVDEPT STVDEPT_DESC UNKNOWN
STUDENT_MEETING_TIME SESSION OF THE STUDENT'S NORMAL ATTENDANCE. SSBSECT SSBSECT_SESS_CODE UNKNOWN
STUDENT_MEETING_TIME_DESC DESCRIPTION FOR THE STUDENT'S SESSION (E.G. DAY, EVENING, WEEKEND, ETC.). STVSESS STVSESS_DESC UNKNOWN
PRIMARY_INSTRUCTOR_ID PERSON'S ID NUMBER USED TO ACCESS THE RECORDS ASSOCIATED WITH THE PERSON SPRIDEN SPRIDEN_ID UNKNOWN
PRIMARY_INSTRUCTOR_FIRST_NAME PERSON'S FIRST OR GIVEN NAME. SPRIDEN SPRIDEN_FIRST_NAME UNKNOWN
PRIMARY_INSTRUCTOR_LAST_NAME PERSON'S LAST NAME OR SURNAME. SPRIDEN SPRIDEN_LAST_NAME UNKNOWN
PERCENTAGE_OF_RESPONSIBILITY SPECIFIES THE PERCENTAGE OF RESPONSIBILITY FOR THE OFFERING FOR THE INSTRUCTOR. SIRASGN SIRASGN_PERCENT_RESP UNKNOWN
GRADE_TYPE DISPLAYS VALUE WHEN ONLY ONE GRADING MODE IS AVAILABLE FOR THIS OFFERING. FOR EXAMPLE, ONLY LETTER GRADES OR ONLY PASS/FAIL OPTION? SSBSECT SSBSECT_GRADE_MODE UNKNOWN
GRADE_TYPE_DESC DESCRIPTION OF THE DEFAULT GRADING TYPE (E.G. PASS/FAIL, LETTER, NUMERIC). STVGMOD STVGMOD_DESC UNKNOWN
INSTRUCTOR_COUNT SPECIFIES THE NUMBER OF INSTRUCTORS FOR THIS COURSE. FUNCTION ? UNKNOWN
MEETING_TIME_COUNT NUMBER OF MEETING TIMES FOR A GIVEN OFFERING. FUNCTION ? UNKNOWN
ATTRIBUTE_COUNT NUMBER OF ATTRIBUTES ASSOCIATED WITH THE PERSON AS A FACULTY MEMBER. MSKFUNC F_COUNT_COURSE_ATTRIBUTES UNKNOWN