USP_MKTSEGMENTATIONEXPORT_GETFIELDMAPPINGS

create procedure dbo.[USP_MKTSEGMENTATIONEXPORT_GETFIELDMAPPINGS]
(
  @SEGMENTATIONID uniqueidentifier
)
as
  set nocount on;

  select distinct
    [MKTSEGMENT].[QUERYVIEWCATALOGID],
    [QUERYVIEWCATALOG].[OBJECTNAME] as [VIEWNAME],
    [FM].[FULLNAMEFIELD],
    [FM].[FIRSTNAMEFIELD],
    [FM].[MIDDLENAMEFIELD],
    [FM].[LASTNAMEFIELD],
    [FM].[TITLEFIELD],
    [FM].[SUFFIXFIELD],
    [FM].[ADDRESSEEFIELD],
    [FM].[SALUTATIONFIELD],
    case when dbo.[UFN_MKTRECORDSOURCE_VALIDFORBBEC]([QUERYVIEWCATALOG].[ID]) = 1 then 'CONTACTADDRESSEE' else '' end as [CONTACTADDRESSEEFIELD],
    [FM].[COUNTRYFIELD],
    [FM].[ADDRESSLINE1FIELD],
    [FM].[ADDRESSLINE2FIELD],
    [FM].[ADDRESSLINE3FIELD],
    [FM].[ADDRESSLINE4FIELD],
    [FM].[ADDRESSLINE5FIELD],
    [FM].[CITYFIELD],
    [FM].[STATEFIELD],
    [FM].[POSTCODEFIELD],
    [FM].[CARTFIELD],
    [FM].[DPCFIELD],
    [FM].[LOTFIELD],
    [FM].[PHONENUMBERFIELD],
    [FM].[EMAILADDRESSFIELD],
    [GFM].[APPEALSYSTEMIDFIELD] as [REVENUEAPPEALSYSTEMIDFIELD],
    [GFM].[APPEALIDFIELD] as [REVENUEAPPEALIDFIELD],
    [GFM].[APPEALDESCRIPTIONFIELD] as [REVENUEAPPEALDESCRIPTIONFIELD],
    [GFM].[AMOUNTFIELD] as [REVENUEAMOUNTFIELD],
    [GFM].[DONORIDFIELD] as [REVENUEDONORIDFIELD],
    [GFM].[SOURCECODEFIELD] as [REVENUESOURCECODEFIELD],
    [GFM].[MAILINGIDFIELD] as [REVENUEMAILINGIDFIELD],
    [GFM].[DATEFIELD] as [REVENUEDATEFIELD],
    [GFM].[FINDERNUMBERFIELD] as [REVENUEFINDERNUMBERFIELD],
    [GFM].[DATEADDEDFIELD] as [REVENUEDATEADDEDFIELD],
    [GFM].[DONOTACKNOWLEDGEFIELD] as [REVENUEDONOTACKNOWLEDGEFIELD],
    [GFM].[DONOTRECEIPTFIELD] as [REVENUEDONOTRECEIPTFIELD],
    [GFM].[DATECHANGEDFIELD] as [REVENUEDATECHANGEDFIELD],
    [MFM].[MEMBERSHIPSYSTEMIDFIELD],
    [MFM].[MEMBERIDFIELD] as [MEMBERSHIPMEMBERIDFIELD],
    [MFM].[MEMBERFIELD] as [MEMBERSHIPMEMBERFIELD],
    [MFM].[GIVENBYIDFIELD] as [MEMBERSHIPGIVENBYIDFIELD],
    [MFM].[GIVENBYFIELD] as [MEMBERSHIPGIVENBYFIELD],
    [MFM].[EXPIRATIONDATEFIELD] as [MEMBERSHIPEXPIRATIONDATEFIELD],
    [MFM].[ISGIFTFIELD] as [MEMBERSHIPISGIFTFIELD],
    [MFM].[JOINDATEFIELD] as [MEMBERSHIPJOINDATEFIELD],
    [MFM].[LASTRENEWEDONDATEFIELD] as [MEMBERSHIPLASTRENEWEDONDATEFIELD],
    [MFM].[LEVELFIELD] as [MEMBERSHIPLEVELFIELD],
    [MFM].[PROGRAMFIELD] as [MEMBERSHIPPROGRAMFIELD],
    [MFM].[SENDRENEWALFIELD] as [MEMBERSHIPSENDRENEWALFIELD],
    [MFM].[STATUSFIELD] as [MEMBERSHIPSTATUSFIELD],
    [MFM].[TERMFIELD] as [MEMBERSHIPTERMFIELD],
    [MFM].[TYPEFIELD] as [MEMBERSHIPTYPEFIELD]
  from dbo.[MKTSEGMENTATIONSEGMENT]
  inner join dbo.[MKTSEGMENT] on [MKTSEGMENT].[ID] = [MKTSEGMENTATIONSEGMENT].[SEGMENTID]
  inner join dbo.[QUERYVIEWCATALOG] on [QUERYVIEWCATALOG].[ID] = [MKTSEGMENT].[QUERYVIEWCATALOGID]
  inner join dbo.[MKTRECORDSOURCEFIELDMAPPINGS] as [FM] on [FM].[ID] = [QUERYVIEWCATALOG].[ID]
  left outer join dbo.[MKTGIFTRECORDSOURCE] as [GFM] on [GFM].[ID] = [FM].[ID]
  left outer join dbo.[MKTMEMBERSHIPRECORDSOURCE] as [MFM] on [MFM].[ID] = [FM].[ID]
  where [MKTSEGMENTATIONSEGMENT].[SEGMENTATIONID] = @SEGMENTATIONID;

  return 0;