Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
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)
|
SSBSECT
|
SSBSECT_TERM_CODE
|
NO
|
NO
|
ACADEMIC_PERIOD_DESC
|
Academic period description.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
NO
|
NO
|
ACADEMIC_PERIOD_WEEKS
|
Number of weeks associated with this academic period. For example, 16 week semester, 10 week quarter, etc.
|
NUMBER
|
SSBSECT
|
SSBSECT_PTRM_WEEKS
|
NO
|
NO
|
ACADEMIC_YEAR
|
Academic year associated with the academic period on this record.
|
VARCHAR2(63)
|
STVTERM
|
STVTERM_ACYR_CODE
|
NO
|
NO
|
ACADEMIC_YEAR_DESC
|
Academic year description.
|
VARCHAR2(255)
|
STVACYR
|
STVACYR_DESC
|
NO
|
NO
|
ACCOUNTING_METHOD
|
Accounting method used for tracking attendance either weekly or daily.
|
VARCHAR2(63)
|
SSBSECT
|
SSBSECT_ACCT_CODE
|
NO
|
NO
|
ACCOUNTING_METHOD_DESC
|
Accounting method description for this course.
|
VARCHAR2(255)
|
STVACCT
|
STVACCT_DESC
|
NO
|
NO
|
ACTIVE_OFFERING_IND
|
Indicates whether the section or schedule offering is active and may have students registered.
|
VARCHAR2(1)
|
FUNCTION
|
F_ACTIVE_SECTION_IND
|
NO
|
NO
|
ACTUAL_ENROLLMENT
|
Total number of students enrolled in this schedule offering. The students counting in the actual enrollment have a course status defined to count as enrolled.
|
NUMBER
|
SSBSECT
|
SSBSECT_ENRL
|
NO
|
NO
|
ADMINISTRATIVE_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
ASSIGNMENT_TYPE
|
Faculty Assignment Type Code
|
VARCHAR2(63)
|
SIRASGN
|
SIRASGN_ASTY_CODE
|
NO
|
NO
|
ASSIGNMENT_TYPE_DESC
|
Faculty Assignment Type Code Description
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
ATTRIBUTE_COUNT
|
Count of course degree attributes recorded for the section or schedule offering.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_COURSE_ATTRIBUTES
|
NO
|
NO
|
CAMPUS
|
Campus associated with this record. Campus for the course section, student course, student, applied for on the admission application, etc.
|
VARCHAR2(63)
|
SSBSECT
|
SSBSECT_CAMP_CODE
|
NO
|
NO
|
CAMPUS_DESC
|
Institution campus name.
|
VARCHAR2(255)
|
STVCAMP
|
STVCAMP_DESC
|
NO
|
NO
|
CATEGORY
|
The session indicator associated with the assignment.
|
VARCHAR2(2)
|
SIRASGN
|
SIRASGN_CATEGORY
|
NO
|
NO
|
CENSUS_ENROLLMENT1
|
Total of students registered and counted in enrollment for the section or schedule offering through the defined census date.
|
NUMBER
|
SSBSECT
|
SSBSECT_CENSUS_ENRL
|
NO
|
NO
|
CENSUS_ENROLLMENT2
|
Total of students registered and counted in enrollment for the section or schedule offering through the second defined census date.
|
NUMBER
|
SSBSECT
|
SSBSECT_CENSUS_2_ENRL
|
NO
|
NO
|
CENSUS_ENROLLMENT_DATE1
|
First date used for official enrollment reporting in a time frame. All student registration through this date is counted in the census one enrollment count.
|
DATE
|
SSBSECT
|
SSBSECT_CENSUS_ENRL_DATE
|
NO
|
NO
|
CENSUS_ENROLLMENT_DATE2
|
Second date used for official enrollment reporting in a time frame. All student registration through this date is counted in the census two enrollment count.
|
DATE
|
SSBSECT
|
SSBSECT_CENSUS_2_DATE
|
NO
|
NO
|
COLLEGE
|
First level of the institution organization structure that owns the student or the academic instruction for a student course.
|
VARCHAR2(63)
|
SSBOVRR
|
SSBOVRR_COLL_CODE
|
NO
|
NO
|
COLLEGE_DESC
|
College, faculty or school name.
|
VARCHAR2(255)
|
STVCOLL
|
STVCOLL_DESC
|
NO
|
NO
|
COURSE_CLASS_LEVEL
|
Expected class (first year, second year, etc.) the enrollee is in when taking the course.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
COURSE_CLASS_LEVEL_DESC
|
Class level code description.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
COURSE_IDENTIFICATION
|
Course subject and course number combined.
|
VARCHAR2(255)
|
CALCULATION
|
SSBSECT_SUBJ_CODE||SSBSECT_CRSE_NUMB
|
NO
|
NO
|
COURSE_NUMBER
|
Course number associated with the subject for the course.
|
VARCHAR2(63)
|
SCBCRSE SSBSECT
|
SCBCRSE_CRSE_NUMB SSBSECT_CRSE_NUMB
|
NO NO
|
NO
|
COURSE_REFERENCE_NUMBER
|
Computer assigned internal unique number for the schedule offering.
|
VARCHAR2(5)
|
SSBSECT
|
SSBSECT_CRN
|
NO
|
NO
|
COURSE_TEXT_NARRATIVE
|
Text developed at the institution to describe the course and course content.
|
VARCHAR2(4000)
|
SSBDESC
|
SSBDESC_TEXT_NARRATIVE
|
NO
|
NO
|
COURSE_VERSION
|
Course version number.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
CROSS_LIST_ACTIVITY_DATE
|
Date record was inserted or updated.
|
DATE
|
SSBXLST
|
SSBXLST_ACTIVITY_DATE
|
NO
|
NO
|
CROSS_LIST_ENROLLMENT
|
Cross list section enrollment.
|
NUMBER
|
SSBXLST
|
SSBXLST_ENRL
|
NO
|
NO
|
CROSS_LIST_MAXIMUM_ENROLLMENT
|
Maximum seats available within any of the sections within a cross list code.
|
NUMBER
|
SSBXLST
|
SSBXLST_MAX_ENRL
|
NO
|
NO
|
CROSS_LIST_SEATS_AVAILABLE
|
Seats available for the sections within the cross list code.
|
NUMBER
|
SSBXLST
|
SSBXLST_SEATS_AVAIL
|
NO
|
NO
|
DEPARTMENT
|
Department responsible for the major subject area of a student course or associated with the major within the student academic study.
|
VARCHAR2(63)
|
SSBOVRR
|
SSBOVRR_DEPT_CODE
|
NO
|
NO
|
DEPARTMENT_DESC
|
Department name.
|
VARCHAR2(255)
|
STVDEPT
|
STVDEPT_DESC
|
NO
|
NO
|
DIVISION
|
Division responsible for the instructional delivery of this course or section.
|
VARCHAR2(63)
|
SSBOVRR
|
SSBOVRR_DIVS_CODE
|
NO
|
NO
|
DIVISION_DESC
|
Name of the division.
|
VARCHAR2(255)
|
STVDIVS
|
STVDIVS_DESC
|
NO
|
NO
|
DURATION
|
Indicates whether the course duration is in days, weeks, months, etc.
|
VARCHAR2(255)
|
SSBSECT
|
SSBSECT_DUNT_CODE
|
NO
|
NO
|
DURATION_UNITS
|
Indicates whether the course duration is in days, weeks, months, etc.
|
NUMBER
|
SSBSECT
|
SSBSECT_DUNT_CODE
|
NO
|
NO
|
END_DATE
|
End date for the section record.
|
DATE
|
SSBSECT
|
SSBSECT_PTRM_END_DATE
|
NO
|
NO
|
EXEMPT_TUITION_SECTION
|
Specifies this section is exempt from the assessment of tuition and fee rules and only incurs any section fee charges.
|
VARCHAR2(63)
|
SSBSECT
|
SSBSECT_TUIW_IND
|
NO
|
NO
|
EXTENSIONS_MAX_DATE
|
Latest date for instruction as calculated by an extension granted to a student.
|
DATE
|
NA
|
NA
|
NO
|
NO
|
EXTENSIONS_PERMITTED
|
Number of extensions permitted to a student beyond the normal end date for the instruction.
|
NUMBER
|
SSBSECT
|
SSBSECT_NUMBER_OF_EXTENSIONS
|
NO
|
NO
|
GENERATED_CREDITS
|
Number of enrolled students multiplied by the number of credits the offering is worth.
|
NUMBER
|
NA SSBSECT
|
NA SSBSECT_TOT_CREDIT_HRS
|
NO NO
|
NO
|
GRADABLE_IND
|
Indicates whether the course can be graded.
|
VARCHAR2(1)
|
SSBSECT
|
SSBSECT_GRADABLE_IND
|
NO
|
NO
|
GRADE_TYPE
|
Grade type for the course.
|
VARCHAR2(63)
|
SSBSECT
|
SSBSECT_GMOD_CODE
|
NO
|
NO
|
GRADE_TYPE_COUNT
|
Count the number of grading types or modes for this section or schedule offering.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_GRADE_TYPE
|
NO
|
NO
|
GRADE_TYPE_DESC
|
Grade type description.
|
VARCHAR2(255)
|
STVGMOD
|
STVGMOD_DESC
|
NO
|
NO
|
INSTRUCTION_METHOD
|
Instructional method either assigned by the schedule type or manually assigned to the schedule offering when it was created that describes how instruction will be delivered.
|
VARCHAR2(63)
|
SSBSECT
|
SSBSECT_INSM_CODE
|
NO
|
NO
|
INSTRUCTION_METHOD_DESC
|
Instruction method description.
|
VARCHAR2(255)
|
GTVINSM
|
GTVINSM_DESC
|
NO
|
NO
|
INSTRUCTOR_COUNT
|
Count of instructors or academic staff members assigned to this section or schedule offering.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_INSTRUCTOR
|
NO
|
NO
|
INTEGRATION_PARTNER
|
Institution defined integration code that identifies an external partner used for instruction of this schedule offering.
|
VARCHAR2(63)
|
SSBSECT
|
SSBSECT_INTG_CDE
|
NO
|
NO
|
INTEGRATION_PARTNER_DESC
|
Instruction integration partner description.
|
VARCHAR2(255)
|
GORINTG
|
GORINTG_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
INTEGRATION_PARTNER_SYS_DESC
|
Instruction integration partner system description.
|
VARCHAR2(255)
|
GORINTG
|
GTVINTP_DESC
|
NO
|
NO
|
LINK_IDENTIFIER
|
Links other sections of the same course which must be taken concurrently.
|
VARCHAR2(2)
|
SSBSECT
|
SSBSECT_LINK_IDENT
|
NO
|
NO
|
MAXIMUM_ENROLLMENT
|
Sets the maximum enrollment for an offering.
|
NUMBER
|
SSBSECT
|
SSBSECT_MAX_ENRL
|
NO
|
NO
|
MAX_BILLING
|
Second valid billing hour value or the high billing hour value within a range.
|
NUMBER
|
SSBSECT
|
SSBSECT_BILL_HRS
|
NO
|
NO
|
MAX_CONTACT_HOURS
|
Second valid contact hour value or the high contact hour value within a range.
|
NUMBER
|
SSBSECT
|
SSBSECT_CONT_HR
|
NO
|
NO
|
MAX_CREDITS
|
Second valid credit hour value or the high credit hour value within a range.
|
NUMBER
|
SSBSECT
|
SSBSECT_CREDIT_HRS
|
NO
|
NO
|
MAX_LAB_HOURS
|
Second valid lab hour value or the high lab hour value within a range.
|
NUMBER
|
SSBSECT
|
SSBSECT_LAB_HR
|
NO
|
NO
|
MAX_LECTURE_HOURS
|
Second valid lecture hour value or the high lecture hour value within a range.
|
NUMBER
|
SSBSECT
|
SSBSECT_LEC_HR
|
NO
|
NO
|
MAX_OTHER_HOURS
|
Second valid other hour value or the high other hour value within a range.
|
NUMBER
|
SSBSECT
|
SSBSECT_OTH_HR
|
NO
|
NO
|
MEETING_TIME_COUNT
|
Count of meeting times assigned to the course but not reflected in this row.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_MEETING_TIME
|
NO
|
NO
|
MINIMUM_ENROLLMENT
|
Sets the minimum enrollment allowed for an offering.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
MIN_BILLING
|
Minimum number of billing hours for which a course may be offered.
|
NUMBER
|
SSBSECT
|
SSBSECT_BILL_HRS
|
NO
|
NO
|
MIN_CONTACT_HOURS
|
Minimum number of contact hours for which a course may be offered.
|
NUMBER
|
SSBSECT
|
SSBSECT_CONT_HR
|
NO
|
NO
|
MIN_CREDITS
|
Minimum number of credit hours for which a course may be offered.
|
NUMBER
|
SSBSECT
|
SSBSECT_CREDIT_HRS
|
NO
|
NO
|
MIN_LAB_HOURS
|
Minimum number of lab hours for which a course may be offered.
|
NUMBER
|
SSBSECT
|
SSBSECT_LAB_HR
|
NO
|
NO
|
MIN_LECTURE_HOURS
|
Minimum number of lecture hours for which a course may be offered.
|
NUMBER
|
SSBSECT
|
SSBSECT_LEC_HR
|
NO
|
NO
|
MIN_OTHER_HOURS
|
Minimum number of other hours for which a course may be offered.
|
NUMBER
|
SSBSECT
|
SSBSECT_OTH_HR
|
NO
|
NO
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
NON_TRADITIONAL_IND
|
Indicates whether the course is a non-traditional course.
|
VARCHAR2(1)
|
NA
|
NA
|
NO
|
NO
|
OFFERING_COREQ_COUNT
|
Count of offering corequisites.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_OFFERING_COREQ
|
NO
|
NO
|
OFFERING_NUMBER
|
Offering number of a course. An offering number can only be used once to identify a subject/course number combination in a term; however, multiple offerings of a course can share a zero offering number.
|
VARCHAR2(63)
|
SSBSECT
|
SSBSECT_SEQ_NUMB
|
NO
|
NO
|
OFFERING_PREREQ_COUNT
|
Count of offering prerequisites.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_OFFERING_PREREQ
|
NO
|
NO
|
PERCENTAGE_OF_RESPONSIBILITY
|
Faculty member's percentage of responsibility to the assignment.
|
NUMBER
|
SIRASGN
|
SIRASGN_PERCENT_RESPONSE
|
NO
|
NO
|
PRIMARY_INSTRUCTOR_FIRST_NAME
|
Primary instructor's current first name.
|
VARCHAR2(60)
|
SPRIDEN
|
SPRIDEN_FIRST_NAME
|
NO
|
NO
|
PRIMARY_INSTRUCTOR_ID
|
Current identification number of the primary instructor.
|
VARCHAR2(63)
|
SPRIDEN
|
SPRIDEN_ID
|
NO
|
NO
|
PRIMARY_INSTRUCTOR_LAST_NAME
|
Primary instructor's current last name.
|
VARCHAR2(60)
|
CALCULATION
|
NVL(SPRIDEN_LAST_NAME,'STAFF')
|
NO
|
NO
|
PRIOR_ENROLLMENT
|
Enrollment in the prior like academic period when available for the section or schedule offering.
|
NUMBER
|
SSBSECT
|
SSBSECT_PRIOR_ENRL
|
NO
|
NO
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
REGISTRATION_END_DATE
|
Latest date a student may register and start this academic instruction.
|
DATE
|
SSBSECT
|
SSBSECT_REG_TO_DATE
|
NO
|
NO
|
REGISTRATION_PERMIT_IND
|
Indicates whether registration is permitted by students for this section or schedule offering.
|
VARCHAR2(255)
|
STVSSTS
|
STVSSTS_DESC
|
NO
|
NO
|
REGISTRATION_START_DATE
|
Earliest date a student may register and start this academic instruction.
|
DATE
|
SSBSECT
|
SSBSECT_REG_FROM_DATE
|
NO
|
NO
|
RESERVED_IND
|
This field indicates whether reserved seats are defined for the section.
|
VARCHAR2(1)
|
SSBSECT
|
SSBSECT_RESERVED_IND
|
NO
|
NO
|
SCHEDULE
|
Instructional delivery methods authorized for a course. Each course must be authorized to be offered for at least one schedule type. An unlimited number of schedule types can be authorized for a course (i.e., lecture, lab, internet, correspondence, etc.).
|
VARCHAR2(63)
|
SSBSECT
|
SSBSECT_SCHD_CODE
|
NO
|
NO
|
SCHEDULE_COUNT
|
Count of the instruction or delivery methods for this section.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_COURSE_SCHEDULE
|
NO
|
NO
|
SCHEDULE_DESC
|
Schedule or instructional type description for this section.
|
VARCHAR2(255)
|
STVSCHD
|
STVSCHD_DESC
|
NO
|
NO
|
SCHEDULE_PRINT_IND
|
This field is used to specify whether the section should be printed in the Schedule Report.
|
VARCHAR2(1)
|
SSBSECT
|
SSBSECT_PRNT_IND
|
NO
|
NO
|
SEATS_AVAILABLE
|
Remaining or available seats in this section or offering. System maintained by subtracting the actual number enrolled from the maximum number permitted to enroll in the section.
|
NUMBER
|
SSBSECT
|
SSBSECT_SEATS_AVAIL
|
NO
|
NO
|
SECTION_CROSS_LIST
|
Course cross list group identifier.
|
VARCHAR2(63)
|
SSRXLST
|
SSRXLST_XLST_GROUP
|
NO
|
NO
|
SECTION_CROSS_LIST_DESC
|
Cross list enrollment description.
|
VARCHAR2(255)
|
SSBXLST
|
SSBXLST_DESC
|
NO
|
NO
|
SPECIAL_APPROVAL
|
Type of special approval a student must have to register for this course or section.
|
VARCHAR2(63)
|
SSBSECT
|
SSBSECT_SAPR_CODE
|
NO
|
NO
|
SPECIAL_APPROVAL_DESC
|
Special approval type description.
|
VARCHAR2(255)
|
STVSAPR
|
STVSAPR_DESC
|
NO
|
NO
|
START_DATE
|
Date the course offering instruction began for this sub academic period.
|
DATE
|
SSBSECT
|
SSBSECT_PTRM_START_DATE
|
NO
|
NO
|
STATUS
|
Current section status. May be used to identify whether registration is permitted for this section.
|
VARCHAR2(63)
|
SSBSECT
|
SSBSECT_SSTS_CODE
|
NO
|
NO
|
STATUS_DESC
|
Section or offering status description.
|
VARCHAR2(255)
|
STVCSTA
|
STVCSTA_DESC
|
NO
|
NO
|
STUDENT_MEETING_TIME
|
Student's normal attendance time. May be either day, evening, weekend, etc.
|
VARCHAR2(63)
|
SSBSECT
|
SSBSECT_SESS_CODE
|
NO
|
NO
|
STUDENT_MEETING_TIME_DESC
|
Student's meeting session description.
|
VARCHAR2(255)
|
STVSESS
|
STVSESS_DESC
|
NO
|
NO
|
SUBJECT
|
Main instructional subject area for this course.
|
VARCHAR2(63)
|
SCBCRSE SSBSECT
|
SCBCRSE_SUBJ_CODE SSBSECT_SUBJ_CODE
|
NO NO
|
NO
|
SUBJECT_DESC
|
Subject code description.
|
VARCHAR2(255)
|
STVSUBJ
|
STVSUBJ_DESC
|
NO
|
NO
|
SUB_ACADEMIC_PERIOD
|
A session, portion or part of the academic period.
|
VARCHAR2(63)
|
SSBSECT
|
SSBSECT_PTRM_CODE
|
NO
|
NO
|
SUB_ACADEMIC_PERIOD_DESC
|
Sub academic period description.
|
VARCHAR2(255)
|
STVPTRM
|
STVPTRM_DESC
|
NO
|
NO
|
TARGET_ENROLLMENT
|
Anticipated or desired enrollment for this section or offering. Optional field defaults to zero when an offering is created.
|
NUMBER
|
SSBSECT
|
SSBSECT_PROJ_ENRL
|
NO
|
NO
|
TITLE_LONG_DESC
|
Long title of the course.
|
VARCHAR2(255)
|
SSRSYLN
|
SSRSYLN_LONG_COURSE_TITLE
|
NO
|
NO
|
TITLE_SHORT_DESC
|
Displays the course or section short title.
|
VARCHAR2(255)
|
SSBSECT
|
SSBSECT_TITLE
|
NO
|
NO
|
VOICE_WEB_AVAILABLE_IND
|
Indicates that this schedule offering is available for web or voice based registration.
|
VARCHAR2(1)
|
SSBSECT
|
SSBSECT_VOICE_AVAIL
|
NO
|
NO
|
WAIT_AVAILABLE
|
This field 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
|
NO
|
NO
|
WAIT_CAPACITY
|
This field is used to set the maximum waitlist enrollment for a section
|
NUMBER
|
SSBSECT
|
SSBSECT_WAIT_CAPACITY
|
NO
|
NO
|
WAIT_COUNT
|
This field 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
|
NUMBER
|
SSBSECT
|
SSBSECT_WAIT_COUNT
|
NO
|
NO
|