UFN_OLAP_GETELIGIBLESMARTFIELDS

CREATE function dbo.[UFN_OLAP_GETELIGIBLESMARTFIELDS]
(
  @OLAPDATASOURCEID uniqueidentifier
)
/*
Returns a table of all eligible smart fields for OLAP data mart use that are not already included.
NOTE:  UFN_OLAP_GETELIGIBLESMARTFIELDSFORBBDW relies on this function.  If you change this, please be sure to confirm that is working as well.
*/
returns table
as
  return
  (
    select
      [ODSSF].[ID],
      @OLAPDATASOURCEID as [DATASOURCEID],
      [SF].[ID] as [SMARTFIELDID],
      [SF].[NAME],
      [SFC].[DISPLAYNAME] as [TYPE],
      [RT].[NAME] as [RECORDTYPE]
    from
      dbo.[SMARTFIELD] [SF]
        left join dbo.[SMARTFIELDCATALOG] [SFC] on [SF].[SMARTFIELDCATALOGID] = [SFC].[ID]
        left join dbo.[OLAPDATASOURCESMARTFIELD] [ODSSF] on ([SF].[ID] = [ODSSF].[SMARTFIELDID] and [ODSSF].[OLAPDATASOURCEID] = @OLAPDATASOURCEID)
        left join dbo.[RECORDTYPE] [RT] on ([SFC].[RECORDTYPEID] = [RT].[ID])
    where
      [ODSSF].[ID] is null 
      and ([SF].[USEVALUEGROUP] = 1 or [SFC].[DATATYPECODE] = 4)--boolean

      );