UFN_CONSTITUENT_GETETHNICITIES

This function returns an individuals ethnicities.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@DEMOGRAPHICID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_CONSTITUENT_GETETHNICITIES(@DEMOGRAPHICID uniqueidentifier)
returns table
as return

    select 
        ID,
        ETHNICITYCODEID
    from 
        dbo.DEMOGRAPHICETHNICITY
    where
        DEMOGRAPHICID = @DEMOGRAPHICID;