S_AL_STU_TransitionVerific_X (ver 20.8.2.0)
This is an extension of the Students table and is used for reporting Special Programs data to the state ODS.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| Age | 20.8.2.0 | Number(11,0) | Age |
| ApprovalDate | 20.8.2.0 | Date | SnapShot Approval date |
| BirthDate | 20.8.2.0 | Date | Student Date of Birth |
| CourOfStudy | 20.8.2.0 | Varchar2(3) | Student in a middle school course of study |
| District | 20.8.2.0 | Varchar2(100) | District Name |
| DistrictID | 20.8.2.0 | Varchar2(15) | District number |
| EndDate | 20.8.2.0 | Date | Report end date |
| FirstName | 20.8.2.0 | Varchar2(50) | Student First Name |
| Generation | 20.8.2.0 | Varchar2(10) | Generation |
| LastName | 20.8.2.0 | Varchar2(50) | Student Last Name |
| MiddleName | 20.8.2.0 | Varchar2(50) | Student Middle Name |
| OthAgen | 20.8.2.0 | Varchar2(3) | Other Agency Invited with prior Consent |
| ProgCred | 20.8.2.0 | Varchar2(3) | Program Credits to be Earned |
| School | 20.8.2.0 | Varchar2(100) | School Name |
| SchoolID | 20.8.2.0 | Varchar2(15) | School Code |
| StartDate | 20.8.2.0 | Date | Report start date |
| StateID | 20.8.2.0 | Varchar2(30) | State ID |
| StudentNumber | 20.8.2.0 | Varchar2(20) | Student Number |
| StuInv | 20.8.2.0 | Varchar2(3) | Student Invited |
| TransAsses | 20.8.2.0 | Varchar2(3) | Transition Assessment |
| TransGoals | 20.8.2.0 | Varchar2(3) | Goals for Postsecondary Transition |
| TransServ | 20.8.2.0 | Varchar2(3) | Transition Services |
| TransVerf | 20.8.2.0 | Varchar2(3) | Verification Summary |