The following table provides information about the source table/field names corresponding to the fields in the S_CRDC_Students_S table.
|
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 |
[StudentCoreFields]PSCore_Legal_Gender
|
|
ethnicity |
Ethnicity |
[Students]FedEthnicity
|
|
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
|
|
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 Single Gender? |
[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 |
|
|
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 |
|