v_payroll_summary

v_payroll_summary

Purpose

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



Table



Column

Type

Description

id

integer

Primary key

client_code

varchar(28)

Organization ID

public_name

varchar(255)

Personnel name

user_id

integer

User reference

time_in

timestamp

Start time

time_out

timestamp

End time

total_time

numeric

Duration

points

numeric

Points earned

stipend

numeric

Stipend amount

pay_rate

numeric

Pay rate

activity_type_id

integer

Activity type

record

varchar

Record type

orig_report_group_code

text

Group code




    • Related Articles

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

    • v_event

      Purpose Event records and tracking. Relationships v_event_participant: One-to-Many (1:N) One event can have many participants Referenced through event_id v_event_payroll_summary: One-to-Many (1:N) One event can have many payroll entries Referenced ...

    • NERIS Documentation - Payroll Summary

      Purpose The purpose of this article is to demonstrate the Payroll Summary section when completing a fire report. Video Directions 1. Navigate to the Payroll Summary section within the fire report. 2. To begin documenting personnel select on the +Add ...

    • Enabling Payroll Summary

      Enabling the Payroll Summary Grid Purpose Statement The payroll summary grid enables fire departments to track personnel compensation associated with incident responses, including pay, stipends, or points for personnel involved in incidents or ...