UFN_PROGRAMGLMAPPING_GETMAPPING

            CREATE function dbo.UFN_PROGRAMGLMAPPING_GETMAPPING(@CURRENTAPPUSERID uniqueidentifier = null) 
            returns table
            as return
                select 
                    row_number() over (order by PROGRAM.NAME) as ROWNUMBER,
                    PROGRAM.ID,
                    PROGRAM.NAME as Program,
                    MAP.ACCOUNTNUMBER,
                    MAP.PROJECTCODE
                from dbo.PROGRAM
                left join dbo.PROGRAMGLMAPPING as MAP on PROGRAM.ID = MAP.ID;