J-90 File Layouts - 1999-00 read_db.txt 12-07-2000 December 7, 2000 IMPORTANT: This file contains the file format layouts you will need to interpret the J-90 Teacher Salary Databases. REPORT OF 1999-00 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 four files comprise the J-90 database: FIXDINFO: Contains information for sections I, III, and IV 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 V. The file j90_9900.exe is a self-extracting zipped file that contains these files. After downloading the file, copy it to an empty directory and extract by typing "j90_9900". The extracted files are quote and comma delimited format (.txt extension). FILE LAYOUT: FIXDINFO (882 records) Field Name Description Field Type COUNTY County Code A2 CDS County-district code A5 TS1_DNAME District name A30 TS1_CNAME County name A15 (NEW THIS YEAR) TS1_TYPE LEA type A1 TS1_ADA 2nd Period ADA N TS1_BACOL BA + 60 N TS1_PCTCHG % change over prior year's salary N TS1_NDAYS Number of teaching days N TS1_SDAYS No. instr days less staff dev days N TS1_RDAYS Number of service days N TS1_HSTEP Highest Step N TS1_HCOL Highest Column N TS1_MINSAL Minimum Salary N TS1_MAXSAL Maximum Salary N TS1_TOTFTE Total FTEs N TS1_COUNS Flag for counselors in schedule A1 TS1_NURSE Flag for nurses in schedule A1 TS1_PSYCH Flag for psychologists in schedule A1 TS1_LIBRA Flag for librarians in schedule A1 TS1_MBONAM Bonus, master's degree (amount) N TS1_MBONFT No. eligible for master's bonus N TS1_DBONAM Bonus, doctorate degree (amount) N TS1_DBONFT No. eligible for doctorate bonus N TS1_SEBONA Bonus, special education (amount) N TS1_SEBONF No. eligible for spec. ed. assignnt N TS1_BBONAM Bonus, bilingual assignment (amount) N TS1_BBONFT No. eligible for bilingual bonus N TS1_O1BONA Bonus, other assignment (amount) N TS1_O1BONF No. eligible for other bonus N TS1_O1DESC Description, other bonus A20 TS1_O2BONA Bonus, other assignment (amount) N TS1_O2BONF No. eligible for other bonus N TS1_O2DESC Description, other bonus A20 TS1_O3BONA Bonus, other assignment (amount) N TS1_O3BONF No. eligible for other bonus N TS1_O3DESC Description, other bonus A20 TS1_O4BONA Bonus, other assignment (amount) N TS1_O4BONF No. eligible for other bonus N TS1_O4DESC Description, other bonus A20 TS1_PRIN Schoolsite principal's salary N TS1_SUPT District superintendent's salary N TS1_SSPRIN Service days, principal N TS1_DISSUP Service days, superintendent N TS1_PRNSUP Principal's name N TS1_PCTSUP Weighted percentage superintendent N TS1_PCTPRN Weighted percentage principal N TS1_PCTOTH Weighted percentage other N TS1_EFFDAT Effective date D TS1_BRDDAT Board date D FILE LAYOUT: SALXSTEP (72,059 records) Field Name Description Field Type CCODE County code A2 CDS County-district code A5 TS3_COL Column N TS3_STEP Row N TS3_SALARY Amount of salary for one FTE N TS3_FTE No. FTE employed at this step & col N EXT_SALARY Salary multiplied by FTEs N FILE LAYOUT: COLMHDGS (4,816 records) Field Name Description Field Type CCODE County code A2 CDS County-district code A5 TS2_COL Relative position of column heading N TS2_COL1 Column description, first line A20 TS2_COL1A Column description, second line A20 TS2_COL2 Column description, third line A20 TS2_COL3 Column description, fourth line A20 TS2_COL3A Column description, fifth line A20 COL1DEG Type of degree (BA or AB) A2 COL1UNIT Units in addition to degree N COL1MA Masters degree required (yes/no) A2 COL2DEG Advance degree (e.g. MA) A2 COL2UNIT Units in addition to advanced degree N COL2MA Masters degree required (yes/no) A2 COL3DEG Third degree A2 COL3UNIT Units in addition to third degree N COL3MA Masters degree required (yes/no) A2 FILE LAYOUT: BENEINFO (11,114 records) Field Name Description Field Type CCODE County code A2 CDS County-district code A5 TS4_BEN Type of benefit A1 TS4_STEP Step of position N TS4_COLUMN Column of position N TS4_DESC Description of benefit A30 TS4_ANNUAL Annual cost of benefits N TS4_CONTR Employer contribution N TS4_FTE No. of FTEs eligible for benefit N Questions may be directed to Sonya Edwards at: sedwards@cde.ca.gov 916-322-5791