Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Workday Pay slips Table

Completed
Stephanie Smith User

The data coming through in the Payroll table is very limited. I'd like it to either be expanded to include pay deductions like taxes, healthcare, 401k, etc. or have a linked table that includes all of this data. One record for each deduction would be fine, with more information about the deduction, as long as it links back to the payroll record.

The goal is to be able to have a complete view of each pay slip, for every employee, every pay period.

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Amanda Wong User

    Hi Stephanie,

    I've investigated the Workday HCM connector and found a table that might solve your request - the payroll_line_pay_component table.

    This table is designed to hold detailed pay component data with deduction and earning columns. When I checked our test data, I found deduction types like:

    • Taxes: W_FUI, W_MEDER, W_MED, W_OASER, W_CASDI (various payroll taxes)

    • Healthcare: MED-ERA, DEN-ERA, FSA-H, VSP-ER (medical, dental, vision, FSA)

    • 401k: 401K (employee), 401K-ER (employer)

    • Other benefits: STD-ER, LTD-ER, LIFE-EE (disability, life insurance)

    Since Workday configurations can vary by company, would you be able to:

    1. Check if the table is enabled: Go to your Workday HCM connector → Schema tab → search for payroll_line_pay_component and enable it if not already checked

    2. Query your data: Once synced, run a quick query to see what deduction types appear in your data.

    Please let me know if these deduction types match what you're looking for. Or are you looking for something else?

    The table structure provides one row per deduction/earning component (linked to payroll_line), which matches your request for "one record per deduction that links back to the payroll record."

    Happy to help investigate further if this doesn't match your needs.

    Thanks,
    Tom