Atomic Warehouse Model Data Model

Entity

Entity Diagnosis Detail

Description

A medical determination of disease or syndrome established by a practitioner. The focus is on the disease process and the physical, genetic, or environmental cause of that process. There are various types of diagnosis, for example, admitting, primary, etc. In some instances, there could be multiple diagnoses. There could also be additional attribution when the diagnosis code does not provide sufficient information for a billing system.

Attributes
Acceptance Reason Code Sk
Accepted Dt
Accepted Ind
Confidential Ind
Derived Ind
Diagnosis Classification Code Sk
Diagnosis Code
Diagnosis Code Sk
Diagnosis Coding Method Code Sk
Diagnosis Descr
Diagnosis Id Num
Diagnosis Sk
Diagnosis Ts
Diagnosis Type Code Sk
Effective From Dt
Effective To Dt
Load Info Sk
Present On Admission Code Sk
Previous C Section Ind
Source Code Sk
Tenant Sk
Translated Diagnosis Code Descr
Translated Diagnosis Code Set Code Sk
Translated Diagnosis Code Sk
Translation Dt
Translation Rule Applied Code Sk
Translation Rule Descr
Valid From Ts
Valid To Ts

Relationship
Diagnosis Detail_Diagnosis_FK

Primary Key
Diagnosis Detail PK

Dependencies

Reverse Dependencies

Attribute Details

Acceptance Reason Code Sk

Description	Indicates the reason for accepting this diagnosis.
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

Accepted Dt

Description	The date upon which the diagnosis was accepted or approved.
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

Accepted Ind

Description	Indicates whether or not the diagnosis has been accepted by the modeled organization.
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

Confidential Ind

Description	Indicates whether the diagnosis is confidential.
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

Derived Ind

Description	Indicates whether the diagnosis code was submitted or derived.
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

Diagnosis Classification Code Sk

Description	Indicates whether the patient information is for a diagnosis or a non-diagnosis code. For example: Consultation Diagnosis Medication Sign Symptom
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

Diagnosis Code

Description	The code that is used to indicate the diagnosis and identify the disease or patient condition. Diagnosis codes generally comply to the International Classification of Diseases code system. ICD-9 CM or ICD-10 codes would typically be used.
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

Diagnosis Code Sk

Description	The code that is used to indicate the diagnosis and identify the disease or patient condition. Diagnosis codes generally comply to the International Classification of Diseases code system. ICD-9 CM or ICD-10 codes would typically be used.
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

Diagnosis Coding Method Code Sk

Description	Indicates the code set or standard used to specify the diagnosis. For example: ICD9 ICD10 SNOMED
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

Diagnosis Descr

Description	A textual description associated with the diagnosis code.
Data Type	Standards - Data Domains.ddm/Data Domains/Description Long [VARCHAR(1024)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Diagnosis Id Num

Description	Identifies a single diagnosis for an encounter. It is unique across all segments and messages for an encounter.
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

Diagnosis Sk

Description	Surrogate key for the anchor Diagnosis.
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

Diagnosis Ts

Description	The date and time that the diagnosis was determined.
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

Diagnosis Type Code Sk

Description	Indicates the type of diagnosis. For example: Admitting Discharge
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

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

Present On Admission Code Sk

Description	Indicates that a given diagnosis was made at the time of the patient's admission to a healthcare facility or that the diagnosis related to a condition already known upon admission.
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

Previous C Section Ind

Description	Indicates whether a patient has previously had a cesarean section.
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

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

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

Translated Diagnosis Code Descr

Description	A textual description of the translated diagnosis code.
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

Translated Diagnosis Code Set Code Sk

Description	A code indicating the diagnostic code set, standard or source used for the translated diagnosis code. For example: ICD-10 ICD-9
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

Translated Diagnosis Code Sk

Description	A code indicating the disease diagnosis based on a diagnosis code set. The translated code relates to a code allocated to the diagnosis other than the one supplied. Translated codes may be used to maintain consistency or to facilitate migration from one code set to another.
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

Translation Dt

Description	The date upon which the translation was performed.
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

Translation Rule Applied Code Sk

Description	The business rule used to perform the translation.
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

Translation Rule Descr

Description	A textual description of the business rule used to perform the translation.
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

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

Diagnosis Detail_Diagnosis_FK

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

Primary Key Details

Diagnosis Detail PK

Key Attribute	Diagnosis Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model