Table Description
Approval Request: A decision regarding a request for approval of a service plan or plan item.

This entity is used to store details regarding a request and decision for the approval of a service plan or plan item. The approval request may relate to a service plan or a plan item. The approval can be undertaken manually by a user or automatically by the system. Approval check rules will determine whether approval is manual or automatic. This entity captures the date the approval was requested, the decision and the approval date.

Example

A case worker creates a Return to Work service plan for participant Linda Smith who has recently become unemployed. A goal of Sustainable Employment is selected for this service plan. A Transportation sub-goal is added to the service plan as Linda is unable to pay for transport to get to work. The Mileage Reimbursement plan item is added to the service plan to achieve the service plan goal.

Linda Smith also needs assistance with paying for childcare and as such a Childcare sub-goal is added to the service plan. A Childcare Provision plan item is added to the Childcare sub-goal.

The service plan is submitted for approval. An Approval Submission baseline is created and records the Sustainable Employment goal, the Childcare and Transportation sub-goals and the Mileage Reimbursement and Childcare Provision plan items. The identifier of this baseline is stored in the service plan approval request table. An approval request record is created indicating, for example, the user who submitted the service plan for approval, the request date and the status of the approval 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::ApprovalRequest::Entity::ApprovalRequest::ApprovalRequest
Controlling File: core\model\Packages\Reference Model\Service Layer\ApprovalRequest\Entity\ApprovalRequest\ApprovalRequest_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (12)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
approvalRequestIDkeynoUnique reference number generated by the system for an approval request record.APPROVAL_REQUEST_ID SVR_INT64
requestedDatedetails Date on which the approval was requested.CURAM_DATE SVR_DATE
requestedByUserdetails User name of the user who requested the approval.USER_NAME SVR_STRING<64>
approvalDecisionDatedetails Date on which the request was approved.CURAM_DATE SVR_DATE
approvalDecisionByUserdetails User name of the user who approved the request.USER_NAME SVR_STRING<64>
documentRefNodetails Unique reference number associated with the physical document.DOCUMENT_REFERENCE_NUMBER SVR_STRING<16>
approverTypeCodedetails Code to denote the grade of the Case worker required to give assent on the Case. This should be a linked table to the User Grade Code and the Organization Unit Skill Type Code.APPROVER_REQUIRED_TYPE_CODEApproverRequiredTypeSVR_STRING<10>
methodCodedetails Code value to indicate the method of Approval.APPROVAL_METHOD_CODEApprovalMethodSVR_STRING<10>
automaticallyApprovedInddetails Indicator used to show if this approval record was generated as a result of automatic approval.CURAM_INDICATOR SVR_BOOLEAN
statusdetails Status of the approval request record. This is Submitted until the user decides to Approve or Reject the approval request. If the user approves the request, the status is set to Approved, if the user Rejects the request the status is set to Rejected. APPROVAL_REQUEST_STATUS_CODEApprovalRequestStatusSVR_STRING<10>
rejectionReasondetails Code table value to indicate why the request was rejected.REJECTION_REASON_CODERejectionReasonSVR_STRING<10>
rejectionCommentsdetails User entered remarks indicating why the approval was rejected.COMMENTS SVR_STRING<300>
Foreign Keys (4)
ChildParent
ApprovalRequestLink.approvalRequestIDApprovalRequest.approvalRequestID
MilestoneWaiverApprovalRequest.approvalRequestIDApprovalRequest.approvalRequestID
PAApprovalRequest.approvalRequestIDApprovalRequest.approvalRequestID
SPApprovalRequest.approvalRequestIDApprovalRequest.approvalRequestID
Indices (1)
Index NameAttributes
ReqIDStatusIndxapprovalRequestID, status
Operations (11)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: approvalRequestID
Standard Operation 
readread Standard Operation 
modifyReasonDetailsnsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Method used to modify the rejection reason for an approval request. 
readRejectionReasonAndCommentsnsread Method to read the rejection reason and comments associated with an approval request. 
validateModifyReasonDetails  Method used to validate the reason details before modifying. 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readStatusnsread Method that retrieves an approval record status based on an approval request identifier. 
approvensmodifyOPTIMISTIC_LOCKING: yes
Modifies status, approval decision date, approvalDecisionByUser and automatically approved indicator. 
modifyStatusRejectionReasonAndCommentsnsmodifyOPTIMISTIC_LOCKING: yes
Modifies status, reject reason, reject comment and approval decision date. 
removeremove Standard Operation 
readRequestedByUserAndDatensread This method reads the requestedByUser for an approval request, i.e. the user that submitted the request and also the date on which the request was submitted. 
Related Pages (169)
Delete Existing (AdvancedEvidenceSharing_removeExistingEvidence)
Approve Resolution (Appeal_approveResolution)
Reject Resolution (Appeal_rejectResolution)
Submit Resolution For Approval (Appeal_submitResolutionForApproval)
Transfer Application (Application_transferApplicationToExistingCase)
Approve Assessment (AssessmentApproval_confirmApproval)
Assessment Results (AssessmentDelivery_listAssessmentResults)
Reject Assessment (AssessmentDelivery_reject)
Approve Timer Extension (CommonIntake_approveTimerExtension)
Edit And Approve Timer Extension (CommonIntake_editAndApproveTimerExtension)
Extend Timer (CommonIntake_extendTimers)
Reject Timer Extension (CommonIntake_rejectTimerExtension)
Edit Child Support Payments Evidence (EVD_incomingModifyAbParChildSupportEvidence)
Edit Absence Evidence (EVD_incomingModifyAbsenceEvidence)
Edit Absenteeism Evidence (EVD_incomingModifyAbsentParentCSEEvidence)
Edit Absent Parent Evidence (EVD_incomingModifyAbsentParentEvidence)
Edit Adoption Evidence (EVD_incomingModifyAdoptionEvidence)
Edit Adoption Payment Evidence (EVD_incomingModifyAdoptionPaymentEvidence)
Edit Alien Evidence (EVD_incomingModifyAlienEvidence)
Edit Alien Sponsor Evidence (EVD_incomingModifyAlienSponsorEvidence)
Edit Alien Sponsorship Evidence (EVD_incomingModifyAlienSponsorshipEvidence)
Edit Alimony Expense Evidence (EVD_incomingModifyAlimonyExpenseEvidence)
Edit Annuity Beneficiary Evidence (EVD_incomingModifyAnnuityBeneficiaryEvidence)
Edit Annuity Evidence (EVD_incomingModifyAnnuityEvidence)
Edit Annuity Income Evidence (EVD_incomingModifyAnnuityIncomeEvidence)
Edit Anticipated Income Evidence (EVD_incomingModifyAnticipatedIncomeEvidence)
Edit Assigned Income Evidence (EVD_incomingModifyAssignedIncomeEvidence)
Edit Authorized Representative Evidence (EVD_incomingModifyAuthorizedRepEvidence)
Edit Beneficiary Evidence (EVD_incomingModifyBeneficiaryEvidence)
Edit Benefit Evidence (EVD_incomingModifyBenefitEvidence)
Edit Boarder Evidence (EVD_incomingModifyBoarderEvidence)
Edit Burial Plan Evidence (EVD_incomingModifyBurialPlanEvidence)
Edit Burial Plot Evidence (EVD_incomingModifyBurialPlotEvidence)
Edit Business Asset Evidence (EVD_incomingModifyBusinessAssetEvidence)
Edit Child Immunization Evidence (EVD_incomingModifyChildImmuneEvidence)
Edit Child Support Enforcement Evidence (EVD_incomingModifyChildSupportEnforcementEvidence)
Edit Child Support Expense Evidence (EVD_incomingModifyChildSupportExpenseEvidence)
Edit Contributor Evidence (EVD_incomingModifyContributorEvidence)
Edit Cost Of Care Allowance Evidence (EVD_incomingModifyCostOfCareAllowanceEvidence)
Edit Countable Assistance History Evidence (EVD_incomingModifyCountableAssistanceHistoryEvidence)
Edit Court Order Expense Evidence (EVD_incomingModifyCourtOrderExpenseEvidence)
Edit Coverage Evidence (EVD_incomingModifyCoverageEvidence)
Edit Coverage Type Evidence (EVD_incomingModifyCoverageTypeDetailsEvidence)
Edit Criminal History Evidence (EVD_incomingModifyCriminalHistoryEvidence)
Edit Dependent Care Expense Evidence (EVD_incomingModifyDependentCareExpenseEvidence)
Edit Deprivation Evidence (EVD_incomingModifyDeprivationEvidence)
Edit Disability Evidence (EVD_incomingModifyDisabilityEvidence)
Edit Domestic Violence Evidence (EVD_incomingModifyDomesticViolenceEvidence)
Edit Earned Income Evidence (EVD_incomingModifyEarnedIncomeEvidence)
Edit Emergency Evidence (EVD_incomingModifyEmergencyEvidence)
Edit Employment Expense Evidence (EVD_incomingModifyEmploymentExpenseEvidence)
Edit Employment Offer Evidence (EVD_incomingModifyEmploymentOfferEvidence)
Edit Entitlement Evidence (EVD_incomingModifyEntitlementEvidence)
Edit Exemption Evidence (EVD_incomingModifyExemptionEvidence)
Edit Extension Evidence (EVD_incomingModifyExtensionEvidence)
Edit Foster Care Evidence (EVD_incomingModifyFosterCareEvidence)
Edit Foster Care Payment Evidence (EVD_incomingModifyFosterCarePaymentEvidence)
Edit General Insurance Evidence (EVD_incomingModifyGeneralInsuranceEvidence)
Edit Gross Receipt Evidence (EVD_incomingModifyGrossReceiptEvidence)
Edit Head of Household Evidence (EVD_incomingModifyHeadOfHouseholdEvidence)
Edit Household Meal Group Evidence (EVD_incomingModifyHholdMealsGroupEvidence)
Edit Household Member Evidence (EVD_incomingModifyHouseholdMemberEvidence)
Edit Household Relationship Evidence (EVD_incomingModifyHouseholdRelationshipEvidence)
Edit Income Reporting Evidence (EVD_incomingModifyIncomeReportingEvidence)
Edit Income Trust Schedule Evidence (EVD_incomingModifyIncomeTrustScheduleEvidence)
Edit Legal Guardian Expense Evidence (EVD_incomingModifyLegalGuardianEvidence)
Edit Level Of Care Evidence (EVD_incomingModifyLevelOfCareEvidence)
Edit Life Insurance Evidence (EVD_incomingModifyLifeInsuranceEvidence)
Edit Liquid Resources Evidence (EVD_incomingModifyLiquidResourcesEvidence)
Edit Living Arrangement Evidence (EVD_incomingModifyLivingArrangeEvidence)
Edit Living Expense Evidence (EVD_incomingModifyLivingExpenseEvidence)
Edit Loan Evidence (EVD_incomingModifyLoanEvidence)
Edit Household Meal Group Member Evidence (EVD_incomingModifyMealGroupMemberEvidence)
Edit Medical Expense Evidence (EVD_incomingModifyMedicalExpenseEvidence)
Edit Medical Expense Payment Evidence (EVD_incomingModifyMedicalExpensePaymentEvidence)
Edit Medical Institution Evidence (EVD_incomingModifyMedicalInstitutionEvidence)
Edit Medical Insurance Evidence (EVD_incomingModifyMedicalInsuranceEvidence)
Edit Medical Screening Evidence (EVD_incomingModifyMedicalScreeningEvidence)
Edit Medical Institution Temporary Absence Evidence (EVD_incomingModifyMedInstTemporaryAbsenceEvidence)
Edit Minor Parent Non Residency Evidence (EVD_incomingModifyMinorParNonResEvidence)
Edit Minor Parent School Attendance Evidence (EVD_incomingModifyMinorParSchlAttEvidence)
Edit Ownership Evidence (EVD_incomingModifyOwnershipEvidence)
Edit Paid Employment Evidence (EVD_incomingModifyPaidEmploymentEvidence)
Edit Pregnancy Evidence (EVD_incomingModifyPregnancyEvidence)
Edit Property Evidence (EVD_incomingModifyPropertyEvidence)
Edit Resource Income Evidence (EVD_incomingModifyResourceIncomeEvidence)
Edit Resource Transfer Evidence (EVD_incomingModifyResourceTransferEvidence)
Edit Self Employment Evidence (EVD_incomingModifySelfEmploymentEvidence)
Edit Shelter Expense Evidence (EVD_incomingModifyShelterExpenseEvidence)
Edit Social Relationship Evidence (EVD_incomingModifySocialRelationshipEvidence)
Edit Spousal Cooperation Evidence (EVD_incomingModifySpousalCooperationEvidence)
Edit Student Evidence (EVD_incomingModifyStudentEvidence)
Edit Student Expense Evidence (EVD_incomingModifyStudentExpenseEvidence)
Edit Third Party Liability Enforcement Evidence (EVD_incomingModifyTPLEnforcementEvidence)
Edit Trade Dispute Evidence (EVD_incomingModifyTradeDisputeEvidence)
Edit Transfer Reversal Evidence (EVD_incomingModifyTransferReversalEvidence)
Edit Transfer To Individual Evidence (EVD_incomingModifyTransferToIndividualEvidence)
Edit Transfer To Trust Evidence (EVD_incomingModifyTransferToTrustEvidence)
Edit Trustee Evidence (EVD_incomingModifyTrusteeEvidence)
Edit Trust Evidence (EVD_incomingModifyTrustEvidence)
Edit Trust Income Evidence (EVD_incomingModifyTrustIncomeEvidence)
Edit Unborn Child Evidence (EVD_incomingModifyUnbornChildEvidence)
Edit Unearned Income Evidence (EVD_incomingModifyUnearnedIncomeEvidence)
Edit Unearned Rental Income Expense Evidence (EVD_incomingModifyUnearnedRentalIncomeExpenseEvidence)
Edit Unpaid Employment Evidence (EVD_incomingModifyUnpaidEmploymentEvidence)
Edit Utility Expense Evidence (EVD_incomingModifyUtilityExpenseEvidence)
Edit Vehicle Evidence (EVD_incomingModifyVehicleEvidence)
Edit Veteran Military Service Evidence (EVD_incomingModifyVetMilitaryServEvidence)
Edit Voluntary Quit Evidence (EVD_incomingModifyVoluntaryQuitEvidence)
Edit Work Non-Participation Evidence (EVD_incomingModifyWorkNonParticipationEvidence)
Edit Work Registration Evidence (EVD_incomingModifyWorkRegistrationEvidence)
Edit Work Requirements Evidence (EVD_incomingModifyWorkRequirementsEvidence)
Approve Evidence (Evidence_approveApprovalRequest)
Confirm Evidence Approval: (Evidence_confirmEvidenceApproval)
Delete Evidence (Evidence_deleteInEdit)
Discard Evidence (Evidence_discardPendingUpdate)
Transfer Evidence: (Evidence_listEvidenceForTransfer)
Reject Evidence: (Evidence_rejectApprovalRequest)
Reject Evidence: (Evidence_rejectApprovalRequest1)
Reject Evidence (Evidence_rejectApprovalRequests)
Delete Active Evidence (Evidence_removeActive)
Confirm Evidence Transfer (Evidence_transferEvidenceConfirmation)
View Evidence Approval Request Details: (Evidence_viewApprovalRequest)
Enable Employee Shopping (HCR_enableAndLogEmployeeCoCShopping)
Edit Annual Tax Return Evidence (HCR_incomingModifyAnnualTaxReturnEvidence)
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)
Approve (Intake_approveTimerExtension)
Edit And Approve (Intake_editAndApproveTimerExtension)
Extend (Intake_extendTimers)
Reject (Intake_rejectTimerExtension)
Apply To Period (ISP_ApplyToPeriod)
Edit Elective CHIP Enrollee Evidence (ISP_incomingModifyElectiveCHIPEnrolleeProductEvidence)
Edit Pay In Evidence (ISP_incomingModifyISPPayInProductEvidence)
Edit Spend Down Medical Expense Evidence (ISP_incomingModifyISPSpendDownMedicalExpenseProductEvidence)
Add Evidence (IssueDelivery_addEvidence)
Add Evidence (IssueDelivery_addEvidenceForIC)
Add Evidence (IssueDelivery_addEvidenceForProductDelivery)
Approve Resolution (IssueDelivery_approveResolution)
Create Issue (IssueDelivery_createIssue)
New Issue Case (IssueDelivery_createIssueForICWizard)
New Issue Case (IssueDelivery_createIssueForPDWizard)
Modify Resolution Approval Request (IssueDelivery_modifyApprovalRequestFromList)
Modify Resolution Approval Request (IssueDelivery_modifyApprovalRequestFromView)
Reject Resolution (IssueDelivery_rejectResolution)
Submit Resolution for Approval (IssueDelivery_submitResolutionForApproval)
Approve Agreement (OutcomePlanAgreement_approve)
Complete Agreement (OutcomePlanAgreement_complete)
Reject Agreement (OutcomePlanAgreement_reject)
Discard Evidence (PDEvidence_discardPendingUpdate)
Approve Service (ProviderManagement_confirmServiceApproval)
Reject Service (ProviderManagement_rejectServiceApproval)
Approve Service Plan (ServicePlanDelivery_approve)
Approve Milestone Waiver Request (ServicePlanDelivery_approveWaiver)
Request Milestone Waiver (ServicePlanDelivery_createWaiverForMilestone)
Edit And Approve Milestone Waiver Request (ServicePlanDelivery_modifyAndApproveWaiver)
Edit Approval Request (ServicePlanDelivery_modifyPlanPlanItemApprovalRequest)
Edit Approval Request (ServicePlanDelivery_modifyServicePlanApprovalRequest)
Reject Service Plan (ServicePlanDelivery_reject)
Reject Plan Item (ServicePlanDelivery_rejectServicePlanPlanItem)
Reject Milestone Waiver Request (ServicePlanDelivery_rejectWaiver)
Submit Service Plan (ServicePlanDelivery_submit)
Submit Plan Item For Approval (ServicePlanDelivery_submitServicePlanPlanItem)
Approval Requests Details : (ServicePlanDelivery_viewPlanPlanItemApprovalRequest)
Approval Requests Details : (ServicePlanDelivery_viewServicePlanApprovalRequest)
ServicePlanDelivery_viewServicePlanApprovalRequestFromList
View Approval Request (ServicePlanDelivery_viewServicePlanApprovalRequestViewOnly)