S_TX_STU_STATE_GEN_C (ver 20.7.2)
This table is a child of the Students table and is used for general PEIMS data.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 16.7.0 | Number(10,0) | Primary key. |
| StudentsDCID | 16.7.0 | Number(10,0) | Foreign key. |
| E0787_ADA_Code | 16.7.0 | Varchar2(1) | ADA Eligibility Code. |
| E0903_Campus_Residence | 16.7.0 | Varchar2(9) | Campus ID of Residence. |
| E1000_Attribution_Code | 16.7.0 | Varchar2(2) | Student Attribution Code. |
| E1002_As_Of_Override | 16.7.0 | Varchar2(1) | As of Status Override. |
| E1027_Campus_Accountability | 16.7.0 | Varchar2(9) | Campus ID of Accountability. |
| E1045_Flexible_Prog_Type | 20.7.2.0 | Varchar2(2) | Flexible Attendance Program Type. |
| E1054_Crisis_Code | 16.7.0 | Varchar2(2) | Student Crisis Code. |
| E1076_Unschooled_Asylee | 16.7.0 | Varchar2(1) | Unschooled-Asylee/Refugee Code. |
| E1082_Homeless | 16.7.0 | Varchar2(1) | Homeless Status. |
| E1084_Unaccompanied_Youth | 16.7.0 | Varchar2(1) | Unaccompanied Youth Status Code. |
| E1528_Foster_Care | 16.7.0 | Varchar2(1) | Foster Care Indicator. |
| E1529_Military_Connected | 16.7.0 | Varchar2(1) | Military connected Indicator. |
| E1530_Dyslexia | 16.7.0 | Number(1,0) | Dyslexia Indicator. |
| E1559_TSTEM | 16.7.0 | Number(1,0) | T-STEM Indicator for Submission 1 and 3. |
| E1559_TSTEM_Sub4 | 16.7.0 | Number(1,0) | T-STEM Indicator for Submission 4. |
| E1560_ECHS | 16.7.0 | Number(1,0) | Early College High School Indicator for Submission 1 and 3. |
| E1560_ECHS_Sub4 | 16.7.0 | Number(1,0) | Early College High School Indicator for Submission 4. |
| E1601_Star_Of_Texas | 18.6.0 | Varchar2(1) | An indicator that the student is eligible for free public pre-kindergarten. |
| E1612_PTECH | 18.6.0 | Varchar2(1) | P-TECH Indicator for Submission 1 and 3. |
| E1612_PTECH_Sub4 | 18.6.0 | Varchar2(1) | P-TECH Indicator for Submission 4. |
| Enter_Date | 16.7.0 | Date | Start Date for this status. |
| Exit_Date | 16.7.0 | Date | Exit Date for this status. |
| State_Gen_Comments | 16.7.0 | Varchar2(4000) | Comments for any audit change. |