Table Description
Case Approval: The acceptance of a decision on a case.

The approval can be undertaken manually by a user or automatically by the system. Whether the case is approved manually or automatically is determined by the approval rules configured in Curam.

The case approval stores the date the approval was requested, the outcome and the approval date.

This table holds a type of case event. Events are displayed in an events calendar for viewing by the user.

Example

User Ronan Rooney submits a case for approval. The Curam server creates a task to inform his supervisor that the case requires approval.

Ronan's supervisor reviews the case and approves it. The Curam server creates a row on this table noting the date and the user that approved the case.

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::Case::Entity Objects::CaseApproval::CaseApproval
Controlling File: core\model\Packages\Case\Case Approval_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (14)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
caseApprovalIDkeynoUnique reference number assigned by the system to a Case Approval record.CASE_APPROVAL_ID SVR_INT64
caseIDdetailsnoCaseID of the CaseHeader in respect of which this CaseApproval was enteredCASE_ID SVR_INT64
typeCodedetails Code value to indicate the type of Case Approval.APPROVAL_TYPE_CODEApprovalTypeCodeSVR_STRING<10>
requestedDatedetails Date on which the Case Approval was sought.CURAM_DATE SVR_DATE
approvalDatedetails Date on which Case Approval occurred.CURAM_DATE SVR_DATE
documentRefNodetails 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 Case Approval.APPROVAL_METHOD_CODEApprovalMethodSVR_STRING<10>
userNamedetailsnoUnique Reference Number assigned by the system for a User.USER_NAME SVR_STRING<64>
outcomeCodedetails The outcome code for this case approval event. This is populated from the ApprovalOutcomeCode code table.APPROVAL_OUTCOME_CODEApprovalOutcomeCodeSVR_STRING<10>
approvalStatusdetails The status code for this case approval event. This is populated from the CaseApprovalStatus code table.CASE_APPROVAL_STATUS_CODECaseApprovalStatusSVR_STRING<10>
automaticallyApprovedInddetails This indicator is used to show if this approval record was generated as a result of automatic case approval.BOOLEAN_TYPE SVR_BOOLEAN
decisionIddetailsyesThe ID of the Case Decision associated with this case approval event.CASE_DECISION_ID SVR_INT64
determinationIDdetails The identifier of the Case Determination associated with the Case Approval record.INTERNAL_ID SVR_INT64
Foreign Keys (3)
ChildParent
CaseApproval.decisionIdCaseDecision.caseDecisionID
CaseApproval.caseIDCaseHeader.caseID
CaseApproval.userNameUsers.userName
Indices (3)
Index NameAttributes
CApprovalIDStatIdxcaseID, approvalStatus
CApprovalUsrDatIdxuserName, approvalDate
CApprovalDecIdxdecisionId
Operations (9)
OperationStereotypeOptionsDescriptionSQL
insertinsertPOST_DATA_ACCESS: yes
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
readByStatusAndCaseIDnsread Method that retrieves a case approval record based on case identifier and approval status 
searchByUserAndDatensmulti Driving cursor for Approved Product Deliveries Report. The search can be made for a specific date by supplying the from date and leaving the to date empty. The search will be based on a date range if both dates are populated.SQL
readCaseIDByCaseApprovalIDnsread This method returns a CaseID for a Case Approval. 
countCasesSubmittedToSupervisorUserns Method to count the number of cases that are awaiting approval for a specified supervisor user.SQL
readByOutcomecodeAndCaseIDnsread Method that retrieves a case approval record based on case identifier and outcome code 
searchByCaseIDAndOutcomeCodereadmulti Method that retrieves all case approval records based on case identifier and outcome code 
Related Pages (112)
Assessment Results (AssessmentDelivery_listAssessmentResults)
Approval Details (Case_viewApproval)
Approval Details (Case_viewApprovalFullTree)
Approval Details (Case_viewApprovalInline)
Approval Details (Case_viewApprovalTextBasedTree)
View Approval (Case_viewApprovalTextBasedTreeViewOnly)
Submitted For Approval Details (Case_viewSubmitForApproval)
Submitted For Approval Details (Case_viewSubmitForApprovalFullTree)
Case_viewSubmitForApprovalInline
View Submit For Approval (Case_viewSubmitForApprovalOnly)
Submitted For Approval Details (Case_viewSubmitForApprovalTextBasedTree)
View Submit For Approval (Case_viewSubmitForApprovalViewOnly)
Complete Findings (CaseAudit_confirmCompleteFindings)
Add Member (CHIPProduct_addAssistanceGroupMember)
Confirm Benefit Group Member (CHIPProduct_confirmAddBenefitGroupMember)
Remove Member (CHIPProduct_removeAssistanceGroupMember)
Remove Member (CHIPProduct_removeBenefitGroupMember)
Extend Timer (CommonIntake_extendTimers)
Check Retroactive Medicaid Eligibility (HCRRetroactiveMedicaid_confirmCheckEligibilty)
Request Milestone Waiver (ICInvestigationDelivery_createWaiverForMilestone)
Extend (Intake_extendTimers)
Approve Investigation Case (InvestigationDelivery_approve)
Reject Request For Approval (InvestigationDelivery_reject)
Submit For Approval (InvestigationDelivery_submit)
Complete Agreement (OutcomePlanAgreement_complete)
Approve Case (ProductDelivery_approve)
ProductDelivery_listCaseApprovalEventCreoleDecisions
View Decision (ProductDelivery_listCaseApprovalEventCreoleDecisionsViewOnly)
ProductDelivery_listSubmitForApprovalCreoleDecisions
ProductDelivery_listSubmitForApprovalCreoleDecisionsViewOnly
Reject Request For Approval (ProductDelivery_reject)
Activate Contract (ProviderManagement_activateContract)
New Text Translation (ProviderManagement_addDescriptionTranslationToServiceOffering)
New Text Translation (ProviderManagement_addNameTranslationToServiceOffering)
Add Service Authorization Line Item: (ProviderManagement_addSampleServiceAuthorizationLineItem)
New Service (ProviderManagement_addServicesToProviderContract)
Add Services to Contract (ProviderManagement_addServicesToProviderGroupContract)
New Service (ProviderManagement_addServicesToProviderGroupContract_fromView)
Update to Training (ProviderManagement_addTrainingForServiceOffering)
Submit Service Invoice Line Item for Processing (ProviderManagement_allowSILIForProcessingAsDuplicate)
Amend Utilization Contract (ProviderManagement_amendProviderGroupUtilizationContract)
Amend Contract (ProviderManagement_amendUtilizationContract)
Approve Line Item (ProviderManagement_approveLineItemCorrections)
Approve Line Item (ProviderManagement_approvePendingSILI)
Approve Line Item (ProviderManagement_approvePendingSILICorrections)
Approve Line Item (ProviderManagement_approveServiceInvoiceLineItem)
Approve Service Invoice Line Items (ProviderManagement_approveServiceInvoiceLineItems)
Approve Line Item (ProviderManagement_approveSILI)
Approve Service Invoice Line Item as Duplicate (ProviderManagement_approveSILIAsDuplicate)
Approve Line Item (ProviderManagement_approveSILICorrections)
Approve Line Items (ProviderManagement_approveSubmittedSILI)
Approve Line Items (ProviderManagement_confirmApproveServiceInvoiceLineItems)
Confirm cancel overlapping reservations (ProviderManagement_confirmCancelOverlappingActiveResForAnyClient)
Confirm Modify Overlapping Placements (ProviderManagement_confirmModifyOverlappingPlacementPrd)
Confirm modify overlapping placements (ProviderManagement_confirmModifyPlacementPrdForWL)
Submit Line Items (ProviderManagement_confirmSubmitServiceInvoiceLineItems)
New Service (ProviderManagement_createNewServiceOffering)
New Service (ProviderManagement_createNewTrainingServiceOffering)
New Service Rate (ProviderManagement_createProviderGroupUtilizationContractProviderOfferingRate)
New Payment Options (ProviderManagement_createProviderPaymentOption)
New Rate (ProviderManagement_createProviderServiceOfferingRate)
Create Emergency Placement (ProviderManagement_createSampleEmergencyPlacement)
Create Service Authorization Line Items (ProviderManagement_createSampleSAWithSALI)
New Service (ProviderManagement_createServiceOffering)
New Payment Options (ProviderManagement_createServicePaymentOption)
New Service Rate (ProviderManagement_createServiceRate)
New Training Service (ProviderManagement_createTrainingServiceOffering)
New Utilization Contract (ProviderManagement_createUtilizationContractForProvider)
New Rate (ProviderManagement_createUtilizationContractProviderOfferingRate)
Edit Payment Option (ProviderManagement_editProviderPaymentOption)
Edit Service (ProviderManagement_editServiceOffering)
Edit Service (ProviderManagement_editServiceOfferingFrmView)
Edit Payment Options (ProviderManagement_editServicePaymentOption)
Edit Service Rate (ProviderManagement_editServiceRate)
Edit Training Service (ProviderManagement_editTrainingServiceOffering)
Edit Training Service (ProviderManagement_editTrainingServiceOfferingFrmView)
Edit Text Translation (ProviderManagement_modifyLocalizableSODescriptionTextTranslation)
Edit Text Translation (ProviderManagement_modifyLocalizableSONameTextTranslation)
Confirm Placement (ProviderManagement_modifyPlaceDuringConfirmation)
Edit Placement (ProviderManagement_modifyPlacementDetails)
Modify Placement Information (ProviderManagement_modifyPlacementInformation)
Confirm Cancel Reservation (ProviderManagement_modifyPlacementInformationConfirmCancelReservation)
Allocate Place (ProviderManagement_modifyPlaceProviderOfferingAllocate)
Edit Service Rate (ProviderManagement_modifyProviderGroupUtilizationContractProviderOfferingRate)
Edit Rate (ProviderManagement_modifyProviderServiceOfferingRate)
Confirm Placement: (ProviderManagement_modifySamplePlaceDuringConfirmation)
Modify Service Authorization Line Item: (ProviderManagement_modifySampleServiceAuthorizationLineItem)
Edit Delivery Configuration (ProviderManagement_modifySecurityRightsAndServiceDeliveryConfiguration)
Edit Utilization Contract (ProviderManagement_modifyUtilizationContractForProviderGroup)
Edit Rate (ProviderManagement_modifyUtilizationContractProviderOfferingRate)
Place Client (ProviderManagement_placeSampleClient)
Renew Contract (ProviderManagement_renewContract)
Renew Contract (ProviderManagement_renewProviderGroupContract)
Submit Line Item (ProviderManagement_submitOpenSILIForProcessing)
Submit Line Item (ProviderManagement_submitServiceInvoiceLineItemForProcessing)
Submit Line Items (ProviderManagement_submitServiceInvoiceLineItems)
Submit Line Item (ProviderManagement_submitSILI)
Submit Service Invoice Line Item for Processing (ProviderManagement_submitSILIForProcessingFromTask)
Submit Service Invoice (ProviderManagement_submittServiceInvoiceForProcessing)
Transfer Client (ProviderManagement_transferClient)
Transfer Placement to Another Case (ProviderManagement_transferSamplePlacementToAnotherCase)
Reassessment Details (ProviderManagement_triggerReassessment)
Update Placement Period (ProviderManagement_updateSamplePlacementPeriod)
Add Plan Item (ServicePlanDelivery_addCustomServicePlanItem)
Add Plan Item (ServicePlanDelivery_addServicePlanItem)
Request Milestone Waiver (ServicePlanDelivery_createWaiverForMilestone)
Edit Plan Item (ServicePlanDelivery_modifyCustomServicePlanItemProviderEditable)
Edit Plan Item (ServicePlanDelivery_modifyCustomServicePlanItemProviderNonEditable)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanItemProviderEditable)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanItemProviderNonEditable)
New Social Enterprise Folder (SocialEnterpriseFolder_create)
New Social Enterprise Folder (SocialEnterpriseFolder_enhancedCreate)