Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
Diagnosis
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| DiagnosisCode | CHARACTER(10) | MANDATORY | The diagnosis code corresponding to the diagnosis. User entered. | |
| Description | CHARACTER(60) | OPTIONAL | Description of the diagnosis code. User entered. | |
| Class | CHARACTER(6) | OPTIONAL | User selects diagnosis class code. Diagnosis class codes are defined in the LookupCode table for the lookup type 'DiagnosisClass'. Codes for the lookup type 'DiagnosisClass' are user definable. | |
| Sex | CHARACTER(1) | Gender_Class | MANDATORY | User selects sex. Sex codes are defined in the LookupCode table for the lookup type 'GenderClass'. Codes for the lookup type 'GenderClass' are not user definable. Acceptable values are (M)ale only, (F)emale only, or (B)oth. |
| RecordStatus | CHARACTER(1) | MANDATORY | User selected record status for the diagnosis code. RecordStatus is defined in the LookupCode table for the lookup type 'RecordStatus'. Codes for lookup type 'RecordStatus' are not user definable. Valid codes are (A)ctive and (I)nactive. | |
| 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. |
| MedcinID | INTEGER | ? | OPTIONAL | Medcin ID that best described the diagnosis. |
| SnomedCode | CHARACTER(20) | OPTIONAL | Snomed code that best describes the diagnosis. | |
| ICDVersion | CHAR(6) | OPTIONAL | User selects ICD version code. ICD version codes are defined in the LookupCode table for the lookup type 'DiagnosisICDVersion'. Codes for the lookup type are system defined. | |
| LongDescription | CHAR(300) | OPTIONAL | The long description of the diagnosis code. Used in Intergy version 8.10.00 and up. | |
| StartDate | DATE | OPTIONAL | Date diagnosis became effective | |
| EndDate | DATE | OPTIONAL | Date diagnosis is no longer effective. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|
| Child Table | Join Phrase | When deleting Diagnosis record... |
|---|---|---|
| Encounter | Encounter.CQMPrimaryDiagnosis = Diagnosis.DiagnosisCode | RESTRICT if Encounter exists |
| EncounterDiagnosis | EncounterDiagnosis.DiagnosisCode = Diagnosis.DiagnosisCode | RESTRICT if EncounterDiagnosis exists |
| PatientOMOrderSet | PatientOMOrderSet.DiagnosisCode = Diagnosis.DiagnosisCode | SET NULL if PatientOMOrderSet exists |
| PatientVacDose | PatientVacDose.ChargeDiagnosisCode = Diagnosis.DiagnosisCode | SET NULL if PatientVacDose exists |
| PatientProblem | PatientProblem.DiagnosisCode = Diagnosis.DiagnosisCode | RESTRICT if PatientProblem exists |
| LabOrderTaskTestDiag | LabOrderTaskTestDiag.DiagnosisCode = Diagnosis.DiagnosisCode | CASCADE if LabOrderTaskTestDiag exists |
| LabOrderTask | LabOrderTask.DiagnosisCode = Diagnosis.DiagnosisCode | NONE if LabOrderTask exists |
| InpatientVisit | InpatientVisit.DiagnosisCode = Diagnosis.DiagnosisCode | RESTRICT if InpatientVisit exists |
| WorkersCompDiagnosis | WorkersCompDiagnosis.DiagnosisCode = Diagnosis.DiagnosisCode | RESTRICT if WorkersCompDiagnosis exists |
| RxDiagnosis | RxDiagnosis.DiagnosisCode = Diagnosis.DiagnosisCode | RESTRICT if RxDiagnosis exists |
| RefTreatmentResultDiagnosis | RefTreatmentResultDiagnosis.DiagnosisCode = Diagnosis.DiagnosisCode | RESTRICT if RefTreatmentResultDiagnosis exists |
| ReferralDiagnosis | ReferralDiagnosis.DiagnosisCode = Diagnosis.DiagnosisCode | RESTRICT if ReferralDiagnosis exists |
| AilmentDiagnosis | AilmentDiagnosis.DiagnosisCode = Diagnosis.DiagnosisCode | RESTRICT if AilmentDiagnosis exists |
| LabOrderTestDiag | LabOrderTestDiag.DiagnosisCode = Diagnosis.DiagnosisCode | RESTRICT if LabOrderTestDiag exists |
| ProcedureEventDiag | ProcedureEventDiag.DiagnosisCode = Diagnosis.DiagnosisCode | RESTRICT if ProcedureEventDiag exists |