Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPatientVisit Contains patient's visit information
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HPatientVisit Rows
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID
RecordIdintNULL RecordId of the Patient
Descriptionvarchar(75)NULL User entered data during registration. It can be visit location or Unit contacted name with additional free text information.
IsDeletedtinyintNOT NULL Indicates if the row has been deleted. Allowable Values: 0 - False, 1 - True(deleted)
IsVersionedbitNOT NULL Indicates if the row has been modified. Allowable Values: 0 - Not Modified 1 - Modified
CreatedUserIdintNULL UserId of the user who created the visit
CreationTimesmalldatetimeNULL Date and Time when the row was created.
VisitIDvarchar(30)NULL VisitID is a running number starting with 1 and incremented everytime a new visit is created for a patient
AlternateVisitIDvarchar(75)NULL Alternate Visit ID entered by the user during registration. Combination of AlternateVisitID and Account ID used to uniquely identify patient visit.
PatientAccountIDvarchar(20)NULL Patient Account ID entered by the user during registration. Combination of AlternateVisitID and Account ID used to uniquely identify patient visit.
VIPIndicatorbitNULL Indicates if the visit is a VIP. Allowable Values: 0 - False, 1 - True(VIP Patient)
VisitStartDateTimedatetimeNOT NULL Date and Time when visit was started.
VisitEndDateTimedatetimeNULL Date and Time when patient was discharged.
VisitStatustinyintNULL Indicates if Visit is Active(0), Closed(1), Cancelled(2), Scheduled(3), MarkedForDischarge(4)
VisitTypeCodevarchar(30)NULL Visit type like IP, OP etc. Value of this field must exist as Code in HPatientClass Table.
Debtorvarchar(64)NULL Debtor is a Data Dictionary Item(DDI).
PatientCategory1varchar(64)NOT NULL Patient Category
PatientLocationNamevarchar(75)NULL Healthcareunitname of the Patient Location.
Remarksvarchar(255)NULL Remarks or Comments related to the visit and entered by the user as a free text.
VisitCategoryvarchar(64)NOT NULL Visit Category
PrivacyTextvarchar(50)NULL Additional free text comments related to the patient visit entered by the user.
PatientReasonForSeekingHCvarchar(255)NULL Indicates Chief Complaint
PaymentModevarchar(64)NULL Payment Mode
Financialclassvarchar(64)NULL Financial class
ProviderGenderPreferencetinyintNULL Not Used
ExpectedLengthofStaysmallintNULL Additional comments entered by the user with expected days of stay for the visit.
ActualLengthofStaysmallintNULL Additional comments entered by the user during discharge with actual days of stay.(Not commonly used).
CorrectedByvarchar(255)NULL Not used
Commentsvarchar(120)NULL Additional Comments or Remarks related to the visit and entered by the user as a free text.
LatestBedNamevarchar(75)NULL Name of the most current bed occupied by the patient.
DeltaValueintNULL Delta value of the Visit Type. Valued by the client in ADT preferences.
UnitContactedNamevarchar(75)NULL Healthcareunitname of the Unit Contacted.
VisitLocationvarchar(64)NULL Visit Location
ReasonForVisitvarchar(64)NULL Reason For Visit
DischargeDispositionvarchar(64)NULL Discharge Disposition
IsolationIndicatorvarchar(64)NULL IsolationIndicator
PatientConditionvarchar(64)NULL PatientCondition
EntityNamevarchar(75)NULL Name of the Healthcare Entity.
EntityAbbvarchar(10)NULL Abbreviation of the Healthcare Entity.
AccommodationTypevarchar(64)NULL AccommodationType
DischargeFormIDintNULL Patient ID used during discharge process. This field can be valued to Objectid of HPatientIdentifiers table pointed to the specific ID type.(example: SSN#).
Patient_oidintNOT NULL ObjectID of the patient. Related to the objectID from HPatient table.
UnitContacted_oidintNULL ObjectID of the HCU that was contacted during registration. Related to Objectid in HHealthcareUnit table.
ReferringInstitution_oidintNULL Referring institution ObjectID. Related to the Objectid in HReferringInstitution table.
PatientLocation_oidintNULL ObjectID of the HCU where patient is located. Related to the Objectid in HHealthcareUnit table.
PatientClass_oidintNOT NULL Visit type objectid related to the ObjectID in HPatientClass table.
Entity_oidintNULL Entity of the visit. Related to the ObjectID from HHealthcareUnit table for the Entity.
PatientVisitExtension_oidintNULL ObjectID from HExtendedPatientVisit
ClinicCodevarchar(64)NULL Clinic Code is a DDI.
DNRValuevarchar(64)NULL DNRValue. Not commonly used.
Confidentialityvarchar(64)NULL Confidentiality
DischargeTovarchar(64)NULL DischargeTo
ExternalMidWifevarchar(64)NULL ExternalMidWife
TypeCodeintNULL Visit type code. Allowable value : 2 - Service.
DischargeTypeCodevarchar(64)NULL Discharge Type Code
Weightfloat(53)NULL Not Used
VentilatorTimefloat(53)NULL Not Used
ComplicationbitNULL Not Used
AdmissionTypevarchar(64)NULL Not Used
ReasonforDischargevarchar(64)NULL Reason for Discharge
StartingVisitOIDintNULL This field is always valued and it can be the same as Initial Visit Objectid or can point to the Parent Visit Oid.
PatientStatusCodevarchar(255), Patient Status Code
PublicityIndicatorvarchar(64)NULL Publicity Indicator.
CriticalCaretinyint, Indicates if the visit Is a CriticalCare, Was a Critical Care or Never a Critical Care. Allowable Values: 0 - False 1 - True
LastCngDtimedatetimeNULL System UTC date /time when row was updated.
AdmitReasoncodevarchar(64)NULL Admit Reason Code
PreVisitDatesmalldatetimeNULL Previous Visit Date. Can be NULL or valued to the initial visit start date and time.
LevelOfCarevarchar(64)NULL Level of Care is a DDI
ReadmissionIndicatorchar(2)NULL Not Used
RTLSTagIdvarchar(20)NULL Not used
AdmitSourcevarchar(64)NULL Admit Source
ReferralSourcevarchar(64)NULL Referral Source
PrevDschDatesmalldatetimeNULL Not Used
ExpAdmDTimesmalldatetimeNULL Expected Admit Date and time. This field can be valued by the user during registration.
ExpDschDTimesmalldatetimeNULL Expected Discharge Date and Time. This field can be valued by the user during registration.
PreArrivalTrackingNovarchar(30)NULL Unique visit identifier for Pre-Arrival - Auto generated by system
PreArrivalMergeStatusvarchar(10)NULL Status of Merge. Can be valued to Null Or "Not_Merged".
RegistrationStatusvarchar(10)NULL Track the progression of the pre-arrival. Values are No_Reg, Scheduled, Quick_Reg, Full_Reg, No_Show.
ModeOfArrivalvarchar(64)NULL Patient Arrival Mode. Examples: Ambulance, car, etc.
TransportAgencyvarchar(64)NULL Transport Agency
IsNotInterfaceablesmallintNULL Field to indicate orders or results that can be assigned. Allowable Values: 1 - True , Null - not valued.
SpecialNeedsvarchar(64)NULL Indication if the patient has any special needs for an appointment.
RestrictionIndicatorvarchar(64)NULL Indicator of the visit restrictions.
IsAmbulatorytinyintNULL Indicates whether visit is Ambulatory. Allowable Values: 1 - True(Ambulatory visit), 0 - False(Not Ambulatory visit), Null - not valued.
ClinicOrg_oidintNULL Valued to oid of the organization unit when ClinicCode holds a valid ExternalHCU value
ClinicOrgNamevarchar(75)NULL Valued to the name of the organization unit when ClinicCode matches valid ExternalHCU value.
PresentingVisitTypevarchar(30)NULL Initial Visit Type of when the Visit was created
PresentingDateTimedatetimeNULL Initial Visit Date time of when the visit was created
ChiefComplaintCodevarchar(20)NULL Code for Chief Complaint of the patient's visit.
ChiefComplaintCodingSystemvarchar(20)NULL Coding system for the chief complaint code. For Example SNM(SNOMED).
IsOnLeaveOfAbsencebitNULL Indicates if the patient is on a Leave of Absence(LOA)
AdmitReasonTextvarchar(255)NULL Admit reason for the patient
AdmitReasonCodingSystemvarchar(20)NULL Admit reason coding system for the patient
HIEConsentvarchar(3)NULL Health Information Exchange(HIE) Consent. Can be Null or valued by the user during registration.

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates