Fetches custom compensation data (VALUE1) for a specific external/contingent worker for a given performance year from Oracle HCM’s flexible external worker data table. VALUE columns store customer-specific metrics like P4P amounts.
SELECT value1
FROM
CMP_EXTERNAL_WORKER_DATA
WHERE
--record_type_cd = 'Put Your Record Type name here'
and person_id = :{PARAMETER.PERSON_ID}
and value3 = :{PARAMETER.YEAR} Output Results
