UFN_OLAP_GETEXISTINGOLAPSMARTFIELDS

CREATE function dbo.[UFN_OLAP_GETEXISTINGOLAPSMARTFIELDS]
(
  @OLAPDATASOURCEID uniqueidentifier
)
/*
Returns a table of all smart fields currently included in the data mart.
*/
returns table
as
  return
  (
    select
      [ODSSF].[ID],
      [ODSSF].[OLAPDATASOURCEID] as [DATASOURCEID],
      [ODSSF].[SMARTFIELDID] as [SMARTFIELDID],
      [SF].[NAME],
      [SFC].[DISPLAYNAME] as [TYPE],
      [RT].[NAME] as [RECORDTYPE]
    from
      dbo.[OLAPDATASOURCESMARTFIELD] [ODSSF]
        left join dbo.[SMARTFIELD] [SF] on [ODSSF].[SMARTFIELDID] = [SF].[ID]
        left join dbo.[SMARTFIELDCATALOG] [SFC] on [SF].[SMARTFIELDCATALOGID] = [SFC].[ID]
        left join dbo.[RECORDTYPE] [RT] on [SFC].[RECORDTYPEID] = [RT].[ID]
    where
      [ODSSF].[OLAPDATASOURCEID] = @OLAPDATASOURCEID
      );