Table Description
WaitListEntryHistory: Records a snapshot of the details of the wait list entry for each update.

For every update that happens for a wait list entry, there will be an entry made in the WaitListEntryHistory table.This is for recording the changes done on each wait list entry.
Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Case::Entity Objects::WaitList::WaitListEntryHistory
Controlling File: core\model\Packages\Case\Wait List_cat.efx
Attributes (11)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
positiondetails The position of the client on the wait list, where 1 is the next client due to be allocated.WAIT_LIST_ENTRY_POSITION SVR_INT16
prioritydetails The priority of the wait list entry.WAIT_LIST_ENTRY_PRIORITYWaitListEntryPrioritySVR_STRING<10>
expiryDatedetails Date the wait list entry expires. After this date, the client will no longer be considered for allocation to the resource.CURAM_DATE SVR_DATE
removalReasondetails Reason for removing the client from the wait list.WAIT_LIST_ENTRY_REMOVAL_REASONWaitListRemovalReasonSVR_STRING<10>
commentsdetails Comments recorded by the user relating to the wait list entry.WAIT_LIST_ENTRY_COMMENTS SVR_STRING<300>
statusdetailsnoStatus of the wait list entry.WAIT_LIST_ENTRY_STATUSWaitListEntryStatusSVR_STRING<10>
lastChangedDateTimedetailsnoThe date and time of the change.CURAM_DATETIME SVR_DATETIME
waitListEntHistIDkeynoThe unique system generated identifier for the wait list entry history record.WAIT_LIST_ENTRY_HISTORY_ID SVR_INT64
waitListEntryIDdetailsnoUnique identifier for the wait list entry.WAIT_LIST_ENTRY_ID SVR_INT64
reviewDatedetails The date on which the wait list entry needs to be reviewed by the user.CURAM_DATE SVR_DATE
userNamedetailsnoUser who has last modified the wait list entry.USER_NAME SVR_STRING<64>
Foreign Keys (2)
ChildParent
WaitListEntryHistory.userNameUsers.userName
WaitListEntryHistory.waitListEntryIDWaitListEntry.waitListEntryID
Indices (2)
Index NameAttributes
WLEHWtLstEntIDIdxwaitListEntryID
IND_859996864userName
Operations (3)
OperationStereotypeOptionsDescriptionSQL
readread Standard Operation 
searchByWaitListEntryreadmultiORDER_BY: lastChangedDateTime
Searches for Wait List Entry History records for a given Wait List Entry. 
insertinsertAUTO_ID: waitListEntHistID
Standard Operation 
Related Pages (12)