USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTACCOUNT

CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTACCOUNT
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @CONDITIONSETTINGNAME nvarchar(50) = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select
        @DATALOADED = 1,
        @CONDITIONSETTINGNAME = BANKINGSYSTEM.CONDITIONSETTINGNAME
    from
        dbo.CONSTITUENTACCOUNT
        inner join dbo.FINANCIALINSTITUTION on FINANCIALINSTITUTION.ID = CONSTITUENTACCOUNT.FINANCIALINSTITUTIONID
        left join dbo.BANKINGSYSTEM on BANKINGSYSTEM.ID = FINANCIALINSTITUTION.BANKINGSYSTEMID
    where
        CONSTITUENTACCOUNT.ID = @ID;

    -- This is used to pull the Banking System Type for uncommitted batches where the constituent account was created in-batch
    if @DATALOADED = 0
    begin
        select
            @DATALOADED = 1,
            @CONDITIONSETTINGNAME = BANKINGSYSTEM.CONDITIONSETTINGNAME
        from dbo.BATCHREVENUECONSTITUENTACCOUNT
            inner join dbo.FINANCIALINSTITUTION on FINANCIALINSTITUTION.ID = BATCHREVENUECONSTITUENTACCOUNT.FINANCIALINSTITUTIONID
            left join dbo.BANKINGSYSTEM on BANKINGSYSTEM.ID = FINANCIALINSTITUTION.BANKINGSYSTEMID
        where BATCHREVENUECONSTITUENTACCOUNT.ID = @ID;
    end

    -- This is used to pull the Banking System Type for uncommitted batches where the financial institution and constituent account were created in-batch
    if @DATALOADED = 0
    begin
        select
            @DATALOADED = 1,
            @CONDITIONSETTINGNAME = BANKINGSYSTEM.CONDITIONSETTINGNAME
        from dbo.BATCHREVENUECONSTITUENTACCOUNT
            inner join dbo.BATCHREVENUEFINANCIALINSTITUTION on BATCHREVENUEFINANCIALINSTITUTION.ID = BATCHREVENUECONSTITUENTACCOUNT.FINANCIALINSTITUTIONID
            left join dbo.BANKINGSYSTEM on BANKINGSYSTEM.ID = BATCHREVENUEFINANCIALINSTITUTION.BANKINGSYSTEMID
        where BATCHREVENUECONSTITUENTACCOUNT.ID = @ID;
    end

    return 0;