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

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

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

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

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

    • Accepting or Denying Trade Requests (End User)

      Purpose To explain how to manage requests for shift trades. Users can request you work for them on specific dates and in turn you have to accept the trade request or deny it. If you accept, you then gain hours that then can be used for when you want ...