Can we access offer DFF to create eligibility profile? — 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

Can we access offer DFF to create eligibility profile?

edited Aug 18, 2025 2:50PM in Benefits 1 comment

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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