Open topic with navigation
Datasets for Web Query
For ad-hoc web query reporting, two different sets of
datasets exist: one is the Dataset Web Query and the other is the Ad-Hoc
Web Query.
The Payroll role can access the Dataset Web Query, and the
Payroll & HR role and Payroll & HR Enterprise role often can access
both web queries.
Different sets of dataset items are available through different
parts of the application and to different web roles.
Another set of dataset items is defined for use with the
online notification templates.
Dataset Web Query
Where available, the Dataset
web query enables a query by standard datasets including payroll earnings,
deductions, net pays, taxes, or employee master files.
- Employee
Deductions Detail. This
dataset shows deduction information from Employee Deduction Detail records.
- Current
YTD Earnings. The
current, year-to-date earnings.
- Employee
Benefit Hour Earnings. This
dataset shows earnings for plans that accrue hours, such as PTO or Vacation.
- Prior
YTD Earnings. The
year-to-date earnings for the prior year.
- Employee
Benefit Detail. Information
from Employee Benefit Detail records.
- Employee
NetPay Detail. Information
from Employee Net Pay Detail records.
- Employee
Tax Detail. Information
from Employee Tax Detail records.
- Employee
Master File. Information
from Employee Master records.
- YTD
Deduction Summary. The
year-to-date deduction summary by deduction code. Per employee information
is excluded.
- YTD
Earnings Summary. The
year-to-date earnings summary by earning code. Per employee information
is excluded.
- YTD
Net Pay Summary. The
year-to-date net pay summary by net pay code. Per employee information
is excluded.
- YTD
Tax Summary. The
year-to-date tax summary by tax code. Per employee information is excluded.
Ad-Hoc Query
Where available, the Ad-Hoc
web query enables a query by an expanded list of system tables.
- ARC_BENEFITS.
Benefit
information from posted payrolls.
- ARC_DEDUCTIONS.
System
payroll history archive table containing deduction information from posted
payrolls.
- ARC_EARNINGS.
System
payroll history archive table containing earning information from posted
payrolls.
- ARC_NACHA.
Payroll
history archive table for NACHA records.
- ARC_NETPAY.
Payroll
history archive table for net payment records.
- ARC_PAYMASTER.
System
payroll history archive table per payroll with employee information including
tier assignments and default labor distributions.
- ARC_PAYMENTS.
System
payroll history archive table including detailed payment information per
employee.
- ARC_PAYROLLDISTR.
System
payroll history archive table including paid labor distributions per payroll
calendar.
- ARC_REPORT940.
System
payroll history archive table for the 940 tax type.
- ARC_REPORT941.
System
payroll history archive table for the 941 tax type.
- ARC_TAXES.
System
payroll history archive table containing tax information from posted payrolls.
- ARC_TAXVNDPAYMENT.
System
payroll history archive table.
- ARC_TIME.
System
payroll history archive table containing pay entry information for posted
payrolls.
- ARC_WARNINGS.
System
payroll history archive table showing pay run messages/warnings.
- PAY_ANNUALTAXFORM.
W-2 and
Form 1099-MISC information based on the latest year-end tax processing.
- PAY_DEDUCTIONS.
Employee
deduction details.
- PAY_EARNINGS.
Employee earning details.
- PAY_PAYRATES.
Employee
pay rate details.
- PAY_SUBMITPAYRUN.
Payroll posting and reset processing dates and times and the date that
a payroll was processed. All payroll dates (scheduled pay run dates) display
as 12:00:00. Comments are listed as 0 or 100.
- PAY_TAXES.
Employee
tax detail information.
- PER_ASSETS.
Employee
asset information details.
- PER_ASSIGNMENT.
Employee
assignment tab information.
- PER_ATTENDANCE.
Employee
attendance detail information.
- PER_AUTOPAYS.
Employee
auto pay details.
- PER_BENEFITS.
Employee
benefit details.
- PER_COMPENSATION.
Employee
compensation tab information.
- PER_CONTACTS.
Employee
contact details.
- PER_DEMOGRAPHICS.
Employee
demographics tab information.
- PER_EDUCATION.
Employee
education code information.
- PER_EMPLOYMENT.
Employee
employment tab information.
- PER_EMPLOYMENTHISTORY.
Employee
employment history information.
- PER_I9
DATA. Employee
I-9 data information.
- PER_MASTER.
Employee
Master tab information.
- PER_OFFICIALDOCS.
Employee
official documents information.
- PER_ORGANIZATION.
Employee
organization tab information.
- PER_OUTOFOFFICE.
Employee
out-of-office detail information.
- PER_PENDTRX.
Pending
transactions.
- PER_EMPLOYMENTHISTORY.
Employee
employment history details.
- PER_SALARY.
Employee
salary detail information.
- PER_TERMINATION.
Employee
termination detail information.
- PER_TK_ATTENDANCE.
Employee
attendance tab information.
- UTL_ANNOUNCEMENTS.
Announcement
table information.
- UTL_ATTACHMENTS.
Attachment
information.
- UTL_INVOICES.
Payroll
invoice information.
- VAL_ACH.
Bank account
codes table information.
- VAL_APPROVALPOLICY.
- VAL_ASSETCODES.
Asset validation
table information.
- VAL_ATTENDANCE_CODES.
Attendance
validation table information.
- VAL_ATTENDANCE_TYPE.
Attendance
type validation table information.
- VAL_BANKCODES.
Bank codes
shows Bank Account information.
- VAL_BENEFITS.
Benefits
validation table information.
- VAL_CHECKCODES.
Check code
validation table information.
- VAL_COMPETENCY.
Competency
code validation table information.
- VAL_CONTACTCODES.
Contact
code validation table information.
- VAL_COVERAGECODE.
Coverage
code validation table information.
- VAL_DEDUCTIONS.
Deductions
code validation table information.
- VAL_DEGREECODES.
Degree
code validation table information.
- VAL_EARNINGS.
Earnings
code validation table information.
- VAL_GLACCOUNTS.
General
ledger account code validation table information.
- VAL_HOLIDAYCODES.
Holiday
code validation table information.
- VAL_INVOICEITEMS.
Invoice
item code validation table information.
- VAL_JOBCODES.
Job code
validation table information.
- VAL_JOBGROUPING.
Job grouping
code validation table information.
- VAL_LABORSEG1CODES.
Labor segment
1 code validation table information.
- VAL_LABORSEG2CODES.
Labor segment
2 code validation table information.
- VAL_LABORSEG3CODES.
Labor segment
3 code validation table information.
- VAL_LABORSEG4CODES.
Labor segment
4 code validation table information.
- VAL_NETPAYS.
Net pay
code validation table information.
- VAL_PAYCALENDAR.
Payroll
calendar code validation table information.
- VAL_PAYCD_TO_EARNINGCD.
Map pay
codes to earnings codes table for time import mapping.
- VAL_PAYGROUP.
Pay group
code validation table information.
- VAL_POSITIONCODES.
Shift codes.
- VAL_SALARYGRADES.
Salary
Grade codes.
- VAL_SHIFTCODES.
Shift codes.
- VAL_SUPERVISORCODES.
Supervisor
codes.
- VAL_TK_DEPARTMENTS.
Department
codes.
- VAL_TK_LOCATIONS.
Location
codes.
- VAL_TIER3.
Tier 3
codes.
- VAL_TIER4.
Tier 4
codes.
- VAL_VENDORS.
Vendor
codes.
- WRK_ACCUMBYCHECK.
Accumulated
amounts by payroll accumulator for un-posted payrolls that are in gross-to-net.
- WRK_DEDUCTIONS.
Gross-to-net
work table for deduction amounts for un-posted payrolls.
- WRK_EARNINGS.
Gross-to-net
work table for earning amounts for un-posted payrolls.
- WRK_GENLEDGER.
Work table
to report on general ledger.
- WRK_NETPAY.
Gross-to-net
work table for net pay. Shows payments and voids and includes net pay
information for un-posted payrolls that are in gross-to-net.
- WRK_PAYMASTER.
Gross-to-net
work table. Shows payments and voids for un-posted payrolls that are in
gross-to-net.