Overview Top Package Entity

Business Data Model Data Model

---

Entity Diagnosis Code

Description

Standard diagnosis codes such as the International Classification of Diseases (ICD-9 ICD-10).

Attributes

Alternate Diagnosis Code

Cost Of Care Range

Curability Rating

Diagnosis Code

Diagnosis Descr

Exempt Ind

Formal Name

Relationship

Diagnosis Code_Coding System Version_FK

Diagnosis Code_Diagnosis Code_FK

Dependencies

NONE

Reverse Dependencies

Attribute Details

 Alternate Diagnosis Code

Description	An alternative code that also uniquely identifies a diagnosis code within a domain.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Cost Of Care Range

Description	Classifies disease according to the predicted cost for treating any patient who has the disease.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Curability Rating

Description	Indicates the degree or probability of recovering from a particular disease or condition.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Diagnosis Code

Description	A code that specifies the diagnosis and identifies the disease or patient condition. Diagnosis codes generally comply to the International Classification of Diseases code system. Codes ICD-9 CM or ICD-10 are typically used.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
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 [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Exempt Ind

Description	Identifies code as being exempt from Hospital Acquired Condition processing.
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

---

 Formal Name

Description	The formal name that is recognized by the medical profession. For example: AIDS. Broken tibia. Diabetes. Hepatitis B.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

 Diagnosis Code_Coding System Version_FK

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

---

 Diagnosis Code_Diagnosis Code_FK

Is Identifying Relationship	false
Child Table	Diagnosis Code
Child Role Name	is associated to
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 Code
Parent Multiplicity	ZERO_TO_MANY
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

Overview Top Package Entity

Business Data Model Data Model