TransformTemp (ver9.0.0)
This table is used as the temporary storage location to handle large amounts of data during export using the Attendance page and the Incident List page. The Attendance page is accessible via Start Page > Attendance. The Incident List page is accessible via Start Page > Special Functions > Incident Management.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ID | 9.0.0 | Number(19,0) | Unique sequential number generated by the application. Required. Indexed. |
TransformGroup | 9.0.0 | Number(19,0) | Uniquely identifies an extract using a system generated UID at the time the extract request is submitted. Required. |
TransformPart | 9.0.0 | CLOB | Contains the result set and the intermediate data of the request. Required. |
UserSession | 9.0.0 | Number(19,0) | Identifies the application session. Required. |
WhenCreated | 9.0.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |