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