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,
0