S_TX_STU_SR_OEYP_C (ver 16.12.3)
This table is a child of the Students table and is used for storing Optional Extended Year data that was migrated from the SRUSER Student OEYP table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| E0017_GRADE_LEVEL | 16.12.3 | VARCHAR2(15) | Indicates the grade level of the student at the time they received OEYP services. |
| E0036_DAYS_ABSENT | 16.12.3 | NUMBER(11,0) | Indicate the number of days absent during for the OEYP record. |
| E0782_CAMPUS_OF_ENROLLMENT | 16.12.3 | VARCHAR2(50) | Indicates the campus the student was enrolled during the OEYP services. |
| E0935_DAYS_TAUGHT | 16.12.3 | NUMBER(11,0) | Indicates the number of days taught for the OEYP record. |
| E0937_DAYS_PRESENT | 16.12.3 | NUMBER(11,0) | Indicates the number of days present for the OEYP record. |
| E1014_OEYP_TYPE_CODE | 16.12.3 | VARCHAR2(15) | Indicate the type of OEYP services the student receivied. |
| E1029_PROMOTION_RETENTION | 16.12.3 | VARCHAR2(15) | Indicates the student's promotion/retention code based on services received. |
| ID | 16.12.3 | NUMBER(10,0) | Primary key. |
| OEYP_SCHOOL_YEAR | 16.12.3 | VARCHAR2(50) | The yearid for the year the services were received. |
| RECORD_ID | 16.12.3 | NUMBER(11,0) | The record id from the sruser table. |
| STUDENTSDCID | 16.12.3 | NUMBER(10,0) | The foreign key to link to the student table. |