VW_Medicare_SNF_QRP_NatMetricMapper

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

measure_code

varchar

null

metric_name

varchar

null

View Definition

CREATE VIEW dbo.VW_Medicare_SNF_QRP_NatMetricMapper AS

/*********************************************************************
Database:		DataCStore
View:			dbo.VW_Medicare_SNF_QRP_NatMetricMapper
Created:		2/9/2021
Description:	An aid to disambiguating and standardizing QRP measures.
                Contents provided by Carly Lemmo.
*********************************************************************/

    SELECT 'S_001_01_OBS_RATE'                              AS measure_code,
           'Application of Functional Assessment/Care Plan' AS metric_name
    UNION
    SELECT 'S_001_03_NATL_RATE'                             AS measure_code,
           'Application of Functional Assessment/Care Plan' AS metric_name
    UNION
    SELECT 'S_002_01_OBS_RATE'              AS measure_code,
           'Pressure Ulcers (New/worsened)' AS metric_name
    UNION
    SELECT 'S_004_01_PPR_PD_NAT_UNADJUST_AVG' AS measure_code,
           'Preventable Readmission'          AS metric_name
    UNION
    SELECT 'S_005_01_DTC_NAT_OBS_RATE' AS measure_code,
           'DC to Community'           AS metric_name
    UNION
    SELECT 'S_005_02_DTC_NAT_OBS_RATE' AS measure_code,
           'DC to Community'           AS metric_name
    UNION
    SELECT 'S_006_01_MSPB_SCORE_NATL'          AS measure_code,
           'Medicare Spending per Beneficiary' AS metric_name
    UNION
    SELECT 'S_007_02_NATL_RATE'  AS measure_code,
           'Drug Regimen Review' AS metric_name
    UNION
    SELECT 'S_013_01_OBS_RATE' AS measure_code,
           'Falls'             AS metric_name
    UNION
    SELECT 'S_013_02_NATL_RATE' AS measure_code,
           'Falls'              AS metric_name
    UNION
    SELECT 'S_022_02_NATL_RATE' AS measure_code,
           'Change Self-Care'   AS metric_name
    UNION
    SELECT 'S_023_02_NATL_RATE' AS measure_code,
           'Change Mobility'    AS metric_name
    UNION
    SELECT 'S_024_02_NATL_RATE'        AS measure_code,
           'Discharge Self-Care Score' AS metric_name
    UNION
    SELECT 'S_025_02_NATL_RATE'       AS measure_code,
           'Discharge Mobility Score' AS metric_name
    UNION
    SELECT 'S_038_02_NATL_RATE'    AS measure_code,
           'Pressure Ulcer/Injury' AS metric_name

Possibly Referenced Tables/Views

VW_Medicare_SNF_QRP_NatMetricMapper