Overview
HRlogics UCM helps staffing companies track, handle, and fight unemployment claims, allowing their team to focus their time, money, and resources not on employees of yesterday – but on the team they have today and the one they are building for tomorrow.
HRlogics UCM and Avionte partnered to create an integration that was built to increase efficiencies and decrease manual effort by automatically syncing employee, assignment, message, and payroll data between Avionte and HRlogics UCM.
Integration Details
Employee File
Assignment File
Placement Notes File – BOLD Only
Message File
Payroll File
Data Mapping
Employee Export Field Mapping
Assignment Export Field Mapping
Placement Note Export Field Mapping
Message Export Field Mapping
Payroll Export Field Mapping
Integration Details
Employee File
- The first file sent to HRlogics UCM will contain all employee records
- Subsequent files will only include new employee and updated employee records
- File is being sent every Tuesday at 10:00 pm CT
Assignment File
- The first file sent to HRlogics UCM will contain all assignment records
- Subsequent files will only include new assignment and updated assignment records
- File is being sent every Tuesday at 10:00 pm CT
Placement Notes File – BOLD Only
- The file sent to HRlogics UCM will contain:
- Placement Notes for newly created placements where the notes field is not NULL
- Placement Notes that have been updated
- File is being sent every Tuesday at 10:00 pm CT
Message File
- The first file sent to HRlogics UCM will contain message records linked to employees and assignments that were created within the last 3 months
- Subsequent files will only include new message and updated message records linked to employees and assignments
- File is being sent every Tuesday at 10:00 pm CT
Payroll File
- The first file sent to HRlogics UCM will contain paycheck records with a check date within the last 18 months
- Subsequent files will only include paycheck records that were processed for the previous account period where the accounting period is closed
- If the accounting period isn’t closed by the time the payroll file is generated, the paycheck records will get picked up on the next file
- File is being sent every Tuesday at 10:00 pm CT
Data Mapping
Employee Export Field Mapping
| Data | Avionte Field | Notes |
| Employee ID | Employee > EmployeeID | EmployeeID from Classic |
| Employee First Name | Employee > First Name | |
| Employee Last Name | Employee > Last Name | |
| Employee SSN | Employee > SSN | |
| Employee Branch | Employee > Branch | |
| Employee Status | Employee > Status |
Assignment Export Field Mapping
| Data | Avionte Field | Notes |
| Assignment ID | Assignment > AssignmentID | AssignmentID from Classic |
| Employee ID | Employee > EmployeeID | EmployeeID from Classic |
| Assignment Job Title | Assignment > Job Title | |
| Assignment Start Date | Assignment > Start Date | |
| Assignment End Date | Assignment > End Date | |
| Assignment End Reason | Assignment > End Reason | |
| Assignment Performance Code | Assignment > Performance | |
| Assignment Entered By Username | Assignment > User > Entered By | |
| Assignment Customer Name | Assignment > Customer | |
| Assignment Branch | Assignment > Branch | |
| Assignment Department Name | Assignment > Department | |
| Customer Branch | Customer > Branch Name | |
| Placement ID | PlacementID from BOLD |
Placement Note Export Field Mapping
| Data | Avionte Field | Notes |
| PlacementID | req_hired_id from BOLD db | |
| PerformanceNote | Hired Details > Notes |
Message Export Field Mapping
| Data | Avionte Field | Notes |
| Message ID | StaffingActionFKGUID from Classic db | |
| Action Type | Message > Action Type | |
| Subject | Message > Subject | |
| Message | Message > Message | |
| Created Date | Message > Date | |
| Entered By User | Message > User | |
| Customer Name | Customer > Customer Name | Customer associated to the assignment the message is linked to |
| EmployeeID | Employee > EmployeeID | Employee the message is linked to |
| AssignmentID | Assignment > AssignmentID | Assignment the message is linked to |
Payroll Export Field Mapping
| Data | Avionte Field | Notes |
| Employee ID | Employee > EmployeeID | Employee that the paycheck is associate with |
| Check Date | Employee > Pay History > Check Date | |
| Check Number | Employee > Pay History > Check Number | |
| Supplier | Employee > Pay History > Supplier | |
| PayTotalHours | Employee > Pay History > Transaction > PayUnit | |
| Gross Wages | Employee > Pay History > Gross Pay | |
| Net Pay | Employee > Pay History > Net Amount | |
| Week Start Date | Calculated value – 6 days prior to the Week End Date | |
| Week End Date | Employee > Pay History > Week End Date |
Comments
0 commentsPlease sign in to leave a comment.