Last Updated: 7/22/2025 8:42:49 PM

Intergy Version: 22.00.00.00

RISVisit

Table Definition  Parent Tables  Child Tables

Table Definition

Description: This table is used to record patient radiology visit information.

Field Datatype Default Null Option Comment
RISVisitSID INTEGER ?   MANDATORY System generated from the RIS sequence.
Description CHARACTER(60)   OPTIONAL System generated description of the patient radiology visit. Derived from Study Reason class and bill method.
RefDoctorID INTEGER ?   OPTIONAL FK - Provider referring patient to radiologist
PracticeID INTEGER ?   MANDATORY FK
PatientID INTEGER ?   MANDATORY FK
AilmentSID INTEGER ?   MANDATORY FK
VisitDate DATE   OPTIONAL User entered. Visit date.
ReferenceDate DATE   OPTIONAL User entered. Visit date.
TargetDate DATE   OPTIONAL User entered. Target date of visit.
WorkGroup CHARACTER(6)   OPTIONAL User entered code allowing visit to be organized and reported on. Validated by user maintained lookup type RISWorkGroup.
VisitStatus CHARACTER(1)   OPTIONAL System defined. Derived from study status associated with visit.
Note CHARACTER(28000)   OPTIONAL User entered comment
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 TableJoin PhraseWhen deleting parent record...
Ailment RISVisit.AilmentSID = Ailment.AilmentSID RESTRICT if RISVisit exists
RefDoctor RISVisit.RefDoctorID = RefDoctor.RefDoctorID RESTRICT if RISVisit exists
Patient RISVisit.PracticeID = Patient.PracticeID and
RISVisit.PatientID = Patient.PatientID		 RESTRICT if RISVisit exists

Child Tables
Child TableJoin PhraseWhen deleting RISVisit record...
RISStudy RISStudy.RISVisitSID = RISVisit.RISVisitSID CASCADE if RISStudy exists