USP_DATALIST_CONSTIT_SECURITY_ATTRIBUTES

This datalist returns all constituent security attributes in the system.
Definition



                    create procedure dbo.USP_DATALIST_CONSTIT_SECURITY_ATTRIBUTES
                    as
                        set nocount on;

                        select
                            CSA.[ID],
                            CSA.[NAME],
                            CSA.[DESCRIPTION],
                            CSA.[DATEADDED],
                            CSA.[DATECHANGED],
                            ADDEDBY.[USERNAME],
                            CHANGEDBY.[USERNAME]
                        from
                            dbo.[CONSTIT_SECURITY_ATTRIBUTE] CSA
                        left join
                            dbo.[CHANGEAGENT] ADDEDBY
                        on
                            CSA.ADDEDBYID = ADDEDBY.ID
                        left join
                            dbo.[CHANGEAGENT] CHANGEDBY
                        on
                            CSA.CHANGEDBYID = CHANGEDBY.ID
                        order by
                            CSA.NAME asc