Question: Why baseline fields in PRASSIGNMENT table are not always updated?
Answer: Baseline fields in the assignment and task tables are deprecated. Use the PRJ_BASELINE_DETAILS table for these values.
All baseline values that are outside of the PRJ_BASELINE_DETAILS table are considered deprecated and are not kept up to date by Clarity. This includes any fields that start with prbase in prassignment, prtask and any of the investment tables.
- Deprecated query
select prbasesum/3600/8 baseline from prassignment
where prtaskid = xxxx -- internal id of the task;
- Current method to obtain baseline information via SQL Query
select sum(b.usage_sum)/3600/8 baseline
from prj_baseline_details b
and b.is_current = 1
and b.object_id = xxxx -- internal id of the task;
Please consult the technical reference guide for more information.
Keywords: CLARITYKB, attributes, projects, tasks, assignments, resources.