Table Description
Product Provider: A type of participant that provides products to the organization which the organization offers to their customers.
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::Concern::Entity Objects::ProductProvider::ProductProvider
Controlling File: core\model\Packages\Concern\ProductProvider_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (13)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
concernRoleIDkeynoUnique reference number assigned by the system to a Concern Role record.CONCERN_ROLE_ID SVR_INT64
namedetails The governing First Name and Surname or label utilized by the Product Provider in their interaction with the Organization.PRODUCT_PROVIDER_NAME SVR_STRING<131>
registeredNamedetails The name, label or Business identity associated with the Product Provider which is legally registered with the appropriate Government agency and through which the Product Provider is addressedREGISTERED_NAME SVR_STRING<131>
statusCodedetails Code table code describing the record status of the product provider record.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
commentsdetails Free text registered by the User.COMMENTS SVR_STRING<300>
primaryAlternateIDdetails The primary alternate ID of the product provider.ALTERNATE_ID SVR_STRING<18>
nextPaymentDatedetailsyesThe next payment date for this product providerCURAM_DATE SVR_DATE
paymentFrequencydetailsyesThe frequency which the organization will calculate and make payments to the Product ProviderFREQUENCY_PATTERN SVR_STRING<9>
methodOfPmtCodedetailsyesThe method of payment for this Product ProviderMETHOD_OF_DELIVERY_CODEMethodOfDeliverySVR_STRING<10>
currencyTypedetailsyesThe preferred currency for the Product Provider.CURRENCY_CODECurrencySVR_STRING<10>
pinNumberdetails Product Provider's Personal Identification Number (PIN). This Personal Identification Number is used in a number of online Curam services.CUSTOMER_PIN_NUMBER SVR_STRING<4>
upperNamedetails The name of the Product Provider stored in upper case format to facilitate Product Provider search functionality in a case independent manner on the Product Provider's name.PRODUCT_PROVIDER_NAME SVR_STRING<131>
upperRegisteredNamedetails The registered name of the Product Provider stored in upper case format to facilitate Product Provider search functionality in a case independent manner on the Product Provider's registered name.REGISTERED_NAME SVR_STRING<131>
Foreign Keys (4)
ChildParent
ProductProvider.concernRoleIDConcernRole.concernRoleID
ProductDelivery.productProviderIDProductProvider.concernRoleID
ProductProvision.providerConcernRoleIDProductProvider.concernRoleID
ProviderLocation.productProviderIDProductProvider.concernRoleID
Indices (2)
Index NameAttributes
PPnxtPmtDateMOPIdxnextPaymentDate, methodOfPmtCode
ProductProviderIndprimaryAlternateID
Operations (19)
OperationStereotypeOptionsDescriptionSQL
insertinsertPOST_DATA_ACCESS: yes
PRE_DATA_ACCESS: yes
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
POST_DATA_ACCESS: yes
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
readByAlternateIDnsread Called to retrieve summary information about the product provider using the primary alternate ID as the key. 
readSummaryDetailsnsPRE_DATA_ACCESS: yes
 
Called to retrieve summary details, including name and address, for a product provider.SQL
searchProductsProvidednsmulti This readmulti will read all of the products provided by the providerSQL
searchByNextPmtDateRangeMOPnsmulti Operation to retrieve all rows from the ProductProvider entity that match the specified methodOfPmtCode and where the nextPaymentDate is within the specified date range.SQL
searchByNextPmtDateMOPnsmulti Operation to retrieve all ProductProvider records that match the specified methodOfPmtCode and where the nextPaymentDate is <= the input dateSQL
modifyNextPmtDatensmodifyOPTIMISTIC_LOCKING: yes
POST_DATA_ACCESS: yes
Operation to update the nextPaymentDate of a specific ProductProvider 
searchAllProductProvidersnsmultiPRE_DATA_ACCESS: yes
READMULTI_LIM: 0
 
Retrieves a summary record for each product provider. May return a very large number of records.SQL
searchForProviderAddressAndNamensmulti reads product provider name and address details by concern role ID.SQL
searchByNameOrAddressnsmultiPRE_DATA_ACCESS: yes
 
 SQL
search  @superseded - replaced by searchByNameOrAddress 
readMethodOfPmtCurrencynsread Reads the methodOfPmtCode and currencyType for a Product Provider. 
readSummaryDetailsByReferenceNumbernsmultiPRE_DATA_ACCESS: yes
READMULTI_LIM: 0
 
Method used to read product provider details based on alternate IDSQL
convertDetailsToUpper  Method to convert the product provider details to upper. 
readAllnkreadmulti Retrieves a list of all product providers.  
insertProductProviderinsert <p class="MsoNormal"> <span style="COLOR: #002060">Inserts product provider record. This method expects the concernRoleID to be set. It is preferred to call <font color="#000000">insertProductProvider</font> method only in scenarios where calling method wants to set the value of primary key by itself.</span> </p> 
searchByAlternateIDreadmulti Returns a list of Product Providers by primary alternate id. 
Related Pages (285)
Register Prospect (AddProspectPerson_registerForPDCWizard)
Register Prospect (AddProspectPerson_registerWizard)
Match Client (Application_matchClientConfirmation)
Add Client (Application_registerPersonAndAddAsClient)
Register Person (Application_registerProspectPersonAsPerson)
AssessmentDelivery_details
Register Person (BenefitSample_registerPerson)
Select Delivery Pattern (BenefitSample_selectDeliveryPattern)
Sample Benefit Overpayment Evidence (BenefitSampleOverpayment_viewEvidence)
Register Person and Create Case (Case_registerPersonAndCreateIntegratedCase)
Register Person and Create Case (Case_registerPersonAndCreateIntegratedCasePDC)
Register Prospect Person and Create a Case (Case_registerProspectPersonAndCreateIntegratedCase)
Register Prospect Person and Create an Integrated Case (Case_registerProspectPersonAndCreateIntegratedCasePDC)
- (CHIPDecision_context)
Add Member (CHIPProduct_addAssistanceGroupMember)
Confirm Benefit Group Member (CHIPProduct_confirmAddBenefitGroupMember)
Remove Member (CHIPProduct_removeAssistanceGroupMember)
Remove Member (CHIPProduct_removeBenefitGroupMember)
Submit Case For Approval (CHIPProductDelivery_submit)
Reception Contact (ClientContactWizard_issueDetails)
Add Client (CommonIntake_addClient)
CommonIntake_applicationCaseHomeContextPanel
Register Client (CommonIntake_registerClient)
Create Client Contact (Contact_register)
Create Client Contact (Contact_registerFromPersonSearch)
New Product Delivery (DefaultIC_createProductDelivery)
DefaultIC_tabDetails
DefaultIC_tabDetailsPreview
Select Delivery Pattern (DefaultICMember_selectDeliveryPattern)
- (DefaultICProduct_tabDetails)
DefaultICProduct_tabDetailsPreview
Integrated Case Product Provider Home (DefaultICProductProvider_home)
Program Summary (Eligibility_createProgram)
- (EmergencyMedicaidDecision_context)
- (ESIDecision_context)
New Absent Parent Evidence (EVD_addToCaseAbsentParentEvidence_sa)
New Household Member Evidence (EVD_createHouseholdMemberEvidence_sa)
Edit Absent Parent Evidence (EVD_incomingModifyAbsentParentEvidence)
Edit Absent Parent Evidence (EVD_modifyAbsentParentEvidence)
- (ExemptionDecision_context)
Edit Alternative Identifier (ExternalParty_modifyAlternateIDFromList)
Edit Alternative Identifier (ExternalParty_modifyAlternateIDFromView)
Regenerate Payment (ExternalParty_regeneratePayment)
Cancel Payment (Financial_cancelPayment)
Cancel Payment (Financial_cancelPayment1)
Cancel Issued Payment (Financial_cancelPaymentInstrument)
Reverse Instruction (Financial_createInstructionReversal)
Reverse Details (Financial_createLineItemReversal)
Refund Payment (Financial_createRefund)
Invalidate Payment (Financial_invalidatePayment)
Refund Payments (Financial_refundPayments)
Confirm & Reissue (Financial_regenerateAppliedFixedDeduction)
Regenerate Payment For New Nominee: (Financial_regenerateForNewNominee)
Regenerate Payment (Financial_regeneratePayment)
Reissue Payment (Financial_regeneratePayment1)
Reissue Payment Instrument (Financial_regeneratePaymentInstrument)
Reissue with Un-applied Deduction (Financial_regenerateUnappliedDeduction)
Add Member (HCRAddMemberWizard_summary)
Check Retroactive Medicaid Eligibility (HCRRetroactiveMedicaid_confirmCheckEligibilty)
Select Delivery Pattern (ICMember_selectDeliveryPattern)
Create Delivery (ICSample_createProductDelivery)
Integrated Case Product Provider Home (ICSample_productProviderHome)
Register Person (ICSample_registerPerson)
Select Delivery Pattern (ICSample_selectDeliveryPattern)
Register Person (IncomeScreening_registerHouseholdMember)
Register Prospect Person (IncomeScreening_registerHouseholdProspect)
Register Person (IncomeScreening_registerPerson)
Register Prospect Person (IncomeScreening_registerProspect)
Register Person (IncomeSupportScreening_registerPerson)
Register Person (IncomeSupportScreening_registerPersonForHouseholdEvidence)
Register Prospect (IncomeSupportScreening_registerProspect)
Register Prospect (IncomeSupportScreening_registerProspectForHouseholdEvidence)
Register Prospect Person as Person (Individual_registerProspectAsPerson)
- (InsuranceAssistanceDecision_context)
Related Persons (Intake_listRelatedPerson)
Register Person (Intake_personFullRegistration)
Person Search Results (Intake_personSearchResult)
Register Prospect Person as Person (Intake_registerProspectAsPerson)
Register Client for Intake (Intake_registerProspectPerson)
Register Prospect Person as Person (Intake_registerProspectPersonAsPerson)
Register Prospect Person (Intake_registerProspectPersons)
Register Prospect Person (Intake_registerProspectPersons_Reset)
Register Prospect Person (Intake_registerProspectPersons_Reset1)
Register Prospect Person (Intake_registerProspectPersons1)
Register Person (IntakeShortCuts_registerPerson)
Add Prospect Person (IntakeShortCuts_registerProspectPerson)
IntegratedCase_tabDetails
IntegratedCase_tabDetailsPreview
- (Investigation_homeTabDetails)
Investigation_homeTabDetailsPreview
Register Person (InvestigationSample_registerPerson)
Register Person (InvestigationSample_registerPersonForPDC)
Add Household Member (ISAddMemberWizard_summaryDetails)
Cancel Sanction (ISP_cancelSanctionEvidence)
Cancel Disregard (ISP_cancelSanctionOverride)
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)
Integrated Case Product Provider Home (ISP_productProviderHome)
Register Person (ISP_registerPerson)
Basic Intake Information (ISPIntakeInformation_createFromScreening)
Re-add a Member (ISReAddMemberWizard_submit)
Register Person (LiabilitySample_registerPerson)
Select Delivery Pattern (LiabilitySample_selectBillingPattern)
OutcomePlan_outcomePlanDetails
) (OutcomePlan_viewActionContextPanel)
) (OutcomePlan_viewExpectedOutcomeContextPanel)
) (OutcomePlan_viewFactorContextPanel)
) (OutcomePlanGoal_clientGoalContextPanelDetails)
) (OutcomePlanGoal_planGoalContextPanelDetails)
) (OutcomePlanReferral_viewContextPanel)
) (OutcomePlanService_viewContextPanel)
New Alternative Identifier (Participant_createAlternateID)
Reverse Line Item (Participant_createLineItemReversal)
Merge Duplicate (Participant_mergeAlternativeIDs)
Edit Alternative Identifier (Participant_modifyAlternateID)
Edit Alternative Identifier (Participant_modifyAlternateIDFromList)
Edit Alternative Identifier (Participant_modifyAlternateIDFromView)
- (Participant_regeneratePaymentInstrument)
Register Person (Person_register)
Register Person (Person_registerForPDC)
New Product (Product_benefitWizardSummary)
New Product (Product_benefitWizardSummary1)
New Product (Product_createProductProvisionForBenefitWizard)
New Product (Product_createProductProvisionForLiabilityWizard)
New Product (Product_createProvisionLocationForBenefitWizard)
New Product (Product_createProvisionLocationForLiabilityWizard)
Edit Product Provision (Product_modifyProductProvisionFromList)
Edit Product Provision (Product_modifyProductProvisionFromView)
New Product (Product_summaryForBenefitWizard)
New Product (Product_summaryForLiabilityWizard)
View Product Provision (Product_viewProductProvision)
New Fixed Deduction (ProductDelivery_createAppliedFixedDeduction)
New Applied Fixed Deduction (ProductDelivery_createAppliedFixedDeduction1)
New Applied Fixed Deduction (ProductDelivery_createAppliedFixedDeductionWizard)
New Variable Deduction (ProductDelivery_createAppliedVariableDeduction)
New Applied Variable Deduction (ProductDelivery_createAppliedVariableDeduction1)
New Applied Variable Deduction (ProductDelivery_createAppliedVariableDeductionWizard)
New Third Party Fixed Deduction (ProductDelivery_createThirdPartyFixedDeduction)
New Third Party Fixed Deduction (ProductDelivery_createThirdPartyFixedDeduction1)
New Third Party Variable Deduction (ProductDelivery_createThirdPartyVariableDeduction)
New Third Party Variable Deduction (ProductDelivery_createThirdPartyVariableDeduction1)
New Fixed Deduction (ProductDelivery_createUnappliedFixedDeduction)
New Un-applied Fixed Deduction (ProductDelivery_createUnappliedFixedDeduction1)
New Variable Deduction (ProductDelivery_createUnappliedVariableDeduction)
New Un-applied Variable Deduction (ProductDelivery_createUnappliedVariableDeduction1)
Set Default Nominee (ProductDelivery_setDefaultNominee)
Set Default Nominee (ProductDelivery_setDefaultNominee1)
Submit Case For Approval (ProductDelivery_submit)
- (ProductDelivery_tabDetails)
ProductDelivery_tabDetailsPreview
Delete Location (ProductProvider_cancelLocation)
New Product Contract (ProductProvider_createContract)
New Location (ProductProvider_createLocation)
Home (ProductProvider_home)
Product Contracts (ProductProvider_listContract)
Products (ProductProvider_listProduct)
Edit Product Contract (ProductProvider_modifyContractFromList)
Edit Product Contract (ProductProvider_modifyContractFromView)
Edit Location (ProductProvider_modifyLocationFromList)
Edit Location (ProductProvider_modifyLocationFromView)
Edit Product Provider (ProductProvider_modifyProductProvider)
Register Product Provider (ProductProvider_register)
Register Prospect (Prospect_register)
Confirm Registration (Prospect_registerPersonFromProspect)
Register Employer (ProspectEmployer_duplicateCheckWizard)
Register Prospect Person (ProspectPerson_register)
Register Prospect Person as Person (ProspectPerson_registerAsPerson)
Register Prospect Person as Person (ProspectPerson_registerAsPersonForPDCWizard)
Register Prospect Person as Person (ProspectPerson_registerAsPersonWizard)
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 Applied Deduction (ProviderManagement_createAppliedVariableDeduction)
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 Third Party Deduction (ProviderManagement_createThirdPartyVariableDeduction)
New Training Service (ProviderManagement_createTrainingServiceOffering)
New Un-Applied Deduction (ProviderManagement_createUnappliedVariableDeduction)
New Utilization Contract (ProviderManagement_createUtilizationContractForProvider)
New Rate (ProviderManagement_createUtilizationContractProviderOfferingRate)
Step 5: Register Person (ProviderManagement_duplicateRegisterPersonAsProvider)
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)
Select Provider Payment Type (ProviderManagement_modifyPaymentType)
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)
Step 5: Register Person (ProviderManagement_registerPersonAsProvider)
Register As Person (ProviderManagement_registerProviderAsPersonFrmProviderHome)
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)
- (ProviderManagement_viewProviderInvestigationTabDetails)
) (ProviderManagement_viewReferralSummaryDetails)
) (ProviderManagement_viewServiceSummaryDetails)
Quick Registration (Quick_register)
Register Person (RegisterPerson_registerForPDCWizard)
Register Person (RegisterPerson_registerWizard)
Register Product Provider (RegisterProductProvider_registerWizard)
Application (RightsAndResponsibilitiesForCase)
Application (RightsAndResponsibilitiesForCaseSubmit)
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 Service Contract (ServiceSupplier_createContract)
Contracts (ServiceSupplier_listContract)
Edit Service Contract (ServiceSupplier_modifyContractFromList)
Edit Service Contract (ServiceSupplier_modifyContractFromView)
- (StateBasicPlanDecision_context)
- (StreamlineMedicaidDecision_context)
Submit Case For Approval (TBBCCProductDelivery_submit)
- (UQHPDecision_context)
New Product (Wizard_benefitSummary)
New Product (Wizard_liabilitySummary)
New Product (Wizard_productProvisionForBenefit)
New Product (Wizard_productProvisionForLiability)
New Product (Wizard_provisionLocationForBenefit)
New Product (Wizard_provisionLocationForLiability)