HCM: Employee Jobs & Job Family Data Conversion Lean Specification

Data Conversion Mapping Specification

Human Capital Management Data Conversion

(Employee Jobs & Job Family)

Author:

Creation Date: 14^th August 2023

Last Updated: 26^th August 2023

Document Ref:

Version: 0.1

Note:Title, Subject, Last Updated Date, Reference Number, and Version are marked by a Word Bookmark so that they can be easily reproduced in the header and footer of documents. When you change any of these values, be careful not to accidentally delete the bookmark. You can make bookmarks visible by selecting Tools->Options…View and checking the Bookmarks option in the Show region.

Document Control

Change Record

Date	Author	Version	Change Reference

Reviewers

Name	Position

Approvers

Name	Position

Contents

Document Control...................................................................................... 2

Change Record........................................................................................... 2

Reviewers.................................................................................................. 2

Approvers.................................................................................................. 2

Introduction.............................................................................................. 4

Conversion Scope, Strategy And Assumptions.................................................. 4

Prerequisites.............................................................................................. 4

MAPPING SPECIFICATIONS........................................................................... 5

Data Extract Component Logic...................................................................... 7

Data Extraction Rules................................................................................... 7

Upload Component Logic............................................................................. 8

Data Flow Assumptions/ Prerequisites............................................................ 8

Open and Closed Issues............................................................................. 10

Open Issues.............................................................................................. 10

Closed Issues............................................................................................ 10

Note:To update the table of contents, put the cursor anywhere in the table and press [F9]. To change the number of levels displayed, select the menu option Insert‑>Index and Tables, make sure the Table of Contents tab is active, and change the Number of Levels to a new value.

Introduction

The purpose of this document is to document and communicate the configurations, data mapping, interdependency and component design specifications for the conversion of an individual entity that is going to be converted to the Oracle Cloud applications.

Following Objects will be converted:

Employee Jobs & Job Family Workstructure

Conversion Scope, Strategy And Assumptions

The Conversion Component Designs is used by the project team as the basis for the design and construction of the Employee Jobs & Job Family data conversion.

High Level Conversion Process Overview- Employee Jobs & Job Family data

a. The Data Migration of Oracle Employee Jobs & Job Family data data will involve conversion of data from CLIENT’s old legacy system (Workday) into CLIENT’s new Oracle Fusion.

b. The data being migrated from CLIENT’s old system into new system will be transformed because the source and target data structures are different.

c. The datafile provided will be used to build the import HDL file templates with Metadata of Locations

Prerequisites

Following configurations are required in SaaS

None

MAPPING SPECIFICATIONS

Please find attached import datafile provided to build the data as per HDL import file. The detail mapping is provided in the table below.

Job HDL (Job Workstructure Detail)

Oracle FBDI Field Name	Description	Mapping from legacy system/Values
*METADATA	This is HDL System required field	Default “MERGE”
Job	This is HDL System required field	Default “Job”
JobCode	Unique Job code	Default ‘JOB’ concatenated with sequence “JOB1”
ActiveStatus		Default “A”
JobFunctionCode		Default “MANAG”
ManagerLevel
MedicalCheckupRequired		Default “NO”
Regulartemporary		Default “R”
EffectiveStartDate		Effective start date defaulted to earlier start date *“1900/08/16”*
EffectiveEndDate		Default to “4712/12/31” which is Open dated
Name		*Datafile.Job Title*
SetCode		Default “COMMON” to be used globally
JobFamilyCode		*Datafile.Job Family*

Job Family HDL (Job Family Workstructure Detail)

Oracle FBDI Field Name	Description	Mapping from legacy system/Values
*METADATA	This is HDL System required field	Default “MERGE”
JobFamily	This is HDL System required field	Default “JobFamily”
JobFamilyId
EffectiveStartDate		Effective start date defaulted to earlier start date *“1951/01/01”*
EffectiveEndDate		Default to “4712/12/31” which is Open dated
JobFamilyCode		*Datafile.Job Family*
JobFamilyName		*Datafile.Job Family Group*
ActionReasonCode
ActiveStatus		Default “A”
SourceSystemOwner	This is HDL System required field	Default “SYSTEMOWNER_HDL”
SourceSystemId	This is HDL System required unique value for Job Family Metadata. Will be concatenated with JOBFAMI’_’II’Sequence’	Default *“JOBFAMII’1’”*

Data Extract Component Logic

Note:Describe the component logic for the download component(s) used to convert the entity being converted.

Bring Employee Jobs & Job Family and related details from existing legacy system to New Fusion

Pool: Only Include Active Employees Jobs & Job family Data

Data Extraction Rules

Only Active Employees Jobs & Job Family from workday for all the countries in scope will be extracted in the Data File.

Upload Component Logic

· Job Family HDL (Job Family Workstructure):

1. Download the template:

1. Log in to Oracle Fusion Applications.

2. Navigate to My Client Groups.

3. Go to Data Exchange and click on View Business Objects under HCM Data Loader.

4. Search for Job Family Business object and click on the Template File to download the template.

5. Save the template to your local drive.

2. Prepare the data in the HDL file, then save the file and click on Compress to ZIP file to generate the ZIP file.

3. Upload the template:

1. Navigate to My Client Groups.

2. Go to Data Exchange and click on Import and Load Data.

3. Click on Import File and select the Zip File from your system.

4. Click Submit Now to upload the Job Family data. A confirmation message will display the Process Request ID for the upload. Use these IDs to track the progress of the upload process.

5. Monitor the progress of process request ID in the Search Results section. Click the Refresh icon to refresh the status.

6. You can view the Import success (%), Load success (%) and previous upload submission. Click the Refresh icon to refresh the status.

· Job HDL (Job Workstructure)