S_CA_STU_ELA_C (ver 16.8.0)
This table is a child table of the [Students] table.
To ensure all ELA records are kept in synch between this S_CA_STU_ELA_C table and the Students table (or the S_CA_STU_X table for customers who have migrated) the application checks for changes to this table, including changes from an import, at intervals of 120 seconds and then updates the Students table accordingly. Note: Only 1000 records are updated per interval; therefore, when running a large import, several minutes will pass before all Students table values are updated.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 16.8.0 | Number(10,0) | Primary key. |
StudentsDCID | 16.8.0 | Number(10,0) | DCID of student to whom this ELA Status record belongs. |
ELACorrectionReason | 18.11.0 | Varchar2(1) | ELPAC field to track ELA status correction reason. |
ELAStatus | 16.8.0 | Varchar2(4) | English Language Acquisition status code. Corresponds to legacy [Students]CA_ELAStatus field. |
ELAStatusEndDate | 16.8.0 | Date | Last day on which student remained at this status. Should be null if still active. |
ELAStatusStartDate | 16.8.0 | Date | First day on which student attained this status. Corresponds to legacy [Students]CA_DateELAStatus field. |
ExcludeFromStateReporting | 16.8.0 | Number(1,0) | Flag to allow or prevent this record from being included in state reports. |
PrimaryLanguage | 16.8.0 | Varchar2(2) | CALPADS Primary Language code. Corresponds to legacy [Students]CA_PrimaryLanguage field. |
| StatusComment | 17.2.0 | Varchar2(500) | Allows user to record any additional information pertaining to the status record. |