v_trade

v_trade

Purpose

  1. 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_personnel: Many-to-One (N:1)

    • Many trades approved by one personnel

    • Referenced through approved_by



Table



Column

Type

Description

id

integer

Primary key

client_code

varchar(28)

Organization ID

user_id

integer

User reference

public_name

varchar(255)

Personnel name

first_name

varchar(64)

First name

last_name

varchar(64)

Last name

request_date

date

Request date

start_at_local

timestamp

Start time

end_at_local

timestamp

End time

duration_hours

numeric(5,2)

Duration

status_code

varchar(30)

Status code

recipient_type_code

varchar(10)

Recipient type

created_at

timestamp

Creation time

created_by

integer

Creator reference

approved_by

integer

Approver reference

is_approval_required

boolean

Approval needed

accepting_user_id

integer

Acceptor reference

responded_at

timestamp

Response time




    • Related Articles

    • v_trade_certification

      Purpose Training certification records. Relationships v_training_certification_user: One-to-Many (1:N) One certification type can have many user certifications Referenced through training_certification_id v_personnel: Many-to-One (N:1) Many ...

    • v_time_off

      Purpose 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 ...

    • Trade Settings

      Purpose Statement The Trade Settings feature enables administrators to establish policies and workflows for shift trades within their department. This configuration determines how personnel request shift trades, who approves them, what work types ...

    • Setting Up Trade Disclaimers

      Purpose Statement The Trade Request Disclaimer feature allows administrators to configure and display a custom disclaimer message that users must acknowledge before submitting or accepting shift trade requests. This ensures that all personnel ...

    • Requesting a Shift Trade

      Purpose Statement The Shift Trade Request feature enables fire and EMS personnel to exchange scheduled shifts with qualified colleagues through a structured, trackable approval process. This feature streamlines shift swaps while maintaining proper ...