1. HCM Data Loading Business Objects
  2. Guidelines for Loading External Identifiers

Guidelines for Loading External Identifiers

The External Identifier component of the Worker object holds an identifier used by a third-party application, such as a time device or payroll application. This topic describes how to set some attributes of the External Identifier component.

External Identifiers at Person or Assignment Level

The external identifier can be captured:

  • At the person level, by supplying only the person number

  • At the assignment level, by supplying both the person number and the assignment number

External Identifier Types

The external identifier type is defined in lookup type ORA_PER_EXT_IDENTIFIER_TYPES. You can add lookup codes to this lookup type.

Date Values

The DateFrom and DateTo attributes include a time stamp. The time stamp ensures that you can assign an external identifier of a single type to a worker more than once on any day. For example, a person may be assigned a time-device badge identifier that he or she loses the same day. If you replace the badge identifier on the same day, then the time stamps differentiate the external identifiers.

External Identifier Sequence

The ExternalIdentifierSequence attribute is a required component of the user key and must be unique. You're recommended to set this attribute to 1 for the first record for a worker. Increment it by 1 for subsequent records.

External Identifier Example

This example Worker.dat file loads an external identifier for a person.

SET PURGE_FUTURE_CHANGES N
METADATA|ExternalIdentifier|ExternalIdentifierNumber|PersonNumber|ExternalIdentifierType|ExternalIdentifierSequence
MERGE|ExternalIdentifier|rtyui45678|TestPer0TALTEST_9|Third-Party Payroll ID|1