Dimensional Warehouse Model Data Model

Entity

Entity Geographic Relative Value Unit Fact

Description

The non-monetary factors which rank the resources used to provide each physician or hospital service. They are used by CMS to determine reimbursement rates for procedures.

For example:
Work RVU
Malpractice RVU
Practice Expense RVU

Attributes
AWM Load Info Sk
Conversion Factor Rt
Current Ind
DWM Load Info Sk
Effective From Dt
Effective To Dt
End Dt
Fully Implemented Facility Ind
Fully Implemented Facility Practice Expense RVU Rt
Fully Implemented Non Facility Ind
Fully Implemented Non Facility Practice Expense RVU Rt
General Relative Value Unit Qty
General Relative Value Unit UOM Cd
General Relative Value Unit UOM Code Sk
Geographic Area Dk
Geographic Area Sk
Malpractice GPCI Rt
Malpractice RVU Rt
Organization Dk
Organization Sk
Physician Technical Cd
Physician Technical Code Descr
Physician Technical Code Sk
Practice Expense GPCI Rt
Procedure Code Dk
Procedure Code Sk
Relative Value Unit Dk
Relative Value Unit Sk
RVU Period Start Calendar Dk
RVU Type Cd
RVU Type Code Descr
RVU Type Code Sk
Source Cd
Source Code Sk
Start Dt
Status Code Sk
Tenant Sk
Total Fully Implemented Facility RVU Rt
Total Fully Implemented Non Facility RVU Rt
Total Transitioned Facility RVU Rt
Total Transitioned Non Facility RVU Rt
Transitioned Facility Ind
Transitioned Facility Practice Expense RVU Rt
Transitioned Non Facility Ind
Transitioned Non Facility Practice Expense RVU Rt
Valid From Ts
Valid To Ts
Work GPCI Rt
Work RVU Rt

Relationship
Geographic Relative Value Unit Fact_Organization Dimension_FK
Geographic Relative Value Unit Fact_Procedure Dimension_FK
Geographic Relative Value Unit Fact_Calendar Dimension_FK
Geographic Relative Value Unit Fact_Geographic Area Dimension_FK

Primary Key
Geographic Relative Value Unit Fact PK

Dependencies

Reverse Dependencies

Attribute Details

AWM Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row in the atomic data warehouse.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Conversion Factor Rt

Description	This is the multiplier that transforms relative values into payment amounts. This conversion factor reflects the MEI update adjustment. For 2002 and beyond, there is a single conversion factor for all services.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Current Ind

Description	Set to 'Y' if this is the most recent row of a group having the same Surrogate Key.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

DWM Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Effective From Dt

Description	Establishes a period where a set of attributes are true according to the business.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Effective To Dt

Description	Ends a period of effectivity.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

End Dt

Description	The date upon which the relative value unit factors are no longer available for use.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Fully Implemented Facility Ind

Description	Indicates whether or not this procedure is rarely or never performed in the facility setting.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Fully Implemented Facility Practice Expense RVU Rt

Description	Relative Value Unit (RVU) for the fully implemented resource-based practice expense for the facility setting, as published in the Federal Register Fee Schedule for Physicians Services.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Fully Implemented Non Facility Ind

Description	Indicates whether or not this procedure is rarely or never performed in the non-facility setting.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Fully Implemented Non Facility Practice Expense RVU Rt

Description	Relative Value Unit (RVU) for the fully-implemented resource-based practice expense for the non-facility setting, as published in the Federal Register Fee Schedule for Physicians Services
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

General Relative Value Unit Qty

Description	RVU factor defined locally for use when relative factors for the complexity of an activity are needed.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

General Relative Value Unit UOM Cd

Description	The unit of measure associated with the General Relative Value Unit Qty.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

General Relative Value Unit UOM Code Sk

Description	The unit of measure associated with the General Relative Value Unit Qty.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Geographic Area Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Geographic Area Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Malpractice GPCI Rt

Description	Geographic Practice Cost Index for the malpractice component of an RVU.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Malpractice RVU Rt

Description	RVU for the malpractice expense for the service as published in the Federal Register Fee Schedule for Physicians' Services.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Organization Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Organization Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Physician Technical Cd

Description	PC / TC Codes determine how Physician and Technical component factors of an RVU are determined.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Physician Technical Code Descr

Description	PC / TC Codes determine how Physician and Technical component factors of an RVU are determined.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Physician Technical Code Sk

Description	PC / TC Codes determine how Physician and Technical component factors of an RVU are determined.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Practice Expense GPCI Rt

Description	Geographic Practice Cost Index for the practice expense component of an RVU.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Procedure Code Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Procedure Code Sk

Description	A numeric surrogate key used to uniquely identify entities in the Atomic model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Relative Value Unit Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	true

Relative Value Unit Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

RVU Period Start Calendar Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

RVU Type Cd

Description	Indicates the kind of Relative Value Unit (RVU) set this record represents. Default would be 'CMS'.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

RVU Type Code Descr

Description	Indicates the kind of Relative Value Unit (RVU) set this record represents. Default would be 'CMS'.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

RVU Type Code Sk

Description	Indicates the kind of Relative Value Unit (RVU) set this record represents. Default would be 'CMS'.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Source Cd

Description	The code that corresponds to the Source Code Sk.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Source Code Sk

Description	The origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Start Dt

Description	The date upon which the relative value unit factors are available for use.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Status Code Sk

Description	Indicates whether the code is in the fee schedule and whether it is separately payable if the service is covered. A = Active Code. B = Bundled Code. C = Carriers price the code. D = Deleted Codes. E = Excluded from Physician Fee Schedule by regulation. F = Deleted/Discontinued Codes. G = Not valid for Medicare purposes. H = Deleted Modifier. I = Not valid for Medicare purposes. J = Anesthesia Services. M = Measurement codes. N = Non-covered Services. P = Bundled/Excluded Codes. R = Restricted Coverage. T = Injections. X = Statutory Exclusion.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Tenant Sk

Description	The surrogate key of the entry identifying the legal owner of the data.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Total Fully Implemented Facility RVU Rt

Description	Sum of work, fully implemented facility practice expense, and malpractice RVUs.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Total Fully Implemented Non Facility RVU Rt

Description	Sum of work, fully implemented non-facility practice expense, and malpractice expense RVUs.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Total Transitioned Facility RVU Rt

Description	Sum of work, transitioned facility practice expense, and malpractice RVUs.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Total Transitioned Non Facility RVU Rt

Description	Sum of work, transitioned non-facility practice expense, and malpractice expense RVUs
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Transitioned Facility Ind

Description	Indicates whether or not this procedure is rarely or never performed in the facility setting or is not paid under the Physician Fee Schedule in the facility setting.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Transitioned Facility Practice Expense RVU Rt

Description	Relative Value Unit (RVU) for the transitioned resource-based practice expense for the facility setting, as published in the Federal Register Fee Schedule for Physicians Services.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Transitioned Non Facility Ind

Description	Indicates whether or not this procedure is rarely or never performed in the non-facility setting.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Transitioned Non Facility Practice Expense RVU Rt

Description	Relative Value Unit (RVU) for the transitioned resource-based practice expense for the non-facility setting, as published in the Federal Register Fee Schedule for Physicians Services
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Valid From Ts

Description	Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Valid To Ts

Description	Ends a period of validity.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Work GPCI Rt

Description	Geographic Practice Cost Index for the work component of an RVU.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Work RVU Rt

Description	Relative Value Unit (RVU) for the physician work in the service as published in the Federal Register Fee Schedule for Physicians Services.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

Geographic Relative Value Unit Fact_Organization Dimension_FK

Is Identifying Relationship	false
Child Table	Geographic Relative Value Unit Fact
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Organization Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Geographic Relative Value Unit Fact_Procedure Dimension_FK

Is Identifying Relationship	false
Child Table	Geographic Relative Value Unit Fact
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Procedure Code Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Geographic Relative Value Unit Fact_Calendar Dimension_FK

Is Identifying Relationship	false
Child Table	Geographic Relative Value Unit Fact
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Calendar Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Geographic Relative Value Unit Fact_Geographic Area Dimension_FK

Is Identifying Relationship	false
Child Table	Geographic Relative Value Unit Fact
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Geographic Area Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Geographic Relative Value Unit Fact PK

Key Attribute

Relative Value Unit Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model