The following table provides information about the source table/field names corresponding to the fields in the S_CRDC_Students_S table.
CRDC 2025–26 update: For the 2025–26 collection, nonbinary (X) gender breakdowns are no longer reported. A new optional Threat Assessment field is added for student-level reporting.
Note: Starting in CRDC 2025–26, nonbinary (_X) breakdowns are no longer reported for GEDPrepProg, distanceEdCourses, attemptedSATOrACT, retainedInGrade* fields, enrolled* course fields, giftedTalented, lepProgram, and all discipline, harassment, and restraint fields.
|
Field |
Description |
Source [Table]Field |
|---|---|---|
|
studentId |
Student ID |
[Students]ID |
|
studentDcid |
Student DCID |
|
|
includeInSnapshot |
Included in Snapshot |
Derived based on report parameters and enrollment dates:
|
|
studentNumber |
Student Number |
[Students]Student_Number |
|
schoolId |
CRDC School Id |
[S_SCH_CRDC_X]SCH_ID |
|
schoolNumber |
Student School Number |
[Students/ReEnrollments]SchoolID |
|
schoolName |
Student School Name |
[Schools]School_Name |
|
lastFirst |
Student Name |
[Students]Last_Name |
|
gender |
Gender. For CRDC 2025–26, only male (M) and female (F) are reported. Nonbinary (X) breakdowns are not collected, and students with a nonbinary gender are not included in any _X totals. |
[StudentCoreFields]PSCore_Legal_Gender
|
|
ethnicity |
Ethnicity |
[Students]FedEthnicity
|
|
servedInLEA |
Is the student served in a non-LEA facility? Used with preschool to fill the preschool non-LEA facility indicator (LEA_PSENR_NONLEAFAC_IND, SSPR-2.1) and the K–12 non-LEA facility indicator (LEA_NONLEAFAC_IND, SSPR-2.3), plus the non-LEA facility enrollment count (LEA_ENR_NONLEAFAC). |
[S_STU_CRDC_X]NonLEA_YN [S_SCH_CRDC_X]NonLEAFacility_YN |
|
preschool |
Preschooler Indicator |
[Students]Grade_Level
|
|
GEDPrepProg |
Does this student participate in a High School Equivalency Exam preparation program (for ages 16-19) operated by this LEA? |
[S_STU_CRDC_X]GEDPrepProgram_YN |
|
distanceEdCourses |
Is this a student enrolled in any distance education courses? |
[S_STU_CRDC_X]DistanceLearning_YN |
|
gradeLevel |
Student Grade Level |
[Students]Grade_Level |
|
ungradedCode |
Ungraded Code |
[S_STU_CRDC_X]Ungraded_YN [S_SCH_CRDC_X]UngradedDetail |
|
ageAsOfSnapshotDate |
Age as of SnapShot Date |
[Students]DOB |
|
idea |
Is this a student with one or more disabilities served under IDEA? |
[S_STU_CRDC_X]IDEA_YN |
|
section504 |
Is this a student with disabilities served under Section 504, but not served under IDEA? |
[S_STU_CRDC_X]Section504_YN |
|
lepQualified |
Is this a student who is an English Learner (EL)? |
[S_STU_CRDC_X]EnglishLearner_YN |
|
lepProgram |
Is this student enrolled in English Learner Programs? |
[S_STU_CRDC_X]EnglishLearnerPrograms_YN |
|
ideaSnapshot |
Is this a student with one or more disabilities served under IDEA as of snapshot date? |
[S_STU_CRDC_X]IDEA_YN
|
|
section504Snapshot |
Is this a student with disabilities served under Section 504, but not served under IDEA as of snapshot date? |
[S_STU_CRDC_X]Section504_YN
|
|
lepQualifiedSnapshot |
Is this a student who is an English Learner (EL) as of snapshot date? |
[S_STU_CRDC_X]EnglishLearner_YN
|
|
giftedTalented |
Is this a student enrolled in Gifted and Talented programs? |
[S_STU_CRDC_X]GiftedTalentedPrograms_YN |
|
enrolledDualEnr |
Is this a student enrolled in Dual Enrollment or Dual Credit Programs? |
[S_STU_CRDC_X]DualEnrollment_YN |
|
creditRecovery |
Does this student participate in at least one credit recovery program? |
[S_STU_CRDC_X]CreditRecovery_YN |
|
enrolledAlgebraI |
Has the student enrolled in an AlgebraI course? |
[S_CRS_CRDC_X]CourseTypeAlgebraI_YN
|
|
passedAlgebraI |
Has the student passed an AlgebraI course? |
[GradeScaleItem]GraduationCredit |
|
AlgebraISchoolId |
School id where student has enrolled in an AlgebraI course? |
[S_CRS_CRDC_X]CourseTypeAlgebraI_YN
|
|
geoschoolid |
School id where student has enrolled in a Geometry course? |
[S_CRS_CRDC_X]CourseTypeGeometry_YN
|
|
AlgebraIISchoolId |
School id where student has enrolled in an AlgebraII course? |
[S_CRS_CRDC_X]CourseTypeAlgebraII_YN
|
|
Apschoolid |
School id where student has enrolled in an Advance Placement course? |
[S_CRS_CRDC_X]APSubjectArea
|
|
AdvMathSchoolId |
School id where student has enrolled in an Advance Maths course? |
[S_CRS_CRDC_X]CourseTypeAdvMath_YN
|
|
CalculusSchoolId |
School id where student has enrolled in a Calculus course? |
[S_CRS_CRDC_X]CourseTypeCalculus_YN
|
|
BiologySchoolId |
School id where student has enrolled in a Biology course? |
[S_CRS_CRDC_X]CourseTypeBiology_YN
|
|
ChemistrySchoolId |
School id where student has enrolled in a Chemistry course? |
[S_CRS_CRDC_X]CourseTypeChemistry_YN
|
|
PhysicsSchoolId |
School id where student has enrolled in a Physics course? |
[S_CRS_CRDC_X]CourseTypePhysics_YN
|
|
CompSciSchoolId |
School id where student has enrolled in a Computer Science course? |
[S_CRS_CRDC_X]CourseTypeCompSci_YN
|
|
DataSciSchoolId |
School id where student has enrolled in a Data Science course? |
[S_CRS_CRDC_X]CourseTypeDataSci_YN
|
|
APMathSchoolId |
School id where student has enrolled in an Advance Placement Math course? |
[S_CRS_CRDC_X]APSubjectArea
|
|
APCompSciSchoolId |
School id where student has enrolled in an Advance Placement Computer Science course? |
[S_CRS_CRDC_X]APSubjectArea
|
|
APScienceSchoolId |
School id where student has enrolled in an Advance Placement Science course? |
[S_CRS_CRDC_X]APSubjectArea
|
|
enrolledGeometry |
Has the student enrolled in a Geometry course? |
[S_CRS_CRDC_X]CourseTypeGeometry_YN
|
|
enrolledAlgebraII |
Has the student enrolled in an AlgebraII course? |
[S_CRS_CRDC_X]CourseTypeAlgebraII_YN
|
|
enrolledAdvMath |
Has the student enrolled in an Advance Math course? |
[S_CRS_CRDC_X]CourseTypeAdvMath_YN
|
|
enrolledCalculus |
Has the student enrolled in a Calculus course? |
[S_CRS_CRDC_X]CourseTypeCalculus_YN
|
|
enrolledBiology |
Has the student enrolled in a Biology course? |
[S_CRS_CRDC_X]CourseTypeBiology_YN
|
|
enrolledChemistry |
Has the student enrolled in a Chemistry course? |
[S_CRS_CRDC_X]CourseTypeChemistry_YN
|
|
enrolledPhysics |
Has the student enrolled in a Physics course? |
[S_CRS_CRDC_X]CourseTypePhysics_YN
|
|
singleSex |
Has the student enrolled in a course restricted to a single gender? For CRDC 2025–26, only male (M) and female (F) values are reported. |
[S_SCH_CRDC]SingleSexClass_YN
|
|
enrolledCompSci |
Has the student enrolled in a Computer Science course? |
[S_CRS_CRDC_X]CourseTypeCompSci_YN
|
|
enrolledDataSci |
Has the student enrolled in a Data Science course? |
[S_CRS_CRDC_X]CourseTypeDataSci_YN
|
|
enrolledIBDiplomaProgram |
Has the student enrolled in an International Baccalaureate (IB) Diploma Program? |
[S_STU_CRDC_X]IBDiplomaProgram_YN
|
|
enrolledAP |
Has the student enrolled in an Advance Placement course? |
[S_CRS_CRDC_X]APSubjectArea
|
|
enrolledAPMath |
Has the student enrolled in an Advance Placement Math course? |
[S_CRS_CRDC_X]APSubjectArea
|
|
enrolledAPScience |
Has the student enrolled in an Advance Placement Science course? |
[S_CRS_CRDC_X]APSubjectArea
|
|
enrolledAPCompSci |
Has the student enrolled in an Advance Placement Computer Science course? |
[S_CRS_CRDC_X]APSubjectArea
|
|
enrolledAPOther |
Has the student enrolled in an Advance Placement (Other) course? |
[S_CRS_CRDC_X]APSubjectArea
|
|
attemptedSATOrACT |
Did this student take the SAT/ACT? |
[S_STU_CRDC_X]SAT_YN
|
|
retainedInGradeKG |
Is the student retained in Kindergarten? |
[Students]Grade_Level
|
|
retainedInGrade1 |
Is the student retained in Grade 1? |
[Students]Grade_Level
|
|
retainedInGrade2 |
Is the student retained in Grade 2? |
[Students]Grade_Level
|
|
retainedInGrade3 |
Is the student retained in Grade 3? |
[Students]Grade_Level
|
|
retainedInGrade4 |
Is the student retained in Grade 4? |
[Students]Grade_Level
|
|
retainedInGrade5 |
Is the student retained in Grade 5? |
[Students]Grade_Level
|
|
retainedInGrade6 |
Is the student retained in Grade 6? |
[Students]Grade_Level
|
|
retainedInGrade7 |
Is the student retained in Grade 7? |
[Students]Grade_Level
|
|
retainedInGrade8 |
Is the student retained in Grade 8? |
[Students]Grade_Level
|
|
retainedInGrade9 |
Is the student retained in Grade 9? |
[Students]Grade_Level
|
|
retainedInGrade10 |
Is the student retained in Grade 10? |
[Students]Grade_Level
|
|
retainedInGrade11 |
Is the student retained in Grade 11? |
[Students]Grade_Level
|
|
retainedInGrade12 |
Is the student retained in Grade 12? |
[Students]Grade_Level
|
|
corporalPunishment |
Corporal Punishment Indicator |
[S_SCH_CRDC_X]CorpPunishment_YN |
|
numInSchoolSuspensions |
Number of In-School-Suspensions |
|
|
numOutOfSchoolSuspensions |
Number of Out-School-Suspensions |
|
|
missedDaysOSS |
Number of School Days Missed Due to Out-School-Suspensions |
|
|
expulsions |
Number of Expulsions |
|
|
expulsionsEduService |
Number of Expulsions with educational services |
|
|
expulsionsNoEduService |
Number of Expulsions without educational services |
|
|
expulsionsZeroTolerance |
Number of Expulsions Under Zero-Tolerance Policies |
|
|
transToOtherSch |
Discipline of Students – Transfer to Alternative School |
|
|
referredLawEnforcement |
Instances of Referrals to Law Enforcement |
|
|
schoolRelatedArrest |
School Arrest |
|
|
threatAssessment |
Did this student receive a threat assessment? Feeds the CRDC 2025–26 Threat Assessment module for preschool students (SCH_PSTHR_*), K–12 students without disabilities (SCH_K12THRWODIS_*), and K–12 students with disabilities (SCH_K12THRWDIS_*). Report only when SCH_THR_IND = Yes and SCH_RIS_IND is not Yes. Optional for 2025–26. |
[S_CRDC_STUDENTS_S]threatAssessmentStudInd |
|
harassedSex |
Harassed or Bullied – Sex. Gender identity is not reported for 2025–26, and nonbinary breakdowns (SCH_HBREPORTED_SEX_*_X) are not collected. |
|
|
harassedRaceColorNatl |
Harassed or Bullied - Race, Color, or National Origin |
|
|
harassedDisability |
Harassed or Bullied - Disability |
|
|
harassmentDiscSex |
Harassment or Bullying - Sex |
|
|
harassmentDiscRaceColorNatl |
Harassment or Bullying - Race, Color, or National Origin |
|
|
harassmentDiscDisability |
Harassment or Bullying - Disability |
|
|
restraintMechanical |
Mechanical restraint indicator. Feeds school-level Restraint and Seclusion (RSTR) reporting, which does not apply when SCH_RIS_IND = Yes. For K–12 students served only in non-LEA facilities, this field also feeds non-LEA facility restraint reporting (LEA_NONLEAMECH_IND, LEA_NONLEAMECH_*). Optional for 2025–26. |
|
|
restraintPhysical |
Physical restraint indicator. Feeds school-level Restraint and Seclusion (RSTR) reporting, which does not apply when SCH_RIS_IND = Yes. For K–12 students served only in non-LEA facilities, this field also feeds non-LEA facility reporting (LEA_NONLEAPHYS_IND, LEA_NONLEAPHYS_*). Optional for 2025–26. |
|
|
seclusion |
Seclusion indicator. Feeds school-level Restraint and Seclusion (RSTR) reporting, which does not apply when SCH_RIS_IND = Yes. For K–12 students served only in non-LEA facilities, this field also feeds non-LEA facility reporting (LEA_NONLEASECL_IND, LEA_NONLEASECL_*). Optional for 2025–26. |
|