Changes Only Mode in HCM Extracts

 Changes Only Mode in HCM Extracts

You can create HCM Extract to extract the results. In HCM extract there are several modes, you can use these modes to extract the data which got changed since earlier extract run which we call it as Baseline.

To Enable these modes you have to enable Changes_Only parameter while you are defining HCM Extract.

At the time of running the Extract you can use Changes Only parameter to fetch the filtered data as per the parameter.

Below are the different parameters in changes only mode :

1. All Attribute
2. Changed Attributes
3. Changed and Marked Attributes
4. Changed and Marked Attributes with previous value
5. Changed, Marked Attributes under threading group
6. Changed, Marked Attributes, previous data under threading group

If you want to see step by step video for this visit  Link

In this blog we will see how first two parameter will works.

All Attribute - If we run the HCM Extract with this parameter then extract will fetch all the attributes     defined in HCM Extracts.

Now we will see how to create Changes only HCM Extract.

Requirement - 1. Need to create HCM Extract with Changes Only Functionality.

                        2. Change any record and fetch this record only using Changes only mode.

Let's Start - 

Navigation - My Client Group -> Data exchange -> Extract Definition -> Create Extract (+).

Name	PersonData_Change
Start Date	Date as you wish
Type	Full Profile
Changes Only	Enable this option

 

Create Data Group - 

Name	Person_Details
Tag Name	Person_Details
User Entity	PER_EXT_SEC_PERSON_UE
Threading Database Item	Extract Person ID
Threading Action Type	Object actions
Root Data Group	Enable this option to make this Root Data Group

Threading Database Item - If we are implementing Changes Only HCM Extract then its required to define threading database item. It is the Unique Id for the selected User Entity

Create Record - 

Sequence	10
Name	Person_Details
Tag Name	Person_Details
Type	Detail Record
Process Type	Fast Formula

Create the Attributes -

1. Person Id - Attribute

Name	Person_ID
Tag Name	Person_ID
Shor Code	Person_ID
Data Type	Number
Type	Database Item Group
Database Item Group	Extract Person ID
Output Label	Person_ID
Output Column	1
Key Attribute	Enable this option

 

Key Attribute - We need to configure Key Attribute which is uniquely identify each row return by the data group. For Changes only mode, you must select at least one attribute in the block as key attribute.

2. Person Full Name - Attribute 

Name	Person_FullName
Tag Name	Person_FullName
Shor Code	Person_FullName
Data Type	Text
Type	Database Item Group
Database Item Group	Person Full Name
Output Label	Person_FullName
Output Column	2

3. Person Gender - Attribute

Name	Person_Gender
Tag Name	Person_Gender
Shor Code	Person_Gender
Data Type	Text
Type	Database Item Group
Database Item Group	Person Gender
Output Label	Person_Gender
Output Column	3

4. Person Date of Birth - Attribute

Name	Person_DOB
Tag Name	Person_DOB
Shor Code	Person_DOB
Data Type	Date
Type	Database Item Group
Database Item Group	Person Date Of Birth
Output Label	Person_DOB
Output Column	4

Define the Delivery Option 

Delivery Option Name	Data
Output Type	Data
Output Name	Data
Delivery Type	None

Navigate to Extract Execution Tree to compile all the formula and validate Extract.

Once HCM Extract validate successfully, then Submit the extract.

All Attribute Mode - 

Submit the Extract with All Attribute Parameter in changes only.

It will Extract full data output at that point of time. We can utilize this as a baseline.

Check the result of Extract.

Now we will change the Person name using Person management Option.

Open Any Worker using Person Management and change the Person Name and save the changes.

Once person changes successfully submitted then we will run again the extract with another mode.

Changed Attribute Parameter - If we run the HCM Extract with this parameter then Extract will compare with    previous extract run and fetch only those records got changed.

Run the Extract with Changed Attribute Parameter.

HCM Extract will fetch those records got changed after previous run to till that point of time.

Now you can check the results. You will get changes only records in output.

In this way you can defined Changes Only Extract and run it with All Attribute Parameter and Changed Attributes Parameter.

In next Blog we will see rest of the Changes only Parameter.

If you want to see step by step video for visit  Link

Changed and Marked Attributes -  Extract will fetch those records which got changed after previous extract run along with this those attributes which are marked as change.

Marked as a Change -  If we enable this option at attribute level which mean that we made that attribute as a required to fetch by HCM Extract irrespective of any data changes.

If you want to see step by step video for Changed and Marked Attribute - visit  Link 

For this we will enable the Marked as a change option for Person Full Name attribute which was

highlighted in yellow.

Person Full Name - Attribute 

Name	Person_FullName
Tag Name	Person_FullName
Shor Code	Person_FullName
Data Type	Text
Type	Database Item Group
Database Item Group	Person Full Name
Output Label	Person_FullName
Output Column	2

Marked as Change

Enable this option

Save Extract.

Now we will change the Person name of any worker using person management and then Submit the extract.

Submit HCM Extract with Changed and Marked Attribute Parameter.

Expected output  -  HCM Extract will fetch those records got changed after the previous run and also those attributes which was marked as change.

If you want to see output for Changed and Marked Attribute - visit  Link 

Changed and Marked Attributes with previous value - 

 HCM Extract with this parameter will fetch the Changed attribute after previous extract run and those attributes which marked as change at attribute level along with old values.

For this we will enable Marked ass change option for person Date of birth Attribute.

If you want to see details for Changed and Marked Attribute with Previous Value - visit  Link 

 Person Date of Birth - Attribute

Name	Person_DOB
Tag Name	Person_DOB
Shor Code	Person_DOB
Data Type	Date
Type	Database Item Group
Database Item Group	Person Date Of Birth
Output Label	Person_DOB
Output Column	4

Marked as Change

Enable this option

Now we have Person Full Name and Person DOB these two attribute are marked as change.

We will change Person Gender for any person and will submit the Extract.

Changed the Gender for any person and save the changes.

Submit the HCM Extract with Changed and Marked Attributes with Previous Value Parameter.

It should fetch Person Full Name, Person DOB, Person Gender with old Values.

If you want to see output for Changed and Marked Attribute with Previous Value - visit  Link