create table config ( create_date TIMESTAMP(6) Not null, create_user VARCHAR2(15 BYTE) Not null, CSTM_FIELD1_NAME VARCHAR2(30 BYTE) , CSTM_FIELD1_VALUE VARCHAR2(100 BYTE) , CSTM_FIELD2_NAME VARCHAR2(30 BYTE) , CSTM_FIELD2_VALUE VARCHAR2(100 BYTE) , CSTM_FIELD3_NAME VARCHAR2(100 BYTE) , CSTM_FIELD3_VALUE VARCHAR2(100 BYTE) , CSTM_FIELD4_NAME VARCHAR2(100 BYTE) , CSTM_FIELD4_VALUE VARCHAR2(100 BYTE) , UPDT_DT TIMESTAMP(6) , UPDT_USER VARCHAR2(15 BYTE), VENDOR VARCHAR2(30 BYTE) ); Insert into CONFIG (CSTM_FIELD1_NAME,CSTM_FIELD1_VALUE,CSTM_FIELD2_NAME,CSTM_FIELD2_VALUE,VENDOR,create_user,create_date,UPDT_USER,UPDT_DT,CSTM_FIELD3_NAME,CSTM_FIELD3_VALUE,CSTM_FIELD4_NAME,CSTM_FIELD4_VALUE) values ('A_ACCOUNT_NUM','1127','MEAC_ACC_TYPE','D','CK_REFERENCE','AGP',to_timestamp('14-OCT-20 09.32.26.014999000 AM','DD-MON-RR HH.MI.SSXFF AM'),null,null,'REF_VALU','01',null,null); Insert into CONFIG (CSTM_FIELD1_NAME,CSTM_FIELD1_VALUE,CSTM_FIELD2_NAME,CSTM_FIELD2_VALUE,VENDOR,create_user,create_date,UPDT_USER,UPDT_DT,CSTM_FIELD3_NAME,CSTM_FIELD3_VALUE,CSTM_FIELD4_NAME,CSTM_FIELD4_VALUE) values ('A_ACCOUNT_NUM','1127','MEAC_ACC_TYPE','D','CK_REFERENCE','AGP',to_timestamp('14-OCT-20 09.32.26.014999000 AM','DD-MON-RR HH.MI.SSXFF AM'),null,null,'REF_VALU','05',null,null); Insert into CONFIG (CSTM_FIELD1_NAME,CSTM_FIELD1_VALUE,CSTM_FIELD2_NAME,CSTM_FIELD2_VALUE,VENDOR,create_user,create_date,UPDT_USER,UPDT_DT,CSTM_FIELD3_NAME,CSTM_FIELD3_VALUE,CSTM_FIELD4_NAME,CSTM_FIELD4_VALUE) values ('A_ACCOUNT_NUM','1128','MEAC_ACC_TYPE','L','CK_REFERENCE','AGP',to_timestamp('14-OCT-20 09.32.26.014999000 AM','DD-MON-RR HH.MI.SSXFF AM'),null,null,'REF_VALU','04',null,null); Insert into CONFIG (CSTM_FIELD1_NAME,CSTM_FIELD1_VALUE,CSTM_FIELD2_NAME,CSTM_FIELD2_VALUE,VENDOR,create_user,create_date,UPDT_USER,UPDT_DT,CSTM_FIELD3_NAME,CSTM_FIELD3_VALUE,CSTM_FIELD4_NAME,CSTM_FIELD4_VALUE) values ('A_ACCOUNT_NUM','22','MEAC_ACC_TYPE','D','CK_REFERENCE','AGP',to_timestamp('14-OCT-20 09.32.26.014999000 AM','DD-MON-RR HH.MI.SSXFF AM'),null,null,'REF_VALU','11',null,null); Insert into CONFIG (CSTM_FIELD1_NAME,CSTM_FIELD1_VALUE,CSTM_FIELD2_NAME,CSTM_FIELD2_VALUE,VENDOR,create_user,create_date,UPDT_USER,UPDT_DT,CSTM_FIELD3_NAME,CSTM_FIELD3_VALUE,CSTM_FIELD4_NAME,CSTM_FIELD4_VALUE) values ('A_ACCOUNT_NUM','36','MEAC_ACC_TYPE','D','CK_REFERENCE','AGP',to_timestamp('14-OCT-20 09.32.26.014999000 AM','DD-MON-RR HH.MI.SSXFF AM'),null,null,'REF_VALU','07',null,null); Insert into CONFIG (CSTM_FIELD1_NAME,CSTM_FIELD1_VALUE,CSTM_FIELD2_NAME,CSTM_FIELD2_VALUE,VENDOR,create_user,create_date,UPDT_USER,UPDT_DT,CSTM_FIELD3_NAME,CSTM_FIELD3_VALUE,CSTM_FIELD4_NAME,CSTM_FIELD4_VALUE) values ('A_ACCOUNT_NUM','37','MEAC_ACC_TYPE','D','CK_REFERENCE','AGP',to_timestamp('14-OCT-20 09.32.26.014999000 AM','DD-MON-RR HH.MI.SSXFF AM'),null,null,'REF_VALU','09',null,null); Insert into CONFIG (CSTM_FIELD1_NAME,CSTM_FIELD1_VALUE,CSTM_FIELD2_NAME,CSTM_FIELD2_VALUE,VENDOR,create_user,create_date,UPDT_USER,UPDT_DT,CSTM_FIELD3_NAME,CSTM_FIELD3_VALUE,CSTM_FIELD4_NAME,CSTM_FIELD4_VALUE) values ('A_ACCOUNT_NUM','38','MEAC_ACC_TYPE','L','CK_REFERENCE','AGP',to_timestamp('14-OCT-20 09.32.26.014999000 AM','DD-MON-RR HH.MI.SSXFF AM'),null,null,'REF_VALU','10',null,null); Insert into CONFIG (CSTM_FIELD1_NAME,CSTM_FIELD1_VALUE,CSTM_FIELD2_NAME,CSTM_FIELD2_VALUE,VENDOR,create_user,create_date,UPDT_USER,UPDT_DT,CSTM_FIELD3_NAME,CSTM_FIELD3_VALUE,CSTM_FIELD4_NAME,CSTM_FIELD4_VALUE) values ('A_ACCOUNT_NUM','47','MEAC_ACC_TYPE','L','CK_REFERENCE','AGP',to_timestamp('14-OCT-20 09.32.26.014999000 AM','DD-MON-RR HH.MI.SSXFF AM'),null,null,'REF_VALU','08',null,null); Insert into CONFIG (CSTM_FIELD1_NAME,CSTM_FIELD1_VALUE,CSTM_FIELD2_NAME,CSTM_FIELD2_VALUE,VENDOR,create_user,create_date,UPDT_USER,UPDT_DT,CSTM_FIELD3_NAME,CSTM_FIELD3_VALUE,CSTM_FIELD4_NAME,CSTM_FIELD4_VALUE) values ('A_ACCOUNT_NUM','9000','MEAC_ACC_TYPE','L','CK_REFERENCE','AGP',to_timestamp('14-OCT-20 09.32.26.014999000 AM','DD-MON-RR HH.MI.SSXFF AM'),null,null,'REF_VALU','02',null,null); Insert into CONFIG (CSTM_FIELD1_NAME,CSTM_FIELD1_VALUE,CSTM_FIELD2_NAME,CSTM_FIELD2_VALUE,VENDOR,create_user,create_date,UPDT_USER,UPDT_DT,CSTM_FIELD3_NAME,CSTM_FIELD3_VALUE,CSTM_FIELD4_NAME,CSTM_FIELD4_VALUE) values ('A_ACCOUNT_NUM','9006','MEAC_ACC_TYPE','L','CK_REFERENCE','AGP',to_timestamp('14-OCT-20 09.32.26.014999000 AM','DD-MON-RR HH.MI.SSXFF AM'),null,null,'REF_VALU','12',null,null); Insert into CONFIG (CSTM_FIELD1_NAME,CSTM_FIELD1_VALUE,CSTM_FIELD2_NAME,CSTM_FIELD2_VALUE,VENDOR,create_user,create_date,UPDT_USER,UPDT_DT,CSTM_FIELD3_NAME,CSTM_FIELD3_VALUE,CSTM_FIELD4_NAME,CSTM_FIELD4_VALUE) values ('A_ACCOUNT_NUM','9007','MEAC_ACC_TYPE','D','CK_REFERENCE','AGP',to_timestamp('14-OCT-20 09.32.26.014999000 AM','DD-MON-RR HH.MI.SSXFF AM'),null,null,'REF_VALU','03',null,null); Insert into CONFIG (CSTM_FIELD1_NAME,CSTM_FIELD1_VALUE,CSTM_FIELD2_NAME,CSTM_FIELD2_VALUE,VENDOR,create_user,create_date,UPDT_USER,UPDT_DT,CSTM_FIELD3_NAME,CSTM_FIELD3_VALUE,CSTM_FIELD4_NAME,CSTM_FIELD4_VALUE) values ('A_ACCOUNT_NUM','9008','MEAC_ACC_TYPE','L','CK_REFERENCE','AGP',to_timestamp('14-OCT-20 09.32.26.014999000 AM','DD-MON-RR HH.MI.SSXFF AM'),null,null,'REF_VALU','06',null,null); CREATE TABLE ELIGIBILITY ( CS_ID VARCHAR2(4 BYTE) NoT NULL, PD_CAT VARCHAR2(1 BYTE) NoT NULL, CSPI_ID VARCHAR2(8 BYTE) NoT NULL, EXCD_ID VARCHAR2(3 BYTE) NoT NULL, GREG_CK NUMBER(10,0) NoT NULL, EMI_CK NUMBER(10,0) NoT NULL, EMPE_BL_ELIG_IND_NVL VARCHAR2(1 BYTE), EMPE_CREATE_DTM TIMESTAMP(3) NoT NULL, EMPE_EFF_DT TIMESTAMP(3) NoT NULL, EMPE_ELIG_IND VARCHAR2(1 BYTE) NoT NULL, EMPE_ELIG_OVR_IND VARCHAR2(1 BYTE) NoT NULL, EMPE_FI VARCHAR2(1 BYTE) NoT NULL, EMPE_HAS_MEDX_IND VARCHAR2(1 BYTE) NoT NULL, EMPE_HAS_WARN_CD VARCHAR2(1 BYTE) NoT NULL, EMPE_LOCK_TOKEN NUMBER(5,0) NoT NULL, EMPE_MCTR_RSN VARCHAR2(4 BYTE) NoT NULL, EMPE_PLAN_ENTRY_DT TIMESTAMP(3) NoT NULL, EMPE_PRCS_STS VARCHAR2(2 BYTE) NoT NULL, EMPE_SOURCE VARCHAR2(1 BYTE) NoT NULL, EMPE_SYS_INEL_CD VARCHAR2(4 BYTE) NoT NULL, EMPE_TERM_DT TIMESTAMP(3) NoT NULL, PDPD_ID VARCHAR2(8 BYTE) NoT NULL, SGSG_CK NUMBER(10,0) NoT NULL ); Insert into ELIGIBILITY (EMI_CK,PD_CAT,EMPE_EFF_DT,EMPE_TERM_DT,EMPE_CREATE_DTM,CS_ID,GREG_CK,SGSG_CK,CSPI_ID,PDPD_ID,EMPE_ELIG_IND,EXCD_ID,EMPE_MCTR_RSN,EMPE_SYS_INEL_CD,EMPE_FI,EMPE_ELIG_OVR_IND,EMPE_HAS_MEDX_IND,EMPE_HAS_WARN_CD,EMPE_PRCS_STS,EMPE_SOURCE,EMPE_PLAN_ENTRY_DT,EMPE_LOCK_TOKEN,EMPE_BL_ELIG_IND_NVL) values (137972150,'M',to_timestamp('01-APR-08 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('30-APR-08 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('09-MAY-20 02.56.58.036000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'CD01',7,0,'GANB0000','GABASIC1','Y',' ',' ',' ','C',' ',' ',' ',' ','S',to_timestamp('01-APR-08 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),1,'Y'); Insert into ELIGIBILITY (EMI_CK,PD_CAT,EMPE_EFF_DT,EMPE_TERM_DT,EMPE_CREATE_DTM,CS_ID,GREG_CK,SGSG_CK,CSPI_ID,PDPD_ID,EMPE_ELIG_IND,EXCD_ID,EMPE_MCTR_RSN,EMPE_SYS_INEL_CD,EMPE_FI,EMPE_ELIG_OVR_IND,EMPE_HAS_MEDX_IND,EMPE_HAS_WARN_CD,EMPE_PRCS_STS,EMPE_SOURCE,EMPE_PLAN_ENTRY_DT,EMPE_LOCK_TOKEN,EMPE_BL_ELIG_IND_NVL) values (872364151,'M',to_timestamp('01-JAN-20 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('30-APR-18 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('29-APR-18 06.36.03.656000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'S500',53,0,'COSNP002','COS01400','N','S23',' ','S13','*',' ',' ',' ',' ','S',to_timestamp('01-MAY-18 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),1,null); Insert into ELIGIBILITY (EMI_CK,PD_CAT,EMPE_EFF_DT,EMPE_TERM_DT,EMPE_CREATE_DTM,CS_ID,GREG_CK,SGSG_CK,CSPI_ID,PDPD_ID,EMPE_ELIG_IND,EXCD_ID,EMPE_MCTR_RSN,EMPE_SYS_INEL_CD,EMPE_FI,EMPE_ELIG_OVR_IND,EMPE_HAS_MEDX_IND,EMPE_HAS_WARN_CD,EMPE_PRCS_STS,EMPE_SOURCE,EMPE_PLAN_ENTRY_DT,EMPE_LOCK_TOKEN,EMPE_BL_ELIG_IND_NVL) values (758951,'M',to_timestamp('01-OCT-05 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('28-FEB-06 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('24-FEB-06 08.19.55.233000000 PM','DD-MON-RR HH.MI.SSXFF AM'),'CD01',4,82,'TXAPRGWM','TXBASIC2','Y',' ',' ',' ','C',' ',' ',' ',' ','S',to_timestamp('01-OCT-05 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),1,null); Insert into ELIGIBILITY (EMI_CK,PD_CAT,EMPE_EFF_DT,EMPE_TERM_DT,EMPE_CREATE_DTM,CS_ID,GREG_CK,SGSG_CK,CSPI_ID,PDPD_ID,EMPE_ELIG_IND,EXCD_ID,EMPE_MCTR_RSN,EMPE_SYS_INEL_CD,EMPE_FI,EMPE_ELIG_OVR_IND,EMPE_HAS_MEDX_IND,EMPE_HAS_WARN_CD,EMPE_PRCS_STS,EMPE_SOURCE,EMPE_PLAN_ENTRY_DT,EMPE_LOCK_TOKEN,EMPE_BL_ELIG_IND_NVL) values (137972150,'M',to_timestamp('01-MAY-08 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('31-JAN-09 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('09-MAY-20 02.56.58.040000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'CD01',7,0,'GANB0001','GABASIC1','Y',' ',' ',' ','C',' ',' ',' ',' ','S',to_timestamp('01-APR-08 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),1,'Y'); Insert into ELIGIBILITY (EMI_CK,PD_CAT,EMPE_EFF_DT,EMPE_TERM_DT,EMPE_CREATE_DTM,CS_ID,GREG_CK,SGSG_CK,CSPI_ID,PDPD_ID,EMPE_ELIG_IND,EXCD_ID,EMPE_MCTR_RSN,EMPE_SYS_INEL_CD,EMPE_FI,EMPE_ELIG_OVR_IND,EMPE_HAS_MEDX_IND,EMPE_HAS_WARN_CD,EMPE_PRCS_STS,EMPE_SOURCE,EMPE_PLAN_ENTRY_DT,EMPE_LOCK_TOKEN,EMPE_BL_ELIG_IND_NVL) values (137972150,'M',to_timestamp('01-FEB-09 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('28-FEB-09 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('09-MAY-20 02.56.58.044000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'CD01',7,0,'GALIMF02','GABASIC1','Y',' ',' ',' ','C',' ',' ',' ',' ','S',to_timestamp('01-APR-08 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),1,'Y'); Insert into ELIGIBILITY (EMI_CK,PD_CAT,EMPE_EFF_DT,EMPE_TERM_DT,EMPE_CREATE_DTM,CS_ID,GREG_CK,SGSG_CK,CSPI_ID,PDPD_ID,EMPE_ELIG_IND,EXCD_ID,EMPE_MCTR_RSN,EMPE_SYS_INEL_CD,EMPE_FI,EMPE_ELIG_OVR_IND,EMPE_HAS_MEDX_IND,EMPE_HAS_WARN_CD,EMPE_PRCS_STS,EMPE_SOURCE,EMPE_PLAN_ENTRY_DT,EMPE_LOCK_TOKEN,EMPE_BL_ELIG_IND_NVL) values (872364251,'M',to_timestamp('01-JAN-20 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('30-APR-18 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('29-APR-18 06.36.05.029000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'S000',42,0,'CTSNP005','CTS00800','N','S23',' ','S13','*',' ',' ',' ',' ','S',to_timestamp('01-MAY-18 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),1,null); Insert into ELIGIBILITY (EMI_CK,PD_CAT,EMPE_EFF_DT,EMPE_TERM_DT,EMPE_CREATE_DTM,CS_ID,GREG_CK,SGSG_CK,CSPI_ID,PDPD_ID,EMPE_ELIG_IND,EXCD_ID,EMPE_MCTR_RSN,EMPE_SYS_INEL_CD,EMPE_FI,EMPE_ELIG_OVR_IND,EMPE_HAS_MEDX_IND,EMPE_HAS_WARN_CD,EMPE_PRCS_STS,EMPE_SOURCE,EMPE_PLAN_ENTRY_DT,EMPE_LOCK_TOKEN,EMPE_BL_ELIG_IND_NVL) values (137972150,'M',to_timestamp('01-MAR-09 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('31-DEC-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('09-MAY-20 02.56.58.048000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'CD01',7,0,'GALIMF02','GABASIC1','N','ST','LOE','ST',' ',' ',' ',' ',' ','S',to_timestamp('01-APR-08 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),1,'N'); Insert into ELIGIBILITY (EMI_CK,PD_CAT,EMPE_EFF_DT,EMPE_TERM_DT,EMPE_CREATE_DTM,CS_ID,GREG_CK,SGSG_CK,CSPI_ID,PDPD_ID,EMPE_ELIG_IND,EXCD_ID,EMPE_MCTR_RSN,EMPE_SYS_INEL_CD,EMPE_FI,EMPE_ELIG_OVR_IND,EMPE_HAS_MEDX_IND,EMPE_HAS_WARN_CD,EMPE_PRCS_STS,EMPE_SOURCE,EMPE_PLAN_ENTRY_DT,EMPE_LOCK_TOKEN,EMPE_BL_ELIG_IND_NVL) values (760101,'M',to_timestamp('01-OCT-05 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('28-FEB-06 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('24-FEB-06 08.19.55.903000000 PM','DD-MON-RR HH.MI.SSXFF AM'),'CD02',4,75,'TXAFEDMN','TXBASIC1','Y',' ',' ',' ','C',' ',' ',' ',' ','S',to_timestamp('01-OCT-05 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),1,null); Insert into ELIGIBILITY (EMI_CK,PD_CAT,EMPE_EFF_DT,EMPE_TERM_DT,EMPE_CREATE_DTM,CS_ID,GREG_CK,SGSG_CK,CSPI_ID,PDPD_ID,EMPE_ELIG_IND,EXCD_ID,EMPE_MCTR_RSN,EMPE_SYS_INEL_CD,EMPE_FI,EMPE_ELIG_OVR_IND,EMPE_HAS_MEDX_IND,EMPE_HAS_WARN_CD,EMPE_PRCS_STS,EMPE_SOURCE,EMPE_PLAN_ENTRY_DT,EMPE_LOCK_TOKEN,EMPE_BL_ELIG_IND_NVL) values (137972250,'M',to_timestamp('01-APR-08 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('31-MAY-08 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('09-MAY-20 02.56.58.167000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'CD01',7,0,'GARSMCH1','GABASIC1','Y',' ',' ',' ','C',' ',' ',' ',' ','S',to_timestamp('01-APR-08 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),1,'Y'); Insert into ELIGIBILITY (EMI_CK,PD_CAT,EMPE_EFF_DT,EMPE_TERM_DT,EMPE_CREATE_DTM,CS_ID,GREG_CK,SGSG_CK,CSPI_ID,PDPD_ID,EMPE_ELIG_IND,EXCD_ID,EMPE_MCTR_RSN,EMPE_SYS_INEL_CD,EMPE_FI,EMPE_ELIG_OVR_IND,EMPE_HAS_MEDX_IND,EMPE_HAS_WARN_CD,EMPE_PRCS_STS,EMPE_SOURCE,EMPE_PLAN_ENTRY_DT,EMPE_LOCK_TOKEN,EMPE_BL_ELIG_IND_NVL) values (3576051,'M',to_timestamp('01-NOV-06 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('31-JAN-07 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('29-JAN-07 06.44.50.373000000 PM','DD-MON-RR HH.MI.SSXFF AM'),'CD03',4,64,'TXAFEDMN','TXBASIC3','N','ST','07','ST','C',' ',' ',' ',' ','S',to_timestamp('01-OCT-05 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),1,null); Insert into ELIGIBILITY (EMI_CK,PD_CAT,EMPE_EFF_DT,EMPE_TERM_DT,EMPE_CREATE_DTM,CS_ID,GREG_CK,SGSG_CK,CSPI_ID,PDPD_ID,EMPE_ELIG_IND,EXCD_ID,EMPE_MCTR_RSN,EMPE_SYS_INEL_CD,EMPE_FI,EMPE_ELIG_OVR_IND,EMPE_HAS_MEDX_IND,EMPE_HAS_WARN_CD,EMPE_PRCS_STS,EMPE_SOURCE,EMPE_PLAN_ENTRY_DT,EMPE_LOCK_TOKEN,EMPE_BL_ELIG_IND_NVL) values (137972250,'M',to_timestamp('01-JUN-08 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('31-JUL-08 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('09-MAY-20 02.56.58.169000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'CD01',7,0,'GARSMCH1','GABASIC1','N','ST','LOE','ST',' ',' ',' ',' ',' ','S',to_timestamp('01-APR-08 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),1,'N'); Insert into ELIGIBILITY (EMI_CK,PD_CAT,EMPE_EFF_DT,EMPE_TERM_DT,EMPE_CREATE_DTM,CS_ID,GREG_CK,SGSG_CK,CSPI_ID,PDPD_ID,EMPE_ELIG_IND,EXCD_ID,EMPE_MCTR_RSN,EMPE_SYS_INEL_CD,EMPE_FI,EMPE_ELIG_OVR_IND,EMPE_HAS_MEDX_IND,EMPE_HAS_WARN_CD,EMPE_PRCS_STS,EMPE_SOURCE,EMPE_PLAN_ENTRY_DT,EMPE_LOCK_TOKEN,EMPE_BL_ELIG_IND_NVL) values (137972250,'M',to_timestamp('01-AUG-08 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('31-OCT-08 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('09-MAY-20 02.56.58.172000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'CD01',7,0,'GARSMCH1','GABASIC1','Y',' ',' ',' ','C',' ',' ',' ',' ','S',to_timestamp('01-APR-08 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),1,'Y'); CREATE TABLE GROUP ( SRC_ID TIMESTAMP(3) NoT nULL, CLC_ID VARCHAR2(2 BYTE) NoT nULL, CRCY_ID VARCHAR2(12 BYTE) NoT nULL, CS_ID VARCHAR2(4 BYTE) NoT nULL, EXCD_ID VARCHAR2(3 BYTE) NoT nULL, GREG_ADDR1 VARCHAR2(40 BYTE) NoT nULL, GREG_ADDR2 VARCHAR2(40 BYTE) NoT nULL, GREG_ADDR3 VARCHAR2(40 BYTE) NoT nULL, GREG_AUTONUM_IND VARCHAR2(1 BYTE) NoT nULL, GREG_BILL_LEVEL VARCHAR2(1 BYTE) NoT nULL, GREG_BL_CONV_DT TIMESTAMP(3) NoT nULL, GREG_CAP_BAT_STS NUMBER(10,0) NoT nULL, GREG_CAP_CONV_DT TIMESTAMP(3) NoT nULL, GREG_CAP_IND VARCHAR2(1 BYTE) NoT nULL, GREG_CITY VARCHAR2(19 BYTE) NoT nULL, GREG_CITY_XLOW VARCHAR2(8 BYTE) NoT nULL, GREG_CK NUMBER(10,0) NoT nULL, GREG_CONT_EFF_DT TIMESTAMP(3) NoT nULL, GREG_CONV_DT TIMESTAMP(3) NoT nULL, GREG_COUNTY VARCHAR2(20 BYTE) NoT nULL, GREG_CTRY_CD VARCHAR2(4 BYTE) NoT nULL, GREG_CURR_ANNV_DT TIMESTAMP(3) NoT nULL, GREG_DEN_CHT_IND VARCHAR2(1 BYTE) NoT nULL, GREG_EIN VARCHAR2(9 BYTE) NoT nULL, GREG_EMAIL VARCHAR2(40 BYTE) NoT nULL, GREG_ERIS_MMDD NUMBER(5,0) NoT nULL, GREG_EXTN_ADDR_IND VARCHAR2(1 BYTE) NoT nULL, GREG_FAX VARCHAR2(20 BYTE) NoT nULL, GREG_FAX_EXT VARCHAR2(4 BYTE) NoT nULL, GREG_ID VARCHAR2(8 BYTE) NoT nULL, GREG_ITS_CODE VARCHAR2(4 BYTE) NoT nULL, GREG_LAST_CAP_DT TIMESTAMP(3) NoT nULL, GREG_LMT_ADJ_MOS NUMBER(5,0) NoT nULL, GREG_LOCK_TOKEN NUMBER(5,0) NoT nULL, GREG_MCTR_LANG VARCHAR2(4 BYTE) NoT nULL, GREG_MCTR_PTYP VARCHAR2(4 BYTE) NoT nULL, GREG_MCTR_TRSN VARCHAR2(4 BYTE) NoT nULL, GREG_MCTR_TYPE VARCHAR2(4 BYTE) NoT nULL, GREG_MCTR_VIP VARCHAR2(4 BYTE) NoT nULL, GREG_NAME VARCHAR2(50 BYTE) NoT nULL, GREG_NAME_XLOW VARCHAR2(8 BYTE) NoT nULL, GREG_NEXT_ANNV_DT TIMESTAMP(3) NoT nULL, GREG_ORIG_EFF_DT TIMESTAMP(3) NoT nULL, GREG_PHONE VARCHAR2(20 BYTE) NoT nULL, GREG_PHONE_EXT VARCHAR2(4 BYTE) NoT nULL, GREG_POL_NO VARCHAR2(30 BYTE) NoT nULL, GREG_PREV_ANNV_DT TIMESTAMP(3) NoT nULL, GREG_PUP_IND_NVL VARCHAR2(1 BYTE) NoT nULL, GREG_RECD_DT TIMESTAMP(3) NoT nULL, GREG_RENEW_MMDD NUMBER(5,0) NoT nULL, GREG_RNST_DT TIMESTAMP(3) NoT nULL, GREG_RNST_TYPE VARCHAR2(1 BYTE) NoT nULL, GREG_RNST_VAL NUMBER(5,0) NoT nULL, GREG_RUNOUT_DT TIMESTAMP(3) NoT nULL, GREG_RUNOUT_EXCD VARCHAR2(3 BYTE) NoT nULL, GREG_STATE VARCHAR2(2 BYTE) NoT nULL, GREG_STS VARCHAR2(2 BYTE) NoT nULL, GREG_TERM_DT TIMESTAMP(3) NoT nULL, GREG_TERM_PREM_MOS NUMBER(5,0) NoT nULL, GREG_TOTAL_CONTR NUMBER(10,0) NoT nULL, GREG_TOTAL_ELIG NUMBER(10,0) NoT nULL, GREG_TOTAL_EMPL NUMBER(10,0) NoT nULL, GREG_TRANS_ACCEPT VARCHAR2(1 BYTE) NoT nULL, GREG_UNDW_USUS_ID VARCHAR2(10 BYTE) NoT nULL, GREG_ZIP VARCHAR2(11 BYTE) NoT nULL, MCAR_AREA_ID VARCHAR2(4 BYTE) NoT nULL, PAGR_CK NUMBER(10,0) NoT nULL, SYS_BITMAP_NVL NUMBER(10,0) SYS_DBUSER_ID VARCHAR2(48 BYTE) SYS_LAST_OFFSET_NVL VARCHAR2(100 BYTE) SYS_LAST_UPD_DTM TIMESTAMP(3) SYS_USUS_ID VARCHAR2(48 BYTE) SEQUENCE_NO NUMBER(5,0) NoT nULL ); Insert into "GROUP" (GREG_CK,CLC_ID,GREG_ID,PAGR_CK,GREG_NAME,GREG_ADDR1,GREG_ADDR2,GREG_ADDR3,GREG_CITY,GREG_STATE,GREG_ZIP,GREG_COUNTY,GREG_CTRY_CD,GREG_PHONE,GREG_PHONE_EXT,GREG_FAX,GREG_FAX_EXT,GREG_EMAIL,GREG_MCTR_TYPE,GREG_MCTR_VIP,MCAR_AREA_ID,CS_ID,GREG_STS,GREG_ORIG_EFF_DT,GREG_TERM_DT,GREG_MCTR_TRSN,EXCD_ID,GREG_RNST_DT,GREG_CONV_DT,GREG_RENEW_MMDD,GREG_PREV_ANNV_DT,GREG_CURR_ANNV_DT,GREG_NEXT_ANNV_DT,GREG_MCTR_PTYP,GREG_UNDW_USUS_ID,GREG_CAP_IND,GREG_LAST_CAP_DT,GREG_CAP_BAT_STS,GREG_BILL_LEVEL,GREG_LMT_ADJ_MOS,GREG_BL_CONV_DT,GREG_NAME_XLOW,GREG_CITY_XLOW,GREG_MCTR_LANG,GREG_EXTN_ADDR_IND,SEQUENCE_NO,GREG_TOTAL_EMPL,GREG_TOTAL_ELIG,GREG_TOTAL_CONTR,GREG_POL_NO,CRCY_ID,GREG_EIN,GREG_ERIS_MMDD,GREG_RECD_DT,GREG_DEN_CHT_IND,GREG_CAP_CONV_DT,GREG_RUNOUT_DT,GREG_RUNOUT_EXCD,GREG_TRANS_ACCEPT,GREG_ITS_CODE,GREG_AUTONUM_IND,GREG_CONT_EFF_DT,GREG_TERM_PREM_MOS,GREG_RNST_TYPE,GREG_RNST_VAL,GREG_LOCK_TOKEN,SRC_ID,SYS_LAST_UPD_DTM,SYS_USUS_ID,SYS_DBUSER_ID,SYS_BITMAP_NVL,SYS_LAST_OFFSET_NVL,GREG_PUP_IND_NVL) values (134,'AR','ARMCR000',0,'Arkansas Medicare','750 FIRST STREET, N.E.','SUITE 1120',' ','Washington','DC','20002','DISTRICT OF COLUMBIA','USA',' ',' ',' ',' ',' ','MDCR','G',' ',' ','AC',to_timestamp('01-JAN-19 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('31-DEC-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),' ',' ',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),1001,to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),' ',' ',' ',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),0,' ',12,to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'arkansas','washingt','None',' ',0,0,0,0,' ',' ',' ',101,to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'N',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('31-DEC-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),' ',' ',' ','Y',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),0,'N',0,1,to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('10-SEP-20 08.20.14.000000000 PM','DD-MON-RR HH.MI.SSXFF AM'),'APP_FCFG','APP_FCFG',null,null,'N'); Insert into "GROUP" (GREG_CK,CLC_ID,GREG_ID,PAGR_CK,GREG_NAME,GREG_ADDR1,GREG_ADDR2,GREG_ADDR3,GREG_CITY,GREG_STATE,GREG_ZIP,GREG_COUNTY,GREG_CTRY_CD,GREG_PHONE,GREG_PHONE_EXT,GREG_FAX,GREG_FAX_EXT,GREG_EMAIL,GREG_MCTR_TYPE,GREG_MCTR_VIP,MCAR_AREA_ID,CS_ID,GREG_STS,GREG_ORIG_EFF_DT,GREG_TERM_DT,GREG_MCTR_TRSN,EXCD_ID,GREG_RNST_DT,GREG_CONV_DT,GREG_RENEW_MMDD,GREG_PREV_ANNV_DT,GREG_CURR_ANNV_DT,GREG_NEXT_ANNV_DT,GREG_MCTR_PTYP,GREG_UNDW_USUS_ID,GREG_CAP_IND,GREG_LAST_CAP_DT,GREG_CAP_BAT_STS,GREG_BILL_LEVEL,GREG_LMT_ADJ_MOS,GREG_BL_CONV_DT,GREG_NAME_XLOW,GREG_CITY_XLOW,GREG_MCTR_LANG,GREG_EXTN_ADDR_IND,SEQUENCE_NO,GREG_TOTAL_EMPL,GREG_TOTAL_ELIG,GREG_TOTAL_CONTR,GREG_POL_NO,CRCY_ID,GREG_EIN,GREG_ERIS_MMDD,GREG_RECD_DT,GREG_DEN_CHT_IND,GREG_CAP_CONV_DT,GREG_RUNOUT_DT,GREG_RUNOUT_EXCD,GREG_TRANS_ACCEPT,GREG_ITS_CODE,GREG_AUTONUM_IND,GREG_CONT_EFF_DT,GREG_TERM_PREM_MOS,GREG_RNST_TYPE,GREG_RNST_VAL,GREG_LOCK_TOKEN,SRC_ID,SYS_LAST_UPD_DTM,SYS_USUS_ID,SYS_DBUSER_ID,SYS_BITMAP_NVL,SYS_LAST_OFFSET_NVL,GREG_PUP_IND_NVL) values (137,'02','OHEGR000',0,'TimkenSteel','1835 Dueber Avenue SW',' ',' ','Canton','OH','44706','STARK','USA',' ',' ',' ',' ','Eric.Murray@timkensteel.com','MDCR','B',' ',' ','AC',to_timestamp('01-JAN-19 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('31-DEC-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),' ',' ',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),1001,to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),' ',' ',' ',to_timestamp('31-DEC-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),0,'B',12,to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'timkenst','canton','None',' ',0,0,0,0,' ',' ',' ',101,to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'N',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('31-DEC-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),' ',' ',' ','Y',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),0,'N',0,1,to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('28-SEP-20 09.32.06.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'APP_FCFG','APP_FCFG',null,null,'N'); Insert into "GROUP" (GREG_CK,CLC_ID,GREG_ID,PAGR_CK,GREG_NAME,GREG_ADDR1,GREG_ADDR2,GREG_ADDR3,GREG_CITY,GREG_STATE,GREG_ZIP,GREG_COUNTY,GREG_CTRY_CD,GREG_PHONE,GREG_PHONE_EXT,GREG_FAX,GREG_FAX_EXT,GREG_EMAIL,GREG_MCTR_TYPE,GREG_MCTR_VIP,MCAR_AREA_ID,CS_ID,GREG_STS,GREG_ORIG_EFF_DT,GREG_TERM_DT,GREG_MCTR_TRSN,EXCD_ID,GREG_RNST_DT,GREG_CONV_DT,GREG_RENEW_MMDD,GREG_PREV_ANNV_DT,GREG_CURR_ANNV_DT,GREG_NEXT_ANNV_DT,GREG_MCTR_PTYP,GREG_UNDW_USUS_ID,GREG_CAP_IND,GREG_LAST_CAP_DT,GREG_CAP_BAT_STS,GREG_BILL_LEVEL,GREG_LMT_ADJ_MOS,GREG_BL_CONV_DT,GREG_NAME_XLOW,GREG_CITY_XLOW,GREG_MCTR_LANG,GREG_EXTN_ADDR_IND,SEQUENCE_NO,GREG_TOTAL_EMPL,GREG_TOTAL_ELIG,GREG_TOTAL_CONTR,GREG_POL_NO,CRCY_ID,GREG_EIN,GREG_ERIS_MMDD,GREG_RECD_DT,GREG_DEN_CHT_IND,GREG_CAP_CONV_DT,GREG_RUNOUT_DT,GREG_RUNOUT_EXCD,GREG_TRANS_ACCEPT,GREG_ITS_CODE,GREG_AUTONUM_IND,GREG_CONT_EFF_DT,GREG_TERM_PREM_MOS,GREG_RNST_TYPE,GREG_RNST_VAL,GREG_LOCK_TOKEN,SRC_ID,SYS_LAST_UPD_DTM,SYS_USUS_ID,SYS_DBUSER_ID,SYS_BITMAP_NVL,SYS_LAST_OFFSET_NVL,GREG_PUP_IND_NVL) values (109,'02','NYEGR003',0,'New York Medical College','40 Sunshine Cottage Road',' ',' ','Valhalla','NY','10595','WESTCHESTER','USA',' ',' ',' ',' ',' ','MDCR','B',' ',' ','TM',to_timestamp('01-JAN-19 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('30-JUN-20 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'GRT3',' ',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),10,to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),' ',' ',' ',to_timestamp('31-DEC-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),0,'B',12,to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'new york','valhalla','None',' ',0,0,0,0,' ',' ',' ',101,to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'N',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('31-DEC-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),' ',' ',' ','Y',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),0,'N',0,1,to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('28-SEP-20 09.32.06.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'APP_FCFG','APP_FCFG',null,null,'N'); Insert into "GROUP" (GREG_CK,CLC_ID,GREG_ID,PAGR_CK,GREG_NAME,GREG_ADDR1,GREG_ADDR2,GREG_ADDR3,GREG_CITY,GREG_STATE,GREG_ZIP,GREG_COUNTY,GREG_CTRY_CD,GREG_PHONE,GREG_PHONE_EXT,GREG_FAX,GREG_FAX_EXT,GREG_EMAIL,GREG_MCTR_TYPE,GREG_MCTR_VIP,MCAR_AREA_ID,CS_ID,GREG_STS,GREG_ORIG_EFF_DT,GREG_TERM_DT,GREG_MCTR_TRSN,EXCD_ID,GREG_RNST_DT,GREG_CONV_DT,GREG_RENEW_MMDD,GREG_PREV_ANNV_DT,GREG_CURR_ANNV_DT,GREG_NEXT_ANNV_DT,GREG_MCTR_PTYP,GREG_UNDW_USUS_ID,GREG_CAP_IND,GREG_LAST_CAP_DT,GREG_CAP_BAT_STS,GREG_BILL_LEVEL,GREG_LMT_ADJ_MOS,GREG_BL_CONV_DT,GREG_NAME_XLOW,GREG_CITY_XLOW,GREG_MCTR_LANG,GREG_EXTN_ADDR_IND,SEQUENCE_NO,GREG_TOTAL_EMPL,GREG_TOTAL_ELIG,GREG_TOTAL_CONTR,GREG_POL_NO,CRCY_ID,GREG_EIN,GREG_ERIS_MMDD,GREG_RECD_DT,GREG_DEN_CHT_IND,GREG_CAP_CONV_DT,GREG_RUNOUT_DT,GREG_RUNOUT_EXCD,GREG_TRANS_ACCEPT,GREG_ITS_CODE,GREG_AUTONUM_IND,GREG_CONT_EFF_DT,GREG_TERM_PREM_MOS,GREG_RNST_TYPE,GREG_RNST_VAL,GREG_LOCK_TOKEN,SRC_ID,SYS_LAST_UPD_DTM,SYS_USUS_ID,SYS_DBUSER_ID,SYS_BITMAP_NVL,SYS_LAST_OFFSET_NVL,GREG_PUP_IND_NVL) values (150,'02','CTEGR004',0,'Stratford Board of Education','1000 East Broadway',' ',' ','Stratford','CT','06615','FAIRFIELD','USA',' ',' ',' ',' ',' ','MDCR','B',' ',' ','AC',to_timestamp('01-JAN-19 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('31-DEC-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),' ',' ',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),1001,to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),' ',' ',' ',to_timestamp('31-DEC-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),0,'B',12,to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'stratfor','stratfor','None',' ',0,0,0,0,' ',' ',' ',101,to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'N',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('31-DEC-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),' ',' ',' ','Y',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),0,'N',0,1,to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('28-SEP-20 09.32.05.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'APP_FCFG','APP_FCFG',null,null,'N'); Insert into "GROUP" (GREG_CK,CLC_ID,GREG_ID,PAGR_CK,GREG_NAME,GREG_ADDR1,GREG_ADDR2,GREG_ADDR3,GREG_CITY,GREG_STATE,GREG_ZIP,GREG_COUNTY,GREG_CTRY_CD,GREG_PHONE,GREG_PHONE_EXT,GREG_FAX,GREG_FAX_EXT,GREG_EMAIL,GREG_MCTR_TYPE,GREG_MCTR_VIP,MCAR_AREA_ID,CS_ID,GREG_STS,GREG_ORIG_EFF_DT,GREG_TERM_DT,GREG_MCTR_TRSN,EXCD_ID,GREG_RNST_DT,GREG_CONV_DT,GREG_RENEW_MMDD,GREG_PREV_ANNV_DT,GREG_CURR_ANNV_DT,GREG_NEXT_ANNV_DT,GREG_MCTR_PTYP,GREG_UNDW_USUS_ID,GREG_CAP_IND,GREG_LAST_CAP_DT,GREG_CAP_BAT_STS,GREG_BILL_LEVEL,GREG_LMT_ADJ_MOS,GREG_BL_CONV_DT,GREG_NAME_XLOW,GREG_CITY_XLOW,GREG_MCTR_LANG,GREG_EXTN_ADDR_IND,SEQUENCE_NO,GREG_TOTAL_EMPL,GREG_TOTAL_ELIG,GREG_TOTAL_CONTR,GREG_POL_NO,CRCY_ID,GREG_EIN,GREG_ERIS_MMDD,GREG_RECD_DT,GREG_DEN_CHT_IND,GREG_CAP_CONV_DT,GREG_RUNOUT_DT,GREG_RUNOUT_EXCD,GREG_TRANS_ACCEPT,GREG_ITS_CODE,GREG_AUTONUM_IND,GREG_CONT_EFF_DT,GREG_TERM_PREM_MOS,GREG_RNST_TYPE,GREG_RNST_VAL,GREG_LOCK_TOKEN,SRC_ID,SYS_LAST_UPD_DTM,SYS_USUS_ID,SYS_DBUSER_ID,SYS_BITMAP_NVL,SYS_LAST_OFFSET_NVL,GREG_PUP_IND_NVL) values (194,'02','INEGR005',0,'RIPEA Insurance Trust','2415 Directors Row-Suite M',' ',' ','Indianapolis','IN','46241','MARION','USA',' ',' ',' ',' ',' ','MDCR','B',' ',' ','AC',to_timestamp('01-JAN-20 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('31-DEC-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),' ',' ',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),1001,to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),' ',' ',' ',to_timestamp('31-DEC-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),0,'B',12,to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'ripea in','indianap','None',' ',0,0,0,0,' ',' ',' ',101,to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'N',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('31-DEC-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),' ',' ',' ','Y',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),0,'N',0,1,to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('30-SEP-20 08.34.33.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'APP_FCFG','APP_FCFG',null,null,'N'); CREATE TABLE MEMBER ( SRC_ID TIMESTAMP(3) NoT NULL, GREG_CK NUMBER(10,0) NoT NULL, MCRL_EMI_CREL_CD VARCHAR2(2 BYTE) NoT NULL, EMI_BIRTH_DT TIMESTAMP(3) NoT NULL, EMI_CCC_END_DT TIMESTAMP(3) NoT NULL, EMI_CCC_START_DT TIMESTAMP(3) NoT NULL, EMI_CELL_PHONE VARCHAR2(20 BYTE) NoT NULL, EMI_CK NUMBER(10,0) NoT NULL, EMI_EDI_RE_CODE_NVL VARCHAR2(10 BYTE) , EMI_EDI_RE_SOURCE_NVL VARCHAR2(7 BYTE) , EMI_ELIG_DT TIMESTAMP(3) NoT NULL, EMI_EOI_TERM_DT TIMESTAMP(3) NoT NULL, EMI_EXC_CRED_DAYS NUMBER(5,0) NoT NULL, EMI_FAM_LINK_ID VARCHAR2(12 BYTE) NoT NULL, EMI_FIRST_NAME VARCHAR2(15 BYTE) NoT NULL, EMI_HEALTH_ID VARCHAR2(80 BYTE) NoT NULL, EMI_HICN VARCHAR2(12 BYTE) NoT NULL, EMI_HIST_LINK_ID VARCHAR2(12 BYTE) NoT NULL, EMI_ID_NAME VARCHAR2(6 BYTE) NoT NULL, EMI_LAST_NAME VARCHAR2(35 BYTE) NoT NULL, EMI_LAST_NAME_XLOW VARCHAR2(8 BYTE) NoT NULL, EMI_LATE_ENR_IND VARCHAR2(1 BYTE) NoT NULL, EMI_LOCK_TOKEN NUMBER(5,0) NoT NULL, EMI_MARITAL_STATUS VARCHAR2(1 BYTE) NoT NULL, EMI_MCTR_ATYP VARCHAR2(4 BYTE) NoT NULL, EMI_MCTR_CTZN_NVL VARCHAR2(4 BYTE) , EMI_MCTR_ETHN_NVL VARCHAR2(4 BYTE) , EMI_MCTR_GENP_NVL VARCHAR2(4 BYTE) , EMI_MCTR_LANG VARCHAR2(4 BYTE) NoT NULL, EMI_MCTR_RACE_NVL VARCHAR2(4 BYTE) , EMI_MCTR_STS VARCHAR2(4 BYTE) NoT NULL, EMI_MEDCD_NO VARCHAR2(20 BYTE) NoT NULL, EMI_MID_INIT VARCHAR2(1 BYTE) NoT NULL, EMI_NEW_SIG_DT TIMESTAMP(3) NoT NULL, EMI_ORIG_EFF_DT TIMESTAMP(3) NoT NULL, EMI_PRBL_EFF_DT TIMESTAMP(3) NoT NULL, EMI_PRBL_IND VARCHAR2(1 BYTE) NoT NULL, EMI_PREX_EFF_DT TIMESTAMP(3) NoT NULL, EMI_PREX_LIMIT1 NUMBER(5,0) NoT NULL, EMI_PREX_LIMIT2 NUMBER(5,0) NoT NULL, EMI_PREX_LIMIT3 NUMBER(5,0) NoT NULL, EMI_PREX_TERM_DT TIMESTAMP(3) NoT NULL, EMI_PRX_CRED_DAYS NUMBER(5,0) NoT NULL, EMI_QUALIFY_DT TIMESTAMP(3) NoT NULL, EMI_RECORD_NO VARCHAR2(11 BYTE) NoT NULL, EMI_REL VARCHAR2(1 BYTE) NoT NULL, EMI_SEX VARCHAR2(1 BYTE) NoT NULL, EMI_SFX NUMBER(5,0) NoT NULL, EMI_SSN VARCHAR2(9 BYTE) NoT NULL, EMI_TITLE VARCHAR2(10 BYTE) NoT NULL, EMI_WRK_PHONE VARCHAR2(20 BYTE) NoT NULL, EMI_WRK_PHONE_EXT VARCHAR2(4 BYTE) NoT NULL, MEMM_ROW_ID NUMBER(10,0) SBAD_TYPE_HOME VARCHAR2(1 BYTE) NoT NULL, SBAD_TYPE_MAIL VARCHAR2(1 BYTE) NoT NULL, SBAD_TYPE_WORK VARCHAR2(1 BYTE) NoT NULL, SBSB_CK NUMBER(10,0) NoT NULL, SYS_DBUSER_ID VARCHAR2(48 BYTE) , SYS_LAST_UPD_DTM TIMESTAMP(3) , SYS_USUS_ID VARCHAR2(48 BYTE) ); Insert into MEMBER (EMI_CK,GREG_CK,SBSB_CK,EMI_SFX,EMI_REL,EMI_ID_NAME,EMI_LAST_NAME,EMI_FIRST_NAME,EMI_MID_INIT,EMI_TITLE,EMI_ORIG_EFF_DT,EMI_SSN,EMI_SEX,EMI_BIRTH_DT,EMI_WRK_PHONE,EMI_WRK_PHONE_EXT,EMI_MCTR_STS,EMI_MCTR_LANG,EMI_RECORD_NO,EMI_LATE_ENR_IND,EMI_MARITAL_STATUS,EMI_HICN,EMI_MEDCD_NO,EMI_FAM_LINK_ID,SBAD_TYPE_HOME,SBAD_TYPE_MAIL,SBAD_TYPE_WORK,EMI_LAST_NAME_XLOW,EMI_CCC_START_DT,EMI_CCC_END_DT,EMI_PREX_EFF_DT,EMI_PRX_CRED_DAYS,EMI_EXC_CRED_DAYS,EMI_MCTR_ATYP,EMI_ELIG_DT,EMI_QUALIFY_DT,EMI_NEW_SIG_DT,EMI_PRBL_IND,EMI_PRBL_EFF_DT,EMI_EOI_TERM_DT,EMI_PREX_TERM_DT,EMI_PREX_LIMIT1,EMI_PREX_LIMIT2,EMI_PREX_LIMIT3,MCRL_EMI_CREL_CD,EMI_HIST_LINK_ID,EMI_CELL_PHONE,EMI_HEALTH_ID,EMI_LOCK_TOKEN,SRC_ID,SYS_LAST_UPD_DTM,SYS_USUS_ID,SYS_DBUSER_ID,MEMM_ROW_ID,EMI_MCTR_RACE_NVL,EMI_MCTR_ETHN_NVL,EMI_EDI_RE_CODE_NVL,EMI_EDI_RE_SOURCE_NVL,EMI_MCTR_GENP_NVL,EMI_MCTR_CTZN_NVL) values (201,4,200,0,'M',' ','Wilson','Willie','M',' ',to_timestamp('01-OCT-05 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'458177851','F',to_timestamp('06-JUL-00 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),' ',' ',' ','ENG',' ',' ',' ','455383075D','105717601','001057176','H','H',' ','wilson',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),0,0,' ',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'N',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('31-DEC-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('31-DEC-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),0,0,0,'M',' ',' ',' ',1,to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('15-JUL-20 09.16.47.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'FACETS','FACETS',null,null,null,null,null,null,null); Insert into MEMBER (EMI_CK,GREG_CK,SBSB_CK,EMI_SFX,EMI_REL,EMI_ID_NAME,EMI_LAST_NAME,EMI_FIRST_NAME,EMI_MID_INIT,EMI_TITLE,EMI_ORIG_EFF_DT,EMI_SSN,EMI_SEX,EMI_BIRTH_DT,EMI_WRK_PHONE,EMI_WRK_PHONE_EXT,EMI_MCTR_STS,EMI_MCTR_LANG,EMI_RECORD_NO,EMI_LATE_ENR_IND,EMI_MARITAL_STATUS,EMI_HICN,EMI_MEDCD_NO,EMI_FAM_LINK_ID,SBAD_TYPE_HOME,SBAD_TYPE_MAIL,SBAD_TYPE_WORK,EMI_LAST_NAME_XLOW,EMI_CCC_START_DT,EMI_CCC_END_DT,EMI_PREX_EFF_DT,EMI_PRX_CRED_DAYS,EMI_EXC_CRED_DAYS,EMI_MCTR_ATYP,EMI_ELIG_DT,EMI_QUALIFY_DT,EMI_NEW_SIG_DT,EMI_PRBL_IND,EMI_PRBL_EFF_DT,EMI_EOI_TERM_DT,EMI_PREX_TERM_DT,EMI_PREX_LIMIT1,EMI_PREX_LIMIT2,EMI_PREX_LIMIT3,MCRL_EMI_CREL_CD,EMI_HIST_LINK_ID,EMI_CELL_PHONE,EMI_HEALTH_ID,EMI_LOCK_TOKEN,SRC_ID,SYS_LAST_UPD_DTM,SYS_USUS_ID,SYS_DBUSER_ID,MEMM_ROW_ID,EMI_MCTR_RACE_NVL,EMI_MCTR_ETHN_NVL,EMI_EDI_RE_CODE_NVL,EMI_EDI_RE_SOURCE_NVL,EMI_MCTR_GENP_NVL,EMI_MCTR_CTZN_NVL) values (251,4,250,0,'M',' ','Lewis','Lillian',' ',' ',to_timestamp('01-OCT-05 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'467224588','F',to_timestamp('07-AUG-09 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),' ',' ',' ','ENG',' ',' ',' ','434036628D','105791001','001057910','H','H',' ','lewis',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),0,0,' ',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'N',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('31-DEC-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('31-DEC-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),0,0,0,'M',' ',' ',' ',0,to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),null,null,null,null,null,null,null,null,null,null); Insert into MEMBER (EMI_CK,GREG_CK,SBSB_CK,EMI_SFX,EMI_REL,EMI_ID_NAME,EMI_LAST_NAME,EMI_FIRST_NAME,EMI_MID_INIT,EMI_TITLE,EMI_ORIG_EFF_DT,EMI_SSN,EMI_SEX,EMI_BIRTH_DT,EMI_WRK_PHONE,EMI_WRK_PHONE_EXT,EMI_MCTR_STS,EMI_MCTR_LANG,EMI_RECORD_NO,EMI_LATE_ENR_IND,EMI_MARITAL_STATUS,EMI_HICN,EMI_MEDCD_NO,EMI_FAM_LINK_ID,SBAD_TYPE_HOME,SBAD_TYPE_MAIL,SBAD_TYPE_WORK,EMI_LAST_NAME_XLOW,EMI_CCC_START_DT,EMI_CCC_END_DT,EMI_PREX_EFF_DT,EMI_PRX_CRED_DAYS,EMI_EXC_CRED_DAYS,EMI_MCTR_ATYP,EMI_ELIG_DT,EMI_QUALIFY_DT,EMI_NEW_SIG_DT,EMI_PRBL_IND,EMI_PRBL_EFF_DT,EMI_EOI_TERM_DT,EMI_PREX_TERM_DT,EMI_PREX_LIMIT1,EMI_PREX_LIMIT2,EMI_PREX_LIMIT3,MCRL_EMI_CREL_CD,EMI_HIST_LINK_ID,EMI_CELL_PHONE,EMI_HEALTH_ID,EMI_LOCK_TOKEN,SRC_ID,SYS_LAST_UPD_DTM,SYS_USUS_ID,SYS_DBUSER_ID,MEMM_ROW_ID,EMI_MCTR_RACE_NVL,EMI_MCTR_ETHN_NVL,EMI_EDI_RE_CODE_NVL,EMI_EDI_RE_SOURCE_NVL,EMI_MCTR_GENP_NVL,EMI_MCTR_CTZN_NVL) values (301,4,300,0,'M',' ','Randle','Lucy',' ',' ',to_timestamp('01-OCT-05 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'466727063','F',to_timestamp('28-JUN-09 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),' ',' ',' ',' ',' ',' ',' ','461188625D','106536701','001065367','H','H',' ','randle',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),0,0,' ',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'N',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('31-DEC-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('31-DEC-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),0,0,0,'M',' ',' ',' ',1,to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JUL-11 09.17.40.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'GSUBRA2','GSUBRA2',null,null,null,null,null,null,null); Insert into MEMBER (EMI_CK,GREG_CK,SBSB_CK,EMI_SFX,EMI_REL,EMI_ID_NAME,EMI_LAST_NAME,EMI_FIRST_NAME,EMI_MID_INIT,EMI_TITLE,EMI_ORIG_EFF_DT,EMI_SSN,EMI_SEX,EMI_BIRTH_DT,EMI_WRK_PHONE,EMI_WRK_PHONE_EXT,EMI_MCTR_STS,EMI_MCTR_LANG,EMI_RECORD_NO,EMI_LATE_ENR_IND,EMI_MARITAL_STATUS,EMI_HICN,EMI_MEDCD_NO,EMI_FAM_LINK_ID,SBAD_TYPE_HOME,SBAD_TYPE_MAIL,SBAD_TYPE_WORK,EMI_LAST_NAME_XLOW,EMI_CCC_START_DT,EMI_CCC_END_DT,EMI_PREX_EFF_DT,EMI_PRX_CRED_DAYS,EMI_EXC_CRED_DAYS,EMI_MCTR_ATYP,EMI_ELIG_DT,EMI_QUALIFY_DT,EMI_NEW_SIG_DT,EMI_PRBL_IND,EMI_PRBL_EFF_DT,EMI_EOI_TERM_DT,EMI_PREX_TERM_DT,EMI_PREX_LIMIT1,EMI_PREX_LIMIT2,EMI_PREX_LIMIT3,MCRL_EMI_CREL_CD,EMI_HIST_LINK_ID,EMI_CELL_PHONE,EMI_HEALTH_ID,EMI_LOCK_TOKEN,SRC_ID,SYS_LAST_UPD_DTM,SYS_USUS_ID,SYS_DBUSER_ID,MEMM_ROW_ID,EMI_MCTR_RACE_NVL,EMI_MCTR_ETHN_NVL,EMI_EDI_RE_CODE_NVL,EMI_EDI_RE_SOURCE_NVL,EMI_MCTR_GENP_NVL,EMI_MCTR_CTZN_NVL) values (351,4,350,0,'M',' ','Johnson','Miriam','R',' ',to_timestamp('01-OCT-05 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'449567174','F',to_timestamp('12-MAY-09 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),' ',' ',' ',' ',' ',' ',' ','449567174A','110047101','001100471','H','H',' ','johnson',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),0,0,' ',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'N',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('31-DEC-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('31-DEC-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),0,0,0,'M',' ',' ',' ',0,to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),null,null,null,null,null,null,null,null,null,null); Insert into MEMBER (EMI_CK,GREG_CK,SBSB_CK,EMI_SFX,EMI_REL,EMI_ID_NAME,EMI_LAST_NAME,EMI_FIRST_NAME,EMI_MID_INIT,EMI_TITLE,EMI_ORIG_EFF_DT,EMI_SSN,EMI_SEX,EMI_BIRTH_DT,EMI_WRK_PHONE,EMI_WRK_PHONE_EXT,EMI_MCTR_STS,EMI_MCTR_LANG,EMI_RECORD_NO,EMI_LATE_ENR_IND,EMI_MARITAL_STATUS,EMI_HICN,EMI_MEDCD_NO,EMI_FAM_LINK_ID,SBAD_TYPE_HOME,SBAD_TYPE_MAIL,SBAD_TYPE_WORK,EMI_LAST_NAME_XLOW,EMI_CCC_START_DT,EMI_CCC_END_DT,EMI_PREX_EFF_DT,EMI_PRX_CRED_DAYS,EMI_EXC_CRED_DAYS,EMI_MCTR_ATYP,EMI_ELIG_DT,EMI_QUALIFY_DT,EMI_NEW_SIG_DT,EMI_PRBL_IND,EMI_PRBL_EFF_DT,EMI_EOI_TERM_DT,EMI_PREX_TERM_DT,EMI_PREX_LIMIT1,EMI_PREX_LIMIT2,EMI_PREX_LIMIT3,MCRL_EMI_CREL_CD,EMI_HIST_LINK_ID,EMI_CELL_PHONE,EMI_HEALTH_ID,EMI_LOCK_TOKEN,SRC_ID,SYS_LAST_UPD_DTM,SYS_USUS_ID,SYS_DBUSER_ID,MEMM_ROW_ID,EMI_MCTR_RACE_NVL,EMI_MCTR_ETHN_NVL,EMI_EDI_RE_CODE_NVL,EMI_EDI_RE_SOURCE_NVL,EMI_MCTR_GENP_NVL,EMI_MCTR_CTZN_NVL) values (401,4,400,0,'M',' ','Lemond','Odile','O',' ',to_timestamp('01-OCT-05 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'449864674','F',to_timestamp('15-DEC-08 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),' ',' ',' ',' ',' ',' ',' ','457206629D','110558401','001105584','H','1',' ','lemond',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),0,0,' ',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'N',to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('31-DEC-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('31-DEC-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),0,0,0,'M',' ',' ',' ',0,to_timestamp('01-JAN-53 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('23-DEC-09 09.53.59.000000000 PM','DD-MON-RR HH.MI.SSXFF AM'),'faapp','FAAPP',null,null,null,null,null,null,null); Have created a staging table to load the data by joining these tables. For this process Have created a procedure as follows. CREATE OR REPLACE PROCEDURE SP_LOAD (P_BTCH_ID IN INTEGER, P_A_ACCOUNT_NUM IN INTEGER, P_YEAR IN INTEGER) AS l_cnt INTEGER; BEGIN EXECUTE IMMEDIATE 'TRUNCATE TABLE LOAD_TEMP'; INSERT INTO LOAD_TEMP ( MCO_NAME, DATE_OF_SERVICE, PATIENT_FIRST_NAME, PATIENT_LAST_NAME, DATE_OF_BIRTH, PATIENT_GENDER_CODE, EMI_SSN, FAMILY_ID, CARDHOLDER_ID_ALTERNATE, ACC_BLNC_QUALIFIER, ACC_APPLIED_AMOUNT, ACC_APPLIED_DIFFERENCE) (SELECT DISTINCT FUN_LOAD (EMP.EMI_CK), TO_CHAR (SYSDATE, 'YYYYMMDD'), EMP.EMI_FIRST_NAME, EMP.EMI_LAST_NAME, TO_CHAR (EMP.EMI_BIRTH_DT, 'YYYYMMDD'), (CASE WHEN EMP.EMI_SEX = 'U' THEN 0 WHEN EMP.EMI_SEX = 'M' THEN 1 WHEN EMP.EMI_SEX = 'F' THEN 2 END), EMP.EMI_SSN, EMP.EMI_FAM_LINK_ID, EMP.EMI_MEDCD_NO, XREF1.CSTM_FIELD3_VALUE AS ACC_BLNC_QUALIFIER, LOAD_FUN (EMP.EMI_CK, XREF1.CSTM_FIELD1_VALUE, P_YEAR), SUM (NVL (INSTG.ACC_APPLIED_AMOUNT1, 0)) OVER (PARTITION BY INSTG.CARDHOLDER_ID, INSTG.MCO_NAME) + SUM (NVL (STG.ACC_APPLIED_AMOUNT7, 0)) OVER (PARTITION BY STG.CARDHOLDER_ID, STG.MCO_NAME) FROM FACETS.CMC_EMPE_PRCS_ELIG MEPE INNER JOIN FACETS.CMC_GREG_GROUP GRGR ON GRGR.GREG_CK = MEPE.GREG_CK AND MEPE.EMPE_ELIG_IND = 'Y' AND (SYSDATE - 180 < MEPE.EMPE_EFF_DT) INNER JOIN FACETS.CMC_EMI_MEMBER MEME ON MEPE.EMI_CK = EMP.EMI_CK INNER JOIN CR_ACC_CONFIG XREF ON RFNC.CSTM_FIELD1_NAME = 'GREG_ID' AND RFNC.CSTM_FIELD1_VALUE = GRGR.GREG_ID AND RFNC.CSTM_FIELD2_NAME = 'CS_ID' AND RFNC.CSTM_FIELD2_VALUE = MEPE.CS_ID AND RFNC.CSTM_FIELD4_NAME = 'PDPD_ID' AND RFNC.CSTM_FIELD4_VALUE = MEPE.PDPD_ID AND RFNC.CSTM_FIELD3_NAME = 'CSPI_ID' AND RFNC.CSTM_FIELD3_VALUE = MEPE.CSPI_ID AND RFNC.VENDOR = 'TN_COVERKIDS' RIGHT JOIN CR_ACC_CONFIG XREF1 ON XREF1.VENDOR = 'CK_REFERENCE' LEFT JOIN RESP_STG INSTG ON EMP.EMI_SSN = INSTG.CARDHOLDER_ID AND INSTG.PROCESS_FLG != 'E' AND INSTG.MCO_NAME = FUN_LOAD (EMP.EMI_CK) LEFT JOIN CR_MCO_EXG_REQUEST_OUT_STG STG ON EMP.EMI_SSN = STG.CARDHOLDER_ID AND STG.PROCESS_FLG != 'E' AND STG.MCO_NAME = FUN_LOAD (EMP.EMI_CK) WHERE FUN_LOAD (EMP.EMI_CK) IN ('BCBS', 'UHC')); l_cnt := SQL%ROWCOUNT; AUDIT_PKGSTEP_INFO_ENTRY ( P_BTCH_ID, 'LOAD_TEMP Record Load count', l_cnt, 'SUCCEEDED'); COMMIT; END SP_LOAD; fUNCTION : LOAD_FUN Here is the definition of the function create or replace FUNCTION LOAD_FUN (P_EMI_CK IN INT, P_A_ACCOUNT_NUM IN INT, P_YEAR IN INT) RETURN NUMBER IS L_AMT NUMBER := 0; BEGIN WITH TEMP0 AS (SELECT DISTINCT MIN ( CASE WHEN MCOEX.BENEFIT_EFFECTIVE_DATE IS NOT NULL THEN MCOEX.BENEFIT_EFFECTIVE_DATE WHEN ATXR.ATSY_ID IS NULL THEN '00000000' WHEN TRIM (ATUF_TEXT1) IS NULL THEN TO_CHAR (EMPE_EFF_DT, 'YYYYMMDD') -- amerigroup elig start dat ELSE '00000000' END) OVER (PARTITION BY EMP.EMI_FAM_LINK_ID, EMP.EMI_CK) TNCK_ENROLL_DT, EMP.EMI_FAM_LINK_ID, EMP.EMI_CK, MEME1.EMI_CK F_EMI_CK FROM FACETS.CMC_EMI_MEMBER MEME JOIN CMC_EMI_MEMBER MEME1 ON TRIM(EMP.EMI_FAM_LINK_ID) IS NOT NULL AND EMP.EMI_FAM_LINK_ID = MEME1.EMI_FAM_LINK_ID AND EMP.EMI_CK = P_EMI_CK JOIN CMC_EMPE_PRCS_ELIG MEPE ON MEPE.EMI_CK = MEME1.EMI_CK AND MEPE.EMPE_ELIG_IND = 'Y' AND (SYSDATE BETWEEN MEPE.EMPE_EFF_DT AND MEPE.EMPE_TERM_DT) JOIN CMC_SBSB_SUBSC SBSB ON MEME1.SBSB_CK = SBSB.SBSB_CK LEFT JOIN CER_ATXR_ATTACH_U ATXR ON ATXR.SRC_ID = SBSB.SRC_ID AND ATXR.ATSY_ID = 'TNL0' LEFT JOIN CER_ATUF_USERFLD_D ATUF ON ATXR.ATSY_ID = ATUF.ATSY_ID AND ATXR.ATXR_DEST_ID = ATUF.ATXR_DEST_ID LEFT JOIN RESP_STG MCOEX ON MCOEX.CARDHOLDER_ID = MEME1.EMI_SSN ), TEMP1 AS (SELECT TEMP0.EMI_CK, TEMP0.EMI_FAM_LINK_ID, MATX.MATX_BEN_BEG_DT, MATX.MATX_ACC_TYPE, MATX.A_ACCOUNT_NUM, MATX.GREG_CK, MATX.MATX_SEQ_NO, MATX_AMT1 + MATX_CTR1 ACC_AMT, MAX (MATX_SEQ_NO) OVER (PARTITION BY MATX.EMI_CK, MATX.MATX_BEN_BEG_DT, MATX.MATX_ACC_TYPE, MATX.A_ACCOUNT_NUM, MATX.GREG_CK) M_MATX_SEQ_NO FROM TEMP0 TEMP0 JOIN FACETS.CMC_MATX_ACC_TXN MATX ON MATX.EMI_CK = TEMP0.F_EMI_CK AND MATX.A_ACCOUNT_NUM = P_A_ACCOUNT_NUM AND TO_CHAR (MATX.MATX_BEN_BEG_DT, 'YYYY') IN (P_YEAR, CASE WHEN TNCK_ENROLL_DT > (P_YEAR - 1)||'0101' THEN P_YEAR - 1 END)) SELECT SUM (ACC_AMT) OVER (PARTITION BY EMI_FAM_LINK_ID, MATX_ACC_TYPE, A_ACCOUNT_NUM, GREG_CK) INTO L_AMT FROM TEMP1 WHERE 1 = 1 AND M_MATX_SEQ_NO = MATX_SEQ_NO; RETURN NVL (L_AMT, 0); EXCEPTION WHEN NO_DATA_FOUND THEN RETURN 0; END; create table stage ( ACC_ACT_CD VARCHAR2(2 BYTE), ACC_APPLIED_AMOUNT1 VARCHAR2(10 BYTE), ACC_APPLIED_AMOUNT10 VARCHAR2(10 BYTE), ACC_APPLIED_AMOUNT11 VARCHAR2(10 BYTE), ACC_APPLIED_AMOUNT12 VARCHAR2(10 BYTE), ACC_APPLIED_AMOUNT2 VARCHAR2(10 BYTE), ACC_APPLIED_AMOUNT3 VARCHAR2(10 BYTE), ACC_APPLIED_AMOUNT4 VARCHAR2(10 BYTE), ACC_APPLIED_AMOUNT5 VARCHAR2(10 BYTE), ACC_APPLIED_AMOUNT6 VARCHAR2(10 BYTE), ACC_APPLIED_AMOUNT7 VARCHAR2(10 BYTE), ACC_APPLIED_AMOUNT8 VARCHAR2(10 BYTE), ACC_APPLIED_AMOUNT9 VARCHAR2(10 BYTE), ACC_BLNC_BENEFIT_TYPE VARCHAR2(1 BYTE), ACC_BLNC_COUNT VARCHAR2(2 BYTE), ACC_BLNC_QUALIFIER1 VARCHAR2(2 BYTE), ACC_BLNC_QUALIFIER10 VARCHAR2(2 BYTE), ACC_BLNC_QUALIFIER11 VARCHAR2(2 BYTE), ACC_BLNC_QUALIFIER12 VARCHAR2(2 BYTE), ACC_BLNC_QUALIFIER2 VARCHAR2(2 BYTE), ACC_BLNC_QUALIFIER3 VARCHAR2(2 BYTE), ACC_BLNC_QUALIFIER4 VARCHAR2(2 BYTE), ACC_BLNC_QUALIFIER5 VARCHAR2(2 BYTE), ACC_BLNC_QUALIFIER6 VARCHAR2(2 BYTE), ACC_BLNC_QUALIFIER7 VARCHAR2(2 BYTE), ACC_BLNC_QUALIFIER8 VARCHAR2(2 BYTE), ACC_BLNC_QUALIFIER9 VARCHAR2(2 BYTE), ACC_BENEFIT_PERIOD_AMOUNT1 VARCHAR2(10 BYTE), ACC_BENEFIT_PERIOD_AMOUNT10 VARCHAR2(10 BYTE), ACC_BENEFIT_PERIOD_AMOUNT11 VARCHAR2(10 BYTE), ACC_BENEFIT_PERIOD_AMOUNT12 VARCHAR2(10 BYTE), ACC_BENEFIT_PERIOD_AMOUNT2 VARCHAR2(10 BYTE), ACC_BENEFIT_PERIOD_AMOUNT3 VARCHAR2(10 BYTE), ACC_BENEFIT_PERIOD_AMOUNT4 VARCHAR2(10 BYTE), ACC_BENEFIT_PERIOD_AMOUNT5 VARCHAR2(10 BYTE), ACC_BENEFIT_PERIOD_AMOUNT6 VARCHAR2(10 BYTE), ACC_BENEFIT_PERIOD_AMOUNT7 VARCHAR2(10 BYTE), ACC_BENEFIT_PERIOD_AMOUNT8 VARCHAR2(10 BYTE), ACC_BENEFIT_PERIOD_AMOUNT9 VARCHAR2(10 BYTE), ACC_CHANGE_SOURCE_CODE VARCHAR2(1 BYTE), ACC_NETWORK_INDICATOR1 VARCHAR2(1 BYTE), ACC_NETWORK_INDICATOR10 VARCHAR2(1 BYTE), ACC_NETWORK_INDICATOR11 VARCHAR2(1 BYTE), ACC_NETWORK_INDICATOR12 VARCHAR2(1 BYTE), ACC_NETWORK_INDICATOR2 VARCHAR2(1 BYTE), ACC_NETWORK_INDICATOR3 VARCHAR2(1 BYTE), ACC_NETWORK_INDICATOR4 VARCHAR2(1 BYTE), ACC_NETWORK_INDICATOR5 VARCHAR2(1 BYTE), ACC_NETWORK_INDICATOR6 VARCHAR2(1 BYTE), ACC_NETWORK_INDICATOR7 VARCHAR2(1 BYTE), ACC_NETWORK_INDICATOR8 VARCHAR2(1 BYTE), ACC_NETWORK_INDICATOR9 VARCHAR2(1 BYTE), ACC_REFERENCE_TIME_STAMP VARCHAR2(26 BYTE), ACC_RMNG_BLNC1 VARCHAR2(10 BYTE), ACC_RMNG_BLNC10 VARCHAR2(10 BYTE), ACC_RMNG_BLNC11 VARCHAR2(10 BYTE), ACC_RMNG_BLNC12 VARCHAR2(10 BYTE), ACC_RMNG_BLNC2 VARCHAR2(10 BYTE), ACC_RMNG_BLNC3 VARCHAR2(10 BYTE), ACC_RMNG_BLNC4 VARCHAR2(10 BYTE), ACC_RMNG_BLNC5 VARCHAR2(10 BYTE), ACC_RMNG_BLNC6 VARCHAR2(10 BYTE), ACC_RMNG_BLNC7 VARCHAR2(10 BYTE), ACC_RMNG_BLNC8 VARCHAR2(10 BYTE), ACC_RMNG_BLNC9 VARCHAR2(10 BYTE), ACC_SPECIFIC_CATEGORY_TYPE VARCHAR2(2 BYTE), ACT_CD10_A VARCHAR2(1 BYTE), ACT_CD10_B VARCHAR2(1 BYTE), ACT_CD10_C VARCHAR2(1 BYTE), ACT_CD11_A VARCHAR2(1 BYTE), ACT_CD11_B VARCHAR2(1 BYTE), ACT_CD11_C VARCHAR2(1 BYTE), ACT_CD12_A VARCHAR2(1 BYTE), ACT_CD12_B VARCHAR2(1 BYTE), ACT_CD12_C VARCHAR2(1 BYTE), ACT_CD1_A VARCHAR2(1 BYTE), ACT_CD1_B VARCHAR2(1 BYTE), ACT_CD1_C VARCHAR2(1 BYTE), ACT_CD2_A VARCHAR2(1 BYTE), ACT_CD2_B VARCHAR2(1 BYTE), ACT_CD2_C VARCHAR2(1 BYTE), ACT_CD3_A VARCHAR2(1 BYTE), ACT_CD3_B VARCHAR2(1 BYTE), ACT_CD3_C VARCHAR2(1 BYTE), ACT_CD4_A VARCHAR2(1 BYTE), ACT_CD4_B VARCHAR2(1 BYTE), ACT_CD4_C VARCHAR2(1 BYTE), ACT_CD5_A VARCHAR2(1 BYTE), ACT_CD5_B VARCHAR2(1 BYTE), ACT_CD5_C VARCHAR2(1 BYTE), ACT_CD6_A VARCHAR2(1 BYTE), ACT_CD6_B VARCHAR2(1 BYTE), ACT_CD6_C VARCHAR2(1 BYTE), ACT_CD7_A VARCHAR2(1 BYTE), ACT_CD7_B VARCHAR2(1 BYTE), ACT_CD7_C VARCHAR2(1 BYTE), ACT_CD8_A VARCHAR2(1 BYTE), ACT_CD8_B VARCHAR2(1 BYTE), ACT_CD8_C VARCHAR2(1 BYTE), ACT_CD9_A VARCHAR2(1 BYTE), ACT_CD9_B VARCHAR2(1 BYTE), ACT_CD9_C VARCHAR2(1 BYTE), ACT_CD_A VARCHAR2(1 BYTE), ACT_CD_B VARCHAR2(1 BYTE), ACT_CD_C VARCHAR2(1 BYTE), ACT_CD_D VARCHAR2(1 BYTE), ACT_CD_E VARCHAR2(1 BYTE), ACT_CD_F VARCHAR2(1 BYTE), ACT_CD_G VARCHAR2(1 BYTE), ACT_CD_H VARCHAR2(1 BYTE), ACT_CD_I VARCHAR2(1 BYTE), ADJUSTMENT_REASON_CODE VARCHAR2(1 BYTE), AMOUNT_ATTRIBUTED_TO_SALES_TAX VARCHAR2(10 BYTE), AMOUNT_ATT_TO_PROCESSOR_FEE VARCHAR2(10 BYTE), AMOUNT_ATT_TO_PRODUCT_BRAND VARCHAR2(10 BYTE), AMOUNT_OF_COPAY VARCHAR2(10 BYTE), BTCH_ID NUMBER(38,0), BENEFIT_EFFECTIVE_DATE VARCHAR2(8 BYTE), BENEFIT_TERMINATION_DATE VARCHAR2(8 BYTE), BENEFIT_TYPE VARCHAR2(1 BYTE), BRAND_GENERIC_INDICATOR VARCHAR2(1 BYTE), CARDHOLDER_ID VARCHAR2(20 BYTE), CARDHOLDER_ID_ALTERNATE VARCHAR2(20 BYTE), CARDHOLDER_LAST_NAME VARCHAR2(35 BYTE), CARRIER_NAME VARCHAR2(9 BYTE), CLIENT_PASS_THROUGH VARCHAR2(50 BYTE), CONTRACT_NUMBER VARCHAR2(15 BYTE), create_date TIMESTAMP(3), create_user VARCHAR2(20 BYTE), CR_MCO_EXG_REQUEST_IN_STG_SID NUMBER, DATE_OF_BIRTH VARCHAR2(8 BYTE), DATE_OF_SERVICE VARCHAR2(8 BYTE), DAYS_SUPPLY VARCHAR2(3 BYTE), DIS_AS_WRN_DAW_PENALTY VARCHAR2(1 BYTE), DOC_REFERENCE_ID VARCHAR2(15 BYTE), DOC_REFERENCE_ID_QUALIFIER VARCHAR2(2 BYTE), FAMILY_ID VARCHAR2(20 BYTE), FORMULARY_STATUS VARCHAR2(1 BYTE), GROSS_AMOUNT_DUE VARCHAR2(10 BYTE), GROUP_ID VARCHAR2(15 BYTE), GROUP_ID_ALTERNATE VARCHAR2(15 BYTE), INSURANCE_CODE VARCHAR2(20 BYTE), INVOICED_AMOUNT VARCHAR2(10 BYTE), IN_NETWORK_INDICATOR VARCHAR2(1 BYTE), MCO_NAME VARCHAR2(100 BYTE), MIDDLE_INITIAL VARCHAR2(1 BYTE), OPTIONAL_DATA_INDICATOR VARCHAR2(1 BYTE), PATIENT_FIRST_NAME VARCHAR2(25 BYTE), PATIENT_GENDER_CODE VARCHAR2(1 BYTE), PATIENT_ID VARCHAR2(20 BYTE), PATIENT_LAST_NAME VARCHAR2(35 BYTE), PATIENT_PAY_AMOUNT VARCHAR2(10 BYTE), PATIENT_RELATIONSHIP_CODE VARCHAR2(1 BYTE), PATIENT_STATE_PROVINCE_ADDRESS VARCHAR2(2 BYTE), PENALTY_AMOUNT VARCHAR2(10 BYTE), PERSON_CODE VARCHAR2(3 BYTE), PROCESSOR_ROUTING_ID VARCHAR2(200 BYTE), PROCESS_FLG VARCHAR2(1 BYTE), PRODUCT_SERVICE_ID VARCHAR2(19 BYTE), PRODUCT_SERVICE_ID_QUALIFIER VARCHAR2(2 BYTE), PRODUCT_SERVICE_NAME VARCHAR2(30 BYTE), QUANTITY_DISPENSED VARCHAR2(10 BYTE), RECEIVER_ID VARCHAR2(30 BYTE), RECORD_LENGTH VARCHAR2(5 BYTE), RECORD_TYPE VARCHAR2(2 BYTE), REJECT_CODE VARCHAR2(3 BYTE), RSRVD1 VARCHAR2(20 BYTE), RSRVD2 VARCHAR2(13 BYTE), RSRVD3 VARCHAR2(90 BYTE), RSRVD4 VARCHAR2(20 BYTE), RSRVD5 VARCHAR2(24 BYTE), RSRVD6 VARCHAR2(23 BYTE), RSRVD7 VARCHAR2(48 BYTE), SENDER_ID VARCHAR2(30 BYTE), SENDER_REFERENCE_NUMBER VARCHAR2(30 BYTE), SERVICE_PROVIDER_ID VARCHAR2(15 BYTE), SERVICE_PROVIDER_ID_QUALIFIER VARCHAR2(2 BYTE), SUBMISSION_NUMBER VARCHAR2(4 BYTE), THERAPEUTIC_CLASS_CODE VARCHAR2(17 BYTE), THERAPEUTIC_CLASS_CODE_QUAL VARCHAR2(1 BYTE), TOTAL_AMOUNT_PAID VARCHAR2(10 BYTE), TRANSACTION_ID VARCHAR2(30 BYTE), TRANSACTION_ID_CROSS_REFERENCE VARCHAR2(30 BYTE), TRANSACTION_RESPONSE_STATUS VARCHAR2(1 BYTE), TRNSM_DATE VARCHAR2(8 BYTE), TRNSM_FILE_TYPE VARCHAR2(2 BYTE), TRNSM_ID VARCHAR2(50 BYTE), TRNSM_TIME VARCHAR2(8 BYTE), RELEASE_NO VARCHAR2(2 BYTE) );