USP_DATALIST_DESIGNATIONLEVELRELATEDSTAFF

Displays a list of staff related to a fundraising purpose.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_DESIGNATIONLEVELRELATEDSTAFF(@CONTEXTID uniqueidentifier)
                as
                    set nocount on;

                    select 
                        DESIGNATIONLEVELRELATEDSTAFF.ID,
                        DESIGNATIONLEVELRELATEDSTAFF.CONSTITUENTID,
                        NF.NAME,
                        RELATEDSTAFFROLECODE.DESCRIPTION,
                        DESIGNATIONLEVELRELATEDSTAFF.STARTDATE,
                        DESIGNATIONLEVELRELATEDSTAFF.ENDDATE,
                        DESIGNATIONLEVELRELATEDSTAFF.COMMENTS
                    from 
                        dbo.DESIGNATIONLEVELRELATEDSTAFF
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(DESIGNATIONLEVELRELATEDSTAFF.CONSTITUENTID) NF
                    left join dbo.RELATEDSTAFFROLECODE on
                        DESIGNATIONLEVELRELATEDSTAFF.ROLECODEID = RELATEDSTAFFROLECODE.ID

                    where 
                        DESIGNATIONLEVELRELATEDSTAFF.DESIGNATIONLEVELID = @CONTEXTID