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

How to get timecard day details with different statuses for different versions through SQL

in Workforce Management

Summary:

We are currently developing an integration to transmit timecard day entries records to a downstream system. However, due to Oracle’s design, when timecard day entries records are updated or withdrawn/removed, the status of previously approved records changes into SUBMITTED which means pending for approval. As the timecard status changes, we hope to obtain the timecard details corresponding to each status/version.

Could you please advise for a particular timecard if it is possible to retrieve timecard day entries records against different statuses, as well as previous versions of those records? And how can we achieve this technically with SQL query / table?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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