J90 2019-20 Readme - Certificated Salaries & Benefits (CA ...



Readme for the 2019–20 Report of Teacher Salary and Benefit Data (Form J-90)California Department of EducationDecember 20, 2020Background:In a continuing effort to share the results of our data collections, 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. The self-extracting zipped file j901920.exe contains three files: the readme file (j901920readme.docx), the summarized report j90summary1920.pdf, and a Microsoft Access database, j901920.accdb. When executed, the files are extracted onto your PC into the default subdirectory C:\j901920. (You can change the extract directory.)File layouts for the Access database.J-90 TSAL120 FileContains information from sections I, III, IV, V, and VI of the J-90.Field# of Characters or NumberSourceDescription of Contents for General dataCountyC 2J-90Two digit county codeDistrictC 5J-90Five digit district CodeCDSC 7J-90Seven digit combined code - Note this is the code used as a key for all records in systemTS1_DnameC 34MasterDistrict Name (Long name)TS1_CountyC 18MasterCounty NameTS1_TypeC 1Master0=COE, 1=Elementary, 2=High School, 4=Unified, 3=Common Admin DistrictTS1_ADAN 7MasterThe current P-2 ADATS1_BAColN 2J-90The column number for BA+60 determinationTS1_PctchgN 7.2J-90Percentage change in salary schedule over the last year.TS1_NdaysN 4J-90Number of student instructional daysTS1_RdaysN 4J-90Number of service days required of returning teachers.TS1_HstepN 3J-90Highest entry level step for experienced teacher.TS1_HcolN 3J-90Column indicator for entry level experienced teacher.TS1_MinsalN 6J-90The minimum salary offered to teaching staffTS1_MaxsalN 6J-90The maximum salary offered to teaching staffTS1_totfteN 10.2J-90The number of full time teachers on salary schedule.TS1_counsC 1J-90Indicates whether counselors are paid from salary schedule.TS1_nurseC 1J-90Indicates whether nurses are paid from salary schedule.TS1_psychC 1J-90Indicates whether psychologists are paid from salary schedule.TS1_libraC 1J-90Indicates whether librarians are paid from salary schedule.TS1_MBonanN 9.2J-90Indicated bonus amount paid over salary schedule for Master’s degreeTS1_MbonftN 9.2J-90Indicates number of FTE's eligible for Master’s degree bonusTS1_DbonamN 9.2J-90Indicates bonus amount paid over salary schedule for Doctorate degree.TS1_DbonftN 9.2J-90Indicates number of FTE's eligible for Doctorate degree bonus.TS1_SEbonaN 9.2J-90Indicates bonus amount paid over salary schedule for Special Education assignment.TS1_SEbonfN 9.2J-90Number of FTE's eligible for Special Education assignment bonus.TS1_BBonamN 9.2J-90Indicates bonus amount paid over salary schedule for Bilingual assignments.TS1_BBonftN 9.2J-90Number of FTE's eligible for Bilingual assignments bonus.TS1_O1bonaTS1_O2bonaTS1_O3bonaTS1_O4bonaN 9.2J-90Indicates bonus amount paid over salary schedule for other Credential Instructional Assignments (up to 4 the user can add).TS1_O1bonfTS1_O2bonfTS1_O3bonfTS1_O4bonfN 9.2J-90Number of FTE's for each type of additional bonus.TS1_O1descTS1_O2descTS1_O3descTS1_O4descC 20J-90Description of each additional bonus.TS1_PrinEN 9.2J-90The average annual elementary principal salary.TS1_PrinMN 9.2J-90The average annual middle school principal salaryTS1_PrinHN 9.2J-90The average annual high school principal salaryTS1_SuptN 9.2J-90The annual salary of the district superintendentTS1_DprinEN 9.2J-90Number of obligated service days for elementary school principlesTS1_DprinMN 9.2J-90Number of obligated service days for middle school principlesTS1_DprinHN 9.2J-90Number of obligated service days for high school principlesTS1_DissupN 9.2J-90Number of obligated service days for District SuperintendentTS1_PctsupN 6.2J-90Percentage for the Superintendent if it is less than full timeTS1_EffdatDateJ-90The effective date of the contractTS1_NoteC 80J-90The name of the agency or trust through which the district purchases the health plansTS1_ConfC 1EnteredAfter the district returns the confirmation for to SSC, this field contains a “Y”TS1_MaxcafN 8.2J-90The maximum annual employer contributions to cafeteria planTS1_MaxsinN 8.2J-90The maximum annual employer contributions to single plan per employee.TS1_MaxtwoN 8.2J-90The maximum annual employer contributions to a two party plan per employee.TS1_MaxthreeN 8.2J-90The maximum annual employer contributions to a three party plan per employeeTS1_MaxfamN 8.2J-90The maximum annual employer contributions to a family plan per employee.TS1_CAPTYPEC 2J-90Is the cap hard or soft or NAPrintedC 1J-90This indicates whether the confirmation reports were printedLastcolN 2J-90Indicates the last column on salary scheduleNote2_1C 60J-90Minimum salary exception explanationNote2_2C 60J-90Minimum salary exception explanationNote 3_1C 60J-90Maximum salary exception explanationNote 3_2C 60J-90Maximum salary exception explanationNote 4_1C 60J-90Benefits FTE exception explanationNote 4_2C 60J-90Benefits FTE exception explanationOther_planN 1J-90Is other benefit plan, a replacement or addition to the other health plans; 1=addition, 2=replacementBen_lifeC 1J-90Does district cover retirees for life? (Y/N)Ben_stopN 3J-90If not for life, when do benefits stop? Age or yearsMaxbonpctN 6.2J-90Maximum bonus percentageH_planN 2J-90Number of Health plansD_planN 2J-90Number of dental plansV_planN 2J-90Number of vision plansL_planN 2J-90Number of life plansO_planN 2J-90Number of other plansAxbonusaN 6J-90Across the board bonus amountAxbonuspN 5.2J-90Across the board bonus percentageRetroactC 1J-90Can salary schedule retroactive? (Y/N)IncludeC 1J-90Are the benefit dollars included in the salary schedule? (Y/N)TS1_cbonamN 9.2J-90For CLAD bonus amountTS1_cbonttN 9.2J-90For CLAD bonus FTEsTS1_bcbonaN 9.2J-90For BCLAD bonus amountTS1_bcbonfN 9.2J-90For BCLAD bonus FTEsTS1_nbonamN 9.2J-90For National Teacher Certification bonus amountTS1_nbonftN 9.2J-90For National Teacher Certification bonus FTEsEstepN 2J-90Highest entry step for an emergency or intern credential teacherEcolN 2J-90Highest entry column for an emergency or intern credential teacherSSAmtN 7.2J-90Summer school pay rate per sessionNote 5_1C 60J-90Summer school pay rate explanationColHeadC 5J-90Beginning salary column heading descriptionEFTEN 9.2J-90Number of FTEs with emergency or intern credentialSSHrN 7.2J-90Summer school pay rate per hourSSDAYN 9.2J-90Summer school daily rateCHARTERC 1J-90Salary schedule include charter school teachers? (Y/N)CHTFTEN 6J-90Number of charter school FTES included in the J-90R_OTHERN 1J-90Is other benefit plan, a replacement or addition to the other health plans in retired employees over 65; 1=addition, 2=replacementUR_OTHERN 1J-90Is other benefit plan, a replacement or addition to the other health plans in retired employees under 66; 1=addition, 2=replacementRETIREN 1J-90Is benefit plan provided for retired employees over 65URETIREN 1J-90Is benefit plan provided for retired employees under 65BONUSAPPC 1J-90Do bonuses increase automatically as across-the-board increases are applied to the salary schedule? (Y/N)LIABILITYN 13J-90Unfunded liability amount reported in actuarial studySTUDYDATEC 10J-90Latest actuarial study dateBA30COLN 3EnteredBA+30 Salary column number in the scheduleTsal_tsDate/TimeJ-90The time and date the J-90 was submittedJ-90 TSAL220 FileContains the text headings entered for each of the columns in the salary schedule, Section II.Field# of Characters or NumberSourceDescription of Contents For salary schedule column headingCountyC 2J-90Two digit county codeDistrictC 5J-90Five digit district codeCDSC 7J-90Seven digit combined codeTS2_ColN 6J-90This indicates the column numberTS2_Col1TS2_Col1ATS2_Col2TS2_Col2A TS2_Col3TS2_Col3AC 20J-90These fields contain the description for the column, up to 20 characters each. Example: BA+60+MATs2_idN 6CalculatedTs2 ID number that is generated when a J-90 is submitted. Each record has an ID number.J-90 TSAL320 FileContains the salary and FTEs for each column and salary in Section II.Field# of Characters or NumberSourceDescription of Contents For salary scheduleCountyC 2J-90Two digit county codeDistrictC 5J-90Five digit county codeCDSC 7J-90Seven digit county codeTS3_ColN 6J-90This indicates the column for the salaryTS3_StepN 6J-90This is used to indicate the step for this salaryTS3_SalaryN 6J-90This is the number of FTEs associated with this column and stepTS3_FTEN 8.2J-90This is the number of FTEs associated with this column and stepTs3_SALCOSN 30CalculatedCalculated field of salary times number of FTEsTs3_IDN 6CalculatedTs3 ID number that is generated when a J-90 is submitted. Each record has an ID numberJ-90 TSAL420 FileContains the benefit information in Section VII.Field# of Characters or NumberSourcesDescription of ContentsFor active FTEs health and welfare benefitsCountyC 2J-90Two digit county codeDistrictC 5J-90Five digit district codeCDSC 7J-90Seven digit combined codeTS4_BenC 1J-90A one character code indicating type of benefit. H for health, D for dental, V for vision, L for life, O for otherTS4_DescC 30J-90The name of the planTS4_StepN 6CalculatedThe health benefit plans ID. The first is always 1, the second and subsequent like plans are number consequently. This is calculated by the input programTS4_ColumnN 6CalculatedA column 1 is always Single, 2 is two party plan, 3 is family plan, 4 is composite rate, 5 is three-party planTS4_AnnualN 8.2J-90The annual cost of plan for active employeesTS4_ContrN 8.2J-90The amount the district contributes to the cost of the planTS4_FTEN 8.2J-90The number of active employees participating in the planTS4_IDN 6CalculatedTs4_ID number that is generated when a J-90 is submitted. Each record has an ID numberJ-90 TSAL520 FileContains the benefit information in Section VIII for retirees over 65.Field# of Characters or NumberSourceDescription of Contents For retirees over 66 yearsCountyC 2J-90Two digit county codeDistrictC 5J-90Five digit district codeCDSC 7J-90Seven digit combined codeTS5_BenC 1J-90A one character code indicating type of benefit. H for health, D for dental, V for vision, L for life, O for otherTS5_DescC 30J-90The name of the planTS5_StepN 6CalculatedThe health benefit plans ID. The first is always 1, the second and subsequent like plans are number consequently. This is calculated by the input programTS5_ColumnN 6CalculatedA column 1 is always Single, 2 is two party plan, 3 is family plan, 4 is composite rate, 5 is three-party planTS5-AnnualN 8.2J-90The annual cost of planTS5_ContrN 8.2J-90The amount the district contributes to the cost of the planTS5_FTEN 8.2J-90The number of retired teachers (age 66 or over) participating in the planTS5_IDN 6CalculatedTs5_ID number that is generated when a J-90 is submitted. Each record has an ID numberJ-90 TSAL620 FileContains the benefit information in Section VIII for retirees 65 and under.Field# of Characters or NumberSourceDescription of Contents for retirees under 65 yearsCountyC 2J-90Two digit county codeDistrictC 5J-90Five digit county codeCDSC 7J-90Seven digit combined codeTS6_BenC 1J-90A one character code indicating the type of benefit. H for health, D for dental, V for vision, L for life, O for otherTS6_DescC 30J-90The name of the planTS6_StepN 6CalculatedThe health benefit plans ID. The first is always 1, the second and subsequent like plans are number consequently. This is calculated by the input programTS6_ColumnN 6CalculatedA column 1 is always Single, 2 is two party plan, 3 is family plan, 4 is composite rate, 5 is three-party planTS6_AnnualN 8.2J-90The annual cost of planTS6_ContrN 8.2J-90The amount the district contributes to the cost of the planTS6_FTEN 8.2J-90The number of retired teachers (age 65 or under) participating in the planTS6_IDN 6CalculatedTs6_ID number that is generated when a J-90 is submitted. Each record has an ID numberQuestions may be directed to the Office of Financial Accountability and Information Services at:sacsinfo@cde.916-322-1770 ................
................

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

Google Online Preview   Download