Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Confirm Start Date for Pending workers created outside ORC — Cloud Customer Connect
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

Confirm Start Date for Pending workers created outside ORC

Accepted answer
52
Views
3
Comments

Hello,

We have been using a task in the Enterprise Onboarding which asks to confirm your Hire Date. We have been using a configurable form with a custom SQL that fetches the Hire Date through the recruiting:

"SELECT TO_CHAR(PAAM.PROJECTED_START_DATE, 'MM/DD/YYYY')

FROM PER_ALLOCATED_CHECKLISTS PAC, PER_ALL_ASSIGNMENTS_M PAAM , IRC_OFFERS OFFER

WHERE PAAM.PERSON_ID = PAC.PERSON_ID

AND OFFER.PERSON_ID = PAC.PERSON_ID

AND PAAM.ASSIGNMENT_ID = OFFER.ASSIGNMENT_OFFER_ID

AND PAAM.EFFECTIVE_LATEST_CHANGE = 'Y'

AND PAAM.ASSIGNMENT_STATUS_TYPE = 'ACTIVE'

AND PAAM.ASSIGNMENT_TYPE = 'O'

AND PAC.ALLOCATION_DATE BETWEEN PAAM.EFFECTIVE_START_DATE AND PAAM.EFFECTIVE_END_DATE

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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