Public Sector Service Provider and Referral Management

The Service Provider and Referral Management feature allows social service agencies to locate service providers and manage the referral process. Features include Service Provider Information Management, Service Provider Contract Management, Service Provider Transaction Management, Service Provider Portal, Service Provider Portal Resource and Inventory Control, Service Provider Locator, Service Provider Referral and Benefits Administration.

This ERD (see the following figure) illustrates that Service Providers can have a Profile, be the subject of Contracts and own Assets. Contracts consist of Contract Items for Products that are made into Asset instances. Benefit Plans with Benefit Plan Items can be associated with a Case. Benefit Plan Items are also associated with a Product and a Service Provider who provides the Benefit. A Benefit Plan is created under a Benefit Program that consists of Benefit Program Items. Each Benefit Plan Item is associated with a Product and can have one or more Orders (created as part of Referral) that are serviced by Service Providers and are composed of Order Items. Order Items are associated with the Product, which is also associated with the related Benefit Plan Item.

The following table lists the entities in this ERD and their corresponding tables.

Entity	Table
Asset	S_ASSET
Benefit Fund	S_BNFT_FUND
Benefit Plan	S_CASE_BNFTPLAN
Benefit Plan Item	S_BNFT_PLAN_ITM, S_BNFT_PLNIT_XA
Benefit Plan Item Payment	S_SRC_PAYMENT
Benefit Program	S_BNFT_PGM
Benefit Program Item	S_BNFT_PGM_ITEM
Case	S_CASE, S_CASE_PSX
Contract Header	S_DOC_AGREE
Contract Item	S_AGREE_ITEM
Internal Product or Service	S_PROD_INT
Order	S_ORDER, S_ORDER_PSX
Order Line Item	S_ORDER_ITEM
Other Organization	S_ORG_EXT, S_PARTY
Party	S_PARTY
Service Provider Profile	S_ORG_EXT_ATTR, S_ORG_EXT_LANG
Service Provider	S_ORG_EXT, S_ORG_EXT_PSX, S_PARTY