Howdy,
Does anyone know what table the Line # (Line_num) attribute is in? I cannot find it under the Field_info table
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
I finally found it in another view (VW_PRJ_LINE_NUM ) Thank your for your help 
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
 
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.