J90 2017-18 Readme - Certificated Salaries & Benefits (CA ...



Readme for the 2017–18 Report of Teacher Salary and Benefit Data (Form J-90)California Department of EducationDecember 7, 2018Background: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 j901718.exe contains three files: the readme file (j901718readme.docx), the summarized report j90summary1718.pdf, and a Microsoft Access database, j901718.accdb. When executed, the files are extracted onto your PC into the default subdirectory C:\j901718. (You can change the extract directory.)File layouts for the Access database.J-90 TSAL118 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 last year.TS1_NdaysN 4J-90Number of student instructional days TS1_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 staff.TS1_MaxsalN 6J-90The maximum salary offered to teaching staff TS1_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_MBonamN 9.2J-90Indicates bonus amount paid over salary schedule for Masters degree.TS1_MbonftN 9.2J-90Indicates number of FTE's eligible for Masters 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_O1bonaN 9.2J-90Indicates bonus amount paid over salary schedule for other Credential Instructional Assignments (up to 4 the user can add).TS1_O1bonfN 9.2J-90Number of FTE's for each type of additional bonus.TS1_O1descC 20J-90Description of each additional bonus.TS1_O2bonaN 9.2J-90Indicates bonus amount paid over salary schedule for other Credential Instructional Assignments (up to 4 the user can add).TS1_O2bonfN 9.2J-90Number of FTE's for each type of additional bonus.TS1_O2descC 20?J-90Description of each additional bonus.TS1_O3bonaN 9.2J-90Indicates bonus amount paid over salary schedule for other Credential Instructional Assignments (up to 4 the user can add).TS1_O3descC 20J-90Description of each additional bonus.TS1_O3bonfN 9.2J-90Number of FTE's for each type of additional bonus.TS1_O4bonaN 9.2J-90Indicates bonus amount paid over salary schedule for other Credential Instructional Assignments (up to 4 the user can add).TS1_O4bonfN 9.2J-90Number of FTE's for each type of additional bonus.TS1_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 salary.TS1_PrinHN 9.2J-90The average annual high school principal salary.TS1_SuptN 9.2J-90The annual salary of the district superintendent.TS1_DprinEN 9.2J-90Number of obligated service days for elementary school principles.TS1_DprinMN 9.2J-90Number of obligated service days for middle school principles.TS1_DprinHN 9.2J-90Number of obligated service days for high school principles.TS1_DissupN 9.2J-90Number of obligated service days for District Superintendent.TS1_PctsupN 6.2J-90Percentage for the Superintendent if it is less than full time.TS1_EffdatDateJ-90The effective date of the contract.TS1_NoteC 80J-90The name of the agency or trust through which the district purchases the health plans.TS1_ConfC 1EnteredAfter the district returns the confirmation form to SSC, this field contains a "Y".TS1_MaxcafN 8.2J-90The maximum annual employer contributions to cafeteria plan.TS1_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 1EnteredThis indicates whether the confirmation reports were printed.LastcolN 2J-90Indicates the last column on salary scheduleNote2_1C 60J-90Minimum salary exception explanationNote2_2C 60J-90Minimum salary exception explanationNote3_1C 60J-90Maximum salary exception explanationNote3_2C 60J-90Maximum salary exception explanationNote4_1C 60J-90Benefits FTE exception explanationNote4_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 percentage H_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 amount TS1_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 sessionNote5_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 scheduleTsal1_tsDate/timeJ-90 The time and date the J-90 was submittedJ-90 TSAL218 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 codeDistrict C 5J-90Five digit district codeCDSC 7J-90Seven digit combined codeTS2_ColN 6J-90This indicates the column numberTS2_Col1C 20J-90These fields contain the description for the column, up to 20 characters each. Example BA+60+MATS2_Col1AC 20J-90These fields contain the description for the column, up to 20 characters each. Example BA+60+MATS2_Col2C 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 numberJ-90 TSAL318 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 codeDistrict C 5J-90Five digit district codeCDSC 7J-90Seven digit combined 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 annual salaryTS3_FTEN 8.2J-90This is the number of FTEs associated with this column and stepTs3_SalaryFteN 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 Tsal418 FileContains the benefit information in Section VII.Field# of Characters or NumberSourceDescription of Contents For active FTEs health and welfare benefitsCountyC 2J-90Two digit county codeDistrict C 5J-90Five digit district codeCDSC 7J-90Seven digit combined codeTS4_BenC 1J-90A one character code indicating type of benefit. H for heath, 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_FTE N 8.2J-90The number of active employees participating in the planTS4_ID N 6CalculatedTs4_ID number that is generated when a J-90 is submitted. Each record has an ID numberJ-90 TSAL518 FileContains the benefit information in Section VIII for retirees over 65.Field# of Characters or NumberSourceDescription of Contents For retirees over 65 yearsCountyC 2J-90Two digit county codeDistrict C 5J-90Five digit district codeCDSC 7J-90Seven digit combined codeTS5_BenC 1J-90A one character code indicating type of benefit. H for heath, 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_FTE N 8.2J-90The number of retired teachers (age 66 or over) participating in the planTS5_ID N 6CalculatedTs5_ID number that is generated when a J-90 is submitted. Each record has an ID numberJ-90 TSAL618 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 codeDistrict C 5J-90Five digit district codeCDSC 7J-90Seven digit combined codeTS6_BenC 1J-90A one character code indicating type of benefit. H for heath, 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_FTE N 8.2J-90The number of retired teachers (age 65 or under) participating in the planTS6_ID N 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:Email: sacsinfo@cde.Phone: 916-322-1770 ................
................

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

Google Online Preview   Download