disorder detail

CREATE OR REPLACE TABLE FACT_BH_ENCOUNTER (
    bh_enctr_key    INTEGER        NOT NULL  -- surrogate key,
    enctr_id        VARCHAR(50)    NOT NULL  -- encounter identifier,
    mbr_id          VARCHAR(20)    NOT NULL  -- member identifier,
    prvdr_npi       VARCHAR(10)              -- rendering provider NPI,
    enctr_dt        DATE           NOT NULL  -- encounter date,
    svc_type_cd     VARCHAR(20)              -- service type code,
    diag_cd         VARCHAR(7)               -- primary diagnosis code,
    diag_cd_2       VARCHAR(7)               -- secondary diagnosis code,
    bh_cond_cd      VARCHAR(20)              -- behavioral health condition,
    lvl_of_care_cd  VARCHAR(20)              -- level of care code,
    session_cnt     INTEGER                  -- session count,
    auth_nbr        VARCHAR(30)              -- authorization number,
    fac_type_cd     VARCHAR(20)              -- facility type code,
    paid_amt        DECIMAL(12,2)            -- paid amount,
    rec_creat_dt    TIMESTAMP      NOT NULL  -- record created date
);