Summary

We request the addition of the payroll-deductions-history endpoint to Fivetran's existing UKG (Ultipro) connector to enable comprehensive employee benefits and compensation analysis.

Business Use Case

Our organization is working to analyze employee compensation data to understand employee financial health and evaluate the effectiveness of our benefits programs. This analysis is critical for:

• Benefits Cost Analysis: Calculate average cost of benefits per employee
• Plan Utilization Metrics: Identify which benefit plans have higher utilization rates
• Retirement Strategy Evaluation: Analyze employee retirement contribution patterns
• Strategic Planning: Enable leadership to make data-driven decisions on future benefit initiatives
• Employee Health Assessment: Combine deduction data with other employee metrics for comprehensive wellness evaluation

Current Gap

While Fivetran's UKG connector provides employee pay data, it's missing the crucial deduction component that would complete our compensation analysis capabilities. Interestingly, this information is already available for international employees in the connector, suggesting the infrastructure exists but domestic employee deduction data was overlooked during implementation.

Technical Details

Endpoint Information

• Endpoint: /payroll/v1/payroll-deductions-history
• Method: GET
• Documentation: UKG Developer Portal - Payroll Deductions History

Sample API Call

curl --location 'https://service4.ultipro.com/payroll/v1/payroll-deductions-history' \
     --header 'US-Customer-Api-Key: <US-Customer-Api-Key>' \
     --header 'Content-Type: application/json' \
     --header 'Authorization: Basic <encoded 64 user:pass123>'

Authentication

The endpoint uses the same authentication pattern as existing UKG connector endpoints:

• US Customer API Key
• Basic Authentication (base64 encoded user:password)

Implementation Considerations

• The endpoint follows the same authentication and request patterns as existing UKG connector endpoints
• Data structure should be consistent with other payroll-related tables in the connector
• Consider implementing similar refresh patterns and incremental sync capabilities as other payroll endpoints

Expected Data Value

This endpoint would provide essential deduction details including:

• Employee benefit deductions (health, dental, vision insurance)
• Retirement plan contributions (401k, pension)
• Voluntary deductions (life insurance, FSA, HSA)
• Tax withholdings and other mandatory deductions
• Historical trend data for longitudinal analysis

Priority Justification

• High Business Impact: Critical for strategic benefits planning and employee wellness initiatives
• Low Technical Complexity: Leverages existing connector infrastructure and authentication
• Data Completeness: Fills a significant gap in our current UKG data pipeline
• Consistency: Aligns with international employee data already available in the connector

Requested Timeline

We would appreciate an estimated timeline for implementation, as this data is needed for our upcoming annual benefits planning cycle.