EPFO-PCP

• Develop DAO class, DB Procedure and UnitTest class to validate scheme certificate w.r.t scheme certificate number, member name, DOB and gender

• Rename package FORM_10D_CLAIM as PKG_FORM_10D_CLAIM

DB procedure: PKG_FORM_10D_CLAIM.VALIDATE_SCHEME_CERT

A scheme certificate may be associated with more than one Member IDs.

• "UNIFIED_PORTAL"."CEN_SCHEME_CERT_DTLS"
• "UNIFIED_PORTAL"."CEN_SCHEME_CERT_ISSUE_DETAILS"(Design document with table name as CEN_SCHEME_CERT_ISSUE_DETAILS)
• "UNIFIED_PORTAL"."CEN_SCH_CERT_SURR_DTLS"
• "UNIFIED_PORTAL"."CEN_SCHEME_CERT_APPROVAL_DTLS"
• "UNIFIED_PORTAL"."CEN_SCHEME_CERT_RECEIPT_DTLS"
• "UNIFIED_PORTAL"."CEN_SCHM_CERT_CLM_REISSUE_DTLS"
• "UNIFIED_PORTAL"."CEN_SCHEME_CERT_ISSUE_DTLS_LOG"
• "UNIFIED_PORTAL"."CEN_SCHM_CERT_CLM_REISSUE_LOG"
• "UNIFIED_PORTAL"."CEN_SCH_CERT_SURR_DTLS_LOG"

• IN_UAN
• IN_SC_NO
• IN_MEM_NAME
• IN_MEM_DOB
• IN_MEM_GENDER
• IN_SOURCE

• OUT_SCHEME_CERT_VALID (Y or N)
• OUT_NOT_VALID_MSG
• OUT_OPR_STATUS (SUCCESS or FAIL)
• OUT_ERROR_MESSAGES
• OUT_SC_NO
  (the following in array)
• OUT_MEMBER_IDS
• OUT_MEMBER_NAME
• OUT_MEMBER_DOB
• OUT_MEMBER_GENDER
• OUT_DOJ_EPF
• OUT_DOE_EPF
• OUT_DOJ_FPS
• OUT_DOE_FPS
• OUT_NCP
• OUT_BIS
• OUT_REASON_LEAVING

• UNIFIED_PENSION_ELIGIBILITY
• FORM_10D_CLAIM

Refer to the attachment for unit test class development

• Modify existing Database function to check for scheme certificate issue as per new table design shared by C-DAC, Pune.
• The table create script to improt from EPFO_PDB_CLONE Database.
• Simulate data in backend for the provided UAN.