v_event_payroll_summary

v_event_payroll_summary

Purpose

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




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

Points earned

stipend

numeric(9,2)

Stipend amount

pay_rate

numeric(9,2)

Pay rate

activity_type_id

integer

Activity type

event_id

integer

Event reference




    • Related Articles

    • Activities: Payroll Summary Tab

      Purpose To explain the features and demonstrate how to edit or delete the Payroll Summary tab within Activities module. Related Articles Methods to Create New Event within Activities Activities: Creating New Event / Event Tab Activities: Creating New ...
    • Activities: Payroll Summary Tab

      Purpose To explain the features and demonstrate how to edit or delete the Payroll Summary tab within Activities module. Related Articles Methods to Create New Event within Activities Activities: Creating New Event / Event Tab Activities: Creating New ...
    • Events & Activities: Enabling Payroll Summary

      Purpose To demonstrate on how to enable the Payroll Summary within the Events & Activities module. Related Articles Adding Personnel to the Payroll Summary within Activities Updating Personnel in Payroll Summary within Activities Personnel Setup ...
    • Updating Personnel in Payroll Summary within Activities

      Purpose To demonstrate how to update Payroll Summary for personnel within the Activities module. Related Articles Adding Personnel in Payroll Summary within Activities Enabling Payroll Summary within Activities Video Directions 1. Navigate to the ...
    • Adding Personnel to the Payroll Summary within Activities

      Purpose To explain how to add personnel to an existing event for Payroll Summary within the Activities module. Related Articles Updating Personnel in Payroll Summary within Activities Enabling Payroll Summary within Activities Video Directions 1. ...