Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPtAllergyReconcile Records of when a Patient's Allergy have been Reconciled - Patient, Visit, User, Date and Time. US Only.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL Object ID of the patient's allergy reconcile session
InstanceHFCIDsmallintNOT NULL Healthcare Foundation Class ID of the object(HFCID = 3414). Note: The value specified in the ObjectID field and in this field enables unique identification of an object across the application.
RecordIdintNULL Not used.
Descriptionvarchar(1)NULL Not used.
IsVersionedbitNULL Not used.
CreatedUserIdintNULL Object ID of the User who reconciled the allergy information(HSUser table)
CreationTimesmalldatetimeNULL Date and time(local) this row was created
ReconcileSeqNointNOT NULL Reconciliation Sequence number(Unique for an environment). Used for determining the most recent reconciliation for a Patient / Visit combination.
CreatedUserNamevarchar(188)NOT NULL Name of the user who reconciled the allergy information(HSUser table)
ReconcileDateTimedatetimeNOT NULL Date and time(local) when the allergy reconciliation occurred
PatientVisitOIDintNOT NULL Object ID of the Patient Visit(HPatientVisit) associated with the patient whose allergies were reconciled
PatientOIDintNOT NULL Object ID of the Patient(HPatient) for whom the allergy information was reconciled
LastCngDtimedatetimeNOT NULL Last date and time the information was updated(UTC)

Return to Table-Index

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