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

    • Setting Up Trade Disclaimers

      Purpose To explain how to set up Trade Disclaimers. The trade disclaimers allow users to acknowledge and accept the terms of a trade. Trade disclaimers are completely adjustable, giving you the ability to tailor them to your department. Video ...

    • Trade Settings

      Purpose To explain the Trade Settings located in the Scheduling Module. Video Directions 1. Click on Scheduling> Setup. 2. Click on Time Off Settings. 3. Click on Trade Settings. 4. Determine how the request will be routed: Let the user select who ...

    • Requesting a Shift Trade

      Purpose To explain how to request a trade in the Scheduling Module. Video Directions 1. Click on Scheduling > Shift Trades. 2. The next months worth of dates will appear. You can change the date range by clicking Start Date and End Date in the upper ...