VW_Medicare_SNF_QRP_MetricMapper - DataCStore Database

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

measure_code

varchar

null

detail_measure_code

varchar

null

metric_name

varchar

null

reported_on_carecompare

varchar

null

View Definition

CREATE VIEW dbo.VW_Medicare_SNF_QRP_MetricMapper AS

/*********************************************************************
Database:		DataCStore
View:			dbo.VW_Medicare_SNF_QRP_MetricMapper
Created:		2/8/2021
Description:	An aid to disambiguating and standardizing QRP measures.
                Contents provided by Carly Lemmo.
*********************************************************************/

    SELECT 'S_001_01_DENOMINATOR'                           AS measure_code,
           'Functional Assessment/Care Plan Denominator'    AS detail_measure_code,
           'Application of Functional Assessment/Care Plan' AS metric_name,
           'n'                                              AS reported_on_carecompare
    UNION
    SELECT 'S_001_01_NUMERATOR'                             AS measure_code,
           'Functional Assessment/Care Plan Numerator'      AS detail_measure_code,
           'Application of Functional Assessment/Care Plan' AS metric_name,
           'n'                                              AS reported_on_carecompare
    UNION
    SELECT 'S_001_01_OBS_RATE'                              AS measure_code,
           'Functional Assessment/Care Plan Observed Rate'  AS detail_measure_code,
           'Application of Functional Assessment/Care Plan' AS metric_name,
           'y'                                              AS reported_on_carecompare
    UNION
    SELECT 'S_001_03_DENOMINATOR'                           AS measure_code,
           'Functional Assessment/Care Plan Denominator'    AS detail_measure_code,
           'Application of Functional Assessment/Care Plan' AS metric_name,
           'n'                                              AS reported_on_carecompare
    UNION
    SELECT 'S_001_03_NUMERATOR'                             AS measure_code,
           'Functional Assessment/Care Plan Numerator'      AS detail_measure_code,
           'Application of Functional Assessment/Care Plan' AS metric_name,
           'n'                                              AS reported_on_carecompare
    UNION
    SELECT 'S_001_03_OBS_RATE'                              AS measure_code,
           'Functional Assessment/Care Plan Observed Rate'  AS detail_measure_code,
           'Application of Functional Assessment/Care Plan' AS metric_name,
           'y'                                              AS reported_on_carecompare
    UNION
    SELECT 'S_002_01_ADJ_RATE'                            AS measure_code,
           'Pressure Ulcers (New/worsened) Adjusted Rate' AS detail_measure_code,
           'Pressure Ulcers (New/worsened)'               AS metric_name,
           'n'                                            AS reported_on_carecompare
    UNION
    SELECT 'S_002_01_DENOMINATOR'                       AS measure_code,
           'Pressure Ulcers (New/worsened) Denominator' AS detail_measure_code,
           'Pressure Ulcers (New/worsened)'             AS metric_name,
           'n'                                          AS reported_on_carecompare
    UNION
    SELECT 'S_002_01_NUMERATOR'                       AS measure_code,
           'Pressure Ulcers (New/worsened) Numerator' AS detail_measure_code,
           'Pressure Ulcers (New/worsened)'           AS metric_name,
           'n'                                        AS reported_on_carecompare
    UNION
    SELECT 'S_002_01_OBS_RATE'                            AS measure_code,
           'Pressure Ulcers (New/worsened) Observed Rate' AS detail_measure_code,
           'Pressure Ulcers (New/worsened)'               AS metric_name,
           'y'                                            AS reported_on_carecompare
    UNION
    SELECT 'S_004_01_PPR_PD_COMP_PERF' AS measure_code,
           'Readmission Comp Perf'     AS detail_measure_code,
           'Preventable Readmission'   AS metric_name,
           'n'                         AS reported_on_carecompare
    UNION
    SELECT 'S_004_01_PPR_PD_OBS'     AS measure_code,
           'Readmission Observed'    AS detail_measure_code,
           'Preventable Readmission' AS metric_name,
           'n'                       AS reported_on_carecompare
    UNION
    SELECT 'S_004_01_PPR_PD_OBS_READM' AS measure_code,
           'Readmission Numerator'     AS detail_measure_code,
           'Preventable Readmission'   AS metric_name,
           'n'                         AS reported_on_carecompare
    UNION
    SELECT 'S_004_01_PPR_PD_RSRR'    AS measure_code,
           'Readmission Adjusted'    AS detail_measure_code,
           'Preventable Readmission' AS metric_name,
           'y'                       AS reported_on_carecompare
    UNION
    SELECT 'S_004_01_PPR_PD_RSRR_2_5' AS measure_code,
           'Readmission RSRR_2_5'     AS detail_measure_code,
           'Preventable Readmission'  AS metric_name,
           'n'                        AS reported_on_carecompare
    UNION
    SELECT 'S_004_01_PPR_PD_RSRR_97_5' AS measure_code,
           'Readmission RSRR_97_5'     AS detail_measure_code,
           'Preventable Readmission'   AS metric_name,
           'n'                         AS reported_on_carecompare
    UNION
    SELECT 'S_004_01_PPR_PD_VOLUME'  AS measure_code,
           'Readmission Denominator' AS detail_measure_code,
           'Preventable Readmission' AS metric_name,
           'n'                       AS reported_on_carecompare
    UNION
    SELECT 'S_005_01_DTC_COMP_PERF'    AS measure_code,
           'DC to Community Comp Perf' AS detail_measure_code,
           'DC to Community'           AS metric_name,
           'n'                         AS reported_on_carecompare
    UNION
    SELECT 'S_005_01_DTC_NUMBER'       AS measure_code,
           'DC to Community Numerator' AS detail_measure_code,
           'DC to Community'           AS metric_name,
           'n'                         AS reported_on_carecompare
    UNION
    SELECT 'S_005_01_DTC_OBS_RATE'         AS measure_code,
           'DC to Community Observed Rate' AS detail_measure_code,
           'DC to Community'               AS metric_name,
           'n'                             AS reported_on_carecompare
    UNION
    SELECT 'S_005_01_DTC_RS_RATE'          AS measure_code,
           'DC to Community Adjusted Rate' AS detail_measure_code,
           'DC to Community'               AS metric_name,
           'y'                             AS reported_on_carecompare
    UNION
    SELECT 'S_005_01_DTC_RS_RATE_2_5' AS measure_code,
           'DC to Community Rate_2_5' AS detail_measure_code,
           'DC to Community'          AS metric_name,
           'n'                        AS reported_on_carecompare
    UNION
    SELECT 'S_005_01_DTC_RS_RATE_97_5' AS measure_code,
           'DC to Community Rate_97_5' AS detail_measure_code,
           'DC to Community'           AS metric_name,
           'n'                         AS reported_on_carecompare
    UNION
    SELECT 'S_005_01_DTC_VOLUME'         AS measure_code,
           'DC to Community Denominator' AS detail_measure_code,
           'DC to Community'             AS metric_name,
           'n'                           AS reported_on_carecompare
    UNION
    SELECT 'S_005_02_DTC_COMP_PERF'    AS measure_code,
           'DC to Community Comp Perf' AS detail_measure_code,
           'DC to Community'           AS metric_name,
           'n'                         AS reported_on_carecompare
    UNION
    SELECT 'S_005_02_DTC_NUMBER'       AS measure_code,
           'DC to Community Numerator' AS detail_measure_code,
           'DC to Community'           AS metric_name,
           'n'                         AS reported_on_carecompare
    UNION
    SELECT 'S_005_02_DTC_OBS_RATE'         AS measure_code,
           'DC to Community Observed Rate' AS detail_measure_code,
           'DC to Community'               AS metric_name,
           'n'                             AS reported_on_carecompare
    UNION
    SELECT 'S_005_02_DTC_RS_RATE'          AS measure_code,
           'DC to Community Adjusted Rate' AS detail_measure_code,
           'DC to Community'               AS metric_name,
           'y'                             AS reported_on_carecompare
    UNION
    SELECT 'S_005_02_DTC_RS_RATE_2_5' AS measure_code,
           'DC to Community Rate_2_5' AS detail_measure_code,
           'DC to Community'          AS metric_name,
           'n'                        AS reported_on_carecompare
    UNION
    SELECT 'S_005_02_DTC_RS_RATE_97_5' AS measure_code,
           'DC to Community Rate_97_5' AS detail_measure_code,
           'DC to Community'           AS metric_name,
           'n'                         AS reported_on_carecompare
    UNION
    SELECT 'S_005_02_DTC_VOLUME'         AS measure_code,
           'DC to Community Denominator' AS detail_measure_code,
           'DC to Community'             AS metric_name,
           'n'                           AS reported_on_carecompare
    UNION
    SELECT 'S_006_01_MSPB_NUMB'                       AS measure_code,
           'Medicare Spending per Beneficiary Number' AS detail_measure_code,
           'Medicare Spending per Beneficiary'        AS metric_name,
           'n'                                        AS reported_on_carecompare
    UNION
    SELECT 'S_006_01_MSPB_SCORE'                     AS measure_code,
           'Medicare Spending per Beneficiary Score' AS detail_measure_code,
           'Medicare Spending per Beneficiary'       AS metric_name,
           'y'                                       AS reported_on_carecompare
    UNION
    SELECT 'S_007_02_DENOMINATOR'            AS measure_code,
           'Drug Regimen Review Denominator' AS detail_measure_code,
           'Drug Regimen Review'             AS metric_name,
           'n'                               AS reported_on_carecompare
    UNION
    SELECT 'S_007_02_NUMERATOR'            AS measure_code,
           'Drug Regimen Review Numerator' AS detail_measure_code,
           'Drug Regimen Review'           AS metric_name,
           'n'                             AS reported_on_carecompare
    UNION
    SELECT 'S_007_02_OBS_RATE'                 AS measure_code,
           'Drug Regimen Review Observed Rate' AS detail_measure_code,
           'Drug Regimen Review'               AS metric_name,
           'y'                                 AS reported_on_carecompare
    UNION
    SELECT 'S_013_01_DENOMINATOR' AS measure_code,
           'Falls Denominator'    AS detail_measure_code,
           'Falls'                AS metric_name,
           'n'                    AS reported_on_carecompare
    UNION
    SELECT 'S_013_01_NUMERATOR' AS measure_code,
           'Falls Numerator'    AS detail_measure_code,
           'Falls'              AS metric_name,
           'n'                  AS reported_on_carecompare
    UNION
    SELECT 'S_013_01_OBS_RATE'   AS measure_code,
           'Falls Observed Rate' AS detail_measure_code,
           'Falls'               AS metric_name,
           'y'                   AS reported_on_carecompare
    UNION
    SELECT 'S_013_02_DENOMINATOR' AS measure_code,
           'Falls Denominator'    AS detail_measure_code,
           'Falls'                AS metric_name,
           'n'                    AS reported_on_carecompare
    UNION
    SELECT 'S_013_02_NUMERATOR' AS measure_code,
           'Falls Numerator'    AS detail_measure_code,
           'Falls'              AS metric_name,
           'n'                  AS reported_on_carecompare
    UNION
    SELECT 'S_013_02_OBS_RATE'   AS measure_code,
           'Falls Observed Rate' AS detail_measure_code,
           'Falls'               AS metric_name,
           'y'                   AS reported_on_carecompare
    UNION
    SELECT 'S_022_02_ADJ_CHG_SFCR_SCORE'     AS measure_code,
           'Change Self-Care Adjusted Score' AS detail_measure_code,
           'Change Self-Care'                AS metric_name,
           'y'                               AS reported_on_carecompare
    UNION
    SELECT 'S_022_02_DENOMINATOR'         AS measure_code,
           'Change Self-Care Denominator' AS detail_measure_code,
           'Change Self-Care'             AS metric_name,
           'n'                            AS reported_on_carecompare
    UNION
    SELECT 'S_022_02_OBS_CHG_SFCR_SCORE'     AS measure_code,
           'Change Self-Care Observed Score' AS detail_measure_code,
           'Change Self-Care'                AS metric_name,
           'n'                               AS reported_on_carecompare
    UNION
    SELECT 'S_023_02_ADJ_CHG_MOBL_SCORE'    AS measure_code,
           'Change Mobility Adjusted Score' AS detail_measure_code,
           'Change Mobility'                AS metric_name,
           'y'                              AS reported_on_carecompare
    UNION
    SELECT 'S_023_02_DENOMINATOR'        AS measure_code,
           'Change Mobility Denominator' AS detail_measure_code,
           'Change Mobility'             AS metric_name,
           'n'                           AS reported_on_carecompare
    UNION
    SELECT 'S_023_02_OBS_CHG_MOBL_SCORE'    AS measure_code,
           'Change Mobility Observed Score' AS detail_measure_code,
           'Change Mobility'                AS metric_name,
           'n'                              AS reported_on_carecompare
    UNION
    SELECT 'S_024_02_DENOMINATOR'                  AS measure_code,
           'Discharge Self-Care Score Denominator' AS detail_measure_code,
           'Discharge Self-Care Score'             AS metric_name,
           'n'                                     AS reported_on_carecompare
    UNION
    SELECT 'S_024_02_NUMERATOR'                  AS measure_code,
           'Discharge Self-Care Score Numerator' AS detail_measure_code,
           'Discharge Self-Care Score'           AS metric_name,
           'n'                                   AS reported_on_carecompare
    UNION
    SELECT 'S_024_02_OBS_RATE'                 AS measure_code,
           'Discharge Self-Care Observed Rate' AS detail_measure_code,
           'Discharge Self-Care Score'         AS metric_name,
           'y'                                 AS reported_on_carecompare
    UNION
    SELECT 'S_025_02_DENOMINATOR'                 AS measure_code,
           'Discharge Mobility Score Denominator' AS detail_measure_code,
           'Discharge Mobility Score'             AS metric_name,
           'n'                                    AS reported_on_carecompare
    UNION
    SELECT 'S_025_02_NUMERATOR'                 AS measure_code,
           'Discharge Mobility Score Numerator' AS detail_measure_code,
           'Discharge Mobility Score'           AS metric_name,
           'n'                                  AS reported_on_carecompare
    UNION
    SELECT 'S_025_02_OBS_RATE'                AS measure_code,
           'Discharge Mobility Observed Rate' AS detail_measure_code,
           'Discharge Mobility Score'         AS metric_name,
           'y'                                AS reported_on_carecompare
    UNION
    SELECT 'S_038_02_ADJ_RATE'                   AS measure_code,
           'Pressure Ulcer/Injury Adjusted Rate' AS detail_measure_code,
           'Pressure Ulcer/Injury'               AS metric_name,
           'y'                                   AS reported_on_carecompare
    UNION
    SELECT 'S_038_02_DENOMINATOR'              AS measure_code,
           'Pressure Ulcer/Injury Denominator' AS detail_measure_code,
           'Pressure Ulcer/Injury'             AS metric_name,
           'n'                                 AS reported_on_carecompare
    UNION
    SELECT 'S_038_02_NUMERATOR'              AS measure_code,
           'Pressure Ulcer/Injury Numerator' AS detail_measure_code,
           'Pressure Ulcer/Injury'           AS metric_name,
           'n'                               AS reported_on_carecompare
    UNION
    SELECT 'S_038_02_OBS_RATE'                   AS measure_code,
           'Pressure Ulcer/Injury Observed Rate' AS detail_measure_code,
           'Pressure Ulcer/Injury'               AS metric_name,
           'n'                                   AS reported_on_carecompare

Possibly Referenced Tables/Views

VW_Medicare_SNF_QRP_MetricMapper