USP_DATALIST_TRAIT_CONDENSED

This datalist returns all traits for a volunteer.

Parameters

Parameter	Parameter Type	Mode	Description
@VOLUNTEERID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@TRAITTYPE	tinyint	IN	Type

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_TRAIT_CONDENSED (@VOLUNTEERID uniqueidentifier, @TRAITTYPE tinyint = null)
            as
                set nocount on;

                select 
                        ID,
                        TRAITTYPEID,
                        TRAITTYPE,
                        coalesce(ADMINISTRATIVE, SKILL, INTEREST, SPECIALNEED,CERTIFICATION,COURSE,LICENSE,MEDICAL),
                        coalesce(CERTIFICATE,LICENSENUMBER),
                        SKILLLEVEL,
                        EXPIRESON,
                        VERIFIED,
                        VERIFIED
                from dbo.UFN_VOLUNTEER_TRAITS(@VOLUNTEERID)
                where TRAITTYPEID = coalesce(@TRAITTYPE, TRAITTYPEID)
                order by TRAITTYPE, ADMINISTRATIVE, SKILL, INTEREST, SPECIALNEED,CERTIFICATION,COURSE,LICENSE,MEDICAL