J-90 File Layouts - 2012-13 readdb1213.txt 12-30-2013 December 30, 2013 IMPORTANT: This file contains the file format layouts you will need to interpret the J-90 Teacher Salary Databases. REPORT OF 2012-13 TEACHER SALARY AND BENEFIT DATA (Form J-90) Background: ----------------------------------- In a continuing effort to share the results of our data collections with the school districts and county offices of education that make them possible, we are making available the entire database of J-90 data. The database is based on information submitted by school districts and county offices on the annual "Salary and Benefits Schedule for the Certificated Bargaining Unit," Form J-90. This information has proven very useful in making district-to- district comparisons during teacher salary negotiations. We also use the information from the Form J-90 to furnish school districts with statewide average salaries required for the School Accountability Report Card (Education Code Section 41409.3). Caveat: ----------------------------------- Keep in mind that the database, although thoroughly checked, may contain errors that will be identified as the information is used. Files: ----------------------------------- The following six files comprise the J-90 database: fixdinfo: Contains information from sections I, III, IV, V, and VI of the J-90. colmhdgs: Contains the text headings entered for each of the columns in the salary schedule, Section II. salxstep: Contains the salary and FTEs for each column and salary in Section II. beneinfo: Contains the benefit information in Section VII. retbeninfo1: Contains the benefit information in Section VIII for retirees over 65. retbeninfo2: Contains the benefit information in Section VIII for retirees 65 and under. In addition to these six files, the j901213.exe also contains the summarized report SELECTED CERTIFICATED SALARIES AND RELATED STATISTICS and the readdb1213.txt readme file. The file j901213.exe is a self-extracting zipped file that contains these files. After downloading the file, copy it to an empty directory and extract by double-clicking on the file. The extracted files are quote and comma delimited format (.txt extension) and will be extracted to the C:\J90_1213\ directory (by default). FILE LAYOUT: fixdinfo (832 records) Field Name Description Field Type County Two digit county code Text District Five digit district code Text CDS Seven digit combined code - Note Text this is the code used as a key for all records in system TS1_DNAME District Name (Long name) Text TS1_COUNTY County Name Text TS1_TYPE Entered code 1=Elementary, 2=High School, Number 3=Common Administration. 4=Unified TS1_ADA The current P-2 ADA Number TS1_BACOL The column number for BA+60 determination Number TS1_PCTCHG Percentage change in salary schedule Number over last year. TS1_NDAYS Number of student instructional days Number TS1_RDAYS Number of service days required of Number returning teachers. TS1_HSTEP Highest entry level step for experienced Number teacher. TS1_HCOL Column indicator for entry level Number experienced teacher. TS1_MINSAL The minimum salary offered to Number teaching staff. TS1_MAXSAL The maximum salary offered to teaching Number staff. TS1_TOTFTE The number of full time teachers on Number salary schedule. TS1_COUNS Indicates whether counselors are paid Text from salary schedule. TS1_NURSE Indicates whether nurses are paid from Text salary schedule. TS1_PSYCH Indicates whether Psychologists are paid Text from salary schedule. TS1_LIBRA Indicates whether Librarians are paid from Text salary schedule. TS1_MBONAM Indicates bonus amount paid over salary Number schedule for Masters degree. TS1_MBONFT Indicates number of FTE's eligible for Number bonus. TS1_DBONAM Indicates bonus amount paid over salary Number schedule for Doctorate degree. TS1_DBONFT Indicates number of FTE's eligible for Number bonus. TS1_SEBONA Indicates bonus amount paid over salary Number schedule for Special Education assignment. TS1_SEBONF Number of FTE's eligible for this bonus. Number TS1_BBONAM Indicates bonus amount paid over salary Number schedule for Bilingual assignments. TS1_BBONFT Number of FTE's eligible for this bonus. Number TS1_O1BONA Indicates bonus amount paid over salary Number TS1_O2BONA schedule for other Credential TS1_o3BONA Instructional Assignments (up to 4). TS1_O4BONA TS1_O1BONF Number of FTE's for each type of Number TS1_O2BONF additional bonus. TS1_O3BONF TS1_O4BONF TS1_O1DESC Description of each additional bonus. Text TS1_O2DESC TS1_O3DESC TS1_O4dDESC TS1_PRINE The average annual principal salary Number for an elementary school. TS1_PRINM The average annual principal salary Number a for middle school. TS1_PRINH The average annual principal salary Number for a high school. TS1_SUPT The annual salary of the district Number superintendent. TS1_DPRINE Number of obligated service days for Number elementary school principles. TS1_DPRINM Number of obligated service days for Number middle school principles. TS1_DPRINH Number of obligated service days for Number high school principles. TS1_DISSUP Number of obligated service days for Number district superintendents. TS1_PRNSUP The annual salary for a shared position. Number TS1_PCTSUP For a shared job, the weighted percentage Number valuation for each function. TS1_EFFDAT The effective date of the contract. Text TS1_NOTE Any notes about the J-90 goes here. Text TS1_MAXCAF The maximum annual employer contributions Number to cafeteria plan. TS1_MAXSIN The maximum annual employer contributions Number to single plan per employee. TS1_MAXTWO The maximum annual employer contributions Number to a two party plan per employee. TS1_MAXFAM The maximum annual employer contributions Number to a family plan per employee. TS1_CAPTYPE Whether the cap is Hard or Soft. Text LASTCOL Indicates the last column on salary Number schedule. Note2_1 Minimum salary exception explanation. Text Note2_2 Note3_1 Maximum salary exception explanation. Text Note3_2 Note4_1 Benefits FTE exception explanation. Text Note4_2 BEN-TYPE Indicates whether it is composite, Number or tier plan. OTHER-PLAN Are other benefit plans a replacement Number or addition to the other health plans. BEN-LIFE Does district cover retirees for life. Text BEN-STOP If not for life, when do benefits stop? Number MAXBONPCT Maximum bonus percentage. Number H_PLAN Number of Health plans. Number D_PLAN Number of dental plans. Number V_PLAN Number of vision plans. Number L_PLAN Number of life plans. Number O_PLAN Number of other plans. Number AXBONUSA Across the board bonus amount. Number AXBONUSP Across the board bonus percentage. Number RETROACT Can salary schedule retro act? Text INCLUDED Are the benefit dollars included in Text the salary schedule? TS1_CBONAM CLAD bonus amount. Number TS1_CBONFT CLAD bonus FTEs. Number TS1_BCBONA BCLAD bonus amount. Number TS1_BCBONF BCLAD bonus FTEs. Number TS1_NBONAM National Teacher Certification bonus Number amount. TS1_NBONFT National Teacher Certification bonus Number FTEs. ESTEP Highest entry step for an emergency or Number intern credential teacher. ECOL Highest entry column for an emergency Number or intern credential teacher. SSAMT Summer school pay rate per session. Number NOTE5_1 Summer school pay rate explanation. Text NOTE5_2 COLHEAD Beginning salary column heading Text description. EFTE Number of FTEs with emergency or Number intern credential. SSHR Summer school pay rate per hour. Number SSDAY Summer school pay rate per day. Number CHARTER Salary schedule include charter school Text teachers? CHTFTE Number of Charter School FTEs. Number R_OTHER Retiree over 65 other plan Number (addition or not) UR_OTHER Retiree under 65 other plan Number (addition or not) RETIRE Has benefits for retiree over 65? Number URETIRE Has benefits for retiree under 65? Number BONUSAPP Do the enhancements/bonuses increase as Text the salary schedule increases? LIABILITY Unfunded liability amount. Number STUDYDATE The date for the actuarial study. Text BA30COL Which column is BA+30? Number NOTE6_1 Retiree notes. Text NOTE6_2 ----------------------------------------------------------------- FILE LAYOUT: salxstep (85,498 records) Field Name Description Field Type COUNTY Two digit county code Text DISTRICT Five digit district code Text CDS Seven digit combined code - Note Text this is the code used as a key for all records in system. TS3_COL Column in the salary schedule. Number TS3_STEP Step in the salary schedule. Number TS3_SALARY Salary amount for each step. Number TS3_FTE Number FTEs on each step. Number TS3_TOTSAL Total salary for each step based Number on number of FTEs. FILE LAYOUT: colmhdgs (4,727 records) Field Name Description Field Type COUNTY Two digit county code Text DISTRICT Five digit district code Text CDS Seven digit combined code - Note Text this is the code used as a key for all records in system. TS2_COL Column in the salary schedule. Number TS2_COL1 Column heading for salary schedule. Text TS2_COL1A Column heading for salary schedule cont). Text TS2_COL2 Column heading for salary schedule (cont.) Text TS2_COL3 Column heading for salary schedule (cont.) Text TS2_COL3A Column heading for salary schedule (cont.) Text ---------------------------------------------------------------- FILE LAYOUT: beneinfo (10,522 records) Field Name Description Field Type COUNTY Two digit county code Text DISTRICT Five digit district code Text CDS Seven digit combined code - Note Text this is the code used as a key for all records in system. TS4_BEN Type of benefit. Text TS4_DESC Description of benefit. Text TS4_STEP Number of plans entered. Number TS4_COLUMN 1 is for single plan, Number 2 is for two-party, 3 is family, 4 is composite. TS4_ANNUAL Annual cost of the plan Number TS4_CONTR Employer contribution Number TS4_FTE No. of FTEs in the plan Number ----------------------------------------------------------------- FILE LAYOUT: retbeninfo1 (1,426 records) Field Name Description Field Type COUNTY Two digit county code Text DISTRICT Five digit district code Text CDS Seven digit combined code - Note Text this is the code used as a key for all records in system. TS5_BEN Type of benefit. Text TS5_DESC Description of benefit. Text TS5_STEP Number of plans entered. Number TS5_COLUMN 1 is for single plan, Number 2 is for two-party, 3 is family, 4 is composite. TS5_ANNUAL Annual cost of the plan Number TS5_CONTR Employer contribution Number TS5_FTE No. of FTEs in the plan Number ----------------------------------------------------------------- FILE LAYOUT: retbeninfo2 (6,241 records) Field Name Description Field Type COUNTY Two digit county code Text DISTRICT Five digit district code Text CDS Seven digit combined code - Note Text this is the code used as a key for all records in system. TS6_BEN Type of benefit. Text TS6_DESC Description of benefit. Text TS6_STEP Number of plans entered. Number TS6_COLUMN 1 is for single plan, Number 2 is for two-party, 3 is family, 4 is composite. TS6_ANNUAL Annual cost of the plan Number TS6_CONTR Employer contribution Number TS6_FTE No. of FTEs in the plan Number ----------------------------------------------------------------- Questions may be directed to Office of Financial Accountability and Information Services at: sacsinfo@cde.ca.gov 916-322-1770