USP_ATTRIBUTECATEGORY_GETLISTBUILDERATTRIBUTES

        CREATE procedure dbo.USP_ATTRIBUTECATEGORY_GETLISTBUILDERATTRIBUTES
        as
        begin
            select
                ATTRIBUTECATEGORY.ID ATTRIBUTECATEGORYID,
                ATTRIBUTECATEGORY.NAME ATTRIBUTECATEGORYNAME,
                TABLECATALOG.TABLENAME,
                ATTRIBUTECATEGORY.VALUECOLUMNNAME,
                ATTRIBUTERECORDTYPE.RECORDTYPEID,
                RECORDTYPE.NAME RECORDTYPENAME,
                RECORDTYPE.BASETABLENAME RECORDTYPETABLE,
                ATTRIBUTECATEGORY.DATATYPECODE,
                ATTRIBUTECATEGORY.ONLYALLOWONEPERRECORD,
                CODETABLECATALOG.DBTABLENAME CODETABLENAME,
                OLAPDATASOURCE.MARTKEY,
                OLAPDATASOURCERECORDTYPE.OLAPATTRIBUTETABLESCHEMA,
                OLAPDATASOURCERECORDTYPE.OLAPATTRIBUTETABLENAME,
                OLAPDATASOURCERECORDTYPE.OLAPATTRIBUTEIDCOLUMN,
                OLAPDATASOURCERECORDTYPE.OLAPATTRIBUTERECORDIDCOLUMN,
                OLAPDATASOURCERECORDTYPE.OLAPATTRIBUTEVALUECOLUMN
            from dbo.ATTRIBUTECATEGORY
            inner join dbo.ATTRIBUTERECORDTYPE
                on ATTRIBUTECATEGORY.ATTRIBUTERECORDTYPEID = ATTRIBUTERECORDTYPE.ID
            inner join dbo.RECORDTYPE
                on ATTRIBUTERECORDTYPE.RECORDTYPEID = RECORDTYPE.ID
            inner join dbo.TABLECATALOG
                on ATTRIBUTECATEGORY.TABLECATALOGID = TABLECATALOG.ID
            left join dbo.CODETABLECATALOG
                on ATTRIBUTECATEGORY.CODETABLECATALOGID = CODETABLECATALOG.ID
            left join dbo.OLAPDATASOURCERECORDTYPE
                on OLAPDATASOURCERECORDTYPE.RECORDTYPEID = RECORDTYPE.ID
            left join dbo.OLAPDATASOURCE
                on OLAPDATASOURCERECORDTYPE.OLAPDATASOURCEID = OLAPDATASOURCE.ID
            where ATTRIBUTECATEGORY.ISLISTBUILDERATTRIBUTE = 1
            and ATTRIBUTECATEGORY.FLAGGEDFOREXTENSIONREMOVAL = 0
            and ATTRIBUTECATEGORY.FLAGGEDFORDELETE = 0
        end