S_CRDC_STUDENTS_S (ver 24.11.1.0)
This table is a standalone table to store student data for the CRDC loader report.
Column Name | Version | Data Type | Description |
DCID | 24.11.1.0 | NUMERIC (10,0) | The primary key that relates the extended table to the table. |
EXPULSIONS | 24.11.1.0 | BOOLEAN | Number of Expulsions |
BIOLOGYSCHOOLID | 24.11.1.0 | VARCHAR2 (15) | School id where student has enrolled in a Biology course? |
APMATHSCHOOLID | 24.11.1.0 | VARCHAR2 (15) | School id where student has enrolled in an Advance Placement Math course? |
SINGLESEX | 24.11.1.0 | VARCHAR2 (10) | Has the student enrolled in a course restricted to Single Gender? |
UNGRADEDCODE | 24.11.1.0 | VARCHAR2 (1) | Ungraded Code |
MISSEDDAYSOSS | 24.11.1.0 | NUMERIC | Number of School Days Missed Due to Out-School-Suspensions |
HARASSMENTDISCRACECOLORNATL | 24.11.1.0 | BOOLEAN | Harassment or Bullying - Race, Color, or National Origin |
HARASSEDDISABILITY | 24.11.1.0 | BOOLEAN | Harassed or Bullied - Disability |
APSCHOOLID | 24.11.1.0 | VARCHAR2 (15) | School id where student has enrolled in an Advance Placement course? |
RETAINEDINGRADE1 | 24.11.1.0 | BOOLEAN | Is the student retained in Grade 1? |
RETAINEDINGRADE3 | 24.11.1.0 | BOOLEAN | Is the student retained in Grade 3? |
RETAINEDINGRADE2 | 24.11.1.0 | BOOLEAN | Is the student retained in Grade 2? |
ENROLLEDCHEMISTRY | 24.11.1.0 | BOOLEAN | Has the student enrolled in a Chemistry course? |
RETAINEDINGRADE5 | 24.11.1.0 | BOOLEAN | Is the student retained in Grade 5? |
RETAINEDINGRADE4 | 24.11.1.0 | BOOLEAN | Is the student retained in Grade 4? |
RETAINEDINGRADE7 | 24.11.1.0 | BOOLEAN | Is the student retained in Grade 7? |
RETAINEDINGRADE6 | 24.11.1.0 | BOOLEAN | Is the student retained in Grade 6? |
RETAINEDINGRADE9 | 24.11.1.0 | BOOLEAN | Is the student retained in Grade 9? |
RETAINEDINGRADE8 | 24.11.1.0 | BOOLEAN | Is the student retained in Grade 8? |
SCHOOLRELATEDARREST | 24.11.1.0 | BOOLEAN | School Arrest |
CHEMISTRYSCHOOLID | 24.11.1.0 | VARCHAR2 (15) | School id where student has enrolled in a Chemistry course? |
ENROLLEDBIOLOGY | 24.11.1.0 | BOOLEAN | Has the student enrolled in a Biology course? |
ALGEBRAIISCHOOLID | 24.11.1.0 | VARCHAR2 (15) | School id where student has enrolled in an Algebra II course? |
SECTION504 | 24.11.1.0 | BOOLEAN | Is this a student with disabilities served under Section 504, but not served under IDEA? |
ENROLLEDALGEBRAII | 24.11.1.0 | BOOLEAN | Has the student enrolled in an Algebra II course? |
ENROLLEDCOMPSCI | 24.11.1.0 | BOOLEAN | Has the student enrolled in a Computer Science course? |
EXPULSIONSZEROTOLERANCE | 24.11.1.0 | BOOLEAN | Number of Expulsions Under Zero-Tolerance Policies |
APSCIENCESCHOOLID | 24.11.1.0 | VARCHAR2 (15) | School id where student has enrolled in an Advance Placement Science course? |
ENROLLEDIBDIPLOMAPROGRAM | 24.11.1.0 | BOOLEAN | Has the student enrolled in an International Baccalaureate (IB) Diploma Program? |
DATASCISCHOOLID | 24.11.1.0 | VARCHAR2 (15) | School id where student has enrolled in a Data Science course? |
TRANSTOOTHERSCH | 24.11.1.0 | BOOLEAN | Discipline of Students – Transfer to Alternative School |
ENROLLEDAPMATH | 24.11.1.0 | BOOLEAN | Has the student enrolled in an Advance Placement Math course? |
EXPULSIONSEDUSERVICE | 24.11.1.0 | BOOLEAN | Number of Expulsions with educational services |
GIFTEDTALENTED | 24.11.1.0 | BOOLEAN | Is this a student enrolled in Gifted and Talented programs? |
ATTEMPTEDSATORACT | 24.11.1.0 | BOOLEAN | Did this student take the SAT/ACT? |
GEDPREPPROG | 24.11.1.0 | BOOLEAN | Does this student participate in a High School Equivalency Exam preparation program (for ages 16-19) operated by this LEA? |
HARASSMENTDISCDISABILITY | 24.11.1.0 | BOOLEAN | Harassment or Bullying - Disability |
PRESCHOOL | 24.11.1.0 | BOOLEAN | Preschooler Indicator |
ENROLLEDDUALENR | 24.11.1.0 | BOOLEAN | Is this a student enrolled in Dual Enrollment or Dual Credit Programs? |
GEOSCHOOLID | 24.11.1.0 | VARCHAR2 (15) | School id where student has enrolled in a Geometry course? |
GENDER | 24.11.1.0 | VARCHAR2 (10) | Gender |
NUMINSCHOOLSUSPENSIONS | 24.11.1.0 | NUMERIC | Number of In-School-Suspensions |
ETHNICITY | 24.11.1.0 | VARCHAR2 (10) | Ethnicity |
ADVMATHSCHOOLID | 24.11.1.0 | VARCHAR2 (15) | School id where student has enrolled in an Advance Maths course? |
ENROLLEDAPSCIENCE | 24.11.1.0 | BOOLEAN | Has the student enrolled in an Advance Placement Science course? |
ENROLLEDAP | 24.11.1.0 | BOOLEAN | Has the student enrolled in an Advance Placement course? |
HARASSMENTDISCSEX | 24.11.1.0 | BOOLEAN | Harassment or Bullying - Sex |
RESTRAINTMECHANICAL | 24.11.1.0 | BOOLEAN | Mechanical restraint Indicator |
INCLUDEINSNAPSHOT | 24.11.1.0 | BOOLEAN | Included in Snapshot |
DISTANCEEDCOURSES | 24.11.1.0 | BOOLEAN | Is this a student enrolled in any distance education courses? |
EXPULSIONSNOEDUSERVICE | 24.11.1.0 | BOOLEAN | Number of Expulsions without educational services |
ENROLLEDPHYSICS | 24.11.1.0 | BOOLEAN | Has the student enrolled in a Physics course? |
SCHOOLNUMBER | 24.11.1.0 | VARCHAR2 (15) | Student School Number |
CALCULUSSCHOOLID | 24.11.1.0 | VARCHAR2 (15) | School id where student has enrolled in a Calculus course? |
ENROLLEDDATASCI | 24.11.1.0 | BOOLEAN | Has the student enrolled in a Data Science course? |
PHYSICSSCHOOLID | 24.11.1.0 | VARCHAR2 (15) | School id where student has enrolled in a Physics course? |
PASSEDALGEBRAI | 24.11.1.0 | BOOLEAN | Has the student passed an AlgebraI course? |
NUMOUTOFSCHOOLSUSPENSIONS | 24.11.1.0 | NUMERIC | Number of Out-School-Suspensions |
SCHOOLID | 24.11.1.0 | VARCHAR2 (15) | CRDC School Id |
ENROLLEDALGEBRAI | 24.11.1.0 | BOOLEAN | Has the student enrolled in an Algebra I course? |
AGEASOFSNAPSHOTDATE | 24.11.1.0 | NUMERIC | Age as of SnapShot Date |
LEPPROGRAM | 24.11.1.0 | BOOLEAN | Is this student enrolled in English Learner Programs? |
LASTFIRST | 24.11.1.0 | VARCHAR2 (100) | Student Name |
CREDITRECOVERY | 24.11.1.0 | BOOLEAN | Does this student participate in at least one credit recovery program? |
REFERREDLAWENFORCEMENT | 24.11.1.0 | BOOLEAN | Instances of Referrals to Law Enforcement |
LEPQUALIFIEDSNAPSHOT | 24.11.1.0 | BOOLEAN | Is this a student who is an English Learner (EL) as of snapshot date? |
COMPSCISCHOOLID | 24.11.1.0 | VARCHAR2 (15) | School id where student has enrolled in a Computer Science course? |
ENROLLEDAPOTHER | 24.11.1.0 | BOOLEAN | Has the student enrolled in an Advance Placement (Other) course? |
LEPQUALIFIED | 24.11.1.0 | BOOLEAN | Is this a student who is an English Learner (EL)? |
ENROLLEDGEOMETRY | 24.11.1.0 | BOOLEAN | Has the student enrolled in a Geometry course? |
RETAINEDINGRADE12 | 24.11.1.0 | BOOLEAN | Is the student retained in Grade 12? |
RETAINEDINGRADE11 | 24.11.1.0 | BOOLEAN | Is the student retained in Grade 11? |
ALGEBRAISCHOOLID | 24.11.1.0 | VARCHAR2 (15) | School id where student has enrolled in an Algebra I course? |
RETAINEDINGRADE10 | 24.11.1.0 | BOOLEAN | Is the student retained in Grade 10? |
SCHOOLNAME | 24.11.1.0 | VARCHAR2 (100) | Student School Name |
IDEASNAPSHOT | 24.11.1.0 | BOOLEAN | Is this a student with one or more disabilities served under IDEA as of snapshot date? |
RESTRAINTPHYSICAL | 24.11.1.0 | BOOLEAN | Physical restraint Indicator |
ENROLLEDAPCOMPSCI | 24.11.1.0 | BOOLEAN | Has the student enrolled in an Advance Placement Computer Science course? |
STUDENTNUMBER | 24.11.1.0 | FLOAT () | Student Number |
CORPORALPUNISHMENT | 24.11.1.0 | NUMERIC | Corporal Punishment Indicator |
HARASSEDRACECOLORNATL | 24.11.1.0 | BOOLEAN | Harassed or Bullied - Race, Color, or National Origin |
SECLUSION | 24.11.1.0 | BOOLEAN | Seclusion restraint Indicator |
SERVEDINLEA | 24.11.1.0 | NUMERIC | Is the student school a Non-LEA facility? |
IDEA | 24.11.1.0 | BOOLEAN | Is this a student with one or more disabilities served under IDEA? |
SECTION504SNAPSHOT | 24.11.1.0 | BOOLEAN | Is this a student with disabilities served under Section 504, but not served under IDEA as of snapshot date? |
APCOMPSCISCHOOLID | 24.11.1.0 | VARCHAR2 (15) | School id where student has enrolled in an Advance Placement Computer Science course? |
STUDENTDCID | 24.11.1.0 | NUMERIC | Student DCID |
GRADELEVEL | 24.11.1.0 | NUMERIC | Student Grade Level |
ENROLLEDCALCULUS | 24.11.1.0 | BOOLEAN | Has the student enrolled in a Calculus course? |
ENROLLEDADVMATH | 24.11.1.0 | BOOLEAN | Has the student enrolled in an Advance Math course? |
RETAINEDINGRADEKG | 24.11.1.0 | BOOLEAN | Is the student retained in Kindergarten? |
HARASSEDSEX | 24.11.1.0 | BOOLEAN | Harassed or Bullied - Sex |
STUDENTID | 24.11.1.0 | NUMERIC | Student ID |