Dimensional Warehouse Model Data Model

Entity

Entity Specimen Description Array

Description

An identification of the nature of a specimen in terms of key indices as well as a free text description.

Attributes
Artificial Blood Id
AWM Load Info Sk
Current Ind
Description Txt
Dilution Factor
Drug Interference Cd
Drug Interference Code Sk
DWM Load Info Sk
Effective From Dt
Effective To Dt
Environmental Factors Cd
Environmental Factors Code Sk
Fibrin Index
Fibrin Index Unit Of Measure Cd
Fibrin Index Unit Of Measure Code Sk
Hemolysis Index
Hemolysis Index Unit Of Measure Cd
Hemolysis Index Unit Of Measure Code Sk
Icterus Index
Icterus Index Unit Of Measure Cd
Icterus Index Unit Of Measure Code Sk
Lipemia Index
Lipemia Index Unit Of Measure Cd
Lipemia Index Unit Of Measure Code Sk
Source Code Sk
Specimen Component Type Cd
Specimen Component Type Code Sk
Specimen Dk
Specimen Seq
Specimen Sk
Specimen Temperature
Specimen Treatment Type Cd
Specimen Treatment Type Code Sk
Tenant Sk
Valid From Ts
Valid To Ts

Relationship
Specimen Description Array_Specimen Dimension_FK

Primary Key
Specimen Description Array PK

Dependencies

Reverse Dependencies

Attribute Details

Artificial Blood Id

Description	Indicates the artificial blood identifier (if any) that is associated with the specimen.
Data Type	Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)]
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

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	A free form textual description providing additional information about the collected specimen.
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

Dilution Factor

Description	Indicates the factor of any dilution already performed on the specimen.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Drug Interference Cd

Description	Indicates the drug interference identifier that is associated with the specimen.
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

Drug Interference Code Sk

Description	Indicates the drug interference identifier that is associated with the specimen.
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

Environmental Factors Cd

Description	Indicates any environmental factors that are associated with or relevant to the specimen.
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

Environmental Factors Code Sk

Description	Indicates any environmental factors that are associated with or relevant to the specimen.
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

Fibrin Index

Description	A numeric value that represents the level of fibrous proteins involved in blood clotting (fibrin)in the specimen.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Fibrin Index Unit Of Measure Cd

Description	Indicates the unit of measure in which the fibrin index is expressed.
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

Fibrin Index Unit Of Measure Code Sk

Description	Indicates the unit of measure in which the fibrin index is expressed.
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

Hemolysis Index

Description	A numeric value that represents the measured breakage of red blood cells (hemolysis) of the specimen.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Hemolysis Index Unit Of Measure Cd

Description	Indicates the unit of measure in which the hemolysis index is expressed.
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

Hemolysis Index Unit Of Measure Code Sk

Description	Indicates the unit of measure in which the hemolysis index is expressed.
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

Icterus Index

Description	A numeric value that represents the level of bilrubin (icterus index) in the serum or plasma specimen.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Icterus Index Unit Of Measure Cd

Description	Indicates the unit of measure in which the the icterus index is expressed.
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

Icterus Index Unit Of Measure Code Sk

Description	Indicates the unit of measure in which the the icterus index is expressed.
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

Lipemia Index

Description	A numeric value that represents the measured presence of excess lipids in the blood (lipemia) specimen.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Lipemia Index Unit Of Measure Cd

Description	Indicates the unit of measure in which the lipemia index is expressed.
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

Lipemia Index Unit Of Measure Code Sk

Description	Indicates the unit of measure in which the lipemia index is expressed.
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

Specimen Component Type Cd

Description	Indicates the nature of the specimen component. For example: Supernatant Sediment
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

Specimen Component Type Code Sk

Description	Indicates the nature of the specimen component. For example: Supernatant Sediment
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

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

Specimen Seq

Description	A positive integer which when present can assist in determining the order of related segment descriptions.
Data Type	Standards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Specimen 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

Specimen Temperature

Description	Indicates the specimen temperature in degrees Celsius [°C].
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Treatment Type Cd

Description	Indicates the nature of specimen treatment performed during lab processing. For example: LDL Precipitation Recalcification Defibrination Acidification
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

Specimen Treatment Type Code Sk

Description	Indicates the nature of specimen treatment performed during lab processing. For example: LDL Precipitation Recalcification Defibrination Acidification
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

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

Specimen Description Array_Specimen Dimension_FK

Is Identifying Relationship	true
Child Table	Specimen Description Array
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	Specimen Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Specimen Description Array PK

Key Attribute	Specimen Dk
Key Attribute	Specimen Seq
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model