Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HVisitActivity Cntains information about visit activities.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HVisitActivity Rows generated by Architecture
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID generated by Architecture
RecordIdintNULL RecordId of the Patient
Descriptionvarchar(1)NULL Most of the time it is not valued(NULL) , but can be vaued to ActivityType( 1 - Admission, 2 - Discharge, 3 - Transfer, 4 - Outpatient)
IsVersionedbitNOT NULL Indicates if the row has been modified. Allowable Values: 0 - Not Modified, 1- Modified.
CreatedUserIdintNULL UserId of the user who performed the activity
CreationTimesmalldatetimeNULL Date and time when row was created.
Visit_oidintNOT NULL ObjectID of the HPatientVisit table to which the activity belongs.
ExternalIDvarchar(75)NULL Alternate Visit Id of the HPatientVisit to which the activity belongs.
StartDateTimedatetimeNULL Date and time when the activity for the visit started.
EndDateTimedatetimeNULL Date and time when the activity for the visit ended.
UserOIDintNULL ObjectId of the user who performed the activity for the visit.
ActivityTypetinyintNULL ActivityType: 1 - Admission, 2 - Discharge, 3 - Transfer, 4 - Outpatient
ActivitySortvarchar(64)NULL ActivitySort. Can be anything or DDI item type "Patient.Visit.ActivitySort"
IsVisitCreatedbitNOT NULL Indicates if the activity created as a part of visit creation or something else like MRU Transfer
PatientCategoryvarchar(64), Patient Category . Example : Initial, Emergency, etc
IsDeletedtinyintNOT NULL Indicates that row was deleted. Allowable Values: 0 - Active row, 1- Row is deleted.
UnitContacted_oidintNULL Unit contacted at the time the visit activity was created. Must exist as Objectid in HHealthcareunit table.
PatientClass_oidintNULL Patient Class for the visit at the time the visit activity was created. Must exist in HPatientClass table.
VisitTypeCodevarchar(30)NULL Contains visity type code from hpatientvisit at the time the visit activity was created
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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