immunization review systems

CREATE OR REPLACE TABLE FACT_POPULATION_RISK (
    pop_risk_key     INTEGER       NOT NULL  -- surrogate key,
    mbr_id           VARCHAR(20)   NOT NULL  -- member identifier,
    msrmt_prd_dt     DATE          NOT NULL  -- measurement period date,
    risk_score       DECIMAL(8,4)            -- risk score,
    risk_tier_cd     VARCHAR(10)             -- risk tier code,
    raf_score        DECIMAL(8,4)            -- RAF score,
    hcc_cnt          INTEGER                 -- HCC condition count,
    chrnc_cond_cnt   INTEGER                 -- chronic condition count,
    ed_visit_cnt     INTEGER                 -- ED visit count,
    admit_cnt        INTEGER                 -- admission count,
    gap_in_care_cnt  INTEGER                 -- gaps in care count,
    care_mgmt_flg    BOOLEAN                 -- care management flag,
    outreach_sts_cd  VARCHAR(20)             -- outreach status code,
    model_vrsn       VARCHAR(20)             -- risk model version,
    rec_creat_dt     TIMESTAMP     NOT NULL  -- record created date
);