Table Description
Milestone Delivery: A significant event or task which will be completed during the life cycle of a case.

This entity is focused on the addition of a milestone to any type of case e.g. service plan, product delivery.

Example

A case worker creates a Return to Work service plan for participant Linda Smith as she has recently become unemployed. A Sustainable Employment goal is selected for this service plan. A Review milestone is added to take place 14 days after the creation of the service plan. Linda requires financial assistance to subsidize her travel to work, therefore a Transportation sub-goal is added to the service plan.

The Mileage Reimbursement plan item is added to the service plan to achieve the service plan sub-goal.

This entity stores the detail of the Review milestone added to the service plan.

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::MilestoneDelivery::Entity::MilestoneDelivery
Controlling File: core\model\Packages\Reference Model\Service Layer\MilestoneDelivery\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (14)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
milestoneDeliveryIDkeynoUnique identifier assigned by the system to this milestone record.MILESTONE_DELIVERY_ID SVR_INT64
milestoneConfigurationIDdetails Unique identifier of the milestone configuration on which this milestone is based.MILESTONE_CONFIGURATION_ID SVR_INT64
caseIDdetails Unique identifier of the case to which this milestone has been added.CASE_ID SVR_INT64
ownerUserNamedetails Unique identifier of the user who is the milestone owner.USER_NAME SVR_STRING<64>
expectedStartDatedetails Date on which the milestone is expected to start.CURAM_DATE SVR_DATE
expectedEndDatedetails Date on which the milestone is expected to end.CURAM_DATE SVR_DATE
actualStartDatedetails Date on which the milestone started.CURAM_DATE SVR_DATE
actualEndDatedetails Date on which the milestone ended.CURAM_DATE SVR_DATE
commentsdetails User entered remarks regarding the milestone.COMMENTS SVR_STRING<300>
statusdetails Status of this milestone i.e. Not Started, In Progress or Completed.MILESTONE_STATUS_CODEMilestoneStatusCodeSVR_STRING<10>
createdBySystemdetails Indicates whether this milestone delivery is system generated record.CREATED_BY_SYSTEM_INDICATOR SVR_BOOLEAN
relatedIDdetailsyesIdentifier which relates the instance of a milestone to a component category or a component type of a case instance.MILESTONE_RELATED_ID SVR_INT64
createdOndetails  CURAM_DATETIME SVR_DATETIME
warningDatedetailsyesThe warning date to inform the user that the completion of the milestone is imminent.CURAM_DATE SVR_DATE
Foreign Keys (3)
ChildParent
IntakeProgramMilestoneLink.milestoneDeliveryIDMilestoneDelivery.milestoneDeliveryID
MilestoneWaiverApprovalRequest.milestoneDeliveryIDMilestoneDelivery.milestoneDeliveryID
ProgramMilestoneLink.milestoneDeliveryIDMilestoneDelivery.milestoneDeliveryID
Indices (3)
Index NameAttributes
MilestoneCaseIDIdxcaseID
milCfgIdIdxmilestoneConfigurationID, status
IND_1404058987relatedID
Operations (23)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: milestoneDeliveryID
PRE_DATA_ACCESS: yes
Standard Operation 
readDetailsns Reads the details of a milestone delivery.SQL
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
removeremovePRE_DATA_ACCESS: no
Standard Operation 
validateDetails  Validates common milestone delivery details. 
validateInsert  Validates milestone delivery details being inserted. 
validateModify  Validates milestone delivery details being modified. 
searchByCaseIDnsmulti @Deprecated since curam 6.0, replaced by {@Link MilestoneDelivery#searchMilestoneDeliveryByCaseID()} See release note:CR00234817 This method lists all milestone deliveries for a case.SQL
searchMilestoneConfigsByCaseTypeIDAndCaseTypensmultiPRE_DATA_ACCESS: yes
 		@Deprecated Since curam 6.0, replaced by { @Link MilestoneDelivery#searchMilestoneConfigurationsByCaseTypeIDAndCaseType() }. See release note:CR00234817 This method lists milestones which have been configured in administration for the selected case. Only milestones which have no end date or an end date in the future are displayed for selection.SQL
validateCaseStatus  Method to validate the case status. 
readTypeByMilestoneDeliveryIDns Returns milestone configuration type.SQL
searchByExpectedEndDateAndNotStatusnsmultiPRE_DATA_ACCESS: yes
 		Operation to read all milestone deliveries where the expected end date has reached and the status is either Not Started or In Progress.SQL
searchByExpectedStartDateAndStatusnsmultiPRE_DATA_ACCESS: yes
 		Operation to read all milestone deliveries where the expected start date has reached and the status is Not Started.SQL
readCaseIDAndMilestoneTypens Returns milestone configuration type and the caseID.SQL
readCaseIDnsread Returns the case id of the milestone delivery. 
validateExpectedStartDate    
searchByMilestoneConfigIDAndStatusreadmulti Retrieves a list of milestone deliveries based on milestone configuration id and status. 
readCreatedBySystemIndns This method reads the created by system indicator to know whether the milestone is created manually or automaticallySQL
searchByRelatedIDAndStatusreadmulti Searches the milestone delivery table by related id and status. 
readread Standard Operation 
searchMilestoneConfigurationsByCaseTypeIDAndCaseTypensmultiPRE_DATA_ACCESS: yes
 		This method lists milestones which have been configured in administration for the selected case. Only milestones which have no end date or an end date in the future are displayed for selection.SQL
searchMilestoneDeliveryByCaseIDnsmulti This method lists all milestone deliveries for a case.SQL
readDetails1ns Reads localized milestone name and milestone type along with the other details of a milestone delivery.SQL
Related Pages (142)
Events (Appeal_listHearingCaseEvent)
Events (Appeal_listHearingCaseEventForIC)
Events (Appeal_listHearingCaseIssueEventForIC)
Events (Appeal_listHearingReviewEvent)
Events (Appeal_listHearingReviewEventForIC)
Events (Appeal_listHearingReviewIssueEventForIC)
Events (Appeal_listJudicialReviewEvent)
Events (Appeal_listJudicialReviewEventForIC)
Events (Appeal_listJudicialReviewIssueEventForIC)
Transfer Application (Application_transferApplicationToExistingCase)
Undo Transfer Application (Application_undoTransferApplicationToExistingCase)
Meetings (ApplicationCase_listEvent)
Applications (ApplicationSearch_TabDetails)
Applications (ApplicationSearch_TabDetails1)
Home (ApplicationSummary)
Timers (ApplicationTimers)
Events (BenefitSample_listEvent)
Events (BenefitSampleOverpayment_listEvent)
CGISSApplicationContextPanel1
Approve Timer Extension (CommonIntake_approveTimerExtension)
Reopen Program (CommonIntake_createProgramReopening)
Deny Program (CommonIntake_denyProgram)
Edit And Approve Timer Extension (CommonIntake_editAndApproveTimerExtension)
Edit Application (CommonIntake_editApplicationCase)
Edit Date Program Added (CommonIntake_editProgramDateAdded)
Extend Timer (CommonIntake_extendTimers)
CommonIntake_listProgramsDueByOwner
Timers (CommonIntake_listTimers)
Edit Reopen Details (CommonIntake_modifyProgramReopenDetails)
Reject Timer Extension (CommonIntake_rejectTimerExtension)
Deny (CREOLEProgramRecommendation_confirmDenyProgramApplication)
Events (DecisionAssistApplication_listEventNoCOC)
Events (DecisionAssistApplication_listEventNoCOCMultiSourceAC)
Events (DecisionAssistApplication_listEventNoCOCMultiSourceMC)
Events (DecisionAssistApplication_listEventNoCOCSingleSource)
Events (DecisionAssistApplication_listEventWithCOC)
Events (DefaultIC_listEvent)
Events (DefaultICProduct_listEvent)
Events (ICBenefitUnderPayment_listEvent)
Approve Milestone Waiver Request: (ICInvestigationDelivery_approveWaiver)
Request Milestone Waiver (ICInvestigationDelivery_createWaiverForMilestone)
Edit And Approve Milestone Waiver Request (ICInvestigationDelivery_modifyAndApproveWaiver)
Reject Milestone Waiver Request (ICInvestigationDelivery_rejectWaiver)
Milestones: (ICInvestigationSample_listAllMilestones)
Events (ICInvestigationSample_listEvent)
Milestones (ICInvestigationSample_listUncompletedMilestones)
Events (ICProductSample_listEvent)
Events (ICSample_listEvent)
Events (ICSampleSportingGrant_listEvent)
Events (ICSportingGrantSample_listEvent)
Events (IncomeScreening_listEvent)
Events: (IncomeSupportScreening_listEvent)
New Milestone (InsuranceAffordability_addMilestone)
Milestones (InsuranceAffordability_listAllMilestones)
Milestones (InsuranceAffordability_listUncompletedMilestones)
Edit Milestone (InsuranceAffordability_modifyMilestoneFromList)
Edit Milestone (InsuranceAffordability_modifyMilestoneFromListWaiver)
Delete Milestone (InsuranceAffordability_removeMilestone)
Select Milestone (InsuranceAffordability_selectCaseMilestone)
Milestone (InsuranceAffordability_viewMilestone)
Add Program (Intake_addProgramApplication)
Approve (Intake_approveTimerExtension)
Confirm Withdrawal Request (Intake_confirmProgramWithdrawalRequest)
Confirm Withdrawal Request (Intake_confirmProgramWithdrawalRequestFromTask)
Withdraw Program Request (Intake_createProgramWithdrawalRequest)
Withdraw Program Request (Intake_createProgramWithdrawalRequest1)
Reopen Program Application (Intake_createReopening)
Edit And Approve (Intake_editAndApproveTimerExtension)
Extend (Intake_extendTimers)
List Timer Extensions (Intake_listTimerExtension)
Reject (Intake_rejectTimerExtension)
Milestones (InvestigationSample_listAllMilestones)
Events (InvestigationSample_listEvent)
Milestones (InvestigationSample_listUncompletedMilestones)
Events (ISP_listEvent)
Application Details (ISPApplicationISCompletePreviewPanel)
Application Details (ISPApplicationISDisposedPreviewPanel)
Events (ISPProduct_listEvent)
Events (ISPSpendDownProduct_listEvent)
Events (IssueDelivery_listEvent)
Events (IssueDelivery_listEventForAppeal)
Events (LiabilityOverbilling_listEvent)
Events (LiabilitySample_listEvent)
Events (LIFCProduct_listEvent)
Events (LTCProduct_listEvent)
Events (MAMProduct_listEvent)
Applications (MyApplications_TabDetails)
Meetings (OutcomePlan_listEvent)
Events (PaymentCorrection_listEvent)
Events (PDBenefitUnderPayment_listEvent)
New Milestone (ProductDelivery_addMilestone)
Edit Milestone (ProductDelivery_modifyMilestoneFromList)
Edit Milestone (ProductDelivery_modifyMilestoneFromListWaiver)
Edit Milestone (ProductDelivery_modifyMilestoneFromView)
Edit Milestone (ProductDelivery_modifyMilestoneFromViewWaiver)
Delete Milestone (ProductDelivery_removeMilestone)
Select Milestone (ProductDelivery_selectInvestigationMilestone)
Milestone (ProductDelivery_viewMilestone)
Milestone (ProductDelivery_viewMilestoneModal)
View Milestone (ProductDelivery_viewMilestoneTransaction)
Milestone (ProductDelivery_viewMilestoneViewOnly)
Authorize (ProgramRecommendation_confirmAuthorize)
Deny (ProgramRecommendation_confirmDenyProgramApplication)
Decline (ProgramRecommendation_decline)
Authorize (ProgramRecommendation_listHouseholdMembersForMA)
Milestones: (ProviderInvestigation_listAllMilestones)
Events: (ProviderInvestigation_listEvent)
Milestones: (ProviderInvestigation_listUncompletedMilestones)
Events (RefugeeProduct_listEvent)
Application (RightsAndResponsibilitiesForAdditionalCase)
Application (RightsAndResponsibilitiesForCase)
Application (RightsAndResponsibilitiesForCaseSubmit)
Add Milestone (ServicePlanDelivery_addMilestone)
Approve Milestone Waiver Request (ServicePlanDelivery_approveWaiver)
Clone Service Plan (ServicePlanDelivery_clone)
Request Milestone Waiver (ServicePlanDelivery_createWaiverForMilestone)
Delete Sub-Goal (ServicePlanDelivery_deletePlannedSubGoal)
Delete Sub-Goal (ServicePlanDelivery_deletePlannedSubGoal_fromGantt)
Milestones (ServicePlanDelivery_listAllISPMilestones)
Milestones (All) (ServicePlanDelivery_listAllMilestonesForServicePlan)
Milestones (ServicePlanDelivery_listAllSPGMilestone)
Baseline Milestones (ServicePlanDelivery_listBaselineMilestones)
Events (ServicePlanDelivery_listEvent)
Milestones (ServicePlanDelivery_listISPMilestones)
Milestones (ServicePlanDelivery_listSPGMilestone)
Milestones (Incomplete) (ServicePlanDelivery_listUncompletedMilestonesForServicePlan)
Edit And Approve Milestone Waiver Request (ServicePlanDelivery_modifyAndApproveWaiver)
Edit Milestone (ServicePlanDelivery_modifyMilestoneFromList)
Edit Milestone (ServicePlanDelivery_modifyMilestoneFromListWaiver)
Edit Milestone (ServicePlanDelivery_modifyMilestoneFromView)
Edit Milestone (ServicePlanDelivery_modifyMilestoneFromViewWaiver)
Reject Milestone Waiver Request (ServicePlanDelivery_rejectWaiver)
Delete Milestone (ServicePlanDelivery_removeMilestone)
Select Milestone (ServicePlanDelivery_selectMilestone)
Use Service Plan Template (ServicePlanDelivery_useTemplate)
View Milestone (ServicePlanDelivery_viewBaselineMilestone)
View Milestone (ServicePlanDelivery_viewMilestone)
Milestone Details (ServicePlanDelivery_viewMilestoneFromGantt)
Calendar (SocialEnterpriseFolder_listEvent)
Events (TBBCC_listEvent)
Results: (WorkQueue_determinationTabDetails)
Results: (WorkQueue_TabDetails)