Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPatientAdditionalInfo Contains latest patient orders and results date information.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HPatientAdditionalInfo Rows generated by Architecture
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID generated by Architecture
RecordIdintNULL Patient Record Id.
Descriptionvarchar(1)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 HPatientAdditionalInfo row
CreationTimesmalldatetimeNULL Creation Date and Time of the row creation.
ResultDateTimesmalldatetimeNULL Date and Time when the patient result was received.
AbnormalResultDateTimesmalldatetimeNULL Date and time when the patient result was received as abnormal.
Patient_oidintNOT NULL Patient Object ID.
LastOrderCngDateTimedatetimenull Date and Time when the last patient order was placed for the patient.
LastResultChangeDTDateTimeNULL Date and Time when the last patient result was received.
LastProviderDocCngDateTimeDateTimeNULL Not in use.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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