Table Description
WaitListEntryStatusHistory: The status history of a Wait List Entry.

The status of a Wait List Entry will change through its lifecycle, for example, the status for a Wait List is set to 'Open' upon initial creation, and then changed to 'Allocated' once a resource is allocated to the client. Every change in the status of the Wait List Entry is recorded in the Wait List Entry Status History.

Example

When a Wait List Entry X is added to a Wait List A, an initial entry is made in the Wait List Entry Status History table with the status as 'Open'. When a place is allocated to this Wait List entry, its status is changed to 'Allocated' and another entry is made in the Wait List Entry Status History table with its new status.

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::WaitListEntryStatusHistory
Controlling File: core\model\Packages\Case\Wait List_cat.efx
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
waitListEntryStatusHistoryIDkeynoThe unique system generated identifier for the wait list entry status history record.WAIT_LIST_ENTRY_STATUS_HISTORY_ID SVR_INT64
waitListEntryIDdetailsnoSystem generated identifier that uniquely identifies the wait list entry status history record to the wait list entry.WAIT_LIST_ENTRY_ID SVR_INT64
statusdetailsnoStatus of the wait list entry.WAIT_LIST_ENTRY_STATUSWaitListEntryStatusSVR_STRING<10>
userNamedetailsnoName of the user who changed the status of the wait list entry.USER_NAME SVR_STRING<64>
changeDateTimedetailsnoThe date and time when the status of the wait list entry was changed and recorded in the Wait List Entry Status History table.CURAM_DATETIME SVR_DATETIME
Foreign Keys (2)
ChildParent
WaitListEntryStatusHistory.userNameUsers.userName
WaitListEntryStatusHistory.waitListEntryIDWaitListEntry.waitListEntryID
Indices (2)
Index NameAttributes
WLESHWtLstEntIDIdxwaitListEntryID
IND_1226594194userName
Operations (3)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: waitListEntryStatusHistoryID
Standard Operation 
readread Standard Operation 
searchByWaitListEntryIDreadmulti Search for Wait List Status History for a Wait List Entry. 
Related Pages (3)