UFN_OLAP_GETELIGIBLEATTRIBUTECATEGORIES

CREATE function dbo.[UFN_OLAP_GETELIGIBLEATTRIBUTECATEGORIES]
(
  @OLAPDATASOURCEID uniqueidentifier
)
/*
Returns a table of all eligible attribute categories for OLAP data mart use that are not already included.
NOTE:  UFN_OLAP_GETELIGIBLEATTRIBUTECATEGORIESFORBBDW relies on this function.  If you change this, please be sure to confirm that is working as well.
DATATYPECODE is currently restricted to 'Code Table' or 'Yes/No'
*/
returns table
as
  return
  (
    select
      [ODSAC].[ID],
      @OLAPDATASOURCEID as [DATASOURCEID],
      [AC].[ID] as [ATTRIBUTECATEGORYID],
      [AC].[NAME],
      [AC].[DATATYPE],
      [RT].[NAME] as [RECORDTYPE]
    from
      dbo.[ATTRIBUTECATEGORY] [AC]
        left join dbo.[OLAPDATASOURCEATTRIBUTECATEGORY] [ODSAC] on [AC].[ID] = [ODSAC].[ATTRIBUTECATEGORYID]
        left join dbo.[ATTRIBUTERECORDTYPE] [ART] on [AC].[ATTRIBUTERECORDTYPEID] = [ART].[ID]
        left join dbo.[RECORDTYPE] [RT] on [ART].[RECORDTYPEID] = [RT].[ID]
    where
      [ODSAC].[ID] is null
      and [AC].[DATATYPECODE] in (4, 5)
      );