USP_DATAFORMTEMPLATE_VIEW_SYSTEMROLE_CONSTIT_SECURITY_ATTRIBUTE

The load procedure used by the view dataform template "System Role Constituent Security View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@CONSTIT_SECURITY_RINGFENCEID	uniqueidentifier	INOUT	Ring fence ID
@CONSTIT_SECURITY_RINGFENCENAME	nvarchar(100)	INOUT	Group
@CONSTIT_SECURITY_RINGFENCEDESCRIPTION	nvarchar(255)	INOUT	Description
@HASRINGFENCEID	bit	INOUT	Has Security Group
@RECORDSECURITYMODE	bit	INOUT	Record Security Mode

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_SYSTEMROLE_CONSTIT_SECURITY_ATTRIBUTE
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @CONSTIT_SECURITY_RINGFENCEID uniqueidentifier = null output,
    @CONSTIT_SECURITY_RINGFENCENAME nvarchar(100) = null output,
    @CONSTIT_SECURITY_RINGFENCEDESCRIPTION nvarchar(255) = null output,
    @HASRINGFENCEID bit = null output,
    @RECORDSECURITYMODE bit = null output

) as
    set nocount on;

    set @DATALOADED = 0

    select
        @DATALOADED = 1,
        @CONSTIT_SECURITY_RINGFENCEID = CSR.[ID],
        @CONSTIT_SECURITY_RINGFENCENAME = case when CSR.[NAME] is null then '<none>' else CSR.[NAME] end,
        @CONSTIT_SECURITY_RINGFENCEDESCRIPTION = CSR.[DESCRIPTION],
        @HASRINGFENCEID = case when CSR.[ID] is null then 0 else 1 end,
        @RECORDSECURITYMODE=RECORDSECURITYMODE
    from
        dbo.[SYSTEMROLE] SR
    left join
        dbo.[SYSTEMROLE_CONSTIT_SECURITY_ATTRIBUTE] SRCSR
    on
        SRCSR.[ID] = SR.[ID]
    left join
        dbo.[CONSTIT_SECURITY_ATTRIBUTE] CSR
    on
        CSR.[ID] = SRCSR.[CONSTIT_SECURITY_ATTRIBUTEID]
    where
        SR.[ID] = @ID;

    return 0;