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');