USP_RECORDOPERATION_DELETEGROUPORGSTEP

Provides the prompt for the "Group or Organization Stewardship Plan Step Delete" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Represents information to be displayed in the record operation prompt.
@GROUPORGNAME	nvarchar(154)	INOUT
@CONTACTSNAME	nvarchar(154)	INOUT

Definition

Copy



CREATE procedure dbo.USP_RECORDOPERATION_DELETEGROUPORGSTEP
(
    @ID uniqueidentifier,
    @GROUPORGNAME nvarchar(154) output,
    @CONTACTSNAME nvarchar(154) output
)
as 
    set nocount on;

    select
        @GROUPORGNAME = STEPOWNER.NAME,
        @CONTACTSNAME = NF.NAME
    from dbo.STEWARDSHIPPLANSTEP STEP
    inner join dbo.STEWARDSHIPPLAN [PLAN]
      on STEP.PLANID = [PLAN].ID
    inner join dbo.CONSTITUENT STEPOWNER
        on [PLAN].CONSTITUENTID = STEPOWNER.ID
    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(STEP.CONTACTPERSONID) NF

    where STEP.ID = @ID