Table Description
Investigation Config: Configuration details of a type of investigation which may need to be recorded independently or during case processing.

This table stores the configuration details of types of investigations which can be created on a product delivery or integrated case or as a standalone case.

Example

During case processing a user receives information that a client may be working while at the same time claiming benefit. An investigation must be created by the user to record details of the suspicion and any actions taken to determine if the client is at fault. To facilitate this, an investigation of type Benefit Fraud must be created in the Administration component. The configuration details of the Benefit Fraud investigation are stored on the Issue Configuration table.

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::InvestigationConfiguration::Entity::InvestigationConfig
Controlling File: core\model\Packages\Reference Model\Service Layer\InvestigationConfiguration\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
VALIDATION_EXIT_POINTyes
Attributes (17)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
investigationConfigIDkeynoUnique reference number assigned by the system to the investigation config record.INVESTIGATION_CONFIG_ID SVR_INT64
typedetails The type of the investigation.INVESTIGATION_CONFIG_TYPEInvestigateConfigTypeSVR_STRING<10>
homePageIdentifierdetails Home page identifier associated with this type of investigation.HOME_PAGE_IDENTIFIER SVR_STRING<200>
startDatedetails Start date of the period for which the configuration details are valid.CURAM_DATE SVR_DATE
endDatedetails End date of the period for which the configuration details are valid.CURAM_DATE SVR_DATE
readSecuritydetails Security Identifier associated with the read rights for this investigation type.SEC_SID_NAME SVR_STRING<100>
approveSecuritydetails Security Identifier associated with the approve rights for this investigation type.SEC_SID_NAME SVR_STRING<100>
createSecuritydetails Security Identifier associated with the creation rights for this investigation type.SEC_SID_NAME SVR_STRING<100>
maintainSecuritydetails Security Identifier associated with the maintain rights for this investigation type.SEC_SID_NAME SVR_STRING<100>
createEventdetails Workflow event to be raised when an investigation of this type is created.PDT_EVENT_CLASS_AND_TYPE SVR_STRING<200>
closeEventdetails Workflow event to be raised when an investigation of this type is closed.PDT_EVENT_CLASS_AND_TYPE SVR_STRING<200>
creationDatedetails The date the investigation type was added to the system.CURAM_DATE SVR_DATE
recordStatusdetails Status of the investigation config record. The values are 'Active' or 'Canceled'. Logical deletion is supported.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
commentsdetails Comments recorded by an administrator relating to the type of investigationCOMMENTS SVR_STRING<300>
ownershipStrategyNamedetails Name of the workflow process configured for this case type to determine a case owner.WORKFLOW_PROCESS_NAME SVR_STRING<254>
adminTranslationRequiredInddetailsyesIndicator to specify whether the system should automatically determine whether a translator is required for investigation participants.CURAM_INDICATOR SVR_BOOLEAN
contactLogInddetailsyesIndicates whether only case members should be available for selection as the concerning participant of a contact created within the contact log of a case.CURAM_INDICATOR SVR_BOOLEAN
Foreign Keys (3)
ChildParent
InvestigationApprovalCheck.investigationConfigIDInvestigationConfig.investigationConfigID
InvestigationDelivery.investigationConfigIDInvestigationConfig.investigationConfigID
InvestigationResolutionLink.investigationConfigIDInvestigationConfig.investigationConfigID
Operations (15)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: investigationConfigID
AUTO_ID_KEY: INVESTGNBO
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
readAllnkreadmultiORDER_BY: recordStatus, startDate
  
searchActiveOverlappingInvestigationConfignsmultiPRE_DATA_ACCESS: yes
 
 SQL
readEventDetailsnsread   
readInvestigationTypensread   
searchCurrentActiveInvestigationTypesnsmultiPRE_DATA_ACCESS: yes
 
 SQL
readRecordStatusnsread Retrieves the current status of the investigation configuration record. 
searchInvestigationTypesByStatusnsmulti List all Investigation types of a certain status.SQL
readSecurityDetailsnsread Reads the security details for an investigation configuration. 
searchAllInvestigationTypesnsmulti Returns all Investigation configuration types.SQL
readInvestigationConfigTabDetailsnsread Reads investigation configuration tab display details. 
insertInvestigationConfiginsert Inserts&nbsp;investigation configuration record. This method expects the investigationConfigID to be set. It is preferred to call insertInvestigationConfig method only in scenarios where calling method wants to set the value of primary key by itself. 
modifyInvestigationConfigmodifyOPTIMISTIC_LOCKING: yes
This modify operation will be called while re-applying a change set in the target system. Entity level validations that will happen during a standard modify operation will not be applicable in this case. This modify operation will update all the attributes defined for this entity. 
Related Pages (243)
Add Legal Status (AdminLegalStatus_associateCaseType)
Case Types (AdminLegalStatus_listSelectedCaseTypes)
Details (AdminLegalStatus_viewConfiguredCaseType)
Match Client (Application_matchClientConfirmation)
New Member (Case_createCaseMember)
Add Family as Case Members (Case_createCaseRelatedMember)
New Owner (Case_modifyCaseOwner)
Edit Contact (Case_modifyContactLogFromList)
Edit Contact (Case_modifyContactLogFromView)
New Contact (CaseContactLogWizard_createContact)
New Contact (CaseContactLogWizard_storeContact)
- (CDAApplication_viewDeterminationMultiSourceMC)
CDAApplication_viewDeterminationMultiSourceMCDecisionList
- (DecisionAssistApplication_answerQuestionnaire)
Cancel Assessment (DecisionAssistApplication_cancelAssessment)
Cancel Determination (DecisionAssistApplication_cancelDetermination)
Cancel Third Party Request (DecisionAssistApplication_cancelThirdPartyRequest)
Clone Assessment (DecisionAssistApplication_cloneAssessment)
- (DecisionAssistApplication_compareDecisionFromListDecisionHistory)
DecisionAssistApplication_compareDecisionFromViewAssessment
- (DecisionAssistApplication_compareDecisionFromViewAssessmentNoCoC)
- (DecisionAssistApplication_compareDecisionFromViewDetermination)
Complete Assessment (DecisionAssistApplication_completeAssessment)
Complete Determination (DecisionAssistApplication_completeDetermination)
Consolidate Answers (DecisionAssistApplication_consolidatedAnswers)
New Third Party (DecisionAssistApplication_createThirdParty)
New Third Party Request (DecisionAssistApplication_createThirdPartyRequests)
Edit Third Party Answers (DecisionAssistApplication_editThirdPartyAnswer)
Edit Third Party Request Details (DecisionAssistApplication_editThirdPartyRequest)
Decision History (DecisionAssistApplication_listAssessmentDecisionHistory)
Decision History (DecisionAssistApplication_listAssessmentDecisionHistoryNoCOC)
Decision History (DecisionAssistApplication_listAssessmentDecisionHistoryNoCOCMultiSourceAC)
Decision History (DecisionAssistApplication_listAssessmentDecisionHistoryNoCOCMultiSourceMC)
Decision History (DecisionAssistApplication_listAssessmentDecisionHistoryNoCOCSingleSource)
DecisionAssistApplication_listClientRoleNoCOC
DecisionAssistApplication_listClientRoleNoCOCMultiSourceAC
DecisionAssistApplication_listClientRoleNoCOCMultiSourceMC
DecisionAssistApplication_listClientRoleNoCOCSingleSource
DecisionAssistApplication_listClientRoleWithCOC
Communications (DecisionAssistApplication_listCommunicationNoCOC)
Communications (DecisionAssistApplication_listCommunicationNoCOCMultiSourceAC)
Communications (DecisionAssistApplication_listCommunicationNoCOCMultiSourceMC)
Communications (DecisionAssistApplication_listCommunicationNoCOCSingleSource)
Communications (DecisionAssistApplication_listCommunicationWithCOC)
- (DecisionAssistApplication_listDeterminationDecisionHistory)
Determinations (DecisionAssistApplication_listDeterminations)
Events (DecisionAssistApplication_listEventNoCOC)
Events (DecisionAssistApplication_listEventNoCOCMultiSourceAC)
Events (DecisionAssistApplication_listEventNoCOCMultiSourceMC)
Events (DecisionAssistApplication_listEventNoCOCSingleSource)
Events (DecisionAssistApplication_listEventWithCOC)
Notes (DecisionAssistApplication_listNoteNoCOC)
Notes (DecisionAssistApplication_listNoteNoCOCMultiSourceAC)
Notes (DecisionAssistApplication_listNoteNoCOCMultiSourceMC)
Notes (DecisionAssistApplication_listNoteNoCOCSingleSource)
Notes (DecisionAssistApplication_listNoteWithCOC)
Tasks (DecisionAssistApplication_listTaskNoCOC)
Tasks (DecisionAssistApplication_listTaskNoCOCMultiSourceAC)
Tasks (DecisionAssistApplication_listTaskNoCOCMultiSourceMC)
Tasks (DecisionAssistApplication_listTaskNoCOCSingleSource)
Tasks (DecisionAssistApplication_listTaskWithCOC)
User Roles (DecisionAssistApplication_listUserRoleNoCOC)
User Roles (DecisionAssistApplication_listUserRoleNoCOCMultiSourceAC)
User Roles (DecisionAssistApplication_listUserRoleNoCOCMultiSourceMC)
User Roles (DecisionAssistApplication_listUserRoleNoCOCSingleSource)
User Roles (DecisionAssistApplication_listUserRoleWithCOC)
Make Decision (DecisionAssistApplication_makeDecisionForAssessment)
Make Decision (DecisionAssistApplication_makeDecisionForDeterminationDelivery)
Record Third Party Answers (DecisionAssistApplication_recordThirdPartyAnswer)
- (DecisionAssistApplication_saveAnswers)
Select Decision For Comparison (DecisionAssistApplication_selectDecisionFromListDecisionHistory)
Select Decision For Comparison (DecisionAssistApplication_selectDecisionFromViewAssessment)
Select Decision For Comparison (DecisionAssistApplication_selectDecisionFromViewAssessmentNoCoC)
Select Decision For Comparison (DecisionAssistApplication_selectDecisionFromViewDetermination)
Send Third Party Request (DecisionAssistApplication_sendThirdPartyRequest)
- (DecisionAssistApplication_viewAnswers)
DecisionAssistApplication_viewAnswersForQuestionnaire
DecisionAssistApplication_viewAnswersForQuestionnaireMultiSource
Home (DecisionAssistApplication_viewAssessmentNoCOCMultiSourceAC)
Home (DecisionAssistApplication_viewAssessmentNoCOCMultiSourceMC)
Home (DecisionAssistApplication_viewAssessmentNoCOCSingleSource)
Assessment History (DecisionAssistApplication_viewAssessmentStatusHistory)
- (DecisionAssistApplication_viewAssessmentWithCOC)
Home (DecisionAssistApplication_viewAssessmentWithCOCNoTotalScore)
- (DecisionAssistApplication_viewAssessmentWithCOCWithTotalScore)
DecisionAssistApplication_viewConsolidatedAnswers
DecisionAssistApplication_viewDecisionDetails
DecisionAssistApplication_viewDetermination
- (DecisionAssistApplication_viewDeterminationMultiSourceAC)
- (DecisionAssistApplication_viewDeterminationMultiSourceACDecisionList)
- (DecisionAssistApplication_viewDeterminationMultiSourceMC)
- (DecisionAssistApplication_viewDeterminationSingleSource)
- (DecisionAssistApplication_viewDeterminationSingleSourceDecisionList)
Determination History (DecisionAssistApplication_viewDeterminationStatusHistory)
- (DecisionAssistApplication_viewMemberHomeForDetermination)
- (DecisionAssistApplication_viewMemberHomeNoCOC)
- (DecisionAssistApplication_viewMemberHomeThirdParty)
- (DecisionAssistApplication_viewMemberHomeWithCOC)
- (DecisionAssistApplication_viewQuestionAnswer)
- (DecisionAssistApplication_viewQuestionAnswers)
Questions & Answers (DecisionAssistApplication_viewQuestionAnswersNoCOC)
Questions & Answers (DecisionAssistApplication_viewQuestionAnswersNoCOCMultiSourceAC)
Questions & Answers (DecisionAssistApplication_viewQuestionAnswersNoCOCMultiSourceMC)
Questions & Answers (DecisionAssistApplication_viewQuestionAnswersNoCOCSingleSource)
View Third Party Request Details (DecisionAssistApplication_viewThirdPartyRequest)
Check Retroactive Medicaid Eligibility (HCRRetroactiveMedicaid_confirmCheckEligibilty)
New Investigation (ICInvestigationSample_create)
Clone Investigation Query (Investigation_cloneQuery)
New Investigation Query (Investigation_createQuery)
Edit Investigation Query (Investigation_modifyQuery)
Investigation Search (Investigation_search)
Approve Investigation Case (InvestigationDelivery_approve)
Edit Investigation (InvestigationDelivery_modifyHeader)
Reject Request For Approval (InvestigationDelivery_reject)
Submit For Approval (InvestigationDelivery_submit)
New Investigation (InvestigationSample_selectType)
New Investigation (InvestigationSample_selectTypeForPerson)
New Investigation (InvestigationSample_selectTypeFromNonRegisteredPerson)
Delete Skill (MultidisciplinaryTeamMember_cancelSkill)
Delete Skill (Organization_cancelUserSkill)
New Investigation Approval Check (Organization_createInvestigationApprovalCheckForOrgUnit)
New Investigation Approval Check (Organization_createInvestigationApprovalCheckForUser)
Investigation Type Search (Organization_investigationTypeSearchPopup)
Investigation (Organization_listInvestigationApprovalChecksForOrgUnit)
Investigation (Organization_listInvestigationApprovalChecksForUser)
Edit Investigation Approval Check (Organization_modifyInvestigationApprovalCheckForOrgUnitFromList)
Edit Investigation Approval Check (Organization_modifyInvestigationApprovalCheckForOrgUnitFromView)
Edit Investigation Approval Check (Organization_modifyInvestigationApprovalCheckForUserFromList)
Edit Investigation Approval Check (Organization_modifyInvestigationApprovalCheckForUserFromView)
Edit User's Language Skills (Organization_modifyUserLanguageSkills)
Organization_userInvestigation
New User Language Skills (Organization_userLanguageSkills)
View Investigation Approval Check for Organization Unit (Organization_viewInvestigationApprovalCheckForOrgUnit)
View Investigation Approval Check for User (Organization_viewInvestigationApprovalCheckForUser)
Edit Person (Person_evidenceModify)
Edit Client Details (Person_evidenceModifyClient)
Edit Person (Person_modifyPerson)
Add Existing Resolution (Product_addExistingResolutionForInvestigation)
Delete Investigation (Product_cancelInvestigationConfiguration)
New Approval Check (Product_createApprovalCheckForInvestigation)
New Investigation (Product_createInvestigationConfiguration)
New Resolution (Product_createResolutionForInvestigation)
Product_investigationConfigurationHomeTabDetails
Investigation Types (Product_listAllInvestigationTypesPopup)
Approval Checks (Product_listApprovalChecksForInvestigation)
Product_listInvestigationConfiguration
Milestones (Product_listMilestoneForInvestigationCase)
Resolutions (Product_listResolutionsForInvestigation)
Edit Approval Check (Product_modifyApprovalCheckForInvestigationFromList)
Edit Approval Check (Product_modifyApprovalCheckForInvestigationFromView)
Edit Investigation (Product_modifyInvestigationConfigFromList)
Edit Investigation (Product_modifyInvestigationConfigFromView)
View Approval Check For Investigation (Product_viewApprovalCheckForInvestigation)
Home (Product_viewInvestigationConfiguration)
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 Investigation Case (ProviderManagement_createInvestigation)
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)
Assessments (Resource_listInvestigationCaseAssessment)
Edit Assessment Assignment (Resource_modifyInvestigationCaseAssessmentFromList)
Edit Assessment Assignment (Resource_modifyInvestigationCaseAssessmentFromView)
View Assessment Assignment (Resource_viewInvestigationCaseAssessment)
Application (RightsAndResponsibilitiesForCase)
Application (RightsAndResponsibilitiesForCaseSubmit)
Add Plan Item (ServicePlanDelivery_addCustomServicePlanItem)
Add Plan Item (ServicePlanDelivery_addServicePlanItem)
Change Plan Owner (ServicePlanDelivery_changePlanOwner)
Edit Plan Item (ServicePlanDelivery_modifyCustomServicePlanItemProviderEditable)
Edit Plan Item (ServicePlanDelivery_modifyCustomServicePlanItemProviderNonEditable)
Set Plan Owner (ServicePlanDelivery_modifyPlanOwner)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanItemProviderEditable)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanItemProviderNonEditable)
New Owner (SocialEnterpriseFolder_modifyCaseOwner)
Delete user skill (Supervisor_cancelUserSkill)