S_TX_STU_ATT_BASIC_C (Version 23.11.2)
This table is a child of the Students table and holds the Ed-Fi BasicReportingPeriodAttendance records for the six week reporting periods.
Column Name | Version | Data Type | Description |
---|---|---|---|
ID | 23.11.2 | Number(10,0) | Primary key |
StudentsDCID | 23.11.2 | Number(11,0) | Foreign Key |
SCHOOLID | 23.11.2 | VarChar2(9) | Reportable School ID |
STU_UID | 23.11.2 | Number(11,0) | Student Unique ID |
YEARID | 24.2.1 | Number(11,0) | The year for the record, such as 33 for the 2023-24 school year. |
E0975_CALENDAR_CODE | 23.11.2 | VarChar2(2) | Calendar Code (Student Track) |
E0934_RPT_PERIOD | 23.11.2 | VarChar2(2) | Reporting Period |
E0017_GRADE_LEVEL | 23.11.2 | VarChar2(2) | Grade Level |
E0935_DAYS_TAUGHT | 23.11.2 | Number(11,0) | Number of Days Taught |
E0036_DAYS_ABS | 23.11.2 | Number(25,10) | Total Days Absent |
E0936_INELIG_DAYS_PRES | 23.11.2 | Number(25,10) | Total Ineligible Days Present |
E0937_ELIG_DAYS_PRES | 23.11.2 | Number(25,10) | Total Eligible Days Present |
E1678_RS_DAYS_PRES | 23.11.2 | Number(25,10) | RS Total Eligible Days Present |
E1679_RA_DAYS_PRES | 23.11.2 | Number(25,10) | RA Total Eligible Days Present |
MARK_FOR_DELETE | 24.3.1 | Number(1,0) | Record is marked for delete |