| Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ACADEMIC_PERIOD
|
Academic Period
|
Identifies the academic period in which the student plans to register for the course or course section in the plan.
|
VARCHAR2(63)
|
SEP_PLAN_TERM SFBPLAN
|
TERM SFRPLAN_TERM_CODE
|
|
ACADEMIC_PERIOD_DESC
|
Academic Period Description
|
Description for the academic period.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
|
ACADEMIC_YEAR
|
Academic Year
|
Identifies the academic period for which the course or course section is planned for registration.
|
VARCHAR2(63)
|
STVTERM
|
STVTERM_ACYR_CODE
|
|
ACADEMIC_YEAR_DESC
|
Academic Year Description
|
Description for the academic period.
|
VARCHAR2(255)
|
STVACYR
|
STVACYR_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
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
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
|
|
COURSE_IDENTIFICATION
|
Course Identification
|
Course subject and course number combined.
|
VARCHAR2(255)
|
CALCULATION
|
SFRPLAN_SUBJ_CODE||SFRPLAN_CRSE_NUMB
|
|
COURSE_NUMBER
|
Course Number
|
Course number associated with the subject for the course.
|
VARCHAR2(63)
|
SEP_PLAN_CLASS SFRPLAN
|
COURSE_NUMBER SFRPLAN_CRSE_NUMB
|
|
COURSE_REFERENCE_NUMBER
|
Course Reference Number
|
Computer assigned internal unique number for the section.
|
VARCHAR2(63)
|
NA SFRPLAN
|
NULL SFRPLAN_CRN
|
|
COURSE_SUBJECT
|
Course Subject
|
Main instructional subject or displace area for this course.
|
VARCHAR2(63)
|
SEP_PLAN_CLASS SFRPLAN
|
COURSE_DISCIPLINE SFRPLAN_SUBJ_CDE
|
|
COURSE_SUBJECT_DESC
|
Course Subject Description
|
Description of the subject area for this course
|
VARCHAR2(255)
|
STVSUBJ
|
STVSUBJ_DESC
|
|
MAXIMUM_ENROLLMENT
|
Maximum Enrollment
|
Sets the maximum enrollment for an offerring.
|
NUMBER
|
SSBSECT
|
SSBSECT_MAX_ENRL
|
|
MULTI_SOURCE
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
CONSTANT SFRPLAN
|
'NA' SFRPLAN_VPDI_CODE
|
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
|
PRIOR_ENROLLMENT
|
Prior Enrollment
|
Enrollment in the prior like academic period when academic period sections were created using the roll process and the data is available for the section or schedule offering.
|
NUMBER
|
SSBSECT
|
SSBSECT_PRIOR_ENRL
|
|
PROCESS_GROUP
|
Process Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
SCHEDULE_OFFERING_COUNT
|
Schedule Offering Count
|
Count of the number of sections offered in the academic period for the course.
|
NUMBER
|
CALCULATION
|
COUNT (DISTINCT COURSE_REFERENCE_NUMBER)
|
|
SEATS_NEEDED
|
Seats Needed
|
Total number of requests made for this course (or section of a course when permitted) by students within an internal or external registration plan.
|
NUMBER
|
CALCULATION
|
COUNT (*) OVER (PARTITION BY COURSE_IDENTIFICATION, ACADEMIC_PERIOD, SUB_ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER)
|
|
STUDENT_HEADCOUNT
|
Student Headcount
|
Total numbe of student requesting this course. This will be an unduplicated headcount when a student has more than one plan.
|
NUMBER
|
CALCULATION
|
COUNT (DISTINCT PERSON_UID)
|
|
SUB_ACADEMIC_PERIOD
|
Sub Academic Period
|
A session, portion or part of the academic period.
|
VARCHAR2(63)
|
CONSTANT SSBSECT
|
'NA' SSBSECT_PTRM_CODE
|
|
SUB_ACADEMIC_PERIOD_DESC
|
Sub Academic Period Description
|
Description for the part of academic period.
|
VARCHAR2(255)
|
STVPTRM
|
STVPTRM_DESC
|
|
TARGET_ENROLLMENT
|
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
|