S_CRDC_Students_S

studentId

Student ID

 [Students]ID

studentDcid

Student DCID

includeInSnapshot

Included in Snapshot

Derived based on report parameters and enrollment dates:
[Students]EntryDate
[Students]ExitDate
[ReEnrollments]EntryDate
[ReEnrollments]ExitDate

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

[StudentCoreFields]PSCore_Legal_Gender
[Students]Gender

ethnicity

Ethnicity

[Students]FedEthnicity
[StudentRace]Race_CD

servedInLEA

Is the student school a Non-LEA facility?

[S_STU_CRDC_X]NonLEA_YN

[S_SCH_CRDC_X]NonLEAFacility_YN

preschool

Preschooler Indicator

[Students]Grade_Level
[Students]DOB

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
[Students]EntryDate
[Students]ExitDate
[ReEnrollments]EntryDate
[ReEnrollments]ExitDate

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
[Students]EntryDate
[Students]ExitDate
[ReEnrollments]EntryDate
[ReEnrollments]ExitDate

lepQualifiedSnapshot

Is this a student who is an English Learner (EL) as of snapshot date?

[S_STU_CRDC_X]EnglishLearner_YN
[Students]EntryDate
[Students]ExitDate
[ReEnrollments]EntryDate
[ReEnrollments]ExitDate

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
[S_SEC_CRDC_X]CourseTypeAlgebraI_YN
[CC]DateEnrolled
[CC]DateLeft
[Students]EntryDate
[Students]ExitDate
[ReEnrollments]EntryDate
[ReEnrollments]ExitDate

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
[S_SEC_CRDC_X]CourseTypeAlgebraI_YN
[CC]DateEnrolled
[CC]DateLeft
[CC]SchoolID

geoschoolid

School id where student has enrolled in a Geometry course?

[S_CRS_CRDC_X]CourseTypeGeometry_YN
[S_SEC_CRDC_X]CourseTypeGeometry_YN
[CC]DateEnrolled
[CC]DateLeft
[CC]SchoolID

AlgebraIISchoolId

School id where student has enrolled in an AlgebraII course?

[S_CRS_CRDC_X]CourseTypeAlgebraII_YN
[S_SEC_CRDC_X]CourseTypeAlgebraII_YN
[CC]DateEnrolled
[CC]DateLeft
[CC]SchoolID

Apschoolid

School id where student has enrolled in an Advance Placement course?

[S_CRS_CRDC_X]APSubjectArea
[S_SEC_CRDC_X]APSubjectArea
[CC]DateEnrolled
[CC]DateLeft
[CC]SchoolID

AdvMathSchoolId

School id where student has enrolled in an Advance Maths course?

[S_CRS_CRDC_X]CourseTypeAdvMath_YN
[S_SEC_CRDC_X]CourseTypeAdvMath_YN
[CC]DateEnrolled
[CC]DateLeft
[CC]SchoolID

CalculusSchoolId

School id where student has enrolled in a Calculus course?

[S_CRS_CRDC_X]CourseTypeCalculus_YN
[S_SEC_CRDC_X]CourseTypeCalculus_YN
[CC]DateEnrolled
[CC]DateLeft
[CC]SchoolID

BiologySchoolId

School id where student has enrolled in a Biology course?

[S_CRS_CRDC_X]CourseTypeBiology_YN
[S_SEC_CRDC_X]CourseTypeBiology_YN
[CC]DateEnrolled
[CC]DateLeft
[CC]SchoolID

ChemistrySchoolId

School id where student has enrolled in a Chemistry course?

[S_CRS_CRDC_X]CourseTypeChemistry_YN
[S_SEC_CRDC_X]CourseTypeChemistry_YN
[CC]DateEnrolled
[CC]DateLeft
[CC]SchoolID

PhysicsSchoolId

School id where student has enrolled in a Physics course?

[S_CRS_CRDC_X]CourseTypePhysics_YN
[S_SEC_CRDC_X]CourseTypePhysics_YN
[CC]DateEnrolled
[CC]DateLeft
[CC]SchoolID

CompSciSchoolId

School id where student has enrolled in a Computer Science course?

[S_CRS_CRDC_X]CourseTypeCompSci_YN
[S_SEC_CRDC_X]CourseTypeCompSci_YN
[CC]DateEnrolled
[CC]DateLeft
[CC]SchoolID

DataSciSchoolId

School id where student has enrolled in a Data Science course?

[S_CRS_CRDC_X]CourseTypeDataSci_YN
[S_SEC_CRDC_X]CourseTypeDataSci_YN
[CC]DateEnrolled
[CC]DateLeft
[CC]SchoolID

APMathSchoolId

School id where student has enrolled in an Advance Placement Math course?

[S_CRS_CRDC_X]APSubjectArea
[S_SEC_CRDC_X]APSubjectArea
[CC]DateEnrolled
[CC]DateLeft
[CC]SchoolID

APCompSciSchoolId

School id where student has enrolled in an Advance Placement Computer Science course?

[S_CRS_CRDC_X]APSubjectArea
[S_SEC_CRDC_X]APSubjectArea
[CC]DateEnrolled
[CC]DateLeft
[CC]SchoolID

APScienceSchoolId

School id where student has enrolled in an Advance Placement Science course?

[S_CRS_CRDC_X]APSubjectArea
[S_SEC_CRDC_X]APSubjectArea
[CC]DateEnrolled
[CC]DateLeft
[CC]SchoolID

enrolledGeometry

Has the student enrolled in a Geometry course?

[S_CRS_CRDC_X]CourseTypeGeometry_YN
[S_SEC_CRDC_X]CourseTypeGeometry_YN
[CC]DateEnrolled
[CC]DateLeft

enrolledAlgebraII

Has the student enrolled in an AlgebraII course?

[S_CRS_CRDC_X]CourseTypeAlgebraII_YN
[S_SEC_CRDC_X]CourseTypeAlgebraII_YN
[CC]DateEnrolled
[CC]DateLeft

enrolledAdvMath

Has the student enrolled in an Advance Math course?

[S_CRS_CRDC_X]CourseTypeAdvMath_YN
[S_SEC_CRDC_X]CourseTypeAdvMath_YN
[CC]DateEnrolled
[CC]DateLeft

enrolledCalculus

Has the student enrolled in a Calculus course?

[S_CRS_CRDC_X]CourseTypeCalculus_YN
[S_SEC_CRDC_X]CourseTypeCalculus_YN
[CC]DateEnrolled
[CC]DateLeft

enrolledBiology

Has the student enrolled in a Biology course?

[S_CRS_CRDC_X]CourseTypeBiology_YN
[S_SEC_CRDC_X]CourseTypeBiology_YN
[CC]DateEnrolled
[CC]DateLeft

enrolledChemistry

Has the student enrolled in a Chemistry course?

[S_CRS_CRDC_X]CourseTypeChemistry_YN
[S_SEC_CRDC_X]CourseTypeChemistry_YN
[CC]DateEnrolled
[CC]DateLeft

enrolledPhysics

Has the student enrolled in a Physics course?

[S_CRS_CRDC_X]CourseTypePhysics_YN
[S_SEC_CRDC_X]CourseTypePhysics_YN
[CC]DateEnrolled
[CC]DateLeft

singleSex

Has the student enrolled in a course restricted to Single Gender?

[S_SCH_CRDC]SingleSexClass_YN
[S_CRS_CRDC_X]SingleSexCode
[S_SEC_CRDC_X]SingleSexCode
[StudentCoreFields]PSCore_Legal_Gender
[Students]Gender

enrolledCompSci

Has the student enrolled in a Computer Science course?

[S_CRS_CRDC_X]CourseTypeCompSci_YN
[S_SEC_CRDC_X]CourseTypeCompSci_YN
[CC]DateEnrolled
[CC]DateLeft

enrolledDataSci

Has the student enrolled in a Data Science course?

[S_CRS_CRDC_X]CourseTypeDataSci_YN
[S_SEC_CRDC_X]CourseTypeDataSci_YN
[CC]DateEnrolled
[CC]DateLeft

enrolledIBDiplomaProgram

Has the student enrolled in an International Baccalaureate (IB) Diploma Program?

[S_STU_CRDC_X]IBDiplomaProgram_YN
[Students]EntryDate
[Students]ExitDate
[ReEnrollments]EntryDate
[ReEnrollments]ExitDate

enrolledAP

Has the student enrolled in an Advance Placement course?

[S_CRS_CRDC_X]APSubjectArea
[S_SEC_CRDC_X]APSubjectArea
[CC]DateEnrolled
[CC]DateLeft

enrolledAPMath

Has the student enrolled in an Advance Placement Math course?

[S_CRS_CRDC_X]APSubjectArea
[S_SEC_CRDC_X]APSubjectArea
[CC]DateEnrolled
[CC]DateLeft

enrolledAPScience

Has the student enrolled in an Advance Placement Science course?

[S_CRS_CRDC_X]APSubjectArea
[S_SEC_CRDC_X]APSubjectArea
[CC]DateEnrolled
[CC]DateLeft

enrolledAPCompSci

Has the student enrolled in an Advance Placement Computer Science course?

[S_CRS_CRDC_X]APSubjectArea
[S_SEC_CRDC_X]APSubjectArea
[CC]DateEnrolled
[CC]DateLeft

enrolledAPOther

Has the student enrolled in an Advance Placement (Other) course?

[S_CRS_CRDC_X]APSubjectArea
[S_SEC_CRDC_X]APSubjectArea
[CC]DateEnrolled
[CC]DateLeft

attemptedSATOrACT

Did this student take the SAT/ACT?

[S_STU_CRDC_X]SAT_YN
[S_STU_CRDC_X]ACT_YN
[Students]EntryDate
[Students]ExitDate
[ReEnrollments]EntryDate
[ReEnrollments]ExitDate

retainedInGradeKG

Is the student retained in Kindergarten?

[Students]Grade_Level
[ReEnrollment]Grade_Level

retainedInGrade1

Is the student retained in Grade 1?

[Students]Grade_Level
[ReEnrollment]Grade_Level

retainedInGrade2

Is the student retained in Grade 2?

[Students]Grade_Level
[ReEnrollment]Grade_Level

retainedInGrade3

Is the student retained in Grade 3?

[Students]Grade_Level
[ReEnrollment]Grade_Level

retainedInGrade4

Is the student retained in Grade 4?

[Students]Grade_Level
[ReEnrollment]Grade_Level

retainedInGrade5

Is the student retained in Grade 5?

[Students]Grade_Level
[ReEnrollment]Grade_Level

retainedInGrade6

Is the student retained in Grade 6?

[Students]Grade_Level
[ReEnrollment]Grade_Level

retainedInGrade7

Is the student retained in Grade 7?

[Students]Grade_Level
[ReEnrollment]Grade_Level

retainedInGrade8

Is the student retained in Grade 8?

[Students]Grade_Level
[ReEnrollment]Grade_Level

retainedInGrade9

Is the student retained in Grade 9?

[Students]Grade_Level
[ReEnrollment]Grade_Level

retainedInGrade10

Is the student retained in Grade 10?

[Students]Grade_Level
[ReEnrollment]Grade_Level

retainedInGrade11

Is the student retained in Grade 11?

[Students]Grade_Level
[ReEnrollment]Grade_Level

retainedInGrade12

Is the student retained in Grade 12?

[Students]Grade_Level
[ReEnrollment]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

harassedSex

Harassed or Bullied - Sex

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

restraintPhysical

Physical restraint Indicator

seclusion

Seclusion restraint Indicator