Table Description
Investigation Case Assessment Configuration: Provides the admin functionality to maintain Investigation Cases and the assessments associated with them.
Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Service Layer::InvCAssessmentConfig::Entity::InvCAssessmentConfig
Controlling File: core\model\Packages\Reference Model\Service Layer\InvCAssessmentConfig\Entity\InvCAssessmentConfig_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
invCAssessmentConfigIDkeynoInternal identifier associating an integrated case with an assessment.INTERNAL_ID SVR_INT64
assessmentConfigurationIDdetails Assessment configuration identifier.ASSESSMENT_CONFIGURATION_ID SVR_INT64
investigationConfigIDdetails Integrated case identifier.INVESTIGATION_CONFIG_ID SVR_INT64
startDatedetails The date from when the association between the integrated case and the assessment began.CURAM_DATE SVR_DATE
endDatedetails The date when the association between the integrated case and the assessment endedCURAM_DATE SVR_DATE
recordStatusdetails The status of the association between the integrated case and the assessment.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Indices (1)
Index NameAttributes
InvCAOverlapIndexinvestigationConfigID, assessmentConfigurationID, recordStatus, startDate, endDate
Operations (16)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: invCAssessmentConfigID
AUTO_ID_KEY: INVESTGNBO
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
removeremove Standard Operation 
cancelInvCAssessmentConfignsmodify Changes the status of a record to canceled. 
validateOverlap  Validates that there is no overlap between the investigation case and any other assessment. 
validateDates  Validates the dates of the association between the assessment and the investigation case. 
countOverlapingICAssessConfigsnsPRE_DATA_ACCESS: yes
 		Counts the number of records that overlap the specified record.SQL
searchByInvestigationConfigIDnsmulti Returns a list of assessment configurations, regardless of the status, associated with an investigation case configuration.SQL
readICAssessmentConfigns Read the details of the relationship between an investigation case and an assessment.SQL
searchInvCAssessmentConfigByInvestigationCaseIDreadmulti   
searchInvestigationCaseTypesByAssessmentConfigurationnsmulti This method list investigation cases that are associated to an assessment configuration.SQL
searchDistinctAssessmentConfigByInvestigationCasensmulti Returns a list of distinct active assessment configurations, associated with an investigation case.SQL
searchByAssessmentConfigurationIDInvestigationConfigIDAndStatusnsmulti Read the all the InvCAssessmentConfigDtls by assessmentConfigurationId, investigationConfigID and recordStatus.SQL
insertInvCAssessmentConfiginsert Inserts&nbsp;investigation assessment&nbsp;configuration record. This method expects the invCAssessmentConfigID to be set. It is preferred to call insertInvCAssessmentConfig method only in scenarios where calling method wants to set the value of primary key by itself. 
modifyInvCAssessmentConfigmodifyOPTIMISTIC_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 (7)