StateSupportData, 21 (ver3.6.1)
Holds information needed for transaction based state reports.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
ModificationDate | 3.6.1 | Date | The date the record was created. |
ModificationTime | 3.6.1 | Time | The time the record was created |
Statesupportdata_Data | 3.6.1 | BLOB | The data for the transaction. For SAIS this is the Absent Date, Value and reason code. |
Statesupportdata_Type | 3.6.1 | Number(10,0) | Type of data that is being stored. Currently has a value of 1 for SAIS. |
StudentID | 3.6.1 | Number(10,0) | The internal number and ID of the associated Students record. |
Unused1 | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |