Table Description
Product Assessment Configuration: Provides the admin functionality to maintain the association between product and assessments.
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::PDAssessmentConfiguration::Entity::PDAssessmentConfiguration
Controlling File: core\model\Packages\Reference Model\Service Layer\PDAssessmentConfiguration\Entity\PDAssessmentConfiguration_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
pdAssessmentConfigurationIDkeyno INTERNAL_ID SVR_INT64
productIDdetailsno PRODUCT_ID SVR_INT64
assessmentConfigurationIDdetailsno ASSESSMENT_CONFIGURATION_ID SVR_INT64
startDatedetails  CURAM_DATE SVR_DATE
endDatedetails  CURAM_DATE SVR_DATE
recordStatusdetails  RECORD_STATUSRecordStatusSVR_STRING<10>
Foreign Keys (2)
ChildParent
PDAssessmentConfiguration.assessmentConfigurationIDAssessmentConfiguration.assessmentConfigurationID
PDAssessmentConfiguration.productIDProduct.productID
Indices (1)
Index NameAttributes
PDAssessConfIdxassessmentConfigurationID, productID
Operations (19)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: pdAssessmentConfigurationID
AUTO_ID_KEY: PRODUCTBO
PRE_DATA_ACCESS: yes
This method inserts a record. 
searchByProductIDnsmulti Returns a list of assessment configurations, regardless of the status, associated with an product case configuration.SQL
countOverlappingPDAssessConfigsnsPRE_DATA_ACCESS: yes
 
This method counts the number of overlapping PDAssessmentConfiguration.SQL
validateOverlap  Validates the dates of the association between the assessment and the Product. 
validateDates  Validates the dates of the association between the assessment and the integrated case. 
readPDAssessmentConfigns Read the details of the relationship between a product and an assessment.SQL
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
This method is used to modify the start date and end date of the association. 
cancelnsmodifyPRE_DATA_ACCESS: yes
Changes the status of the record to cancelled. 
searchProductsByAssessmentConfigurationnsmulti Returns a list of products, regardless of the status, associated with an assessment configuration.SQL
readread This method reads a record. 
searchActiveAssessmentConfigByProductAndStatusnsmultiPRE_DATA_ACCESS: yes
 
Returns a list of active assessment configurations, associated with an product case configuration.SQL
searchDistinctAssessmentConfigByAdminIntegratedCasensmulti Returns a list of distinct active assessment configurations, associated with an product case configuration.SQL
readByAssessmentConfigurationIDProductIDAndStatusnsmulti Read all the PDAssessmentConfigurationDtls by the assessmentConfigurationID, ProductID and record statusSQL
searchByProductIDKeyreadmulti Return&nbsp;a&nbsp;list&nbsp;of&nbsp;PD assessment configuration records&nbsp;by&nbsp;product ID. 
searchByAssessmentConfigurationIDreadmulti Returns list of PD assessment configuration records by a assessment configuration&nbsp;ID. 
insertPDAssessmentConfigurationinsertPRE_DATA_ACCESS: yes
<p class="MsoNormal"> <span style="COLOR: #002060">Inserts&nbsp;PD assessment configuration&nbsp;record. This method expects the pdAssessmentConfigurationID to be set. It is preferred to call insertPDAssessmentConfiguration method only in scenarios where calling method wants to set the value of primary key by itself.</span> </p> 
removeremove Removes a record from PD assessment configuration table. 
searchByProductIDAndVersionNonsmulti Returns a list of assessment configurations, regardless of the status, associated with an product case configuration.SQL
modifyPDAssessmentConfigurationmodifyOPTIMISTIC_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 (9)