S_TX_STU_ESY_C (ver 16.7.0)
This table is a child of the Students table and is used for collecting Extended Services Year data.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| E0017_GRADE_LEVEL | 16.7.0 | VARCHAR2(2) | The grade level the student was at the time the services were rendered. |
| E0173_INSTR_SETTING1 | 16.7.0 | VARCHAR2(2) | The primary instructional setting for the student. |
| E0173_INSTR_SETTING2 | 16.7.0 | VARCHAR2(2) | Used for speech if the student received more than speech services. |
| E0782_CAMPUS_ID | 16.7.0 | VARCHAR2(9) | The campus the student was enrolled for the services. |
| E1013_CONTACT_HOURS1 | 21.8.1 | Number(25,10) | The number of contact hours received for the first instructional setting. Modified to support one decimal place in version 21.8.1. |
| E1013_CONTACT_HOURS2 | 21.8.1 | Number(25,10) | The number of contact hours received for the second instructional setting if applicable. Modified to support one decimal place in version 21.8.1. |
| ID | 16.7.0 | NUMBER(10,0) | Primary key. |
| STUDENTSDCID | 16.7.0 | NUMBER(10,0) | Foreign key. |
| YEARID | 16.7.0 | NUMBER(11,0) | The year for this record data. |