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(6)
|
SSBSECT
|
SSBSECT_TERM_CODE
|
NO
|
NO
|
ACADEMIC_PERIOD_DESC
|
Academic period description.
|
VARCHAR2(30)
|
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(4)
|
STVTERM
|
STVTERM_ACYR_CODE
|
NO
|
NO
|
ACADEMIC_YEAR_DESC
|
Academic year description.
|
VARCHAR2(30)
|
STVACYR
|
STVACYR_DESC
|
NO
|
NO
|
ACCOUNTING_METHOD
|
Accounting method used for tracking attendance either weekly or daily.
|
VARCHAR2(2)
|
SSBSECT
|
SSBSECT_ACCT_CODE
|
NO
|
NO
|
ACCOUNTING_METHOD_DESC
|
Accounting method description for this course.
|
VARCHAR2(30)
|
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
|
CAMPUS
|
Campus associated with this record. Campus for the course section, student course, student, applied for on the admission application, etc.
|
VARCHAR2(3)
|
SSBSECT
|
SSBSECT_CAMP_CODE
|
NO
|
NO
|
CAMPUS_DESC
|
Institution campus name.
|
VARCHAR2(30)
|
STVCAMP
|
STVCAMP_DESC
|
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(2)
|
SSBOVRR
|
SSBOVRR_COLL_CODE
|
NO
|
NO
|
COLLEGE_DESC
|
College, faculty or school name.
|
VARCHAR2(30)
|
STVCOLL
|
STVCOLL_DESC
|
NO
|
NO
|
COURSE_CLASS_LEVEL
|
Expected class (first year, second year, etc.) the enrollee is in when taking a course.
|
VARCHAR2(0)
|
NA
|
NA
|
NO
|
NO
|
COURSE_CLASS_LEVEL_DESC
|
Class level code description.
|
VARCHAR2(0)
|
NA
|
NA
|
NO
|
NO
|
COURSE_IDENTIFICATION
|
Course subject and course number combined.
|
VARCHAR2(9)
|
CALCULATION
|
SSBSECT_SUBJ_CODE||SSBSECT_CRSE_NUMB
|
NO
|
NO
|
COURSE_NUMBER
|
Course number associated with the subject for the course.
|
VARCHAR2(5)
|
SSBSECT
|
SSBSECT_CRSE_NUMB
|
NO
|
NO
|
COURSE_REFERENCE_NUMBER
|
Computer assigned internal unique number for the schedule offering.
|
VARCHAR2(5)
|
SSBSECT
|
SSBSECT_CRN
|
NO
|
NO
|
COURSE_TEXT_NARRATIVE
|
Course offering descriptive text.
|
CLOB
|
SSBDESC
|
SSBDESC_TEXT_NARRATIVE
|
NO
|
NO
|
COURSE_VERSION_NO
|
Course version number.
|
VARCHAR2(0)
|
NA
|
NA
|
NO
|
NO
|
CROSS_LIST_ACTIVITY_DATE
|
Most recent date a record was created or updated.
|
DATE
|
SSBXLST
|
SSBXLST_ACTIVITY_DATE
|
NO
|
NO
|
CROSS_LIST_ENROLLMENT
|
Cross list section enrollment to date.
|
NUMBER
|
SSBXLST
|
SSBXLST_ENRL
|
NO
|
NO
|
CROSS_LIST_MAXIMUM_ENROLLMENT
|
Maximum cross listed section enrollment.
|
NUMBER
|
SSBXLST
|
SSBXLST_MAX_ENRL
|
NO
|
NO
|
CROSS_LIST_SEATS_AVAILABILE
|
Seats available in the sections within a cross List code.
|
NUMBER
|
SSBXLST
|
SSBXLST_SEATS_AVAIL
|
NO
|
NO
|
CROSS_LIST_SEATS_AVAILABLE
|
|
NUMBER
|
|
|
|
NO
|
CURRENT_DATE
|
System current date (sysdate) or date the data was extracted.
|
DATE
|
NA
|
SYSDATE
|
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(4)
|
SSBOVRR
|
SSBOVRR_DEPT_CODE
|
NO
|
NO
|
DEPARTMENT_DESC
|
Department name.
|
VARCHAR2(30)
|
STVDEPT
|
STVDEPT_DESC
|
NO
|
NO
|
DIVISION
|
Division responsible for the instructional delivery of this course or section.
|
VARCHAR2(4)
|
SSBOVRR
|
SSBOVRR_DIVS_CODE
|
NO
|
NO
|
DIVISION_DESC
|
Name of the division.
|
VARCHAR2(30)
|
STVDIVS
|
STVDIVS_DESC
|
NO
|
NO
|
DOMAIN_VALUE
|
Organization-oriented identifier for the record used to determine access authorization. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
DURATION
|
Indicates whether the course duration is in days, weeks, months, etc.
|
VARCHAR2(4)
|
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(1)
|
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
|
This field is the number of enrolled students times the number of credits the offering is worth.
|
NUMBER
|
NA
|
NA
|
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(1)
|
SSBSECT
|
SSBSECT_GMOD_CODE
|
NO
|
NO
|
GRADE_TYPE_DESC
|
Grade type description.
|
VARCHAR2(30)
|
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(5)
|
SSBSECT
|
SSBSECT_INSM_CODE
|
NO
|
NO
|
INSTRUCTION_METHOD_DESC
|
Instruction method description.
|
VARCHAR2(30)
|
GTVINSM
|
GTVINSM_DESC
|
NO
|
NO
|
INTEGRATION_PARTNER
|
Institution defined integration code that identifies an external partner used for instruction of this schedule offering.
|
VARCHAR2(5)
|
SSBSECT
|
SSBSECT_INTG_CDE
|
NO
|
NO
|
INTEGRATION_PARTNER_DESC
|
Instruction integration partner description.
|
VARCHAR2(30)
|
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(5)
|
GORINTG
|
GORINTG_INTP_CODE
|
NO
|
NO
|
INTEGRATION_PARTNER_SYS_DESC
|
Instruction integration partner system description.
|
VARCHAR2(30)
|
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
|
MIF_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(30)
|
NA
|
NA
|
NO
|
NO
|
MIF_VALUE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
MINIMUM_ENROLLMENT
|
Sets the minimum enrollment allowed for an offering.
|
VARCHAR2(0)
|
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
|
NON_TRADITIONAL_IND
|
Indicates whether the course is a non-traditional course.
|
VARCHAR2(1)
|
NA
|
NA
|
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(3)
|
SSBSECT
|
SSBSECT_SEQ_NUMB
|
NO
|
NO
|
PART_OF_TERM
|
Session or part of the academic period associated with the information in the record.
|
VARCHAR2(3)
|
SSBSECT
|
SSBSECT_PTRM_CODE
|
NO
|
NO
|
PART_OF_TERM_DESC
|
Session, part of term, or academic period description.
|
VARCHAR2(30)
|
STVPTRM
|
STVPTRM_DESC
|
NO
|
NO
|
PART_OF_TERM_END_DATE
|
Date the course offering instruction ends.
|
DATE
|
SSBSECT
|
SSBSECT_PTRM_END_DATE
|
NO
|
NO
|
PART_OF_TERM_START_DATE
|
Date the course offering instruction begins.
|
DATE
|
SSBSECT
|
SSBSECT_PTRM_START_DATE
|
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
|
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 for the offering is available.
|
VARCHAR2(1)
|
NA
|
NA
|
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(3)
|
SSBSECT
|
SSBSECT_SCHD_CODE
|
NO
|
NO
|
SCHEDULE_DESC
|
Schedule or instructional type description for this section.
|
VARCHAR2(30)
|
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
|
|
VARCHAR2(2)
|
|
|
|
NO
|
SECTION_CROSS_LIST_DESC
|
|
VARCHAR2(30)
|
|
|
|
NO
|
SPECIAL_APPROVAL
|
Type of special approval a student must have to register for this course or section.
|
VARCHAR2(2)
|
SSBSECT
|
SSBSECT_SAPR_CODE
|
NO
|
NO
|
SPECIAL_APPROVAL_DESC
|
Special approval type description.
|
VARCHAR2(30)
|
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
|
Identifies the current section status. May be used to identify whether registration is permitted for this section.
|
VARCHAR2(1)
|
SSBSECT
|
SSBSECT_SSTS_CODE
|
NO
|
NO
|
STATUS_DESC
|
Section or offering status description.
|
VARCHAR2(30)
|
STVSSTS
|
STVSSTS_DESC
|
NO
|
NO
|
STUDENT_MEETING_TIME
|
Student's normal attendance time. May be either day, evening, weekend, etc.
|
VARCHAR2(1)
|
SSBSECT
|
SSBSECT_SESS_CODE
|
NO
|
NO
|
STUDENT_MEETING_TIME_DESC
|
Student's meeting session description.
|
VARCHAR2(30)
|
STVSESS
|
STVSESS_DESC
|
NO
|
NO
|
SUBJECT
|
Main instructional subject area for this course.
|
VARCHAR2(4)
|
SSBSECT
|
SSBSECT_SUBJ_CODE
|
NO
|
NO
|
SUBJECT_DESC
|
Subject code description.
|
VARCHAR2(30)
|
STVSUBJ
|
STVSUBJ_DESC
|
NO
|
NO
|
SUB_ACADEMIC_PERIOD
|
A session, portion or part of the academic period.
|
VARCHAR2(3)
|
SSBSECT
|
SSBSECT_PTRM_CODE
|
NO
|
NO
|
SUB_ACADEMIC_PERIOD_DESC
|
Sub academic period description.
|
VARCHAR2(30)
|
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
|
TAXONOMY_OF_PROGRAM
|
Government reporting code typically used for reporting of vocational technical courses or subjects.
|
VARCHAR2(6)
|
SSBOVRR
|
SSBOVRR_TOPS_CODE
|
NO
|
NO
|
TAXONOMY_OF_PROGRAM_DESC
|
Taxonomy of program code description.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
TITLE_LONG_DESC
|
Long title of the course.
|
VARCHAR2(100)
|
NA
|
NA
|
NO
|
NO
|
TITLE_SHORT_DESC
|
Displays the course or section short title.
|
VARCHAR2(30)
|
SSBSECT
|
SSBSECT_CRSE_TITLE
|
NO
|
NO
|
VOICE_WEB_AVAILABLE_IND
|
The indicator that reflects if the section if offered on the Web or not.
|
VARCHAR2(1)
|
|
|
|
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
|
ZONE_VALUE
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|