Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HCallback This table is used to store callback information.
Column Name Column Datatype Column Null Option Column Comment
CallbackOidBIGINTNOT NULL This is the primary key.
Context_OIDBIGINTNOT NULL This is the ID of the context object associated with this record.
ContextTypeVARCHAR(8)NOT NULL This indicates the type of the context object. Allowable values: "EdVisit".
CallbackListDefOidINTNOT NULL This indicates the queue type that this item belongs to. This is a foreign key to the callback definition table.
CBOwnerUserOidINTNULL If the queue is "My items" then this field is valued to the user that the item belongs to, otherwise it contains the person who is performing the callback.
CBOwnerLoginIdVARCHAR(100)NULL This is the login ID of the user who owns this callback.
CallbackStatusVARCHAR(10)NOT NULL This indicates the status of the callback. Allowable values include: "pending", "inprogress", "complete", "removed", "deleted", "uncharted".
CBCreatedReasonVARCHAR(255)NULL This is the reason why this callback was created. It is a Data Dictionary Item defined in the HDataDictionaryItem table.
CBDelayMinsINTNULL This indicates the delay time frame for the callback item to be added to the queue.
CBCreatedByUserOidINTNOT NULL This is the user who created the callback item.
CBCreatedByUserLoginIdVARCHAR(100)NOT NULL This is the login ID of the user who created the callback item.
CBCreatedDtimeMinsSMALLDATETIMENOT NULL This is the date/time when the callback item was added to the queue.
CBDueDTimeMinsSMALLDATETIMENULL This is the date/time when the callback item is due.
CBRemovedReasonVARCHAR(255)NULL This indicates the reason the item was removed from the callback list. It is a Data Dictionary Item defined in the HDataDictionaryItem table.
CBRemovedUserOidINTNULL This is the user who removed the item from the callback list.
CBRemovedUserLoginIdVARCHAR(100)NULL This is the login ID of the user who removed the item from the callback list.
CBRemovedDTimeMinsSMALLDATETIMENULL This indicates the date/time when the item was removed from the callback list.
CBCompletedReasonVARCHAR(255)NULL This is the reason why the item was completed in the callback list. It is a Data Dictionary Item defined in the HDataDictionaryItem table.
CBCompletedUserOidINTNULL This is the user ID of the person who completed the callback.
CBCompletedUserLoginIdVARCHAR(100)NULL This is the login ID of the user who completed the callback.
CBCompletedDTimeMinsSMALLDATETIMENULL This indicates the date/time when the callback item was completed.
CBCompletedDocumentOidBIGINTNULL This is the unique document ID that completed this callback.
CBAssigneeStaffOidINTNULL This is the user that this callback is currently assigned to.
CBDispositionDtimeMinsSMALLDATETIMENULL This is a denormalized version of the disposition date/time from patient milestones, tracking board removed date, or tracking board end date.
LastCngDtimeDATETIMENOT NULL This indicates the current Universal Time Coordinate or Greenwich Mean Time.

Return to Table-Index

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