Exploring Appendix A

Objective

After completing this lesson, you will be able to describe the relevant data model mappings and check system configuration

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 NameEC Field IDPicklist UsedCode MappingRecommendation
Date of Birthdate-of-birth   
Person IDperson-id-external  Ensure that the Person ID is unique and not changed after data replication.

National ID Card

EC Field NameEC Field IDPicklist UsedCode MappingRecommendation
National Identificationnational-id   
Countrycountry   

Job Information

EC Field NameEC Field IDPicklist UsedCode MappingRecommendation
Companycompany   
Locationlocation Mapping entries in table PAOCFEC_KM_APPESTLocation maps into 2 fields in ERP inbound personnel area and subarea.
Cost centercost-center   
Employee Classemployee-classEMPLOYEECLASS

WORK_AGREEMENT_TYPE_CODE

Best practice is to take over the ERP key and to use the ERP text as the EC label.
Employment Typeemployment-typeemploymentType Best practice is to take over the ERP key as 2-char external code.
Job classificationjobCode JOB_ID 
Time offworkschedule WORK_SCHEDULE_RULE 
Working Days Per Week

workingDays

PerWeek

   

Compensation Information

EC Field NameEC Field IDPicklist UsedCode MappingRecommendation
Pay Grouppay-group 

PAYROLL_GROUP

_CODE

Length=4; Pay Scale Groups Constant, 'DY' or Mapping

Pay Component

pay-component;

paycomponentcode

 

COMPENSATION_COMPONENT_TYPE_ID

 
Currencycurrency-code   
Amount

paycompvalue

value

   
Issue datepay-date   
FrequencyFrequency 

COMPENS_COMP_RECURR_FREQ_CODE

 

Payment Information

EC Field NameEC Field IDPicklist UsedCode MappingRecommendation
Payment Methodpayment-method 

PAYMENT_FORM_CODE

 
Processing Typeprocess-typeprocessType

PAYMENT_FORM_CODE

Mapping done in the middleware.
Bank Countrycountry-code   

Job Information (Country Specific Succession Data Model - US)

EC Field NameEC Field IDPicklist UsedCode MappingRecommendation
Pay Scale TypepayScaleTypepay-scale-type

PAY_SCALE_TYPE_CODE

Length ﹤= 20
Pay Scale AreapayScaleAreapay-scale-area

PAY_SCALE_AREA_CODE

Length ﹤= 20

Home Address (Country Specific Succession Data Model - US)

EC Field NameEC Field IDPicklist UsedCode MappingRecommendation
CityCity   
StatestateSTATE_USAREGION_CODE

Best practice is to take over the ERP key and to use the ERP text as the EC label.

ZIPzip   

Personal Information

EC Field NameEC Field IDPicklist UsedCode MappingRecommendation
Salutationsalutationsalutation

FORM_OF_ADDRESS_CODE

Change the Employee Central Codes to match the EC Payroll codes.

Marital Statusmarital-statusecMaritalStatus

MARITAL_STATUS_CODE

Place of Birthplace-of-birth   
Birth NameBirth-name   

Using the Check Tool to Solve Issues

Get an overview of potential problems and errors in your configuration that you can try to solve yourself before you contact Product Support about an issue.

Context

The check tool provides an overview of the issues found in the system. New checks that are being added in a new release go through a first initial run to return a result. After the initial run, checks are run on a regular basis (at least monthly). We recommend you open the check tool after you upgrade to a new release to see whether issues have been found by new checks.

In addition to these runs performed by the system, you can also run individual checks after you make changes to the system, for example, after updating data models or picklists. For more information, refer to the application-specific documentation.

Prerequisites

  • You've enabled the Metadata Framework.

  • You have the following Administrator Permissions→ Check Tool permissions:
    • Access Check Tool authorizes users to access the tool.
    • Allow Configuration Export authorizes users to attach configuration information to a ticket.
    • Allow Check Tool Quick Fix authorizes users to run quick fixes for the checks that have this feature. A quick fix can be used to immediately correct any issues found by that check.

Refer to Guided Answers for the Check Tool for a guided navigation through the available check tool checks and more information on each check.

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.

CompanyMax. 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.

Location20Mapping always required
Cost Center20costcenterExternalObjectID is used
Job Classification10﹥= 2
Pay Group4﹤= 2
Pay Component10﹤= 4

Log in to track your progress & complete quizzes