S_TX_STU_SCHOOL_ENR_C (Version 23.8.2)
This table is a child of the Students table and holds student enrollment records for Ed-Fi reporting, which combine dates and data elements from the Students, ReEnrollments and PEIMS General tables.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 23.8.2 | Number(10,0) | Primary key |
StudentsDCID | 23.8.2 | Number(11,0) | Foreign key |
ADA_ELIGIBILITY | 23.8.2 | Varchar2(1) | Student ADA Eligibility Code |
CAMPUS_ACCOUNTABILITY | 23.11.2 | Varchar2(9) | Campus ID of Accountability |
CAMPUS_RESIDENCE | 23.11.2 | Varchar2(9) | Campus ID of Residence |
ENTRYDATE | 23.8.2 | Date | Enrollment Entry Date |
ENTRYCODE | 23.8.2 | Varchar2(10) | Enrollment Entry Code |
EXITDATE | 23.8.2 | Date | Enrollment Exit Date |
EXITCODE | 23.8.2 | Varchar2(10) | Enrollment Exit Code |
GRADELEVEL | 23.8.2 | Integer | Student Grade Level |
SCHOOLID | 23.8.2 | Integer | PowerSchool School Number |
STUDENT_ATTRIBUTION | 23.8.2 | Varchar2(2) | Student Attribution Code |
TRACK | 23.8.2 | Varchar2(20) | Student Track |