|
--1.Drop the existing table
|
|
DROP TABLE CEN_OCS_FORM_10_D_TEMP;
|
|
--2.Recreate the table with the desired column order
|
|
CREATE TABLE "UNIFIED_PORTAL"."CEN_OCS_FORM_10_D_TEMP"
|
|
(
|
|
"C_OCS_FORM_10_D_TEMP_ID" NUMBER(10,0) NOT NULL ENABLE,
|
|
"C_CLAIM_ID" VARCHAR2(17),
|
|
"C_TRACKING_ID" NUMBER(18,0),
|
|
"C_CLAIM_MODE" CHAR(1),
|
|
"C_CLAIM_FORM_TYPE" VARCHAR2(3),
|
|
"C_CLAIM_SOURCE_FLAG" VARCHAR2(2 BYTE),
|
|
"C_CLAIM_BY" CHAR(1 BYTE),
|
|
"C_CLAIMANT_NAME" VARCHAR2(85 BYTE),
|
|
"C_CLAIM_RECEIPT_DATE" DATE,
|
|
"C_CLAIM_FORM_RECEIPT_DATE" DATE,
|
|
"C_UAN" NUMBER(12,0),
|
|
"C_MEMBER_NAME" VARCHAR2(85 BYTE),
|
|
"C_F_H_NAME" VARCHAR2(85 BYTE),
|
|
"C_F_H_FLAG" VARCHAR2(1 BYTE),
|
|
"C_DOB" DATE,
|
|
"C_DOB_FLAG" VARCHAR2(1 BYTE),
|
|
"C_AGE" NUMBER(2),
|
|
"C_AGE_AS_ON" NUMBER(4,0),
|
|
"C_DATE_OF_ATTAINING_58YRS" DATE,
|
|
"C_GENDER" VARCHAR2(1 BYTE),
|
|
"C_MARITAL_STATUS" VARCHAR2(1 BYTE),
|
|
"C_MOBILE_NO" NUMBER,
|
|
"C_EMAIL" VARCHAR2(50 BYTE),
|
|
"C_PERMANENT_ADDRESS1" VARCHAR2(40 BYTE),
|
|
"C_PERMANENT_ADDRESS2" VARCHAR2(40 BYTE),
|
|
"C_PERMANENT_CITY" VARCHAR2(40 BYTE),
|
|
"C_PERMANENT_DIST" VARCHAR2(40 BYTE),
|
|
"C_PERMANENT_DIST_ID" NUMBER(3,0),
|
|
"C_PERMANENT_STATE" VARCHAR2(40 BYTE),
|
|
"C_PERMANENT_STATE_ID" NUMBER(3,0),
|
|
"C_PERMANENT_PIN" VARCHAR2(11 BYTE),
|
|
"C_PRESENT_ADDRESS1" VARCHAR2(40 BYTE),
|
|
"C_PRESENT_ADDRESS2" VARCHAR2(40 BYTE),
|
|
"C_PRESENT_CITY" VARCHAR2(40 BYTE),
|
|
"C_PRESENT_DIST" VARCHAR2(40 BYTE),
|
|
"C_PRESENT_DIST_ID" NUMBER(3,0),
|
|
"C_PRESENT_STATE" VARCHAR2(40 BYTE),
|
|
"C_PRESENT_STATE_ID" NUMBER(3,0),
|
|
"C_PRESENT_PIN" VARCHAR2(11 BYTE),
|
|
"C_AADHAAR_NO" VARCHAR2(12 BYTE),
|
|
"C_PAN" VARCHAR2(10 BYTE),
|
|
"C_MEMBER_SYS_ID" NUMBER(10,0),
|
|
"C_MEMBER_ID" VARCHAR2(22 BYTE),
|
|
"C_AADHAAR_VERIFICATION_STATUS" CHAR(1 BYTE),
|
|
"C_KYC_PDF_EXISTS" CHAR(1 BYTE),
|
|
"C_AADHAAR_CONSENT_STATUS" CHAR(1 BYTE),
|
|
"C_AADHAAR_CONSENT_REF_ID" NUMBER(3,0),
|
|
"C_EKYC_STATUS" CHAR(1 BYTE),
|
|
"C_UID_TOKEN" VARCHAR2(72),
|
|
"C_DATE_OF_DEATH" DATE,
|
|
"C_UIDAI_RESPONSE_TRANS_ID" VARCHAR2(64),
|
|
"C_OFFICE_ID" NUMBER(5,0),
|
|
"C_OFFICE" VARCHAR2(3 BYTE),
|
|
"C_REGION" VARCHAR2(3 BYTE),
|
|
"C_ESTABLISHMENT_ID" VARCHAR2(15 BYTE),
|
|
"C_EST_SL_NO" NUMBER(10,0),
|
|
"C_EST_CODE" NUMBER(7,0),
|
|
"C_EST_EXT" VARCHAR2(3 BYTE),
|
|
"C_EMP_NO" VARCHAR2(7 BYTE),
|
|
"C_REASON_EXIT" VARCHAR2(1 BYTE),
|
|
"C_DOJ_FPS" DATE,
|
|
"C_DOE_FPS" DATE,
|
|
"C_DOJ_EPF" DATE,
|
|
"C_DOE_EPF" DATE,
|
|
"C_ELIGIBLE_SERVICE" NUMBER(2,0),
|
|
"C_ELIGIBLE_SERVICE_DD" NUMBER(2,0),
|
|
"C_ELIGIBLE_SERVICE_MM" NUMBER(2,0),
|
|
"C_ELIGIBLE_SERVICE_YY" NUMBER(2,0),
|
|
"C_PAST_SERVICE" NUMBER(2,0),
|
|
"C_PAST_SERVICE_DD" NUMBER(2,0),
|
|
"C_PAST_SERVICE_MM" NUMBER(2,0),
|
|
"C_PAST_SERVICE_YY" NUMBER(2,0),
|
|
"C_BIS" NUMBER,
|
|
"C_CUMM_ACTUAL_SERVICE" NUMBER(2,0),
|
|
"C_ACTUAL_SERVICE_DD" NUMBER(2,0),
|
|
"C_ACTUAL_SERVICE_MM" NUMBER(2,0),
|
|
"C_ACTUAL_SERVICE_YY" NUMBER(2,0),
|
|
"C_NCP" NUMBER(5,0),
|
|
"C_NCP_31082014" NUMBER(5,0),
|
|
"C_NCP_01092014" NUMBER(5,0),
|
|
"C_PENSION_SERVICE" NUMBER(2,0),
|
|
"C_PENSION_SERVICE_MM" NUMBER(2,0),
|
|
"C_PENSION_SERVICE_DD" NUMBER(2,0),
|
|
"C_P_SER_YY_6500" NUMBER(2,0),
|
|
"C_P_SER_MM_6500" NUMBER(2,0),
|
|
"C_P_SER_DD_6500" NUMBER(2,0),
|
|
"C_P_SER_PURE_DD_6500" NUMBER(10,0),
|
|
"C_P_SER_YY_15000" NUMBER(2,0),
|
|
"C_P_SER_MM_15000" NUMBER(2,0),
|
|
"C_P_SER_DD_15000" NUMBER(2,0),
|
|
"C_P_SER_PURE_DD_15000" NUMBER(10,0),
|
|
"C_WEIGHTAGE_PENSION_SERVICE" NUMBER(2,0),
|
|
"C_WEIGHTAGE_PENSION_SERVICE_6500" NUMBER(2,0),
|
|
"C_WEIGHTAGE_PENSION_SERVICE_15000" NUMBER(2,0),
|
|
"C_WAGE_151195" NUMBER(5,0),
|
|
"C_WAGE_AS_ON_31082014" NUMBER(5,0),
|
|
"C_WAGE_DATE_OF_EXIT" NUMBER(5,0),
|
|
"C_SCHEME_CERTIFICATE_FLAG" VARCHAR2(1 BYTE),
|
|
"C_NO_OF_SCHEME_CERTIFICATE" NUMBER(3,0),
|
|
"C_COUNT_SURR_SCHEME_CERT" NUMBER(3,0),
|
|
"C_COUNT_CLAIM_SURR_SCHEME_CERT" NUMBER(2,0),
|
|
"C_NOMIATION_ID" NUMBER(12,0),
|
|
"C_BANK_UAN_NEW_FLAG" VARCHAR2(1 BYTE),
|
|
"C_CLAIMANT_BANK_ID" NUMBER(3,0),
|
|
"C_CLAIMANT_NAME_AS_BANK" VARCHAR2(50 BYTE),
|
|
"C_CLAIMANT_ACC_NO" VARCHAR2(50 BYTE),
|
|
"C_CLAIMANT_IFSC" VARCHAR2(50 BYTE),
|
|
"C_CLAIMANT_BRN_NAME_ADDR" VARCHAR2(200 BYTE),
|
|
"ENCLOSURE_IDs" VARCHAR2(200 BYTE),
|
|
"ENCLOSURES" VARCHAR2(11 BYTE),
|
|
"C_PASSBOOK_CHEQUE_UPLOAD_PATH" VARCHAR2(200 BYTE),
|
|
"C_ROC_FLAG" VARCHAR2(1 BYTE),
|
|
"C_ROC_OPTION" VARCHAR2(1 BYTE),
|
|
"C_ROC_BENEFICIARY_NO" NUMBER(2,0),
|
|
"C_ROC_OTH_BENEFICIARY" VARCHAR2(85),
|
|
"C_ROC_OTH_BENEFICIARY_ACC_NO" VARCHAR2(30),
|
|
"C_ROC_OTH_BENEFICIARY_ADDRESS1" VARCHAR2(35),
|
|
"C_ROC_OTH_BENEFICIARY_ADDRESS2" VARCHAR2(35),
|
|
"C_ROC_OTH_BENEFICIARY_CITY" VARCHAR2(35),
|
|
"C_ROC_OTH_BENEFICIARY_DISTRICT_ID" NUMBER(4,0),
|
|
"C_ROC_OTH_BENEFICIARY_DISTRICT" VARCHAR2(35),
|
|
"C_ROC_OTH_BENEFICIARY_DOB" DATE ,
|
|
"C_ROC_OTH_BENEFICIARY_PIN" VARCHAR2(11),
|
|
"C_ROC_OTH_BENEFICIARY_STATE_ID" NUMBER(4,0),
|
|
"C_ROC_OTH_BENEFICIARY_STATE" VARCHAR2(35) ,
|
|
"C_ROC_OTH_BENEFICIARY_RELATION_ID" NUMBER(4,0),
|
|
"C_ROC_OTH_BENEFICIARY_RELATION" VARCHAR2(20),
|
|
"C_ROC_OTH_BENEFICIARY_ID_MARK" VARCHAR2(50),
|
|
"C_ROC_OTH_BANK_VERIFY_FLAG" VARCHAR2(1),
|
|
"C_BANK_OTH_VERIFY_PROCESS_ID" VARCHAR2(1),
|
|
"C_BANK_OTH_VERIFY_FAIL_REASON_ID" NUMBER(2,0),
|
|
"C_BANK_OTH_VERIFY_FAIL_REASON" VARCHAR2(50),
|
|
"C_REF_ID" VARCHAR2(256 BYTE),
|
|
"C_OTP_REF_ID" VARCHAR2(256 BYTE),
|
|
"C_BIO_REF_ID" VARCHAR2(256 BYTE),
|
|
"C_SESSION_ID" VARCHAR2(256 BYTE),
|
|
"C_SCHEME_CODE" VARCHAR2(3 Byte),
|
|
"C_PARA_CODE" VARCHAR2(2 Byte),
|
|
"C_SUB_PARA_CODE" VARCHAR2(2 Byte) ,
|
|
"C_SUB_PARA_CATEGORY" VARCHAR2(1 Byte),
|
|
"C_PENSION_PARA" VARCHAR2(100 BYTE),
|
|
"C_PEN_CASE_FLAG" VARCHAR2(1 BYTE),
|
|
"C_PENSION_TYPE" VARCHAR2(1 BYTE),
|
|
"C_ORIGINAL_PENSION" NUMBER(7,0),
|
|
"C_REDUCE_PEN_FLAG" VARCHAR2(1 BYTE),
|
|
"C_REDUCED_PENSION" NUMBER(7,0),
|
|
"C_REDUCED_PEN_DUE_TO_CUMMUTATION" NUMBER(7,0),
|
|
"C_REDUCED_PEN_DUE_TO_EARLY_PENSION" NUMBER(7,0),
|
|
"C_R_M_PEN" NUMBER(5,0),
|
|
"C_REDUCED_PENSION_OPT_DATE" DATE,
|
|
"C_DEFER_PENSION_OPTION" VARCHAR2(20 BYTE),
|
|
"C_DEFER_PENSION_OPTION_DATE" NUMBER(2,0),
|
|
"C_DEFER_PENSION_OPTION_AMOUNT" NUMBER(5,0),
|
|
"C_PENSION_RELIEF" NUMBER(7,0),
|
|
"C_WIDOW_PENSION" NUMBER(7,0),
|
|
"C_CHILD_PENSION" NUMBER(7,0),
|
|
"C_ORPHAN_PENSION" NUMBER(7,0),
|
|
"C_ROC_AMOUNT" NUMBER(8,0),
|
|
"C_ROC_WIDOW_AMOUNT" NUMBER(8,0),
|
|
"C_REDUCED_PEN_DUE_TO_ROC" NUMBER(7,0),
|
|
"C_COMM_OPT" VARCHAR2(1 BYTE),
|
|
"C_COMM_DATE" DATE,
|
|
"C_COM_ACT" NUMBER(5,0),
|
|
"C_PENSION_COMM_AMOUNT" NUMBER(9,2),
|
|
"C_PENSION_COMM_VALUE" NUMBER(7,2),
|
|
"C_COMM_PERCENT" NUMBER(10,2),
|
|
"C_DATE_PEN_PAY" DATE,
|
|
"C_PPO_DATE" DATE,
|
|
"C_CORRES_ADD_FLAG" VARCHAR2(1 BYTE),
|
|
"C_PENSION_PAY_AGENCY" VARCHAR2(1 BYTE),
|
|
"C_ACC_NO" VARCHAR2(30 BYTE),
|
|
"C_OLD_ACC_NO" VARCHAR2(50 BYTE),
|
|
"C_BANK_ID" NUMBER(5,0),
|
|
"C_BANK_NAME" VARCHAR2(256),
|
|
"C_BANK_CODE" VARCHAR2(10),
|
|
"C_BRANCH_NAME" VARCHAR2(256) ,
|
|
"C_BRANCH_CODE" VARCHAR2(10 BYTE),
|
|
"C_IFSC_CODE" VARCHAR2(10 BYTE),
|
|
"C_CBS_ACC_FLAG" VARCHAR2(1 BYTE),
|
|
"C_IDENTIFICATION_MARK" VARCHAR2(50 BYTE),
|
|
"C_LIFE_FLAG" VARCHAR2(1 BYTE),
|
|
"C_LIFE_CERTIFICATION_FLAG" VARCHAR2(1 BYTE),
|
|
"C_LIFE_CERTIFICATE_DUE_DATE" DATE,
|
|
"C_LIFE_CERTIFICATE_SUB_DATE" DATE,
|
|
"C_LIFE_CERTIFICATE_YEAR" VARCHAR2(10 BYTE),
|
|
"C_LAST_JP_TRAN_ID" VARCHAR2(10 BYTE),
|
|
"C_LC_INVALID_FLAG" VARCHAR2(1 BYTE),
|
|
"C_LC_VALID_UPTO" VARCHAR2(6 BYTE),
|
|
"C_MIGR_FLAG" VARCHAR2(1 BYTE),
|
|
"C_MIGR_DATE" DATE,
|
|
"C_SLIP_TYPE" VARCHAR2(3 BYTE),
|
|
"C_TRANSFER_DATE" DATE,
|
|
"C_TRANSFER_TYPE" VARCHAR2(1 BYTE),
|
|
"C_TRANSFER_OFFICE" VARCHAR2(3 BYTE),
|
|
"C_TRANSFER_REGION" VARCHAR2(3 BYTE),
|
|
"C_DESPATCH_DT_TR_OUT" DATE,
|
|
"C_DESPATCH_NO_TR_OUT" VARCHAR2(20 BYTE),
|
|
"C_PREV_REGION" VARCHAR2(3 BYTE),
|
|
"C_PREV_TRANSFER_REGION" VARCHAR2(3 BYTE),
|
|
"C_PREV_MEMBER_ID" VARCHAR2(22 BYTE),
|
|
"C_CREATED_REMARKS" VARCHAR2(100 BYTE),
|
|
"C_VERIFIED_BY" VARCHAR2(20 BYTE),
|
|
"C_VERIFIED_REMARKS" VARCHAR2(100 BYTE),
|
|
"C_VERIFIED_ON" VARCHAR2(20 BYTE),
|
|
"C_VERIFIED_DATE" DATE,
|
|
"C_CERTIFIED_BY" VARCHAR2(20 BYTE),
|
|
"C_CERTIFIED_REMARKS" VARCHAR2(100 BYTE),
|
|
"C_CERTIFIED_ON" VARCHAR2(20 BYTE),
|
|
"C_CERTIFIED_DATE" DATE,
|
|
"C_PENDING_REMARKS" VARCHAR2(100 BYTE),
|
|
"C_WORKLEVEL" NUMBER(2,0),
|
|
"C_PPO_NO" VARCHAR2(13 BYTE),
|
|
"C_PPO_TYPE" VARCHAR2(1 BYTE),
|
|
"C_OLD_PPO_NO" VARCHAR2(13 BYTE),
|
|
"C_PREV_PPO_NO" VARCHAR2(13 BYTE),
|
|
"C_PREV_OLD_PPO_NO" VARCHAR2(13 BYTE),
|
|
"C_WKLY_FLAG" VARCHAR2(1 BYTE),
|
|
"C_NON_REMARRIAGE_FLAG" VARCHAR2(1 BYTE),
|
|
"C_REJECT_REMARKS" VARCHAR2(100 BYTE),
|
|
"C_REJECTORRELEASE" VARCHAR2(2 BYTE),
|
|
"C_RLF_REF" DATE,
|
|
"C_FLAG_SPECIAL" VARCHAR2(1),
|
|
"C_WS_CREATED_BY" VARCHAR2(20 BYTE),
|
|
"C_WS_CREATED_DATE" DATE,
|
|
"C_WS_CREATED_ON" VARCHAR2(20 BYTE),
|
|
"C_WS_CREATED_REMARKS" VARCHAR2(100 BYTE),
|
|
"C_WS_VERIFIED_BY" VARCHAR2(20 BYTE),
|
|
"C_WS_VERIFIED_DATE" DATE,
|
|
"C_WS_VERIFIED_ON" VARCHAR2(20 BYTE),
|
|
"C_WS_VERIFIED_REMARKS" VARCHAR2(1000 BYTE),
|
|
"C_WS_APPROVED_BY" VARCHAR2(20 BYTE),
|
|
"C_WS_APPROVED_DATE" VARCHAR2(20 BYTE),
|
|
"C_WS_APPROVED_ON" VARCHAR2(20 BYTE),
|
|
"C_WS_APPROVED_REMARKS" VARCHAR2(100 BYTE),
|
|
"C_WS_CERTIFIED_BY" VARCHAR2(20 BYTE),
|
|
"C_WS_CERTIFIED_DATE" DATE,
|
|
"C_WS_CERTIFIED_ON" VARCHAR2(20 BYTE),
|
|
"C_WS_CERTIFIED_REMARKS" VARCHAR2(100 BYTE),
|
|
"C_PPO_CREATED_BY" VARCHAR2(20 BYTE),
|
|
"C_PPO_CREATED_DATE" DATE,
|
|
"C_PPO_CREATED_ON" VARCHAR2(20 BYTE),
|
|
"C_PPO_CREATED_REMARKS" VARCHAR2(100 BYTE),
|
|
"C_PPO_VERIFIED_BY" VARCHAR2(20 BYTE),
|
|
"C_PPO_VERIFIED_DATE" DATE,
|
|
"C_PPO_VERIFIED_ON" VARCHAR2(20 BYTE),
|
|
"C_PPO_VERIFIED_REMARKS" VARCHAR2(100 BYTE),
|
|
"C_PPO_APPROVED_BY" VARCHAR2(20 BYTE),
|
|
"C_PPO_APPROVED_DATE" DATE,
|
|
"C_PPO_APPROVED_ON" VARCHAR2(20 BYTE),
|
|
"C_PPO_APPROVED_REMARKS" VARCHAR2(100 BYTE),
|
|
"C_PPO_CERTIFIED_BY" VARCHAR2(20 BYTE),
|
|
"C_PPO_CERTIFIED_DATE" DATE,
|
|
"C_PPO_CERTIFIED_ON" VARCHAR2(20 BYTE),
|
|
"C_PPO_CERTIFIED_REMARKS" VARCHAR2(100 BYTE),
|
|
"C_ESIGN_FLAG" VARCHAR2(2 BYTE),
|
|
"C_IDS_WS_PATH" VARCHAR2(1024 BYTE),
|
|
"C_REMARK" VARCHAR2(100 BYTE),
|
|
"C_SUBMITTED_BY_USER_ID" NUMBER(5,0),
|
|
"C_SUBMITTED_BY_USER_NAME" VARCHAR2(50 BYTE),
|
|
"C_SUBMITTED_BY_USER_ACTOR_ID" NUMBER(3,0),
|
|
"C_SUBMITTED_BY_IP_ADDRESS" VARCHAR2(35 BYTE),
|
|
"C_SUBMITTED_ON_TIMESTAMP" TIMESTAMP (6),
|
|
"C_LDAP_ID" NUMBER(12,0),
|
|
"C_PROCESS_ID" NUMBER(3,0),
|
|
"C_PROCESS_GROUP_ID" NUMBER(3,0),
|
|
"C_CRITERIA_ID" NUMBER(5,0),
|
|
"C_CRITERIA_FLOW_ID" NUMBER(5,0),
|
|
"C_APPROVING_ACTOR_LEVEL" VARCHAR2(3 BYTE),
|
|
"C_NEXT_USER_ID" NUMBER(12,0),
|
|
"C_IDS_WS_TRANSACTION_ID" VARCHAR2(30 BYTE),
|
|
"C_APPROVAL_ID" NUMBER(15,0),
|
|
"C_APPROVED_BY_ACTOR_ID" NUMBER(5,0),
|
|
"C_APPROVAL_TIMESTAMP" TIMESTAMP (6),
|
|
"C_APPROVED_BY_IP_ADD" VARCHAR2(256 BYTE),
|
|
"C_IS_PORTED_DATA" VARCHAR2(1),
|
|
"C_CREATED_BY" VARCHAR2(50 BYTE),
|
|
"C_CREATED_DATE" DATE,
|
|
"C_CREATED_ON" VARCHAR2(20 BYTE),
|
|
"C_APPROVED_BY" VARCHAR2(50 BYTE),
|
|
"C_APPROVED_DATE" DATE,
|
|
"C_APPROVED_ON" VARCHAR2(20 BYTE),
|
|
"C_RECORD_STATUS" NUMBER(1,0),
|
|
CONSTRAINT "CEN_OCS_FORM_10_D_TEMP_PK" PRIMARY KEY ("C_OCS_FORM_10_D_TEMP_ID")
|
|
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
|
|
TABLESPACE "UNIFIED_PORTAL" ENABLE
|
|
) SEGMENT CREATION DEFERRED
|
|
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
|
|
NOCOMPRESS LOGGING
|
|
TABLESPACE "UNIFIED_PORTAL" ;
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-- --"C_RELIEF_PAID_UPTO" NUMBER(6,0),
|
|
-- "C_EST_EXT" VARCHAR2(3 BYTE),
|
|
-- "C_DOB" DATE,
|
|
-- "C_AGE" NUMBER(2,0),
|
|
-- "C_DOJ_EPS71" DATE,
|
|
-- "C_DOJ_EPS" DATE,
|
|
-- "C_DOE" DATE,
|
|
-- "C_ORIGINAL_PENSION" NUMBER(7,0),
|
|
-- "C_ROC_BENEFICIARY" VARCHAR2(85 BYTE),
|
|
-- "C_ROC_BENEFICIARY_ACC_NO" VARCHAR2(30 BYTE),
|
|
-- --"C_ROC_PAY_DATE" DATE,
|
|
-- --"C_ROC_PAID_DATE" DATE,
|
|
-- --"C_PPO_STOP_DATE" DATE,
|
|
-- --"C_REASON_STOP" VARCHAR2(1 BYTE),
|
|
-- --"C_PENSION_REVISION_DATE" DATE,
|
|
-- "C_LC_INVALID_FLAG" VARCHAR2(1 BYTE),
|
|
-- "C_LC_VALID_UPTO" VARCHAR2(6 BYTE),
|
|
-- --"C_PENSION_START_STATUS" VARCHAR2(1 BYTE),
|
|
-- --"C_PENSION_LAST_PAID" VARCHAR2(1 BYTE),
|
|
-- --"C_DESPATCH_NO" VARCHAR2(20 BYTE),
|
|
-- --"C_DESPATCH_DT" DATE,
|
|
--
|
|
--
|
|
--
|
|
--
|
|
-- "C_CLAIM_FORM_TYPE" VARCHAR2(3 BYTE),
|
|
-- "C_ROC_BENEFICIARY_ADDRESS1" VARCHAR2(35 BYTE),
|
|
-- "C_ROC_BENEFICIARY_ADDRESS2" VARCHAR2(35 BYTE),
|
|
-- "C_ROC_BENEFICIARY_DISTRICT" VARCHAR2(35 BYTE),
|
|
-- "C_ROC_BENEFICIARY_DOB" DATE,
|
|
-- "C_ROC_BENEFICIARY_PIN" VARCHAR2(11 BYTE),
|
|
-- "C_ROC_BENEFICIARY_STATE" VARCHAR2(35 BYTE),
|
|
-- "C_ROC_BENEFICIARY_RELATION" VARCHAR2(20 BYTE),
|
|
-- "C_ROC_BENEFICIARY_ID_MARK" VARCHAR2(50 BYTE),
|
|
-- "C_APPROVED_REMARKS" VARCHAR2(100 BYTE),
|
|
--
|
|
--
|
|
--
|
|
--
|
|
--
|
|
-- --"C_PENSION_PAID_UPTO_BANK" VARCHAR2(6 BYTE),
|
|
-- --"C_PENSION_PAID_UPTO_EPFO" VARCHAR2(6 BYTE),
|
|
--
|
|
-- --"C_BENEFIT_TYPE" VARCHAR2(1 BYTE),
|
|
--
|
|
-- --"C_PENSION_RESTART_DATE" DATE,
|
|
--
|
|
--
|
|
-- --"C_MIN_PEN_ARR_PAID_UPTO" DATE,
|
|
-- --"C_MIN_PEN_ARR_PAID_DT" DATE,
|
|
--
|
|
-- --"C_COMM_ARREAR_FLAG" VARCHAR2(1 BYTE),
|
|
-- --"C_REST_COMM_AMT" NUMBER(6,0),
|
|
-- "COLUMN1" VARCHAR2(20 BYTE),
|
|
-- --"C_EXCESS_PAYMENT" NUMBER(10,0),
|
|
-- --"C_EXCESS_PAYMENT_ADJUSTED" NUMBER(10,0),
|
|
-- "C_ROC_BENEFICIARY_CITY" VARCHAR2(35 BYTE),
|
|
|