Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HExtendedPatientVisit Contains extended patient visit information
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HExtendedPatientVisit Rows generated by Architecture
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID generated by Architecture
RecordIdintNULL RecordId of the Patient
Descriptionvarchar(255)NULL Not Used
IsVersionedbitNOT NULL Indicates that row has been modified. Allowable Values: 0 - Not Modified 1 - Modified
CreatedUserIdintNULL UserId of the user who created the HExtendedPatientVisit row
CreationTimesmalldatetimeNULL Date and time when the object is created.
UserDefinedNumeric1float(53)NULL Additional numeric information about patient visit.
UserDefinedNumeric2float(53)NULL Additional numeric information about patient visit.
UserDefinedNumeric3float(53)NULL Additional numeric information about patient visit.
UserDefinedNumeric4float(53)NULL Additional numeric information about patient visit.
UserDefinedNumeric5float(53)NULL Additional numeric information about patient visit.
UserDefinedString1varchar(255)NULL Additional information about patient visit.
UserDefinedString2varchar(255)NULL Additional information about patient visit.
UserDefinedString3varchar(255)NULL Additional information about patient visit.
UserDefinedString4varchar(255)NULL Additional information about patient visit.
UserDefinedString5varchar(255)NULL Additional information about patient visit.
UserDefinedString6varchar(255)NULL Additional information about patient visit.
UserDefinedString7varchar(255)NULL Additional information about patient visit.
UserDefinedString8varchar(255)NULL Additional information about patient visit.
UserDefinedString9varchar(255)NULL Additional information about patient visit.
UserDefinedString10varchar(255)NULL Additional information about patient visit.
UserDefinedString11varchar(255)NULL Additional information about patient visit.
UserDefinedString12varchar(255)NULL Additional information about patient visit.
UserDefinedString13varchar(255)NULL Additional information about patient visit.
UserDefinedString14varchar(255)NULL Additional information about patient visit.
UserDefinedString15varchar(255)NULL Additional information about patient visit.
UserDefinedString16varchar(255)NULL Additional information about patient visit.
UserDefinedString17varchar(255)NULL Additional information about patient visit.
UserDefinedString18varchar(255)NULL Additional information about patient visit.
UserDefinedString19varchar(255)NULL Additional information about patient visit.
UserDefinedString20varchar(255)NULL Additional information about patient visit.
UserDefinedString21varchar(255)NULL Additional information about patient visit.
UserDefinedString22varchar(255)NULL Additional information about patient visit.
UserDefinedString23varchar(255)NULL Additional information about patient visit.
UserDefinedString24varchar(255)NULL Additional information about patient visit.
UserDefinedString25varchar(255)NULL Additional information about patient visit.
LastCngDtimedatetimeNULL Last system UTC date /time when row was updated.

Return to Table-Index

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