Our Core HR and Viewpoint Vista AppXChange 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 integration keeps Arcoro's Core HR as the system of record for managing employees and syncs employee data between Arcoro and Vista using Vista’s Import Utility, compared to the previous Core HR and Vista integration.
Source of Truth
Core HR is 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.
Roles of respective modules/systems:
- Core HR = Authoritative Employee System
- AppXChange = Transformation, Transportation, and Execution Layer
- Viewpoint Vista = Consuming Payroll System
Data That Syncs
The following employee-related objects are currently supported:
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
Logging & Notifications
Reviewing Sync Status
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.
Reviewing Sync Status in AppXChange
- Navigate to Flows.
- Select Arcoro - Core HR Employees to Viewpoint Vista Employees.
- Open the Runs tab. This view provides detailed insight into each execution, including any errors encountered during processing.
- Successful flow runs confirm that data has been accurately transmitted to Vista without issue. Any failed runs are recorded as failures and should be reviewed as soon as possible.
- You can click into a failed run to review why it did not complete successfully, allowed targeted troubleshooting and resolution.
Email Notifications
Email notifications like the one below will be automatically sent for both successful updates and error conditions within Vista processing. Opening the attached text file will provide additional information on successes and what caused a failure, if any.