P6 Database - where are Baseline fields data located?

Matthew,

You are looking for the wrong things.  MS Project stores information in baseline fields inside of the target project.  P6 uses entirely separate and independent schedules as baseline schedules.  You assign the baseline schedule to a project and then all fields are available as baseline fields.   Baseline Schedule “A” can be assigned as BL1 on one day and Baseline Schedule “B” can be assigned to that very same slot on the next.  I suggest that you read up on what P6 has to say about managing Baseline Schedules. Good luck!

Hi Ronald,

Thank you for the steer - very helpful.

In the screenshot below, you can see a new project called, "01" with a baseline created. In the DB, a second project, called, "01-B1" has been created to hold the baseline information.

Basic stuff, I guess but I'm learning. As you guessed, I come from a MS Project background and there's plenty of things to unlearn using P6! 

Regards, Matthew

Hi Matthew,

As Ronald indicated, baselines are stored as an entire copy of a schedule. As such, baselines exist in the same tables as normal projects.

In order to find the baseline projects in the database tables, you first need to know the internal project identifier (proj_id) for your project. You then can use this with the orig_proj_id field in the PROJECT table to find your baseline projects. You could use something like:

select proj_id, proj_short_name from project where orig_proj_id=(select proj_id from project where proj_short_name='01');

Once you have the baseline project details, you can use this in the other tables to get the dates you need.

I hope that helps.

Cheers,

Steve

Hi Matthew,

As Ronald indicated, baselines are stored as an entire copy of a schedule. As such, baselines exist in the same tables as normal projects.

In order to find the baseline projects in the database tables, you first need to know the internal project identifier (proj_id) for your project. You then can use this with the orig_proj_id field in the PROJECT table to find your baseline projects. You could use something like:

select proj_id, proj_short_name from project where orig_proj_id=(select proj_id from project where proj_short_name='01');

Once you have the baseline project details, you can use this in the other tables to get the dates you need.

I hope that helps.

Cheers,

Steve