USP_DATALIST_PARTICIPANTROLE

CREATE procedure dbo.USP_DATALIST_PARTICIPANTROLE
(
        @CLIENTUSERSID int,
      @EVENTID uniqueidentifier
)with execute as caller
as
    set nocount on;

    DECLARE @CONSTITUENTID uniqueidentifier
    SET @CONSTITUENTID = dbo.UFN_CONSTITUENT_GET_BY_CLIENTUSERID(@CLIENTUSERSID)

    DECLARE 
        @IsIndependentHouseholdMember bit 
        ,@IsIndependentHouseholdLeader bit  
        ,@IsIndependentTeamMember bit  
        ,@IsIndependentTeamLeader bit   
        ,@IsCompanyHouseholdMember bit   
        ,@IsCompanyHouseholdLeader bit   
        ,@IsCompanyTeamHouseholdLeader bit   
        ,@IsCompanyTeamMember bit   
        ,@IsCompanyTeamLeader bit   
        ,@IsCompanyLeader bit   
    ,@IsCompanyTeamHouseholdMember bit
    ,@IsTeamHouseholdMember bit
    ,@IsTeamHouseholdLeader bit
    ,@IsCompanyIndividual bit
    ,@IsIndependentIndividual bit

    EXEC dbo.USP_FAF_REGISTRANT_ROLE
        @CONSTITUENTID = @CONSTITUENTID
        ,@EVENTID =@EVENTID
        ,@IsIndependentHouseholdMember  = @IsIndependentHouseholdMember OUTPUT
        ,@IsIndependentHouseholdLeader  = @IsIndependentHouseholdLeader OUTPUT
        ,@IsIndependentTeamMember  = @IsIndependentTeamMember OUTPUT
        ,@IsIndependentTeamLeader   = @IsIndependentTeamLeader OUTPUT
        ,@IsCompanyHouseholdMember   = @IsCompanyHouseholdMember OUTPUT
        ,@IsCompanyHouseholdLeader   = @IsCompanyHouseholdLeader OUTPUT
        ,@IsCompanyTeamHouseholdLeader   = @IsCompanyTeamHouseholdLeader OUTPUT
        ,@IsCompanyTeamMember   = @IsCompanyTeamMember OUTPUT
        ,@IsCompanyTeamLeader   = @IsCompanyTeamLeader OUTPUT
        ,@IsCompanyLeader   = @IsCompanyLeader OUTPUT
    ,@IsCompanyTeamHouseholdMember = @IsCompanyTeamHouseholdMember OUTPUT
    ,@IsTeamHouseholdMember = @IsTeamHouseholdMember OUTPUT
    ,@IsTeamHouseholdLeader = @IsTeamHouseholdLeader OUTPUT
    ,@IsCompanyIndividual = @IsCompanyIndividual OUTPUT
    ,@IsIndependentIndividual = @IsIndependentIndividual OUTPUT

    SELECT @IsIndependentHouseholdMember as ISINDEPENDENTHOUSEHOLDMEMBER,
      @IsIndependentHouseholdLeader as ISINDEPENDENTHOUSEHOLDLEADER,
      @IsIndependentTeamMember as ISINDEPENDENTTEAMMEMBER,
      @IsIndependentTeamLeader as ISINDEPENDENTTEAMLEADER,
      @IsCompanyHouseholdMember as ISCOMPANYHOUSEHOLDMEMBER,
      @IsCompanyHouseholdLeader as ISCOMPANYHOUSEHOLDLEADER,
      @IsCompanyTeamHouseholdLeader as ISCOMPANYTEAMHOUSEHOLDLEADER,
      @IsCompanyTeamMember as ISCOMPANYTEAMMEMBER,
      @IsCompanyTeamLeader as ISCOMPANYTEAMLEADER,
      @IsCompanyLeader as ISCOMPANYLEADER,
      @IsCompanyTeamHouseholdMember as ISCOMPANYTEAMHOUSEHOLDMEMBER,
      @IsTeamHouseholdMember as ISTEAMHOUSEHOLDMEMBER,
      @IsTeamHouseholdLeader as ISTEAMHOUSEHOLDLEADER,
      @IsCompanyIndividual as ISCOMPANYINDIVIDUAL,
      @IsIndependentIndividual as ISINDEPENDENTINDIVIDUAL