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

    • v_trade

      Purpose Shift trade records. Relationships v_personnel: Many-to-One (N:1) Many trades requested by one personnel Referenced through user_id v_personnel: Many-to-One (N:1) Many trades accepted by one personnel Referenced through accepting_user_id ...

    • v_event

      Purpose Event records and tracking. Relationships v_event_participant: One-to-Many (1:N) One event can have many participants Referenced through event_id v_event_payroll_summary: One-to-Many (1:N) One event can have many payroll entries Referenced ...

    • v_invoice

      Purpose Invoice records. Relationships v_invoice_line_item: One-to-Many (1:N) One invoice can have many line items Referenced through invoice_id v_invoice_payment: One-to-Many (1:N) One invoice can have many payments Referenced through invoice_id ...

    • v_equipment

      Purpose Equipment inventory and tracking. Relationships v_work_order: One-to-Many (1:N) One equipment item can have many work orders Referenced through equipment_id v_asset_inspection_completed: One-to-Many (1:N) One equipment item can have many ...

    • v_personnel

      Purpose Personnel information and assignments. Relationships v_fire_dept_user: One-to-One (1:1) One personnel links to one user account Referenced through id/personnel_id f_all_schedule: One-to-Many (1:N) One personnel can have many schedules ...