USP_DATALIST_CONSTITUENTPROFILEDASHBOARDVOLUNTEERTRAITS

Returns volunteer traits for the constituent profile.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Constituent ID
@ISVISIBLE	bit	IN	Is visible

Definition

Copy



                    CREATE procedure dbo.USP_DATALIST_CONSTITUENTPROFILEDASHBOARDVOLUNTEERTRAITS
                    (
                        @CONSTITUENTID uniqueidentifier,
                        @ISVISIBLE bit = 1
                    )
                    as
                        set nocount on;

                        if @ISVISIBLE = 1
                        begin
                            select
                                    TRAITTYPE,
                                    coalesce(ADMINISTRATIVE, SKILL, INTEREST, SPECIALNEED,CERTIFICATION,COURSE,LICENSE,MEDICAL) as DESCRIPTION,
                                    coalesce(CERTIFICATE,LICENSENUMBER) as NUMBER,
                                    SKILLLEVEL,
                                    EXPIRESON,
                                    VERIFIED
                            from dbo.UFN_VOLUNTEER_TRAITS(@CONSTITUENTID)
                            order by TRAITTYPE, ADMINISTRATIVE, SKILL, INTEREST, SPECIALNEED,CERTIFICATION,COURSE,LICENSE,MEDICAL
                        end