Table Description
WaitListEntry: An entry on a wait list for a resource relating to a client.

Each entry of client in the wait list forms a 'Wait List Entry'. Wait list entry can be in the 'Open' state if the client is waiting for the resource or it can be in the 'Allocated' state if the client has been allocated the resource or it can be in the 'Removed' state if the client has been removed for some reason or it can be in the 'Expired' state if the expiry date of the wait list entry has been reached. The position of a wait list entry can change when a new entry is added or an existing entry is either removed, allocated or expired.

Example

A wait list is created for a provider Carrey's Child Care with two clients, James Smith with position 1 and Lind Smith with position 2 in it, waiting for place to become available. Once James Smith is allocated a place, the wait list entry status is changed to 'Allocated' and the wait list entry for Linda Smith will have its position renumbered to 1.

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::WaitListEntry
Controlling File: core\model\Packages\Case\Wait List_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
waitListEntryIDkeynoThe unique system generated identifier for the wait list entry record.WAIT_LIST_ENTRY_ID SVR_INT64
waitListIDdetailsnoIdentifier that uniquely identifies the wait list for which the wait list entry belongs to.WAIT_LIST_ID SVR_INT64
caseParticipantRoleIDdetailsnoIdentifier that uniquely identifies the client associated with the wait list entry.INTERNAL_ID SVR_INT64
positiondetailsyesThe position represents the actual order of the wait list entry in the wait list. The wait list entries are ordered based on their position in the wait list.WAIT_LIST_ENTRY_POSITION SVR_INT16
prioritydetailsyesThe priority is used to indicate the priority of the wait list entry, for example, High, Medium or Low. This is only for the information purpose and is not considered when deciding the order of the wait list entry.WAIT_LIST_ENTRY_PRIORITYWaitListEntryPrioritySVR_STRING<10>
expiryDatedetailsyesThe date that indicates the expiry date of the wait list entry.CURAM_DATE SVR_DATE
removalReasondetailsyesThe reason for removing a wait list entry from the wait listWAIT_LIST_ENTRY_REMOVAL_REASONWaitListRemovalReasonSVR_STRING<10>
statusdetailsnoThe status of the wait list entry.WAIT_LIST_ENTRY_STATUSWaitListEntryStatusSVR_STRING<10>
reviewDatedetails The date on which the wait list entry needs to be reviewed by the user.CURAM_DATE SVR_DATE
commentsdetails Comments recorded by the user relating to the wait list entry.WAIT_LIST_ENTRY_COMMENTS SVR_STRING<300>
Foreign Keys (4)
ChildParent
WaitListEntry.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
WaitListEntry.waitListIDWaitList.waitListID
WaitListEntryHistory.waitListEntryIDWaitListEntry.waitListEntryID
WaitListEntryStatusHistory.waitListEntryIDWaitListEntry.waitListEntryID
Indices (3)
Index NameAttributes
reviewDateStatusIdxstatus, reviewDate
caseParticipantRoleIDIndexcaseParticipantRoleID
IND_1335780334waitListID
Operations (16)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: waitListEntryID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByWaitListIDreadmulti Searches for a Wait List Entry by Wait List ID. 
searchByCaseParticipantRoleIDreadmulti Searches for a Wait List Entry by Case Participant RoleID. 
searchByExpiryDateAndStatusreadmultiWHERE: status = :status AND expiryDate < :expiryDate
Searches for wait list entry by expiry date and status. This operation is used to retrieve the list of wait list entries to be expired. 
modifyPositionByOne  Adds the position by one for all the wait list entries greater than or equal to the specified position. 
modifyPositionByMinusOne  Subtracts the position by one for all the wait list entries greater than the specified position. 
searchByClientResourceAndStatusnsmulti Searches for a Wait List Entry by Resource ID, Case Participant Role ID and Wait List Entry Status.SQL
readMaxPositionns Searches for the maximum position allocated to the Wait List Entry for the input Wait List.SQL
searchByClientAndStatusreadmulti Searches for a Wait List Entry by Case Participant Role ID and Wait List Entry Status. 
searchBynsmulti Searches the wait list entries for a provider for the search criteria entered. Search criterion can be Client Name, Priority, Expiry Date and/or Status. Search is performed based on partial match of the client name criteria.SQL
searchByReviewDateAndStatusreadmulti Search the wait list entries based on the input review date and status key values. 
searchByProcessingDateAndStatusnsmulti Search&nbsp;the&nbsp;wait&nbsp;list&nbsp;entries&nbsp;based&nbsp;on&nbsp;the&nbsp;input&nbsp;processing date&nbsp;and&nbsp;status&nbsp;key&nbsp;values.SQL
searchByReviewDateRangeAndStatusnsmulti Searches&nbsp;all the&nbsp;wait&nbsp;list&nbsp;entries&nbsp;which has review date within the given date range for a given status.SQL
searchByConcernRoleAndStatusnsmulti  SQL
Related Pages (38)
Wait List Status History (FundPM_listWaitListEntryStatusHistory)
Remove Wait List Entry (FundPM_removeWaitListEntry)
Edit Wait List Entry (FundPM_updateWaitListEntry)
View Wait List Entry (FundPM_viewWaitListEntry)
Wait List Status History (FundPM_viewWaitListEntryStatusHistory)
Confirm cancel overlapping reservations (ProviderManagement_confirmCancelActiveRsrv)
Confirm modify overlapping placements (ProviderManagement_confirmModifyPlacementPrdForWL)
Confirm remove open wait lists (ProviderManagement_confirmRemoveOpenWL)
Create Wait List (ProviderManagement_createSampleWaitList)
Wait Lists (ProviderManagement_listProviderOfferingWaitListForProvider)
ProviderManagement_listRecentWaitListEntryDueForReview
Wait Lists (ProviderManagement_listWaitListEntryForProvider)
Provider Service Wait Lists: (ProviderManagement_listWaitListEntryForProviderOffering)
Wait List Entry History: (ProviderManagement_listWaitListEntryHistoryForProvider)
Wait List Entry History: (ProviderManagement_listWaitListEntryHistoryForProviderOffering)
Mark as Allocated (ProviderManagement_markAsAllocated)
Allocate Place (ProviderManagement_modifyPlaceProviderOfferingAllocate)
Allocate Place (ProviderManagement_modifyPrdForAllocatePOWaitList)
Allocate Place (ProviderManagement_modifyPrdForAllocateProviderWaitList)
Remove Wait List Entry (ProviderManagement_removeWaitListEntry)
Available Places (ProviderManagement_searchAvailablePlacesForWaitList)
Wait Lists (ProviderManagement_searchWaitListForProvider)
Wait Lists (ProviderManagement_searchWaitListForProviderAndProviderOffering)
Wait List Search (ProviderManagement_searchWaitListForProviderOffering)
Edit Wait List Entry (ProviderManagement_updateWaitListEntry)
ProviderManagement_viewProviderTabDetailsForFacilityManager
ProviderManagement_viewWaitListEntryFrmProvider
ProviderManagement_viewWaitListEntryFrmProviderOffering
ProviderManagement_viewWaitListEntryFrmProviderSearch
View Wait List Entry History: (ProviderManagement_viewWaitListEntryHistory)
ProviderManagement_viewWaitListEntryHistoryFrmProvider
ProviderManagement_viewWaitListEntryStatusHistory
ProviderManagement_viewWaitListEntryStatusHistoryFromSearch
Defer review for the Wait list entry: (WaitList_deferReview)
Wait Lists (WaitList_listWaitListEntryForPerson)
Allocate Wait List Entry: (WaitList_markAsAllocated)
Remove Wait List Entry: (WaitList_removeWaitListEntry)
Wait Lists (WaitList_viewWaitListEntryForPerson)