Advanced Pharmacy Practice Experience

CREATE OR REPLACE TABLE FACT_PHARMACY_CLAIM (
    rx_clm_key      INTEGER        NOT NULL  -- surrogate key,
    rx_clm_id       VARCHAR(50)    NOT NULL  -- pharmacy claim ID,
    mbr_key         INTEGER        NOT NULL  -- FK to DIM_MEMBER,
    ndc_cd          VARCHAR(11)              -- national drug code,
    drug_nm         VARCHAR(255)             -- drug name,
    drug_gnrc_ind   CHAR(1)                  -- generic indicator,
    days_sply_cnt   SMALLINT                 -- days supply count,
    qty_dspnd       DECIMAL(10,3)            -- quantity dispensed,
    rx_fill_dt      DATE                     -- fill date,
    formulary_tier  SMALLINT                 -- formulary tier,
    rx_cost_amt     DECIMAL(10,2)            -- total drug cost,
    mbr_pay_amt     DECIMAL(10,2)            -- member pay amount,
    plan_pay_amt    DECIMAL(10,2)            -- plan pay amount,
    prior_auth_ind  CHAR(1)                  -- prior auth required,
    load_dt         TIMESTAMP_NTZ  NOT NULL  -- load timestamp
);