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

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

    • Personnel Setup - Pay Grades

      Purpose Statement Pay Grades in First Due allow fire departments and EMS agencies to standardize hourly rates for personnel across different documentation areas. This feature ensures consistent compensation tracking when documenting incidents, ...

    • v_incident_report_payroll_summary

      Purpose Incident-related payroll records. Relationships v_incident_report: Many-to-One (N:1) Many payroll records link to one incident Referenced through incident_report_id v_personnel: Many-to-One (N:1) Many payroll records link to one personnel ...