USP_DATAFORMTEMPLATE_VIEW_INDIVIDUALBIOGRAPHICAL

The load procedure used by the view dataform template "Individual Biographical View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@NICKNAME	nvarchar(50)	INOUT	Nickname
@MAIDENNAME	nvarchar(100)	INOUT	Maiden name
@GENDER	nvarchar(100)	INOUT	Gender
@BIRTHDATE	UDT_FUZZYDATE	INOUT	Birth date
@AGE	int	INOUT	Age
@DECEASED	bit	INOUT	Deceased
@DECEASEDDATE	UDT_FUZZYDATE	INOUT	Deceased date
@GIVESANONYMOUSLY	bit	INOUT	Gives anonymously
@WEBADDRESS	UDT_WEBADDRESS	INOUT	Website
@MARITALSTATUS	nvarchar(50)	INOUT	Marital status
@JOBTITLE	nvarchar(100)	INOUT	Job title
@TITLECODE	nvarchar(100)	INOUT	Title
@TITLE2CODE	nvarchar(100)	INOUT	Title 2
@SUFFIXCODE	nvarchar(100)	INOUT	Suffix
@SUFFIX2CODE	nvarchar(100)	INOUT	Suffix 2
@KEYNAME	nvarchar(100)	INOUT
@FIRSTNAME	nvarchar(50)	INOUT
@MIDDLENAME	nvarchar(50)	INOUT
@CONSTITUENTIMAGE	varbinary	INOUT
@GENDERCODE	tinyint	INOUT
@GENDERCODE2	nvarchar(100)	INOUT

Definition

Copy


            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_INDIVIDUALBIOGRAPHICAL(
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 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,
                    @KEYNAME nvarchar(100) = null output,
                    @FIRSTNAME nvarchar(50) = null output,
                    @MIDDLENAME nvarchar(50) = null output,
                    @CONSTITUENTIMAGE varbinary(max) = null output,
                    @GENDERCODE tinyint = null output,
                    @GENDERCODE2 nvarchar(100) = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;

                    select 
                        @DATALOADED = 1,
                        @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)),
                        @KEYNAME = CONSTITUENT.KEYNAME,
                        @FIRSTNAME = CONSTITUENT.FIRSTNAME,
                        @MIDDLENAME = CONSTITUENT.MIDDLENAME,
                        @CONSTITUENTIMAGE = CONSTITUENT.PICTURETHUMBNAIL,
                        @GENDERCODE = CONSTITUENT.GENDERCODE,
                        @GENDERCODE2 = (select dbo.UFN_GENDERCODE_GETDESCRIPTION(CONSTITUENT.GENDERCODEID))
                    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;