Table Description
Milestone Waiver Approval Request: Details of milestone waiver approval request.

This entity is focused on the milestone waiver approval request raised by the user.

Example

The case worker requests for a waiver on the Expected start date of a system generated milestone delivery. This request is then approved or rejected by super user based on the nature of the waiver request.
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::Service Layer::MilestoneApprovalRequest::Entity::MilestoneWaiverApprovalRequest
Controlling File: core\model\Packages\Reference Model\Service Layer\MilestoneApprovalRequest\MilestoneApprovalRequest_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (12)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
waiverApprovalRequestIDkeynoUnique reference number assigned by the system to the milestone waiver approval request record.INTERNAL_ID SVR_INT64
approvalRequestIDdetailsyesUnique reference number of approval request record.APPROVAL_REQUEST_ID SVR_INT64
milestoneDeliveryIDdetailsyesUnique reference number of a milestone delivery to which milestone waiver approval request is related.MILESTONE_DELIVERY_ID SVR_INT64
originalExpStartDatedetails Date on which the milestone was originally expected to start..CURAM_DATE SVR_DATE
requestedExpStartDatedetails Date on which the milestone is being requested to start.CURAM_DATE SVR_DATE
approvedExpStartDatedetails Date on which the milestone is approved to start.CURAM_DATE SVR_DATE
originalExpEndDatedetails Date on which the milestone was originally expected to end.CURAM_DATE SVR_DATE
requestedExpEndDatedetails Date on which the milestone is being requested to end.CURAM_DATE SVR_DATE
approvedExpEndDatedetails Date on which the milestone is approved to end.CURAM_DATE SVR_DATE
requestCommentsdetails Comments entered by a user when submitting a milestone waiver request for approval.COMMENTS SVR_STRING<300>
approvalCommentsdetails Comments entered by a user when approving a milestone waiver request.COMMENTS SVR_STRING<300>
requestedDatedetails Date on which this milestone waiver approval request created.CURAM_DATE SVR_DATE
Foreign Keys (2)
ChildParent
MilestoneWaiverApprovalRequest.approvalRequestIDApprovalRequest.approvalRequestID
MilestoneWaiverApprovalRequest.milestoneDeliveryIDMilestoneDelivery.milestoneDeliveryID
Indices (2)
Index NameAttributes
IND__1491165504approvalRequestID
IND_1920648504milestoneDeliveryID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: waiverApprovalRequestID
Standard Operation 
readread Standard Operation 
searchByMilestoneDeliveryIDnsmulti Method lists all the waiver associated with the given milestone delivery IDSQL
readMWReqDetailsns This method will provide the waiver request details along with the approval and rejection detailsSQL
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
Related Pages (12)