resource_absences_v1
'Resource absences' refers to the periods when a resource, such as an employee, is unavailable due to vacation, sick leave, or other approved time off. It helps organisations manage workforce planning and scheduling to maintain productivity and ensure adequate coverage.
| Column | Data type | Description |
|---|---|---|
| id | NUMBER(38,0) | A unique identifier assigned to each resource absence record. |
| resource_name | VARCHAR(100) | The name of the resource (e.g., employee) associated with the absence. |
| start_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of resource absence start. |
| end_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of resource absence end. |
| type | VARCHAR(100) | The type of the resource absence as configured by the user in Administration panel. |
| reason | VARCHAR(200) | The absence reason that is inputted as free text. |
| status | VARCHAR(50) | Indicates current status of the absence. Possible values: 'Requested', 'Queried', 'Rejected', 'Approved'. |
| status_comment | VARCHAR(1000) | Additional comments or notes related to the status of the absence, inputted as free text. |
| status_updated_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the status of the absence was last updated. |
| status_triggered_by | VARCHAR(100) | The name of the person who triggered absence status update. |
| is_paid | VARCHAR(3) | Indicates whether the absence is paid or unpaid. Possible values: 'Yes', 'No'. |
| number_of_days_requested | NUMBER(3,1) | The total number of days requested for the absence, inputted as a number between -99 and 99. |
| _resource_id | NUMBER(38,0) | The identifier linking the resource absence to the corresponding resource record. |
| _last_sync_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the resource absence record was last refreshed. |