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 ...
    • EMS Setup - Default Time Setup

      Purpose The purpose of this article is to explain the Default Time Setup found in the EMS Setup. Video Directions 1. Navigate to Incident Documentation and select on EMS Setup. 2. From the EMS Setup select on the General section. 3. Scroll down to ...
    • 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. ...
    • Events and Activities: Adjusting Time Granularity

      Purpose To explain how to adjust the Time Granularity settings. Video Directions 1. Click on Events & Activities 2. Click on Setup 3. Click on General 4. Click on Time granularity and select desired time frame.
    • Setting up Time Off Types

      Purpose To explain how to create Time Off Types in the Scheduling Module. Video Directions 1. Click on Scheduling > Setup. 2. Click on Time Off Types. 3. Click on Add Time Off Type. 4. Type in a time off type name and Shortcode (short name). ...