Table Description
Product Category: A category of products.
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::ProductCategory::ProductCategory
Controlling File: core\model\Packages\Products\ProductCategory_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (3)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
productCategoryIDkeynoUnique reference number assigned by the systemINTERNAL_ID SVR_INT64
productIDdetailsnoUnique reference number assigned by the system to a Product recordPRODUCT_ID SVR_INT64
categoryCodedetails Product Category code. All Products can be placed into one or more Categories. Codetable is 'ProductCategory'.CODETABLE_CODE SVR_STRING<10>
Foreign Keys (1)
ChildParent
ProductCategory.productIDProduct.productID
Indices (2)
Index NameAttributes
ProductCategoryIdxcategoryCode
ProdIDCategoryIndeproductID, categoryCode
Operations (12)
OperationStereotypeOptionsDescriptionSQL
insertinsertPRE_DATA_ACCESS: yes
Standard Operation 
searchAllProductCategoriesnsmultiREADMULTI_LIM: 0
 		Returns a list of all ProductCategory codes in the codetable.SQL
searchCategoriesByProductnsreadmultiPRE_DATA_ACCESS: yes
READMULTI_LIM: 0
Reads all categories that apply to a Product. 
searchAllCategoriesNotForProductnsmultiPRE_DATA_ACCESS: yes
READMULTI_LIM: 0
 		Reads all categories that do NOT apply to a Product.SQL
removeProductnsremove Removes all records containing the specified Product.  
searchProductsByCategorynsreadmulti Search Product Category by Category. 
removeCategoryFromProductnsremove Removes a category from a product. 
searchProductsByCategoryAndStatusnsmulti  SQL
searchByProductIDreadmulti Return&nbsp;a&nbsp;list&nbsp;of product category records&nbsp;by&nbsp;product ID. 
modifymodify Modifies a row of data from ProductCategory table. 
readread Reads a row of data from ProductCategory table. 
insertProductCategoryinsert Inserts product category record. This method expects the productCategoryID to be set. It is preferred to call insertProductCategory method only in scenarios where calling method wants to set the value of primary key by itself. 
Related Pages (64)
Search Case (Appeal_searchCase)
Search Case (Appeal_searchHearingReviewCase)
Search Case (Appeal_searchHearingReviewCaseForIC)
Search Case (Appeal_searchJudicialReviewCase)
Add Determination Appeal (AppealDetermination_searchCase)
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)
Select Product Type (DefaultICMember_selectBenefitType)
Home (HCRIC_home)
Select Product Type (ICMember_selectBenefitType)
Select Product Type (ICSample_selectBenefitType)
Select Case Member (ICSample_selectMember)
Select Case Member (ICSample_selectMember1)
Intake_quickSearch
Organization_applicationSearch
My Items of Interest (Organization_listBookmarkedCases)
Organization_listUserBookmark
My Items of Interest (Organization_listUserBookmarkedCases)
My Cases (Organization_userCases)
OutcomePlan_applicationSearch
Add Category (Product_addCategoryToBenefit)
Add Category (Product_addCategoryToLiability)
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)
Remove Category (Product_removeCategoryFromBenefitVerify)
Remove Category (Product_removeCategoryFromLiabilityVerify)
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)