Atomic Warehouse Model Data Model

Entity

Entity Relative Value Unit Detail

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
Conversion Factor Rt
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 RVU UOM Code Sk
Load Info Sk
Malpractice RVU Rt
Physician Technical Code Sk
Relative Value Unit Sk
RVU Type Code Sk
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 RVU Rt

Relationship
Relative Value Unit Detail_Relative Value Unit_FK

Primary Key
Relative Value Unit Detail PK

Dependencies

Reverse Dependencies

Attribute Details

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

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 RVU 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

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

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

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

Relative Value Unit Sk

Description	Surrogate key for the anchor entity.
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	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 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	true
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 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

Relative Value Unit Detail_Relative Value Unit_FK

Is Identifying Relationship	true
Child Table	Relative Value Unit Detail
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	Relative Value Unit
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Relative Value Unit Detail PK

Key Attribute	Relative Value Unit Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model