USP_DATAFORMTEMPLATE_VIEW_DEMOGRAPHIC_EDUCATION

The load procedure used by the view dataform template "Education Demographic 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.
@ETHNICITY	nvarchar(100)	INOUT	Ethnicity
@RELIGION	nvarchar(100)	INOUT	Religion
@BIRTHPLACE	nvarchar(50)	INOUT	Birthplace
@DENOMINATION	nvarchar(100)	INOUT	Denomination
@CHURCHAFFILIATION	nvarchar(100)	INOUT	Church affiliation
@ISHISPANICLATINO	bit	INOUT	Is Hispanic/Latino

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DEMOGRAPHIC_EDUCATION
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,        
    @ETHNICITY nvarchar(100) = null output,
    @RELIGION nvarchar(100) = null output,
    @BIRTHPLACE nvarchar(50) = null output,
    @DENOMINATION nvarchar(100) = null output,
    @CHURCHAFFILIATION nvarchar(100) = null output,
    @ISHISPANICLATINO bit = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select 
        @DATALOADED = 1,

        @ETHNICITY = (select stuff((select '; ' + ETHNICITYCODE.DESCRIPTION
                                    from 
                                        dbo.DEMOGRAPHICETHNICITY
                                        join dbo.ETHNICITYCODE on ETHNICITYCODE.ID = DEMOGRAPHICETHNICITY.ETHNICITYCODEID
                                    where 
                                        DEMOGRAPHICETHNICITY.DEMOGRAPHICID = @ID
                                    order by ETHNICITYCODE.DESCRIPTION
                      for xml path(''), type).value('.', 'nvarchar(max)'), 1, 2, '')),

        @RELIGION = dbo.UFN_RELIGIONCODE_GETDESCRIPTION(D.RELIGIONCODEID),
        @BIRTHPLACE = D.BIRTHPLACE,
        @DENOMINATION = dbo.UFN_DENOMINATIONCODE_GETDESCRIPTION(D.DENOMINATIONCODEID),
        @CHURCHAFFILIATION = dbo.UFN_CHURCHAFFILIATIONCODE_GETDESCRIPTION(D.CHURCHAFFILIATIONCODEID),
        @ISHISPANICLATINO = D.ISHISPANICLATINO
    from dbo.CONSTITUENT C
        left outer join dbo.DEMOGRAPHIC D with (nolock) on D.ID = C.ID
        left outer join dbo.GROUPDATA GD with (nolock) on GD.ID = C.ID
    where 
        C.ID = @ID 

    return 0;