Project baseline information and tables

[Nock]

I can't seem to find any tables in either the Pjsvrdb.htm or the Pjdb.htm
that give specific reference to simple PROJECT baseline related information.

Can someone please tell me where this information is kept? I can see
various tables relating to project assignments, project tasks and project
resources but where does the (high level) project related baselining data get
stored? I desperatedly need this info for reporting purposes.

ie. Has XYZ project been baselined? Yes. > Where is this stored?
Any help would be most appreciated for this SQL newb.

Nock (Australia)

 

[Rod Gill]

Data like Baseline Start is in the main tables. For example Task Baseline
start is in Task_BASE_START in MSP_Tasks. Remember that a Task ID and Unique
ID of 0 (Zero) represents a project summary task.

 

[Nock]

Ah I see. Using the SQL query below pulls back the Level 1 summary task
baseline start date and replacing (project) '92' with '" & VAR & "' enables
me to script this in VBA.

SELECT PROJ_ID, TASK_BASE_START, TASK_UID, TASK_ID
FROM dbo.MSP_TASKS
WHERE (PROJ_ID = 92) AND (TASK_UID = 0) AND (TASK_ID = 0)

Fantastic, thanks again Rod.

Nock

 

[Rod Gill]

Yep, but Level 0: the Project Summary task, not a task you have created.

 

[Nock]

Sorry Rod - absolutely correct, level 0 it is.

Nock