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
|
SFRSTCR_TERM_CODE
|
ACADEMIC_PERIOD_DESC
|
Academic Period Description
|
Academic period description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
ACADEMIC_YEAR
|
Academic Year
|
Academic year associated with the academic period on this record.
|
VARCHAR2(63)
|
STVTERM
|
STVTERM_ACYR_CODE
|
ACADEMIC_YEAR_DESC
|
Academic Year Description
|
Academic year description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
ACCOUNTING_METHOD
|
Accounting Method
|
Accounting method used for tracking attendance either weekly or daily.
|
VARCHAR2(63)
|
SSBSECT
|
SSBSECT_ACCT_CODE
|
ACCOUNTING_METHOD_DESC
|
Accounting Method Description
|
Accounting method description for this course.
|
VARCHAR2(255)
|
STVACCT
|
STVACCT_DESC
|
ACTUAL_ENROLLMENT
|
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
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
BEGIN_TIME
|
Begin Time
|
Begin time of the section or schedule offering. It is in the format HHMM using military time.
|
VARCHAR2(4)
|
SSRMEET
|
SSRMEET_BEGIN_TIME
|
BILLING_UNITS
|
Billing Units
|
Specifies the billing units associated with this course.
|
NUMBER
|
SFRSTCR
|
SFRSTCR_BILL_HR
|
BUILDING
|
Building
|
Building code for the room assignment.
|
VARCHAR2(63)
|
SSRMEET
|
SSRMEET_BLDG_CODE
|
CENSUS_ENROLLMENT1
|
Census Enrollment 1
|
Total of students registered and counted in enrollment for the section or schedule offering through the defined census date.
|
NUMBER
|
SSBSECT
|
SSBSECT_CENSUS_ENRL
|
CENSUS_ENROLLMENT2
|
Census Enrollment 2
|
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
|
CENSUS_ENROLLMENT_DATE1
|
Census Enrollment Date 1
|
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
|
CENSUS_ENROLLMENT_DATE2
|
Census Enrollment Date 2
|
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
|
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_CAMPUS
|
Course Campus
|
Campus the student attended this schedule offering or section.
|
VARCHAR2(63)
|
SFRSTCR
|
SFRSTCR_CAMP_CODE
|
COURSE_CAMPUS_DESC
|
Course Campus Description
|
Institution campus description.
|
VARCHAR2(255)
|
STVCAMP
|
STVCAMP_DESC
|
COURSE_COLLEGE
|
Course College
|
College, faculty or school provide this section instruction.
|
VARCHAR2(63)
|
SCBCRSE SSBOVRR
|
SCBCRSE_COLL_CODE SSBOVRR_COLL_CODE
|
COURSE_COLLEGE_DESC
|
Course College Description
|
College description.
|
VARCHAR2(255)
|
STVCOLL
|
STVCOLL_DESC
|
COURSE_CREDITS
|
Course Credits
|
Credits associated with this course.
|
NUMBER
|
SFRSTCR
|
SFRSTCR_CREDIT_HR
|
COURSE_CREDITS_HOLD
|
Course Credits Hold
|
Identifies the number of credits that are being held for potential reinstatement.
|
NUMBER
|
SFRSTCR
|
SFRSTCR_CREDIT_HR_HOLD
|
COURSE_DEPARTMENT
|
Course Department
|
Department providing this instruction.
|
VARCHAR2(63)
|
SCBCRSE SSBOVRR
|
SCBCRSE_DEPT_CODE SSBOVRR_DEPT_CODE
|
COURSE_DEPARTMENT_DESC
|
Course Department Description
|
Department providing this instruction.
|
VARCHAR2(255)
|
STVDEPT
|
STVDEPT_DESC
|
COURSE_DIVISION
|
Course Division
|
Division providing this instruction.
|
VARCHAR2(63)
|
SCBCRSE SSBOVRR
|
SCBCRSE_DIVS_CODE SSBOVRR_DIVS_CODE
|
COURSE_DIVISION_DESC
|
Course Division Description
|
Division description.
|
VARCHAR2(255)
|
STVDIVS
|
STVDIVS_DESC
|
COURSE_IDENTIFICATION
|
Course ID
|
Course subject and course number combined.
|
VARCHAR2(63)
|
CALCULATION CALCULATION
|
SHRTCKN_SUBJ_CODE||SHRTCKN_CRSE_NUMB SSBSECT_SUBJ_CODE||SSBSECT_CRSE_NUMB
|
COURSE_LEVEL
|
Course Level
|
Level of academic study satisfied by this course. For example, undergraduate, graduate, credit, etc.
|
VARCHAR2(63)
|
NA SFRSTCR
|
NA SFRSTCR_LEVL_CODE
|
COURSE_LEVEL_DESC
|
Course Level Description
|
Course level description.
|
VARCHAR2(255)
|
FUNCTION NA
|
GOKODSF.F_GET_DESC NA
|
COURSE_NUMBER
|
Course Number
|
Course number associated with the subject for the course.
|
VARCHAR2(63)
|
SCBCRSE
|
SCBCRSE_CRSE_NUMB
|
COURSE_REFERENCE_NUMBER
|
Course Reference Number
|
Computer assigned internal unique number for the schedule offering.
|
VARCHAR2(63)
|
SFRSTCR
|
SFRSTCR_CRN
|
COURSE_REPORTING_CODE_1
|
Course Reporting Code 1
|
Course institutional reporting element 1 code.
|
VARCHAR2(63)
|
SCBSUPP
|
SCBSUPP_CUDA_CODE
|
COURSE_REPORTING_CODE_2
|
Course Reporting Code 2
|
Course institutional reporting element 2 code.
|
VARCHAR2(63)
|
SCBSUPP
|
SCBSUPP_CUDB_CODE
|
COURSE_REPORTING_CODE_3
|
Course Reporting Code 3
|
Course institutional reporting element 3 code.
|
VARCHAR2(63)
|
SCBSUPP
|
SCBSUPP_CUDC_CODE
|
COURSE_REPORTING_CODE_4
|
Course Reporting Code 4
|
Course institutional reporting element 4 code.
|
VARCHAR2(63)
|
SCBSUPP
|
SCBSUPP_CUDD_CODE
|
COURSE_REPORTING_CODE_5
|
Course Reporting Code 5
|
Course institutional reporting element 5 code.
|
VARCHAR2(63)
|
SCBSUPP
|
SCBSUPP_CUDE_CODE
|
COURSE_REPORTING_CODE_6
|
Course Reporting Code 6
|
Course institutional reporting element 6 code.
|
VARCHAR2(63)
|
SCBSUPP
|
SCBSUPP_CUDF_CODE
|
COURSE_TITLE_SHORT
|
Course Title Short
|
Short title for the course.
|
VARCHAR2(63)
|
CALCULATION
|
NVL(SSBSECT_CRSE_TITLE,SCBCRSE_TITLE)
|
END_DATE
|
End Date
|
Date on which the instruction ended. It is either stored specifically for the open learning student or taken from the end date on the offering.
|
DATE
|
SFRAREG
|
SFRAREG_COMPLETION_DATE
|
END_TIME
|
End Time
|
Time the offering meeting ends.
|
VARCHAR2(4)
|
SSRMEET
|
SSRMEET_END_TIME
|
EXEMPT_TUITION_SECTION
|
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
|
FACULTY_MEMBER_STAFF_TYPE
|
Faculty Member Staff Type
|
Staff type assigned to the faculty or academic staff member. Included type may be full time, part time, continuing education, etc.
|
VARCHAR2(63)
|
SIBINST
|
SIBINST_FSTP_CODE
|
FACULTY_MEMBER_STAFF_TYPE_DESC
|
Faculty Member Staff Type Description
|
Faculty member staff type description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
FINAL_GRADE
|
Final Grade
|
Final grade earned by the student for this course.
|
VARCHAR2(63)
|
SHRTCKG
|
SHRTCKG_GRDE_CODE_FINAL
|
FIRST_NAME
|
First Name
|
Person's first or given name.
|
VARCHAR2(63)
|
SPRIDEN
|
SPRIDEN_FIRST_NAME
|
FRIDAY_IND
|
Friday Indicator
|
Indicates whether the section meets on Friday.
|
VARCHAR2(1)
|
SSRMEET
|
SSRMEET_FRI_DAY
|
ID
|
ID
|
Identification number assigned to a person that is used externally for all communication and correspondence with the person.
|
VARCHAR2(63)
|
SPRIDEN
|
SPRIDEN_ID
|
INSTRUCTION_METHOD
|
Instruction Method
|
Method of instruction. Traditional classroom, internet, correspondence, etc.
|
VARCHAR2(63)
|
SSBSECT
|
SSBSECT_INSM_CODE
|
INSTRUCTION_METHOD_DESC
|
Instruction Method Description
|
Instructional method description.
|
VARCHAR2(255)
|
GTVINSM
|
GTVINSM_DESC
|
INSTRUCTOR_COUNT
|
Instructor Count
|
Count of instructors assigned to the course.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_INSTRUCTOR
|
INSTRUCTOR_FIRST_NAME
|
Instructor First Name
|
Primary instructor first name.
|
VARCHAR2(60)
|
SPRIDEN
|
SPRIDEN_FIRST_NAME
|
INSTRUCTOR_ID
|
Instructor ID
|
Instructor ID for the academic staff assigned as the primary instructor.
|
VARCHAR2(63)
|
SPRIDEN
|
SPRIDEN_ID
|
INSTRUCTOR_LAST_NAME
|
Instructor Last Name
|
Primary instructor last name.
|
VARCHAR2(60)
|
CALCULATION
|
NVL(SPRIDEN_LAST_NAME,'STAFF')
|
INSTRUCTOR_MIDDLE_NAME
|
Instructor Middle Name
|
Primary instructor middle name.
|
VARCHAR2(63)
|
SPRIDEN
|
SPRIDEN_MI
|
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
|
LAB_CONTACT_HOURS
|
Lab Contact Hours
|
Maximum lab contact hours for schedule offering.
|
NUMBER
|
CALCULATION
|
NVL(SSBSECT_LAB_HR,SCBCRSE_LAB_HR_HIGH)
|
LAST_NAME
|
Last Name
|
Last name.
|
VARCHAR2(63)
|
SPRIDEN
|
SPRIDEN_LAST_NAME
|
LECTURE_CONTACT_HOURS
|
Lecture Contact Hours
|
Maximum lecture contact hours for schedule offering.
|
NUMBER
|
CALCULATION
|
NVL(SSBSECT_LEC_HR,SCBCRSE_LEC_HR_HIGH)
|
MAXIMUM_ENROLLMENT
|
Maximum Enrollment
|
Sets the maximum enrollment for this offering.
|
NUMBER
|
SSBSECT
|
SSBSECT_MAX_ENRL
|
MEETING_TIME_COUNT
|
Meeting Time Count
|
Count of meeting times assigned to the course but not reflected in this row.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_MEETING_TIME
|
MIDDLE_NAME
|
Middle Name
|
Middle name.
|
VARCHAR2(63)
|
SPRIDEN
|
SPRIDEN_MI
|
MONDAY_IND
|
Monday Indicator
|
Indicates whether the section meets on Monday.
|
VARCHAR2(1)
|
SSRMEET
|
SSRMEET_MON_DAY
|
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
|
NON_TRADITIONAL_COURSE
|
Non Traditional Course
|
Non-traditional course as indicated by the institution.
|
VARCHAR2(1)
|
NA
|
NA
|
OCCUPATIONAL_COURSE
|
Occupational Course
|
Indicates whether this course is an occupational or vocational course for reporting purposes.
|
VARCHAR2(63)
|
SCBSUPP
|
SCBSUPP_OCCS_CODE
|
OCCUPATIONAL_COURSE_DESC
|
Occupational Course Description
|
Vocational or occupational indicator description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
OFFERING_NUMBER
|
Offering Number
|
Identifies a particular offering within the course identification.
|
VARCHAR2(63)
|
SSBSECT
|
SSBSECT_SEQ_NUMB
|
OTHER_CONTACT_HOURS
|
Other Contact Hours
|
Maximum other contact hours for schedule offering.
|
NUMBER
|
CALCULATION
|
NVL(SSBSECT_OTH_HR,SCBCRSE_OTH_HR_HIGH)
|
PERCENT_RESPONSIBILITY
|
Percent Responsibility
|
Schedule offering session percent of responsibility for the faculty member's instructional assignment.
|
NUMBER
|
SIRASGN
|
SIRASGN_PERCENT_SESS
|
PERSON_UID
|
Person UID
|
Internally generated by the system to uniquely identify the person or entity.
|
NUMBER
|
SFRSTCR
|
SFRSTCR_PIDM
|
PRIMARY_IND
|
Primary Indicator
|
Indicates Y if the instructor is the primary or N if not.
|
VARCHAR2(1)
|
SIRASGN
|
SIRASGN_PRIMARY_IND
|
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_CLASSIFICATION
|
Program Classification
|
Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting.
|
VARCHAR2(63)
|
NA
|
NA
|
PROGRAM_CLASSIFICATION_DESC
|
Program Classification Description
|
Program classification description.
|
VARCHAR2(255)
|
STVCIPC
|
STVCIPC_DESC
|
REGISTER_CENSUS_DATE1_IND
|
REGISTER_CENSUS_DATE1_IND
|
Indicates a registration course status that identifies the person counts in the course section headcount was recorded prior to the census date.
|
VARCHAR2(1)
|
SSBSECT
|
SSBSECT_CENSUS_ENRL
|
REGISTER_CENSUS_DATE2_IND
|
REGISTER_CENSUS_DATE2_IND
|
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)
|
SSBSECT
|
SSBSECT_CENSUS_2_DATE
|
REGISTRATION_ERROR_FLAG
|
Registration Error Indicator
|
Identifies an error associated with the registration of this course section or offering. Values include F=Fatal, D=Do not count in enrollment, L=Waitlisted, O=Override.
|
VARCHAR2(1)
|
SFRSTCR
|
SFRSTCR_ERROR_FLAG
|
REGISTRATION_SEQUENCE_NUMBER
|
Registration Sequence Number
|
Sequence in which this registrant enrolled in this course.
|
NUMBER
|
SFRSTCR
|
SFRSTCR_REG_SEQ
|
REGISTRATION_STATUS
|
Registration Status
|
Identifies the course registration status associated for this course.
|
VARCHAR2(63)
|
SFRSTCR
|
SFRSTCR_RSTS_CODE
|
REGISTRATION_STATUS_DATE
|
Registration Status Date
|
Latest change registration date for this course.
|
DATE
|
SFRSTCR
|
SFRSTCR_RSTS_DATE
|
REGISTRATION_STATUS_DESC
|
Registration Status Description
|
Course registration status description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
REGISTRATION_USER_ID
|
Registration User ID
|
User who entered the course registration.
|
VARCHAR2(63)
|
SFRSTCR
|
SFRSTCR_USER
|
REPEAT_COURSE_IND
|
Repeat Course Indicator
|
Identifies this course is being taken again by this student.
|
VARCHAR2(1)
|
SFRSTCR
|
SFRSTCR_REPT_OVER
|
ROOM
|
Room
|
Room where the offering meeting is scheduled.
|
VARCHAR2(10)
|
SSRMEET
|
SSRMEET_ROOM_CODE
|
SATURDAY_IND
|
Saturday Indicator
|
Indicates whether the section meets on Saturday.
|
VARCHAR2(1)
|
SSRMEET
|
SSRMEET_SAT_DAY
|
SCHEDULE
|
Schedule
|
Instructional delivery for this course. This could be lecture, lab, internet, etc.
|
VARCHAR2(63)
|
SSBSECT
|
SSBSECT_SCHD_CODE
|
SCHEDULE_TYPE_DESC
|
Schedule Type Description
|
Description for the method in which the course content is delivered. For example, lecture, lab, internet, etc.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
SEATS_AVAILABLE
|
Seats Available
|
System maintained running total of remaining available seats in the section by subtracting the Actual enrollment field from the Maximum enrollment field defined for this section.
|
NUMBER
|
SSBSECT
|
SSBSECT_ENRL
|
SECTION_ADD_DATE
|
Section Add Date
|
Original registration date for this course regardless of the last change in registration status date.
|
DATE
|
SFRSTCR
|
SFRSTCR_ADD_DATE
|
SPECIAL_APPROVAL_IND
|
Special Approval Indicator
|
Indicates special approval was required for this registration.
|
VARCHAR2(1)
|
SFRSTCR
|
SFRSTCR_APPR_RECEIVED_IND
|
START_DATE
|
Start Date
|
Date the instruction for this course began for this student.
|
DATE
|
SFRAREG
|
SFRAREG_START_DATE
|
STUDENT_MEETING_TIME
|
Student Meeting Time
|
Student's normal attendance time. May be either day, evening, weekend, etc.
|
VARCHAR2(63)
|
NA
|
NA
|
STUDENT_MEETING_TIME_DESC
|
Student Meeting Time Description
|
Student's normal attendance time. May be either day, evening, weekend, etc.
|
VARCHAR2(255)
|
NA
|
NA
|
SUBJECT
|
Subject
|
Main instructional subject area for this course.
|
VARCHAR2(63)
|
SCBCRSE
|
SCBCRSE_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
|
SFRSTCR_PTRM_CODE
|
SUB_ACADEMIC_PERIOD_DESC
|
Sub Academic Period Description
|
Sub academic period description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
SUNDAY_IND
|
Sunday Indicator
|
Indicates whether the section meets on Sunday.
|
VARCHAR2(1)
|
SSRMEET
|
SSRMEET_SUN_DAY
|
TAXONOMY_OF_PROGRAM
|
Taxonomy Of Program
|
Government reporting code typically used for reporting of vocational technical courses or subjects.
|
VARCHAR2(63)
|
SCBSUPP SSBOVRR
|
SCBSUPP_TOPS_CODE SSBOVRR_TOPS_CODE
|
TAXONOMY_OF_PROGRAM_DESC
|
Taxonomy Of Program Description
|
Government reporting code description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
THURSDAY_IND
|
Thursday Indicator
|
Indicates whether the section meets on Thursday.
|
VARCHAR2(1)
|
SSRMEET
|
SSRMEET_THU_DAY
|
TOTAL_CONTACT_HOURS
|
Total Contact Hours
|
Maximum contact hours for schedule offering.
|
NUMBER
|
CALCULATION
|
NVL(SSBSECT_CONT_HR,SCBCRSE_CONT_HR_HIGH)
|
TUESDAY_IND
|
Tuesday Indicator
|
Indicates whether the section meets on Tuesday.
|
VARCHAR2(1)
|
SSRMEET
|
SSRMEET_TUE_DAY
|
WEDNESDAY_IND
|
Wednesday Indicator
|
Indicates whether the section meets on Wednesday.
|
VARCHAR2(1)
|
SSRMEET
|
SSRMEET_SUN_DAY
|
WORKLOAD_ADJUST
|
Workload Adjustment
|
Adjusted workload recorded for the instructional assignments of this faculty member.
|
NUMBER
|
SIRASGN
|
SIRASGN_WORKLOAD_ADJUST
|