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