USP_DATAFORMTEMPLATE_VIEW_FAFEVENTBATCH_CONTACT

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TITLECODEID	uniqueidentifier	INOUT
@FIRSTNAME	nvarchar(50)	INOUT
@NICKNAME	nvarchar(50)	INOUT
@MIDDLENAME	nvarchar(50)	INOUT
@MAIDENNAME	nvarchar(100)	INOUT
@KEYNAME	nvarchar(100)	INOUT
@SUFFIXCODEID	uniqueidentifier	INOUT
@GENDERCODE	tinyint	INOUT
@BIRTHDATE	UDT_FUZZYDATE	INOUT
@LOOKUP_ID	nvarchar(100)	INOUT
@EMAILADDRESS	UDT_EMAILADDRESS	INOUT

Definition

Copy


create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_FAFEVENTBATCH_CONTACT
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TITLECODEID uniqueidentifier = null output,
    @FIRSTNAME nvarchar(50) = null output,
    @NICKNAME nvarchar(50) = null output,
    @MIDDLENAME nvarchar(50) = null output,
    @MAIDENNAME nvarchar(100) = null output,
    @KEYNAME nvarchar(100) = null output,
    @SUFFIXCODEID uniqueidentifier = null output,
    @GENDERCODE tinyint = null output,
    @BIRTHDATE dbo.UDT_FUZZYDATE = null output,
    @LOOKUP_ID nvarchar(100) = null output,
  @EMAILADDRESS UDT_EMAILADDRESS = null output
)
as
    set nocount on;

    -- be sure to set this, in case the select returns no rows
    set @DATALOADED = 0;

    -- populate the output parameters, which correspond to fields on the form.  Note that
    -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system
    -- will display a "no data loaded" message.
  select 
    @DATALOADED = 1,
    @TITLECODEID = C.TITLECODEID,
    @FIRSTNAME = C.FIRSTNAME,
    @NICKNAME = C.NICKNAME,
    @MIDDLENAME = C.MIDDLENAME,
    @MAIDENNAME = C.MAIDENNAME,
    @KEYNAME = C.KEYNAME,
    @SUFFIXCODEID = C.SUFFIXCODEID,
    @GENDERCODE = C.GENDERCODE,
    @BIRTHDATE = C.BIRTHDATE,
    @LOOKUP_ID = C.LOOKUPID,
    @EMAILADDRESS = EA.EMAILADDRESS
  from dbo.CONSTITUENT C
  left join EMAILADDRESS EA on C.ID = EA.CONSTITUENTID and EA.ISPRIMARY=1
  where C.ID = @ID

  return 0;