Can we access offer DFF to create eligibility profile?
Summary:
I am trying to create an eligibility profile to find if the worker had a DFF filled during their offer.
I have a SQL query to do this but am not sure we can use eligibility profile to access similar info. Is this possible?
Version (include the version you are using, if applicable):
25B
Code Snippet (add any code snippets that support your topic, if applicable):
SELECT
PAAM.PERSON_ID ID,
O.ATTRIBUTE_CHAR15
FROM
PER_ALL_ASSIGNMENTS_M PAAM
LEFT JOIN IRC_OFFERS O ON PAAM.ASSIGNMENT_ID = O.ASSIGNMENT_OFFER_ID
AND O.MOVE_TO_HR_STATUS IS NOT NULL