Table Description
Audit Plan: The AuditPlan entity captures details specific to the audit plan.

This entity manages the details of the case audit process from its initial inception through to completion and describes the expected scope, goals and conduct of the audit. Details captured include the type of case being audited, the purpose for the audit, the priority, focus areas and level of user involvement in the audit.

Example

An Audit Coordinator creates an audit plan for Social Assistance cases and sets the purpose to 'Compliance Review', the Audit Item to 'Social Assistance', the User Involvement to 'View Findings Only' and the priority to 'Medium'. The audit coordinator saves the audit plan and is directed to the audit plan home page.

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::CaseAudit::Entity::AuditPlan::AuditPlan
Controlling File: core\model\Packages\Reference Model\Service Layer\CaseAudit\Entity\AuditPlan_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (20)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
auditPlanIDkeynoUnique reference number assigned by the system to an audit plan record.AUDIT_PLAN_ID SVR_INT64
auditPlanReferencedetails A unique ID for an audit plan. The auditPlanReference exists so that a meaningful ID can be displayed to a user for each audit plan.AUDIT_PLAN_REF SVR_STRING<40>
auditPlanStatusdetails The status of an audit plan. The status will change through the lifecycle of the audit plan. For example, when an audit plan is first created, its status is 'pending', but once auditors are assigned to work on it, it becomes 'in progress'.AUDIT_PLAN_STATUSAuditPlanStatusSVR_STRING<10>
recordStatusdetails The record status is used to indicate if the audit plan has been logically deleted.RECORD_STATUSRecordStatusSVR_STRING<10>
createdDatedetails The date the audit plan was created.CURAM_DATE SVR_DATE
createdBydetails The user who created the audit plan.USER_NAME SVR_STRING<64>
coordinatordetails The user who is the coordinator of this audit plan.USER_NAME SVR_STRING<64>
purposedetails The purpose of or type of audit.AUDIT_PLAN_PURPOSEAuditPlanPurposeSVR_STRING<10>
prioritydetails Indicates the importance of the audit plan.AUDIT_PLAN_PRIORITYAuditPlanPrioritySVR_STRING<10>
userAccessdetails Indicates what a case owner and supervisor can view in relation to a case audit. If View Findings and Provide Feedback is selected, the caseworker and supervisor will be notified when the audit is complete and that feedback is required. They will be allowed to view the findings and enter feedback. If View Findings Only is selected, the caseworker and supervisor will be notified when the audit is complete, and will be allowed to view the findings (however they will not be allowed to add feedback). If No Access to Audit Information is selected, the caseworker and supervisor will not be able to view the findings or provide feedback. AUDIT_PLAN_USER_ACCESSAuditPlanUserAccessSVR_STRING<10>
percentageCasesdetails The percentage of cases to be audited, specified by the audit coordinator, to be used in the case selection algorithm employed by the agency. If the auditor selected a number of cases, the system populates this field with the percentage of cases matching the specified number. AUDIT_PLAN_PERCENTAGE_CASES SVR_DOUBLE
numberCasesdetails The number of cases to be audited, specified by the audit coordinator, to be used in the case selection algorithm employed by the agency. If the auditor selected a percentage of cases, the system populates this field with the number of cases matching the specified percentage. AUDIT_PLAN_NUMBER_CASES SVR_INT32
scheduledStartDatedetails The date the audit is scheduled to commence.CURAM_DATE SVR_DATE
scheduledEndDatedetails The date the audit is scheduled to end.CURAM_DATE SVR_DATE
scheduleCommentsdetails Scheduling notations entered by the user regarding time frames, locations for interviews, expected audit time frames.COMMENTS SVR_STRING<300>
casesUserSelecteddetails Indicates if the user has selected specific cases to audit rather than letting the system produce a random sample based on selection criteria.CURAM_INDICATOR SVR_BOOLEAN
commentsdetails Comments recorded by a user relating to the audit plan. This enables the user to give a brief description about why the audit plan is needed or any additional information which is required.COMMENTS SVR_STRING<300>
auditCaseConfigIDdetails Identifier of the Audit Case Configuration associated with this Audit PlanAUDIT_CASE_CONFIG_ID SVR_INT64
findingsTextdetails Overall summary findings text added by the coordinator.RICH_TEXT_DATA SVR_STRING<10000>
selectionQueryIDdetails The selection query used to generate the case sample.SELECTION_QUERY_ID SVR_INT64
Foreign Keys (1)
ChildParent
CaseAudit.auditPlanIDAuditPlan.auditPlanID
Indices (2)
Index NameAttributes
audPlanRefIdxauditPlanReference
statCoordIdxrecordStatus, coordinator
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: auditPlanID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByRecordStatusAndCoordinatorreadmulti Method to search for audit plans by record status and coordinator. 
readByAuditPlanReferencensread Method to read the audit plan record using the audit plan reference. 
Related Pages (151)
Complete Audit Plan (AuditPlan_confirmCompletePlan)
Complete Audit Plan (AuditPlan_confirmCompletePlanFromFindings)
Add Summary Findings (AuditPlan_createSummaryFindings)
Edit Audit Plan Summary Findings (AuditPlan_modifySummaryFindings)
View Audit Plan Summary Findings (AuditPlan_viewSummaryFindings)
Add Focus Areas (CaseAudit_addAuditPlanFocusAreas)
Add Findings (CaseAudit_addFocusAreaFinding)
Assign Case Audits (CaseAudit_assignCaseAudits)
Home (CaseAudit_auditorViewCaseAudit)
Delete Audit Plan (CaseAudit_cancelAuditPlan)
Confirm Case Audit Assignment (CaseAudit_confirmCaseAuditAssignment)
Produce List of Cases for Audit (CaseAudit_confirmCaseSelection)
Confirm Change of Audit Coordinator (CaseAudit_confirmChangeCoord)
Complete Case Audit (CaseAudit_confirmCompleteAudit)
Complete Findings (CaseAudit_confirmCompleteFindings)
Delete Case Audit (CaseAudit_confirmDeleteFromPlan)
Delete Case Audit (CaseAudit_confirmDeleteFromPlanItem)
Generate Random Case Sample (CaseAudit_confirmExternalServiceCaseSampleGeneration)
Generate Random Case Sample (CaseAudit_confirmFixedQueryCaseSampleGeneration)
Generate Random Case Sample (CaseAudit_confirmICCaseSampleGeneration)
Generate Random Case Sample (CaseAudit_confirmInvestigationCaseSampleGeneration)
Generate Random Case Sample (CaseAudit_confirmLPDCaseSampleGeneration)
Generate Random Case Sample (CaseAudit_confirmPDCaseSampleGeneration)
Remove (CaseAudit_confirmRemoveAuditor)
Home (CaseAudit_coordinatorViewCaseAudit)
New Auditor (CaseAudit_createAuditors)
Add to Audit Team (CaseAudit_createAuditorsAndAddToTeam)
New Audit Plan (CaseAudit_createAuditPlan)
New Audit Team (CaseAudit_createAuditTeam)
Add Findings (CaseAudit_createCaseAuditFinding)
Delete Audit Plan Schedule (CaseAudit_deleteScheduleInfo)
Generate Random Case Sample (CaseAudit_externalServiceSelectAmount)
Generate Random Case Sample (CaseAudit_fixedQueryFilteredCaseSampleSelectAmount)
Focus Area Findings (CaseAudit_FocusAreaDetailsView)
Search for Cases to Audit (CaseAudit_ICCaseSampleManualSearch)
Generate Random Case Sample (CaseAudit_ICCaseSampleSelectAmount)
Search for Cases to Audit (CaseAudit_InvestigationCaseSampleManualSearch)
Generate Random Case Sample (CaseAudit_InvestigationCaseSampleSelectAmount)
CaseAudit_listActiveAuditPlans
Auditors (CaseAudit_listAssignees)
Focus Areas (CaseAudit_listAuditPlanFocusAreas)
Case Audits Not Satisfied (CaseAudit_listAuditsNotSatisfied)
Case Audits Remaining (CaseAudit_listAuditsRemaining)
Case Audits Satisfied (CaseAudit_listAuditsSatisfied)
Assigned Audits (CaseAudit_listCaseAuditsByAssignee)
CaseAudit_listForAuditorUser
Selection Criteria (CaseAudit_listRandomSampleSelectionCriteria)
Search for Cases to Audit (CaseAudit_LPDCaseSampleManualSearch)
Generate Random Case Sample (CaseAudit_LPDCaseSampleSelectAmount)
Manage Audit Plan Schedule (CaseAudit_maintainAuditPlanSchedule)
Case Audits (CaseAudit_manualFilterListForAuditPlan)
Search Results (CaseAudit_manuallySearchAndSelectCases)
Edit Audit Plan (CaseAudit_modifyAuditPlan)
Manage Focus Areas (CaseAudit_modifyAuditPlanFocusAreas)
Edit Audit Team (CaseAudit_modifyAuditTeam)
Edit Case Audit (CaseAudit_modifyCaseAudit)
Edit Findings (CaseAudit_modifyCaseAuditFinding)
Edit Findings (CaseAudit_modifyFocusAreaFinding)
Search for Cases to Audit (CaseAudit_PDCaseSampleManualSearch)
Generate Random Case Sample (CaseAudit_PDCaseSampleSelectAmount)
Case Audit Feedback - (CaseAudit_provideFeedback)
Case Audits (CaseAudit_randomFilterListForAuditPlan)
Assigned Audits (CaseAudit_reassignCaseAudit)
Confirm Removal of Assignment (CaseAudit_removeAssignCaseAudits)
Assigned Audits (CaseAudit_removeAssignment)
CaseAudit_searchAuditPlan
CaseAudit_searchCaseAudit
Select Specific Cases to Audit (CaseAudit_selectCase)
Home (CaseAudit_viewAuditPlan)
CaseAudit_viewAuditPlanTabDetail
CaseAudit_viewCaseAuditTabDetail
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)
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)