S_AL_STU_STC_X ver 19.12.1.0
This table is an extension of the Students' table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| StudentSDCID | 19.12.1.0 | Number(19,0) | The primary key that relates the extended table back to the Students' table. |
| EndDate | 19.12.1.0 | Date | The student's End Date at the Special Treatment Center. |
| Special Treatment Center | 19.12.1.0 | Number(11,0) | The Special Treatment Center name. |
| StartDate | 19.12.1.0 | Date | The student's Start Date at the Special Treatment Center. |
| PLACEMENTREASON | 20.3.2.0 | Number(11,0) | The Placement Reason of the student at the Special Treatment Center. |
| ASSIGNEDBY | 20.3.2.0 | Varchar2(50) | The Assigned By name. |
| CASENO | 20.3.2.0 | Varchar2(25) | The Case Number. |
| AGENTNAME | 20.3.2.0 | Varchar2(50) | The Judge/Agent name. |
| RETURNDATE | 20.3.2.0 | Date | The Return Date of the student at the Special Treatment Center. |
| RETURNREASON | 20.3.2.0 | Number(11,0) | The Return Reason of the student at the Special Treatment Center. |
| DESTINATIONDISTRICT | 21.9.1.0 | Varchar2(31) | The Destination District Number |