Keep your systems in sync, reduce data entry mistakes, and streamline your operations in the field and the office with Arcoro Core HR and CMiC. Integrations between both systems make it easy to manage employee data with features like:
- Full round-trip synchronization between systems (Importing/Exporting employee and company information)
- Push Core HR employee data to CMiC, on-demand, to complete payroll
- Keep Benefit Deductions, Direct Deposit, Taxes, and more in sync
Table of Contents
Integration Demonstration
To provide a better understanding of the integration, you can watch our demonstration video below.
How Does Data Synchronization Work?
The data synchronization operates bidirectionally, establishing a connection between CMiC and Core HR.
The connection allows for bidirectional employee data synchronization for:
- Demographic
- Federal and State Level Taxes
- Compensation
- Direct Deposit
- Benefits (CMiC Deductions)
- Fringes (CMiC Benefits)
Connector Configuration Page
The required field of "Security Group" is set by you to match your CMiC configuration.
Enterprise clients will also see default values for:
- Rate Code
- Federal Withholding Tax Code
- State Withholding Tax Code
Cloud users are set by the CMiC Standards, where no change is necessary.
PYEmployee Section
The PYEmployee Additional Required Properties section is only needed when your CMiC configuration has required fields outside the scope of our mapped fields.
When text is entered in the “Enter the property to map” type ahead field, a list of the unmapped properties appears for you to choose.
Once the property is added, it becomes a required field, and a default value is required before the connector can be saved.
Click Save for the connector to initiate validation on the connection properties and the PYEmployee Additional Required Properties. If the PYEmployee Additional Required Properties have a mismatch on data type and value, an error message would appear. For example, the property is a data type of DateTime (yyyy-mm-dd), and the default value entered was “12” when Save is clicked, the error would appear.
You can Add and Edit as many of these fields as necessary to match your CMiC configuration, along with deleting the unused requirements as your CMiC configuration changes.
Data Mapping Fields
As the field names for a CMiC property can be customized, we have included the default field for CMiC and the property. This field name may differ depending on your CMiC configuration. Some fields (user defined fields) in Core HR must be defined by you or with the assistance of Arcoro to allow proper data flow.
Special Consideration
- The Core HR Employee Type is the same as the CMiC Employee Status.
- The Core HR Employee Status is the same as the CMiC Employee Type.
- Make sure that the correct hire date is entered in Core HR as the hire date in CMiC is a locked field. Updating the field requires higher-level permission to update.
- State & Federal taxes will not pull into Core HR from CMiC if not in the exemptions/overrides area of CMiC.
Syncing Employees
- CMiC into Core HR - Sync will include all active employees and any terminated employees with a termination date of 01/01 of the previous year to the current date.
- Core HR to CMiC - Sync will include all active employees and any terminated employees with a term date as of 12/01 of the previous year to the current date.
Defaulted Values/Fields
The integration includes mappings that establish defaulted values for synchronization from Core HR to CMiC as these values cannot be typically entered in Core HR. These defaulted values are used when creating a new employee record within CMiC.
In cases where a defaulted value is adjusted and saved within CMiC, subsequent synchronization processes will not revert that property to its original mapped value. Defaulted fields will be labeled in the 'Notes' column.
Legend
- Core HR Field - The field used for syncing in Core HR, if any.
- CMiC Default Field - The default field name for syncing in CMiC, if any.
- CMiC Property - The name for the field on the backend of CMiC.
- <None> - No equivalent field in Core HR/CMiC.
- <Not on screen> - Field not presented in CMiC.
- Required fields for Core HR and CMiC will be marked in RED
- [Defaulted Value] - The initial value that will be used when creating a new employee record within CMiC. The defaulted value can be adjusted in CMiC and will not revert to the original value from future syncs.
Data Mapping Table and Screenshots
Expand any of the sections below to view the appropriate data mapping tables and screenshots of the fields utilized in CMiC.
Things to Note
- The integration includes validation to exclude non-US addresses from syncing and proper truncation for postal codes exceeding CMiC’s 13-character limit.
| Core HR Field | CMiC Default Field | CMiC Property | Notes | |||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| <None> | <None> | EmpCalcPref | [Defaulted Value] Value defaults to "S" for initial employee sync. Value can be updated in CMiC after. | |||||||||||||||||||||||||||||||||
| Overtime Exempt | <Not on Screen> | EmpOtEligibility | If Overtime Exempt is true in Core HR, the value will be "N" in CMiC. | |||||||||||||||||||||||||||||||||
| <None> | <Not on Screen> | EmpLastUpdDate | [Defaulted Value] Value defaults to Today's Date. | |||||||||||||||||||||||||||||||||
| <None> | <Not on Screen> | EmpCreateDate | [Defaulted Value] Value defaults to Today's Date. | |||||||||||||||||||||||||||||||||
| <None> | <Not on Screen> | EmpPaymentMode | [Defaulted Value] Value defaults to "C" for initial employee sync. Value can be updated in CMiC after. | |||||||||||||||||||||||||||||||||
| <None> | <Not on Screen> | EmpUser | [Defaulted Value] Value defaults to "CMICINTEGRATION" for initial employee sync. Value can be updated in CMiC after. | |||||||||||||||||||||||||||||||||
| <None> | Security Group Code | EmpSecGrpEmpCode | [Defaulted Value] Value defaults to the security group set from 'Connector' page for integrations UI for initial employee sync. Value can be updated in CMiC after. | |||||||||||||||||||||||||||||||||
| Overtime Exempt | FLSA Type | EmpFlsaType | [Defaulted Value] If an employee is overtime exempt, will map to "E" (Exempt) with false mapping to "N" (Non-Exempt). | |||||||||||||||||||||||||||||||||
| Compensation Type | Yearly Salary | EmpHemplYearlySal | If Compensation Type = 1, "Salary" then Annual Salary Else Null/blank | |||||||||||||||||||||||||||||||||
| Compensation Type | <Not on Screen> | EmpHemplType |
|
|||||||||||||||||||||||||||||||||
|
Skill Level|Craft (User Defined Lookup 15) |
<Not on Screen> | EmpHrrTypeCode | ||||||||||||||||||||||||||||||||||
| Mobile Phone | Work Cell Phone | EmpWorkCellPhone | ||||||||||||||||||||||||||||||||||
| Work Email | Work Email Address | EmpWorkEmailAddress | ||||||||||||||||||||||||||||||||||
| <None> | Geo Code From |
EmpVertex GeocodeSource |
[Defaulted Value] Value defaults to "M" for initial employee sync. Value can be updated in CMiC after. | |||||||||||||||||||||||||||||||||
| <None> | Foreign Address |
EmpAddress ForeignFlag |
[Defaulted Value] Value defaults to "N" for initial employee sync. Value can be updated in CMiC after. | |||||||||||||||||||||||||||||||||
| <None> | Foreign Address |
EmpPhAddress ForeignFlag |
[Defaulted Value] Value defaults to "N" for initial employee sync. Value can be updated in CMiC after. | |||||||||||||||||||||||||||||||||
| Employee ID | Employee # | EmpNo | Value must be alpha-numeric. Cannot have special characters. | |||||||||||||||||||||||||||||||||
| <None> | Employee Full Name | EmpFullName | Combination of employees last and first name. | |||||||||||||||||||||||||||||||||
| First Name | First Name | EmpFirstName | ||||||||||||||||||||||||||||||||||
| Middle Name | <Not on Screen> | EmpMiddleName | ||||||||||||||||||||||||||||||||||
| Last Name | Last Name | EmpLastName | ||||||||||||||||||||||||||||||||||
| Name Suffix | <Not on Screen> | EmpSuffixName | ||||||||||||||||||||||||||||||||||
| Nickname | <Not on Screen> | EmpNickName | ||||||||||||||||||||||||||||||||||
| Employee SSN | SSN / SIN | EmpSinNo | Numbers only when writing to CMiC | |||||||||||||||||||||||||||||||||
| Compensation Type | Type | EmpType |
|
|||||||||||||||||||||||||||||||||
| Employee Status | Full/Part | EmpFullPartTime |
|
|||||||||||||||||||||||||||||||||
| Employee Type | Status | EmpStatus | If Employee Status is Terminated send "T", else "A". | |||||||||||||||||||||||||||||||||
| Employee Type | Work Status | EmpSubStatus | ||||||||||||||||||||||||||||||||||
|
Union or Union Loc (User Defined Lookup 12 or 13) |
Unionized | EmpUnionized | If a value is entered in either Union or Union Loc, set this to Y, else N. | |||||||||||||||||||||||||||||||||
|
Rehirable (User Defined Lookup 9) |
<None> | EmpRehireEligible | Send Yes as "Y" and No as "N" | |||||||||||||||||||||||||||||||||
|
Union Id (User Defined Lookup 12) |
Union | EmpUniCode | ||||||||||||||||||||||||||||||||||
|
Union Local (User Defined Lookup 13) |
Union | EmpUniCode | ||||||||||||||||||||||||||||||||||
|
Union Member Number (User Defined Lookup 14) |
Union | EmpUniCode | ||||||||||||||||||||||||||||||||||
| Title | Job Title | EmpJobTitle | ||||||||||||||||||||||||||||||||||
| Birth Location | Place of Birth | EmpPlaceOfBirth | ||||||||||||||||||||||||||||||||||
| Date Of Birth | Date of Birth | EmpDateOfBirth | ||||||||||||||||||||||||||||||||||
| Original Hire Date | Hire Date | EmpHireDate | ||||||||||||||||||||||||||||||||||
| Termination Date | Termination Date | EmpTerminationDate | ||||||||||||||||||||||||||||||||||
| Hire Date | Re-Hire Date | EmpReHireDate |
|
|||||||||||||||||||||||||||||||||
| Original Hire Date | Seniority Date | EmpSeniorityDate | We set this to "Original Hire Date" as there is no direct support for this required field. | |||||||||||||||||||||||||||||||||
| Employee ID | <None> | EmpPrimaryEmpNo | Value must be alpha-numeric. Cannot have special characters. | |||||||||||||||||||||||||||||||||
| Facility 1 Name (Code) | Payroll Company | EmpCompCode | Location is Facility 1 in Core HR. This is set based on the company codes set in the Connector as to what we will be able to sync. | |||||||||||||||||||||||||||||||||
| Facility 1 Name (Code) | Home Company | EmpHomeCompCode | Location is Facility 1 in Core HR. This is set based on the company codes set in the Connector as to what we will be able to sync. | |||||||||||||||||||||||||||||||||
| Department | Payroll Dept | EmpDeptCode | ||||||||||||||||||||||||||||||||||
| Department | Home Dept | EmpHomeDeptCode | ||||||||||||||||||||||||||||||||||
| Pay Schedule | Pay Run | EmpPrnCode | ||||||||||||||||||||||||||||||||||
| Payroll Pay Group | Pay Group | EmpPygCode | ||||||||||||||||||||||||||||||||||
|
Work State (User Defined Lookup 8) |
Work Location | EmpWrlCode | ||||||||||||||||||||||||||||||||||
| EEOC Occupation | Trade | EmpTrdCode | ||||||||||||||||||||||||||||||||||
| EEOC Workers Comp | WC Code | EmpWcbCode | ||||||||||||||||||||||||||||||||||
| <None> | Workers Comp From Job | EmpWcbByJob | [Defaulted Value] Value defaults to "Y" for initial employee sync. Value can be updated in CMiC after. | |||||||||||||||||||||||||||||||||
| <None> | <None> | EmpWrlFlag | [Defaulted Value] Value defaults to "Y" for initial employee sync. Value can be updated in CMiC after. | |||||||||||||||||||||||||||||||||
| Compensation Type | Annual Salary | EmpAnnualSalary | If Compensation Type = 1 'Salary', send the Annual Amount, Else Blank. | |||||||||||||||||||||||||||||||||
| Per Pay Rate | Hourly Rate | EmpHourlyRate | Send if Hourly employee, else send a zero value | |||||||||||||||||||||||||||||||||
| Per Pay Rate | Charge Out Rate | EmpChargeOutRate | Send if Hourly employee, else send a zero value | |||||||||||||||||||||||||||||||||
| Per Pay Rate | Billing Rate | EmpBillingRate | Send if Hourly employee, else send a zero value | |||||||||||||||||||||||||||||||||
| Pay Rate Type Code | NWHR Rate | EmpRateCode | Default value must be set up on the Connectors page. | |||||||||||||||||||||||||||||||||
| <None> | Preferred Pay Rate | EmpPreferPayRate | [Defaulted Value] Value defaults to "E" for initial employee sync. Value can be updated in CMiC after. | |||||||||||||||||||||||||||||||||
| <None> | Preferred Charge out Rate | EmpPreferChargeRate | [Defaulted Value] Value defaults to "E" for initial employee sync. Value can be updated in CMiC after. | |||||||||||||||||||||||||||||||||
| <None> | Perferred Bill Rate | EmpPreferBillRate | [Defaulted Value] Value defaults to "E" for initial employee sync. Value can be updated in CMiC after. | |||||||||||||||||||||||||||||||||
| <None> | Preferred Method for Direct Deposit Stubs | EmpDirectDepMethod | [Defaulted Value] Value defaults to "E" for initial employee sync. Value can be updated in CMiC after. | |||||||||||||||||||||||||||||||||
| Home Email | <None> | EmpDirectDepEmail | [Defaulted Value] Value defaults to "E" for initial employee sync. Value can be updated in CMiC after. | |||||||||||||||||||||||||||||||||
| Home Address 1 | Address Line 1 | EmpAddress1 | ||||||||||||||||||||||||||||||||||
| Home Address 2 | Address Line 2 | EmpAddress2 | ||||||||||||||||||||||||||||||||||
| <None> | <None> | EmpAddress3 | ||||||||||||||||||||||||||||||||||
| Home Zip Code | Postal Code | EmpZipCode | Will be truncated to CMiC’s 13-character limit | |||||||||||||||||||||||||||||||||
| Country | Country Code | EmpCountryCode | ||||||||||||||||||||||||||||||||||
| Home State | State/Province | EmpStateCode | ||||||||||||||||||||||||||||||||||
| Home City | EmpAddress3 | EmpAddress3 | CMiC will sync this data to Core HR, but Core HR will not sync the data to CMiC as it can affect the GeoCode. | |||||||||||||||||||||||||||||||||
| Home Phone | Home Phone | EmpPhone | ||||||||||||||||||||||||||||||||||
| Work Phone + Work Phone Extension | Work Phone | EmpWorkPhone | The employee's work phone and work phone extension will be combined. | |||||||||||||||||||||||||||||||||
| Work Fax | Work Fax | EmpWorkFax | ||||||||||||||||||||||||||||||||||
| Home Email | Email Address | EmpEmailAddress | ||||||||||||||||||||||||||||||||||
|
I-9 Status (User Defined Lookup 6) |
Residential Status | EmpResidentStatus |
|
|||||||||||||||||||||||||||||||||
| <None> | Federal Filing Status | EmpFilingStatus |
|
|||||||||||||||||||||||||||||||||
| <None> | State Filing Status | EmpStateFilingStatus | ||||||||||||||||||||||||||||||||||
| <None> | Non-Residence Certificate | EmpNrCertificate | [Defaulted Value] Value defaults to "N" for initial employee sync. Value can be updated in CMiC after. | |||||||||||||||||||||||||||||||||
| <None> | Able to Travel | EmpTravelFlag | [Defaulted Value] Value defaults to "N" for initial employee sync. Value can be updated in CMiC after. | |||||||||||||||||||||||||||||||||
| Gender | Sex | EmpSex |
|
|||||||||||||||||||||||||||||||||
| Marital Status | Marital Status | EmpMaritalStatus |
|
|||||||||||||||||||||||||||||||||
| EEOC Ethnicity | Ethnic Code | EmpEthnicCode |
|
|||||||||||||||||||||||||||||||||
| Vet | Military Status | EmpMilitaryStatus |
|
|||||||||||||||||||||||||||||||||
| <None> | Dominant Hand | EmpDominantHand | [Defaulted Value] Value defaults to "R" for initial employee sync. Value can be updated in CMiC after. | |||||||||||||||||||||||||||||||||
| <None> | Reason Code | EmhActionCode | [Defaulted Value] Value defaults to "NH" for initial employee sync. Value can be updated in CMiC after. | |||||||||||||||||||||||||||||||||
| <None> | Effective Date | EmhEffectiveDate | [Defaulted Value] Value defaults to Today's date for initial employee sync. Value can be updated in CMiC after. | |||||||||||||||||||||||||||||||||
| <None> | <None> | EmpTxtCode | [Defaulted Value] Value defaults to "DC" for initial employee sync. Value can be updated in CMiC after. | |||||||||||||||||||||||||||||||||
| <None> | <None> | EmpCreateAccessCode | [Defaulted Value] Value defaults to "N" for initial employee sync. Value can be updated in CMiC after. |
Personal Tab
Company Tab
Rates/Salary Tab
Address Tab
HR Info Tab
Security Tab
| Core HR Field | CMiC Default Field | CMiC Property | Notes |
|---|---|---|---|
| Facility 1 Name | Company | EssCompCode | This is set up in the Connector and separated by commas |
| Employee ID | Employee | EssEmpNo | Value must be alpha-numeric. Cannot have special characters. |
| Priority | Priority | EssSplitNumber | To pass the value from Core HR to CMiC the Priority MUST have a numeric value set. |
| <None> | Split Type | EssSplitType |
[Defaulted Value] Value defaults to "D" for direct deposit when syncing to CMiC. Will only sync to Core HR for accounts that are "D". |
| Account Number | Account Number | EssBankAccNumber | |
| Routing Number | Bank | EssBankCode | |
| <None> | Percent / Flat Amount | EssSplitPercent | If Direct Deposit Amount is Null then Direct Deposit Percent, else Direct Deposit Amount. |
| <None> | <Not on Screen> | EssUser | [Defaulted Value] Value defaults to "CMICINTEGRATION". |
| <None> | <Not on Screen> | EssLastUpdDate | [Defaulted Value] Value defaults to Today's Date. |
| Deposit Account Type | Code | EssAchTranCode | |
| <None> | Count | EssPrenoteCnt | Set to 0 if no PreNote, 2 if there is a PreNote |
| <None> | Method of Salary Deposit | EssEmpSalSplitType | If Direct Deposit Amount is not Null Send as "F", else "P", Except if Direct Deposit Percent is 100 then, "F". |
| <None> | Split Method | EssSplitMethod | [Defaulted Value] Value defaults to "B" for initial employee sync. Value can be updated in CMiC after. |
| <None> | Tran Type | EssTranType | [Defaulted Value] Value defaults to "ALL" for initial employee sync. Value can be updated in CMiC after. |
| <None> | Tran Code | EssTranCode | [Defaulted Value] Value defaults to "ALL" for initial employee sync. Value can be updated in CMiC after. |
Direct Deposit Tab
| Core HR Field | CMiC Default Field | CMiC Property | Notes |
|---|---|---|---|
| Employee ID | Employee # | TxpEmpNo | Value must be alpha-numeric. Cannot have special characters. |
| <None> | State | TxpStateCode |
|
|
Work State (User Defined Lookup 8) |
Work Location | TxpWrlCode |
|
| <None> | Tax Code | TxpTaxCode |
For Cloud:
For Enterprise: Set on the Connector screen. |
| Start Date | Effective Date | TxpEffectiveDate (Fed) | |
| Override Amount | Tax Amount | TxpTaxAmount | CMiC does not support an Override Percentage |
| <None> | Amt Type | TxpAmtType |
|
| <None> | Calc. Meth | TxpCalcmeth | [Defaulted Value] Value defaults to "02" for initial employee sync. Value can be updated in CMiC after. |
| <None> | Alt. Calc. | TxpAltCalcCode (State) |
Null/blank Only used for Arizona State Taxes |
| <None> | <Not on Screen> | TxpUser | [Defaulted Value] Value defaults to "CMICINTEGRATION". |
| <None> | <Not on Screen> | TxpLastUpdDate | [Defaulted Value] Value defaults to Today's Date. |
| <None> | Tax Type | TxpTaxType | Value defaults to "B" for initial employee sync. Value can be updated in CMiC after. |
| <None> | <Not on Screen> | TxpExemptFlag | |
| <None> | <Not on Screen> | TxpExcludeFlag | Will set to "Y" if an employee is exempt from federal tax. |
| Employee ID | Employee # | TxxEmpNo | Value must be alpha-numeric. Cannot have special characters. |
| <None> | State | TxxStateCode |
|
| State Date | Effective Date | TxxEffectiveDate | |
| Filing Status | Filing Status | TxxFilingStatus |
|
| Allowances | Exemption Amt | TxxExempAmount | 2020+ only |
| <None> | <None> | TxxPrimExemp | Fed Tax 2019 and State Tax Allowances Whenever a 0 value, send a Null |
| <None> | <Not on Screen> | TxxUser | [Defaulted Value] Value defaults to "CMICINTEGRATION". |
| <None> | <Not on Screen> | TxxLastUpdDate | [Defaulted Value] Value defaults to Today's Date. |
| <None> | Work Location | TxxWrlCode | Value defaults to "All". |
| Two Jobs | Multi Jobs | TxxMultiJobsFlag | 2020+ only State Tax- N/A |
| Dependents | Dependents Tax Credit | TxxDepTaxCreditAmt | 2020+ only State Tax- N/A |
| Other Income | Other Income | TxxOtherIncomeAmt | 2020+ only State Tax- N/A |
| Deductions | Other Deductions | TxxOtherDeductionAmt | 2020+ only State Tax- N/A |
Tax Tab
Things to Note
- To fully leverage the Core HR to CMiC integration for Benefits and Fringes, ensure that the following is set up in Core HR:
- Knowing the Vendor ID from CMiC.
- Adding the vendor code in the description field (this is mandatory for data transfer).
- Using either an Alt1Code or an Alt2Code, as appropriate.
- Alt1Code should be used for employee-paid deductions (and any shared employer/employee contributions).
- Alt2Code should be used for employer-paid only benefits.
- In CMiC, eligibility rules must be configured to determine when an employee can elect these plans.
- For deductions (Alt1Code), include the employer-paid portion if applicable—currently, only the employee portion is passed.
- For benefits (Alt2Code), the employer-paid amount will be transferred.
| Core HR Field | CMiC Default Field | CMiC Property | Notes |
|---|---|---|---|
| Facility 1 Name | Company | EmdCompCode | Setup in the connector and separated by commas |
| Pay Schedule | Pay Run | EmdPrnCode | |
| Employee ID | Employee | EmdEmpNo | Value must be alpha-numeric. Cannot have special characters. |
| DeductionCode_Alt1 | Deduction Code | EmdDedCode | |
| Start Date | Effective Date | EmdStartDate | |
| Start Date | <Not on Screen> | EmdEffStartDate | |
| End Date | End Date | EmdEndDate | |
| <None> | Default Amount | EmdDedAmount | Sent as amount per pay period |
| CoverageInputTypeID | Deduction Type | EmdDedType | L (Lump Sum), P (Percentage) |
| <None> | Plan Code | EmdPlanCode | [Defaulted Value] Value defaults to "DEFAULT" for initial employee sync. Value can be updated in CMiC after. |
| <None> | Right of Plan Code | EmdPlanName | [Defaulted Value] Value defaults to "DEFAULT" for initial employee sync. Value can be updated in CMiC after. |
| <None> | Plan Option | EmdPloCode | [Defaulted Value] Value defaults to "DEFAULT" for initial employee sync. Value can be updated in CMiC after. |
| <None> | Right of Plan Option | EmdPloName | [Defaulted Value] Value defaults to "DEFAULT" for initial employee sync. Value can be updated in CMiC after. |
| <None> | Out of Area (Check box) | EmdOutOfAreaFlag | [Defaulted Value] Value defaults to "N" for initial employee sync. Value can be updated in CMiC after. |
| <None> | <Not on Screen> | EmdOthInsurFlag | [Defaulted Value] Value defaults to "N" for initial employee sync. Value can be updated in CMiC after. |
| <None> | <Not on Screen> | EmdUser | [Defaulted Value] Value defaults to "CMICINTEGRATION". |
Things to Note
- To fully leverage the Core HR to CMiC integration for Benefits and Fringes, ensure that the following is set up in Core HR:
- Knowing the Vendor ID from CMiC.
- Adding the vendor code in the description field (this is mandatory for data transfer).
- Using either an Alt1Code or an Alt2Code, as appropriate.
- Alt1Code should be used for employee-paid deductions (and any shared employer/employee contributions).
- Alt2Code should be used for employer-paid only benefits.
- In CMiC, eligibility rules must be configured to determine when an employee can elect these plans.
- For deductions (Alt1Code), include the employer-paid portion if applicable—currently, only the employee portion is passed.
- For benefits (Alt2Code), the employer-paid amount will be transferred.
| Core HR Field | CMiC Default Field | CMiC Property | Notes |
|---|---|---|---|
| Facility 1 Name | Company | EmbCompCode | Setup in the connector and separated by commas |
| Pay Schedule | Pay Run | EmbPrnCode | |
| Employee ID | Employee | EmbEmpNo | Value must be alpha-numeric. Cannot have special characters. |
| DeductionCode_Alt2 | Benefit Code | EmbBenCode |
The Benefit codes (Core HR Fringe) from CMiC are entered into Core HR as the Alt 2 code on the coverage level. Must match or they will not flow |
| Start Date | Effective Date | EmbStartDate | |
| Start Date | Effective Date | EmbEffStartDate | |
| End Date | End Date | EmbEndDate | Fringe end date - usually matches plan year end date |
| <None> | Benefit Amount | EmbBenAmount | Sent as amount per pay period |
| <None> | <Not on Screen> | EmbUser | [Defaulted Value] Value defaults to "CMICINTEGRATION". |
| <None> | <Not on Screen> | EmbLastUpdDate | [Defaulted Value] Value defaults to Today's Date. |
| CoverageInputTypeID | Benefit Type | EmbBenType | L for Lump Sum (most), P for Percent (401k only) |
| <None> | Plan Code | EmbPlanCode | [Defaulted Value] Value defaults to "DEFAULT" for initial employee sync. Value can be updated in CMiC after. |
| <None> | Plan Name | EmbPlanName | [Defaulted Value] Value defaults to "DEFAULT" for initial employee sync. Value can be updated in CMiC after. |
| <None> | Plane Code | EmbPloCode | [Defaulted Value] Value defaults to "DEFAULT" for initial employee sync. Value can be updated in CMiC after. |
| <None> | Plan Option Name | EmbPloName | [Defaulted Value] Value defaults to "DEFAULT" for initial employee sync. Value can be updated in CMiC after. |
| <None> | Out of Area (Check box) | EmbOutOfAreaFlag | [Defaulted Value] Value defaults to "N" for initial employee sync. Value can be updated in CMiC after. |
| <None> | <Not on Screen> | EmbOthInsurFlag | [Defaulted Value] Value defaults to "N" for initial employee sync. Value can be updated in CMiC after. |
Things to Note
Demographic, Federal Tax, Compensation Data
CMiC intertwines pieces of these concepts into one API (Application Programming Interface) call (PYEmployee) and therefore all three “scopes” are required when executing a sync.
When syncing Core HR to CMiC changes or revisions to the listed properties will be set to the effective date from the history logs in Core HR, as opposed to utilizing a hire date or the current date.
| Property List | ||
|---|---|---|
| EmpTrdCode | EmpAddress1 | EmpHemplYearlySal |
| EmpPygCode | EmpAddress2 | EmpAnnualSalary |
| EmpFlsaType | EmpAddress3 | EmpHourlyRate |
| EmpUniCode | EmpZipCode | EmpChargeOutRate |
| EmpWrlCode | EmpType | EmpBillingRate |
| EmpWcbCode | EmpHemplType |
Direct Deposit
Core HR does not require a priority to be set when saving a record, however, it is a requirement of CMiC.
Compensation
The integration only supports the passing of one defaulted Rate Code. The connector configuration page allows Enterprise clients to set their default value. Cloud-hosted clients will default to the standard REG for Regular.