Atomic Warehouse Model Data Model

Entity

Entity Point Of Care Device Detail

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
Battery Level
CE Mark Ind
Class Code Sk
Code Modified Txt
Description Txt
Device ID
Device Status Code Sk
Device System Model
Device Timestamp
Device Type Code Sk
Effective From Dt
Effective To Dt
Expiration Dt
Form Code Sk
Handling Code Sk
Load Info Sk
Lot Number Txt
Manufacture Dt
Material Code Sk
Model Nm
Over The Counter Product Ind
Point Of Care Device Sk
Power Status Code Sk
Remaining Battery Time UOM Code Sk
Remaining Battery Time Value
Reprocessed Device Code Sk
Returned To Reprocessor Dt
Risk Code Sk
Single Use Device Ind
Soft ID
Software Nm
Source Code Sk
Stability Duration Qty
Tenant Sk
Type Code Sk
Valid From Ts
Valid To Ts
Virtual Device Position

Relationship
Point Of Care Device Detail_Point Of Care Device_FK

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

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

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

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

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

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

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

Description	Identifies the actual type of the entry based on the entity type hierarchy defined in the business 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	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

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

Relationship Details

Point Of Care Device Detail_Point Of Care Device_FK

Is Identifying Relationship	true
Child Table	Point Of Care Device 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	Point Of Care Device
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 Device Detail PK

Key Attribute	Point Of Care Device Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model