S_CRDC_CTRL_S (ver 24.11.1.0)
This table is a standalone table to store data entry control 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. |
CTRL_OFFALLEG_RAPE_RESP | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Offenses - Allegations Against School Staff (Determined Responsible) |
CTRL_RS_IDEA_MECH | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for IDEA Students Subjected to Restraint or Seclusion - Mechanical Restraint |
CTRL_FTESERVICES | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Support Services Staff Number FTE |
CTRL_CALCULUSSCHOOLID | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Calculus School Id |
CTRL_TEACHERS_CURR | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Current Year Teachers Count |
CTRL_OFFALLEG_RAPE_DUTY | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Offenses - Allegations Against School Staff (Duty Reassignment) |
CTRL_FTETEACH | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Teachers – FTE Count and Certification |
CTRL_DISCWODIS_EXPZT | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Discipline of Students without Disabilities - Expulsions Under Zero-Tolerance Policies |
CTRL_DISCWDIS_EXPZT_IDEA | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Discipline of Students with Disabilities - Expulsions Under Zero-Tolerance Policies |
CTRL_SCHOOLNUMBER | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for School Number |
CTRL_REFINSTANCES | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Instances of Referrals to Law Enforcement |
CTRL_DISCWDIS_ISS_IDEA | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Discipline of Students with Disabilities - One or More In-School Suspension |
CTRL_HBALLEGATIONS_GEN | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Allegations of Harassment or Bullying – Gender Identity |
CTRL_RS_NONIDEA_SECL | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Non-IDEA Students Subjected to Restraint or Seclusion - Seclusion |
CTRL_SECBLOCKSCHEDULEDCLASS | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Section Block Scheduled Classes |
CTRL_RS_IDEA_PHYS | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for IDEA Students Subjected to Restraint or Seclusion - Physical Restraint |
CTRL_DISCWDIS_MULTOOS_IDEA | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Discipline of Students with Disabilities - More than One Out-of-School Suspension |
CTRL_APCOMPSCISCHOOLID | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for AP Computer Science School Id |
CTRL_SPORTS_TEAMS_PART | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Interscholastic Athletics Sports and Teams |
CTRL_DISCWDIS_CORP_IDEA | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Discipline of Students with Disabilities - Corporal Punishment |
CTRL_OFF_RAPE_BATT_BYSTAF | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Offenses – Rape and Sexual Assault committed by a staff |
CTRL_DISCWODIS_REF | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Students without Disabilities – Referred to Law Enforcement |
CTRL_DISCWODIS_MULTOOS | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Discipline of Students without Disabilities - More than One Out-of-School Suspension |
CTRL_DISCWDIS_ARR_IDEA | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Students with Disabilities – School-Related Arrest |
CTRL_OOSINST | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Instances of Out-of-School Suspension |
CTRL_HBDISCIPLINED_SEX | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Students Disciplined for Harassment or Bullying - Sex |
CTRL_RS_IDEA_SECL | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for IDEA Students Subjected to Restraint or Seclusion - Seclusion |
CTRL_DISCWODIS_ISS | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Discipline of Students without Disabilities – One or More In-School Suspensions |
CTRL_DATASCISCHOOLID | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Computer Science School Id |
CTRL_PSOOSINST_WODIS_504 | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Instances of Preschool Suspension – Children Without Disabilities and With Disabilities |
CTRL_DISCWDIS_REF_IDEA | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Students with Disabilities – Referred to Law Enforcement |
CTRL_ARRINSTANCES | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Instances of School-Related Arrests |
CTRL_HBREPORTED_SEX | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Students Reported as Harassed or Bullied - Sex |
CTRL_APMATHSCHOOLID | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Data Science School Id |
CTRL_RS_NONIDEA_MECH | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Non-IDEA Students Subjected to Restraint or Seclusion - Mechanical Restraint |
CTRL_ALGEBRAIISCHOOLID | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Algebra II School Id |
CTRL_HBREPORTED_DIS | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Students Reported as Harassed or Bullied - Disability |
CTRL_SECLASTDAY | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Section Last Day |
CTRL_OFFENSE | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Offenses - Number of Incidents |
CTRL_RSINST | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Instances of Restraint or Seclusion |
CTRL_RS_NONIDEA_PHYS | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Non-IDEA Students Subjected to Restraint or Seclusion - Physical Restraint |
CTRL_ADVMATHSCHOOLID | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Advance Math School Id |
CTRL_PSCORPINST_WWODIS | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Instances of Preschool Corporal Punishment – Children Without Disabilities and With Disabilities |
CTRL_HBDISCIPLINED_DIS | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Students Disciplined for Harassment or Bullying - Disability |
CTRL_DISCWODIS_ARR | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Students without Disabilities – School-Related Arrest |
CTRL_DISCWODIS_SINGOOS | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Discipline of Students without Disabilities – Only One Out-of-School Suspension |
CTRL_DISCWDIS_EXPWOE_IDEA | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Discipline of Students with Disabilities - Expulsions without Educational Services |
CTRL_FIREARM_IND | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Offenses - Shooting |
CTRL_CORPINST_WWODIS | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Instances of Corporal Punishment – Students Without Disabilities and With Disabilities ( |
CTRL_DAYSMISSED | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for School Days Missed Due to Out-of-School Suspension |
CTRL_TEACHERS_PREV_TOT | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Teacher Retention Count |
CTRL_DISCWDIS_TFRALT_IDEA | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Discipline of Students with Disabilities – Transfer to Alternative School |
CTRL_OFF_RAPE_BATT_BYSTUD | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Offenses – Rape and Sexual Assault committed by a student |
CTRL_HOMICIDE_IND | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Offenses - Homicide |
CTRL_FTESECURITY | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Security Staff |
CTRL_OFFALLEG_RAPE_DTNR | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Offenses - Allegations Against School Staff (Determined Not Responsible) |
CTRL_FTETEACH_CERTSPEC | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Teacher Certification in Specialized Areas |
CTRL_APSCIENCESCHOOLID | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for AP Science School Id |
CTRL_PSCORP_IND | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Preschool Corporal Punishment Indicator |
CTRL_SECDCID | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Section DCID |
CTRL_CRSDISTANCELEARNING | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Distance Learning Course |
CTRL_DISCWODIS_EXPWE | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Discipline of Students without Disabilities - Expulsions with Educational Services |
CTRL_DISCWODIS_EXPWOE | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Discipline of Students without Disabilities - Expulsions without Educational Services |
CTRL_SECTERMID | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Section Term ID |
CTRL_ATHLETICS_IND | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Interscholastic Athletics Indicator |
CTRL_PSDISC_MULTOOS | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Preschool Suspension – More than One Out-of-School Suspension |
CTRL_STUDENTSCOUNT | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Students Count |
CTRL_CRSDUALENROLLMENT | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Dual Enrollment Course |
CTRL_OFF_RAPE_BATT | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Offenses – Rape and Sexual Assault occurred at school |
CTRL_FTETEACH_FY_SY | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Teacher Years of Experience |
CTRL_PSDISC_CORP | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Preschool Corporal Punishment |
CTRL_SATACT | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Student Participation in the SAT Reasoning Test or ACT |
CTRL_APSCHOOLID | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Advance Placement School Id |
CTRL_DISCWODIS_CORP | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Discipline of Students without Disabilities - Corporal Punishment |
CTRL_SECDUALENROLLMENT | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Dual Enrollment Section |
CTRL_DISCWDIS_SINGOOS_IDEA | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Discipline of Students with Disabilities - Only One Out-of-School Suspension |
CTRL_BIOLOGYSCHOOLID | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Biology School Id |
CTRL_DISCWDIS_EXPWE_IDEA | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Discipline of Students with Disabilities - Expulsions with Educational Services |
CTRL_CORP_IND | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Corporal Punishment Indicator |
CTRL_OFFALLEG_RAPE_PEND | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Offenses - Allegations Against School Staff (Determination Pending) |
CTRL_SHOOTING_DEATHHOMICIDE | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Offenses – Shooting and Homicide Incidents |
CTRL_PHYSICSSCHOOLID | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Physics School Id |
CTRL_ALGEBRAISCHOOLID | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Algebra I School Id |
CTRL_FTECOUNSELORS | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for School Counselors Number FTE |
CTRL_HBALLEGATIONS | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Allegations of Harassment or Bullying |
CTRL_SECDISTANCELEARNING | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Distance Learning Section |
CTRL_PSDISC_SINGOOS | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Preschool Suspension – Only One Out-of-School Suspension |
CTRL_OFFALLEG_RAPE_RNRT | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Offenses - Allegations Against School Staff (Resignation or Retirement) |
CTRL_COMPSCISCHOOLID | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Computer Science School Id |
CTRL_PARTICIPANTS | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Interscholastic Athletics Participants |
CTRL_SECFIRSTDAY | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Section First Day |
CTRL_CHEMISTRYSCHOOLID | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Chemistry School Id |
CTRL_GEOSCHOOLID | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Geometry School Id |
CTRL_CRSDCID | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Course DCID |
CTRL_PSOOSINST_ALL_IDEA | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Instances of Preschool Suspension |
CTRL_PSDISC_EXP | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Preschool Expulsion |
CTRL_HBREPORTED_RAC | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Students Reported as Harassed or Bullied - Race, Color, or National Origin |
CTRL_PSCORPINST | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Instances of Preschool Corporal Punishment |
CTRL_DISCWODIS_TFRALT | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Discipline of Students without Disabilities – Transfer to Alternative School |
CTRL_HBALLEGATIONS_REL | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Allegations of Harassment or Bullying - By Religion Type |
CTRL_HBDISCIPLINED_RAC | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Students Disciplined for Harassment or Bullying - Race, Color, or National Origin |
CTRL_FTETEACH_ABSENT | 24.11.1.0 | VARCHAR2 (1) | Data Entry Control for Teacher Absenteeism |