USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTSUMMARYORGANIZATIONINFOTILE

CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTSUMMARYORGANIZATIONINFOTILE
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @CONSTITUENTIMAGE varbinary(max) = null output,
    @INDUSTRY nvarchar(100) = null output,
    @NUMEMPLOYEES int = null output,
    @NUMSUBSIDIARIES int = null output,
  @PARENTORGANIZATIONNAME nvarchar(100) = null output,
  @PARENTORGANIZATIONID uniqueidentifier = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select 
        @DATALOADED = 1,
        @INDUSTRY = dbo.UFN_INDUSTRYCODE_GETDESCRIPTION(ORGANIZATIONDATA.INDUSTRYCODEID),
        @NUMEMPLOYEES = coalesce(ORGANIZATIONDATA.NUMEMPLOYEES,0),
        @NUMSUBSIDIARIES = coalesce(ORGANIZATIONDATA.NUMSUBSIDIARIES,0),
        @CONSTITUENTIMAGE = CONSTITUENT.PICTURETHUMBNAIL,
    @PARENTORGANIZATIONID = ORGANIZATIONDATA.PARENTCORPID
    from 
        dbo.CONSTITUENT
        left join dbo.ORGANIZATIONDATA on CONSTITUENT.ID = ORGANIZATIONDATA.ID
    where 
        CONSTITUENT.ID = @ID
        and CONSTITUENT.ISORGANIZATION = 1;

  -- Get the name of the parent organization

  select
    @PARENTORGANIZATIONNAME = CONSTITUENT.KEYNAME
  from
    dbo.CONSTITUENT
  where
    CONSTITUENT.ID = @PARENTORGANIZATIONID;

    return 0;