Table Description
Product Rules Link: The rules which are used to perform eligibility assessments for a product over a given period of time.
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::ProductRulesLink::ProductRulesLink
Controlling File: core\model\Packages\Products\ProductRulesLink_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
VALIDATION_EXIT_POINTno
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
productRulesLinkIDkeynoUnique ID to identify a product rules link recordPRODUCT_RULES_LINK_ID SVR_INT64
ruleSetIDdetails Unique ID of the rule set to be applied when performing eligibility assessment on a product.RULE_SET_ID SVR_STRING<16>
productIDdetailsnoForeign key to the Product EntityPRODUCT_ID SVR_INT64
startDatedetailsnostart date for the linkCURAM_DATE SVR_DATE
endDatedetailsnoend date for the linkCURAM_DATE SVR_DATE
commentsdetails comment fieldCOMMENTS SVR_STRING<300>
statusCodedetails status of the product rules linkRECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
ProductRulesLink.productIDProduct.productID
Indices (1)
Index NameAttributes
RulesByProdIDDateIproductID, startDate, endDate
Operations (10)
OperationStereotypeOptionsDescriptionSQL
insertinsertPRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
cancelnsmodifyPRE_DATA_ACCESS: yes
Entity operation to cancel a products rule link, sets the record status to canceled. 
searchByProductAndDatensmulti Read Product Rules Link by Product and Date.SQL
searchRulesLinkByProductIDreadmultiORDER_BY: startDate
Returns a list of product rules link details by product ID. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies an existing product rules link record 
readByProductAndDatens Read Product Rules Link by Product and Date.SQL
readStatusnsread Entity operation to read a product rules link record status. 
validateCancel  Entity operation to validate cancel product rules link details, checks if the record has already been canceled. 
insertProductRulesLinkinsert <p class="MsoNormal"> <span style="COLOR: #002060">Inserts product rules link record. This method expects the productRulesLinkID to be set. It is preferred to call insertProductRulesLink method only in scenarios where calling method wants to set the value of primary key by itself.</span> </p> 
Related Pages (232)
Add Member (addGroupMemberLIFC)
Add Member (addGroupMemberRefugee1)
Utility Payments (BenefitSample_listUtilityPayment)
Approval Details (Case_viewApproval)
Approval Details (Case_viewApprovalFullTree)
Approval Details (Case_viewApprovalInline)
Approval Details (Case_viewApprovalTextBasedTree)
View Approval (Case_viewApprovalTextBasedTreeViewOnly)
Submitted For Approval Details (Case_viewSubmitForApproval)
Submitted For Approval Details (Case_viewSubmitForApprovalFullTree)
Case_viewSubmitForApprovalInline
View Submit For Approval (Case_viewSubmitForApprovalOnly)
Submitted For Approval Details (Case_viewSubmitForApprovalTextBasedTree)
View Submit For Approval (Case_viewSubmitForApprovalViewOnly)
Add Member (CHIPProduct_addAssistanceGroupMember)
Add Member (CHIPProduct_addBenefitGroupMember)
Confirm Benefit Group Member (CHIPProduct_confirmAddBenefitGroupMember)
Assistance (CHIPProduct_listAssistanceGroupMember)
Assistance (CHIPProduct_listBenefitGroupMember)
Remove Member (CHIPProduct_removeAssistanceGroupMember)
Remove Member (CHIPProduct_removeBenefitGroupMember)
Submit Case For Approval (CHIPProductDelivery_submit)
Program Summary (Eligibility_createProgram)
Decision Details (Eligibility_viewDecision)
Decision Details (Eligibility_viewDecisionWithFullRulesTree)
Decision Details (Eligibility_viewDecisionWithStaticRulesTree)
View Member Eligibility Details (Eligibility_viewMemberEligibilityDetails)
Eligibility Result (Eligibility_viewResults)
Eligibility Result (Eligibility_viewResultsFromIC)
Cancel Payment (Financial_cancelPayment)
Cancel Payment (Financial_cancelPayment1)
Cancel Issued Payment (Financial_cancelPaymentInstrument)
Reverse Instruction (Financial_createInstructionReversal)
Reverse Details (Financial_createLineItemReversal)
Invalidate Payment (Financial_invalidatePayment)
Check Retroactive Medicaid Eligibility (HCRRetroactiveMedicaid_confirmCheckEligibilty)
Utility Payments (ICBenefitUnderPayment_listUtilityPayment)
Utility Payments (ICProductSample_listUtilityPayment)
Utility Payments (ICSportingGrantSample_listUtilityPayment)
Confirm Appointment: (IncomeSupportScreening_createAppointment)
Eligibility Summary Communication: (IncomeSupportScreening_generateEligibilitySummaryComm)
Home: (IncomeSupportScreening_home)
Decision Details: (IncomeSupportScreening_viewDecisionDetails)
Screening Result: (IncomeSupportScreening_viewEligibilityResult)
Ineligible Decision Details: (IncomeSupportScreening_viewIneligibleDecision)
Cancel Sanction (ISP_cancelSanctionEvidence)
Cancel Disregard (ISP_cancelSanctionOverride)
Check Retroactive Spend Down Eligibility (ISP_checkSpendDownRetroactiveEligibility)
Renew Program (ISP_confirmProgramRenewal)
Retroactive Program Summary (ISP_createRetroactiveProgram)
New Sanction (ISP_createSanctionEvidence)
New Disregard (ISP_createSanctionOverride)
Evidence Used By Rule: (ISP_MAViewRuleEvidence)
Edit Sanction (ISP_modifySanctionEvidence_fromList)
Edit Sanction (ISP_modifySanctionEvidence_fromView)
Edit Disregard (ISP_modifySanctionOverride_fromList)
Modify Sanction Override Details: (ISP_modifySanctionOverride_fromView)
Renew Program (ISP_renewProductDeliveryConfirmation)
Select Assistance Unit Members (ISP_selectChipAssistanceUnitMemberForRenewal)
Select Assistance Unit Members (ISP_selectChipAssistanceUnitMembers)
Medical Assistance Eligibility Result (ISP_viewCurrentChipRenewalEligibilityDetails)
Medical Assistance Eligibility Result (ISP_viewCurrentChipRenewalIneligibleDetails)
Retroactive Medical Assistance Eligibility Result (ISP_viewCurrentRetroactiveMedicalAssistanceEligibilityResults)
Retroactive Spend Down Eligibility Result (ISP_viewCurrentRetroactiveSpendDownEligibilityResults)
Medical Assistance with Spend Down Eligibility Result (ISP_viewMedicalAssistanceWithSDEligibilityDetails)
View Member Eligibility Details (ISP_viewMemberEligibilityDetails)
View Premium and Co-Payment Limit (ISP_viewPremiumAndCoPaymentLimit)
View Premium and Co-Payment Limit (ISP_viewPremiumAndCoPaymentLimitForRenewal)
Medical Assistance Eligibility Result (ISP_viewProductDeliveryRenewEligibilityResult)
Medical Assistance Eligibility Result (ISP_viewProductDeliveryRenewInEligibilityResult)
Retroactive Medical Assistance Eligibility Result (ISP_viewRetroactiveMedicalAssistanceEligibilityDetails)
Medical Assistance with Spend Down Retroactive Eligibility Result (ISP_viewRetroactiveMedicalAssistanceWithSDEligibilityDetails)
Retroactive Spend Down Eligibility Result (ISP_viewRetroactiveSpendDownMedicalAssistanceEligibilityDetails)
Evidence Used By Rule: (ISP_ViewRuleEvidence)
Utility Payments (ISPProduct_listUtilityPayment)
Decision Details (ISPProductDelivery_viewDecision)
Decision Details (ISPProductDelivery_viewDecisionWithFullRulesTree)
Decision Details (ISPProductDelivery_viewDecisionWithStaticRulesTree)
Medical Assistance with Spend Down Program Summary (ISPSpendDown_createProgram)
Create Program (ISPSpendDown_createRetroactiveProgram)
Reuse Program (ISPSpendDown_reuseProgram)
Reuse Program (ISPSpendDown_reuseRetroactiveProgram)
Select Application Date (ISPSpendDown_selectApplicationDate)
Assistance (ISPSpendDownProduct_listBenefitGroupMembers)
Financial (ISPSpendDownProduct_listFinancialGroupMembers)
Member (ISPSpendDownProduct_listGroupMembers)
LIFCPreviewPanel
Assistance (LIFCProduct_listBenefitGroupMembers)
Financial (LIFCProduct_listFinancialGroupMembers)
Decision Details (LIFCProduct_viewDecision)
Decision Details (LIFCProduct_viewDecisionWithFullRulesTree)
Decision Details (LIFCProduct_viewDecisionWithStaticRulesTree)
LIFCProductHomeDetails
Assistance (listBenefitGroupMembers)
Financial (listFinancialGroupMembers)
Member (listGroupMembers)
Member (listGroupMembersLIFC)
Member (listGroupMembersLTC)
Member (listGroupMembersRefugee)
Member (listGroupMembersTBBCC)
Member (listPreviousCurrentGroupMembersLIFC)
Member (listPreviousCurrentGroupMembersRefugee)
Assistance (LTCProduct_listBenefitGroupMembers)
Financial (LTCProduct_listFinancialGroupMembers)
Reverse Line Item (Participant_createLineItemReversal)
Utility Payments (PDBenefitUnderPayment_listUtilityPayment)
Edit Utility Payment (Person_modifyUtilityPaymentFromList)
Edit Utility Payment (Person_modifyUtilityPaymentFromView)
View Utility Payment (Person_viewUtilityPayment)
Rule Sets (Product_listBenefitRuleSet)
Rule Sets (Product_listBenefitRuleSet1)
Rule Sets (Product_listLiabilityRuleSet)
Evidence Comparison (ProductDelivery_compareBenefitDecisionEvidence)
Rules Comparison (ProductDelivery_compareBenefitDecisionRules)
Evidence Differences Only (ProductDelivery_compareBenefitEvidenceDifferenceOnly)
ProductDelivery_compareDecisionEvidence
ProductDelivery_compareDecisionRules
ProductDelivery_compareEvidenceDifferenceOnly
Evidence Comparison (ProductDelivery_compareLiabilityDecisionEvidence)
Rules Comparison (ProductDelivery_compareLiabilityDecisionRules)
Evidence Differences Only (ProductDelivery_compareLiabilityEvidenceDifferenceOnly)
ProductDelivery_compareViewNewDecision
ProductDelivery_compareViewOldDecision
New Utility Payment (ProductDelivery_createUtilityPayment)
ProductDelivery_listCaseApprovalEventCreoleDecisions
View Decision (ProductDelivery_listCaseApprovalEventCreoleDecisionsViewOnly)
ProductDelivery_listSubmitForApprovalCreoleDecisions
ProductDelivery_listSubmitForApprovalCreoleDecisionsViewOnly
View Decision (ProductDelivery_viewDecision)
View Decision (ProductDelivery_viewDecisionInline)
View Decision (ProductDelivery_viewDecisionViewOnly)
Decision Details (ProductDelivery_viewDecisionWithFullRulesTree)
Decision Details (ProductDelivery_viewDecisionWithStaticRulesTree)
View Decision (ProductDelivery_viewDecisionWithStaticRulesTreeInline)
View Decision (ProductDelivery_viewDecisionWithStaticRulesTreeViewOnly)
ProductDelivery_viewNewDecisionWithStaticRulesTreeOnly
ProductDelivery_viewOldDecisionWithStaticRulesTreeOnly
Evidence Used By Rule (ProductDelivery_viewRuleEvidence)
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 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)
Assistance (RefugeeProduct_listBenefitGroupMembers)
Financial (RefugeeProduct_listFinancialGroupMembers)
Remove Member (removeGroupMember)
Assign Rule Set To Product (Resource_assignProductRuleSet)
Delete Rule Set Assignment (Resource_cancelProductRuleSet)
Edit Rule Set Assignment (Resource_modifyProductRuleSetFromList)
Edit Rule Set Assignment (Resource_modifyProductRuleSetFromView)
View Rule Set Assignment (Resource_viewProductRuleSet)
New Disregard (SanctionAssessment_createDisregard_CREOLE)
New Sanction (SanctionAssessment_createSanction_CREOLE)
Edit Sanction (SanctionAssessment_modifySanction)
Edit Recommendation Disregard (SanctionAssessment_modifySanctionOverride)
Add Plan Item (ServicePlanDelivery_addCustomServicePlanItem)
Add Plan Item (ServicePlanDelivery_addServicePlanItem)
Edit Plan Item (ServicePlanDelivery_modifyCustomServicePlanItemProviderEditable)
Edit Plan Item (ServicePlanDelivery_modifyCustomServicePlanItemProviderNonEditable)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanItemProviderEditable)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanItemProviderNonEditable)
Create Summary View Configuration: (SummaryView_createConfiguration)
Assistance (TBBCC_listBenefitGroupMembers)
Financial (TBBCC_listFinancialGroupMembers)
Submit Case For Approval (TBBCCProductDelivery_submit)