USP_DATAFORMTEMPLATE_VIEW_GRANTORSUMMARY

create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_GRANTORSUMMARY
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @GRANTORTYPE nvarchar(250) = null output,
    @GRANTORCONTACT nvarchar(700) = null output
)
as
    set nocount on;
    set @DATALOADED = 0;

    --Grantor information
    select
        @DATALOADED = 1,
        @GRANTORTYPE = dbo.UFN_GRANTORTYPECODE_GETDESCRIPTION(GRANTOR.GRANTORTYPECODEID),
        @GRANTORCONTACT = isnull(NF.NAME, '')
    from
        dbo.GRANTOR
        left join dbo.RELATIONSHIP on RELATIONSHIP.ID = GRANTOR.CONTACTID
        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(RELATIONSHIP.RECIPROCALCONSTITUENTID) NF
    where
        GRANTOR.ID = @ID;
        return 0;