Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
CallbackOid | BIGINT | NOT NULL | This is the primary key. |
Context_OID | BIGINT | NOT NULL | This is the ID of the context object associated with this record. |
ContextType | VARCHAR(8) | NOT NULL | This indicates the type of the context object. Allowable values: "EdVisit". |
CallbackListDefOid | INT | NOT NULL | This indicates the queue type that this item belongs to. This is a foreign key to the callback definition table. |
CBOwnerUserOid | INT | NULL | 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. |
CBOwnerLoginId | VARCHAR(100) | NULL | This is the login ID of the user who owns this callback. |
CallbackStatus | VARCHAR(10) | NOT NULL | This indicates the status of the callback. Allowable values include: "pending", "inprogress", "complete", "removed", "deleted", "uncharted". |
CBCreatedReason | VARCHAR(255) | NULL | This is the reason why this callback was created. It is a Data Dictionary Item defined in the HDataDictionaryItem table. |
CBDelayMins | INT | NULL | This indicates the delay time frame for the callback item to be added to the queue. |
CBCreatedByUserOid | INT | NOT NULL | This is the user who created the callback item. |
CBCreatedByUserLoginId | VARCHAR(100) | NOT NULL | This is the login ID of the user who created the callback item. |
CBCreatedDtimeMins | SMALLDATETIME | NOT NULL | This is the date/time when the callback item was added to the queue. |
CBDueDTimeMins | SMALLDATETIME | NULL | This is the date/time when the callback item is due. |
CBRemovedReason | VARCHAR(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. |
CBRemovedUserOid | INT | NULL | This is the user who removed the item from the callback list. |
CBRemovedUserLoginId | VARCHAR(100) | NULL | This is the login ID of the user who removed the item from the callback list. |
CBRemovedDTimeMins | SMALLDATETIME | NULL | This indicates the date/time when the item was removed from the callback list. |
CBCompletedReason | VARCHAR(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. |
CBCompletedUserOid | INT | NULL | This is the user ID of the person who completed the callback. |
CBCompletedUserLoginId | VARCHAR(100) | NULL | This is the login ID of the user who completed the callback. |
CBCompletedDTimeMins | SMALLDATETIME | NULL | This indicates the date/time when the callback item was completed. |
CBCompletedDocumentOid | BIGINT | NULL | This is the unique document ID that completed this callback. |
CBAssigneeStaffOid | INT | NULL | This is the user that this callback is currently assigned to. |
CBDispositionDtimeMins | SMALLDATETIME | NULL | This is a denormalized version of the disposition date/time from patient milestones, tracking board removed date, or tracking board end date. |
LastCngDtime | DATETIME | NOT NULL | This indicates the current Universal Time Coordinate or Greenwich Mean Time. |