Banner California Community Colleges Baseline Operational Data
Contents
1. WEEKLY CONTACT HOURS Calculated weekly contact hours for the section This field is null when the attendance type is DAILY ISDAY ACTUAL or UNKNOWN December 2012 Banner California Community Colleges Baseline Operational Data Store 8 1 3 5 Handbook Reporting Views STUDENT_ATTENDANCE CALB This CALB reporting view includes California CCSF 320 related reporting elements such as contact hours and apportionment status It returns one row per registration record The CCFS 320 numbers are projections or estimates They have some variations from the final apportionment reported values in order to allow estimating very early in the reporting year cycle For example the daily contact hour value is used to project FTES for a positive attendance section Additionally the section error checking CCFS 320 report exceptions list is not included in the projections View Column Name Description ACADEMIC PERIOD Academic period or term associated with the information in the course record ACADEMIC PERIOD DESC Description of the academic period code ACADEMIC YEAR Academic year associated with the information in the course record ACADEMIC YEAR DESC Description of the academic year code ADMINISTRATIVE GROUP Administrative group domain column for future use not currently populated APPORTIONMENT OVERRIDE Registration override code if apportion2. SATURDAY IND Indicates that the session meets on Saturdays SCHED CONFLICT OVERRIDE DESC Description associated with the schedule conflict override SCHEDULE Schedule type code such as lecture lab self paced and so on for the session December 2012 Banner California Community Colleges Baseline Operational Data Store 8 1 3 11 Handbook Reporting Views View Column Name SCHEDULE CONFLICT OVERRIDE Description Indicator for whether an override was required to schedule this meeting record and if so whether it was overridden due to aroom conflict time conflict or both SCHEDULE DESC Description associated with the schedule type code SCHEDULE STATUS Schedule status SCHEDULE STATUS DESC E Description associated with the schedule status SECTION Section of the course reference number CRN This is called the offering number in the SECTION ATTENDANCE CALB reporting view SECTION DESC Section of the course SESSION CREDIT HOURS Session credit hours START DAT GI Session meeting start date SUBJECT Subject code associated with the course reference number CRN of the meeting time record SUBJECT DESC Description of the subject code SUNDAY IND Indicates that the session meets on Sundays THURSDAY IN
3. C PERIOD DESC Description of the academic period or term associated with the academic period code ACADEMIC YEAR Academic year associated with the information in the section record for apportionment reporting ACADEMIC YEAR DESC Description of the academic year associated with the academic year code ACTIVE OFFERING IND Indicator for whether the offering is active ADMINISTRATIVE GROUP Administrative group domain column for future use not currently populated 3 2 Banner California Community Colleges Baseline Operational Data Store 8 1 December 2012 Handbook Reporting Views View Column Name ATTENDANCE METHOD Description California Community College attendance method used for apportionment reporting Valid values are as follows e ACTUAL Actual e DAILY Daily Census e ISDAY Independent Study Daily Credit e ISNC Independent Study Weekly Non credit e ISWEEK Independent Study Weekly Credit e UNKNOWN Setup is incorrect e WEEKLY Weekly Census ATTENDANCE METHOD DESC Description of the California Community College attendance method CAMPUS Campus on which the section is scheduled CAMPUS DESC Description of the campus associated with the campus code Census date for the section Census 2 date for the section COURSE IDENTIFICATION Course subject and c
4. D Indicates that the session meets on Thursdays TITLE LONG DESC Long title of the course TITLE SHORT DESC Short title of the course TO BE ANNOUNCED IND To be announced indicator for the session s meeting type code specifying whether the meeting days meeting times or both are currently unscheduled TUESDAY IND Indicates that the session meets on Tuesdays WEDNESDAY IND Indicates that the session meets on Wednesdays 3 12 Banner California Community Colleges Baseline Operational Data Store 8 1 December 2012 Handbook Reporting Views
5. E mapping followed by its associated UPDATE mapping CALB ODS is delivered with a number of mappings already defined LOAD DELETE and UPDATE mappings exist for each CALB composite table in ODS To make it easier to work with the mappings two jobs load and refresh are available to run all the CALB mapping at the same time December 2012 Banner California Community Colleges Baseline Operational Data Store 8 1 2 1 Handbook Administrative User Interface CALB ODS delivers the Oracle Warehouse Builder mappings shown in the following table You can view these from the design center of the Oracle Warehouse Builder client Mapping Action Reporting View DELETE MST MEETING TIME CALB Refreshes inserted deleted or updated rows MEETING TIME CALB UPDATE MEETING TIME CALB Refreshes inserted deleted or updated rows MEETING TIME CALB DELETE MST SECTION ATTEND CALB Refreshes inserted deleted or updated rows SECTION ATTENDANCE CALB UPDATE MST SECTION ATTEND CALB Refreshes inserted deleted or updated rows SECTION ATTENDANCE CALB DELETE MST STUDENT ATTEND CALB Refreshes inserted deleted or updated rows STUDENT_ATTENDANCE_CALB UPDATE_MST_STUDENT_ATTEND_CALB Refreshes inserted deleted or updated rows STUDENT_ATTENDANCE_CALB LOAD MST MEETING TIME CALB Loads all rows MEETING TIME CALB LOAD MST SECTION ATTEND CALB Loads all rows SECTION _ATTEND
6. LDING Building where the session is to take place This is not required when scheduling session meeting times but is required when scheduling session meeting rooms BUILDING_DESC Description associated with the building code BUILDING SITE Site or location where the student is attending or obtaining instruction BUILDING SITE DESC Description associated with the site or location CATEGORY Session indicator CLASS TYPE Session class type CLASS TYPE DESC Class type description December 2012 Banner California Community Colleges Baseline Operational Data Store 8 1 3 9 Handbook Reporting Views View Column Name COMMITTEE Description Committee COMMITTEE DESC Description associated with the committee COURSE_CAMPUS Campus scheduling the offering COURSE CAMPUS DESC Description associated with the course reference number s CRN s campus COURSE I UO ENTIFICATION Course subject and course number combined COURSE NUMBER Course number associated with the course reference number CRN of the meeting time record COURSE REFERENCE NUMBER Course reference number CRN CRN assigned to this course section when it was initially added E z D_DATE Session meeting end date E 2 D TIME End time of the session being scheduled T
7. View Column Name PROJECTED NONRES ENROLLMENT Description Projected number of California non resident students counted in apportionment PROJECTED NONRES FTES California FTES calculation for non resident enrollment in a section This value is calculated as the product of total contact hours and non resident enrollment divided by 525 PROJECTED RESIDENT ENROLLMENT Projected number of California resident students counted in apportionment PROJECTED RESIDENT FTES California FTES calculation for resident enrollment ina section This value is calculated as the product of total contact hours and resident enrollment divided by 525 REFUND CUTOFF DATE Refund cutoff date for the section START DATE Start date for the section For traditional sections this is the part of term start date defined for this section For open learning sections the learner start date is used and it is the first possible start date for any student SUBJECT Subject area of the course SUBJECT DESC Description of the subject associated with the subject code TERM LENGTH MULTIPLIER Weekly or Independent Study Weekly term length multiplier used in total hours calculation for weekly attendance type sections TOTAL CONTACT HOURS Calculated total contact hours for the section
8. _CALB LOAD MST STUDENT ATTEND CALB Loads all rows STUDENT _ATTEND_CALB Schedule a process You can schedule a job to run at a specific time To run load and refresh update jobs select Schedule a Process on the Options menu of the Administrative UI The Load process uses the Load mapping e The Load Mapping uses the Composite view to pull data from the Staging tables e The Load Mapping uses the Composite view to populate the Composite tables The Refresh process uses the Delete and Update mapping e The Delete Mapping deletes the Change tables e The Update Mapping uses the Staging table triggers to populate the Changes tables e The Update Mapping uses the Change tables with the Composite views to update the Composite tables 2 2 Banner California Community Colleges Baseline Operational Data Store 8 1 Handbook Administrative User Interface December 2012 The following CALB ODS jobs are available from the Schedule Banner ODS Mappings menu e Load CALB loads all CALB data in CALB composite tables e Refresh CALB refreshes changed records in CALB composite tables In addition to the CALB ODS refresh and load jobs the CALB mappings are integrated into the Student jobs e Load Student loads data into the composite tables for reporting views such as STUDENT ATTENDANCE CALB SECTION ATTENDANCE CALB and MEETING TIME CALB e Refresh Student refreshes data in the composit
9. able or multiple tables in the source system with the number of rows in the composite tables in Banner ODS Run a reconcile group job A custom reconcile group named CALB CALB Reporting Views 1s available to compare the CALB reporting views to the source tables Use the following steps to run the custom CALB reconcile group 1 2 10 11 Click Options from the Administrative UI menu Click Schedule a Process Click Banner ODS Utilities Click Reconcile a Group of Tables Choose the Reconciliation Type Choose CALB CALB Reporting Views from the Reconcile Group drop down list that you want to run You can reconcile a group in either ROWCOUNT or DATA mode The DATA mode reconcile process does a complete row by row column by column compare of data Depending on the amount of data involved the reconcile process can take a long time to complete in this mode To display the sql statement used in the process check the Show SQL check box Check the Retain Output Table check box to keep the temporary output table Enter a Run Date format dd mon yyyy and Run Time format hh24 mi ss Enter NOW in each field to run the job immediately Click Submit to run the job Refer to the Banner Operation Data Store Handbook for more information about Banner ODS utilities and the available parameter options for the reconcile groups 2 4 Banner California Community Colleges Baseline Operational Data Store 8 1 December 2012 Handboo
10. airfax Virginia 22033 United States of America Revision History Publication Date Summary December 2012 New version that supports Banner California Community Colleges Baseline Operational Data Store 8 1 software Banner California Community Colleges Baseline Operational Data Store 8 1 Contents E E Chapter Introduction is ccisgsiculagindiaehoradaciadevatersiveieatateseawiatass 1 1 Related Documentation 00022 eee ee 1 2 Prerequisites 00 6 24 ir we ee A Se ee ae amp A 1 2 Chapter 2 Administrative User Interface 0 ccc cece cece eee 2 1 Set up and synchronize data o o ees 2 1 Schedule a process a 2 2 Metadata o resser ea bene ko SE Sel ow ade eg eat ed bok 2 3 Banner ODS Utilities oie cir eG ache a ra 2 4 Runareconcile groUpjOb sesede o o ee 2 4 Chapter 3 Reporting ViewWS o oooococococcocococonnccnnr rr 3 1 Summary of CCFS 320 datainCALBODS 3 1 SECTION_ATTENDANCE CALB 0 0 0 3 2 STUDENT_ATTENDANCE CALB o 3 6 MEETING TIME CAUB 0 2 aus baaa he ee 3 9 December 2012 Banner California Community Colleges Baseline Operational Data Store 8 1 iii Handbook Contents iv Banner California Community Colleges Baseline Operational Data Store 8 1 December 2012 Handbook Contents 1 Introduction The Banner Operational Data Store Banner ODS enables you to extract information from your source administrat
11. dbook Reporting Views View Column Name OFFERING NUMBER Description Offering number of a course An offering number can only be used once to identify a subject course number combination in a term although multiple offerings of a course can share a 0 offering number PART OF TERM Part of term for the section PART OF TERM DESC Description associated with the part of term TU ERSON_UID Student PIDM Specifies the internal identification number of the student PROCESS GROUP Process group zone column for future use not currently populated REG STATUS AT CENSUS Registration status from audit history as of the census 1 date REG STATUS AT CENSUS D ie nN Q Description of the census 1 registration status REG STATUS AT CUTOFF Registration status from audit history as of the academic cutoff date REG STATUS AT CUTOFF DESC Description of the academic cutoff registration status REG STATUS CURRENT Current registration status associated with this CRN REG STATUS CURRENT DESC Description of current registration status REGISTRATION SEQUENCE NUMBER Registration sequence number SUBJECT Subject area of the course SUBJECT DESC Description of the subject associated with the subject code TOTAL CONTACT HOURS Total contact hours for t
12. e Oracle Database 11 2 0 2 0 or 11 2 0 2 5 for both source and target databases e Oracle Warehouse Builder 11 2 0 2 0 or 11 2 0 2 5 1 2 Banner California Community Colleges Baseline Operational Data Store 8 1 December 2012 Handbook Introduction 2 Administrative User Interface a Options in the Administrative User Interface UI enable you to easily perform the tasks required to set up and maintain the Banner CALB elements of CALB ODS at your institution This chapter discusses the following topics e Set up and synchronize data on page 2 1 e Schedule a process on page 2 2 e Metadata on page 2 3 Set up and synchronize data Maintaining current data in Banner ODS is key to producing accurate reports ODS uses programs Oracle Warehouse Builder OWB mappings to associate elements in the administrative system with their corresponding elements in ODS When you run a job that is schedule a process using the Administrative UJ it calls the related mappings and loads or updates the data defined by them ODS includes the following main categories of mappings LOAD mappings load data from the administrative system into ODS These mapping names include a LOAD prefix e REFRESH mappings update ODS with data that has changed in the administrative system These mapping names include an UPDATE or DELETE prefix Typically these mappings exist in pairs To perform a complete refresh you run the DELET
13. e tables for reporting views such as STUDENT ATTENDANCE CALB SECTION ATTENDANCE CALB and MEETING TIME CALB Refer to the Banner Operation Data Store Handbook for instructions on how to run these processes Metadata Metadata is data about data or information and characteristics about data entities such as a column name description format length origin and destination Metadata in ODS provides the following types of information e Data columns in ODS e Definition of each data column s business use e Type of data number character date and so on e How long the data column is e Where in the source system the data column comes from Data column s destination in the target system CALB ODS includes reporting views and source composite views with the original source tables and source column names From the Subject Area drop down list in the Administrative Ul select the CALB option to view the metadata for that area The metadata can then be viewed online or it can be output to an HTML file December 2012 Banner California Community Colleges Baseline Operational Data Store 8 1 2 3 Handbook Administrative User Interface Banner ODS Utilities The Utilities process contains utility jobs or processes that perform various administrative tasks and provide ongoing maintenance of the Banner ODS For example the Utilities option enables you to compare the number of rows in one t
14. ellucian Banner California Community Colleges Baseline Operational Data Store Handbook Release 8 1 December 2012 Banner Colleague PowerCAMPUS Luminis and Datatel are trademarks of Ellucian or its affiliates and are registered in the U S and other countries Ellucian Advance DegreeWorks fsaATLAS Course Signals SmartCall Recruiter MOX ILP and WCMS are trademarks of Ellucian or its affiliates Other names may be trademarks of their respective owners 2012 Ellucian All rights reserved The unauthorized possession use reproduction distribution display or disclosure of this material or the information contained herein is prohibited Contains confidential and proprietary information of Ellucian and its subsidiaries Use of these materials is limited to Ellucian licensees and is subject to the terms and conditions of one or more written license agreements between Ellucian and the licensee in question In preparing and providing this publication Ellucian is not rendering legal accounting or other similar professional services Ellucian makes no claims that an institution s use of this publication or the software for which it is provided will insure compliance with applicable federal or state laws rules or regulations Each organization should seek legal accounting and other similar professional services from competent providers of the organization s own choosing Prepared by Ellucian 4375 Fair Lakes Court F
15. he registration record when the apportionment status is C Counted 3 8 Banner California Community Colleges Baseline Operational Data Store 8 1 December 2012 Handbook Reporting Views MEETING_TIME CALB This CALB reporting view includes California Community College contact hour calculations and other scheduling data for each meeting record in a section A meeting record is a session defined for a section or course reference number CRN This view has no special adjustments for CCFS 320 projections View Column Name Description ACADEMIC PERIOD Academic period or term associated with the course reference number CRN of the meeting time record ACADEMIC PERIOD DESC Description of the academic period code ACADEMIC YEAR Academic year associated with the course reference number CRN of the meeting time record ACADEMIC YEAR DESC Description of the academic year code ADMINISTRATIVE GROUP Domain column for future use not currently populated BEGIN TIMI GI Begin time of the session being scheduled This is a required field and must be in HHMM format using 24 hour time BREAK MINUTES Calculated California Community College break minutes This is calculated based on the begin and end time of the meeting and is used only when the contact hours override indicator is unchecked and the contact hours are calculated not manually entered BUI
16. his is a required field and must be in HHMM format using 24 hour time EVENT FUNCTION Event function EVENT FUNCTION DESC Description associated with the event function FIRST M T ET DATE First day the scheduled meeting will occur This is the CALB calculated start date for this session It uses the session meeting start date START DATE and the checked day indicators to calculate the first actual meeting date related to this session FRIDAY IND Indicates that the session meets on Fridays HOURS OVERRIDE IND Indicator for whether the total weekly and daily hours calculations are overridden by manual entry INSTRUCTION DELIVERY MODE E Instructional delivery mode of the session INSTRUCTION DELIVERY MODE DESC Instructional delivery mode LAB_IND Indicator for the session s meeting type code specifying whether the meeting is a lab MEETING ACTIVITY DATE Date record was inserted or updated 3 10 Banner California Community Colleges Baseline Operational Data Store 8 1 December 2012 Handbook Reporting Views View Column Name MEETING_HOURS Description Calculated California Community College contact hours per week for the meeting This is calculated when the hours override is set to No and is manually entered when the hours override
17. ions For example tables and views that include SECTION in the title relate to the Banner section entity and tables For example the AS_SECTION_ATTENDANCE and SECTION ATTENDANCE CALB views contain data relating to the Banner section for a course December 2012 Banner California Community Colleges Baseline Operational Data Store 8 1 1 1 Handbook Introduction Related Documentation In addition to this handbook the following documentation supports your work with CALB ODS processing Banner Operational Data Store Handbook a user manual describing the setup and use of the Operational Data Store ODS product Banner California Community Colleges Baseline Handbook a handbook describing the setup and use of CALB which is used with Banner General and Banner Student Banner Getting Started Guide a user reference manual that describes the features and components of the Banner system and Banner Online Help Prerequisites E Note CALB ODS 8 1 version is designed as a new install and should not be installed on the earlier version of CALB ODS 8 0 CALB ODS 8 0 was a controlled testing release and is not meant for production use CALB 8 1 includes all the database components and Oracle warehouse components found in CALB ODS 8 0 m The minimum required releases for CALB ODS 8 1 are as follows e Banner ODS 8 4 e Banner General 8 5 or higher Banner Student 8 5 3 or higher e CALB 8 6 1 or higher
18. is Yes MEETING HOURS DAY Calculated California Community College contact hours per day for the meeting This is calculated when the hours override is set to No and is manually entered when the hours override is Yes MEETING HOURS TOTAL Total California Community College contact hours for the meeting This is calculated when the hours override is set to No and is manually entered when the hours override is Yes MEETING TYPE Meeting type MEETING TYPE DESC Description associated with the meeting type MONDAY IND Indicates that the session meets on Mondays MULTI SOURCE Institution value for the record when the optional multi institution facility feature has been installed and applied for this table column MULTI SOURCE DESC Institution description for the record when the optional multi institution facility feature has been installed and applied for this table column PART OF TERM Part of term associated with the course reference number CRN of the meeting time record PART OF TERM DESC Description associated with the part term code PROCESS GROUP Zone column for future use not currently populated ROOM Room where the session is to take place This is not required when scheduling session meeting times but is required when scheduling a session meeting building
19. ive systems and reorganize that information into a simplified set of tables and views in the Banner ODS database End users can then create and deploy operational and ad hoc reports on this information Banner ODS provides an extensive and flexible data store as well as business organized reporting views with fewer columns and improved performance You can use these views alone or in combination with other views when producing reports Using this solution your institution can take full advantage of the data stored in your source system by turning it into applied knowledge that can help you make informed decisions guide strategic institutional planning and forecasting based on analysis of historical trends and enhance institutional performance The Banner California Community Colleges Baseline Operational Datastore CALB ODS incorporates CALB data structures allowing users to extract transform and load CALB data into the ODS database The CALB ODS reporting area includes California Community College specific reporting elements such as contacts hours resident and non resident enrollment counts and apportionment status This handbook provides details about the objects that have been delivered with CALB ODS Note This handbook assumes that you have a working knowledge of ODS If you need more information about how to use Banner and ODS see Related Documentation on page 1 2 m The ODS tables and views use Banner naming convent
20. k Administrative User Interface m 3 Reporting Views E a CALB data from your source system database is used to populate Banner ODS composite tables This data can be retrieved in reports using the CALB ODS reporting views Use the Administrative User Interface UI to maintain and view metadata reports for each composite view data on the source system used as an intermediate step to produce the composite tables and reporting views and reporting view This chapter describes the reporting views included in Banner CALB ODS e Summary of CCFS 320 data in CALB ODS on page 3 1 e SECTION ATTENDANCE CALB on page 3 2 e STUDENT ATTENDANCE CALB on page 3 6 e MEETING TIME _CALB on page 3 9 Summary of CCFS 320 data in CALB ODS CALB ODS calculates projected or estimated contact hours and FTES It does not replace the CALB CCFS 320 reports which are still the source for actual apportionment contact hours and FTES The following table provides a summary of some of the major differences in how the projected calculations differ from the actual CALB CCFS 320 CALB ODS Projected ACTUAL CRN Apportionment status C Apportionment status D dropped students counted with the attendance dropped not counted to hours for the contact hours conservatively underestimate contact hours and FTES ISNC CRNs Uses two census averaging Only project contact hours and method FTES based on the census 1 data d
21. ment override was used for CCFS 320 reporting Only override codes that are coded as exclude from apportionment are saved here All other codes are ignored similar to CCFS 320 reporting APPORTIONMENT OVERRIDE DESC Description of registration override code APPORTIONMENT STATUS Code to identify whether this record counts in apportionment or not and if not why not in California CCSF 320 reporting This is the projected apportionment status If this is a census CRN using two census averaging ATTENDANCE METHOD of SNC it is only evaluating census 1 Valid values are as follows e A Audit C Counted D Drop E Exclude e O exception 3 6 Banner California Community Colleges Baseline Operational Data Store 8 1 December 2012 Handbook Reporting Views View Column Name APPORTIONMENT STATUS DESC Description Description of the apportionment status CALIFORNIA RESIDENT_IND Indicator for whether the student is an in state resident or out of state non resident CONCURRENT HIGH SCHOOL IND Indicator for whether the student is concurrently enrolled in high school CONTACT HOURS Contact hours for the registration record If the attendance method for the section is DAILY ACTUAL or ISDAY this is the section projected daily contact hours If the attendance method is WEELKY ISNC or ISWEEK this is the projected weekly contact hours This val
22. nstitution facility feature has been installed and applied for this table column MULTI SOURCE DESC Institution description for the record when the optional multi institution facility feature has been installed and applied for this table column NUMBER _OF LAB MEETINGS Number of lab only days this section meets Since this value is derived from a baseline function in SSAACCL it has a limitation It will not account for an assumed meeting pattern of Monday through Friday for TBA only sections It uses the meeting type lab indicator to determine whether the meeting record is a lab NUMBER_OF MEETINGS Number of days this section meets Since this value is derived from a baseline function in SSAACCL it has a limitation It will not account for assumed meeting pattern of Monday through Friday for TBA only sections OFFERING NUMBER Offering number of a course An offering number can only be used once to identify a subject course number combination in a term although multiple offerings of a course can share a 0 offering number PART OF TERM Part of term for the section PART OF TERM DESC Description associated with the part of term PROCESS GROUP Process group zone column for future use not currently populated 3 4 Banner California Community Colleges Baseline Operational Data Store 8 1 December 2012 Handbook Reporting Views
23. oes not evaluate census 2 for averaging December 2012 Banner California Community Colleges Baseline Operational Data Store 8 1 3 1 Handbook Reporting Views CALB CCFS 320 CALB ODS Projected Number of meetings Uses the assumed meeting Ignores the assumed meeting pattern logic to calculate the pattern logic SSAACCL displayed value when TBA meetings are included in a daily or actual CRN SVRCALX exception Any CRN with an exceptionis Only the not reported messages not included in CCFS 320 exceptions STVACCT code reporting with no indicators checked are considered All other exceptions are ignored SECTION _ATTENDANCE CALB This CALB reporting view includes California CCSF 320 related reporting elements such as enrollment contact hours and projected FTES It returns one row per section The CCFS 320 numbers are projections or estimates They have some variations from the final apportionment reported values in order to allow estimating early in the reporting year cycle For example the daily contact hour value is used to project FTES for a positive attendance section Additionally the section error checking CCFS 320 report exceptions list is not considered in the projections View Column Name ACADEMIC CUTOFF DATE Description Academic cutoff date for the section ACADEMIC PERIOD Academic period or term associated with the information in the section record ACADEMI
24. ourse number combined COURSE NUMBER Course number associated with the subject for the course COURSE REFERENCE NUMBE Course reference number CRN assigned to this section when it was initially added DAILY CONTACT HOURS Calculated daily contact hours for the section This field is null when the attendance type is WEEKLY ISWEEK ISNC ISDAY or UNKNOWN DISTRICT District associated with the campus for which the section is scheduled DISTRICT DESC Description of the district associated with the campus code DROP_CUTOFF DATE Drop cutoff date for the section December 2012 Banner California Community Colleges Baseline Operational Data Store 8 1 3 3 Handbook Reporting Views View Column Name END_DATE Description End date for section For traditional sections this is the part of term end date defined for this section For open learning sections the learner end date is derived as a calculation of duration units and it is the last possible end date for any student ENROLLMENT CUTOFF DATE Enrollment cutoff date for the section FIRST MEET DATE First date the section meets This is the CALB calculated start date MAXIMUM ENROLLMENT Maximum enrollment for the section MULTI_SOURCI El Institution value for the record when the optional multi i
25. ue is null if not counted in apportionment COURSE IDENTIFICATION Course subject and course number combined COURSE NUMBER Course number associated with the subject for the course COURSE REFERENCE NUMBER Course reference number CRN assigned to this section when it was initially added HOURS ATTENDED Number of hours the student attended this class This is used in apportionment calculations for positive attendance courses but it is not used for the projected CCFS 320 calculations LAST ATTEND DATE Last date the student attended the class if it was recorded by the instructor ENGTH MULTIPLIER Length multiplier for the registration record If the attendance method is ACTUAL DAILY or ISDAY this is the number of meetings If the attendance method is WEEKLY this is the term length multiplier If the attendance method is JSNC or ISWEEK this is the independent study term length multiplier MULTI SOURCE Institution value for the record when the optional multi institution facility feature has been installed and applied for this table column MULTI SOURCE DESC Institution description for the record when the optional multi institution facility feature has been installed and applied for this table column December 2012 Banner California Community Colleges Baseline Operational Data Store 8 1 3 7 Han
Download Pdf Manuals
Related Search