Activity #2524
closedModule #2268: Pension Claim - Phase II
Sub module #2269: Online Member Claim
Sub module #2519: DAO, DB Procedure, Unit Test Module
Check pension eligibility
80%
Description
Develop DAO and Oracle DB Procedure to check eligibility for applying pension.
Develop unit test class
Input data format: IN_UAN
DB procedure: PKG_FORM_10D_CLAIM.isPensionEligible
-Check whether primary UAN (Check on field IS_PRIMARY of table UAN_REPOSITORY)
-whether benefit already taken including check on non primary UAN (BENEFIT_TAKEN_TYPE of table MEMBER)
-Any claim processing in progress (while table and field to check ?)
-Among all services in member table min DoJ EPF <= 1st Sep 2014. If beyond 1st Sep 2014, not eligible for pension
-All member IDs transferred. To check DB fields ?
If member does not belong to disabled category, check the following
-Minimum 10 years service (include Scheme Certificate surrender details. Tables and fields to check: ?)
if member belongs to disabled category, check the following. What all to check?
{
}
Handle errors using RAISE_APPLICATION_ERROR (Enclosing error messages within Z# and #Z)
RAISE_APPLICATION_ERROR(-20001, 'Z#UAN is not primary account.#Z');
RAISE_APPLICATION_ERROR(-20001,'Z#Not eligible for pension as Date of Joining EPFO is later than 1st Sep 2014.#Z');
Updated by Thara S Pillai about 2 years ago
ONLINE
BY MEMBER for Superannuation, Early/ deferred or Disability Pension
that is the three options available for a member
Conditions for filing:
a. The member has a primary account, Primary Member ID and Primary
UAN. Refer: Primary Account classification document
b. All linked MIDs not settled, are already transferred to the Primary
account. Additionally, if there is service against the settled MID account
the same will also have to be transferred.
c. Member has filed e-nomination
d. Based on the total services being claimed against the Primary Member
ID:
i. Services that are part of all the transferred MIDs.
ii. Services that have been linked up through surrender of Scheme
Certificate in the past.
iii. Services that are being claimed to be added through Scheme
Certificates being surrendered as part of claim filing.
Pension claim eligibility will be checked against the total service of all
above three for eligible service of 10 years. Only in case the reason for
exit against the Primary Member ID is Physical Disability, this condition
of eligible service will not be checked.
e. System will check for Member’s age, as on date of filing, to be over 50
years. Only in case of Physical Disability Pension as reason of exit
against the Primary Member ID, this condition of age will not be
checked.
f. Member has a valid bank account for all, self and all his eligible family
members as per the e-nomination he has filled.
g. Member should not be drawing member pension against any other PPO
(as linked with his Aadhaar). If any such member is trying to submit a
10D claim, system will prompt that he/she is already a pensioner and
will display the PPO Number.
Updated by Thara S Pillai about 2 years ago
- Due date changed from 05/02/2024 to 05/10/2024
Refer doc shared at http://10.176.14.22/EPFO-PCP/docs/PensionRequirements
Tables to refer:
"UNIFIED_PORTAL"."UAN_REPOSITORY"
"UNIFIED_PORTAL"."MEMBER"
"UNIFIED_PORTAL"."MEMBER_NOMINATION_DETAILS"
"UNIFIED_PORTAL"."MEM_NOMINATION_FAMILY_DETAILS"
"UNIFIED_PORTAL"."MEM_NOMINATION_FAMILY_DETAILS"
"UNIFIED_PORTAL"."CEN_OCS_FORM_10_D_MAS"
- The number of years of service may be hardcorded in DB function.
- The bank account details need not be checked as of now for pension eligibility check
The input in json format accepting a UAN. Refer coding guideline followed by Pune team for DB procedure/function coding.
The output in json format with uan, pension eligbility status, not_elig_status_code
Updated by Thara S Pillai about 2 years ago
Reason of Exit of the Pensionable Service; "UNIFIED_PORTAL"."MEMBER_EXIT_REASON" (REASON_CODE)
Updated by Jiji P B about 2 years ago
- Status changed from New to In Progress
- % Done changed from 0 to 80
Updated by Nisha Balakrishnan about 2 years ago
- Status changed from In Progress to Closed