File Import Specifications for CDIF and SIF 2019 ...



CBEDS File Import SpecificationsFor County District Information Form (CDIF) and School Information Form (SIF) Data RecordsSchool Year 2019–20Collected through the California Basic Educational Data System (CBEDS) Online Reporting Application (ORA)Version 12.0.0June 3, 2019California Basic Educational Data System (CBEDS) California Department of Education (CDE)Document InformationThis document is in the public domain. Authorization to reproduce it in whole or in part is granted.PropertiesDescriptionTitleCBEDS File Import SpecificationVersionVersion 12.0.0Issue DateJune 3, 2019Revision HistoryVersionDateSummary of Change12.0.0June 3, 2019Initial release:Type A records have been modified as follows:Added additional rows and valid values for the Form Row Number data element to include Nonbinary informationType B records have been modified as follows:SIF Section F updated to include new education program NewcomerYear Round Calendar Type has been removed from SIF Section D. Educational CalendarMinor corrections to file layout tablesDescription of Import FileDistricts and Independently Reporting Charter schools are required to submit CDIF (district level) and/or SIF (school level) data to the web-based CBEDS Online Reporting Application (CBEDS-ORA) either through the web application’s CDIF and/or SIF forms or via import files. Properly formatted text files containing Type A and B records can be imported; their record layout are described in this document.Import File FormatImport files are tab delimited text files. Each row of data (one record) consists of a predefined number of fields, and each field is separated by a tab character. Each row must end with a carriage return and line feed. The import file should only contain data and no additional information.Please DO NOT add any of the following to the import file:Do not include headers (i.e. Male Classified Staff CDIF, Female Classified Staff CDIF).Do not include field headers and/or description (i.e. Row Indicator, County-District-School (CDS) Code, Year, etc.).Do not pad (left or right) data with leading zeros or blank spaces.Do not use quotation marks in the data files.Level of Import DataData records can either be district (D) and or school (S) level data.Importing Files into CBEDS-ORAImport files containing CDIF and/or SIF data should be uploaded into CBEDS-ORA using the Import option on the Advanced Features page. DO NOT use the import option from the District of Choice Menu page, as the file will fail to import. Multiple files can be imported but only one at a time.Importing data for a section that already has data populated will overwrite the data for that section. In other words, if you want to use the import option to update one cell, or row of data, for a section that you have already imported/entered data for, you will need to include all of the data for that section, not just data for the cell/row that you are updating.TYPE A RECORD Field DefinitionsFile structure for submitting electronic data for Section A. Full-Time Equivalent of Classified Staff of the CDIF and SIF CBEDS forms. Each Type A record has a total of 16 fields.When submitting Type A data for import, include only those rows that contain data. It is not necessary to submit records where all values in fields 8–15 are zero. For example, if you do not have any male paraprofessionals at a school, you do not need to submit a record containing zero values for each race/ethnicity data element (fields 8–15).FieldData Element DescriptionDataTypeDataSizeDescriptionValid Values1Row IndicatorC1Indicates a row of dataD2SourceC4CDIF – County/District Information FormSIF – School Information FormCDIF or SIF3YearC4Year of submission for October 2019 CBEDS19204Record TypeC1Type of recordA5CDS CodeC14This is your LEA’s 14 digit CDS Code.District level records should have 2-digit county code plus a 5-digit district code plus seven zeros. (i.e. 12345670000000; Used when SOURCE = CDIF and LEVEL = D). School level records should have a 2-digit county code plus a 5-digit district code plus a 7-digit school code. (i.e. 12345671234567; Used when SOURCE = SIF and LEVEL = S).Valid 7 digit CD code with 7 zeroes for a District-level record or valid 14 digit CDS code for a school-level record.i.e. 12345670000000or 123456712345676Form Section LetterC1Form section letter; related to the section of dataA7Form Section Row NumberC3CDIF (district level) and SIF (school level) Section A. Full-Time Equivalents of Classified StaffSingle-school districts are NOT to report FTEs on the CDIF. Instead, they are to report them on the SIF.Use the following row numbers to specify the type of classified staff and use the appropriate race/ethnicity fields to specify the count (fields 8–15).Row number and descriptionMale ParaprofessionalsMale Office/Clerical StaffMale Other Classified Staff Female Paraprofessionals Female Office/Clerical StaffFemale Other Classified StaffNonbinary ParaprofessionalsNonbinary Office/Clerical StaffNonbinary Other Classified Staff WHEN SOURCE = CDIF or SIFAND FORM SECTION = A THEN VALID VALUES are: 1–98American Indian or Alaska Native Not HispanicC8Number of American Indian or Alaska Native Not Hispanic full-time equivalent (FTE) classified staff. Report to two decimal places.Data Format: FTE counts can be reported to two decimal places or no decimal places (i.e. 10.00 or 10 are valid).WHEN SOURCE = CDIF or SIF ANDFORM SECTION = A ANDROW = 1, 2, 3, 4, 5, 6, 7, and 8THENVALID VALUES are:0–99999.999Asian Not Hispanic C8Number of Asian Not Hispanic full-time equivalent (FTE) classified staff. Report to two decimal places.See current table row 8 Valid Values field.10Pacific Islander Not HispanicC8Number of Pacific Islander Not Hispanic full-time equivalent (FTE) classified staff. Report to two decimal places.See current table row 8 Valid Values field.11Filipino Not HispanicC8Number of Filipino Not Hispanic full-time equivalent (FTE) classified staff. Report to two decimal places.See current table row 8 Valid Values field.12Hispanic or Latino of Any Race C8Number of Hispanic or Latino of Any Race full-time equivalent (FTE) classified staff. Report to two decimal places.See current table row 8 Valid Values field.13African American Not HispanicC8Number of African American Not Hispanic full-time equivalent (FTE) classified staff. Report to two decimal places.See current table row 8 Valid Values field.14White Not HispanicC8Number of White Not Hispanic full-time equivalent (FTE) classified staff. Report to two decimal places.See current table row 8 Valid Values field.15Two or More Races Not HispanicC8Number of Two or More Races Not Hispanic full-time equivalent (FTE) classified staff. Report to two decimal places.See current table row 8 Valid Values field.16LevelC1Level of data:Use D for district level data (CDIF) Use S for school level data (SIF) WHEN SOURCE = CDIFTHEN VALID VALUE is: DWHEN SOURCE = SIFTHEN VALID VALUE is: STYPE A RECORD Data File ExamplesThe following examples are provided to assist with the creation of the data file for Type A records. Note that field headers are used as a reference in the below sample to show the order of fields. DO NOT include field headers in the actual data file. The greater than symbol “>” in the examples represents a TAB character. Do not submit data with the “>” symbol as a field separator as the data will fail to load correctly. The TAB character must be used to separate fields.Data File Set UpField order for one row of data (this is only for reference, do not include in actual import file).Row Indicator > Source > Year > Record Type > CDS Code > Form Section > Form Row Number > American Indian or Alaska Native Not Hispanic > Asian Not Hispanic > Pacific Islander Not Hispanic > Filipino Not Hispanic > Hispanic or Latino of Any Race > African American Not Hispanic > White Not Hispanic > Two or More Races Not Hispanic > Level?CDIF Section A. Classified StaffReporting data for Female Paraprofessional, and Nonbinary Other Classified StaffD>CDIF>1920>A>99999990000000>A>4>3>0>3.5>0>0>0>1>0>D?D>CDIF>1920>A>99999990000000>A>9>1>0>3>0>0>1>0>1>D?SIF Section A. Classified StaffReporting data for Male Other Classified Staff, Female Office/Clerical Staff, and Nonbinary Other Classified StaffD>SIF>1920>A>99999991234567>A>3>3>4.25>0>0>0>10.50>0>1>S?D>SIF>1920>A>99999991234567>A>5>2>7>0>6.25>0>2>0>4.75>S?D>SIF>1920>A>99999991234567>A>8>6>9>0>7>0>2>0>4.75>S?Data File ExamplesBelow is an example of how the actual data rows will look within the data file, assuming the space between each field is a TAB character and each data row terminates with a carriage return and line feed.D CDIF 1920 A 99999990000000 A 1 13.75 0.75 10.00 0 0.50 0 2.25 10.50 DD SIF 1920 A 99999991234567 A 6 1 1 0 6.25 0 2 0 4.75 STYPE B RECORD Field Definitions File structure for submitting electronic data for Sections B, C and D of the CBEDS CDIF and/or Sections B through H of the CBEDS SIF. Each Type B record has a total of 9 fields. When submitting data for import, include only those rows that contain data. It is not necessary to submit records with zero values. For example, if you do not have data to report for one of the subjects in that section (e.g., you don’t plan to hire art teachers), you do not need to submit a record containing a zero value for the row that corresponds to art. TYPE B RECORD Standard FieldsFields 1–6 are standard fields found in all Type B records.FieldData Element DescriptionData TypeData SizeDescriptionValid Values1Row IndicatorC1Indicates a row of dataD2SourceC4CDIF – County/District Information FormSIF – School Information FormCDIF or SIF3YearC4Year of submission for October 2019 CBEDS19204Record TypeC1Type of recordB5CDS CodeC14This is your LEA’s 14 digit CDS Code.District level records should have 2-digit county code plus a 5-digit district code plus seven zeros. (i.e. 12345670000000; Used when SOURCE = CDIF and LEVEL = D). School level records should have a 2-digit county code plus a 5-digit district code plus a 7-digit school code. (i.e. 12345671234567; Used when SOURCE = SIF and LEVEL = S).Valid 7 digit CD code with 7 zeroes for a District-level record or valid 14 digit CDS code for a school-level record.i.e. 12345670000000or 123456712345676Form Section LetterC1The section letter related to the form. Provides information as to whether or not the section is required and if the section applies to a specific type of school. CDIF SectionsSection BSection CSIF SectionsSection B (Required)Section C (For charter schools only) Section D (Required)Section E (For independently reporting charter schools only)Section FSection GWHEN SOURCE = CDIF THEN VALID VALUES: B, or CWHEN SOURCE = SIF THEN VALID VALUES:B, C, D, E, F, or GTYPE B RECORD Field 7: Form Section Row NumberCDIF Form Section Row NumbersThe Form Section Row Number (field 7) is dependent on the Source (field 2) and the Form Section Letter (field 6). Each Form Section Letter has its own set of row numbers and only specific combinations of section letters and row numbers are allowed. The table below provides information on the valid form section and row number combinations for submitting district level (CDIF) Type B records.FieldData Element DescriptionData TypeData SizeDescriptionValid Values7Form Section Row NumberC3CDIF Section B. Estimated Number of Teacher Hires at the district-level (2020–21)Report the estimated number of teacher hires (specified in the VALUE field below) by subject (subject specified in this field ROW) for classroom teaching and specialist positions only. Report in full-time equivalents (FTEs) to one decimal place. (Do not include administrative, guidance, media, library, health service, or classified positions.)Row Number and DescriptionAgriculture ArtMultilingual Education Business Dance English Foreign LanguageHealth Home Economics Continues on next row.WHENSOURCE = CDIF AND FORM SECTION = B THENVALID VALUES are:1–217Form Section Row NumberC3This row is a continuation of previous row.CDIF Section B. Estimated Number of Teacher Hires at the district-level (2020–21)Report the estimated number of teacher hires (specified in the VALUE field below) by subject (subject specified in this field ROW) for classroom teaching and specialist positions only. Report in full-time equivalents (FTEs) to one decimal place. (Do not include administrative, guidance, media, library, health service, or classified positions.)Row Number and DescriptionLife ScienceMathematicsMusic Physical EducationPhysical ScienceReading Self-Contained Classes Special Education Social Science/Studies TheaterTrades and Industrial ArtsOther SpecializationsWHENSOURCE = CDIF AND FORM SECTION = B THENVALID VALUES are:1–217Form Section Row NumberC3CDIF Section C. Work Visa ApplicationsReport the number of H-1B work visas applied for on behalf of potential LEA and school employees, and the number of those applications that were granted.Do not to include visa application data from charter schools on the CDIF. Visa data for charter schools are to be reported on the charter school’s SIF. Row Number and DescriptionNumber of H-1B work visa applications submitted.Number of H-1B work visa applications granted.WHENSOURCE = CDIF ANDFORM SECTION = CTHENVALID VALUES are1 or 2SIF Form Section Row NumbersThe Form Section Row Number (field 7) is dependent on the Source (field 2) and the Form Section Letter (field 6). Each section has its own set of row numbers and only specific combinations of section letters and row numbers are allowed. The table below provides information on the valid form section and row number combinations for submitting school level (SIF) Type B records.FieldData Element DescriptionData TypeData SizeDescriptionValid Values7Form Section Row NumberC3SIF Section B. Kindergarten Program TypesFor Kindergarten Program Types, indicate the row number that represents the type of kindergarten program that is offered at the school.Row Number and DescriptionFull-dayPart-dayBoth full-day and part-dayNoneFor Transitional Kindergarten Program Types, indicate the row number that represents the type of transitional kindergarten program that is offered at the school.Row Number and DescriptionFull-dayPart-dayBoth full-day and part-dayNoneWHENSOURCE = SIF ANDFORM SECTION = B THEN VALID VALUES are:1, 2, 3, 4, 5, 6, 7, or 87Form Section Row NumberC3This section is for charter schools onlySIF 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 visa applications that were granted.Row Number and DescriptionNumber of H-1B work visa applications submitted.Number of H-1B work visa applications granted.WHENSOURCE = SIF ANDFORM SECTION = CTHENVALID VALUES are1 or 27Form Section Row NumberC3SIF Section D. Educational Calendar TypeIndicate the type of calendar on which your school operates.Row Number and DescriptionTraditionalSingle-TrackMultitrackStart and End DatesReport the school’s start date (first day of school) and end date (last day of school). Submit a separate record for start and end dates.Row Number and DescriptionStart DateEnd DateWHENSOURCE = SIF AND FORM SECTION = D THEN VALID VALUES are:1, 2, 3, 4 or 57Form Section Row NumberC3For Independently Reporting Charter schools only.SIF Section E. Estimated number of teacher hires (2020–21) (at the school-level for independently reporting charter schools only)Report the estimated number of teacher hires (specified in the VALUE field below) by subject (subject specified in this field ROW) for classroom teaching and specialist positions only. Report in full-time equivalents (FTEs) to one decimal place. Do not include administrative, guidance, media, library, health service, or classified positions.Row Number and DescriptionAgriculture ArtBilingual Education Business Dance English Foreign LanguageHealth EducationHome Economics Continues on next row.WHENSOURCE = SIF ANDFORM SECTION = E THENVALID VALUES are:1–217Form Section Row NumberC3This row is a continuation of previous row.For Independently Reporting Charter schools only.SIF Section E. Estimated number of teacher hires (2020–21) (at the school-level for independently reporting charter schools only)Report the estimated number of teacher hires (specified in the VALUE field below) by subject (subject specified in this field ROW) for classroom teaching and specialist positions only. Report in full-time equivalents (FTEs) to one decimal place. Do not include administrative, guidance, media, library, health service, or classified positions.Row Number and DescriptionLife Science MathematicsMusic Physical EducationPhysical ScienceReading Self-Contained Classes Special Education Social Science/Studies Drama/TheaterTrades and Industrial Arts Other SpecializationsWHENSOURCE = SIF ANDFORM SECTION = E THENVALID VALUES are:1–217Form Section Row NumberC3SIF F. Multilingual Instructional Programs Specify whether or not the school offers a multilingual/biliteracy instructional program.Row Number and DescriptionYesNoWHENSOURCE = SIF ANDFORM SECTION = F THENVALID VALUES = 1 or 27Form Section Row NumberC3SIF F. Multilingual Instructional Programs (continued)If the school offers a multilingual instructional program, report the type(s) of program(s) offered. Report all that apply.Row Number and DescriptionDual Immersion or Two-WayDevelopmental BilingualTransitional BilingualOne-Way ImmersionHeritage LanguageFLEX: Foreign Language Elementary ExperienceFLES: Foreign Language in Elementary SchoolsNative Speakers CoursesNewcomerWHENSOURCE = SIF ANDFORM SECTION = F THENVALID VALUES are: 3, 4, 5, 6, 7, 8, 9, 10 or 117Form Section Row NumberC3SIF G. Language(s) of InstructionsIf the school offers a multilingual instructional program, report the target language(s) in which multilingual instructional programs are offered. The Form Section Row Number for this section corresponds to the language code for the language being reported. A list of reportable languages and codes is available in the appendix. Report one language per record (data row).Please note that leading zero are required for numbers 1–9 (i.e. 01, 02, 03, 04, 05, 06, 07, 08, 09)WHENSOURCE = SIF ANDFORM SECTION = G THENVALID VALUES are: 01, 02, 03, 04, 05, 06, 07, 08, 09, 10–13, 15–30, 32–54, 56, 57, 60–72, and 99TYPE B RECORD Field 8: Form Section Row ValueCDIF Form Section Row ValuesValid values for the Form Section Row Value (field 8) are dependent on the Source (field 2), Form Section Letter (field 6), and Form Section Row number (field 7). The table below provides information on the valid values for submitting district level (CDIF) Type B records based on valid section and row number combinations.FieldData Element DescriptionData TypeData SizeDescriptionValid Values8Form Section Row ValueC5CDIF Section B. Estimated Number of Teacher Hires (2020–21)Report the estimated number of teacher hires (specified in this field, Form Section Row Value) by subject (specified in the Form Section Row Number field) for classroom teaching and specialist positions only. Report in full-time equivalents (FTEs) to one decimal place. (Do not include administrative, guidance, media, library, health service, or classified positions.)Data Format: Values can be reported to one decimal place or no decimal places (i.e. 12.5, 5, or 5.0 are valid).WHENSOURCE = CDIF ANDFORM SECTION = B ANDROW NUMBER = 1–21THENVALID VALUES are:0–999.98Form Section Row ValueC5CDIF Section C. Work Visa ApplicationsReport the number of H-1B work visas applied for on behalf of potential LEA and school employees, and the number of those applications that were granted. Do not to include visa application data from charter schools on the CDIF. Visa data for charter schools are to be reported on the charter school’s SIF. Data Format: Numeric, 5 digits. For example if 10 H-1B work visa applications were submitted, submit 10 as the value.WHENSOURCE = CDIF ANDFORM SECTION = CANDRow Number = 1 or 2THENVALID VALUES are0–99999SIF Form Section ValuesValid values for the Form Section Row Value (field 8) are dependent on the Source (field 2), Form Section Letter (field 6), and Form Section Row number (field 7). The table below provides information on the valid values for submitting school level (SIF) Type B records based on section and row number combinations.FieldData Element DescriptionData TypeData SizeDescriptionValid Values8Form Section Row ValueC4SIF Section B. Kindergarten Program TypesSubmit a “True” value for the type of kindergarten and transitional kindergarten program offered at the school based on the type of program specified in the Form Section Row Number field.Data Format: TRUE. If your LEA has no kindergarten program then you would report row number 4 with a Form Section Row Value of TRUE.WHENSOURCE = SIF ANDFORM SECTION = B ANDROW NUMBER = 1, 2, 3, 4, 5, 6, 7, or 8THENVALID VALUE isTRUE8Form Section Row ValueC5This section is for charter schools onlySIF 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 visa applications that were granted.Data Format: Numeric, 5 digits. For example if 7 visa applications were granted, then report for row number 2 with 7 as the row value.WHENSOURCE = SIF ANDFORM SECTION = CANDRow Number = 1 or 2THENVALID VALUES are0–999998Form Section Row ValueC4SIF Section D. Educational Calendar Calendar Type (Section Row Numbers 1–3)When reporting a calendar type, do not report both single-track and multitrack. If ANY part of the school is year-round, select more than one type of calendar: Traditional and single-track, or traditional and multitrack.Submit a TRUE value for the type of educational calendar that the school operates on based on the type of calendar specified in the Form Section Row Number field.WHENSOURCE = SIF ANDFORM SECTION = D ANDROW NUMBER = 1, 2, or 3THENVALID VALUE is: TRUE8Form Section Row ValueC8SIF Section D: Educational Calendar (continued)School Start and End Dates (Section Row Numbers 4 and 5)Report the school’s start date (first day of school) and end date (last day of school). If on a multi-track calendar, report the first day of the earliest track and last day of the latest track. Data FormatEight digits max length; Value = Date in the format of CCYYMMDD (Century, Year, Month with leading zero, Day with leading zero). For example, if the first day of school is September 3, 2019, report the date as 20190903.WHENSOURCE = SIF and FORM SECTION = D andROW NUMBER = 4 or 5THENVALID VALUES are:Valid date in the format of CCYYMMDD (CC = Century, YY = Year, MM = month, and DD = day; i.e. 20190903)8Form Section Row ValueC5This section is for Independently Reporting Charter schools only.SIF Section E. Estimated Number of Teacher Hires (2019–2020)Report the value of the estimated number of teacher hires (specified in this field, Form Section Row Value) by subject (specified in the Form Section Row Number field) for classroom teaching and specialist positions only. Report in full-time equivalents (FTEs) to one decimal place. (Do not include administrative, guidance, media, library, health service, or classified positions.)Data Format: Values can be reported to one decimal place or no decimal places (i.e. 17.75, 7 or 7.0 are valid).WHENSOURCE = SIF ANDFORM SECTION = EANDROW NUMBER = 1–21THENVALID VALUES are:0–999.98Form Section Row ValueC4SIF Section F. Multilingual Instructional Programs Specify whether or not the school offers a multilingual/biliteracy instructional program by reporting a TRUE value for either row 1 (Yes) or row 2 (No). Do not report TRUE values for both Rows 1 and 2. WHENSOURCE = SIFAND FORM SECTION = FANDROW NUMBER = 1 or 2THENVALID VALUES is: TRUE8Form Section Row ValueC4SIF Section F. Multilingual Instructional Programs (continued)If the school offers a multilingual instructional program, report the type(s) of program(s) offered. Submit a TRUE value for each program offered in rows 3-11 based on the Form Section Row Number field. Report a data row for each type of program offered.WHENSOURCE = SIFAND FORM SECTION = FANDROW NUMBER = 3–11THENVALID VALUES is: TRUE8Form Section Row ValueC4SIF Section G. Language(s) of Instruction If the school offers a multilingual instructional program, report the target language(s) in which multilingual instructional programs are offered. Submit a TRUE value for each language offered based on the Form Section Row Number field. Report a data row for each language offered.WHENSOURCE = SIFAND FORM SECTION = GANDROW NUMBER = 01, 02, 03, 04, 05, 06, 07, 08, 09, 10–13, 15–30, 32–54, 56, 57, 60–72, and 99THENVALID VALUES is: TRUETYPE B RECORD Field 9: Level of Data FieldThis is the last field of the Type B record (field 9). It specifies the level of data. A carriage return with line feed should follow this field.FieldData Element DescriptionData TypeData SizeDescriptionValid Values9LevelC1Level of DataIf you are reporting district data then use “D”. If you’re reporting school data then use “S”.D for district (CDIF)S for school (SIF)D or STYPE B RECORD Data File ExamplesThe following examples are provided to assist with the creation of the data file for Type B records. Note that field headers are used as a reference in the below example to show the order of fields. DO NOT include field headers in the actual data file. The greater than symbol “>” in the examples represents a TAB character. Do not submit data with the “>” symbol as a field separator as the data will fail to load correctly. The TAB character must be used to separate fields.Data File Set UpField Order for One Row of Data (this is only for reference, do not include in actual import file).Row Indicator>Source>Year>Record Type>CDS Code>Form Section Letter>Form Section Row Number>Form Section Row Value>Level?CDIF Section B. Estimated Number of Teacher HiresReporting Multilingual Education with a FTE of 4.0 and Dance with a FTE of 2.5.D>CDIF>1920>B>12345670000000>B>3>4.0>D?D>CDIF>1920>B>12345670000000>B>5>2.5>D? CDIF Section C. Work Visa ApplicationsReporting 5 H-1B work visa applications submitted and 3 granted.D>CDIF>1920>B>12345670000000>C>1>5>D?D>CDIF>1920>B>12345670000000>C>2>3>D? SIF Section B. Kindergarten Program TypeReporting full-day kindergarten and both full-day and part-day transitional kindergarten.D>SIF>1920>B>12345670000004>B>1>TRUE>S?D>SIF>1920>B>12345670000004>B>7>TRUE>S?SIF Section C. Work Visa ApplicationsReporting 15 H-1B work visa applications submitted and 10 H-1B work visa applications granted.D>SIF>1920>B>12345670000004>C>1>15>S?D>SIF>1920>B>12345670000004>C>2>10>S?SIF Section D. Educational CalendarReporting traditional calendar with school start date of September 3, 2019, and school end date of May 15, 2020.D>SIF>1920>B>12345670000004>D>1>TRUE>S? D>SIF>1920>B>12345670000004>D>4>20190903>S?D>SIF>1920>B>12345670000004>D>5>20200515>S? SIF Section E. Estimated Number of Teacher HiresReporting Art with a FTE of 2.0.D>SIF>1920>B>12345670000005>E>2>2.0>S?SIF Section F. Multilingual Instructional ProgramsReporting YES, the school offers multilingual/biliteracy education programs and the school offers a Transitional Bilingual program and a FLEX: Foreign Language Elementary Experience program.D>SIF>1920>B>12345670000004>F>1>TRUE>S?D>SIF>1920>B>12345670000004>F>4>TRUE>S?D>SIF>1920>B>12345670000004>F>7>TRUE>S?SIF Section G. Language(s) of InstructionReporting French, Turkish, and Vietnamese languages are offered by the school.D>SIF>1920>B>12345670000004>G>01>TRUE>S?D>SIF>1920>B>12345670000004>G>05>TRUE>S? D>SIF>1920>B>12345670000004>G>33>TRUE>S?Data File ExampleBelow is an example of how the actual data rows will look within the data file, assuming the space between each field is a TAB character and each data row terminates with a carriage return and line feed.CDIF Data RowsD CDIF 1920 B 12345670000000 B 3 4.0 DD CDIF 1920 B 12345670000000 B 5 2.5 DD CDIF 1920 B 12345670000000 C 1 5 DD CDIF 1920 B 12345670000000 C 2 2 DSIF Data RowsD SIF 1920 B 12345670000004 B 1 TRUE SD SIF 1920 B 12345670000004 B 7 TRUE SD SIF 1920 B 12345670000004 C 1 15 SD SIF 1920 B 12345670000004 C 2 10 SD SIF 1920 B 12345670000004 D 1 TRUE SD SIF 1920 B 12345670000004 D 4 20190903 SD SIF 1920 B 12345670000004 D 5 20200515 SD SIF 1920 B 12345670000005 E 2 2.0 SD SIF 1920 B 12345670000004 F 1 TRUE SD SIF 1920 B 12345670000004 F 4 TRUE SD SIF 1920 B 12345670000004 F 7 TRUE SD SIF 1920 B 12345670000004 G 01 TRUE SD SIF 1920 B 12345670000004 G 05 TRUE SD SIF 1920 B 12345670000004 G 33 TRUE SAPPENDIXValid Combinations of Source, Record Type, Form Section, and Form Section Row Number (Row)CDIF Type A Record Valid CombinationsSourceRecordTypeForm SectionRowLevelDescriptionSection DescriptionCDIFAA1DMale ParaprofessionalsFull-Time Equivalent of Classified StaffCDIFAA2DMale Office/Clerical StaffFull-Time Equivalent of Classified StaffCDIFAA3DMale Other StaffFull-Time Equivalent of Classified StaffCDIFAA4DFemale ParaprofessionalsFull-Time Equivalent of Classified StaffCDIFAA5DFemale Office/Clerical StaffFull-Time Equivalent of Classified StaffCDIFAA6DFemale Other StaffFull-Time Equivalent of Classified StaffCDIFAA7DNonbinary ParaprofessionalsFull-Time Equivalent of Classified StaffCDIFAA8DNonbinary Office/Clerical StaffFull-Time Equivalent of Classified StaffCDIFAA9DNonbinary Other StaffFull-Time Equivalent of Classified StaffCDIF Type B Record Valid CombinationsSourceRecordTypeForm SectionRowLevelDescriptionSection DescriptionCDIFBB1DAgricultureEstimated Number of Teacher HiresCDIFBB2DArtEstimated Number of Teacher HiresCDIFBB3DMultilingual EducationEstimated Number of Teacher HiresCDIFBB4DBusinessEstimated Number of Teacher HiresCDIFBB5DDanceEstimated Number of Teacher HiresCDIFBB6DEnglish and/or DramaEstimated Number of Teacher HiresCDIFBB7DForeign LanguageEstimated Number of Teacher HiresCDIFBB8DHealth EducationEstimated Number of Teacher HiresCDIFBB9DHome EconomicsEstimated Number of Teacher HiresCDIFBB10DLife ScienceEstimated Number of Teacher HiresCDIFBB11DMathematicsEstimated Number of Teacher HiresCDIFBB12DMusicEstimated Number of Teacher HiresCDIFBB13DPhysical Education/Health/DanceEstimated Number of Teacher HiresCDIFBB14DPhysical ScienceEstimated Number of Teacher HiresCDIFBB15DReadingEstimated Number of Teacher HiresCDIFBB16DSelf-contained ClassesEstimated Number of Teacher HiresCDIFBB17DSpecial EducationEstimated Number of Teacher HiresCDIFBB18DSocial Science/StudiesEstimated Number of Teacher HiresCDIFBB19DDrama/TheaterEstimated Number of Teacher HiresCDIFBB20DTrades and Industrial ArtsEstimated Number of Teacher HiresCDIFBB21DOther SpecializationsEstimated Number of Teacher HiresCDIFBC1DNumber of H-1B work visa applications submitted.Work Visa ApplicationsCDIFBC2DNumber of H-1B work visa applications granted.Work Visa ApplicationsSIF Type A Record Valid CombinationsSourceRecordTypeForm SectionRowLevelDescriptionSection DescriptionSIFAA1SMale ParaprofessionalsFull-Time Equivalent of Classified StaffSIFAA2SMale Office/Clerical StaffFull-Time Equivalent of Classified StaffSIFAA3SMale Other StaffFull-Time Equivalent of Classified StaffSIFAA4SFemale ParaprofessionalsFull-Time Equivalent of Classified StaffSIFAA5SFemale Office/Clerical StaffFull-Time Equivalent of Classified StaffSIFAA6SFemale Other StaffFull-Time Equivalent of Classified StaffSIFAA7SNonbinary ParaprofessionalsFull-Time Equivalent of Classified StaffSIFAA8SNonbinary Office/Clerical StaffFull-Time Equivalent of Classified StaffSIFAA9SNonbinary Other StaffFull-Time Equivalent of Classified StaffSIF Type B Record Valid CombinationsSourceRecordTypeForm SectionRowLevelDescriptionSection DescriptionSIFBB1SKindergarten Full-dayKindergarten Program TypeSIFBB2SKindergarten Part-dayKindergarten Program TypeSIFBB3SKindergarten Full and Part DayKindergarten Program TypeSIFBB4SKindergarten NoneKindergarten Program TypeSIFBB5STransitional Kindergarten Full-dayKindergarten Program TypeSIFBB6STransitional Kindergarten Part-dayKindergarten Program TypeSIFBB7STransitional Kindergarten Full and Part DayKindergarten Program TypeSIFBB8STransitional Kindergarten NoneKindergarten Program TypeSIFBC1SNumber of H-1B work visa applications received.Work Visa Applications (For charter schools only)SIFBC2SNumber of H-1B work visa applications granted.Work Visa Applications (For charter schools only)SIFBD1STraditionalEducational CalendarSIFBD2SSingle-TrackEducational CalendarSIFBD3SMultitrackEducational CalendarSIFBD4SStart DateEducational CalendarSIFBD5SEnd DateEducational CalendarSIFBE1SAgricultureEstimated Number of Teacher Hires (for independently reporting charter schools)SIFBE2SArtEstimated Number of Teacher Hires (for independently reporting charter schools)SIFBE3SMultilingual EducationEstimated Number of Teacher Hires (for independently reporting charter schools)SIFBE4SBusinessEstimated Number of Teacher Hires (for independently reporting charter schools)SIFBE5SDanceEstimated Number of Teacher Hires (for independently reporting charter schools)SIFBE6SEnglish and/or DramaEstimated Number of Teacher Hires (for independently reporting charter schools)SIFBE7SForeign LanguageEstimated Number of Teacher Hires (for independently reporting charter schools)SIFBE8SHealth EducationEstimated Number of Teacher Hires (for independently reporting charter schools)SIFBE9SHome EconomicsEstimated Number of Teacher Hires (for independently reporting charter schools)SIFBE10SLife ScienceEstimated Number of Teacher Hires (for independently reporting charter schools)SIFBE11SMathematicsEstimated Number of Teacher Hires (for independently reporting charter schools)SIFBE12SMusicEstimated Number of Teacher Hires (for independently reporting charter schools)SIFBE13SPhysical Education/Health/DanceEstimated Number of Teacher Hires (for independently reporting charter schools)SIFBE14SPhysical ScienceEstimated Number of Teacher Hires (for independently reporting charter schools)SIFBE15SReadingEstimated Number of Teacher Hires (for independently reporting charter schools)SIFBE16SSelf-contained ClassesEstimated Number of Teacher Hires (for independently reporting charter schools)SIFBE17SSpecial EducationEstimated Number of Teacher Hires (for independently reporting charter schools)SIFBE18SSocial Science/StudiesEstimated Number of Teacher Hires (for independently reporting charter schools)SIFBE19SDrama/TheaterEstimated Number of Teacher Hires (for independently reporting charter schools)SIFBE20STrades and Industrial ArtsEstimated Number of Teacher Hires (for independently reporting charter schools)SIFBE21SOther SpecializationsEstimated Number of Teacher Hires (for independently reporting charter schools)SIFBF1SDo you offer multilingual/biliteracy education program? (YES)Multilingual Instructional ProgramsSIFBF2SDo you offer multilingual/biliteracy education program? (NO)Multilingual Instructional ProgramsSIFBF3SDual-Language ImmersionMultilingual Instructional ProgramsSIFBF4SDevelopment BilingualMultilingual Instructional ProgramsSIFBF5STransitional BilingualMultilingual Instructional ProgramsSIFBF6SOne-Way ImmersionMultilingual Instructional ProgramsSIFBF7SHeritage Language/Indigenous LanguageMultilingual Instructional ProgramsSIFBF8SForeign Language Elementary Experience (FLEX)Multilingual Instructional ProgramsSIFBF9SForeign Language in Elementary Schools (FLES)Multilingual Instructional ProgramsSIFBF10SNative Speakers CoursesMultilingual Instructional ProgramsSIFBF11SNewcomerMultilingual Instructional ProgramsSIFBG01SSpanishLanguage(s) of InstructionSIFBG02SVietnameseLanguage(s) of InstructionSIFBG03SCantoneseLanguage(s) of InstructionSIFBG04SKoreanLanguage(s) of InstructionSIFBG05SFilipino (Pilipino or Tagalog)Language(s) of InstructionSIFBG06SPortugueseLanguage(s) of InstructionSIFBG07SMandarin (Putonghua)Language(s) of InstructionSIFBG08SJapaneseLanguage(s) of InstructionSIFBG09SKhmer (Cambodian)Language(s) of InstructionSIFBG10SLaoLanguage(s) of InstructionSIFBG11SArabicLanguage(s) of InstructionSIFBG12SArmenianLanguage(s) of InstructionSIFBG13SBurmeseLanguage(s) of InstructionSIFBG15SDutchLanguage(s) of InstructionSIFBG16SFarsi (Persian)Language(s) of InstructionSIFBG17SFrenchLanguage(s) of InstructionSIFBG18SGermanLanguage(s) of InstructionSIFBG19SGreekLanguage(s) of InstructionSIFBG20SChamorro (Guamanian)Language(s) of InstructionSIFBG21SHebrewLanguage(s) of InstructionSIFBG22SHindiLanguage(s) of InstructionSIFBG23SHmongLanguage(s) of InstructionSIFBG24SHungarianLanguage(s) of InstructionSIFBG25SIlocanoLanguage(s) of InstructionSIFBG26SIndonesianLanguage(s) of InstructionSIFBG27SItalianLanguage(s) of InstructionSIFBG28SPunjabiLanguage(s) of InstructionSIFBG29SRussianLanguage(s) of InstructionSIFBG30SSamoanLanguage(s) of InstructionSIFBG32SThaiLanguage(s) of InstructionSIFBG33STurkishLanguage(s) of InstructionSIFBG34STonganLanguage(s) of InstructionSIFBG35SUrduLanguage(s) of InstructionSIFBG36SCebuano (Visayan)Language(s) of InstructionSIFBG37SSign LanguageLanguage(s) of InstructionSIFBG38SUkrainianLanguage(s) of InstructionSIFBG39SChaozhou (Chiuchow)Language(s) of InstructionSIFBG40SPashtoLanguage(s) of InstructionSIFBG41SPolishLanguage(s) of InstructionSIFBG42SAssyrianLanguage(s) of InstructionSIFBG43SGujaratiLanguage(s) of InstructionSIFBG44SMien (Yao)Language(s) of InstructionSIFBG45SRumanianLanguage(s) of InstructionSIFBG46STaiwaneseLanguage(s) of InstructionSIFBG47SLahuLanguage(s) of InstructionSIFBG48SMarshalleseLanguage(s) of InstructionSIFBG49SMixtecoLanguage(s) of InstructionSIFBG50SKhmuLanguage(s) of InstructionSIFBG51SKurdish (Kurdi, Kurmanji)Language(s) of InstructionSIFBG52SSerbo-Croatian (Bosnian, Croatian, Serbian)Language(s) of InstructionSIFBG53SToishaneseLanguage(s) of InstructionSIFBG54SChaldeanLanguage(s) of InstructionSIFBG56SAlbanianLanguage(s) of InstructionSIFBG57STigrinyaLanguage(s) of InstructionSIFBG60SSomaliLanguage(s) of InstructionSIFBG61SBengaliLanguage(s) of InstructionSIFBG62STeluguLanguage(s) of InstructionSIFBG63STamilLanguage(s) of InstructionSIFBG64SMarathiLanguage(s) of InstructionSIFBG65SKannadaLanguage(s) of InstructionSIFBG66SAmharicLanguage(s) of InstructionSIFBG67SBulgarian Language(s) of InstructionSIFBG68SKikuyu (Gikuyu)Language(s) of InstructionSIFBG69SKashmiriLanguage(s) of InstructionSIFBG70SSwedish Language(s) of InstructionSIFBG71SZapoteco Language(s) of InstructionSIFBG72SUzbekLanguage(s) of InstructionSIFBG99SOther non-English languagesLanguage(s) of InstructionLanguages of InstructionA list of reportable languages for schools offering a multilingual instructional program in a language other than English. The code listed for the corresponding language shall be used as the Form Section Row Number for reporting SIF Section G data in Type B records.CodeLanguage56Albanian66Amharic11Arabic12Armenian42Assyrian61Bengali67Bulgarian 13Burmese03Cantonese36Cebuano (Visayan)54Chaldean20Chamorro (Guamanian)39Chaozhou (Chiuchow)15Dutch16Farsi (Persian)05Filipino (Pilipino or Tagalog)17French18German19Greek43Gujarati21Hebrew22Hindi23HmongCodeLanguage24Hungarian25Ilocano26Indonesian27Italian08Japanese65Kannada69Kashmiri09Khmer (Cambodian)50Khmu68Kikuyu (Gikuyu)04Korean51Kurdish (Kurdi, Kurmanji)47Lahu10Lao07Mandarin (Putonghua)64Marathi48Marshallese44Mien (Yao)49Mixteco40Pashto41Polish06Portuguese28PunjabiCodeLanguage45Rumanian29Russian30Samoan52Serbo-Croatian (Bosnian, Croatian, Serbian)37Sign Language60Somali01Spanish70Swedish 46Taiwanese63Tamil62Telugu32Thai57Tigrinya53Toishanese34Tongan33Turkish38Ukrainian35Urdu72Uzbek02Vietnamese71Zapoteco 99Other non-English languages ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download