AnsweredAssumed Answered

Task Level Hours for life of project +4 years

Question asked by Lowell on Aug 17, 2010
Latest reply on Aug 19, 2010 by Chris_Hackett
Hi All,
Is there a task level query where I can get the values based on Task Level TKC for hours greater than 2 years ago?

I have a temporary table for users to query against. They have suddenly decided to ask for older task level data.

The time slice tables appear to have values for 2008 - current. The reason I am looking for Task level information is that the "Charge Code" is only available at task level. The "project summary" does not have this level of detail.

Here's my sample query (pulling from the tables I create for resources to query against).

select T.mstart_date, T.employee_no, T.first_name, T.last_name, T.person_type, T.prj_external_id,
T.task_external_id, Tsk.task_name , Tsk.budget_category_id,
Tsk.charge_code_name, Tsk.charge_code_id, sum(T.slice_amount)
from trg_mv_time_m_act T,
trg_mv_project P, trg_mv_task Tsk
where T.projectid = P.pkid
and T.taskid = Tsk.pkid
and P.pkid = Tsk.project_pkid
and Tsk.charge_code_id in ('~160','~161')
group by T.mstart_date, T.employee_no, T.first_name, T.last_name, T.person_type, T.prj_external_id,
T.task_external_id, Tsk.task_name, Tsk.budget_category_id, Tsk.charge_code_name, Tsk.charge_code_id

Outcomes