Project

General

Profile

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

DB Logic

Added by Thara S Pillai about 2 years ago. Updated about 2 years ago.

Status:
In Progress
Priority:
Normal
Assignee:
Category:
-
Start date:
07/28/2024
Due date:
% Done:

0%

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 open0 closed)

Activity #3028: Modify -- Revised requirement -- PoHW flagNewJiji P B07/28/2024

Actions
Activity #3029: Modify -- Revised requirement -- Retrieve PANNewJiji P B07/28/2024

Actions
Actions

Also available in: Atom PDF