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 14, 2025 11:07AM in Reporting and Analytics for HCM 3 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.

Is there an SQL that I can use that pulls only the required information and I can directly upload as a HDL so that I can merge with the current contracts without any issues?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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