Table Description
Product Delivery Pattern: The product delivery pattern groups defined for a product.
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::ProductDeliveryPattern::ProductDeliveryPattern
Controlling File: core\model\Packages\Products\ProductDeliveryPattern_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (2)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
productDeliveryPatternIDkeynoUnique identifier for this recordPRODUCT_DELIVERY_PATTERN_ID SVR_INT64
productIDdetailsnoProduct that the pattern is associated withPRODUCT_ID SVR_INT64
Foreign Keys (4)
ChildParent
ProductDeliveryPattern.productIDProduct.productID
CaseNomineeProdDelPattern.productDeliveryPatternIDProductDeliveryPattern.productDeliveryPatternID
ProductDeliveryPatternInfo.productDeliveryPatternIDProductDeliveryPattern.productDeliveryPatternID
Product.defaultProductDelPatternIDProductDeliveryPattern.productDeliveryPatternID
Indices (1)
Index NameAttributes
ProdDelPatProdIDproductID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertPRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
searchByProductIDreadmulti Return a list of ProductDeliveryPattern records by productID. 
searchByCaseIDnsmulti Method to return a list of ProductDeliveryPattern records by caseID.SQL
modifymodify Modifies a row of data from ProductDeliveryPattern table. 
insertProductDeliveryPatterninsert Inserts product delivery pattern record. This method expects the productDeliveryPatternID to be set. It is preferred to call insertProductDeliveryPattern method only in scenarios where calling method wants to set the value of primary key by itself. 
Related Pages (152)
Select Delivery Pattern (BenefitSample_selectDeliveryPattern)
Add Member (CHIPProduct_addAssistanceGroupMember)
Confirm Benefit Group Member (CHIPProduct_confirmAddBenefitGroupMember)
Remove Member (CHIPProduct_removeAssistanceGroupMember)
Remove Member (CHIPProduct_removeBenefitGroupMember)
New Product Delivery (DefaultIC_createProductDelivery)
Select Delivery Pattern (DefaultICMember_selectDeliveryPattern)
Program Summary (Eligibility_createProgram)
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)
Select Delivery Pattern (ICMember_selectDeliveryPattern)
View Delivery Patterns (ICProduct_viewDeliveryPattern)
Create Delivery (ICSample_createProductDelivery)
Select Delivery Pattern (ICSample_selectDeliveryPattern)
View Delivery Pattern (ICSample_viewDeliveryPattern)
View Delivery Pattern (ICSample_viewDeliveryPatternHistory)
View Delivery Patterns (ICSportingGrantSample_viewDeliveryPattern)
Cancel Sanction (ISP_cancelSanctionEvidence)
Cancel Disregard (ISP_cancelSanctionOverride)
Retroactive Program Summary (ISP_createRetroactiveProgram)
New Sanction (ISP_createSanctionEvidence)
New Disregard (ISP_createSanctionOverride)
Edit Sanction (ISP_modifySanctionEvidence_fromList)
Edit Sanction (ISP_modifySanctionEvidence_fromView)
Edit Disregard (ISP_modifySanctionOverride_fromList)
Modify Sanction Override Details: (ISP_modifySanctionOverride_fromView)
View Delivery Patterns (ISPProduct_viewDeliveryPattern)
Medical Assistance with Spend Down Program Summary (ISPSpendDown_createProgram)
Create Program (ISPSpendDown_createRetroactiveProgram)
Edit Delivery Pattern (LiabilitySample_modifyBillingPattern)
Select Delivery Pattern (LiabilitySample_selectBillingPattern)
Reverse Line Item (Participant_createLineItemReversal)
View Delivery Pattern (PdtDelivery_viewDeliveryPatternTransaction)
New Product (Product_benefitWizardSummary)
New Product (Product_benefitWizardSummary1)
Delete Billing Pattern (Product_cancelBillingPattern)
Delete Delivery Pattern (Product_cancelDeliveryPattern)
New Billing Pattern (Product_createBillingPattern)
New Delivery Pattern (Product_createDeliveryPattern)
Billing Patterns (Product_listBillingPattern)
Delivery Patterns (Product_listDeliveryPattern)
Edit Billing Pattern (Product_modifyBillingPatternFromList)
Edit Billing Pattern (Product_modifyBillingPatternFromView)
Edit Delivery Pattern (Product_modifyDeliveryPatternFromList)
Edit Delivery Pattern (Product_modifyDeliveryPatternFromView)
New Product (Product_summaryForBenefitWizard)
New Product (Product_summaryForLiabilityWizard)
View Billing Pattern (Product_viewBillingPattern)
View Billing Pattern (Product_viewBillingPatternHistory)
View Delivery Pattern (Product_viewDeliveryPattern)
View Delivery Pattern (Product_viewDeliveryPatternHistory)
New Case Nominee (ProductDelivery_createCaseNominee)
New Case Nominee (ProductDelivery_createCaseNominee1)
New Delivery Pattern (ProductDelivery_createDeliveryPattern)
New Nominee Delivery Pattern (ProductDelivery_createNomineeDeliveryPattern)
Edit Delivery Pattern (ProductDelivery_modifyDeliveryPattern)
Edit Delivery Pattern (ProductDelivery_modifyDeliveryPatternForCaseNominee)
Edit Nominee Delivery Pattern (ProductDelivery_modifyNomineeDeliveryPattern)
Edit Nominee Delivery Pattern (ProductDelivery_modifyNomineeDeliveryPattern1)
View Delivery Pattern (ProductDelivery_viewDeliveryPattern)
View Delivery Pattern (ProductDelivery_viewDeliveryPattern1)
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)
Edit Placement Payment Frequency (ProviderManagement_modifyPlacementPaymentFrequency)
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)
Edit Delivery Method (Resource_modifyDeliveryMethod)
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)
New Product (Wizard_benefitSummary)
New Product (Wizard_liabilitySummary)