|
--1.Drop the existing table
|
|
DROP TABLE CEN_OCS_FORM_10_D_SERVICE;
|
|
--2.Recreate the table with the desired column order
|
|
CREATE TABLE "UNIFIED_PORTAL"."CEN_OCS_FORM_10_D_SERVICE"
|
|
(
|
|
"C_OCS_FORM_10_D_SERVICE_ID" NUMBER(10,0) NOT NULL ENABLE,
|
|
"C_OCS_FORM_10_D_TEMP_ID" NUMBER(10,0),
|
|
"C_CLAIM_FORM_TYPE" NUMBER(10,0),
|
|
"C_MEMBER_ID" VARCHAR2(22 BYTE),
|
|
"C_MEMBER_SYS_ID" NUMBER(10,0),
|
|
"C_IS_PRIMARY" VARCHAR2(1),
|
|
"C_DOJ_FPS" DATE,
|
|
"C_DOE_FPS" DATE,
|
|
"C_DOJ_EPF" DATE,
|
|
"C_DOE_EPF" DATE,
|
|
"C_DOJ_EPS" DATE,
|
|
"C_DOE_EPS" DATE,
|
|
"C_NCP_DAYS" NUMBER(15,2),
|
|
"C_BIS_DAYS" NUMBER(15,2),
|
|
"C_REASON_OF_LEAVING_EPS" NUMBER(2,0),
|
|
"C_REASON_OF_LEAVING" NUMBER(2,0),
|
|
"C_STATUS" VARCHAR(200),
|
|
"C_IS_BENEFIT_TAKEN" VARCHAR2(1),
|
|
"C_CREATED_BY" VARCHAR2(50),
|
|
"C_CREATED_DATE" TIMESTAMP(6),
|
|
"C_CREATED_ON" VARCHAR2(20),
|
|
"C_RECORD_STATUS" NUMBER(1,0),
|
|
"C_NCP_PR_SEPT_2014" NUMBER(15,2),
|
|
"C_NCP_PST_AUG_2014" NUMBER(15,2),
|
|
"C_WAGES_ON_15NOV95" NUMBER(15,2),
|
|
"C_WAGES_AS_ON_31_AUG_2014" NUMBER(15,2),
|
|
"C_WAGES_ON_DATE_OF_EXIT" NUMBER(15,2),
|
|
"C_PAST_SERVICE_DD" NUMBER(4,0),
|
|
"C_PAST_SERVICE_MM" NUMBER(4,0),
|
|
"C_PAST_SERVICE_YY" NUMBER(4,0),
|
|
"C_PAST_SERVICE_TOTAL_DAYS" NUMBER(4,0),
|
|
"C_ACTUAL_SERVICE_DD_PR_SEPT_2014" NUMBER(4,0),
|
|
"C_ACTUAL_SERVICE_MM_PR_SEPT_2014" NUMBER(4,0),
|
|
"C_ACTUAL_SERVICE_YY_PR_SEPT_2014" NUMBER(4,0),
|
|
"C_ACTUAL_SERVICE_DD_PST_AUG_2014" NUMBER(4,0),
|
|
"C_ACTUAL_SERVICE_MM_PST_AUG_2014" NUMBER(4,0),
|
|
"C_ACTUAL_SERVICE_YY_PST_AUG_2014" NUMBER(4,0),
|
|
CONSTRAINT "CEN_OCS_FORM_10_D_SERVICE_PK" PRIMARY KEY ("C_OCS_FORM_10_D_SERVICE_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_CEN_OCS_FORM_10_D_MAS_ID" NUMBER(10,0),
|
|
-- "C_DOJ_FPS71" DATE,
|
|
-- "C_DOE_FPS71" DATE,
|
|
-- "C_DOJ_EPS95" DATE,
|
|
-- "C_DOE_EPS95" DATE,
|
|
-- "C_DOJ_EPF" DATE,
|
|
-- "C_DOE_EPF" DATE,
|
|
-- "C_IS_BENEFIT_TAKEN" VARCHAR2(1 BYTE),
|