Dimensional Warehouse Model Data Model

Entity

Entity Point Of Care Device Dimension

Description

A device that is used in the monitoring of a patient's condition, including vital signs, during the delivery of care.

Attributes
Actual Ind
Age Qty
Altitude
Available For Evaluation Ind
AWM Load Info Sk
Battery Level
CE Mark Ind
Class Cd
Class Code Descr
Class Code Sk
Code Modified Txt
Current Ind
Description Txt
Device ID
Device Status Cd
Device Status Code Descr
Device Status Code Sk
Device System Model
Device Timestamp
Device Type Cd
Device Type Code Descr
Device Type Code Sk
DWM Load Info Sk
Effective From Dt
Effective To Dt
Expiration Dt
Form Cd
Form Code Descr
Form Code Sk
Handling Cd
Handling Code Descr
Handling Code Sk
Lot Number Txt
Manufacture Dt
Material Cd
Material Code Descr
Material Code Sk
Model Nm
Over The Counter Product Ind
Point Of Care Device Bk
Point Of Care Device Dk
Point Of Care Device Sk
Power Status Cd
Power Status Code Descr
Power Status Code Sk
Remaining Battery Time UOM Cd
Remaining Battery Time UOM Code Descr
Remaining Battery Time UOM Code Sk
Remaining Battery Time Value
Reprocessed Device Cd
Reprocessed Device Code Descr
Reprocessed Device Code Sk
Returned To Reprocessor Dt
Risk Cd
Risk Code Descr
Risk Code Sk
Single Use Device Ind
Soft ID
Software Nm
Source Cd
Source Code Descr
Source Code Sk
Stability Duration Qty
Tenant Sk
Type Cd
Type Code Descr
Type Code Sk
Valid From Ts
Valid To Ts
Virtual Device Position

Primary Key
Point Of Care Device Dimension PK

Dependencies

Reverse Dependencies

Attribute Details

Actual Ind

Description	Indicates whether or note the material is a particular instance (actual) vs. universal kind. For Example: To indicate a particular Material, actual indicator = "true". To indicate a kind of Material, actual indicator = "false".
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

Age Qty

Description	A measure (or best estimate) of the length of time during which a device existed, measured from manufacture date (and time) to a given date (and time) of use. Derived from the difference between the manufacture date and the date of the activity in which it is used. This is not really a characteristic of the device since the device could be used in multiple activities.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Altitude

Description	In meters above and below sea level.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Small [SHORT]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Available For Evaluation Ind

Description	Specifies whether or not the device is accessible for assessment by the manufacturer.
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

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

Battery Level

Description	The percentage of battery capacity remaining on the device.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Small [SHORT]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

CE Mark Ind

Description	Specifies whether or not this device bears a CE (Conformite Europeenne) mark. CE is a mark for device products placed on the market in the European Economic Area (EEA). By placing the CE marking on a product, the manufacturer affirms that the product conforms with the requirements of the applicable European Community directives.
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

Class Cd

Description	Identifies a group of products that are homogeneous or generally considered as substitutes for each other. The class is considered as narrow or broad depending on how substitutable the various products are. For example: Stents Breakfast cereals Cox-2 inhibitors
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

Class Code Descr

Description	Identifies a group of products that are homogeneous or generally considered as substitutes for each other. The class is considered as narrow or broad depending on how substitutable the various products are. For example: Stents Breakfast cereals Cox-2 inhibitors
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

Class Code Sk

Description	Identifies a group of products that are homogeneous or generally considered as substitutes for each other. The class is considered as narrow or broad depending on how substitutable the various products are. For example: Stents Breakfast cereals Cox-2 inhibitors
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

Code Modified Txt

Description	A character string that is a revision of the original text of the product to enable the coding of the text. For Example: If the original text is "aspriin", the CodeModifiedText could be set to "aspirin", so that the text can be successfully coded. In the context of BRIDG, text modification occurs a single time for a given instance of originalText.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)]
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

Description Txt

Description	The textual representation of the material.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Device ID

Description	Device unique identifier – typically EUI-64; top 24 bits = unique company ID; lower 40 bits = serialization code; related to MAC addresses.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Small [VARCHAR(50)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Device Status Cd

Description	The device’s connection state (based on FSM).
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

Device Status Code Descr

Description	The device’s connection state (based on FSM).
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

Device Status Code Sk

Description	The device’s connection state (based on FSM).
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

Device System Model

Description	The Manufacturer & Model label strings.
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

Device Timestamp

Description	The device’s current date and time setting.
Data Type	Standards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Device Type Cd

Description	Indicates the category of the device. For example: Infusion pump Monitor
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

Device Type Code Descr

Description	Indicates the category of the device. For example: Infusion pump Monitor
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

Device Type Code Sk

Description	Indicates the category of the device. For example: Infusion pump Monitor
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

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

Expiration Dt

Description	The date assigned by the manufacturer on which the product should not be used.
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

Form Cd

Description	Indicates the state and nature of the material. For example: Solid Liquid Gas Tablet Ointment Gel
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

Form Code Descr

Description	Indicates the state and nature of the material. For example: Solid Liquid Gas Tablet Ointment Gel
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

Form Code Sk

Description	Indicates the state and nature of the material. For example: Solid Liquid Gas Tablet Ointment Gel
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

Handling Cd

Description	Indicates any special handling requirement for the materials including drugs, biologic substances and devices. For example: Keep at room temperature Refrigerate Store upright Keep dry
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

Handling Code Descr

Description	Indicates any special handling requirement for the materials including drugs, biologic substances and devices. For example: Keep at room temperature Refrigerate Store upright Keep dry
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

Handling Code Sk

Description	Indicates any special handling requirement for the materials including drugs, biologic substances and devices. For example: Keep at room temperature Refrigerate Store upright Keep dry
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

Lot Number Txt

Description	An alphanumeric string used to identify a particular batch of the product.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Small [VARCHAR(50)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Manufacture Dt

Description	The date and time that the device was made by the manufacturer.
Data Type	Standards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Material Cd

Description	Indicates the non-unique textual identifier for the material. The granularity of the code may vary depending on the specificity of the material. For example, acetaminophen, Tylenol, Tylenol 250 mg gel cap. For example: Aspirin Tobacco Caffeine
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

Material Code Descr

Description	Indicates the non-unique textual identifier for the material. The granularity of the code may vary depending on the specificity of the material. For example, acetaminophen, Tylenol, Tylenol 250 mg gel cap. For example: Aspirin Tobacco Caffeine
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

Material Code Sk

Description	Indicates the non-unique textual identifier for the material. The granularity of the code may vary depending on the specificity of the material. For example, acetaminophen, Tylenol, Tylenol 250 mg gel cap. For example: Aspirin Tobacco Caffeine
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

Model Nm

Description	Name or Identifier for a particular type of product.
Data Type	Standards - Data Domains.ddm/Data Domains/Name Medium [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Over The Counter Product Ind

Description	Specifies whether or not a device is available over-the-counter.
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 Device 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 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	true
Is Required	true
Is Derived	false
Is Surrogate Key	true

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

Power Status Cd

Description	The power status of the point of care device. For example: A/C or D/C
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

Power Status Code Descr

Description	The power status of the point of care device. For example: A/C or D/C
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

Power Status Code Sk

Description	The power status of the point of care device. For example: A/C or D/C
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

Remaining Battery Time UOM Cd

Description	The Unit of Measure for the estimated battery run-time remaining (typically in minutes) on the device.
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

Remaining Battery Time UOM Code Descr

Description	The Unit of Measure for the estimated battery run-time remaining (typically in minutes) on the device.
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

Remaining Battery Time UOM Code Sk

Description	The Unit of Measure for the estimated battery run-time remaining (typically in minutes) on the device.
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

Remaining Battery Time Value

Description	The estimated battery run-time remaining (typically in minutes) on the device.
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Reprocessed Device Cd

Description	Indicates whether a device is reconditioned. For example: Initial use Reuse Unknown
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

Reprocessed Device Code Descr

Description	Indicates whether a device is reconditioned. For example: Initial use Reuse Unknown
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

Reprocessed Device Code Sk

Description	Indicates whether a device is reconditioned. For example: Initial use Reuse Unknown
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

Returned To Reprocessor Dt

Description	The date and time that a device is returned to it's manufacturer or reprocessor.
Data Type	Standards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Risk Cd

Description	Indicates the type of hazard or threat associated with the device. For example: Flammable Explosive
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

Risk Code Descr

Description	Indicates the type of hazard or threat associated with the device. For example: Flammable Explosive
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

Risk Code Sk

Description	Indicates the type of hazard or threat associated with the device. For example: Flammable Explosive
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

Single Use Device Ind

Description	Specifies whether or not a device is intended to be used only one time.
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

Soft ID

Description	Locally (non-manufacturer) ID. For example: Hospital inventory 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

Software Nm

Description	Text description of a software product.
Data Type	Standards - Data Domains.ddm/Data Domains/Name Medium [VARCHAR(80)]
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

Stability Duration Qty

Description	The period of time during which the cosmetic is considered usable after it is activated (opened).
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity 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

Type Cd

Description	The code that corresponds to the Type 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

Type Code Descr

Description	The description that corresponds to the 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

Type Code Sk

Description	The code identifying the actual type of the entity as per the type hierarchy defined in the analysis data 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

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

Virtual Device Position

Description	The Physical “slot” that the virtual device is plugged into.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Small [SHORT]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Primary Key Details

Point Of Care Device Dimension PK

Key Attribute

Point Of Care Device Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model