You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

What is the minimum information necessary to update contracts

edited Apr 16, 2025 1:41PM in HCM Data Loader (HDL) 2 comments

Summary:

Trying to create a data model and report to fix contracts that are missing PERIOD_OF_SERVICE_ID.

I can run an SQL query on any of the tables, filter by PER_CONTRACTS_F.ASSIGNMENT_ID = PER_ALL_ASSIGNMENTS_M.ASSIGNMENT_ID to get the work terms table or PER_CONTRACTS_F.ASSIGNMENT_ID = PER_ALL_ASSIGNMENTS_M.WORK_TERMS_ASSIGNMENT_ID to get assignment table and getting period of service ID from either of them but I do not have source system ID or source system owner to merge with the current contracts.

What is the minimum METADATA I need in Assignment, WorkTerms and Contract?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!