Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HCallbackListDef This table holds the definition of the callback lists.
Column Name Column Datatype Column Null Option Column Comment
CallbackListDefOidINTNOT NULL This is the primary key.
CallbackListNameVARCHAR(255)NOT NULL This is the name assigned to the callback list.
CallbackListAbbrVARCHAR(64)NOT NULL This is the abbreviation assigned to the callback list.
CallbackListTypeVARCHAR(10)NOT NULL This indicates the type of the list("Customer", "MyItems", "Quality", "Results").
CBLIsEndedINTNOT NULL This indicates if the callback list definition ended. Allowable Values: 0 - No, 1 - Yes.
CBLStartedByUserOidINTNOT NULL This is the user who added the callback list.
CBLStartedByUserLoginIdVARCHAR(100)NOT NULL This is the Login ID of the user who added the callback list.
CBLStartedDTimeMinsSMALLDATETIMENOT NULL This indicates the start date/time for the callback list.
CBLEndedByUserOidINTNULL This is the user who ended the callback list.
CBLEndedByUserLoginIdVARCHAR(100)NULL This is the login ID of the user who ended the callback list.
CBLEndedDTimeMinsSMALLDATETIMENULL This indicates the end date/time of the callback list.
CBLVisibilityDaysSMALLINTNULL This indicates the duration in days that a callback is visible in a callback list.
ResultFlowSheetOidINTNULL If the callback list type is "Results", then this is the flowsheet that is associated to the callback list.
IsResultNormalSMALLINTNOT NULL This indicates that normal results will qualify a patient for the callback list. Allowable Values: 0 - No, 1 - Yes.
IsResultCriticalSMALLINTNOT NULL This indicates that critical results will qualify a patient for the callback list. Allowable Values: 0 - No, 1 - Yes.
IsResultAbnormalSMALLINTNOT NULL This indicates that abnormal results will qualify a patient for the callback list. Allowable Values: 0 - No, 1 - Yes.
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