PowerSchool SIS All States

S_CRDC_School_S

CRDC 2025–26 updates

Bilingual teacher certification

  • SCH_FTETEACH_BILCERT (STAF-2.3) is new and optional. It reports FTE teachers certified in bilingual education.

School-level remote instruction

  • SCH_RIS_IND replaces the retired SCH_VIRT_IND (SCHR-1). It's required and reported as Yes/No as of the fall snapshot.

  • The optional INST module replaces the retired DIND module. All INST fields apply only when SCH_RIS_IND = No:

    • INST-1 SCH_INST_INSTRUCTIONTYPE: If the value is A, skip INST-2 and INST-3.

    • INST-2 SCH_INST_REMOTETYPE and INST-3 SCH_INST_REMOTEPERCT: Report these only when INST-1 is B or C.

    • SCH_DIND_REMOTEAMOUNT is no longer collected.

  • When SCH_RIS_IND = Yes, the RSTR, INET-1.4 and THRE modules don't apply.

.

The following table provides information about the source table/field names corresponding to the fields in the S_CRDC_School_S table.

Field

Description

Source [Table]Field

schoolId

CRDC School ID

[S_SCH_CRDC_X]SCH_ID

schoolName

School Name

[Schools]Name

remoteInstructionSettingInd

Remote Instruction and Setting Indicator (SCH_RIS_IND). Indicates whether the school provides remote instruction and setting.

[S_SCH_CRDC_X]RemoteInstructionSetting_YN

justiceFacilityInd

Justice Facility Indicator

[S_SCH_CRDC_X]JusticeFacility_YN

instructionType

Instruction Type (SCH_INST_INSTRUCTIONTYPE / INST-1). Optional when SCH_RIS_IND is No.

[S_SCH_CRDC_X]InstructionType

remoteInstructionType

Remote Instruction Type (SCH_INST_REMOTETYPE / INST-2). Optional when SCH_RIS_IND is No and INST-1 is B or C.

[S_SCH_CRDC_X]VirtualInstructionType

remoteInstructionPercentage

Remote Instruction Percentage (SCH_INST_REMOTEPERCT / INST-3). Optional when SCH_RIS_IND is No and INST-1 is B or C.

[S_SCH_CRDC_X]RemInstructSTUPercentage

S_CRDC_SCHOOLS_S.RemInstructStuPercentage

preKGAgeNonIDEA3

Preschool Age for Non-IDEA Children - Children age 3 years

[S_SCH_CRDC_X]PreKgAgeNonIDEA3_YN

preKGAgeNonIDEA4_5

Preschool Age for Non-IDEA Children - Children ages 4 and 5 years

[S_SCH_CRDC_X]PreKgAgeNonIDEA4_5_YN

providesPreKG

Grades with Students Enrolled - Preschool

[Schools]Low_Grade

providesKG

Grades with Students Enrolled - Kindergarten

[Schools]Low_Grade
[Schools]High_Grade

forStudentDisabilities

Is this school a special education school?

[S_SCH_CRDC_X]ForDisabilities_YN

magnetSchoolOrProgram

Is this school either a magnet school or a school operating a magnet program within the school?

[S_SCH_CRDC_X]MagnetSchoolOrProgram_YN

charterSchool

Is this school a charter school?

[S_SCH_CRDC_X]CharterSchool_YN

alternativeSchool

Is this school an alternative school?

[S_SCH_CRDC_X]AlternativeSchool_YN

allMagnetOnly

Magnet School Detail

[S_SCH_CRDC_X]AllMagnetOnly_YN

alternativeSchoolFocus

Alternative School Focus (SCH_ALTFOCUS). Valid values: Academic, Discipline, or Both.

[S_SCH_CRDC_X]AlternativeSchoolAcademic_TF
[S_SCH_CRDC_X]AlternativeSchoolDiscipline_TF

[S_CRDC_SCHOOLS_S]alternativeSchoolAcademic and [S_CRDC_SCHOOLS_S]alternativeSchDisc

hasGiftedTalentedStudents

Gifted and Talented Programs Indicator

 

hasDualEnrollment

Dual Enrollment Program Indicator

[S_SCH_CRDC_X]DualEnrollment_YN

numCoursesAP

Different Advanced Placement (AP) Courses

[Schools]NumCoursesAP

totFTETeachersAll

Total number of full-time equivalent (FTE) teachers

[S_SCH_CRDC_X]NoOfFTETeachers

totFTETeachersCert

Number of FTE teachers who are certified

[S_SCH_CRDC_X]NoOfFTETeachersCert

totFTETeachersNotCert

Number of FTE teachers who are not certified

[S_SCH_CRDC_X]NoOfFTETeachersNotCert

totFTETeachersBilingualCert

Number of FTE teachers who are certified in bilingual education (SCH_FTETEACH_BILCERT / STAF-2.3).

[S_SCH_CRDC_X]NoOfFTETeachersBilingualCert

[S_CRDC_SCHOOLS_S]totFTEBilingualTeachers

totFTEMathsTeachers

Number of FTE teachers—mathematics

[S_SCH_CRDC_X]NoOfFTETeachersMaths

totFTEScienceTeachers

Number of FTE teachers—science

[S_SCH_CRDC_X]NoOfFTETeachersScience

totFTEEnglishTeachers

Number of FTE teachers—English as a Second Language

[S_SCH_CRDC_X]NoOfFTETeachersEnglish

totFTESpecEduTeachers

Number of FTE teachers—special education

[S_SCH_CRDC_X]NoOfFTETeachersSpecEdu

providesInterSchAthletics

Interscholastic Athletics Indicator

[S_SCH_CRDC_X]InterSchParticipantsM
[S_SCH_CRDC_X]InterSchParticipantsF

numInterSchPrtcptsMaleOnly

Number of Interscholastic Athletics Participants - Male

[S_SCH_CRDC_X]InterSchParticipantsM

numInterSchPrtcptsFemOnly

Number of Interscholastic Athletics Participants - Female

[S_SCH_CRDC_X]InterSchParticipantsF

numInterSchPrtcptsTotal

Number of Interscholastic Athletics Participants - Total

[S_SCH_CRDC_X]InterSchParticipantsM
[S_SCH_CRDC_X]InterSchParticipantsF

numPreSchCorpPunishInst

Number of instances of corporal punishment - Preschool Children without Disabilities

[S_SCH_CRDC_X]CorporalPunishment

numAllegHarassSexualOrient

Allegations of harassment or bullying on the basis of sexual orientation

 

justiceFacEdPart31to90

Justice Facility Educational Program Participants - 31 days to 90 days

[S_SCH_CRDC_X]JusticeFacilityType

isFiberOpInetConnected

Is this school connected to the Internet through a fiber-optic connection?

[S_SCH_CRDC_X]SchInternetFiber_YN

hasWifiEveryClassroom

Does this school have Wi-Fi access in every classroom?

[S_SCH_CRDC_X]SchInternetWiFi_YN

allowInetDevicesBringToSch

Does this school allow students to bring to school student-owned devices that can be used to access the Internet for classroom or student learning? Does not apply when SCH_RIS_IND is Yes.

[S_SCH_CRDC_X]SchInternetStuDev_YN

numStuNeedWifiDevices

Number of Wi-Fi enabled devices needed. Applies only to schools that offered remote or hybrid instruction.

[S_SCH_CRDC_X]NoOfStuNeedWifiDevices

threatAssessmentTeamInd

Threat Assessment Team Indicator (SCH_THR_IND). New optional THRE module indicator; applies when SCH_RIS_IND is not Yes.

[S_SCH_CRDC_X]ThreatAssessmentTeam_YN

threatAssessmentCounts

Threat assessment counts for preschool and K-12 students, including students with and without disabilities.

calculated based on [S_CRDC_STUDENTS_S]threatAssessmentStudInd