S_AL_STU_STATE_ChildCount_X (ver 20.8.2.0)
This is an extension of the Students table and is used for reporting Special Programs data to the state ODS.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| Age | 20.8.2.0 | Number(11,0) | Age |
| AnRevDueDate | 20.8.2.0 | Date | Annual Review Due By |
| ApprovalDate | 20.8.2.0 | Date | Approval Date |
| Birthdate | 20.8.2.0 | Date | Student Date of Birth |
| CaseManager | 20.8.2.0 | Varchar2(100) | Case Manager |
| CountDate | 20.8.2.0 | Date | Child Count Date |
| CurrentIEPEndDate | 20.8.2.0 | Date | IEP To Date |
| CurrentIEPStartDate | 20.8.2.0 | Date | IEP From Date |
| District | 20.8.2.0 | Varchar2(100) | District Name |
| DistrictID | 20.8.2.0 | Varchar2(15) | District number |
| EligMeetDueDate | 20.8.2.0 | Date | Next Eligibility Meeting Due By |
| EnrollmentEndDate | 20.8.2.0 | Date | Enrollment End Date |
| EnrollmentStartDate | 20.8.2.0 | Date | Enrollment Start Date |
| Exceptionality | 20.8.2.0 | Varchar2(100) | Exceptionality |
| FirstName | 20.8.2.0 | Varchar2(30) | Student First Name |
| Gender | 20.8.2.0 | Varchar2(50) | Gender |
| Generation | 20.8.2.0 | Varchar2(10) | Generation |
| Grade | 20.8.2.0 | Varchar2(20) | Grade |
| IEPBy3rdBthday | 20.8.2.0 | Varchar2(3) | IEP in Place on 3rd Birthday |
| IEPSignDate | 20.8.2.0 | Date | IEP Signature |
| IntIEPDate | 20.8.2.0 | Date | Date of Initial IEP Meeting |
| IS_ELL | 20.8.2.0 | Varchar2(5) | EL check box |
| IsGifted | 20.8.2.0 | Varchar2(3) | Gifted check box |
| LastName | 20.8.2.0 | Varchar2(30) | Student Last Name |
| LRECode | 20.8.2.0 | Varchar2(100) | LRE Code |
| MiddleName | 20.8.2.0 | Varchar2(30) | Student Middle Name |
| MostRecEligDate | 20.8.2.0 | Date | Date of Most Recent Eligibility Determination |
| PreServBegDate | 20.8.2.0 | Date | Preschool Services Begin Date (3-5 yrs.) |
| Race_A | 20.8.2.0 | Varchar2(3) | Race - Asian |
| Race_B | 20.8.2.0 | Varchar2(3) | Race - Black or African American |
| Race_H | 20.8.2.0 | Varchar2(3) | Race - Hispanic or Latino |
| Race_I | 20.8.2.0 | Varchar2(3) | Race - American Indian or Alaskan Native |
| Race_M | 20.8.2.0 | Varchar2(3) | Race - Two or More Races |
| Race_P | 20.8.2.0 | Varchar2(3) | Race - Native Hawaiian or Pacific Islander |
| Race_W | 20.8.2.0 | Varchar2(3) | Race - White |
| ReferralDate | 20.8.2.0 | Date | Referral Date |
| School | 20.8.2.0 | Varchar2(100) | School Name |
| SchoolID | 20.8.2.0 | Varchar2(15) | School Code |
| SchoolYear | 20.8.2.0 | Varchar2(10) | School Year |
| SnapShotApprovalDate | 20.8.2.0 | Date | SnapShot Approval Date |
| SnapshotDate | 20.8.2.0 | Date | Snap Shot Date |
| StateID | 20.8.2.0 | Varchar2(50) | State ID |
| Status | 20.8.2.0 | Varchar2(10) | Status |