CBEDS-ORA File B - CDIF Sections B, C and SIF Sections B, C, D, E, F, G
Introduction
The CBEDS-ORA File B extract generates a file to upload to the CBEDS-ORA Data portal. This extract is used to generate the Type B record of the CBEDS electronic data file. The Type B Record includes Section B and C counts from the County/District Information Form (CDIF) and Section B, C, D, E, F and G counts from the School Information Form (SIF).
Each section of the Type B record of the CBEDS electronic data file contains the following information:
CDIF Section B - The estimated number of teacher new hires by subject area for the upcoming school year. When entering data, include teachers and specialized positions. Do not include administrative, guidance, media, library, health services or non-certified positions. To enter estimated new teacher hire data, navigate to District Setup > District Info > District New Hire Forecast.
CDIF Section C - The number of requested and granted H1-B work visa applications.
SIF Section B - The kindergarten program(s) offered at the school.
SIF Section C - The number of requested and granted H1-B work visa applications.
SIF Section D - The school's Calendar Type.
SIF Section E - The Estimated Number of Teacher Hires
SIF Section F - Multilingual Instructional Programs
SIF Section G - Language(s) of Instruction
Selection Criteria
Selection criteria determine which database records are used in the report.
Student Selection
The report selects which student records from the [Students], [S_CA_STU_ELA_C], or [ReEnrollments] tables based on the following criteria:
The student must not be excluded from state reporting.
The student must be enrolled in grade level K (0) through 12.
The student must be enrolled in a school included in the report. The school must not be excluded from state reporting. The school must have a valid 7-digit CALPADS school number.
The student's school enrollment Exit Date must occur after the CBEDS Count Date entered when running the report.
The student's school enrollment Entry Date must occur on or before the CBEDS Count Date when running the report.
The student's school enrollment Exit Date must occur after the Entry Date.
Staff Selection
The report selects staff records from the [Teachers] table based on the following criteria:
The staff member's Staff Providing Instructional Services to English Learners must be set to (3) Bilingual Paraprofessional Providing Primary Language Support to ELs.
The staff member's Language of Instruction must be a valid foreign language (not English or American Sign Language). If instruction is provided in more than one language, choose the language taught most frequently. If there is a tie, choose the language with the lowest numeric code value.
Note: If a bilingual paraprofessional works at more than one school, flag the person at the school in which he or she spends the majority of time providing EL instructional services.
Report Input
This report is run at the School(s) and District level.
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
---|---|
Use | If run at the district level, choose one of the following from the pop-up menu:
If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list. |
Processing Options | Choose a time to run the report from the pop-up menu:
|
Specific Date/Time | Enter a date using the format mm/dd/yyyy or mm-dd-yyyy in order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry. Use the pop-up menus to schedule the report to be run at a specific hour and minute. Example: 7/29/2008 @ 10 AM : 05. |
CBEDS Count Date | Enter the CBEDS count date. |
Last Year’s CBEDS Count Date | Enter the CBEDS count date from the previous year. |
Select Sub-District | If you are at the School Level, you can select only the Current School. If you are at the district level, you can choose the sub-district and select the list of schools in the sub-district. You need to set up sub-district to view the schools in the subdistrict.
|
Select Schools or Leave blank to process CDIF data and SIF data for all schools | If only [District and All Schools] is selected or if this field is left blank, then the district CDIF data and SIF data for all schools will be generated. Only schools with a 7-digit CALPADS school number will be displayed in this list and processed. Choose one or more schools to include in the report. Select multiple schools by pressing the shift, command or control keys while clicking in the list. Note: Schools with identical CSIS School Numbers are aggregated. |
Graduation Set (Choose one per district) | Choose a Graduation Set from the pop-up menu. The Graduation Set determines which course enrollments are used to calculate whether the student has the required number of units to earn a graduation diploma for this school year. |
Number of Units Credited for a One-year Course | Enter the number of units that are awarded when a student completes a one-year course. |
Include Column Headings | Choose No Delimiters (can be uploaded) or Include Delimiters (cannot be uploaded) from the pop-up menu. Including delimiters in the file makes each field easier to view. |
Report Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Note: Each row is only output if the value is non-zero.
Report Output Format: The report output format for CBEDS-ORA File B is tab delimited. For SIF and CDIF, the report output is html.
Item # | Data Element | Description | [Table]FieldName |
---|---|---|---|
1 | Row Indicator | Always “D” | N/A |
2 | Source | The source of the data, either CDIF or SIF. | N/A |
3 | Year | The school year, output in the format Y1Y2. For example, the 2018-2019 school year is output as 1819. | [Terms]FirstDay [Terms]LastDay |
4 | Record Type | Always “B” | N/A |
5 | CDS Code | The 14 digit CDS associated with the school included in the report. If the report is run for the district, the report extracts the district number. | [Prefs]Value where [Prefs]Value = districtnumber [S_CA_SCH_X]StateSchoolNumber |
6 | Form Section | The source section from the CDIF or SIF form. The report extracts either B or C for CDIF and B, C, D, E ,F, or M for SIF. | N/A |
7 | Row Number | The data row number.
| N/A |
8 | Value | The report extracts the value for the group listed in the table in the following section, Report Output – Rows. | N/A |
9 | Level | The report extracts “D” for district records and “S” for school records. | N/A |
CDIF Form Section B - Teacher HiresThe estimated number of teacher new hires by subject area for the upcoming school year. When entering data, include teachers and specialized positions. Do not include administrative, guidance, media, library, health services, or non-certified positions. To enter estimated new teacher hire data, navigate to District Setup > District Info > District New Hire Forecast. The report extracts the value entered on the District New Hire Forecast page. | |||
1 | Agriculture | The number of new hires who specialize in agriculture. | [Prefs]Value where [Prefs]Name = CA_NewHireAgric |
2 | Art | The number of new hires who specialize in arts. | [Prefs]Value where [Prefs]Name = CA_NewHireArt |
3 | Bilingual Education | The number of new hires who specialize in bilingual education. | [Prefs]Value where [Prefs]Name = CA_NewHireBilingEd |
4 | Business | The number of new hires who specialize in business. | [Prefs]Value where [Prefs]Name = CA_NewHireBusiness |
5 | Dance | The number of new hires who specialize in dance. | [Prefs]Value where [Prefs]Name = CA_NewHireDance |
6 | English and/or Drama | The number of new hires who specialize in English and/or drama. | [Prefs]Value where [Prefs]Name = CA_NewHireEnglish |
7 | Foreign Language | The number of new hires who specialize in foreign language. | [Prefs]Value where [Prefs]Name = CA_NewHireForeignLang |
8 | Health | The number of new hires who specialize in health. | [Prefs]Value where [Prefs]Name = CA_NewHireHealth |
9 | Home Economics | The number of new hires who specialize in home economics. | [Prefs]Value where [Prefs]Name = CA_NewHireHomeEd |
10 | Life Science | The number of new hires who specialize in life science. | [Prefs]Value where [Prefs]Name = CA_NewHireLifeSci |
11 | Mathematics | The number of new hires who specialize in mathematics. | [Prefs]Value where [Prefs]Name = CA_NewHireMath |
12 | Music | The number of new hires who specialize in music. | [Prefs]Value where [Prefs]Name = CA_NewHireMusic |
13 | Physical Education/Health/Dance | The number of new hires who specialize in physical education/health/dance. | [Prefs]Value where [Prefs]Name = CA_NewHirePE |
14 | Physical Science | The number of new hires who specialize in physical science. | [Prefs]Value where [Prefs]Name = CA_NewHirePhySci |
15 | Reading | The number of new hires who specialize in reading. | [Prefs]Value where [Prefs]Name = CA_NewHireReading |
16 | Self-contained Classes | The number of new hires who specialize in self-contained classes. | [Prefs]Value where [Prefs]Name = CA_NewHireSelfCont |
17 | Special Education | The number of new hires who specialize in special education. | [Prefs]Value where [Prefs]Name = CA_NewHireSpecEd |
18 | Social Science/Studies | The number of new hires who specialize in social science/studies. | [Prefs]Value where [Prefs]Name = CA_NewHireSocialSci |
19 | Theater | The number of new hires who specialize in theater. | [Prefs]Value where [Prefs]Name = CA_NewHireTheater |
20 | Trades and Industrial Arts | The number of new hires who specialize in trades and industrial arts. | [Prefs]Value where [Prefs]Name = CA_NewHireTrade |
21 | Other Specialization | The number of new hires who have a specialization other than those listed. | [Prefs]Value where [Prefs]Name = CA_NewHireOther |
CDIF Form Section C - Work Visa ApplicationsReport the number of H-1B work visa applications applied for on behalf of potential employees, and the number of those via applications that were granted. | |||
1 | Number of H-1B work visa applications submitted | The number of H-1B work visa applications submitted on behalf of potential employees. Note: The request date must occur between last year’s CBEDS date and this year’s CBEDS date. | N/A |
2 | Number of H-1B work visa applications granted | The number of H-1B work visas granted. | N/A |
SIF Form Section B - Kindergarten Program TypeReport the type of kindergarten and transitional kindergarten program offered by the school by selecting the appropriate program type below. Note: Transitional kindergarten programs must be of equal length as kindergarten programs except in the case of an approved State Board of Education waiver on file. Refer to the Glossary and the SIF instructions in the CBEDS Administrative Manual for further information. | |||
1 | Kindergarten Program (select one) | Select one of the following kindergarten programs:
| N/A |
2 | Transitional Kindergarten Program (select one) | Select one of the following transitional kindergarten programs:
| N/A |
SIF Form Section C - Work Visa Applications (For Charter Schools only)Report the number of H-1B work visa applications applied for on behalf of potential employees, and the number of those via applications that were granted. | |||
1 | Number of H-1B work visa applications submitted | The number of H-1B work visa applications submitted on behalf of potential employees. Note: The request date must occur between last year’s CBEDS date and this year’s CBEDS date. | N/A |
2 | Number of H-1B work visa applications granted | The number of H-1B work visas granted. | N/A |
SIF Form Section D - Educational CalendarThe value 'True' is reported for the educational calendar assigned to the school. Single-track and multitrack should not be reported for a single school. If any part of the school calendar is traditional and year-round, select more than one type of calendar: traditional and single-track or traditional and multitrack. When selecting multitrack or single track, an additional record must be submitted which contains the year round calendar type. | |||
1 | Traditional | The value 'True' is extracted if the calendar type is 24. | [S_CA_SCH_X]CalendarType = 24 |
2 | Single Track | The value 'True' is extracted if the calendar type is 17 – 23, or 32 – 38. | [S_CA_SCH_X]CalendarType = 17 – 23, or 32 – 38 |
3 | Multitrack | The value 'True' is extracted if the calendar type is 10 – 16, or 25 – 31. | [S_CA_SCH_X]CalendarType = 10 – 16, or 25 – 31 |
4 | School Calendar Duration – 60/20 | The value 'True' is extracted if the calendar type is 19, 34, 14, or 29. | [S_CA_SCH_X]CalendarType = 19, 34, 14, or 29 |
5 | School Calendar Duration – 90/30 | The value 'True' is extracted if the calendar type is 20, 35, 15, or 30. | [S_CA_SCH_X]CalendarType = 20, 35, 15, or 30 |
6 | School Calendar Duration – Custom | The value 'True' is extracted if the calendar type is 22, 37, 16, or 31. | [S_CA_SCH_X]CalendarType = 22, 37, 16, or 31 |
7 | School Calendar Duration – 60/15 | The value "'True'" is extracted if the calendar type is 18, 33, 13, or 28. | [S_CA_SCH_X]CalendarType = 18, 33, 13, or 28 |
8 | School Calendar Duration – 45/15 | The value 'True' is extracted if the calendar type is 17, 32, 12, or 27. | [S_CA_SCH_X]CalendarType = 17, 32, 12, or 27 |
9 | School Calendar Duration – Modified Concept | The value 'True' is extracted if the calendar type is 23, 38, 11, or 26. | [S_CA_SCH_X]CalendarType = 23, 38, 11, or 26 |
10 | School Calendar – Start Date | First day of school. If on a multitrack calendar, the first day for the earliest track is reported. If reporting multiple schools with the same 7-digit school number, the report takes the earliest date found across schools. | [Calendar_Day]InSession = 1 [Calendar_Day]Date [S_CA_SCH_X]StateSchoolNumber |
11 | School Calendar – End Date | Last day of school. If on a multitrack calendar, the last day for the latest track is reported. If reporting multiple schools with the same 7-digit school number, the report takes the latest date found across schools. | [Calendar_Day]InSession = 1 [Calendar_Day]Date [S_CA_SCH_X]StateSchoolNumvber |
SIF Form Section E - Teacher HiresThe estimated number of teacher new hires by subject area for the upcoming school year. When entering data, include teachers and specialized positions. Do not include administrative, guidance, media, library, health services, or non-certified positions. To enter estimated new teacher hire data, navigate to District Setup > District Info > District New Hire Forecast. The report extracts the value entered on the District New Hire Forecast page. | |||
1 | Agriculture | The number of new hires who specialize in agriculture. | [Prefs]Value where [Prefs]Name = CA_NewHireAgric |
2 | Art | The number of new hires who specialize in arts. | [Prefs]Value where [Prefs]Name = CA_NewHireArt |
3 | Bilingual Education | The number of new hires who specialize in bilingual education. | [Prefs]Value where [Prefs]Name = CA_NewHireBilingEd |
4 | Business | The number of new hires who specialize in business. | [Prefs]Value where [Prefs]Name = CA_NewHireBusiness |
5 | Dance | The number of new hires who specialize in dance. | [Prefs]Value where [Prefs]Name = CA_NewHireDance |
6 | English and/or Drama | The number of new hires who specialize in English and/or drama. | [Prefs]Value where [Prefs]Name = CA_NewHireEnglish |
7 | Foreign Language | The number of new hires who specialize in foreign language. | [Prefs]Value where [Prefs]Name = CA_NewHireForeignLang |
8 | Health | The number of new hires who specialize in health. | [Prefs]Value where [Prefs]Name = CA_NewHireHealth |
9 | Home Economics | The number of new hires who specialize in home economics. | [Prefs]Value where [Prefs]Name = CA_NewHireHomeEd |
10 | Life Science | The number of new hires who specialize in life science. | [Prefs]Value where [Prefs]Name = CA_NewHireLifeSci |
11 | Mathematics | The number of new hires who specialize in mathematics. | [Prefs]Value where [Prefs]Name = CA_NewHireMath |
12 | Music | The number of new hires who specialize in music. | [Prefs]Value where [Prefs]Name = CA_NewHireMusic |
13 | Physical Education/Health/Dance | The number of new hires who specialize in physical education/health/dance. | [Prefs]Value where [Prefs]Name = CA_NewHirePE |
14 | Physical Science | The number of new hires who specialize in physical science. | [Prefs]Value where [Prefs]Name = CA_NewHirePhySci |
15 | Reading | The number of new hires who specialize in reading. | [Prefs]Value where [Prefs]Name = CA_NewHireReading |
16 | Self-contained Classes | The number of new hires who specialize in self-contained classes. | [Prefs]Value where [Prefs]Name = CA_NewHireSelfCont |
17 | Special Education | The number of new hires who specialize in special education. | [Prefs]Value where [Prefs]Name = CA_NewHireSpecEd |
18 | Social Science/Studies | The number of new hires who specialize in social science/studies. | [Prefs]Value where [Prefs]Name = CA_NewHireSocialSci |
19 | Theater | The number of new hires who specialize in theater. | [Prefs]Value where [Prefs]Name = CA_NewHireTheater |
20 | Trades and Industrial Arts | The number of new hires who specialize in trades and industrial arts. | [Prefs]Value where [Prefs]Name = CA_NewHireTrade |
21 | Other Specialization | The number of new hires who have a specialization other than those listed. | [Prefs]Value where [Prefs]Name = CA_NewHireOther |
SIF Form Section F - Multilingual Instructional Programs | |||
1 | Do you offer multilingual/ biliteracy education programs? | Indicates whether or not the school offers a multilingual instructional program. | N/A |
2 | Type of Multilingual/ Biliteracy Education Programs (Choose all that apply) | Indicates the type(s) of multilingual/biliteracy program(s) offered.
| N/A |
SIF Form Section G - Language(s) of Instruction | |||
1 | Language(s) of Instruction | Indicates the language(s) in which multilingual instructional programs are offered. | N/A |