Clarity: How do baseline detail slices relate to the baseline tables in the Schema?

Document ID : KB000052515
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Clarity provides baseline slices, but it is unclear how to join them in custom queries? How do these tables relate and what fields do I need to join for my queries?

Solution:

The prj_blb_slices table contain the following key references:

prj_object_id        -- This is the id reference to the "parent object".  
                       (i.e. prassignment.prid, prteam.prid or prj_baseline_details.id)  
slice_request_id     -- this is the  

The prj_baseline_details table contains the following key references:

id                   -- this field uniquely identifies the baseline details record.           
                       (It also would be the key reference for the prj_object_id for a baseline slice)       
baseline_id          -- this is the id of the baseline record (prj_baselines.id)       
object_id            -- this represents the id reference of the parent object.  

Note: The object_type will determine the baseline type. i.e. for assignments, the object_type would be "ASSIGNMENT" and the object_id would be a reference to the assignment (prassignment.prid).

e.g. a sample "academic" example SQL Query fragment showing the joins for team information:

   WHERE PRJ_BLB_SLICES.PRJ_OBJECT_ID = PRJ_BASELINE_DETAILS.ID   
   AND PRJ_BASELINE_DETAILS.OBJECT_ID = PRTEAM.PRID   
   AND PRJ_BASELINE_DETAILS.OBJECT_TYPE = 'TEAM'  

For more information, please refer to user guide.

Keywords:

CLARITYKB, prj_baseline_details, baseline, slices, prj_object_id.