EN
Español
English
Português
    APMO_ABSENCE

    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