v_time_off

v_time_off

Purpose

  1. Personnel time off records.

Relationships

  • v_personnel: Many-to-One (N:1)

    • Many time off records link to one personnel

    • Referenced through user_id

  • v_personnel: Many-to-One (N:1)

    • Many time off records approved by one personnel

    • Referenced through approving_user_id



Table



Column

Type

Description

id

integer

Primary key

user_id

integer

User reference

client_code

varchar(28)

Organization ID

public_name

varchar(255)

Personnel name

first_name

varchar(64)

First name

last_name

varchar(64)

Last name

time_off_type_name

varchar(50)

Time off type

time_off_type_shortcode

varchar(12)

Type code

time_off_date

date

Off date

start_at_local

timestamp

Start time

end_at_local

timestamp

End time

duration_hours

numeric(5,2)

Duration

is_trade

boolean

Trade flag

is_kelly_day

boolean

Kelly day flag

is_approved

boolean

Approval status

status_code

varchar(20)

Status code

approving_user_id

integer

Approver reference

responded_at

timestamp

Response time





    • Related Articles

    • Unit Turnout Time Compliance

      Purpose To explain the functionality and features of the Unit Turnout Time Compliance Report. Video Instructions 1. Find the Unit Turnout Time Compliance report under Reports -> Incidents. 2. The headline displays the percentage of responses per ...

    • Time Off: Resubmitting Time Off

      Purpose Statement This feature allows personnel to resubmit a request for time off directly through the First Due Platform. Users can resubmit time-off requests that integrate with the department's scheduling system, enabling supervisors to review ...

    • EMS Setup - Default Time Setup

      Purpose Statement The purpose of this article is to explain how to configure the Default Time Setup within the EMS Setup section of the Incident Documentation module. This setting allows agencies to streamline documentation by pre-selecting which ...

    • Managing Time Off Requests

      Purpose To explain how to manage Time Off requests within the Time Off sub-module. You can Approve, Deny, Edit and Delete time off requests. You can also manage from a list or calendar view. Video Directions 1. Click on Scheduling > Time Off. 2. ...

    • Time Clock Settings

      Purpose Statement The Time Clock Settings in the Scheduling Module enable departments to track personnel work hours accurately, automate clock-out processes, and receive notifications for scheduling discrepancies. This feature ensures compliance with ...