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

Benefits Enrollment Query to find pending action with document type Designation supporting document

Summary:

Hi Team,

I need to validate a condition proof relation is submitted or not if document type = 'Designation supporting document' then I have to consider as yes else 'N'
Hence I need to pull the column from the pending actions in benefits.

Please share me the sample query please.

I need a clarification is there any relation between certifications and document types in the benefits.

Content (please ensure you mask any confidential information): when I am using the below code I am getting the document type as 'Dependent requires certification'

SELECT
pea.prtt_enrt_actn_id,
act.name AS action_type,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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