S_MI_SSF_TSDL_X (ver 15.8.0)
This table is an extension of the [SchoolStaff] table.
Column Name | Version | Data Type | Description |
---|---|---|---|
SchoolStaffDCID | 15.8.0 | Number(10,0) | Primary key that relates the extended table back to the [SchoolStaff] table. |
contractAbsent | 15.8.0 | Number(25,10) | Number of contracted days the employee was absent. Migrated from [SchoolStaff.REPAtnd]. |
contractDays | 15.8.0 | Number(25,10) | Number of days for which the employee was contracted. Migrated from [SchoolStaff.MI_REPAtnd_contract]. |
contractHours | 15.8.0 | Number(25,10) | Number of hours for which the employee was contracted. Migrated from [SchoolStaff.MI_REPHrs_contract]. |
contractHrsAbsent | 15.8.0 | Number(25,10) | Number of contracted hours for which the employee was absent. Migrated from [SchoolStaff.REPhrsAb]. |
crdcAbsentDays | 17.1.0 | Number(25,10) | Total days teacher was absent in the school year. |
crdcFTE | 17.1.0 | Number(25,10) | Total teacher FTE. |
crdcNewTeacher | 17.1.0 | Varchar2(4) | Year that the teacher started in the district. |
crdcStaff | 17.1.0 | Varchar2(4) | Support staff category. |
ethnicAsian | 15.8.0 | Varchar2(4) | Asian ethnicity. Migrated from [SchoolStaff.MI_ethnAsi]. |
ethnicBlack | 15.8.0 | Varchar2(4) | Black or African American ethnicity. Migrated from [SchoolStaff.MI_ethnAfr]. |
ethnicHispanic | 15.8.0 | Varchar2(4) | Hispanic or Latino ethnicity. Migrated from [SchoolStaff.MI_ethnLat]. |
ethnicIndian | 15.8.0 | Varchar2(4) | American Indian or Alaskan Native ethnicity. Migrated from [SchoolStaff.MI_ethnInd]. |
ethnicPacific | 15.8.0 | Varchar2(4) | Native Hawaiian or Other Pacific Islander ethnicity. Migrated from [SchoolStaff.MI_ethnPac]. |
ethnicWhite | 15.8.0 | Varchar2(4) | White ethnicity. Migrated from [SchoolStaff.MI_ethnWhi]. |
excludeTSDL | 15.8.0 | Number(1,0) | Use to exclude staff record from TSDL submission. |
repCertType | 15.8.0 | Varchar2(4) | Type of credential. Migrated from [SchoolStaff.REPCertType]. |
repCertDate | 15.8.0 | Date | Date credential issued. Migrated from [SchoolStaff.REPCertDtIssu]. |
repCertExpireDate | 15.8.0 | Date | Date of credential expiration. Migrated from [SchoolStaff.REPCertExDt]. |
repDistrict | 15.8.0 | Varchar2(12) | Employed by district. Migrated from [SchoolStaff.MI_REP_DISTRICT]. |
repEffectiveness | 15.8.0 | Varchar2(4) | Educator effectiveness. |
repFunded | 15.8.0 | Varchar2(4) | Funded position status. Migrated from [SchoolStaff.REPvacant]. |
repFundTitle | 15.8.0 | Varchar2(4) | Employee funding type (Title I, Title II, Part A). |
repGradFrom | 15.8.0 | Varchar2(12) | Michigan sponsoring institution. Migrated from [SchoolStaff.REPGradDegRecIns]. |
repGradFromState | 15.8.0 | Varchar2(4) | Non-Michigan sponsoring institution. Migrated from [SchoolStaff.REPStIssInst]. |
repHighDegree | 15.8.0 | Varchar2(4) | Highest educational level. Migrated from [SchoolStaff.REPHighDeg]. |
repHireDate | 15.8.0 | Date | Date of hire. Migrated from [SchoolStaff.REPdthire]. |
repLicense | 15.8.0 | Varchar2(24) | Credential license number. Migrated from [SchoolStaff.REPlicense]. |
repPDdelivery | 15.8.0 | Number(25,10) | Instructional delivery (strategy) days. |
repPDmgmt | 15.8.0 | Number(25,10) | Classroom management days. |
repPIC | 15.8.0 | Varchar2(12) | Personnel Identification Code (PIC). Migrated from [SchoolStaff.MI_REP_PIC]. |
repTermDate | 15.8.0 | Date | Date of termination of employment. Migrated from [SchoolStaff.REPdtTermEmp]. |
repTermReason | 15.8.0 | Varchar2(4) | Reason for termination. Migrated from [SchoolStaff.REPEmpStat]. |
specEdPrgmAssign | 15.8.0 | Varchar2(4) | Special Education instructor program assignment. Migrated from [SchoolStaff.MI_SpecEd_PrgmAssign]. |
teacherEC | 15.8.0 | Number(1,0) | Early Child caseload worker. |
teacherEO | 15.8.0 | Number(1,0) | Early On caseload worker. Migrated from [SchoolStaff.MI_EI_Teacher]. |
teacherLEP | 15.8.0 | Number(1,0) | LEP student instructor. Migrated from [SchoolStaff.MI_LEP_Teacher]. |
teacherParaPro | 15.8.0 | Number(1,0) | Para Professional. |
teacherSpecEd | 15.8.0 | Number(1,0) | Special Education instructor. Migrated from [SchoolStaff.MI_SpecEd_Teacher]. |
teacherVirtual | 15.8.0 | Number(1,0) | Virtual Delivery teacher or Mentor. |
teacherVocEd | 15.8.0 | Number(1,0) | Vocational Education instructor. |