USP_MKTRECORDSOURCE_GETMATCHBACKFIELDS

create procedure dbo.[USP_MKTRECORDSOURCE_GETMATCHBACKFIELDS]
(
  @RECORDSOURCEID uniqueidentifier
)
as
begin
  set nocount on;

  select
    [QUERYVIEWCATALOG].[DISPLAYNAME] as [RECORDSOURCEDISPLAYNAME],
    [MKTGIFTRECORDSOURCE].[QUERYVIEWCATALOGID] as [GIFTRECORDSOURCEID],
    [MKTAPPEALRECORDSOURCE].[QUERYVIEWCATALOGID] as [APPEALRECORDSOURCEID],
    [MKTAPPEALRECORDSOURCE].[APPEALIDFIELD] as [APPEALRECORDSOURCEAPPEALIDFIELD],
    [MKTAPPEALRECORDSOURCE].[DESCRIPTIONFIELD] as [APPEALRECORDSOURCEDESCRIPTIONFIELD],
    [MKTGIFTRECORDSOURCE].[APPEALSYSTEMIDFIELD],
    [MKTGIFTRECORDSOURCE].[APPEALIDFIELD],
    [MKTGIFTRECORDSOURCE].[APPEALDESCRIPTIONFIELD],
    [MKTGIFTRECORDSOURCE].[MAILINGIDFIELD],
    [MKTAPPEALRECORDSOURCE].[SEARCHLISTCATALOGID],
    dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([GIFTQUERYVIEWCATALOG].[ID], [MKTGIFTRECORDSOURCE].[APPEALIDFIELD]) as [APPEALIDFIELDDISPLAYNAME],
    dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([GIFTQUERYVIEWCATALOG].[ID], [MKTGIFTRECORDSOURCE].[APPEALDESCRIPTIONFIELD]) as [APPEALDESCRIPTIONFIELDDISPLAYNAME],
    [MKTGIFTRECORDSOURCE].[SOURCECODEFIELD],
    [MKTGIFTRECORDSOURCE].[FINDERNUMBERFIELD],
    [MKTGIFTRECORDSOURCE].[DONORIDFIELD],
    [GIFTQUERYVIEWCATALOG].[OBJECTNAME] as [GIFTQUERYVIEWNAME],
    [GIFTQUERYVIEWCATALOG].[RECORDTYPEID],
    [GIFTQUERYVIEWCATALOG].[PRIMARYKEYFIELD] as [GIFTQUERYVIEWPRIMARYKEY],
    [GIFTQUERYVIEWCATALOG].[PRIMARYKEYTYPENAME] as [GIFTQUERYVIEWPRIMARYKEYTYPENAME],
    [MKTGIFTRECORDSOURCE].[AMOUNTFIELD],
    [MKTGIFTRECORDSOURCE].[DATEFIELD],
    dbo.[UFN_MKTRECORDSOURCE_MAKEMATCHBACKTABLENAME]([MKTRECORDSOURCE].[ID]) as [LISTMATCHBACKTABLENAME],
    dbo.[UFN_CONSTITUENTSEGMENT_MAKETABLENAME]([MKTRECORDSOURCE].[ID]) as [CONSTITUENTSEGMENTTABLENAME]
  from dbo.[MKTRECORDSOURCE]
  inner join dbo.[QUERYVIEWCATALOG] on [QUERYVIEWCATALOG].[ID] = [MKTRECORDSOURCE].[ID]
  left outer join dbo.[MKTGIFTRECORDSOURCE] on [MKTGIFTRECORDSOURCE].[ID] = [QUERYVIEWCATALOG].[ID]
  left outer join dbo.[MKTAPPEALRECORDSOURCE] on [MKTAPPEALRECORDSOURCE].[ID] = [QUERYVIEWCATALOG].[ID]
  left outer join dbo.[QUERYVIEWCATALOG] as [GIFTQUERYVIEWCATALOG] on [GIFTQUERYVIEWCATALOG].[ID] = [MKTGIFTRECORDSOURCE].[QUERYVIEWCATALOGID] 
  left outer join dbo.[QUERYVIEWCATALOG] as [APPEALQUERYVIEWCATALOG] on [APPEALQUERYVIEWCATALOG].[ID] = [MKTAPPEALRECORDSOURCE].[QUERYVIEWCATALOGID] 
  where [MKTRECORDSOURCE].[ID] = @RECORDSOURCEID;

  return 0;
end