BEH_MERGE_PROVIDER

Overview

The SPROC is set up to run as a Store Procedure Behavior. It allows a workflow behavior to call the https://heuristicsolutions.atlassian.net/wiki/spaces/DOCS/pages/1501561337/LB+MERGE+PROVIDER stored procedure to merge two providers. This SPROC performs translates and validates the data provided via the workflow behavior.

Business Rules

This SPROC does the following:

• Identifies the MEMBER_ID of the Persistent Member in the Merge based on the workflow from which the behavior was called.

• Identifies the MEMBER_ROLE_ID of the Persistent Member in the Merge based on the workflow from which the behavior was called.

• Identifies the MEMBER_ID of the Merge Member in the Merge based on matching the value of the Source Attribute ID to that of a Member Role Unique ID

• Identifies the MEMBER_ROLE_ID of the Merge Member in the Merge based on matching the value of the Source Attribute ID to that of a Member Role Unique ID

• Identifies the Member Role Attribute that is named “Merge Message”

• Confirms the Merge member does not have more than one role other than the ORG_STAFF_ROLE (Role = 4)

  • Otherwise, sets the “Merge Message” attribute to 'Dupe Member has other roles'

• Confirms the Merge member does not have any Learning Plan Instances

  • Otherwise, sets the “Merge Message” attribute to 'Dupe Member has learning plan(s) - must delete them first'

• Confirms the Merge member has an ALTERNATE_NAME = 'Merge' (this is to double check that the users did not accidentally enter the wrong Unique ID for the Merge member since this process is not reversible)

  • Otherwise, sets the “Merge Message” attribute to 'Dupe Member does not have "Merge" in Alternate name'

• Confirms the Merge Member actually exists

  • Otherwise, sets the “Merge Message” attribute to 'Merge Provider ID not found'

• If there are no errors, it executes the LB_MERGE_PROVIDER stored procedure.

  • If successful, sets the “Merge Message” attribute to 'Merge was successful'

History