Education & Training
Services & Support
to create and rate content, and to follow, bookmark, and share content with other members.
Project ETC hours
Question asked by
on Jan 4, 2013
on Jan 4, 2013 by Owen_R
Show 0 Likes
How can I get ETC hours of a project? Any specific table and column name?
No one else has this question
Mark as assumed answered
This content has been marked as final.
Show 1 comment
(Required, will not be published)
Jan 4, 2013 3:15 PM
Quite a few ways I can think of:
1 Sum of PRASSIGNMENT.PRESTSUM/3600 joined to PRTASK and thence to SRM_PROJECTS
2 Just read ETC_HOURS from NBI_PROJECT_CURRENT_FACTS (if you have the datamart running)
3 Use one of the neat functions that CA provide in the PMO accelerator pack (in SQL Server Clarity anyway):
select niku.cop_get_etc_fct (project_id, -1, -1, 'EQ') from dual
select niku.prj_effort_fct (project_id, 'PROJECT', 'ETC') from dual
do the sum of select niku.prj_sum_assignment_fct (team_id, 0) from dual joined to PRTEAM and thence to SRM_PROJECTS
will get you it, but be warned they can be a bit slow if you pass lots of records in to them
Show 0 Likes
Retrieving data ...
JUI or AWI?
Explore cipher log columns
How to get the role of the logged user?
Editing list form and tab form - CA SDM