Entity Patient Transaction Diagnosis

DescriptionThe primary diagnosis code that the healthcare provider uses for billing purposes.

Attributes
Diagnosis CodeDiagnosis Code

Relationship
Bill Diagnosis_Bill Line_FKBill Diagnosis_Bill Line_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Diagnosis Code
DescriptionA code that specifies the diagnosis and identifies the disease or patient condition.
Diagnosis codes generally comply with the International Classification of Diseases code system.
Codes ICD-9 CM and ICD-10 are typically used.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Bill Diagnosis_Bill Line_FK
Is Identifying Relationshiptrue
Child TablePatient Transaction Diagnosis
Child Role Nameprimary diagnosis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePatient Financial Transaction
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE