Text Fields

Table B-9 lists all text fields available in Microsoft Project.

Table B-9. Text Fields

Available

OLE DB

Microsoft

Field

Categories

Provider

Project Database

Description

Code

Resource

ResourceCode

The information about a resource entered as a code, abbreviation, or number.

Contact

Task

TaskContact

The name of the person responsible for a task.

E-mail

Resource

ResourceEmail-

The e-mail address for a

Address

Address

resource.

Group

Resource

ResourceGroup

The name of the group that a resource is part of.

Hyperlink

Assignment

Assignment-Hyperlink

The title of a hyperlink associated with an assignment,

Resource

Resource-Hyperlink

resource, or task.

Task

TaskHyperlink

Hyperlink

Assignment

Assignment-

The hyperlink address of a

Address

Resource Task

Hyperlink-Address Resource-HyperlinkAddress

TaskHyperlink-Address

hyperlink associated with an assignment, resource, or task.

Hyperlink

Assignment

Assignment-

The combination of the

Href

HyperlinkHref

Hyperlink Address and the

Resource

Resource-HyperlinkHref

Hyperlink Sub-Address fields.

Task

TaskHyperlinkHref

Hyperlink

Assignment

Assignment-

The location within a docu

SubAddress

Resource Task

Hyperlink-SubAddress ResourceHyperlink-SubAddress

TaskHyperlink-SubAddress

ment associated with the Hyperlink Address field.

Initials

Resource

Resourcelnitials

RES_INITIALS

The abbreviation of a resource's name.

Available

OLE DB

Microsoft

Field

Categories

Provider

Project Database

Description

Material

Resource

Resource-

RES_MATERIAL_

The name of the unit of

Label

MaterialLabel

LABEL

measurement associated with a material resource.

Name

Resource

ResourceName

RES_NAME

The name of a resource or

Task

TaskName

TASK_NAME

task.

Notes

Assignment

AssignmentNotes

ASSN_RTF_NOTES

The notes about an assign-

Resource

ResourceNotes

RES_RTF_NOTES

ment, resource, or task.

Task

TaskNotes

TASK_RTF_NOTES

Outline

Task

TaskOutline-

TASK_OUTLINE_

The number that identifies a

Number

Number

LEVEL

task's position in a project's outline; this number is entered automatically by Microsoft Project.

Phonetics

Resource

Resource-Phonetics

RES_PHONETICS

The phonetic information about a resource name; used only in the Japanese version of Microsoft Project.

Project

Assignment

Projects

The PROJ_NAME

The name of the project.

Resource Task

Projects Projects

field in the MSP_PROJECTS table contains the name of a project. Match the PROJ_UID in the MSP_ASSIGNMENTS, MSP_RESOURCES, or MSP_TASKS tables to the PROJ_UID in the MSP_PROJECTS table to identify the project name.

Resource

Assignment

ResourceGroup

The name of a group to

Group

Task

ResourceGroup

which a resource belongs.

Field

Provider

Microsoft Project Database

Description

Resource Initials

Assignment

ResourceInitials in the Resources table

RES_INITIALS in the

MSP_RESOURCES

table

The initials of a resource assigned to a task.

Task

ResourceInitials in the Resources table

RES_INITIALS in the

MSP_RESOURCES

table

Resource Names

Assignment

ResourceName in the Resources table

RES_NAME in the

MSP_RESOURCES

table

The name of a resource assigned to a task.

Task

ResourceName in the Resources table

RES_NAME in the

MSP_RESOURCES

table

Subproject File

Task

TaskSubprojectFile

The name of an inserted project, including the path to the project.

Task Name

Assignment

TaskName

TASK_NAME

The name of a task.

Task

Summary Name

TaskSummary-

Name

The name of a summary task.

Text1-30

Assignment Resource

Assignment-Text1-30

ResourceText1-30

MSP_TEXT_FIELDS MSP_TEXT_FIELDS

The values for the custom Text1 through Text30 fields.

Task

TaskText1-30

MSP_TEXT_FIELDS

WBS

Assignment Task

TaskWBS

TASK_WBS

The work breakdown structure codes used to represent a task's position within the project.

Windows

User

Account

Resource

ResourceNT-Account

The Microsoft Windows user name for a work resource.

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