NOTICE: You are in the old ClientSpace Help system. Please link to the new ClientSpace Help here https://extranet.clientspace.net/helpdoc/home/ClientSpace.htm

Payroll Batch information

You can import payroll batch data into ClientSpace for reporting. The imported data resides in the following dataforms:

  • Payroll Batch (gen_PayrollBatch)

  • Billing Voucher (gen_BillingVoucher)

Payroll Batch dataform

All the fields on the Payroll Batch dataform are read-only and are filled using a PrismHR API Import. By default, the form is secured with View rights for all users in the PEO Employees role.

The Payroll Processor field is set using a business rule that finds the Client Team form associated with the workspace and copies the Payroll Processor field information from the Client Team form into the Payroll Processor field on the Payroll Batch form. The business rule is triggered when records are inserted either through a normal dataform save or from an import.

The Payroll Batch dataform is a parent to the Billing Voucher dataform. The Payroll Batch dataform has the following fields.

Label

FieldName

Datatype

Label

FieldName

Datatype

Pay Date

DatePaid

date

Payroll Number

PayrollNumber

text

Batch Type

luBatchType

lookup

Pay Group

PayGroup

text

Period Start Date

DatePeriodStart

date

Period End Date

DatePeriodEnd

date

Employee Count

EmployeeCount

integer

Total Hours

TotalHours

integer

Payroll Processor

fkPayrollProcessorID

use

Billing Voucher dataform

Billing Voucher records break out the individual line item billing code entries associated with a payroll batch. A link is available to the Payroll Batch dataform to display the associated voucher records. The Billing Voucher dataform is a child to the Payroll Batch dataform.

The Billing Voucher dataform has the following fields.

Label

FieldName

Datatype

Label

FieldName

Datatype

Billing Amount

BillingAmount

integer

Billing Code

luBillingCode

lookup

Cost Amount

Cost Amount

integer

Batch Status

This is a placeholder for the Batch Status modified attribute in the Event object. The field should remain empty.

text

NOTICE: You are in the old ClientSpace Help system. Please link to the new ClientSpace Help here https://extranet.clientspace.net/helpdoc/home/ClientSpace.htm