Guidelines for Loading Employee City Earnings Distribution Card Components

The Employee City Earnings Distribution card component is used to capture the percentage of earnings distribution that applies to the city.

Card Component Hierarchy

hdl employee city earnings distribution card components hierarchy

The Employee City Earnings Distribution card component utilizes the Employee Earnings Distribution flexfield context and data for this is loaded using the Component Detail record type.

It references the Employee County Earnings Distribution card component as its parent card component.

Card Component Attributes

The Employee City Earnings Distribution card component uses these attributes:

HCM Data Loader Attribute Alternative User Key Attributes Functional Description
SourceSystemId CardSequence, ComponentSequence, AssignmentNumber, DirCardDefinitionName, LegislativeDataGroupName, DirCardCompDefName A unique identifier for the Employee City Earnings Distribution card component. For new card components supply the source key attributes. You can also identify card components with the user key attributes.
SourceSystemOwner N/A The name of the source system owner used to generate the source system ID.
LegislativeDataGroupName N/A The name of the legislative data group for the card component definition.
DirCardId(SourceSystemId) CardSequence, AssignmentNumber, DirCardDefinitionName, LegislativeDataGroupName

The parent Employee Earnings Distribution Overrides calculation card should be identified by using the same key type used to identify the calculation card.

When using source keys, supply this attribute with the value supplied for the calculation card’s SourceSystemId attribute. Otherwise, supply the user key attributes with the same values as the parent calculation card
ParentDirCardCompId(Source SystemId) CardSequence, ParentComponentSequence, AssignmentNumber, DirCardDefinitionName, LegislativeDataGroupName, ParentDirCardCompDefName

The parent Employee County Earnings Distribution card component.

When using source keys, supply this attribute with the value supplied to the SourceSystemId on the parent Employee County Earnings Distribution card component.

EffectiveStartDate N/A

The start date of the Employee City Earnings Distribution card component, typically the employee’s start date. This must be the same as the EffectiveStartDate on the Employee Earnings Distribution Overrides calculation card.

If updating an existing Employee City Earnings Distribution card component, the effective start date must be original start date of the component.

EffectiveEndDate N/A The end date is optional for the card component
DirCardCompDefName N/A The component definition name. Specify ‘Employee City Earnings Distribution’.
ComponentSequence N/A The number to uniquely identify this card component when multiple card components with the same DirCardCompDefName exist. Not required when source keys are used.
Context1 N/A The geocode number that identifies the state.
Context2 N/A The geocode number that identifies the county.
Context3 N/A The geocode number that identifies the city.

Component Detail Attributes

The component detail record type enables you to upload data into flexfield segments.

In addition to the attributes defined here, include the necessary flexfield segment attribute values for the flexfield context:

  • Employee Earnings Distribution (ORA_HRX_US_EARN_DISTRIBUTION)

You can find the flexfield segment attribute name for this flexfield context using the View Business Objects task.

Core attributes for Component Details:

HCM Data Loader Attribute Alternative User Key Attributes Functional Description
SourceSystemId CardSequence, ComponentSequence, DirInformationCategory, LegislativeDataGroupName, AssignmentNumber, DirCardDefinitionName, DirCardCompDefName A unique identifier for the Employee Earnings Distribution component detail. For new component detail records supply the source key attributes. You can also identify card components with the user key attributes.
SourceSystemOwner N/A The name of the source system owner used to generate the source system ID.
LegislativeDataGroupName N/A The name of the legislative data group for the card component definition.
DirCardCompId(SourceSystemId) CardSequence, ComponentSequence, AssignmentNumber, DirCardDefinitionName, LegislativeDataGroupName, DirCardCompDefName

The parent Employee City Earnings Distribution card component should be referenced using the same key type used to identify the parent record.

When using source keys, supply this attribute with the value supplied for the card component’s SourceSystemId attribute. Otherwise, supply the user key attributes with the same values as the parent card component.
EffectiveStartDate N/A The start date of the component detail, or update to the component detail if you are providing date-effective history. This must be after or equal to the EffectiveStartDate provided for the Employee City Earnings Distribution card component.
EffectiveEndDate N/A The optional end date of the component detail, or if you are providing date-effective history the last day of the date-effective changes.
DirCardCompDefName N/A The name of the card component this detail is for. This is used to identify the flexfield context and should be supplied even when a source key is used to identify the parent card component. Supply ‘Employee City Earnings Distribution’.
DirInformationCategory N/A The code for the flexfield context. Supply ‘ORA_HRX_US_EARN_DISTRIBUTION’.
FLEX:Deduction DeveloperDF N/A Supply the same value as for the DirInformationCategory attribute.
Note: When supplying values to lookup validated flexfield segments, you can provide the lookup meaning using the ‘_Display’ suffixed attribute name, but it's recommended that you supply the lookup code to remove potential translation issues.