Table Description
Referral Role: An association between a referral and one of the following: a service, a provider, a provider representative, a user specified service, client or attachment.

When a referral is created the service that the client is being referred for can be selected from the CPM services registry or a case worker can specify the name of a service. A provider can be specified for a referral and can be selected from a CPM provider or a case worker can specify a provider. When a case worker specifies a provider, the provider is stored as a provider representative. This entity is used to store the associations of these items with the referral.

Example

A case worker assesses James Smith's strengths and needs and identifies that he has mental health issues. To address these issues the case worker creates an outcome plan to address these issues. A referral is created to refer James for a Psychiatric Assessment. This entity is used to link the client and the service to the referral entity.
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::CPM::Service Layer::Referral::Entity::ReferralRole
Controlling File: CPM\model\Packages\Service Layer\Referral\Referral.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
referralRoleIDkeynoUnique identifier for a referral role record.REFERRAL_ROLE_ID SVR_INT64
relatedObjectIDdetailsyesUnique reference number of the object with which the referral is associated. This id is used in conjunction with the relatedObjectType for lookup.INTERNAL_ID SVR_INT64
relatedObjectTypedetailsnoType of object the referral is related to. This is used for lookup in conjunction with relatedObjectID.REFERRAL_OBJECT_ROLE_TYPEReferralRelatedRoleTypeSVR_STRING<10>
recordStatusdetailsnoStatus of the referral role record. Values include 'Active' or 'Canceled'. Logical deletion is supportedRECORD_STATUS_CODERecordStatusSVR_STRING<10>
referralIDdetailsnoUnique identifier of the related referral with which the referral link is associated.INTERNAL_ID SVR_INT64
relatedObjectNamedetails The name of the object with which the referral is associated. This name is used in conjunction with the relatedObjectType for lookup.REFERRAL_OBJECT_NAME SVR_STRING<100>
Foreign Keys (1)
ChildParent
ReferralRole.referralIDReferral.referralID
Indices (2)
Index NameAttributes
ReferalRoleRelatedObjectIDIdxrelatedObjectID
ReferralRoleReferralIDIdxreferralID
Operations (8)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: referralRoleID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByReferralRelatedObjectTypeAndStatusreadmulti Retrieves all referral role records related to a referral based on the type of referral role record and its status. 
searchByReferralAndStatusreadmulti Retrieves all referral role records related to a referral based on the passed in record status. 
readByReferralRelatedObjectTypeAndStatusnsread Reads a referral role record related to a referral based on the type of referral link record and record status. 
readByReferralRelatedObjectIDTypeAndStatusnsread Retrieves the referral role record that is related to the passed in referral, related object identifier, type and record status. 
searchByRelatedObjectTypeAndStatusreadmulti   
Related Pages (42)
Activities (OutcomePlan_listReferrals)
Referral Details (OutcomePlan_viewReferralDetails)
OutcomePlan_viewReferralDetailsPreviewPanel
New Referral (OutcomePlanCollaborationPreselectedReferralWizard_details)
New Referral: (OutcomePlanCollaborationPreselectedReferralWizard_factors)
New Referral (OutcomePlanCollaborationPreselectedReferralWizard_notification)
OutcomePlanCollaborationPreselectedReferralWizard_provider
OutcomePlanCollaborationPreselectedReferralWizard_sharing
New Referral (OutcomePlanCollaborationReferralWizard_details)
New Referral (OutcomePlanCollaborationReferralWizard_factors)
New Referral (OutcomePlanCollaborationReferralWizard_notification)
OutcomePlanCollaborationReferralWizard_provider
New Referral (OutcomePlanCollaborationReferralWizard_service)
OutcomePlanCollaborationReferralWizard_sharing
New Referral (OutcomePlanPreselectedReferralWizard_details)
New Referral: (OutcomePlanPreselectedReferralWizard_factors)
New Referral (OutcomePlanPreselectedReferralWizard_notification)
OutcomePlanPreselectedReferralWizard_provider
) (OutcomePlanReferral_viewContextPanel)
Home (OutcomePlanReferral_viewReferral)
New Referral (OutcomePlanReferralWizard_details)
New Referral (OutcomePlanReferralWizard_factors)
New Referral (OutcomePlanReferralWizard_notification)
OutcomePlanReferralWizard_provider
New Referral (OutcomePlanReferralWizard_service)
Undo Provider Selection (ProviderManagement_confirmCancelReferralProvider)
New Attachment (ProviderManagement_createReferralAttachment)
Edit Referral (ProviderManagement_editReferralNotificationsNotSent)
Edit Referral (ProviderManagement_editReferralNotificationsSent)
ProviderManagement_listReferralAttachments
ProviderManagement_listReferralNotifications
Referrals (ProviderManagement_listReferrals)
New Referral (ProviderManagement_referralWizardAddDetails)
New Referral (ProviderManagement_referralWizardAddNotification)
ProviderManagement_referralWizardAddProvider
New Referral (ProviderManagement_referralWizardAddService)
ProviderManagement_referralWizardLinkAddProvider
ProviderManagement_specifyReferralProviderCPMService
ProviderManagement_specifyReferralProviderCPMServiceLink
Specify Provider (ProviderManagement_specifyReferralProviderUnregisteredService)
Home (ProviderManagement_viewReferral)
) (ProviderManagement_viewReferralSummaryDetails)