v_incident_report_payroll_summary

v_incident_report_payroll_summary

Purpose

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

    • 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(10,2)

Points earned

stipend

numeric(10,2)

Stipend amount

pay_rate

numeric(10,2)

Pay rate

activity_type_id

integer

Activity type

incident_report_id

integer

Incident reference





    • Related Articles

    • Incidents, Training and Events Payroll Report

      Purpose To demonstrate the features and navigation of the Incidents, Training and Events Payroll Report. Related Articles There is set up involed in each of the three modules payrol and Poits can be tracked. Please follow the steps in the related ...
    • Scheduling Module - Payroll Summary Report

      Purpose To explain the Payroll Summary Report for the Scheduling module. How is this report helpful? This report can be used for organizations that provide payroll summaries for input into payroll systems. This report will give you a summary of hours ...
    • Points Report

      Purpose To demonstrate the features and navigation of the Points Report. Related Articles There is set up involed in each of the three modules payrol and Poits can be tracked. Please follow the steps in the related articles below to set up the areas ...
    • Scheduling Module - Response Payroll Report

      Purpose To explain the Response Payroll Report for the Scheduling module. How is this report helpful? This report is helpful for departments that use a pay per call system. Instructions Navigate to Reports > Scheduling Reports. Select the Response ...
    • 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 ...