Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
Ailment
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| AilmentSID | INTEGER | ? | MANDATORY | System generated unique id using the Ailment sequence. |
| PracticeID | INTEGER | ? | MANDATORY | FK |
| PatientID | INTEGER | ? | MANDATORY | FK |
| Name | CHARACTER(30) | MANDATORY | User entered name of ailment. | |
| CaseSID | INTEGER | ? | OPTIONAL | FK |
| Reason | CHARACTER(1) | OPTIONAL | User entered reason for the ailment. Reasons are validated by the lookup type Ailment Reason. | |
| EmploymentRelated | CHARACTER(1) | OPTIONAL | User entered flag to indicate if the ailment is related to employment. Valid values are (Y)es or (N)o as provided in the Confirmation lookup type. | |
| AccidentRelated | CHARACTER(1) | OPTIONAL | User entered flag to indicate source of accident. Accident source is obtained from the lookup type AccidentType. Possible values are: (A)uto , (H)ome , (W)ork , (O)ther , (N)one | |
| AccidentHour | CHARACTER(2) | OPTIONAL | User entered hour the accident occurred. | |
| AccidentState | CHARACTER(2) | OPTIONAL | Two letter code of the state. User entered. | |
| FirstSymptomDate | DATE | OPTIONAL | User entered date symptom first occurred. | |
| FirstConsultDate | DATE | OPTIONAL | User entered date patient first consulted. | |
| FirstConsultHour | INTEGER | 0 | OPTIONAL | User entered hour the patient was first consulted. |
| OldSymptomsExist | CHARACTER(1) | OPTIONAL | User entered flag to indicate if old sysmptoms exist. Valid values are (Y)es or (N)o as provided in the Confirmation lookup type. | |
| OldSymptomsSource | CHARACTER(1) | OPTIONAL | User entered flag to indicate source of old symptom. Symptom source is obtained from the lookup type SymptomSource. Possible values are: (I)llness , (P)regnancy , (A)ccident | |
| SimilarIllnessStart | DATE | OPTIONAL | User entered date the similar illness started. | |
| DueToEmergency | CHARACTER(1) | OPTIONAL | User entered flag to indicate if the ailment is due to an emergency. Valid values are (Y)es or (N)o as provided in the Confirmation lookup type. | |
| AuthorizationNumber | CHARACTER(30) | OPTIONAL | User entered authorization number as provided by insurance company. | |
| HoldClaim | CHARACTER(1) | OPTIONAL | User set flag to indicate any claims associated with the ailment are not to be submitted. Possible values are (Y)es or (N)o and are validated by the Confirmation lookup type. | |
| UBBillType | CHARACTER(3) | OPTIONAL | User set UB bill type. | |
| 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. |
| RefDoctorID | INTEGER | ? | OPTIONAL | FK |
| InpatientVisitSID | INTEGER | ? | OPTIONAL | FK |
| WorkersCompSID | INTEGER | ? | OPTIONAL | FK |
| GeneralPageSaved | CHARACTER(1) | No_Value__N_ | OPTIONAL | Indicates that a general ailment page has been recorded. Possible values: (Y)es, (N)o |
| UBPageSaved | CHARACTER(1) | No_Value__N_ | OPTIONAL | Indicates that a UB ailment page has been recorded. Possible values: (Y)es, (N)o |
| EAPageSaved | CHARACTER(1) | No_Value__N_ | OPTIONAL | Indicates that a extended information ailment page has been recorded. Possible values: (Y)es, (N)o |
| UBOtherProviderID | INTEGER | ? | OPTIONAL | FK - RefDoctor Table. UB Other Provider |
| UBProviderType | CHARACTER(15) | OPTIONAL | Obsolete. Do NOT use. | |
| AccidentCountry | CHARACTER(2) | OPTIONAL | Two letter code of the country. User entered. Validated by the countrycode lookuptype. | |
| AnotherRespParty | CHARACTER(1) | OPTIONAL | Y/N Flag indicating if another party is responsible for the injury. User entered. | |
| UBAttendingProviderID | INTEGER | ? | OPTIONAL | FK - RefDoctor Table. UB Attending Provider |
| UBOperatingProviderID | INTEGER | ? | OPTIONAL | FK - RefDoctor table. UB Operating Provider |
| UBDiagRelGroup | CHAR(6) | OPTIONAL | Diagnosis Related Group. From user defined lookup type DRGCodes. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| RefDoctor | Ailment.UBOperatingProviderID = RefDoctor.RefDoctorID | RESTRICT if Ailment exists |
| RefDoctor | Ailment.UBAttendingProviderID = RefDoctor.RefDoctorID | RESTRICT if Ailment exists |
| RefDoctor | Ailment.UBOtherProviderID = RefDoctor.RefDoctorID | RESTRICT if Ailment exists |
| InpatientVisit | Ailment.InpatientVisitSID = InpatientVisit.InpatientVisitSID | SET NULL if Ailment exists |
| WorkersComp | Ailment.WorkersCompSID = WorkersComp.WorkersCompSID | NONE if Ailment exists |
| RefDoctor | Ailment.RefDoctorID = RefDoctor.RefDoctorID | RESTRICT if Ailment exists |
| Patient | Ailment.PracticeID = Patient.PracticeID and Ailment.PatientID = Patient.PatientID |
RESTRICT if Ailment exists |
| Child Table | Join Phrase | When deleting Ailment record... |
|---|---|---|
| RISStudy | RISStudy.AilmentSID = Ailment.AilmentSID | RESTRICT if RISStudy exists |
| RISVisit | RISVisit.AilmentSID = Ailment.AilmentSID | RESTRICT if RISVisit exists |
| EAObjectData | EAObjectData.EAObjectSID = Ailment.AilmentSID | CASCADE if EAObjectData exists |
| AilmentNote | AilmentNote.AilmentSID = Ailment.AilmentSID | CASCADE if AilmentNote exists |
| AilmentDiagnosis | AilmentDiagnosis.AilmentSID = Ailment.AilmentSID | CASCADE if AilmentDiagnosis exists |
| UBOccurrenceCode | UBOccurrenceCode.AilmentSID = Ailment.AilmentSID | CASCADE if UBOccurrenceCode exists |
| UBConditionCode | UBConditionCode.AilmentSID = Ailment.AilmentSID | CASCADE if UBConditionCode exists |
| Claim | Claim.AilmentSID = Ailment.AilmentSID | RESTRICT if Claim exists |
| UBSpanCode | UBSpanCode.AilmentSID = Ailment.AilmentSID | CASCADE if UBSpanCode exists |
| ChargeCoverage | ChargeCoverage.AilmentSID = Ailment.AilmentSID | SET NULL if ChargeCoverage exists |
| AilmentProcedure | AilmentProcedure.AilmentSID = Ailment.AilmentSID | CASCADE if AilmentProcedure exists |
| ProcedureEvent | ProcedureEvent.AilmentSID = Ailment.AilmentSID | RESTRICT if ProcedureEvent exists |