Dimensional Warehouse Model Data Model

Entity

Entity Procedure Code Dimension

Description

A code that identifies a procedure within a code set or code type. Standard procedure code sets include Current Procedural Terminology (CPT) and Universal Billing (UB) Revenue codes.

Attributes
Abortion Ind
Anesthesia Cd
Anesthesia Code Sk
Anesthesia Ind
Anesthesia Minutes
Associated Diagnosis Cd
Associated Diagnosis Code Sk
AWM Load Info Sk
Coding System Version Descr
Coding System Version Num
Coding System Version Sk
Complication Ind
Consent Cd
Consent Code Sk
C Section Ind
Current Ind
Derived Ind
Domain Descr
Domain Nm
Domain Sk
DWM Load Info Sk
Effective From Dt
Effective To Dt
Image Id Num
Laboratory Process Ind
Method Cd
Method Code Sk
Newborn Ind
Procedure Cd
Procedure Classification Level 1 Cd
Procedure Classification Level 1 Descr
Procedure Classification Level 2 Cd
Procedure Classification Level 2 Descr
Procedure Classification Level 3 Cd
Procedure Classification Level 3 Descr
Procedure Classification Level 4 Cd
Procedure Classification Level 4 Descr
Procedure Code Dk
Procedure Code Sk
Procedure Descr
Procedure Functional Type Cd
Procedure Functional Type Code Sk
Procedure Minutes
Procedure Nm
Procedure Priority Cd
Procedure Priority Code Sk
Procedure Ts
Process Class Ind
Publisher Cd
Publisher Nm
Publisher Sk
RBRVS Num
Report Result Ind
Required Documentation
Source Cd
Source Code Descr
Source Code Sk
Status Cd
Status Code Sk
Tenant Sk
Terminology Author Cd
Terminology Author Nm
Terminology Author Sk
Vaginal Delivery Ind
Valid From Ts
Valid To Ts

Primary Key
Procedure Code Dimension PK

Dependencies

Reverse Dependencies

Attribute Details

Abortion Ind

Description	Indicates whether or not this procedure involved an abortion.
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

Anesthesia Cd

Description	Identifies the anesthesia used during the procedure.
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

Anesthesia Code Sk

Description	Identifies the anesthesia used during the procedure.
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

Anesthesia Ind

Description	Indicates whether or not this procedure involved the use of anesthesia.
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

Anesthesia Minutes

Description	The length of time expressed in minutes that the anesthesia was administered.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Associated Diagnosis Cd

Description	Identifies the diagnosis that is the primary reason this procedure was performed. Diagnosis codes are generally recorded using the International Classification of Diseases ICD-9 or ICD-10 coding systems. For example: In the US, Medicare wants to know for which diagnosis this procedure is submitted for inclusion on CMS 1500 form.
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

Associated Diagnosis Code Sk

Description	Identifies the diagnosis that is the primary reason this procedure was performed. Diagnosis codes are generally recorded using the International Classification of Diseases ICD-9 or ICD-10 coding systems. For example: In the US, Medicare wants to know for which diagnosis this procedure is submitted for inclusion on CMS 1500 form.
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

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

Coding System Version Descr

Description	The description or explanation of a code domain. This is to more fully describe the "Code Type" which may be an abbreviation or acronym. For Example "Code Type" = SNOMED, Code Type Description "Systemized Nomenclature of Medicine".
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

Coding System Version Num

Description	The designation of a unique set of codes.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Coding System Version 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

Complication Ind

Description	Indicates whether or not this procedure is due to a complication.
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

Consent Cd

Description	Indicates the type of consent that was obtained for permission to treat the patient.
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

Consent Code Sk

Description	Indicates the type of consent that was obtained for permission to treat the patient.
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

C Section Ind

Description	Indicates whether or not this procedure involved an abortion.
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

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

Derived Ind

Description	Indicates whether the Procedure was submitted or derived.
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

Domain Descr

Description	The description or explanation of a code domain. This is to more fully describe the "Domain Name" which may be an abbreviation or acronym.
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

Domain Nm

Description	A unique name for a group or type of codes, STATE might refer to data that defined State in the United States of America or Provinces in Canada.
Data Type	Standards - Data Domains.ddm/Data Domains/Domain Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Domain 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

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

Image Id Num

Description	A reference pointer to an image file stored on an external system.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Laboratory Process Ind

Description	Indicates whether or not this procedure is a laboratory procedure.
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

Method Cd

Description	Identifies the technique that is used for the procedure. For example: Finger stick Veni puncture Abdominal/ ascites effusion Biopsy Bronchial alveolar lavage (BAL) Open Laparoscopic
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

Method Code Sk

Description	Identifies the technique that is used for the procedure. For example: Finger stick Veni puncture Abdominal/ ascites effusion Biopsy Bronchial alveolar lavage (BAL) Open Laparoscopic
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

Newborn Ind

Description	Indicates whether or not this procedure is performed on a new born.
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

Procedure Cd

Description	A unique code that identifies a procedure within a coding system. Standard procedure code sets include Current Procedural Terminology (CPT), SNOMED and Healthcare Common and Universal Billing (UB) Revenue codes.
Data Type	Standards - Data Domains.ddm/Data Domains/Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Procedure Classification Level 1 Cd

Description	Code that identifies a level one procedure classification.
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

Procedure Classification Level 1 Descr

Description	A term that describes a level one procedure classification.
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

Procedure Classification Level 2 Cd

Description	Code that identifies a level two procedure classification.
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

Procedure Classification Level 2 Descr

Description	A term that describes a level two procedure classification.
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

Procedure Classification Level 3 Cd

Description	Code that identifies a level three procedure classification.
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

Procedure Classification Level 3 Descr

Description	A term that describes a level three procedure classification.
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

Procedure Classification Level 4 Cd

Description	Code that identifies a level four procedure classification.
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

Procedure Classification Level 4 Descr

Description	A term that describes a level four procedure classification.
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

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	true
Is Required	true
Is Derived	false
Is Surrogate Key	true

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

Procedure Descr

Description	Describes a Procedure Code.
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

Procedure Functional Type Cd

Description	Indicates the functional nature of the procedure. For example: Anesthesia Procedure for treatment (therapeutic, including operations) Surgical Procedure Invasive procedure not classified elsewhere (for example, IV, catheter, etc.) Diagnostic procedure
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

Procedure Functional Type Code Sk

Description	Indicates the functional nature of the procedure. For example: Anesthesia Procedure for treatment (therapeutic, including operations) Surgical Procedure Invasive procedure not classified elsewhere (for example, IV, catheter, etc.) Diagnostic procedure
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

Procedure Minutes

Description	The length of time expressed in whole minutes that the procedure took to complete.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Procedure Nm

Description	Name of the procedure.
Data Type	Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Procedure Priority Cd

Description	Identifies the significance or priority of a procedure.
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

Procedure Priority Code Sk

Description	Identifies the significance or priority of a procedure.
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

Procedure Ts

Description	The date and time that the procedure was performed.
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

Process Class Ind

Description	Indicates whether or not this procedure is a complication or co-morbidity.
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

Publisher Cd

Description	Unique coded value identifying a publisher.
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

Publisher Nm

Description	Text description of a publication organization through which any material is issued or published.
Data Type	Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Publisher 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

RBRVS Num

Description	Identifies the Resource Based Relative Value Scale (RBRVS) number for the procedure code.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Small [DECIMAL(5,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Report Result Ind

Description	Indicates whether or not the Procedure has a result that is reportable to the requester.
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

Required Documentation

Description	Supporting documentation that is required when processing a claim for this procedure code.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
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 Descr

Description	The description that corresponds to the Source Type Cd.
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

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

Status Cd

Description	Indicates the status of the procedure.
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

Status Code Sk

Description	Indicates the status of the procedure.
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

Terminology Author Cd

Description	The Business Key for Terminology Author.
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

Terminology Author Nm

Description	The name of an organization that produces and maintains a set of codes.
Data Type	Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Terminology Author 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

Vaginal Delivery Ind

Description	Indicates whether or not this procedure involved a vaginal delivery.
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

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

Primary Key Details

Procedure Code Dimension PK

Key Attribute

Procedure Code Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model