Dimensional Warehouse Model Data Model

Entity

Entity Point Of Care Location Dimension

Description

A location where a patient is placed or where medical services are provided.

Attributes
Active Ind
Acuity Tier Descr
Address Line 1 Descr
Address Line 2 Descr
Address Line 3 Descr
Address Line 4 Descr
Address Text Descr
Adult Pediatric Tier Descr
Area Cd
Area Code Descr
Area Code Sk
Availability Duration Qty
Availability Duration Unit Cd
Availability Duration Unit Code Sk
Availability Duration Unit Descr
AWM Load Info Sk
Bed Cnt
Bed Num
Building Nm
Building Num
City Nm
Country Nm
County Nm
Current Ind
Density Designation Cd
Density Designation Code Descr
Density Designation Code Sk
Department Cd
Department Code Sk
Department Descr
Descriptive Tier Descr
DWM Load Info Sk
Effective From Dt
Effective To Dt
Floor Cardinal Direction Cd
Floor Cardinal Direction Code Sk
Floor Cardinal Direction Descr
Floor Num
Geographic Descr
Global Location Num
Inactivation Reason Descr
Location Cost Center Cd
Location Cost Center Code Sk
Location Cost Center Descr
Location Descr
Location Nm
Location Overflow Ind
Location Tier Descr
Point Of Care Device Dk
Point Of Care Location Bk
Point Of Care Location Dk
Point Of Care Location Sk
Point Of Care Location Type Cd
Point Of Care Location Type Code Sk
Point Of Care Location Type Descr
Postal Cd
Provider Dk
Provider Sk
Room Num
Service Category Type Cd
Service Category Type Code Sk
Service Category Type Descr
Service Location Cd
Service Location Code Sk
Service Location Descr
Site Nm
Soil Type Cd
Soil Type Code Descr
Soil Type Code Sk
Source Cd
Source Code Descr
Source Code Sk
State Province Cd
Status Cd
Status Code Sk
Status Descr
Surface Area
Tenant Sk
Unit Cd
Unit Code Sk
Unit Descr
Unit Nm
Unit Tier Descr
Unit Type Category Cd
Unit Type Category Code Sk
Unit Type Category Descr
Unit Type Cd
Unit Type Code Sk
Unit Type Descr
Valid From Ts
Valid To Ts

Relationship
Point Of Care Location Dimension_Provider Dimension_FK
Point Of Care Location Dimension_Point Of Care Device Dimension_FK

Primary Key
Point Of Care Location Dimension PK

Dependencies

Reverse Dependencies

Attribute Details

Active Ind

Description	Indication of whether the point of care location entry is active or not.
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

Acuity Tier Descr

Description	The second tier in the Unit Cd used to identify a level of acuity. For example: acute non-acute
Data Type	Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Address Line 1 Descr

Description	First line of the address. Use for Primary Street and Building Number
Data Type	Standards - Data Domains.ddm/Data Domains/Address Line [VARCHAR(100)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Address Line 2 Descr

Description	Second line of the address
Data Type	Standards - Data Domains.ddm/Data Domains/Address Line [VARCHAR(100)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Address Line 3 Descr

Description	Third line of the address
Data Type	Standards - Data Domains.ddm/Data Domains/Address Line [VARCHAR(100)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Address Line 4 Descr

Description	Fourth line of the address
Data Type	Standards - Data Domains.ddm/Data Domains/Address Line [VARCHAR(100)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Address Text Descr

Description	Free form textual comments with respect to the telephone number.
Data Type	Standards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Adult Pediatric Tier Descr

Description	A tier representing if the Unit is for adults, pediatrics, or neither.
Data Type	Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Area Cd

Description	Indicates the area code assigned by the system.
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

Area Code Descr

Description	Indicates the area code assigned by the system.
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

Area Code Sk

Description	Indicates the area code assigned by the system.
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

Availability Duration Qty

Description	The duration for which the resource location is available.
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

Availability Duration Unit Cd

Description	Indicates the unit of measure for the availability duration count.
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

Availability Duration Unit Code Sk

Description	Indicates the unit of measure for the availability duration count.
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

Availability Duration Unit Descr

Description	Indicates the unit of measure for the availability duration count.
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

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

Bed Cnt

Description	Total number of beds in a health care Unit.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Bed Num

Description	Identifies a bed number.
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

Building Nm

Description	Indicates the name of the building such as Northside Building.
Data Type	Standards - Data Domains.ddm/Data Domains/Location Name [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Building Num

Description	Indicates the number that identifies a building such as Building 6.
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

City Nm

Description	Name for the city of the address.
Data Type	Standards - Data Domains.ddm/Data Domains/Area Name [VARCHAR(50)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Country Nm

Description	Name of the country for the address.
Data Type	Standards - Data Domains.ddm/Data Domains/Area Name [VARCHAR(50)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

County Nm

Description	The name of the county for the address.
Data Type	Standards - Data Domains.ddm/Data Domains/Area Name [VARCHAR(50)]
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

Density Designation Cd

Description	Classifies places according to the number of people resident per unit of area in or at the place. For example: City area Not populated Rural area
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

Density Designation Code Descr

Description	Classifies places according to the number of people resident per unit of area in or at the place. For example: City area Not populated Rural area
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

Density Designation Code Sk

Description	Classifies places according to the number of people resident per unit of area in or at the place. For example: City area Not populated Rural area
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

Department Cd

Description	Identifies the institution's department to which the location belongs
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

Department Code Sk

Description	Identifies the institution's department to which the location belongs
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

Department Descr

Description	Identifies the institution's department to which the location belongs
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

Descriptive Tier Descr

Description	The fourth tier in the Unit Cd used as a final descriptive element.
Data Type	Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	false
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

Floor Cardinal Direction Cd

Description	Identifies the cardinal direction of a floor. For example: North South East West
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

Floor Cardinal Direction Code Sk

Description	Identifies the cardinal direction of a floor. For example: North South East West
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

Floor Cardinal Direction Descr

Description	Identifies the cardinal direction of a floor. For example: North South East West
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

Floor Num

Description	Indicates the number of the floor.
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

Geographic Descr

Description	Free text that provides additional information about an address or location. For example: Landmark
Data Type	Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Global Location Num

Description	A Global Location Number (GLN) is the Global Standards One (GS1) identification key for a physical location. It consists of a 13-digit number composed of a GS1 Company Prefix, a Location Reference number and a Check Digit calculated across the preceding digits to ensure data integrity.
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

Inactivation Reason Descr

Description	Describes the reason for inactivation of the point of care location.
Data Type	Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Location Cost Center Cd

Description	Identifies the institution's cost center to which the location belongs.
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

Location Cost Center Code Sk

Description	Identifies the institution's cost center to which the location belongs.
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

Location Cost Center Descr

Description	Identifies the institution's cost center to which the location belongs.
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

Location Descr

Description	Describes the location in the form of free text.
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

Location Nm

Description	Indicates the full name of the location.
Data Type	Standards - Data Domains.ddm/Data Domains/Location Name Long [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Location Overflow Ind

Description	Indication of location use when another location is filled.
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

Location Tier Descr

Description	The first tier in the Unit Cd used to identify a unit location. For example: Inpatient locations Outpatient locations Community locations Non-patient care locations
Data Type	Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Point Of Care Device 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	false
Is Derived	false
Is Surrogate Key	false

Point Of Care Location Bk

Description	Concatenated values of a set of business attributes that uniquely identify the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Point Of Care Location 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

Point Of Care Location 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

Point Of Care Location Type Cd

Description	Indicates the type of the point of care location. For example: Organization unit site Work unit site Building Floor Room Bed
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

Point Of Care Location Type Code Sk

Description	Indicates the type of the point of care location. For example: Organization unit site Work unit site Building Floor Room Bed
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

Point Of Care Location Type Descr

Description	Indicates the type of the point of care location. For example: Organization unit site Work unit site Building Floor Room Bed
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

Postal Cd

Description	Zip code and International Postal Code for the address.
Data Type	Standards - Data Domains.ddm/Data Domains/Postal Code [VARCHAR(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Provider 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

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

Room Num

Description	A number that identifies a room.
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

Service Category Type Cd

Description	Indicates the type of services provided by the location. For example: Diagnostic Therapeutic Primary care Emergency
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

Service Category Type Code Sk

Description	Indicates the type of services provided by the location. For example: Diagnostic Therapeutic Primary care Emergency
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

Service Category Type Descr

Description	Indicates the type of services provided by the location. For example: Diagnostic Therapeutic Primary care Emergency
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

Service Location Cd

Description	Identifies the type of service location for reporting purposes.
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

Service Location Code Sk

Description	Identifies the type of service location for reporting purposes.
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

Service Location Descr

Description	Identifies the type of service location for reporting purposes.
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

Site Nm

Description	Name of a campus or site where an organization is located.
Data Type	Standards - Data Domains.ddm/Data Domains/Location Name [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Soil Type Cd

Description	The classification of the surface layer of this place. For example: Sand Lime Rock Swamp
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

Soil Type Code Descr

Description	The classification of the surface layer of this place. For example: Sand Lime Rock Swamp
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

Soil Type Code Sk

Description	The classification of the surface layer of this place. For example: Sand Lime Rock Swamp
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

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

State Province Cd

Description	Indicates the state or province for the address using a recognized set of codes or abbreviations.
Data Type	Standards - Data Domains.ddm/Data Domains/State Code [CHAR(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Status Cd

Description	Indicates the status of a point of care location. For example: Closed Occupied Unoccupied Isolated Contaminated
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

Status Code Sk

Description	Indicates the status of a point of care location. For example: Closed Occupied Unoccupied Isolated Contaminated
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 Descr

Description	Indicates the status of a point of care location. For example: Closed Occupied Unoccupied Isolated Contaminated
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

Surface Area

Description	Indicates the measurement of the surface area of this place.
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

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

Unit Cd

Description	Unit Code identifies a regulatory standard for healthcare units. Unit Code is the concatenation of the Location Tier, Acuity Tier, Unit Tier, and the Descriptive Tier attributes. For example: IN:ACUTE:CC:B IN:ACUTE:CC:C IN:ACUTE:CC:M
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

Unit Code Sk

Description	Unit Code identifies a regulatory standard for healthcare units. Unit Code is the concatenation of the Location Tier, Acuity Tier, Unit Tier, and the Descriptive Tier attributes. For example: IN:ACUTE:CC:B IN:ACUTE:CC:C IN:ACUTE:CC:M
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

Unit Descr

Description	A short description of the Unit Type Code.
Data Type	Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Unit Nm

Description	A textual name that identifies a point of care location or an organization unit. For example: The name of a nursing unit
Data Type	Standards - Data Domains.ddm/Data Domains/Location Name [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Unit Tier Descr

Description	The third tier in the Unit Cd used to identify the location unit. For example: critical care ward special care area operating room
Data Type	Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Unit Type Category Cd

Description	A group name for Unit Type Codes. For example: Inpatient Adult Critical Care Neonatal Units Pediatric Clinical Care
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

Unit Type Category Code Sk

Description	A group name for Unit Type Codes. For example: Inpatient Adult Critical Care Neonatal Units Pediatric Clinical Care
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

Unit Type Category Descr

Description	A group name for Unit Type Codes. For example: Inpatient Adult Critical Care Neonatal Units Pediatric Clinical Care
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

Unit Type Cd

Description	Identifies the type of unit. For example: Burn Critical Care Medical Cardiac Critical Care Medical Critical Care Medical/Surgical Critical Care Neurologic Critical Care Neurosurgical Critical Care Prenatal Critical Care Respiratory Critical Care
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

Unit Type Code Sk

Description	The generated unique key for a Unit Type Code.
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

Unit Type Descr

Description	A short description of the Unit Type 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

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

Relationship Details

Point Of Care Location Dimension_Provider Dimension_FK

Is Identifying Relationship	false
Child Table	Point Of Care Location Dimension
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	Provider Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Point Of Care Location Dimension_Point Of Care Device Dimension_FK

Is Identifying Relationship	false
Child Table	Point Of Care Location Dimension
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	Point Of Care Device Dimension
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Point Of Care Location Dimension PK

Key Attribute

Point Of Care Location Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model