This release introduces the Core HR to Viewpoint Vista integration via Trimble’s AppXChange platform, enabling automated transfer of employee workforce data from Core HR into Vista’s Payroll module.
The integration extracts employee-related data from Core HR, transforms it into Vista-compatible CSV files, packages the files into a structured ZIP archive, and delivers them to AppXChange for downstream processing into Vista.
This release establishes a standardized, automated data flow that reduces manual payroll setup in Vista while maintaining Core HR as the authoritative system of record for employee data.
Core Problem
Prior to this integration, employee configuration within Vista often required manual data entry or repetitive updates when employee records changed in Core HR. This introduced risk of:
- Data inconsistency between systems
- Duplicate maintenance effort
- Payroll processing delays
- Configuration errors within Vista
Without an automated sync, payroll administrators were required to manage employee demographic, tax, direct deposit, and benefit-related configuration across both platforms. This release addresses that gap by introducing a structured, scheduled integration that standardizes data movement and enforces Vista-compatible formatting and validation rules.
User Impact
This enhancement applies to users implementing the version of the Core HR to Vista integration leveraging AppXChange.
For impacted users:
- Employee data will flow from Core HR into Vista via AppXChange.
- Core HR will serve as the authoritative system for all in-scope employee configuration entities.
- Updates made in Core HR will overwrite corresponding data in Vista during subsequent syncs.
- No reverse sync from Vista to Core HR is supported.
users not implementing this version of the Vista integration are unaffected.
This integration supports incremental adoption and configurable scope controls to ensure alignment with each user’s payroll configuration requirements.
Feature Details
Integration Architecture
The integration performs the following high-level steps:
- Extracts employee-related data from Core HR
- Writes data to Vista:
- Generates object-specific CSV files
- Packages files into a ZIP using the existing naming convention
- Moves files to Arcoro’s SFTP server
- Delivers files to AppXChange for downstream processing
- Triggers appropriate Vista actions (Add, Change, Remove) based on employee state
Jobs within AppXChange retrieve files from SFTP and process updates approximately every fifteen minutes to maintain consistent system alignment.
Data Objects Included
The following employee-related objects are supported in this release:
Employee (Core Demographics & Employment)
- Company (PRCo)
- Employee Identifier (PREmp)
- Name fields
- SSN
- Hire, Termination, and Rehire dates
- Department (PRDept)
- Pay Group
- Workers Comp Code
- Work State / Unemployment State
- I9 status transformation logic
Movement Types:
- Employees Add V2
- Employees Change V2
Address
- Address1 / Address2
- City
- State
- Zip
- Country
Movement Types:
- Employees Add V2
- Employees Change V2
Includes truncation logic where Vista field limits are exceeded.
Compensation
- EarnCode
- Hourly Rate
- Salary Amount
Movement Types:
- Employees Add V2
- Employees Change V2
Includes regex-based decimal validation aligned with Vista constraints.
Benefits / Deductions & Liabilities
- DLCode
- Frequency
- Override Calculation
- Deduction Cost
Movement Types:
- Deductions and Liabilities Add V2
- Deductions and Liabilities Change V2
Direct Deposit
- Routing Number
- Account Number
- Account Type (Checking/Savings)
- Deposit Method
- Percent or Amount
- Sequence/Priority
Movement Types:
- Additional Direct Deposit Add V2
- Additional Direct Deposit Change V2
- Additional Direct Deposit Remove V2
Federal Taxes
- Filing Status
- Allowances
- Additional Withholding
- Two Jobs Flag
- Dependents Amount
- Exempt Flag
Movement Types:
- Deductions and Liabilities Add V2
- Deductions and Liabilities Change V2
State Taxes
- Filing Status
- Allowances
- Override Percent
- Override Amount
- Additional Withholding
Movement Types:
- Deductions and Liabilities Add V2
- Deductions and Liabilities Change V2
Source of Truth
Core HR remains the authoritative system of record for all employee-related objects included in this integration.
Vista receives and consumes employee configuration data. Changes made directly in Vista to in-scope objects may be overwritten during subsequent syncs.
System Roles:
- Core HR = Authoritative Employee System
- AppXChange = Transformation, Transportation, and Execution Layer
- Viewpoint Vista = Consuming Payroll System
Scheduling & Scope Controls
Syncs may be manually triggered. Scheduled jobs within AppXChange process files approximately every fifteen minutes. Syncs can be filtered by:
- Employee ID list
- Last updated date (incremental sync support)
Scope toggles allow selective inclusion of employee related domains/scopes.
Logging & Notifications
The integration platform generates three message levels:
- Info (non-critical confirmations)
- Warning (review recommended)
- Error (processing halted; correction required)
File results are accessible through sync output and include the ZIP file containing generated CSVs for validation and troubleshooting.
Email notifications are automatically sent for both successful updates and error conditions within Vista processing.
What Will Not Be Available
The following items are not included in this release:
- Payroll calculation logic
- Benefit calculation logic
- Reverse data sync from Vista to Core HR
- Vista payroll processing configuration