Table Description
Milestone Waiver Approval Check: Configuration details of a milestone waiver approval.

This entity is focused on the administration of milestone waiver approval. A milestone waiver can be associated with user or milestone or organization unit.

Example

An approval check can be created such that 50% of the waivers requested for a particular type of milestone will require manual approval by a supervisor. The other 50% will be automatically approved. An approval check can also be created such that 50% of milestone waivers submitted by a user or for an organization unit will require manual approval by a supervisor.

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::MilestoneApprovalCheck::Entity::MilestoneWaiverApprovalCheck
Controlling File: core\model\Packages\Reference Model\Service Layer\Milestone Approval Check\MilestoneApprovalCheck_cat.efx
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
milestoneWaiverApprovalCheckIDkeynoUnique reference number assigned by the system to the milestone waiver approval check record.MILESTONE_WAIVER_APPROVAL_ID SVR_INT64
percentagedetailsnoPercentage of waiver requests for the milestone that requires approval.EVIDENCE_APPROVAL_CHECK_RATE SVR_INT16
typedetailsnoType of milestone waiver approval check.MW_APPROVAL_TYPEMWApprovalTypeSVR_STRING<10>
statusdetailsnoThe status of the milestone waiver approval check i.e Active or Cancelled. Logical deletion supported.MW_APPROVAL_STATUSMWApprovalStatusSVR_STRING<10>
milestoneConfigurationIDdetailsyesUnique identifier of the milestone configuration on which this milestone waiver approval check is based.APPROVAL_CHECK_MILESTONE_CONFIG_ID SVR_INT64
userNamedetailsyesThe user name of the milestone waiver approval check.USER_NAME SVR_STRING<64>
organisationUnitIDdetailsyesUnique organization unit reference number of the milestone waiver approval check.ORGANISATION_UNIT_ID SVR_INT64
commentsdetailsyesGenerate remarks entered by a user.COMMENTS SVR_STRING<300>
versionNodetails Version number of the milestone waiver approval check.VERSION_NO SVR_INT32
Foreign Keys (3)
ChildParent
MilestoneWaiverApprovalCheck.milestoneConfigurationIDMilestoneConfiguration.milestoneConfigurationID
MilestoneWaiverApprovalCheck.organisationUnitIDOrganisationUnit.organisationUnitID
MilestoneWaiverApprovalCheck.userNameUsers.userName
Indices (3)
Index NameAttributes
milWaivUsrIdxuserName
milestoneConfigurationIDIdxmilestoneConfigurationID
organisationUnitIDIdxorganisationUnitID
Operations (15)
OperationStereotypeOptionsDescriptionSQL
insertinsertPOST_DATA_ACCESS: no
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyPRE_DATA_ACCESS: no
Standard Operation 
searchByOrganisationUnitIDreadmulti Returns a list of milestone waiver approval check entries based on the organization unit id. 
searchByUserNamereadmulti Returns a list of milestone waiver approval check entries based on the user name. 
searchMilestoneWaiverAppListByOrgUnitIDnsmulti Returns a list of milestone waiver approval check details based on the organization unit id.SQL
searchMilestoneWaiverAppListByUserNamensmulti Returns a list of milestone waiver approval check details based on the user name.SQL
countDuplicateOrgUnitMWns This method returns the count of milestone waiver approval checks based on the organization id, status, milestone configuration id and the type of milestone.SQL
countDuplicateOrgUnitns This method returns the count of milestone waiver approval checks based on the organization id, status and the type of milestone. Note: The Milestone configuration id is considered null in this case.SQL
countDuplicateUserMWns This method returns the count of milestone waiver approval checks based on the user name, status, milestone configuration id and the type of milestone.SQL
countDuplicateUserns This method returns the count of milestone waiver approval checks based on the user name, status and the type of milestone. Note: The Milestone configuration id is considered null in this case.SQL
searchByMilestoneConfigurationIDreadmultiWHERE: userName is NULL AND organisationUnitID is NULL AND milestoneConfigurationID= :milestoneConfigurationID
Returns a list of milestone waiver approval check entries based on the milestone configuration id. 
countDuplicateMilestoneConfigurationIDns This method returns the count of milestone waiver approval checks based on the status, milestone configuration id and the type of milestone.SQL
modifyPercentageDescriptionnsmodify Modifies the waiver approval percentage of a milestone. 
removeremove Removes a record from milestone approval check entity. 
Related Pages (21)
Extend Timer (CommonIntake_extendTimers)
Request Milestone Waiver (ICInvestigationDelivery_createWaiverForMilestone)
Extend (Intake_extendTimers)
Delete Milestone Approval Check (Milestone_cancelMilestoneApprovalCheck)
New Milestone Waiver Approval Check (Milestone_createMilestoneApproval)
Milestone Approval Checks (Milestone_listMilestoneApproval)
Edit Milestone Waiver Approval Check (Milestone_modifyMilestoneApproval)
View Approval Check For Milestone (Milestone_viewApprovalCheckForMilestone)
Delete Milestone Waiver Approval Check (Organization_cancelOrgUnitMilestoneApproval)
Delete Milestone Waiver Approval Check (Organization_cancelUserMilestoneApproval)
New Milestone Waiver Approval Check (Organization_createOrgUnitMilestoneApproval)
New Milestone Waiver Approval Check (Organization_createUserMilestoneApproval)
Milestone Waiver (Organization_listOrgUnitMilestoneApproval)
Milestone Waiver (Organization_listUserMilestoneApproval)
Edit Milestone Waiver Approval Check (Organization_modifyOrgUnitMilestoneApprovalFromList)
Edit Milestone Waiver Approval Check (Organization_modifyOrgUnitMilestoneApprovalFromView)
Edit Milestone Waiver Approval Check (Organization_modifyUserMilestoneApprovalFromList)
Edit Milestone Waiver Approval Check (Organization_modifyUserMilestoneApprovalFromView)
Milestone Waiver Approval Check Details (Organization_viewOrgUnitMilestoneApproval)
Milestone Waiver Approval Check Details (Organization_viewUserMilestoneApproval)
Request Milestone Waiver (ServicePlanDelivery_createWaiverForMilestone)