S_TX_STU_CHARTER_WAITLIST_C (ver 20.7.2.0)
This table is a child of the Students table and stores data for the TSDS Charter School Waitlist Collection.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 20.7.2.0 | Number(10,0) | Primary key. |
| StudentsDCID | 20.7.2.0 | Number(10,0) | The foreign key to link to the student table. |
| Exclude_Waitlist | 20.7.2.0 | Number(1,0) | Indicates that the student and record should be excluded from the charter school waitlist. This field is initially provided as a placeholder and may not be needed pending clarification of the TEA reporting requirements. |
| Waitlist_Campus_ID | 20.7.2.0 | Varchar2(9) | The nine-digit CDC number of the charter school campus whose waitlist the student is on as of the last Friday in September. |
| Waitlist_Comment | 20.7.2.0 | Varchar2(250) | Optional, local use field for comments pertaining to the record. |
| Waitlist_Effective_Date | 20.7.2.0 | Date | The effective date for the student's charter waitlist status. |