USP_DATALIST_CONSTIT_ASSIGNED_SECURITY_ATTRIBUTES

Returns all security attributes that have been assigned to a constituent.

Parameters

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

Definition

Copy



create procedure dbo.USP_DATALIST_CONSTIT_ASSIGNED_SECURITY_ATTRIBUTES
(
    @CONSTITUENTID uniqueidentifier
) as
    set nocount on;

    select
        CSAA.[ID],
        CSA.[NAME],
        CSA.[DESCRIPTION],
        CSA.[ID] AS [SECURITYATTRIBUTEID],
        CSAA.[DATECHANGED]
    from
        dbo.[CONSTIT_SECURITY_ATTRIBUTE_ASSIGNMENT] CSAA
    inner join
        dbo.[CONSTIT_SECURITY_ATTRIBUTE] CSA
    on
        CSA.[ID] = CSAA.[CONSTIT_SECURITY_ATTRIBUTEID]
    where
        CSAA.[CONSTITUENTID] = @CONSTITUENTID
    order by
        CSA.[NAME] asc;