Table Description
Service Supplier: A type of participant that provides a service to the organization.
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::ServiceSupplier::ServiceSupplier
Controlling File: core\model\Packages\Concern\ServiceSupplier_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (11)
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 Service Supplier in their interaction with the Organization.SERVICE_SUPPLIER_NAME SVR_STRING<131>
statusCodedetails Code table code describing the record status of the service supplier record.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
commentsdetails Free text registered by the User.COMMENTS SVR_STRING<300>
primaryAlternateIDdetails The primary alternate reference number of this Service Supplier.ALTERNATE_ID SVR_STRING<18>
paymentFrequencydetailsyesThe frequency which the organization will calculate and make payments to the Service Supplier.FREQUENCY_PATTERN SVR_STRING<9>
methodOfPmtCodedetailsyesThe method of payment for this Service Supplier.METHOD_OF_DELIVERY_CODEMethodOfDeliverySVR_STRING<10>
nextPaymentDatedetailsyesThe next payment calculation date for this Service Supplier.CURAM_DATE SVR_DATE
currencyTypedetailsyesThe preferred currency for the Service Supplier.CURRENCY_CODECurrencySVR_STRING<10>
pinNumberdetailsyesService Supplier Personal Identification Number (PIN). This Personal Information Number allows them to identify themselves to a number of online Curam services.CUSTOMER_PIN_NUMBER SVR_STRING<4>
upperNamedetails The name of the Service Supplier stored in upper case format to facilitate Service Supplier search functionality in a case independent manner on the Service Supplier's name.SERVICE_SUPPLIER_NAME SVR_STRING<131>
Foreign Keys (5)
ChildParent
ServiceSupplier.concernRoleIDConcernRole.concernRoleID
CaseAppeal.serviceSupplierIDServiceSupplier.concernRoleID
CaseReferral.serviceSupplierIDServiceSupplier.concernRoleID
FSHouseholdExpenses.serviceSupplierIDServiceSupplier.concernRoleID
ServiceSupplierLink.supplierConcernRoleIDServiceSupplier.concernRoleID
Indices (2)
Index NameAttributes
SSnxtPmtDateMOPIdxnextPaymentDate, methodOfPmtCode
ServiceSupplierIndprimaryAlternateID
Operations (16)
OperationStereotypeOptionsDescriptionSQL
insertinsertPRE_DATA_ACCESS: yes
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
readByAlternateIDnsread Called to retrieve summary information about the service supplier using the primary alternate ID as the key. 
readSummaryDetailsnsPRE_DATA_ACCESS: yes
 
Called to retrieve a summary details record, containing name and address, for a service supplier.SQL
searchByServiceTypensmulti Returns a list of service suppliers matching the typeSQL
searchByNextPmtDateRangeMOPnsmulti Operation to retrieve all ServiceSupplier records that match the specified methodOfPmtCode and where the nextPaymentDate is within the specified date range.SQL
searchByNextPmtDateMOPnsmulti  Operation to retrieve all ServiceSupplier records that match the specified methodOfPmtCode and where the nextPaymentDate is <= the input dateSQL
modifyNextPmtDatensmodifyOPTIMISTIC_LOCKING: yes
Operation to update the nextPaymentdate of a specific serviceSupplier 
searchAllServiceSuppliersnsmultiPRE_DATA_ACCESS: yes
READMULTI_LIM: 0
 
Retrieves a summary record for each service supplier. May return a very large number of records.SQL
searchByNameOrAddressnsmultiPRE_DATA_ACCESS: yes
 
 SQL
search  @superseded - replaced by searchByNameOrAddress 
readMethodOfPmtCurrencynsread Reads the methodOfPmtCode and currencyType for a Service Supplier. 
readSummaryDetailsByReferenceNumbernsmultiPRE_DATA_ACCESS: yes
READMULTI_LIM: 0
 
Method to read service suppliers by alternate IDSQL
convertDetailsToUpper  Method to convert the service supplier details to upper. 
searchByAlternateIDreadmulti Returns a list of Service Suppliers by primary alternate id. 
Related Pages (290)
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)
Edit Referral (Case_modifyReferralFromList)
Edit Referral (Case_modifyReferralFromView)
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)
View Appeal (Case_viewAppealInline)
View Appeal (Case_viewAppealViewOnly)
View Referral (Case_viewReferral)
View Referral (Case_viewReferralViewOnly)
- (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)
- (DecisionAssistApplication_viewMemberHomeForDetermination)
- (DecisionAssistApplication_viewMemberHomeNoCOC)
- (DecisionAssistApplication_viewMemberHomeThirdParty)
- (DecisionAssistApplication_viewMemberHomeWithCOC)
New Product Delivery (DefaultIC_createProductDelivery)
DefaultIC_tabDetails
DefaultIC_tabDetailsPreview
Integrated Case Employer Home (DefaultICEmployer_homeTabDetails)
Integrated Case Information Provider Home (DefaultICInformationProvider_homeTabDetails)
Integrated Case Member Home (DefaultICMember_home)
Integrated Case Member Home (DefaultICMember_homeTabDetails)
Select Delivery Pattern (DefaultICMember_selectDeliveryPattern)
Select Provider & Location (DefaultICMember_selectProviderAndLocation)
- (DefaultICProduct_tabDetails)
DefaultICProduct_tabDetailsPreview
Integrated Case Product Provider Home (DefaultICProductProvider_homeTabDetails)
Integrated Case Member Home (DefaultICProspectPerson_homeTabDetails)
Integrated Case Representative Home (DefaultICRepresentative_homeTabDetails)
Integrated Case Service Supplier Home (DefaultICServiceSupplier_home)
Integrated Case Member Home (DefaultICServiceSupplier_homeTabDetails)
Integrated Case Utility Home (DefaultICUtility_homeTabDetails)
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)
Select Provider & Location (ICMember_selectProviderAndLocation)
Create Delivery (ICSample_createProductDelivery)
Integrated Case Member Home (ICSample_memberHome)
Integrated Case Member Home (ICSample_memberHomeTabDetails)
Register Person (ICSample_registerPerson)
Select Delivery Pattern (ICSample_selectDeliveryPattern)
Integrated Case Service Supplier Home (ICSample_serviceSupplierHome)
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)
Edit Referral (IntegratedCase_modifyReferralFromList)
Edit Referral (IntegratedCase_modifyReferralFromView)
IntegratedCase_tabDetails
IntegratedCase_tabDetailsPreview
View Referral (IntegratedCase_viewReferral)
- (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)
Integrated Case Member Home (ISP_memberHome)
Edit Sanction (ISP_modifySanctionEvidence_fromList)
Edit Sanction (ISP_modifySanctionEvidence_fromView)
Edit Disregard (ISP_modifySanctionOverride_fromList)
Modify Sanction Override Details: (ISP_modifySanctionOverride_fromView)
Register Person (ISP_registerPerson)
Integrated Case Service Supplier Home (ISP_serviceSupplierHome)
Basic Intake Information (ISPIntakeInformation_createFromScreening)
Re-add a Member (ISReAddMemberWizard_submit)
Create Issue (IssueDelivery_createIssue)
New Issue Case (IssueDelivery_createIssueForICWizard)
New Issue Case (IssueDelivery_createIssueForPDWizard)
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 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
New Product Contract (ProductProvider_createContract)
Edit Product Contract (ProductProvider_modifyContractFromList)
Edit Product Contract (ProductProvider_modifyContractFromView)
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 Service Supplier (RegisterServiceSupplier_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)
Home (ServiceSupplier_homePage)
Edit Service Contract (ServiceSupplier_modifyContractFromList)
Edit Service Contract (ServiceSupplier_modifyContractFromView)
Edit Service Supplier (ServiceSupplier_modifyServiceSupplier)
Register Service Supplier (ServiceSupplier_register)
- (StateBasicPlanDecision_context)
- (StreamlineMedicaidDecision_context)
Submit Case For Approval (TBBCCProductDelivery_submit)
- (UQHPDecision_context)