USP_OLAP_GETELIGIBLEATTRIBUTECATEGORIES_FORQV

CREATE procedure dbo.[USP_OLAP_GETELIGIBLEATTRIBUTECATEGORIES_FORQV] (@OLAPDATASOURCEID uniqueidentifier)
as
begin

  select
    distinct
    ac.[NAME] as [ATTRIBUTECATEGORYNAME],
    ac.[ID] as [ATTRIBUTECATEGORYID],
    ac.[DATATYPECODE],
    ct.[DBTABLENAME] as [CODETABLENAME],
    gc.[DESCRIPTION] as [ATTRIBUTEGROUP],
    ort.[OLAPATTRIBUTEIDCOLUMN],
    ort.[OLAPATTRIBUTERECORDIDCOLUMN],
    ort.[OLAPATTRIBUTETABLESCHEMA],
    ort.[OLAPATTRIBUTETABLENAME],
    ort.[OLAPATTRIBUTEVALUECOLUMN],
    ort.[OLAPATTRIBUTECOMMENTCOLUMN],
    ort.[OLAPATTRIBUTESTARTDATEKEYCOLUMN],
    ort.[OLAPATTRIBUTESTARTDATECOLUMN],
    ort.[OLAPATTRIBUTEENDDATEKEYCOLUMN],
    ort.[OLAPATTRIBUTEENDDATECOLUMN],
    ort.[OLAPATTRIBUTEPRIMARYKEYCOLUMN],
    ort.[OLAPATTRIBUTECONSTITUENTIDCOLUMN],
    ort.[OLAPATTRIBUTECONSTITUENTNAMECOLUMN],
    rt.[NAME] as [RECORDTYPENAME],
    rt.[ID] as [RECORDTYPEID],
    ds.[MARTKEY],
    ac.[CONSTITUENTSEARCHLISTCATALOGID],
    ds.[DATEQUERYNAME] [DATEQUERYNAME],
    ds.[DATEQUERYKEYCOLUMN] [DATEQUERYKEYCOLUMN],
    ort.[OLAPATTRIBUTEVALUEDATECOLUMN],
    ort.[OLAPATTRIBUTEVALUEDATEDIMIDCOLUMN],
    ort.[OLAPATTRIBUTEVALUEYESNOCOLUMN],
    ort.[OLAPATTRIBUTEVALUECURRENCYCOLUMN],
    ort.[OLAPATTRIBUTEVALUECONSTITUENTSYSTEMIDCOLUMN],
    ort.[OLAPATTRIBUTEVALUECONSTITUENTDIMIDCOLUMN],
    ort.[OLAPATTRIBUTEVALUEHOURMINUTECOLUMN],
    ort.[OLAPATTRIBUTEVALUEFUZZYDATECOLUMN],
    ort.[OLAPATTRIBUTEVALUENUMBERCOLUMN]

  from dbo.[ATTRIBUTECATEGORY] ac
  inner join dbo.[OLAPDATASOURCEATTRIBUTECATEGORY] oc on ac.[ID] = oc.[ATTRIBUTECATEGORYID]
  inner join dbo.[ATTRIBUTERECORDTYPE] arc on arc.[ID] = ac.[ATTRIBUTERECORDTYPEID]
  inner join dbo.[OLAPDATASOURCERECORDTYPE] ort on ort.[RECORDTYPEID] = arc.[RECORDTYPEID]
  inner join dbo.[RECORDTYPE] rt on ort.[RECORDTYPEID] = rt.[ID]
  inner join dbo.[OLAPDATASOURCE] ds on ds.[ID] = @OLAPDATASOURCEID
  inner join dbo.[QUERYVIEWCATALOG] qv on qv.[RECORDTYPEID] = arc.[RECORDTYPEID] and ds.[MARTKEY] = qv.[MARTKEY]
  left join dbo.[ATTRIBUTEGROUPCODE] gc on gc.[ID] = ac.[ATTRIBUTEGROUPCODEID]
  left join dbo.[CODETABLECATALOG] ct on ct.[ID] = ac.[CODETABLECATALOGID]

end