Example of Loading Data for Descriptive Flexfields

This topic shows how to construct the METADATA line for the Contract component of the Worker object with multiple configured descriptive flexfields. The METADATA line appears automatically in the generated worker template.

The contract component supports these descriptive flexfields:

  • PER_CONTRACT_DF

  • PER_CONTRACT_LEG_DDF

Constructing the METADATA Line for the Worker Contract Component

The PER_CONTRACT_DF descriptive flexfield is configured in Oracle HCM Cloud with the context and attribute values shown in this table. The Hint column shows the resulting hint for each attribute.

Context

Attribute

Hint

Global

CONTRACT_GLB

(PER_CONTRACT_DF=Global Data Elements)

CONTRACT_DF

Currency

(PER_CONTRACT_DF=CONTRACT_DF)

The PER_CONTRACT_LEG_DDF descriptive flexfield is configured in Oracle HCM Cloud with the context and attribute values shown in this table. The Hint column shows the resulting hint for each attribute.

Context

Attribute

Hint

CH

_MAIN_CONTRACT

(PER_CONTRACT_LEG_DDF=CH)

CN

_CONST_PROB_DATE

(PER_CONTRACT_LEG_DDF=CN)

CN

_NDA

(PER_CONTRACT_LEG_DDF=CN)

CN

_COMPETITION_CLAUSE

(PER_CONTRACT_LEG_DDF=CN)

CN

_NOTICE_DURATION_UNIT

(PER_CONTRACT_LEG_DDF=CN)

In the generated Worker.dat template file, the Contract METADATA line includes these attribute definitions for the flexfield attributes:

METADATA|Contract|...|_CONTRACT_GLB(PER_CONTRACT_DF=Global Data Elements) |_Currency(PER_CONTRACT_DF=CONTRACT_DF)|_MAIN_CONTRACT(PER_CONTRACT_LEG_DDF=CH)|_CONST_PROB_DATE(PER_CONTRACT_LEG_DDF=CN)|_NDA(PER_CONTRACT_LEG_DDF=CN)|_COMPETETION_CLAUSE(PER_CONTRACT_LEG_DDF=CN)|_NOTICE_DURATION_UNIT(PER_CONTRACT_LEG_DDF=CN)

As each attribute has a hint that identifies both the descriptive flexfield and the context, you can define attributes for multiple flexfields on the same METADATA line.