S_GA_STU_PK_X (ver 16.5.0)
This table is an extension of the [Students] table. These fields are specific to Early Care and Learning reporting.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StudentsDCID | 16.5.0 | Number(10,0) | Primary key that relates the extended table back to the Students table. |
| BirthOrder | 16.5.0 | Varchar2(2) | Indicates the student's birth indicator (1=single, 2=twin, 3=triplet,etc...). |
DualLanguage | 16.5.0 | Number(1,0) | Indicates the student is a dual language learner. |
| IEP | 16.5.0 | Number(1,0) | Indicates the student has an IEP. This field is separate from Students.All_IEP field. |
| PANDAClassId | 16.5.0 | Varchar2(5) | Indicates the PANDA Class ID associated with this student. |
| ProgramCode | 16.10.1 | Varchar2(2) | Indicates the student's pre-kindergarten program association. Migrated from Students.GA_PreK_Code. |
| SocioEcIndicator | 16.5.0 | Varchar2(1) | Indicates the student's socio-economic indicator. |
| Transported | 16.5.0 | Number(1,0) | Indicates transportation will be provided. |
| WaiverReasonCode | 16.5.0 | Varchar2(2) | Indicates the code as to why the Pre-K student has a blank SSN. |
| WaiverReasonDetail | 16.5.0 | Varchar2(1000) | Details why the student has a blank SSN. Required when Waiver Reason Code is 5. |