Skip to main content

Howdy,

Does anyone know what table the Line # (Line_num) attribute is in? I cannot find it under the Field_info table 

I know it can be found in the Project_View table/view.  You might want to check the database schema guide https://success.planview.com/Planview_Portfolios/Analytics_and_Reporting/Database_Schema_Guide


@Thbutler even though it lists it in Project_view in the schema guide, If you run a query on it it does not show it in the table. 


I finally found it in another view (VW_PRJ_LINE_NUM ) Thank your for your help ​@Thbutler I appreciate it. 


This is the SQL code I use:
 

SELECT
    pe.ppl_code                                                                                                                AS ppl_code,
    (SELECT Description FROM ip.structure with (nolock) WHERE structure_code = pe.ppl_code)                                    AS Program_Description,
    pe.planning_code                                                                                                        AS planning_code,
    (SELECT Description FROM ip.structure with (nolock) WHERE structure_code = pe.planning_code)                            AS Line_Description,
    (ROW_NUMBER() OVER(PARTITION BY pe.ppl_code ORDER BY smap.map_code))                                                    AS Line_Nbr

FROM
    ip.planning_entity AS pe with (nolock) 
    JOIN IP.structure_map smap with (nolock) ON pe.planning_code = smap.structure_code

WHERE pe.ppl_code is not null