S_OH_STU_Truancy_Shared_C ver 18.10.0
This table is a child table of the [Students] table.
Column Name | Version | Data Type | Description |
---|---|---|---|
Primary Key | 18.10.0 | Number(10) | System generated number. |
ForeignKey | 18.10.0 | Number(11) | Student's DCID related to the record. |
Date_Absent | 18.10.0 | Date | Date of absence for the record. |
District_IRN | 18.10.0 | Number(6) | A six-digit IRN associated with the district providing the information. |
Excluded_Chronic_Flag | 19.11.1.0 | Varchar(1) | A true value (1) denotes the absence is excluded from HB410 Chronic calculations. A false value (0) denotes the absence is not excluded from HB410 Chronic Calculations. |
Excluded_flag | 18.10.0 | VarChar(1) | A true value (1) denotes the absence is excluded from HB410 Truancy calculations. A false value (0) denotes the absence is not excluded from HB410 Truancy Calculations. |
Excused_flag | 18.10.0 | VarChar(1) | A true value (1) denotes the absence is excused. A false value (0) denotes the absence is unexcused. |
Hours_absent | 18.10.0 | Number(10,2) | The length of time for the absence expressed in hours:minutes. |
ImportID | 19.1.0 | Number | Used by the Absence Import for HB410 Truancy/Chronic-OH functionality to identify a set of records and remove the records, if necessary. |