Table Description
Reservation Status History: The status history of a reservation.

The status of a reservation will change through its lifecycle and change history will be captured with Reservation status history.

Example

For example, the status for a reservation is set to 'Active' upon initial creation, and then changed to 'Fulfilled' once transferred to placement.

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::CPM::Service Layer::Reservation::Entity::ReservationStatusHistory
Controlling File: CPM\model\Packages\Service Layer\Reservation\Entity\Entity_cat.efx
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
reservationStatusHistoryIDkeynoThe unique system generated reference number for the reservation status history record.INTERNAL_ID SVR_INT64
reservationIDdetailsyesThe unique system generated reference number for the reservation record.INTERNAL_ID SVR_INT64
statusdetails The status of the reservation. For example, when a reservation is expired, the status will be set to 'Expired'.RESERVATION_STATUSReservationStatusSVR_STRING<10>
cancellationReasondetails Reason that the reservation has been canceled.RESERVATION_CANCEL_REASONReservationCancelReasonSVR_STRING<10>
creationDateTimedetails The date and time the status is effective from.CURAM_DATETIME SVR_DATETIME
userNamedetailsyesThe user name of the user who created the reservation.USER_NAME SVR_STRING<64>
Foreign Keys (2)
ChildParent
ReservationStatusHistory.reservationIDReservation.reservationID
ReservationStatusHistory.userNameUsers.userName
Indices (2)
Index NameAttributes
ReservStatHisReservationIDIdxreservationID
IND_1174826783userName
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: reservationStatusHistoryID
Creates a new row on ReservationStatusHistory table.  
readread Reads a row of data from ReservationStatusHistory table.  
modifymodify Modifies an existing row on ReservationStatusHistory table.  
removeremove Removes an existing row from ReservationStatusHistory table.  
searchByReservationreadmultiORDER_BY: creationDateTime
Searches the status history for Reservation. 
Related Pages (16)