Table Description
Case Audit: A case audit is the individual case being audited as part of an audit plan.

This entity captures the current state of a case audit and its associated Case and audit plan.

Example

When a case is initially added to an audit plan, a CaseAudit record is created for it on that plan and the status is set to Open. The case audit can progress through many statuses including 'Assigned', 'Findings Complete', 'Findings Complete & Awaiting Feedback', 'Feedback Received', 'Feedback Complete' and finally 'Complete'.

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::CaseAudit::CaseAudit
Controlling File: core\model\Packages\Reference Model\Service Layer\CaseAudit\Entity\CaseAudit_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
caseAuditIDkeynoUnique reference number assigned by the system to a case audit record.CASE_AUDIT_ID SVR_INT64
auditPlanIDdetailsnoID of the audit plan for this case auditAUDIT_PLAN_ID SVR_INT64
caseIDdetails ID of the case that this audit refers toCASE_ID SVR_INT64
caseAuditStatusdetails The current status of this case auditCASE_AUDIT_STATUSCaseAuditStatusSVR_STRING<10>
commentsdetails Comments associated with this case auditCOMMENTS SVR_STRING<300>
caseAuditReferencedetails Human readable reference number for this case auditCASE_AUDIT_REF SVR_STRING<40>
auditorIDdetails The identifier of the auditor. This can be a single auditor user or an audit team.AUDITOR_ID SVR_INT64
dateAssigneddetails The date on which the case audit was assigned to the auditor.CURAM_DATE SVR_DATE
findingsTextdetails Findings text for this case auditRICH_TEXT_DATA SVR_STRING<10000>
Foreign Keys (1)
ChildParent
CaseAudit.auditPlanIDAuditPlan.auditPlanID
Indices (3)
Index NameAttributes
CaseAuditByAuditPlanIdxauditPlanID
IND_1157277855caseID
IND_306470853auditorID
Operations (8)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: caseAuditID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
searchByAuditPlanIDreadmulti Method to search for all Case Audit records associated with the specified Audit Plan 
searchByAuditPlanAndCaseIDreadmulti Retrieves case audit records for the specified audit plan and case identifiers. 
searchByAuditorreadmulti Method to retrieve a list of case audits for the specified auditor user. 
searchByAuditPlanAndStatusreadmulti Retrieves case audit records for the specified audit plan and case audit status. 
Related Pages (144)
Edit Attachment (Attachment_modify)
Complete Audit Plan (AuditPlan_confirmCompletePlan)
Complete Audit Plan (AuditPlan_confirmCompletePlanFromFindings)
Add Summary Findings (AuditPlan_createSummaryFindings)
Edit Attachment (CalendarMeetingMinutes_modifyAttachmentFromList)
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)
Remove (CaseAudit_confirmRemoveAuditor)
Home (CaseAudit_coordinatorViewCaseAudit)
Add Findings (CaseAudit_createCaseAuditFinding)
Focus Area Findings (CaseAudit_FocusAreaDetailsView)
Search for Cases to Audit (CaseAudit_ICCaseSampleManualSearch)
Search for Cases to Audit (CaseAudit_InvestigationCaseSampleManualSearch)
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)
Feedback (CaseAudit_listFeedback)
CaseAudit_listForAuditorUser
Search for Cases to Audit (CaseAudit_LPDCaseSampleManualSearch)
Case Audits (CaseAudit_manualFilterListForAuditPlan)
Search Results (CaseAudit_manuallySearchAndSelectCases)
Edit Audit Plan (CaseAudit_modifyAuditPlan)
Manage Focus Areas (CaseAudit_modifyAuditPlanFocusAreas)
Edit Case Audit (CaseAudit_modifyCaseAudit)
Edit Findings (CaseAudit_modifyCaseAuditFinding)
Edit Findings (CaseAudit_modifyFocusAreaFinding)
Search for Cases to Audit (CaseAudit_PDCaseSampleManualSearch)
Case Audit Feedback - (CaseAudit_provideFeedback)
Case Audits (CaseAudit_randomFilterListForAuditPlan)
Assigned Audits (CaseAudit_reassignCaseAudit)
Reassign Case Audits (CaseAudit_reassignCaseAudits)
Confirm Removal of Assignment (CaseAudit_removeAssignCaseAudits)
Assigned Audits (CaseAudit_removeAssignment)
CaseAudit_searchCaseAudit
Select Specific Cases to Audit (CaseAudit_selectCase)
Home (CaseAudit_viewAuditPlan)
CaseAudit_viewAuditPlanTabDetail
View Case Audit Finding (CaseAudit_viewCaseAuditAndFocusAreaFindings)
View Findings (CaseAudit_viewCaseAuditFinding)
CaseAudit_viewCaseAuditTabDetail
Feedback (CaseAudit_viewFeedback)
Add Attachment (FocusAreaFinding_createAttachment)
Attachments (FocusAreaFindingAttachments_listByCaseAudit)
Edit Attachment (MeetingMinutes_modifyAttachmentFromList)
Edit Attachment (MeetingMinutes_modifyAttachmentFromListFromAgenda)
Edit Attachment (MeetingMinutes_modifySingleAttachment)
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 Attachment (ProviderManagement_modifyIncidentAttachment)
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)
Edit Attachment (SocialEnterpriseFolder_modifyAttachmentFromList)
Edit Attachment (SocialEnterpriseFolder_modifyAttachmentFromView)
Modify File: (SocialEnterpriseFolder_modifyIncidentFileFromList)
Modify File: (SocialEnterpriseFolder_modifyIncidentFileFromView)