DROP TABLE ERX.INBOUND_NCPDP_MSG_HIST CASCADE CONSTRAINTS ;

CREATE TABLE ERX.INBOUND_NCPDP_MSG_HIST
  (
    INBOUND_NCPDP_MSG_HIST_ID NUMBER NOT NULL ,
    INBOUND_NCPDP_MSG_ID      NUMBER NOT NULL ,
    MESSAGE_STATUS            VARCHAR2 (4) ,
    PATIENT_CHK_STATUS        VARCHAR2 (4) ,
    PROVIDER_CHK_STATUS       VARCHAR2 (4) ,
    DRUG_CHK_STATUS           VARCHAR2 (4) ,
    RUN_CNT					  NUMBER,
    UPDATED_DATE              DATE ,
    CREATED_DATE              DATE
  )
  LOGGING ;
CREATE UNIQUE INDEX ERX.IB_NCPDP_MSG_HIST_ID_IDX ON ERX.INBOUND_NCPDP_MSG_HIST
  (
    INBOUND_NCPDP_MSG_HIST_ID ASC
  )
  LOGGING ;
