USP_RECORDOPERATION_ORGANIZATIONPOSITIONHOLDERDELETEPROMPT

Provides the prompt for the "Organization Position Holder: Delete" record operation.

Parameters

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

Definition

Copy



                    create procedure dbo.USP_RECORDOPERATION_ORGANIZATIONPOSITIONHOLDERDELETEPROMPT
                    (
                        @ID uniqueidentifier,
                        @NAME nvarchar(100) output
                    )
                    as
                        set nocount on;

                        declare @DATETO datetime;

                        select top 1
                            @NAME = CONSTITUENT.NAME,
                            @DATETO = DATETO
                        from dbo.ORGANIZATIONPOSITIONHOLDER
                        inner join dbo.CONSTITUENT
                            on ORGANIZATIONPOSITIONHOLDER.CONSTITUENTID = CONSTITUENT.ID
                        where POSITIONID = @ID
                        order by DATEFROM desc;

                        if @DATETO is not null
                              set @NAME = '<Vacant>';

                        return 0;