Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPatientCareAlert Contains specific alert information for the patient.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HPatientCareAlert Rows generated by Architecture
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID generated by Architecture
RecordIdintNULL RecordId of the Patient
Descriptionvarchar(20)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 HPatientCareAlert row
CreationTimesmalldatetimeNULL Date and time when the object is created.
PrecautionsToSPvarchar(255)NULL Precautions that are raised to the service provider.
FromDatedatetimeNULL Start date and time for when the precautions need to be taken for the patient.
ToDatedatetimeNULL Last date and time when the precautions need to be taken for the patient.
Patient_oidintNOT NULL ObjectID of the patient. Must be in HPatient Table.
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