1. HCM Data Loading Business Objects
  2. Example of Loading Qualifiers for Event Actions

Example of Loading Qualifiers for Event Actions

This topic shows how to add qualifiers to an event group using HCM Data Loader (HDL).

Loading Date Tracked Events

The Date Tracked Event component identifies the entity to be monitored. For example, Element Entry.

METADATA|DateTrackedEvent|ColumnName|UpdateType|EventGroupCode|DatedObjectName
MERGE|DateTrackedEvent|SCREEN_ENTRY_VALUE|DT_UPDATE_COLUMN|EleEntryChangeEventGroup|oracle.apps.hcm.payrolls.elements.entries.protectedModel.entity.ElementEntryValueDEO

Loading Event Value Changes

The Event Value Change component identifies the change values to be monitored. You must define these as 'include' or 'exclude' rules in HDL. For example, a US customer can indicate they only want to 'include' input value changes from California to New York.

When you don’t have a requirement to monitor a specific value change, you should enter include <ANY_VALUE> to <ANY_VALUE>.

Note: You can’t enter a mix of include and exclude rules for an entity.

When you create an ‘include’ record, the application automatically creates an 'exclude' record (for all other state input value changes), so that you don't need to enter it explicitly.

Currently, you must enter the ID of the value. For example, when tracking assignment location changes, you may opt to only track changes from New York to San Francisco. In this instance, you must enter the ID for the New York and San Francisco locations.

METADATA|EventValueChange|EffectiveStartDate|EffectiveEndDate|Sequence|ValidEvent|FromValue|ToValue|EventGroupCode|LegislativeDataGroupName|DatedObjectName|ColumnName|UpdateType|ParentEvtValChangeSequence
MERGE|EventValueChange|2020/01/01|4712/12/31|1|Y|<ANY_VALUE>|<ANY_VALUE>|DN_EV_C1|<LEGISLATIVE_DATA_GROUP_NAME>|oracle.apps.hcm.employment.core.publicModel.entity.EmployeeAssignmentDEO|LOCATION_ID|DT_UPDATE_COLUMN|

Loading Event Value Qualifiers

The Event Value Qualifier component enables you to qualify the changes to be monitored for the entity. For example, you can indicate you want to monitor the creation of ‘Salary’ element entries only.

You can define multiple qualifiers. For example, you can indicate you want to monitor input value changes to the 'Premium' and 'Shift' element entries only.

METADATA|EventValueQualifier|EffectiveStartDate|EffectiveEndDate|QualifierValue|LegislativeDataGroupName|ColumnName|UpdateType|EventGroupCode|DatedObjectName|Sequence|QualifierName
MERGE|EventValueQualifier|2020/01/01|4712/12/31|Y|<LEGISLATIVE_DATA_GROUP_NAME>|LOCATION_ID|DT_UPDATE_COLUMN|DN_EV_C1|oracle.apps.hcm.employment.core.publicModel.entity.EmployeeAssignmentDEO|1|EmployeeAssignmentDEO Primary Flag