Source data

The available set of fields to export is referred to as the source data set. The source data set is comprised of two database views that consist of these tables:

  • EMPLOYEE_HISTORY
  • WORK_DETAIL
  • WORK_SUMMARY
  • WORK_DETAIL_ADJUST

The standard Payroll Export Interface engine has an API that also lets you pull in data from these default labor tables:

  • CALC_GROUP
  • DEPARTMENT
  • DOCKET
  • HOUR_TYPE
  • JOB
  • PAY_GROUP
  • PROJECT
  • SHIFT
  • TIME_CODE

This API (Code Mapper) lets you reference any field in these tables as though they are a part of the source data view. This server code piece resolves the record ID from the two views into the actual field that is required. For a list of all the fields in the source data views, see the VIEW_PAYEXP_CURRENT and VIEW_PAYEXP_ADJUSTMENT field descriptions in Payroll Export Interface references.