Selerix (formerly SyncStream) helps businesses of all sizes stay compliant with the Affordable Care Act (ACA). From tracking employee hours to generating reports, our user-friendly platform and team of experts makes ACA compliance easy and hassle-free. The Selerix integration automates file transmission, eliminating the need for manual SFTP uploads.
Key Takeaways
- Selerix Streamlines Compliance: The Selerix platform offers businesses a comprehensive solution to ensure compliance with the Affordable Care Act (ACA). From tracking employee hours to generating reports, it simplifies the ACA compliance process, making it user-friendly and efficient.
- Automated File Transmission: The Selerix integration automates the file export and transmission process. While export mapping still requires manual configuration, files are automatically transmitted to Selerix on a scheduled basis, eliminating the need for manual SFTP uploads.
- Integration Details for Data Export: The article provides detailed information on how businesses can export employee census and payroll data to Selerix. It outlines the parameters, file formats, and export logic for both types of data, ensuring a smooth data transfer process.
- File Validation Ensures Data Accuracy: Selerix integration includes robust file validation checks to ensure the data exported meets the required format and standards. If any issues are detected, error files are generated with guidance on how to address them, ensuring data accuracy and compliance.
CHAPTERS
- Integration Details
- Export Mapping
- Employee Mapping
- Employee Census Export Mappings
- Payroll Export Mappings
Integration Details
Automated Employee Census Export
- Automated Export run schedule:
- Tuesday evenings
- Saturday evenings
- Automated Export Logic:
- Export pulls employee data for employees with hours worked within the accounting period dates for the supplier. Separate files for each supplier will be sent.
- Export also pulls employee records if their Terminated Date was entered within the date range parameter values even if the employee doesn't have transaction data for that period.
- File Format: csv
- File Name Example: <CompanyCode>_<SupplierCode>_EmployeeCensus_<CurrentDateandTime>.csv
Automated Payroll Export
- Automated Export run schedule:
- Tuesday evenings
- Saturday evenings
- Automated Export Logic
- Export pulls employee, assignment, and transaction data for employees with hours worked within the accounting period dates for the supplier. Separate files for each supplier will be sent.
- Export also pulls employee records if their Terminated Date was entered within the date range parameter values even if the employee doesn't have transactions for that period.
- File Format: csv
- File Name Example: <CompanyCode>_<SupplierCode>_Payroll_<CurrentDateandTime>.csv
Export Mapping
Customers using Selerix for their ACA management services, must complete the required export mapping in Admin Tools.
- Navigate the Start Page and open Admin Tools
- Click on Import Export Mapping
- Click on the Mapping Type Data tab
-
Filter in the Group Description filter field for "SyncStream Export"
Employee Status Mapping
For each of the available Avionte employee statuses listed in the Source System Value column, select a Selerix status to map them to in the Mapped Value column. The mapped Selerix status is what is passed in the files to Selerix.
The available Selerix employee statuses are:
- Active
- Inactive
- Terminated
- FMLA
- IFMLA
Data Requirement Message (DRM) Warning: If employee statuses are not mapped, you will receive a warning: "Selerix Integration: There are unmapped Employee Status which will cause incorrect reporting. Please map them in Admin Tools > Import/Export/Mapping > SyncStream Export."
Default Behavior: If mappings are not configured and the DRM warning is dismissed or turned off, the system will default to passing "Active" as the employee status in files sent to Selerix.
Rate of Pay Type Mapping
For each of the available Avionte staffing suppliers listed in the Source System Value column, select a Rate of Pay Type to map them to in the Mapped Value column. The mapped Rate of Pay Type is used to pass the appropriate value for the "Rate of Pay" column in the files to Selerix.
The available Selerix Rate of Pay Types are:
- W2 = Gross Wages
- Rate of Pay = Pay Rate
Data Requirement Message (DRM) Warning: If rate of pay types are not mapped, you will receive a warning: "Selerix Integration: There are unmapped items in Mapping Type 'Rate of Pay Type' which will cause incorrect reporting. Please map them in Admin Tools > Import/Export/Mapping > SyncStream Export."
Default Behavior: If mappings are not configured and the DRM warning is dismissed or turned off, the system will default to passing "Rate of Pay" (pay rate) in files sent to Selerix.
Rehire Gap (Days) Mapping
For each of the available Avionte staffing suppliers listed in the Source System Value column, enter a value in the Mapped Value column that defines the gap (in days) in pay which would result in the talent being a rehire. The mapped rehire gap value is used to pass an accurate hire date in the files to Selerix.
Data Requirement Message (DRM) Warning: If rehire gap values are not mapped, you will receive a warning: "Selerix Integration: There are unmapped items in Mapping Type: 'Rehire Gap' which will cause incorrect reporting. Please map them in Admin Tools > Import/Export/Mapping > SyncStream Export."
Default Behavior: If mappings are not configured and the DRM warning is dismissed or turned off, the system will default to using "91 days" as the rehire gap in files sent to Selerix.
Employee Mapping
There's a new standard Employee Extra called Employee Type that goes with the Selerix exports. By default the export will pass an employee type value of "Part Time" for all records in the files to Selerix. For employees who are either "Full Time" or "Seasonal", a user will need to set their employee type to the appropriate value and then the default value of "Part Time" will be overridden with the new value entered in Employee > Extra.
- Search for employee record
- Navigate to the Extra subtree menu
- Select the Label of Employee Type
- Select the appropriate employee type value for the employee
Available Employee Type options:
- Full Time
- Part Time
- Seasonal
Default Behavior: If the Employee Type extra is not set up or not populated for specific employees, the system will default to passing "Part Time" as the employee type in files sent to Selerix.
Employee Census Export
Field Mapping
| Column Name | Required/Optional | Value Passed | Value Location |
| SSN | Required | SSN | Employee > SSN |
| Employee ID | Required | SSN | Employee > SSN |
| Employee Name | Required | FirstName + MiddleName + LastName | Employee > FirstName + MiddleName + LastName |
| Employee First Name | Optional | FirstName | Employee > FirstName |
| Employee Middle Name | Optional | MiddleName | Employee > MiddleName |
| Employee Last Name | Optional | LastName | Employee > LastName |
| Hire Date | Optional | Pass blank value | |
| Termination Date | Optional | Pass blank value | |
| Effective Date | Optional | Pass blank value | |
| Employee Status | Optional | Pass blank value | |
| Employee Type | Optional | Pass blank value | |
| Pay Type | Optional | Pass blank value | |
| Address 1 | Required | Street1 | Employee > Address > Street1 |
| Address 2 | Optional | Street2 | Employee > Address > Street2 |
| City | Required | City | Employee > Address > City |
| State | Required | State | Employee > Address > State |
| Zip | Required | ZipCode | Employee > Address > ZipCode |
| Home Department | Optional | Pass blank value | |
| Home Location | Optional | Pass blank value | |
| Date of Birth | Optional | DateofBirth | EmployeeEEO > DateofBirth |
| Employee Email | Optional | Employee > ContactMethod > Email | |
| Primary Worksite ZipCode | Optional | Pass blank value | |
| County of Worksite | Optional | Pass blank value | |
| County of Residence | Optional | Pass blank value | |
| Miscellaneous | Optional | Pass blank value |
Employee Census Export File Validation
The Selerix Payroll export runs automatically on the scheduled basis (Tuesday and Saturday evenings). Files are generated and transmitted to Selerix automatically without manual user intervention.
Data Validation: If required data is missing or incomplete when the export runs, the file will still be transmitted to Selerix. Selerix will process the file on their end and notify the client if any data issues are detected that prevent proper processing.
Correcting Data Issues: If Selerix identifies missing or invalid data, clients can update the necessary information in Avionte's Back Office (such as employee records, mapping configurations, transaction data, or other relevant data). The corrected data will automatically be included in the next scheduled export run.
Payroll Export
Field Mapping
| Column Name | Value Passed | Value Location | Notes |
| Company Name | Supplier Name | MasterStaffingSupplier > StaffingSupplierDesc | |
| Employee ID | SSN | Employee > SSN | Ensure leading zeros are maintained |
| Employee Name | DateofBirth | Employee > FirstName + MiddleName + LastName | |
| Employee First Name | FirstName | Employee > FirstName | |
| Employee Middle Name | MiddleName | Employee > MiddleName | |
| Employee Last Name | LastName | Employee > LastName | |
| Date Hired | StartDate | AssignmentSchedule > StartDate | Start date of the employees first assignment that has payroll associated with it |
| Date Terminated | Date | AssignmentSchedule > EndDate | If Employee Status is Terminated, pass the talents most recent assignment end date |
| Employee Status | ChoiceCode | Employee > EmployeeStatusConfigChoiceID > ConfigChoice | Pulled mapped value from Import Export Mapping |
| Employee Type | Default value = Part Time | Default value can be overriden by an Employee > Extra > Employee Type value of Full Time or Seasonal | |
| Pay Type | Default value = Hourly | Default value is overriden with a value of "Salary" if the employee has hours associated with a "Salary" transaction type | |
| Residence State | State | Employee > Address > State | |
| Employment State | State | Assignment > Order > Address > State | Employee's assignment worksite state tied to their hours |
| Department | CustomerName | Assignment > Order > Customer > CustomerName | |
| Location | SiteName | Employee > Branch > StaffingSupplierSite | |
| Rate of Pay | Value based on Affordability Type mapping | Based on System Setting "Affordability Type" - If Value = W2 pass gross wages from paycheck - If Value = Rate of Pay pass pay rate |
|
| Hours | Total Hours | Hours where the transaction type has a transaction type propderty, IsACAHours = 1 The transaction type property, Units to HoursMultiplier is respected and used to calculate hours. |
|
| Work Ending Date | Week Worked | Transaction > Week Worked | Week worked date associated with the transaction |
| Miscellaneous | Pass a blank value |
Payroll Export File Transmission Validation
The Selerix Employee Census export runs automatically on the scheduled basis (Tuesday and Saturday evenings). Files are generated and transmitted to Selerix automatically without manual user intervention.
Data Validation: If required data is missing or incomplete when the export runs, the file will still be transmitted to Selerix. Selerix will process the file on their end and notify the client if any data issues are detected that prevent proper processing.
Correcting Data Issues: If Selerix identifies missing or invalid data, clients can update the necessary information in Avionte's Back Office (such as employee records, mapping configurations, or other relevant data). The corrected data will automatically be included in the next scheduled export run.
Comments
0 commentsPlease sign in to leave a comment.