Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Student Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: PROJECTED_SEATS_NEEDED

Description Contains summary information about the seats needed per the student registration plans.
Key & Frequency One row academic period per course identification and or course reference number
Recommended Search Columns ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER
COURSE_NUMBER, ACADEMIC_PERIOD
ACADEMIC_PERIOD, COURSE_IDENTIFICATION, COURSE_REFERENCE_NUMBER

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: 8.5