USP_DATALIST_PDACCOUNTSEGMENTMAPLISTTASK

CREATE procedure dbo.USP_DATALIST_PDACCOUNTSEGMENTMAPLISTTASK
as

    set nocount on;

    select 
        ID,
        DESCRIPTION, 
        SEQUENCE, 
        LENGTH, 
        case  SEGMENTTYPE when 4 then dbo.UFN_PDCOMPOSITESEGMENT_TABLENAMESTRING(PDACCOUNTSTRUCTURE.PDACCOUNTTABLESAVAILABLEFORSEGMENTID,1)  else (SELECT FRIENDLYTABLENAME FROM DBO.PDACCOUNTTABLESAVAILABLEFORSEGMENT WHERE ID = PDACCOUNTSTRUCTURE.PDACCOUNTTABLESAVAILABLEFORSEGMENTID) end TABLENAME,        
        cast(dbo.UFN_PDACCOUNTSTRUCTURE_ACCOUNTEXISTS()as NCHAR(1)) HASACCOUNTS,
        case PDACCOUNTSTRUCTURE.SEGMENTTYPE when 3 then '1' when 4 then '1' else '0' end HASMAPPING,
        SEGMENTTYPE,
        --case  SEGMENTTYPE when 4 then 'Composite' else  'Regular' end SEGMENTTYPEDESCRIPTION,

        SEPARATOR  
    from dbo.PDACCOUNTSTRUCTURE where segmenttype >= 3
    order by sequence