Atomic Warehouse Model Data Model

Entity

Entity Contraindication Diagnosis

Description

A diagnosis or problem that is deemed a contraindication for the ordered service or procedure.

For Example:
Pacemaker
Metal implant
Renal failure

Attributes
Contraindication Diagnosis Code Sk
Effective From Dt
Effective To Dt
Load Info Sk
Order Master Sk
Source Code Sk
Tenant Sk
Valid From Ts
Valid To Ts

Relationship
Contraindication Diagnosis _Order Master_FK

Primary Key
Contraindication Diagnosis PK

Dependencies

Reverse Dependencies

Description	Indicates the patient's diagnosis or problem for which the ordered service/procedure is a contraindication or a possible danger to the patient. For Example: If the ordered procedure was an intravenous pyelogram, this would include warnings about the use of contrast media in diabetes. The contraindication diagnoses should be separated by repeat delimiters.
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

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

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

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

Description	Anchor surrogate key for the Orderable Item data.
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

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

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

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

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

Is Identifying Relationship	true
Child Table	Contraindication Diagnosis
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	Order Master
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Key Attribute	Order Master Sk
Key Attribute	Contraindication Diagnosis Code Sk
Key Attribute	Valid From Ts

Entity

Atomic Warehouse Model Data Model