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: Default – District Wide. Includes all records on the PowerSchool server that meet selection criteria. Current School Only – Includes all records associated with the current school that meet the selection criteria. District Wide – Includes all records on the PowerSchool server that meet the selection criteria. 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: In Background Now (Recommended) – Execute the report immediately in the background. ASAP – Execute the report in the order it is received in the Report Queue. At Night – Execute the report during the next evening. On Weekend – Execute the report during the next weekend. On Specific Time – Execute the report on the date and time specified.
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 All Schools or Multiple Schools in the Sub-District.
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. CDIF Section B - The estimated number of teacher new hires by subject area for the upcoming school year. CDIF Section C - High school graduation requirements by subject area. 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	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 Hires 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. 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 Applications 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 B - Kindergarten Program Type Report 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: Full-day Part-day Both full-day and part-day None	N/A
2	Transitional Kindergarten Program (select one)	Select one of the following transitional kindergarten programs: Full-day Part-day Both full-day and part-day None	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 Calendar The 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 Hires 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. 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. Dual-Language Immersion Developmental Bilingual Transitional Bilingual One-Way Immersion Heritage Language / Indigenous Language Foreign Language Elementary Experience (FLEX) Foreign Language in Elementary Schools (FLES)	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

Introduction

Selection Criteria

Report Input

Report Output

CDIF Form Section B - Teacher Hires

CDIF Form Section C - Work Visa Applications

SIF Form Section B - Kindergarten Program Type

SIF Form Section C - Work Visa Applications (For Charter Schools only)

SIF Form Section D - Educational Calendar

SIF Form Section E - Teacher Hires

SIF Form Section F - Multilingual Instructional Programs

SIF Form Section G - Language(s) of Instruction