Table Description
Product Concern Role: The association of a product with a participant role type for which the product is applicable.

There can be more than one participant role type associated with any one product.

Technical Notes

Optimistic locking is not required for this table as the data is never modified.

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::Products::Entity Objects::ProductConcernRole::ProductConcernRole
Controlling File: core\model\Packages\Products\ProductConcernRole_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGno
Attributes (3)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
productIDdetailsnoThe ID of the Product to which this record refers.PRODUCT_ID SVR_INT64
concernRoleTypedetails The concernRoleType to which the product is applicableCONCERN_ROLE_TYPE_CODEConcernRoleTypeSVR_STRING<10>
productConcernRoleIDkeynoUnique reference number assigned by the system to a ProductConcernRole record - generated.PRODUCT_CONCERN_ROLE_ID SVR_INT64
Foreign Keys (1)
ChildParent
ProductConcernRole.productIDProduct.productID
Indices (2)
Index NameAttributes
PCProductIdxproductID
PCConcProdIdxproductID, concernRoleType
Operations (9)
OperationStereotypeOptionsDescriptionSQL
insertinsertPRE_DATA_ACCESS: yes
Standard Operation 
searchTypesByProductnsreadmulti Method to return a list of all client types eligible for a specified Product. 
searchTypesNotForProductnsmulti Method to return a list of Client Types not eligible for a specified Product.SQL
removeTypesByProductnsremove Method to remove the Client Types associated with a Product. 
readByProductAndTypensread Read by productID and concernRoleType. 
searchByProductIDreadmulti Return&nbsp;a&nbsp;list&nbsp;of products which is associated with a participant role type for which the product is applicable. 
modifymodify Modifies a row of data from ProductConcernRole table. 
readread Reads a row of data from ProductConcernRole table. 
insertProductConcernRoleinsert Inserts product concern role record. This method expects the productConcernRoleID to be set. It is preferred to call insertProductConcernRole method only in scenarios where calling method wants to set the value of primary key by itself. 
Related Pages (60)
Search Case (Appeal_searchCase)
Search Case (Appeal_searchHearingReviewCase)
Search Case (Appeal_searchHearingReviewCaseForIC)
Search Case (Appeal_searchJudicialReviewCase)
Add Determination Appeal (AppealDetermination_searchCase)
Select Product Type (BenefitSample_selectBenefitType)
My Case Queries (Case_queryListAndRun)
(Case_queryResults)
) (Case_runQueryFromList)
) (Case_runQueryFromWorkspace)
Case Search (Case_search1)
Case Search (Case_searchPopup1)
Home (DefaultIC_home)
New Product Delivery (DefaultIC_selectMember)
Home (HCRIC_home)
Select Product Type (ICSample_selectBenefitType)
Select Case Member (ICSample_selectMember)
Select Case Member (ICSample_selectMember1)
Intake_quickSearch
Select Product Type (LiabilitySample_selectLiabilityType)
Organization_applicationSearch
My Items of Interest (Organization_listBookmarkedCases)
Organization_listUserBookmark
My Items of Interest (Organization_listUserBookmarkedCases)
My Cases (Organization_userCases)
OutcomePlan_applicationSearch
Benefit Product Home: (Product_benefitHome)
Home (Product_benefitHome1)
Home (Product_benefitHomeFinancials)
Home (Product_benefitHomeParticipants)
Home (Product_benefitHomeSecurity)
New Product (Product_benefitWizardSummary)
New Product (Product_benefitWizardSummary1)
Product_correctionHome
Product_correctionHomeFinancials
Product_correctionHomeSecurity
New Benefit Product (Product_createBenefit)
New Benefit Product (Product_createBenefit1)
New Liability Product (Product_createLiability)
New Liability Product (Product_createLiability1)
Liability Product Home (Product_liabilityHome)
Home (Product_liabilityHome1)
Home (Product_liabilityHomeFinancials)
Home (Product_liabilityHomeParticipants)
Home (Product_liabilityHomeSecurity)
Edit Benefit Product (Product_modifyBenefitFromList)
Edit Benefit Product (Product_modifyBenefitFromList1)
Edit Benefit Product (Product_modifyBenefitFromView)
Edit Benefit Product (Product_modifyBenefitFromView1)
Edit Correction Case (Product_modifyCorrection)
Edit Liability Product (Product_modifyLiabilityFromList)
Edit Liability Product (Product_modifyLiabilityFromList1)
Edit Liability Product (Product_modifyLiabilityFromView)
Edit Liability Product (Product_modifyLiabilityFromView1)
New Product (Product_summaryForBenefitWizard)
New Product (Product_summaryForLiabilityWizard)
Return Line Items for Supplier (ServiceSupplier_listReturnLineItem)
Case Search (SocialEnterpriseFolder_searchCaseAddMember)
New Product (Wizard_benefitSummary)
New Product (Wizard_liabilitySummary)