Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
InpatientVisit
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| InpatientVisitSID | INTEGER | ? | MANDATORY | System generate unique identifier. Uses the General sequence. |
| PracticeID | INTEGER | ? | MANDATORY | FK |
| PatientID | INTEGER | ? | MANDATORY | FK |
| StaffID | INTEGER | ? | OPTIONAL | FK |
| ServiceCenterID | INTEGER | ? | OPTIONAL | FK |
| RoomNumber | CHARACTER(8) | OPTIONAL | User entered room number the patient is in. | |
| AdmissionType | CHARACTER(6) | OPTIONAL | User selected admission type. Admission types are user defined and selected from the lookup type AdmissionType. | |
| AdmissionSource | CHARACTER(6) | OPTIONAL | User selected admission source. Admission sources are user defined and selected from the lookup type AdmissionSource. | |
| AdmissionDate | DATE | OPTIONAL | User entered date of admission. | |
| AdmissionHour | CHARACTER(2) | OPTIONAL | User entered hour of admission. Possible values are 0 to 23. | |
| DischargeStatus | CHARACTER(6) | OPTIONAL | User selected discharge status. Discharge status is user defined and selected from the lookup type DischargeStatus. | |
| DischargeDate | DATE | OPTIONAL | User entered date of discharge. | |
| DischargeHour | CHARACTER(2) | OPTIONAL | User entered hour of discharge. Possible values are 0 to 23. | |
| EstStayLength | INTEGER | 0 | OPTIONAL | User entered estimated stay in days. Possible values are 1 to 999. |
| 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. |
| ContactProviderID | INTEGER | ? | OPTIONAL | FK |
| InpatientVisitType | CHARACTER(1) | H | MANDATORY | Identifies the type of inpatient visit. Possible values: (F)acility Visit and (H)ospital Rounds Default: "H" |
| DiagnosisCode | CHARACTER(10) | OPTIONAL | The diagnosis code corresponding to the diagnosis. User entered. | |
| DischargeRefProviderID | INTEGER | ? | OPTIONAL | FK |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| RefDoctor | InpatientVisit.DischargeRefProviderID = RefDoctor.RefDoctorID | RESTRICT if InpatientVisit exists |
| Diagnosis | InpatientVisit.DiagnosisCode = Diagnosis.DiagnosisCode | RESTRICT if InpatientVisit exists |
| Provider | InpatientVisit.ContactProviderID = Provider.ProviderID | RESTRICT if InpatientVisit exists |
| Patient | InpatientVisit.PracticeID = Patient.PracticeID and InpatientVisit.PatientID = Patient.PatientID |
RESTRICT if InpatientVisit exists |
| ServiceCenter | InpatientVisit.ServiceCenterID = ServiceCenter.ServiceCenterID | RESTRICT if InpatientVisit exists |
| Staff | InpatientVisit.PracticeID = Staff.PracticeID and InpatientVisit.StaffID = Staff.StaffID |
RESTRICT if InpatientVisit exists |
| Child Table | Join Phrase | When deleting InpatientVisit record... |
|---|---|---|
| Ailment | Ailment.InpatientVisitSID = InpatientVisit.InpatientVisitSID | SET NULL if Ailment exists |
| InpatientVisitNote | InpatientVisitNote.InpatientVisitSID = InpatientVisit.InpatientVisitSID | CASCADE if InpatientVisitNote exists |