Skip to main content
Skip table of contents

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.

contractAbsent15.8.0Number(25,10)Number of contracted days the employee was absent. Migrated from [SchoolStaff.REPAtnd].
contractDays15.8.0Number(25,10)Number of days for which the employee was contracted. Migrated from [SchoolStaff.MI_REPAtnd_contract].
contractHours15.8.0Number(25,10)Number of hours for which the employee was contracted. Migrated from [SchoolStaff.MI_REPHrs_contract].
contractHrsAbsent15.8.0Number(25,10)Number of contracted hours for which the employee was absent. Migrated from [SchoolStaff.REPhrsAb].
crdcAbsentDays17.1.0Number(25,10)Total days teacher was absent in the school year.
crdcFTE17.1.0Number(25,10)Total teacher FTE.
crdcNewTeacher17.1.0Varchar2(4)Year that the teacher started in the district.
crdcStaff17.1.0Varchar2(4)Support staff category.
ethnicAsian15.8.0Varchar2(4)Asian ethnicity. Migrated from [SchoolStaff.MI_ethnAsi].
ethnicBlack15.8.0Varchar2(4)Black or African American ethnicity. Migrated from [SchoolStaff.MI_ethnAfr].
ethnicHispanic15.8.0Varchar2(4)Hispanic or Latino ethnicity. Migrated from [SchoolStaff.MI_ethnLat].
ethnicIndian15.8.0Varchar2(4)American Indian or Alaskan Native ethnicity. Migrated from [SchoolStaff.MI_ethnInd].
ethnicPacific15.8.0Varchar2(4)Native Hawaiian or Other Pacific Islander ethnicity. Migrated from [SchoolStaff.MI_ethnPac].
ethnicWhite15.8.0Varchar2(4)White ethnicity. Migrated from [SchoolStaff.MI_ethnWhi].
excludeTSDL15.8.0Number(1,0)Use to exclude staff record from TSDL submission.
repCertType

15.8.0

Varchar2(4)Type of credential. Migrated from [SchoolStaff.REPCertType].
repCertDate15.8.0DateDate credential issued. Migrated from [SchoolStaff.REPCertDtIssu].
repCertExpireDate15.8.0DateDate of credential expiration. Migrated from [SchoolStaff.REPCertExDt].
repDistrict15.8.0Varchar2(12)Employed by district. Migrated from [SchoolStaff.MI_REP_DISTRICT].
repEffectiveness15.8.0Varchar2(4)Educator effectiveness.
repFunded15.8.0Varchar2(4)Funded position status. Migrated from [SchoolStaff.REPvacant].
repFundTitle15.8.0Varchar2(4)Employee funding type (Title I, Title II, Part A).
repGradFrom15.8.0Varchar2(12)Michigan sponsoring institution. Migrated from [SchoolStaff.REPGradDegRecIns].
repGradFromState15.8.0Varchar2(4)Non-Michigan sponsoring institution. Migrated from [SchoolStaff.REPStIssInst].
repHighDegree15.8.0Varchar2(4)Highest educational level. Migrated from [SchoolStaff.REPHighDeg].
repHireDate15.8.0DateDate of hire. Migrated from [SchoolStaff.REPdthire].
repLicense15.8.0Varchar2(24)Credential license number. Migrated from [SchoolStaff.REPlicense].
repPDdelivery15.8.0Number(25,10)Instructional delivery (strategy) days.
repPDmgmt15.8.0Number(25,10)Classroom management days.
repPIC15.8.0Varchar2(12)Personnel Identification Code (PIC). Migrated from [SchoolStaff.MI_REP_PIC].
repTermDate15.8.0DateDate of termination of employment. Migrated from [SchoolStaff.REPdtTermEmp].
repTermReason15.8.0Varchar2(4)Reason for termination. Migrated from [SchoolStaff.REPEmpStat].
specEdPrgmAssign15.8.0Varchar2(4)Special Education instructor program assignment. Migrated from [SchoolStaff.MI_SpecEd_PrgmAssign].
teacherEC15.8.0Number(1,0)Early Child caseload worker.
teacherEO15.8.0Number(1,0)Early On caseload worker. Migrated from [SchoolStaff.MI_EI_Teacher].
teacherLEP15.8.0Number(1,0)LEP student instructor. Migrated from [SchoolStaff.MI_LEP_Teacher].
teacherParaPro15.8.0Number(1,0)Para Professional.
teacherSpecEd15.8.0Number(1,0)Special Education instructor. Migrated from [SchoolStaff.MI_SpecEd_Teacher].
teacherVirtual15.8.0Number(1,0)Virtual Delivery teacher or Mentor.
teacherVocEd15.8.0Number(1,0)Vocational Education instructor.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.