--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),