v_personnel_pay_rate

v_personnel_pay_rate

Purpose

  1. Personnel pay rate history.

Relationships

  • v_personnel: Many-to-One (N:1)

    • Many pay rates link to one personnel

    • Referenced through personnel_id

  • v_fire_dept_user: Many-to-One (N:1)

    • Many pay rates link to one user

    • Referenced through user_id



Table



Column

Type

Description

id

integer

Primary key

first_name

varchar(64)

First name

last_name

varchar(64)

Last name

start_date

date

Effective start

end_date

date

Effective end

pay_rate

numeric(7,4)

Pay rate amount

personnel_id

integer

Personnel reference

user_id

integer

User reference

is_latest

boolean

Current rate flag

client_code

varchar(28)

Organization ID




    • Related Articles

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

    • Personnel Setup - Pay Grades

      Purpose To explain how to setup Pay Grades within the Personnel Module. Pay grades are used within: Incident Documentation Activities Training Pay grades are not used for anything Scheduling related. Video Directions 1. Click on Personnel > Setup. 2. ...

    • Scheduling Pay Rates

      Purpose To explain how to update a user's scheduling pay rate. This pay rate assists with Ad-Hoc Report exports in regards to the Scheduling Module. Video Directions 1. Navigate to Personnel > Personnel List. 2. Next, choose the individual whose ...

    • v_event_payroll_summary

      Purpose Event-related payroll records. Relationships v_event: Many-to-One (N:1) Many payroll records link to one event Referenced through event_id v_personnel: Many-to-One (N:1) Many payroll records link to one personnel Referenced through user_id ...

    • v_payroll_summary

      Purpose Payroll summary records. Relationships v_personnel: Many-to-One (N:1) Many payroll records link to one personnel Referenced through user_id activity_type: Many-to-One (N:1) Many payroll records link to one activity type Referenced through ...