Activity #2634: DB Logic - EPFO-PCP - Health and Technology Group

Actions

Activity #2634

open

Module #2640: Pension Claim - Phase III

Module #2663: Online Member Claim

Sub module #2622: Development & unit testing

Sub module #2629: Fetch member details for pension claim form

Status:

In Progress

Priority:

Normal

Assignee:

Category:

Start date:

07/28/2024

Due date:

% Done:

Estimated time:

(Total: 0:00 h)

Planned Due Date:

Description

Develop a DB procedure to return query responses in JSON format with member details.

Include JSON attributes for error codes/messages
Modify to check whether the UAN linked bank account is verified or not. Include a new JSON attribute for that.
Modify the procedure to include service-wise grouping
Modify to include a new attribute in services for dangling services to list services to transfer/delink (based on primary UAN..services without primary MID)
Develop a DB function to implement the logic for pension type determination and return to procedure. A master for pension type to refer for pension type code to return.

Subtasks 2 (2 open — 0 closed)