UFN_OLAP_GETELIGIBLESMARTFIELDSFORBBDW

CREATE function dbo.[UFN_OLAP_GETELIGIBLESMARTFIELDSFORBBDW]
(
  @OLAPDATASOURCEID uniqueidentifier
)
/*
Returns a table of all eligible smart fields for the BBDW OLAP data mart.
*/
returns table
as
  return
  (
    select
      [ESF].[ID],
      [ESF].[DATASOURCEID],
      [ESF].[SMARTFIELDID],
      [ESF].[NAME],
      [ESF].[TYPE],
      [ESF].[RECORDTYPE]
    from 
      dbo.[UFN_OLAP_GETELIGIBLESMARTFIELDS](@OLAPDATASOURCEID) [ESF]
        left join dbo.[SMARTFIELD] [SF] on [ESF].[SMARTFIELDID] = [SF].[ID]
        left join dbo.[SMARTFIELDCATALOG] [SFC] on [SF].[SMARTFIELDCATALOGID] = [SFC].[ID]
        left join dbo.[RECORDTYPE] [RT] on [SFC].[RECORDTYPEID] = [RT].[ID]
        left join dbo.[OLAPDATASOURCE] [ODS] on [ESF].[DATASOURCEID] = [ODS].[ID]
    where 
      [RT].[NAME] in ('Constituent', 'Financial Transaction Line Item')
      and [ODS].[MARTKEY] = 'BBDW'
      );