Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
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
|
NO NO
|
NO
|
ACADEMIC_PERIOD_DESC
|
Description for the academic period.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
NO
|
NO
|
ACADEMIC_YEAR
|
Identifies the academic period for which the course or course section is planned for registration.
|
VARCHAR2(63)
|
STVTERM
|
STVTERM_ACYR_CODE
|
NO
|
NO
|
ACADEMIC_YEAR_DESC
|
Description for the academic period.
|
VARCHAR2(255)
|
STVACYR
|
STVACYR_DESC
|
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
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
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
|
COURSE_IDENTIFICATION
|
Course subject and course number combined.
|
VARCHAR2(255)
|
CALCULATION
|
SFRPLAN_SUBJ_CODE||SFRPLAN_CRSE_NUMB
|
NO
|
NO
|
COURSE_NUMBER
|
Course number associated with the subject for the course.
|
VARCHAR2(63)
|
SEP_PLAN_CLASS SFRPLAN
|
COURSE_NUMBER SFRPLAN_CRSE_NUMB
|
NO NO
|
NO
|
COURSE_REFERENCE_NUMBER
|
Computer assigned internal unique number for the section.
|
VARCHAR2(63)
|
NA SFRPLAN
|
NULL SFRPLAN_CRN
|
NO NO
|
NO
|
COURSE_SUBJECT
|
Main instructional subject or displace area for this course.
|
VARCHAR2(63)
|
SEP_PLAN_CLASS SFRPLAN
|
COURSE_DISCIPLINE SFRPLAN_SUBJ_CDE
|
NO NO
|
NO
|
COURSE_SUBJECT_DESC
|
Description of the subject area for this course
|
VARCHAR2(255)
|
STVSUBJ
|
STVSUBJ_DESC
|
NO
|
NO
|
MAXIMUM_ENROLLMENT
|
Sets the maximum enrollment for an offerring.
|
NUMBER
|
SSBSECT
|
SSBSECT_MAX_ENRL
|
NO
|
NO
|
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
|
NO NO
|
NO
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
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
|
NO
|
NO
|
PROCESS_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
SCHEDULE_OFFERING_COUNT
|
Count of the number of sections offered in the academic period for the course.
|
NUMBER
|
CALCULATION
|
COUNT (DISTINCT COURSE_REFERENCE_NUMBER)
|
NO
|
NO
|
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)
|
NO
|
NO
|
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)
|
NO
|
NO
|
SUB_ACADEMIC_PERIOD
|
A session, portion or part of the academic period.
|
VARCHAR2(63)
|
CONSTANT SSBSECT
|
'NA' SSBSECT_PTRM_CODE
|
NO NO
|
NO
|
SUB_ACADEMIC_PERIOD_DESC
|
Description for the part of academic period.
|
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
|