
CREATE TABLE SNF_RPT (
       RPT_REC_NUM          NUMBER NOT NULL,
       RPT_STUS_CD          CHAR(1) NOT NULL,
       PRVDR_CTRL_TYPE_CD   CHAR(2) NULL,
       PRVDR_NUM            CHAR(6) NULL,
       FY_BGN_DT            DATE NULL,
       FY_END_DT            DATE NULL,
       PROC_DT              DATE NULL,
       INITL_RPT_SW         CHAR(1) NULL,
       LAST_RPT_SW          CHAR(1) NULL,
       FI_NUM               CHAR(5) NULL,
       TRNSMTL_NUM          CHAR(2) NULL,
       ADR_VNDR_CD          CHAR(1) NULL,
       FI_CREAT_DT          DATE NULL,
       UTIL_CD              CHAR(1) NULL,
       NPR_DT               DATE NULL,
       SPEC_IND             CHAR(1) NULL,
       FI_RCPT_DT           DATE NULL
);


CREATE TABLE SNF_RPT_ALPHNMRC (
       RPT_REC_NUM          NUMBER NOT NULL,
       WKSHT_CD             CHAR(7) NOT NULL,
       CLMN_NUM             CHAR(4) NOT NULL,
       LINE_NUM             CHAR(5) NOT NULL,
       ALPHNMRC_ITM_TXT     CHAR(40)  NULL
);


CREATE TABLE SNF_RPT_NMRC (
       RPT_REC_NUM          NUMBER NOT NULL,
       WKSHT_CD             CHAR(7) NOT NULL,
       CLMN_NUM             CHAR(4) NOT NULL,
       LINE_NUM             CHAR(5) NOT NULL,
       ITM_VAL_NUM          NUMBER NULL
);


