UFN_OLAP_GETELIGIBLEATTRIBUTECATEGORIESFORBBDW

CREATE function dbo.[UFN_OLAP_GETELIGIBLEATTRIBUTECATEGORIESFORBBDW]
(
  @OLAPDATASOURCEID uniqueidentifier
)
/*
Returns a table of all eligible attribute categories for the BBDW OLAP data mart.
*/
returns table
as
  return
  (
    select
      [EAC].[ID],
      [EAC].[DATASOURCEID],
      [EAC].[ATTRIBUTECATEGORYID],
      [EAC].[NAME],
      [EAC].[DATATYPE],
      [EAC].[RECORDTYPE]
    from
      dbo.[UFN_OLAP_GETELIGIBLEATTRIBUTECATEGORIES](@OLAPDATASOURCEID) [EAC]
        left join dbo.[ATTRIBUTECATEGORY] [AC] on [EAC].[ATTRIBUTECATEGORYID] = [AC].[ID]
        left join dbo.[ATTRIBUTERECORDTYPE] [ART] on [AC].[ATTRIBUTERECORDTYPEID] = [ART].[ID]
        left join dbo.[RECORDTYPE] [RT] on [ART].[RECORDTYPEID] = [RT].[ID]
        left join dbo.[OLAPDATASOURCE] [ODS] on [EAC].[DATASOURCEID] = [ODS].[ID]
    where
      [RT].[NAME] in ('Registrant','Constituent','Revenue','Event','Educational History','Designation','Interaction','Model Scores and Ratings','Address','Funding Request','Prospect Plan','Fundraising Purpose','Opportunity','Benefit','Membership')
      and [ODS].[MARTKEY] = 'BBDW'
      and [AC].[ISLISTBUILDERATTRIBUTE] = 0
      );