Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HCallbackAssignment This table is used to store callback assignment information.
Column Name Column Datatype Column Null Option Column Comment
CallbackAssignmentOidBIGINTNOT NULL This is the primary key.
CallbackOidBIGINTNOT NULL This is a foreign key to the HCallback table.
CallbackListDefOidINTNOT NULL This is a foreign key to the HCallbackListDef table.
CBListContainerTypeVARCHAR(8)NOT NULL This indicates the context associated with a callback list. Allowable values: "TbOid".
CBListContainerOidINTNOT NULL This is the object ID of the context associated with a callback list. For example, TrackingboardOid.
CBAssigneeStaffOidINTNULL This indicates which staff is assigned.
CBAssignmentStartDTimeMinsSMALLDATETIMENOT NULL This indicates the date/time when this assignment started.
CBAssignmentEndDTimeMinsSMALLDATETIMENULL This indicates the date/time when this assigment ended.
CBAssignmentStartedByOidINTNOT NULL This is the user who started the assignment.
CBAssignmentEndedByOidINTNULL This is the user who ended the assignment.
CBAssignmentStartedByLoginIdVARCHAR(100)NOT NULL This is the login ID of the user who started the assignment.
CBAssignmentEndedByLoginIdVARCHAR(100)NULL This is the login ID of the user who ended the assignment.
CBAssignmentIsEndedSMALLINTNOT NULL This indicates if the assignment ended. 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