Atomic Warehouse Model Data Model

Entity

Entity Specimen Susceptibility Detail

Description

A clinical finding that describes the organisms found in a specimen. In addition to this, the resistance or vulnerability of an organism to a drug, often an antibiotic is also recorded. It is used by healthcare practitioners to prescribe the most appropriate medication for the patient's diagnosis. Susceptibilities are identified through microbiology testing.

For example:
Blood cultures are used to identify organisms like staphylococcus aureus in a person's blood.
Sputum cultures are used to identify organisms like klebsiella pneumoniae in a person's sputum.
The bacteria clostridium difficile is sensitive to the antibiotic clindamycin.

Attributes
Clinical Finding Sk
Effective From Dt
Effective To Dt
Load Info Sk
Organism Susceptibility Code Sk
Priority Seq
Source Code Sk
Specimen Susceptibility Comparative Operator Symbol Nm
Specimen Susceptibility Drug Code Sk
Specimen Susceptibility End Ts
Specimen Susceptibility Identifier Code Sk
Specimen Susceptibility Interpretation Result Code Sk
Specimen Susceptibility Interpretation Result Txt
Specimen Susceptibility Lab Test Code Sk
Specimen Susceptibility Nature Abnormal Test Code Sk
Specimen Susceptibility Observation Method Code Sk
Specimen Susceptibility Occurred Ts
Specimen Susceptibility Organism Code Sk
Specimen Susceptibility Probability Num
Specimen Susceptibility Producing System Code Sk
Specimen Susceptibility Producing System Nm
Specimen Susceptibility Reference Range Effective Ts
Specimen Susceptibility Reference Range Txt
Specimen Susceptibility Reported Ts
Specimen Susceptibility Responsible Observer Nm
Specimen Susceptibility Result Status Code Sk
Specimen Susceptibility Result Status Ts
Specimen Susceptibility Set Num
Specimen Susceptibility Sub Identifier Num
Specimen Susceptibility Unit Code Sk
Specimen Susceptibility Value Qty
Specimen Susceptibility Value Txt
Specimen Susceptibility Value Type Code Sk
Specimen Susceptibility Value UOM Code Sk
Tenant Sk
Valid From Ts
Valid To Ts

Relationship
Specimen Susceptibility Detail_Clinical Finding_FK

Primary Key
Specimen Susceptibility Detail PK

Dependencies

Reverse Dependencies

Attribute Details

Clinical Finding Sk

Description	The system generated identifier that names one and only one Clinical Finding.
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

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

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

Organism Susceptibility Code Sk

Description	Identifies a set of one or more observations about the resistance or vulnerability of an isolate (organism) to a drug, often an antibiotic. It is used by healthcare practitioners to prescribe the most appropriate medication for the patient's diagnosis. Susceptibilities are identified through microbiology testing. For Example: The bacteria Clostridium Difficile is sensitive to the antibiotic clindamycin
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

Priority Seq

Description	A number representing the relative order of importance for each clinical finding in a set.
Data Type	Standards - Data Domains.ddm/Data Domains/Sequence Number [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 Susceptibility Comparative Operator Symbol Nm

Description	Identifies the name of the Finding Comparative Operator Symbol for the Clinical Finding. For Example: Greater than is Equals is = Less that is
Data Type	Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Susceptibility Drug Code Sk

Description	Identifies the generic drug used in the specimen susceptibility test.
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 Susceptibility End Ts

Description	The date and time that a timed observation or test was completed. For Example: Glucose Tolerance test is a series of blood glucose tests. Samples of blood are taken before the test begins and every 30 to 60 minutes after the person has drank a glucose drink. The last blood sample is considered the Finding End Ts.
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

Specimen Susceptibility Identifier Code Sk

Description	Identifies the generic drug used in the specimen susceptibility test that the isolate (organism) is sensitive to.
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 Susceptibility Interpretation Result Code Sk

Description	The explanation in understandable, non-scientific terms for the specimen test results.
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 Susceptibility Interpretation Result Txt

Description	The explanation in understandable, non-scientific terms for the specimen test results.
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

Specimen Susceptibility Lab Test Code Sk

Description	A specific category of clinical finding that will detail the type of laboratory test that was performed and the outcome of those tests.
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 Susceptibility Nature Abnormal Test Code Sk

Description	An acronym or abbreviation that describes the characterization of the abnormal finding. For Example: A race-based population A sex-based population An age-based population
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 Susceptibility Observation Method Code Sk

Description	Indicates the technique used to obtain the clinical finding. This is normally used to indicate that a different method than the standard method was used for the clinical finding. For Example: Microscopic Titration Dipstick
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 Susceptibility Occurred Ts

Description	The date and time when the clinical finding was observed or was performed.
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

Specimen Susceptibility Organism Code Sk

Description	The microbial organism that was tested for susceptibility to a drug. For Example: Bacteria Clostridium Difficile
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 Susceptibility Probability Num

Description	A decimal number represented as text that indicates the likelihood that the clinical finding is true. The number is normally between 0 and 1.
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

Specimen Susceptibility Producing System Code Sk

Description	Identifies the system responsible for producing the clinical finding. This may name an internal hospital system or an outside laboratory.
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 Susceptibility Producing System Nm

Description	Identifies the system responsible for producing the clinical finding. This may name an internal hospital system or an outside laboratory.
Data Type	Standards - Data Domains.ddm/Data Domains/Name Compound [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Susceptibility Reference Range Effective Ts

Description	The date upon which the reference range for a clinical finding is to be observed from.
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

Specimen Susceptibility Reference Range Txt

Description	Reference ranges are a set of values used to interpret clinical findings. The values would include the upper and lower limits for a specific clinical finding. For Example: Potassium has a reference range of 3.5 - 5.2 mmols/L which means a potassium level above 5.2 mmols/l would be considered high.
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

Specimen Susceptibility Reported Ts

Description	The date and time the clinical findings were officially recorded.
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

Specimen Susceptibility Responsible Observer Nm

Description	The name of the responsible observer for the specimen susceptibility test.
Data Type	Standards - Data Domains.ddm/Data Domains/Name Compound [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Susceptibility Result Status Code Sk

Description	Indicates the current condition of the clinical finding result. For example: Interim Final
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 Susceptibility Result Status Ts

Description	The date and time the clinical finding result status was recorded.
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

Specimen Susceptibility Set Num

Description	A number that identifies the test set that the specific clinical test is associated to.
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

Specimen Susceptibility Sub Identifier Num

Description	A unique identifier for the clinical finding within a set of clinical findings for one clinical order.
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

Specimen Susceptibility Unit Code Sk

Description	The code or abbreviation describing the specimen test results.
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 Susceptibility Value Qty

Description	The numeric version of the Finding Value Text.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Susceptibility Value Txt

Description	A description of the clinical finding result. The field may contain the exact scientific result or it may contain the normal/abnormal state of the test, i.e. quantitative or qualitative results. The field may contain a single or multi-part answer.
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

Specimen Susceptibility Value Type Code Sk

Description	Indicates the unit of measure that is used in combination with Finding Value Type to describe the contents of the Finding Value Txt. International coding systems such as ISO may be used to define the list and description for all units of measure within a system. For Example: mmol= millimole kg = kilogram mcg = microgram iu= international units
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 Susceptibility Value UOM Code Sk

Description	The Unit of Measure Code corresponding to the Finding Value Quantity. For Example: mmol= millimole kg = kilogram mcg = microgram iu= international units
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 Susceptibility Detail_Clinical Finding_FK

Is Identifying Relationship	true
Child Table	Specimen Susceptibility 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	Clinical Finding
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 Susceptibility Detail PK

Key Attribute	Clinical Finding Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model