USP_DATAFORMTEMPLATE_VIEW_STUDENTBIOGRAPHICAL

The load procedure used by the view dataform template "Student 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
@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
@WEBADDRESS	UDT_WEBADDRESS	INOUT	Website

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_STUDENTBIOGRAPHICAL(
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,        
                    @NICKNAME nvarchar(50) = 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,
                    @WEBADDRESS dbo.UDT_WEBADDRESS = null output
          )
                as
                    set nocount on;

                    set @DATALOADED = 0;

                    select 
                        @DATALOADED = 1,
                        @NICKNAME = CONSTITUENT.NICKNAME,
                        @GENDER = CONSTITUENT.GENDER,
                        @BIRTHDATE = CONSTITUENT.BIRTHDATE,
                        @AGE =
                            case
                                when DECEASEDCONSTITUENT.ID is null then
                                    case
                                        when CONSTITUENT.AGE > 0 then CONSTITUENT.AGE
                                        else null
                                    end
                                else null
                            end,
                        @DECEASEDDATE = DECEASEDCONSTITUENT.DECEASEDDATE,
                        @DECEASED = case when DECEASEDCONSTITUENT.ID is null then 0 else 1 end,
                        @WEBADDRESS = CONSTITUENT.WEBADDRESS
                    from  dbo.CONSTITUENT
                        inner join STUDENT on CONSTITUENT.ID = STUDENT.ID
                        left outer join dbo.DECEASEDCONSTITUENT on DECEASEDCONSTITUENT.ID = CONSTITUENT.ID
                        where 
                                    CONSTITUENT.ID = @ID and
                        ISORGANIZATION = 0 and
                        ISGROUP = 0;

                            return 0;

              --,@STUDENTID nvarchar(50) = null output

              --,@STUDENTID = STUDENT.STUDENTID