Exploring Appendix A
Objective
Introduction
Employee Central – Mapping for Data Succession Model
For the mapping please consider: Employee Central codes that are longer than 10 characters are cut off during replication and only the first 10 characters are available for mapping in the EC Payroll system. Picklist entries must be in CAPITAL LETTERS and/or Numbers (0, 1, 2, 3….9).
Biographical Information
| EC Field Name | EC Field ID | Picklist Used | Code Mapping | Recommendation |
|---|---|---|---|---|
| Date of Birth | date-of-birth | |||
| Person ID | person-id-external | Ensure that the Person ID is unique and not changed after data replication. |
National ID Card
| EC Field Name | EC Field ID | Picklist Used | Code Mapping | Recommendation |
|---|---|---|---|---|
| National Identification | national-id | |||
| Country | country |
Job Information
| EC Field Name | EC Field ID | Picklist Used | Code Mapping | Recommendation |
|---|---|---|---|---|
| Company | company | |||
| Location | location | Mapping entries in table PAOCFEC_KM_APPEST | Location maps into 2 fields in ERP inbound personnel area and subarea. | |
| Cost center | cost-center | |||
| Employee Class | employee-class | EMPLOYEECLASS | WORK_AGREEMENT_TYPE_CODE | Best practice is to take over the ERP key and to use the ERP text as the EC label. |
| Employment Type | employment-type | employmentType | Best practice is to take over the ERP key as 2-char external code. | |
| Job classification | jobCode | JOB_ID | ||
| Time off | workschedule | WORK_SCHEDULE_RULE | ||
| Working Days Per Week | workingDays PerWeek |
Compensation Information
| EC Field Name | EC Field ID | Picklist Used | Code Mapping | Recommendation |
|---|---|---|---|---|
| Pay Group | pay-group | PAYROLL_GROUP _CODE | Length=4; Pay Scale Groups Constant, 'DY' or Mapping | |
| Pay Component | pay-component; paycomponentcode | COMPENSATION_COMPONENT_TYPE_ID | ||
| Currency | currency-code | |||
| Amount | paycompvalue value | |||
| Issue date | pay-date | |||
| Frequency | Frequency | COMPENS_COMP_RECURR_FREQ_CODE |
Payment Information
| EC Field Name | EC Field ID | Picklist Used | Code Mapping | Recommendation |
|---|---|---|---|---|
| Payment Method | payment-method | PAYMENT_FORM_CODE | ||
| Processing Type | process-type | processType | PAYMENT_FORM_CODE | Mapping done in the middleware. |
| Bank Country | country-code |
Job Information (Country Specific Succession Data Model - US)
| EC Field Name | EC Field ID | Picklist Used | Code Mapping | Recommendation |
|---|---|---|---|---|
| Pay Scale Type | payScaleType | pay-scale-type | PAY_SCALE_TYPE_CODE | Length ﹤= 20 |
| Pay Scale Area | payScaleArea | pay-scale-area | PAY_SCALE_AREA_CODE | Length ﹤= 20 |
Home Address (Country Specific Succession Data Model - US)
| EC Field Name | EC Field ID | Picklist Used | Code Mapping | Recommendation |
|---|---|---|---|---|
| City | City | |||
| State | state | STATE_USA | REGION_CODE | Best practice is to take over the ERP key and to use the ERP text as the EC label. |
| ZIP | zip |
Personal Information
| EC Field Name | EC Field ID | Picklist Used | Code Mapping | Recommendation |
|---|---|---|---|---|
| Salutation | salutation | salutation | FORM_OF_ADDRESS_CODE | Change the Employee Central Codes to match the EC Payroll codes. |
| Marital Status | marital-status | ecMaritalStatus | MARITAL_STATUS_CODE | |
| Place of Birth | place-of-birth | |||
| Birth Name | Birth-name |
Employee Central – Mapping for Corporate Data Model
The ID length restriction is technically required by the API. Longer fields cannot be handled and generate errors in the middleware. The recommended length is based on the EC Payroll field length. If you are using fields with external code longer than the recommended characters you need to map the codes. In this case the external code needs to be in CAPITAL LETTERS and/or Numbers (0, 1, 2, 3….9).
Save and import the XML in provisioning once completed.
| Company | Max. Length of ID (handled by the API) | Recommendation (based on the EC Payroll field length) |
|---|---|---|
Company (Legal Entity) | 20 | ﹤=4; best practice is to take over the ERP key of the company code. |
| Location | 20 | Mapping always required |
| Cost Center | 20 | costcenterExternalObjectID is used |
| Job Classification | 10 | ﹥= 2 |
| Pay Group | 4 | ﹤= 2 |
| Pay Component | 10 | ﹤= 4 |