USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTMEMBERSHIPPROGRAMCARD

CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTMEMBERSHIPPROGRAMCARD]
(
  @ID nvarchar(72),
  @CURRENTAPPUSERID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @NAMEONCARD nvarchar(700) = null output
)
as
  begin
    set nocount on;

    declare @CONSTITUENTID uniqueidentifier;
    declare @MEMBERSHIPPROGRAMID uniqueidentifier;
    declare @FORMATID uniqueidentifier;

    set @CONSTITUENTID = substring(@ID, 1, 36);
    set @MEMBERSHIPPROGRAMID = substring(@ID, 37, 36);
    set @NAMEONCARD = '';

    select
      @DATALOADED = 1,
      @FORMATID = [ADDRESSEEFUNCTIONID]
    from dbo.[MEMBERSHIPPROGRAM]
    left outer join dbo.[NAMEFORMATPARAMETER] on [NAMEFORMATPARAMETER].[ID] = [MEMBERSHIPPROGRAM].[NAMEFORMATID]
    where [MEMBERSHIPPROGRAM].[ID] = @MEMBERSHIPPROGRAMID;

    if @FORMATID is null
      select @NAMEONCARD = [NAME] from dbo.[UFN_CONSTITUENT_DISPLAYNAME](@CONSTITUENTID);
    else
      set @NAMEONCARD = dbo.[UFN_NAMEFORMAT_FROMID_INTERNAL](@FORMATID, @CONSTITUENTID, 0);

    return 0;
  end