USP_DATAFORMTEMPLATE_VIEW_INDIVIDUALBIOGRAPHICAL2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@KEYNAME	nvarchar(100)	INOUT
@FIRSTNAME	nvarchar(100)	INOUT
@MIDDLENAME	nvarchar(100)	INOUT
@NICKNAME	nvarchar(50)	INOUT
@MAIDENNAME	nvarchar(100)	INOUT
@GENDER	nvarchar(100)	INOUT
@BIRTHDATE	UDT_FUZZYDATE	INOUT
@AGE	int	INOUT
@DECEASED	bit	INOUT
@DECEASEDDATE	UDT_FUZZYDATE	INOUT
@GIVESANONYMOUSLY	bit	INOUT
@WEBADDRESS	UDT_WEBADDRESS	INOUT
@MARITALSTATUS	nvarchar(50)	INOUT
@JOBTITLE	nvarchar(100)	INOUT
@TITLECODE	nvarchar(100)	INOUT
@TITLE2CODE	nvarchar(100)	INOUT
@SUFFIXCODE	nvarchar(100)	INOUT
@SUFFIX2CODE	nvarchar(100)	INOUT

Definition

Copy


            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_INDIVIDUALBIOGRAPHICAL2(
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,        
                    @KEYNAME nvarchar(100) = null output,
                    @FIRSTNAME nvarchar(100) = null output,
                    @MIDDLENAME nvarchar(100) = null output,
                    @NICKNAME nvarchar(50) = null output,
                    @MAIDENNAME nvarchar(100) = null output,
                    @GENDER nvarchar(100) = null output,
                    @BIRTHDATE dbo.UDT_FUZZYDATE = null output,
                    @AGE int = null output,
                    @DECEASED bit = null output,
                    @DECEASEDDATE dbo.UDT_FUZZYDATE = null output,
                    @GIVESANONYMOUSLY bit = null output,
                    @WEBADDRESS dbo.UDT_WEBADDRESS = null output,
                    @MARITALSTATUS nvarchar(50) = null output,
                    @JOBTITLE nvarchar(100) = null output,
                    @TITLECODE nvarchar(100) = null output,
                    @TITLE2CODE nvarchar(100) = null output,
                    @SUFFIXCODE nvarchar(100) = null output,
                    @SUFFIX2CODE nvarchar(100) = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;

                    select 
                        @DATALOADED = 1,
                        @KEYNAME = CONSTITUENT.KEYNAME,
                        @FIRSTNAME = CONSTITUENT.FIRSTNAME,
                        @MIDDLENAME = CONSTITUENT.MIDDLENAME,
                        @NICKNAME = CONSTITUENT.NICKNAME,
                        @MAIDENNAME = CONSTITUENT.MAIDENNAME,
                        @GENDER = CONSTITUENT.GENDER,
                        @BIRTHDATE = CONSTITUENT.BIRTHDATE,
                        @AGE = case when DECEASEDCONSTITUENT.ID is null then CONSTITUENT.AGE else null end,
                        @DECEASEDDATE = DECEASEDCONSTITUENT.DECEASEDDATE,
                        @DECEASED = case when DECEASEDCONSTITUENT.ID is null then 0 else 1 end,
                        @GIVESANONYMOUSLY = CONSTITUENT.GIVESANONYMOUSLY,
                        @WEBADDRESS = CONSTITUENT.WEBADDRESS,
                        @MARITALSTATUS = dbo.UFN_MARITALSTATUSCODE_GETDESCRIPTION(MARITALSTATUSCODEID),
                        @JOBTITLE = CONSTITUENTJOBINFO.JOBTITLE,
                        @TITLECODE = (select dbo.UFN_TITLECODE_GETDESCRIPTION(TITLECODEID)),
                        @TITLE2CODE = (select dbo.UFN_TITLECODE_GETDESCRIPTION(TITLE2CODEID)),
                        @SUFFIXCODE = (select dbo.UFN_SUFFIXCODE_GETDESCRIPTION(SUFFIXCODEID)),
                        @SUFFIX2CODE = (select dbo.UFN_SUFFIXCODE_GETDESCRIPTION(SUFFIX2CODEID))
                    from dbo.CONSTITUENT
                        left outer join dbo.CONSTITUENTJOBINFO on CONSTITUENTJOBINFO.ID = CONSTITUENT.ID
                        left outer join dbo.DECEASEDCONSTITUENT on DECEASEDCONSTITUENT.ID = CONSTITUENT.ID
                    where 
                        CONSTITUENT.ID = @ID and
                        ISORGANIZATION = 0 and
                        ISGROUP = 0;

                        return 0;