Description: This table holds the diagnosis codes at the encounter. This is so we can support ordering claim level diags and 12 diags per claim even if there is one charge.

Field	Datatype	Default	Null Option	Comment
EncounterSID	INTEGER	?	MANDATORY	FK - from Encounter table
OrderNumber	INTEGER	?	MANDATORY	The order of the diagnosis code.
DiagnosisCode	CHARACTER(10)		MANDATORY	FK - from Diagnosis table.
TimeStamp	CHARACTER(14)		OPTIONAL	System generated date/time stamp record was last written.
LastUser	INTEGER	?	OPTIONAL	User ID of user that last wrote the record.
CreateStamp	CHARACTER(14)		OPTIONAL	System generated date/time stamp record was created.
CreateUser	INTEGER	?	OPTIONAL	User ID of user that created the record.

Parent Tables

Parent Table Join Phrase When deleting parent record...

Diagnosis EncounterDiagnosis.DiagnosisCode = Diagnosis.DiagnosisCode RESTRICT if EncounterDiagnosis exists

Encounter EncounterDiagnosis.EncounterSID = Encounter.EncounterSID CASCADE if EncounterDiagnosis exists

Parent Table	Join Phrase	When deleting parent record...
Diagnosis	EncounterDiagnosis.DiagnosisCode = Diagnosis.DiagnosisCode	RESTRICT if EncounterDiagnosis exists
Encounter	EncounterDiagnosis.EncounterSID = Encounter.EncounterSID	CASCADE if EncounterDiagnosis exists

Child Tables

Child Table	Join Phrase	When deleting EncounterDiagnosis record...