Field Reference

Field Types 969 Special Field Categories 997

This appendix lists all the fields available in Microsoft Office Project 2003, broken down by type of data:

Currency

Date

Duration

Enumerated

Indicator

Integer

Outline Code

Percentage and Number

Text

Yes/No (Boolean)

In addition, the following special categories of fields are grouped together for your reference toward the end of this appendix:

• PERT Analysis

Each row in the following tables contains the name of a field in Project 2003 and the category in Microsoft Project to which the field belongs; for example, tasks, resources, and so on. Each row contains a description of the field and the name of the field when it's exposed using the Microsoft Office Project 11.0 OLE DB Provider. Each row also includes the name of the field when you open a project as a database, for example, when you save a project as a Microsoft Office Access database and open it in Access.

Fields are listed in this appendix if the field in the database contains the same data entered or added through Microsoft Project. Some fields listed in this appendix that can be accessed using the Project 11.0 OLE DB Provider do not have a corresponding field in the Microsoft Project database. These "missing" fields are actually the results of calculations based on values stored in other fields. For example, the Cost Variance field contains the difference between a baseline cost and total scheduled cost. The Cost Variance field can be assigned in Microsoft Project and exposed using the OLE DB Provider, but it doesn't have its own field in the Microsoft Project database because Cost Variance is the result of a calculation (Cost - Baseline Cost).

Most fields in Microsoft Project can be found in the following OLE DB Provider or Microsoft Project database tables:

• Assignment. Fields are stored in the Assignments table in OLE DB and in the MSP_ASSIGNMENTS table in the Project database.

• Assignment (Timephased). Fields are stored in the Minute, Hour, Day, Week, and Month assignment-timephased tables in OLE DB.

• Resource. Fields are stored in the Resources table in OLE DB and in the MSP_RESOURCES table in the Microsoft Project database.

• Resource (Timephased). Fields are stored in the Minute, Hour, Day, Week, and Month resource-timephased tables in OLE DB.

• Task. Fields are stored in the Tasks table in OLE DB and in the MSP_TASKS table in the Microsoft Project database.

• Task (Timephased). Fields are stored in the Minute, Hour, Day, Week, and Month task-timephased tables in OLE DB.

• Custom. Fields are stored in the tables they are associated with in OLE DB; for example, custom assignment cost fields are in the Assignments table.

Project Management Made Easy

Project Management Made Easy

What you need to know about… Project Management Made Easy! Project management consists of more than just a large building project and can encompass small projects as well. No matter what the size of your project, you need to have some sort of project management. How you manage your project has everything to do with its outcome.

Get My Free Ebook


Post a comment