Absences from a resource (type, date range, time, and approval status); approved absences are deducted from capacity
Data model
Fields
| Field | Type | Description |
|---|---|---|
| absence_hours* | DECIMAL | Total Hours of Absence |
| absence_id* | UNIQUEIDENTIFIER | Unique absence identifier |
| absence_type* | VARCHAR (50) | Type of absence (vacation, disability, leave, training, other) |
| approval_status* | VARCHAR (30) | Pending, Approved, Rejected Status |
| end_date* | DATE | End of absence date |
| is_active* | BIT | Logical Deletion: 1 = Active Record, 0 = Retired |
| resource_id* | UNIQUEIDENTIFIER | Resource to which absence belongs |
| start_date* | DATE | Absence Start Date |
Primary Key
| PK_APMO_ABSENCE |
|---|
| absence_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| resource_id* | dbo.APMO_RESOURCE | resource_id | FK01_APMO_ABSENCE |