Target Column	Business Definition	Database Data Type	Source Name	Source Column
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	Description for the academic period.	VARCHAR2(255)	STVTERM	STVTERM_DESC
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	Description for the academic period.	VARCHAR2(255)	STVACYR	STVACYR_DESC
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	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
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
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
COURSE_IDENTIFICATION	Course subject and course number combined.	VARCHAR2(255)	CALCULATION	SFRPLAN_SUBJ_CODE||SFRPLAN_CRSE_NUMB
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	Computer assigned internal unique number for the section.	VARCHAR2(63)	NA SFRPLAN	NULL SFRPLAN_CRN
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	Description of the subject area for this course	VARCHAR2(255)	STVSUBJ	STVSUBJ_DESC
MAXIMUM_ENROLLMENT	Sets the maximum enrollment for an offerring.	NUMBER	SSBSECT	SSBSECT_MAX_ENRL
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	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
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	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
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	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	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	A session, portion or part of the academic period.	VARCHAR2(63)	CONSTANT SSBSECT	'NA' SSBSECT_PTRM_CODE
SUB_ACADEMIC_PERIOD_DESC	Description for the part of academic period.	VARCHAR2(255)	STVPTRM	STVPTRM_DESC
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

Ver: 9.1