Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HExtendedPatient Contains extended patient information.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HExtendedPatient 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 if the row has been modified. Allowable Values: 0 - Not Modified 1 - Modified
CreatedUserIdintNULL UserId of the user who created the HExtendedPatient row
CreationTimesmalldatetimeNULL Date and time when the object is created.
UserDefinedNumeric1float(53)NULL Additional numeric information about an extended patient.
UserDefinedNumeric2float(53)NULL Additional numeric information about an extended patient.
UserDefinedNumeric3float(53)NULL Additional numeric information about an extended patient.
UserDefinedNumeric4float(53)NULL Additional numeric information about an extended patient.
UserDefinedNumeric5float(53)NULL Additional numeric information about an extended patient.
UserDefinedString1varchar(255)NULL Additional information about an extended patient.
UserDefinedString2varchar(255)NULL Additional information about an extended patient.
UserDefinedString3varchar(255)NULL Additional information about an extended patient.
UserDefinedString4varchar(255)NULL Additional information about an extended patient.
UserDefinedString5varchar(255)NULL Additional information about an extended patient.
UserDefinedString6varchar(255)NULL Additional information about an extended patient.
UserDefinedString7varchar(255)NULL Additional information about an extended patient.
UserDefinedString8varchar(255)NULL Additional information about an extended patient.
UserDefinedString9varchar(255)NULL Additional information about an extended patient.
UserDefinedString10varchar(255)NULL Additional information about an extended patient.
UserDefinedString11varchar(255)NULL Additional information about an extended patient.
UserDefinedString12varchar(255)NULL Additional information about an extended patient.
UserDefinedString13varchar(255)NULL Additional information about an extended patient.
UserDefinedString14varchar(255)NULL Additional information about an extended patient.
UserDefinedString15varchar(255)NULL Additional information about an extended patient.
UserDefinedString16varchar(255)NULL Additional information about an extended patient.
UserDefinedString17varchar(255)NULL Additional information about an extended patient.
UserDefinedString18varchar(255)NULL Additional information about an extended patient.
UserDefinedString19varchar(255)NULL Additional information about an extended patient.
UserDefinedString20varchar(255)NULL Additional information about an extended patient.
UserDefinedString21varchar(255)NULL Additional information about an extended patient.
UserDefinedString22varchar(255)NULL Additional information about an extended patient.
UserDefinedString23varchar(255)NULL Additional information about an extended patient.
UserDefinedString24varchar(255)NULL Additional information about an extended patient.
UserDefinedString25varchar(255)NULL Additional information about an extended patient.
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