Project

General

Profile

Actions

Activity #2751

open

Module #2640: Pension Claim - Phase III

Module #2665: PRO user claim entry

Sub module #2744: Development & unit testing

Sub module #2745: Pension Eligibility Check

DB Logic

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

Status:
New
Priority:
Normal
Assignee:
Category:
-
Start date:
06/24/2024
Due date:
06/28/2024 (over 2 years late)
% Done:

0%

Estimated time:
Planned Due Date:

Description

Design a JSON schema to return a flag with pension eligbility status, reasons if not eligbile, reference number from table; return member details + lookup required for form (enclosures master,..) if eligible. Share JSON format
Develop a database procedure to check:
All conditions for pension eligibility to check + whether member primary MID-establishment associates with the RO where the member submitting the claim.
If the UAN shows that one or more linked MIDs have not been transferred to the primary account, the claim will be rejected. The rejection letter will indicate the reason.
+ other mentioned in SRS PDF. Logic for overlapping services to implement

If not eligible for pension, insert a record in table (table?) and generate a reference number for the claim received. A new table to design.
Format of this reference number and table to sore ?
Return not-eligible reason list.

Return JSON with status and related data

Include JSON attributes for error codes/messages
Actions

Also available in: Atom PDF