USP_DATALIST_ATTRIBUTECATEGORY

CREATE procedure dbo.USP_DATALIST_ATTRIBUTECATEGORY
(
  @CURRENTAPPUSERID uniqueidentifier = null
)
as begin
  set nocount on;

  select
    ATTRIBUTECATEGORY.ID,
    ATTRIBUTECATEGORY.NAME,
    RECORDTYPE.NAME,
    ATTRIBUTECATEGORY.DATATYPE,
    ATTRIBUTECATEGORY.ONLYALLOWONEPERRECORD,
    ATTRIBUTECATEGORY.DATATYPECODE,
    ATTRIBUTECATEGORY.CONSTITUENTSEARCHLISTCATALOGID,
    ATTRIBUTECATEGORY.CODETABLECATALOGID,
    ATTRIBUTEGROUPCODE.DESCRIPTION,
    CODETABLECATALOG.DBTABLENAME as CODETABLEDBNAME,
    ATTRIBUTECATEGORY.ISLISTBUILDERATTRIBUTE,
    ATTRIBUTECATEGORY.FLAGGEDFOREXTENSIONREMOVAL,
    TABLECATALOG.ID as TABLECATALOGID,
    TABLECATALOG.TABLENAME,
    RECORDTYPE.BASETABLENAME as RECORDTYPEBASETABLENAME
  from
    dbo.ATTRIBUTECATEGORY
    inner join dbo.ATTRIBUTERECORDTYPE on ATTRIBUTERECORDTYPE.ID = ATTRIBUTECATEGORY.ATTRIBUTERECORDTYPEID
    inner join dbo.RECORDTYPE on RECORDTYPE.ID = ATTRIBUTERECORDTYPE.RECORDTYPEID
    inner join dbo.TABLECATALOG on TABLECATALOG.ID = ATTRIBUTECATEGORY.TABLECATALOGID
    left join dbo.ATTRIBUTEGROUPCODE on ATTRIBUTEGROUPCODE.ID = ATTRIBUTECATEGORY.ATTRIBUTEGROUPCODEID
    left join dbo.CODETABLECATALOG on CODETABLECATALOG.ID = ATTRIBUTECATEGORY.CODETABLECATALOGID
  where
    dbo.UFN_SECURITY_APPUSER_GRANTED_ATTRIBUTECATEGORY_IN_SYSTEMROLE(@CURRENTAPPUSERID,ATTRIBUTECATEGORY.ID) = 1
    and ATTRIBUTECATEGORY.FLAGGEDFORDELETE = 0
  order by
    RECORDTYPE.NAME, ATTRIBUTECATEGORY.NAME;
end