Confirm Start Date for Pending workers created outside ORC
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