Atomic Warehouse Model Data Model

Entity

Entity Point Of Care Location Detail

Description

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

Attributes
Active Ind
Area Code Sk
Availability Duration Qty
Availability Duration UOM Code Sk
Bed Cnt
Bed Num
Building Nm
Building Num
Density Designation Code Sk
Department Code Sk
Effective From Dt
Effective To Dt
Floor Cardinal Direction Code Sk
Floor Num
Geographic Descr
Global Location Num
Inactivation Reason Descr
Load Info Sk
Location Cost Center Code Sk
Location Descr
Location Nm
Location Overflow Ind
Point Of Care Location Sk
Point Of Care Location Type Code Sk
Room Num
Service Category Type Code Sk
Site Nm
Soil Type Code Sk
Source Code Sk
Status Code Sk
Surface Area
Tenant Sk
Unit Nm
Unit Type Code Sk
Valid From Ts
Valid To Ts

Relationship
Point Of Care Details _Point Of Care Location_FK

Primary Key
Point Of Care Location Detail 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	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 UOM 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

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

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

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	false
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/Description [VARCHAR(250)]
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

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

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

Point Of Care Location Sk

Description	Surrogate key for Point Of Care Location.
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

Point Of Care Location Type Code Sk

Description	Indicates the type of 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	true
Is Required	true
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 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	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 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 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 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	false
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 Nm

Description	The name of an organization unit or work 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 Type Code Sk

Description	A regulatory standard by which a tenant's institution can categorize their health care units for reporting purposes to the regulatory body such as the National Healthcare Safety Network (NHSN).
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

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

Relationship Details

Point Of Care Details _Point Of Care Location_FK

Is Identifying Relationship	true
Child Table	Point Of Care Location Detail
Child Role Name	has anchor of
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 Location
Parent Multiplicity	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 Detail PK

Key Attribute	Point Of Care Location Sk
Key Attribute	Point Of Care Location Type Code Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model