Gateway Providers Data Dictionary - Oracle Cloud · wish to use this object to integrate data with your ERP application. ProjectFinanceElement The EnterpriseTrack ProjectFinanceSnapshot

GGaatteewwaayy PPrroovviiddeerrss DDaattaa DDiiccttiioonnaarryyVVeerrssiioonn 1177

JJuullyy 22001177

3

Contents

Overview ................................................................................................ 9

Supported Integrations ................................................................................ 11

Flow Types Supported by Primavera Providers .................................................... 11

EnterpriseTrack Business Objects ................................................................. 13

Project .................................................................................................. 14

ProjectFinance ......................................................................................... 16

ProjectFinanceElement ............................................................................... 19

ProjectFinanceSnapshot .............................................................................. 20

Gateway and File Provider Business Objects .................................................... 23

Activity .................................................................................................. 32

ActivityCode ............................................................................................ 39

ActivityCodeType ...................................................................................... 39

ActivityExpense ........................................................................................ 40

ActivityRisk ............................................................................................. 41

BaselineType ........................................................................................... 41

BlanketPurchaseOrder ................................................................................ 42

BlanketPurchaseOrderDetail ......................................................................... 42

BudgetApproval ........................................................................................ 43

BudgetApprovalDetail ................................................................................. 43

BudgetChange .......................................................................................... 44

BudgetChangeDetail ................................................................................... 44

BudgetChangeOrder ................................................................................... 45

BudgetChangeOrderDetail ............................................................................ 46

BudgetItem ............................................................................................. 47

BudgetItemDetail ...................................................................................... 47

BudgetTransfer ......................................................................................... 48

BudgetTransferDetail ................................................................................. 49

Calendar ................................................................................................ 49

CBS ....................................................................................................... 51

CBSDurationSummary ................................................................................. 51

CBSExpenseSpread ..................................................................................... 52

CBSResourceSpread .................................................................................... 53

ChangeOrder ........................................................................................... 55

ChangeOrderDetail .................................................................................... 55

Contract ................................................................................................. 56

ContractDetail ......................................................................................... 57

CostAccount ............................................................................................ 58

Gateway Providers Data Dictionary

4

CostColumn ............................................................................................. 58

Currency ................................................................................................ 59

EPS ....................................................................................................... 59

Estimate ................................................................................................. 67

EstimateDetail ......................................................................................... 67

ExchangeRate .......................................................................................... 68

ExpenseCategory ....................................................................................... 68

FinancialPeriod ......................................................................................... 69

FundAppropriation ..................................................................................... 69

FundAppropriationDetail.............................................................................. 69

Invoice ................................................................................................... 70

InvoiceDetail ........................................................................................... 71

JournalEntry ............................................................................................ 71

JournalEntryDetail ..................................................................................... 72

Location ................................................................................................. 72

NotebookTopic ......................................................................................... 73

Payment ................................................................................................. 74

PaymentApplication ................................................................................... 74

PaymentApplicationDetail ............................................................................ 75

PaymentApplicationtoOwner ......................................................................... 75

PaymentApplicationtoOwnerDetail ................................................................. 76

PaymentDetail ......................................................................................... 77

PaymentFromOwner ................................................................................... 78

PaymentFromOwnerDetail ........................................................................... 78

POAmendment ......................................................................................... 79

POAmendmentDetail .................................................................................. 80

PotentialChangeOrder ................................................................................ 80

PotentialChangeOrderDetail ......................................................................... 81

Project .................................................................................................. 81

ProjectCode ............................................................................................ 90

ProjectCodeType ...................................................................................... 90

ProjectFinance ......................................................................................... 90

ProjectFinanceElement ............................................................................... 92

ProjectFinanceSnapshot .............................................................................. 93

ProjectInformation .................................................................................... 94

ProjectResource ....................................................................................... 94

PurchaseOrder ......................................................................................... 95

PurchaseOrderDetail .................................................................................. 95

Relationship ............................................................................................ 96

RequestForSubstitution ............................................................................... 97

RequestForSubstitutionDetail ........................................................................ 97

Resource ................................................................................................ 98

Contents

5

ResourceAssignment ................................................................................... 99

ResourceCode ......................................................................................... 104

ResourceCodeType ................................................................................... 104

ResourceCurve ........................................................................................ 104

ResourceRate .......................................................................................... 105

ResourceRole .......................................................................................... 105

Risk ..................................................................................................... 106

RiskAndIssue ........................................................................................... 107

RiskAndIssueDetail .................................................................................... 107

RiskImpact ............................................................................................. 108

RiskMatrix .............................................................................................. 108

RiskMatrixScore ....................................................................................... 109

RiskMatrixThreshold .................................................................................. 110

RiskResponseAction ................................................................................... 111

RiskResponseActionImpact .......................................................................... 112

RiskResponsePlan ..................................................................................... 113

RiskThreshold ......................................................................................... 114

RiskThresholdLevel ................................................................................... 114

Role ..................................................................................................... 115

RoleLimit ............................................................................................... 115

RoleRate ............................................................................................... 116

ShellList ................................................................................................ 116

Timesheet.............................................................................................. 117

TimesheetDetail ...................................................................................... 117

UDFType ............................................................................................... 118

UnitOfMeasure ........................................................................................ 118

Vendor .................................................................................................. 118

VendorDetail .......................................................................................... 119

VendorEvaluation ..................................................................................... 119

WBS ..................................................................................................... 120

WBSCategory .......................................................................................... 121

WBSExpenseSpread ................................................................................... 121

WBSResourceSpread .................................................................................. 122

WBSSpread ............................................................................................. 124

WorkRelease ........................................................................................... 127

WorkReleaseDetail.................................................................................... 128

P6 Business Objects List ........................................................................... 129

Activity ................................................................................................. 134

ActivityCode ........................................................................................... 153

ActivityCodeType ..................................................................................... 154

ActivityExpense ....................................................................................... 154


6

ActivityRisk ............................................................................................ 157

BaselineType .......................................................................................... 157

Calendar ............................................................................................... 158

Example of Importing a Global Calendar ................................................... 161

CBS ...................................................................................................... 161

CBSDurationSummary ................................................................................ 162

CBSExpenseSpread .................................................................................... 163

CBSResourceSpread ................................................................................... 164

CostAccount ........................................................................................... 166

Currency ............................................................................................... 167

EPS ...................................................................................................... 168

ExpenseCategory ...................................................................................... 181

FinancialPeriod ........................................................................................ 181

Location ................................................................................................ 182

NotebookTopic ........................................................................................ 183

Project ................................................................................................. 183

ProjectCode ........................................................................................... 199

ProjectCodeType ..................................................................................... 200

ProjectResource ...................................................................................... 201

Relationship ........................................................................................... 202

Resource ............................................................................................... 204

ResourceAssignment .................................................................................. 207

ResourceCode ......................................................................................... 215


ResourceRate .......................................................................................... 217

ResourceCurve ........................................................................................ 218

ResourceRole .......................................................................................... 218

Risk ..................................................................................................... 219

RiskImpact ............................................................................................. 219

RiskMatrix .............................................................................................. 220






RiskThreshold ......................................................................................... 225


Role ..................................................................................................... 226

RoleLimit ............................................................................................... 227

RoleRate ............................................................................................... 227

UDFType ............................................................................................... 228

UnitOfMeasure ........................................................................................ 229

Contents

7

WBS ..................................................................................................... 229

WBSCategory .......................................................................................... 239

WBSExpenseSpread ................................................................................... 240

WBSResourceSpread .................................................................................. 240

WBSSpread ............................................................................................. 243

Prime Business Objects List....................................................................... 249

Activity ................................................................................................. 254

ActivityRisk ............................................................................................ 261

Calendar ............................................................................................... 261

CBSSegment ........................................................................................... 262

CBSTemplate .......................................................................................... 262

CBSTemplateCode .................................................................................... 263

CostCategory .......................................................................................... 264

CostSheetWorkspaceTotalCostRow ................................................................. 264

CostSheetWorkspaceTotalItem ..................................................................... 266

Currency ............................................................................................... 267

EPS ...................................................................................................... 268

ExchangeRate ......................................................................................... 268

Holiday ................................................................................................. 269

HolidayGroup .......................................................................................... 269

Location ................................................................................................ 270

Project ................................................................................................. 270

ProjectBudget ......................................................................................... 278

ProjectBudgetChange ................................................................................ 279

ProjectBudgetTransfer ............................................................................... 280

ProjectCode ........................................................................................... 281

ProjectCodeType ..................................................................................... 281

Relationship ........................................................................................... 281

Resource ............................................................................................... 282

ResourceAssignment .................................................................................. 284

ResourceCode ......................................................................................... 287


ResourceRate .......................................................................................... 288

ResourceRoleAssignment ............................................................................ 288

Risk ..................................................................................................... 289

RiskImpact ............................................................................................. 290

RiskMatrix .............................................................................................. 290






8


RiskThreshold ......................................................................................... 296


Role ..................................................................................................... 297

UDFType ............................................................................................... 297

UnitOfMeasure ........................................................................................ 298

WBS ..................................................................................................... 298

WBSSpread ............................................................................................. 299

Unifier Business Objects ........................................................................... 301

CBS ...................................................................................................... 302

CBSDurationSummary ................................................................................ 303

CBSExpenseSpread .................................................................................... 303

CBSResourceSpread ................................................................................... 305

CompanyCosts ......................................................................................... 307

Column ................................................................................................. 307

CompanyCostsDetail .................................................................................. 308

CompanyLineItem..................................................................................... 308

CompanyLineItemDetail ............................................................................. 309

CompanySimple ....................................................................................... 309

ExchangeRate ......................................................................................... 310

OtherProjectCosts .................................................................................... 310

OtherProjectCostsDetail ............................................................................. 310

P6ActivitySheet ....................................................................................... 311

Project ................................................................................................. 312

ProjectCommits ....................................................................................... 313

ProjectCommitsDetail ................................................................................ 314

ProjectDocument ..................................................................................... 314

ProjectDocumentDetail .............................................................................. 315

ProjectInvoices ........................................................................................ 315

ProjectInvoicesDetail ................................................................................ 316

ProjectSimple ......................................................................................... 317

Resource ............................................................................................... 317

Role ..................................................................................................... 317

ShellList ................................................................................................ 318

WBS ..................................................................................................... 318

Legal Notices ........................................................................................ 320

9

Overview

The Primavera Gateway Providers Data Dictionary provides a comprehensive listing of all business objects and all associated fields available with each Primavera provider delivered with Primavera Gateway. Review the list of supported business objects in each application to determine the data that needs to be supported for integration in Primavera Gateway.

To view these business objects in the Primavera Gateway user interface log in to Gateway and select the Data Dictionary menu.

Within our documentation, some content might be specific for cloud deployments while other content is relevant for on-premises deployments. Any content that applies to only one of these deployments is labeled accordingly.

In This Section

Supported Integrations ............................................................................................ 11 Flow Types Supported by Primavera Providers ....................................................... 11

11

Supported Integrations

Integrations between the following Primavera applications are supported and delivered in Primavera Gateway:

Integrations With P6 EPPM Sample File

Oracle Prime x x x

Oracle Instantis EnterpriseTrack

x x

P6 EPPM x x x

Primavera Unifier x x x

Flow Types Supported by Primavera Providers

Primavera Gateway supports the following flow types:

Master Data

Use this flow type to export or import master data between two applications or between distinct P6 deployments. For example, export master data from P6 to Prime.

Project Data

Use this flow type to export or import project data between two applications or between distinct P6 deployments. For example, export transfer project data from P6 to Prime.

The following table identifies the default flow types supported for each Primavera provider:

Flows EnterpriseTrack P6 Prime Sample Unifier File

Master Data x x x x x

Project Data x x x x x x

13

EnterpriseTrack Business Objects

For the EnterpriseTrack provider, the Project business object is available in the Data Dictionarymenu in the Gateway user interface. Select this business object to review a detailed list of fields supported for an EnterpriseTrack project.

Business Object Description

Project

A project is a temporary endeavor undertaken to create a unique product, service, or result. Project fields will depend on an initiative. Project attributes for different initiatives will be different, as some of the settings are initiative specific.The following fields are available for an EnterpriseTrack project.

ProjectFinance

The EnterpriseTrack Project Finance object contains actual values associated with a project finance structure. To import or export a ProjectFinance object, you will need to select the following objects in the field mapping template:

Project

ProjectFinance

ProjectFinanceElement

Note: By default, all ProjectFinance related business objects are commented in the metadata XML file. You will need to remove the comment tags if you wish to use this object to integrate data with your ERP application.


The EnterpriseTrack ProjectFinanceSnapshot object is a representation of the project finance values at a specific point in time. To import or export a ProjectFinanceSnapshot object, you will need to select the following objects in the field mapping template:

Project

ProjectFinance

ProjectFinanceSnapshot


Note: By default, all ProjectFinance related business objects are commented out in the metadata XML file. You will need to remove the comment tags if you wish to use this object to integrate data with your ERP application.


14


Project

A project is a temporary endeavor undertaken to create a unique product, service, or result. Project fields will depend on an initiative. Project attributes for different initiatives will be different, as some of the settings are initiative specific.The following fields are available for an EnterpriseTrack project.


The EnterpriseTrack ProjectFinanceElement is the most granular unit of the project finance structure. To import or export a ProjectFinanceElement object, you will need to select the following objects in the field mapping template:

ProjectFinance



Note: By default, all ProjectFinance related business objects are commented out in the metadata XML file. You will need to remove the comment tags if you wish to use this object to integrate data with your ERP application.

In This Section

Project ..................................................................................................................... 14 ProjectFinance ........................................................................................................ 16 ProjectFinanceElement ........................................................................................... 19 ProjectFinanceSnapshot ......................................................................................... 20

Project

Description: A project is a temporary endeavor undertaken to create a unique product, service, or result. Projects usually contain a work breakdown structure (WBS) and activities. The following fields are available for an EnterpriseTrack project:

Field Description Read-Only

project_number The unique ID generated by the system. No

project_name The name of the project. No

project_status

The status of the project. Valid values are:

Active

On-Hold

No


15


Canceled

Completed-Post Realization

Closed-In Realization

percent_completion_type Indicates the activity default percent complete type of the activity.

No

planned_realization_date Planned realization date. No

The following fields can be modified in the metadata file

business_unit Organization hierarchy - Business Unit. No

calendar_id Project calendar name. No

consider_for_finances Consider for Finances flag. No

currency_code Project currency. No

default_laborexpensetype Default expense type. No

division Organization hierarchy - Division No

emailnotification_flag Email notification flag No

externalmode_datesduration External mode - Dates Duration No

externalmode_durationeffort External mode - Duration Effort No

externalmode_effortcost External mode - Effort Cost No

fin_approval_template_id Finance approval template. No

fin_edit_mode Finance edit mode. No

fin_track_start_date Finance tracking start month. No

fintemplateid Finance template. No

functional_area Functional area. No

grace_period_for_completed_activities_in_ts

Grace period for completed activities in timesheet.

No

grace_period_for_future_activities_in_ts

Grace period for future activities in timesheet.

No

initial_forecast_cost Initial Forecast - Cost No

initial_forecast_savings Initial Forecast - Savings No

initial_forecast_total Initial Forecast - Total No

is_capitalization_enabled Is Capitalization enabled flag No

Is_capitalized Is capitalized flag. No

is_etc_enabled_for_timesheet

ETC Enabled for timesheets flag. No


16


is_etc_required_for_timesheet

ETC Required for timesheet flag. No

is_fin_lock_global Global finance lock flag. No

is_laborexpensetype_mandatory

Labor expense mandatory flag. No

keywords Project keywords. No

object_id The unique ID generated by the system. No

pcs Project initiative No

percent_completion_type Project percent completion type. No

planned_realization_date Planned realization date of the project. No

planned_start_date Planned start date of the project. No

priority Priority. No

project_fin_lock_date Project finance lock date No

project_name Project name No

project_number Project number No

project_status Project status

project_type Project type No

resource_computation_enabled

Resource computation enabled flag. No

roadmap Project roadmap No

start_date Project start date No

ProjectFinance

Description: The EnterpriseTrack Project Finance object contains actual values associated with a project finance structure. To import or export a ProjectFinance object, you will need to select the following objects in the field mapping template:

Project

ProjectFinance



17

Note: Project finance data (and finance-related business objects) transfer is supported only between two distinct instances of EnterpriseTrack applications.


fin_data_type The finance data type ( current / snapshot / structure ).

No

fin_edit_mode

The finance edit mode used only when editing. Valid options include:

" " If set to a blank value, then finances will be retrieved in the finance edit mode. For example, if the finance edit mode is monthly and the fin_search_mode is set to "", then finances will be retrieved in monthly mode.

M Indicates monthly finance edit mode

Y Indicates yearly finance edit mode

A Indicates aggregate finance edit mode

No

fin_search_mode

The finance Search Mode ( M / Y / A ); used only when searching. Valid options include:

" " If set to a blank value, then finances will be retrieved in the finance edit mode. For example, if the finance edit mode is monthly and the fin_search_mode is set to "", then finances will be retrieved in monthly mode.

M Indicates monthly finance search mode

Y Indicates yearly finance search mode

A Indicates aggregate finance search mode

No

fintemplate_id The name of the project's finance template. No

fintemplate_version_id The version of the project's finance template.

No


18


from_month

The from (start) month when searching or updating; applicable only if fin_search_mode or fin_edit_mode = M. (YYYY/MM Format)

If from_month and to_month have non empty values, then finance data will be retrieved for the specific month range.

If from_month is not specified and to_month is valued, then finances will be retrieved for all months till the to_month value.

If from_month is valued and to_month is not specified, then finances will be retrieved for all months starting from the from_month value.

No

from_year

The from (start) year is used to define month range when searching or updating finance information. This is applicable only if fin_search_mode or fin_edit_mode = Y. (YYYY Format).

No


operation_type The operation type; specifies the operation being performed.

No

project_object_id The unique ID of the Project. No

to_month

The to (end) month when searching or updating; applicable only if fin_search_mode or fin_edit_mode = M. (YYYY/MM Format)

If from_month and to_month have non empty values, then finance data will be retrieved for the specific month range.

If from_month is not specified and to_month is valued, then finances will be retrieved for all months till the to_month value.

If from_month is valued and to_month is not specified, then finances will be retrieved for all months starting from the from_month value.

No


19


to_year

The to (end) year is used to define month range when searching or updating finance information. This is applicable only if fin_search_mode or fin_edit_mode = Y. (YYYY Format).

No


Description: The EnterpriseTrack ProjectFinanceElement is the most granular unit of the project finance structure. To import or export a ProjectFinanceElement object, you will need to select the following objects in the field mapping template:

ProjectFinance





display_name The display name of the element. No

element_class The element classification; indicates the element's class within the project finance structure.

No

element_type

The element type; indicates whether the element is currency or some user-specified, non-currency type (such as kilowatts, hours, etc.).

No

id The finance element ID. No

mf_type The element multiplication factor type. No

mf_value

The multiplication factor value of the element; specifies its impact (contribution) toward computation of parent element values.

No


20


number_of_units

Contains raw data; used if the element_type is not currency.

During finance import, only specify the value element (listed below) if the element_type is not currency.

During finance export, specify the number_of_units element which contains the raw data and the value element (listed below) which contains the currency amount.

No


parent_id The ID of the parent element; this will be empty if element_id is 'Total'.

No

project_object_id The unique ID of the associated project. No

projectfinance_object_id

The unique ID of the associated project finance.

No

sequence_number The sequence of this element within parent; 10, 20, 30, etc.

No

value

Contains the actual value of element; editable only when element_type is currency. If element_type is not currency, value is not editable, and is instead computed internally from number_of_units.

No


Description: The EnterpriseTrack ProjectFinanceSnapshot object is a representation of the project finance values at a specific point in time. To import or export a ProjectFinanceSnapshot object, you will need to select the following objects in the field mapping template:

Project

ProjectFinance





21


is_default_snapshot The is default snapshot flag; indicates whether or not this is the default snapshot.

No

is_editable_snapshot

The is editable snapshot flag; indicates whether or not snapshot can be edited. Used only during export, as this is a read-only attribute.

No


project_object_id The unique ID of the associated project. No

projectfinance_object_id


No

snapshot_created_by The login ID of the user who created the snapshot.

No

snapshot_created_date The date on which the snapshot was created. No

snapshot_desc The snapshot description. No

snapshot_name The snapshot name. No

snapshot_updated_by The login ID of the user who last updated the snapshot.

No

snapshot_updated_date

The date on which the snapshot was last updated.

No

23

Gateway and File Provider Business Objects

The following business objects are supported in Gateway as well as the File providers:

Note: If you want to change the read-only status for a specific field in a business object, you will need to modify the Read-Only value for that field in the metadata file of the provider. Gateway developers and administrators can change the read-only status of field.


Activity An activity is a unit of work performed during the course of a project.

ActivityCode Activity codes are user-defined codes to classify and categorize activities according to the organization's and project's needs.

ActivityCodeType

Activity code types provide a way of classifying activity codes. Activity codes are user-defined codes to classify and categorize activities according to the organization's and project's needs.

ActivityExpense Activity expenses are non-resource costs associated with a project and assigned to a project's activities. They are typically one-time expenditures for non-reusable items.

ActivityRisk The activity risk object stores the relationship between a single activity and a single Risk.

BaselineType BaselineType fields

BlanketPurchaseOrders

A company level purchase order, which enables agreements with vendors to provide services across multiple projects, released on a per-project/per-period basis with work authorizations against a previously determined maximum.

BlanketPurchaseOrdersDetail

Line Items for Blanket Purchase Order

BudgetApproval used to approve project budget

BudgetApprovalDetail Line Items for Budget Approval

BudgetChange For requesting additional (or reduced) budget beyond the existing budget

BudgetChangeDetail Line Items for Budget Change

BudgetChangeOrder A change to a budget that is typically created for a contractor that is based on changes to a contract between the


24


contractor and owner.

Note: This object is not available in the File provider data dictionary.

BudgetChangeOrderDetail

Line Items for Budget Change Orders


BudgetItem

A budget that is typically created for a contractor that is based on a contract they have with an owner for a project.


BudgetItemDetail

Line Items for Budget Items


BudgetTransfer For transferring budget from one WBS code to another. Most typically used to release budget contingency to other cost items.

BudgetTransferDetail Line Items for Budget Transfer

Calendar The P6 Calendar Object definition

CBS CBS business object

CBSDurationSummary CBSDurationSummary business object

CBSExpenseSpread Summarized spread data per CBS per expense category

CBSResourceSpread Summarized spread data per CBS per resource assignment

ChangeOrder

A formal commit change to the contract


ChangeOrderDetail

Line Items for Change Order


Contract Base Commit for EPC Activities (SOV = Payment Application)

ContractDetail Line Items for Contract

CostAccount

Cost accounts contain the organization's cost account IDs. Available across all projects, they support tracking of costs and earned value based on the organization's cost account IDs. Cost accounts are hierarchical objects.

CostColumn CostColumn is used to exchange the cost sheet data. Cost Sheet is a sheet which will have all the Costs related to


25


different WBS codes for a particular project listed in it.


Currency Currency fields

EPS EPS

Estimate Used to create multiple project estimates and identify the preferred scenario

EstimateDetail Line Items for Estimate

ExchangeRate

ExchangeRate allows the use of multiple currencies within a project for Cost purposes and are defined at the Company level. ExchangeRate would be used to define the current exchange rate for a currency as compared to the base currency of the Company.


ExpenseCategory Expense categories are used to categorize project expenses. They are used for standardizing expenses and for rolling up expenses across projects.

FinancialPeriod Financial periods are used to provide accurate display and reporting of actual units and costs. Financial periods may not overlap each other and do not have to be contiguous.

FundAppropriation Fund accounts as assigned to projects

FundAppropriationDetail Line Items for Fund Appropriation

Invoice A general process for requesting and approving payments against commitments (invoice at the WBS or breakdown level do not calculate retainage or stored materials)

InvoiceDetail Line items for invoice

JournalEntry A process for adjusting spends line items. Most commonly used to reassign costs to alienate cost centers or GL code. Generic spend to transfer across cost codes.

JournalEntryDetail Line items for Journal Entry

Location The location is used to store address information including latitude and longitude. Locations can be assigned to resources, projects and/or activities.

NotebookTopic Notebook topics are used to categorize notes on EPS, project, WBS,and activity objects.

Payment BP to hold Checks Processed Information from Financial System.


26


PaymentApplication A process to track your payment information using a standard payment application method (for example, tracking retainage, stored materials, past payments, etc.)

PaymentApplicationDetail

Line Items for Payment Application

PaymentApplicationtoOwner

A payment application that is raised by a contractor to the owner in order for the contractor to receive payment.


PaymentApplicationOwnerDetail

Line Items for Payment Applications to Owner


PaymentDetail Line Items for Payment

PaymentFromOwner

A record of the actual payments a contractor will have received from the owner based on the payment application they presented to the owner.


PaymentFromOwnerDetail

Line Items for Payments From Owner


POAmendment Approval process for purchase order changes

POAmendmentDetail Line items for PO Amendment

PotentialChangeOrder Contractor initiated potential change order.

PotentialChangeOrderDetail

Line items for Potential Change Order.

Project A project is a temporary endeavor undertaken to create a unique product, service, or result. Projects usually contain a work breakdown structure (WBS) and activities.

ProjectCode Project codes are user-defined codes to classify and categorize projects across the enterprise.

ProjectCodeType Project code types provide a way of classifying project codes. Project codes are user-defined codes to classify and categorize projects across the enterprise.

ProjectFinance EnterpriseTrack Project Finance.

ProjectFinanceElement EnterpriseTrack Project Finance Element.

ProjectFinanceSnapshot EnterpriseTrack Project Finance Snapshot.


27


ProjectInformation Project attribute information

ProjectResource Primavera's resource planning feature allows you to do high-level project planning for future project or project that does not require resource assignments at the activity level.

PurchaseOrder To track money committed to be spent (General Spends type Base Commit)

PurchaseOrderDetail Line items for Purchase Order

Relationship

A relationship defines how an activity relates to the start or finish of another activity or assignment. These relationships, which form the logic of the project network, are used together with activity durations to determine schedule dates.

RequestforSubstitution A change of identical material or equipment

RequestforSubstitutionDetail

Line items for Request For Substitution

Resource Resources include labor, nonlabor, and materials that are used for activities across all projects.

ResourceAssignment Resource assignments track the work of resources or roles that are performing various activities.

ResourceCode Resource codes are user-defined codes to classify and categorize resources across all projects.

ResourceCodeType Resource Code Types provide a way of classifying resource codes. Resource codes areuser-defined codes to classify and categorize resources across all projects.

ResourceCurve Resource curves enable you to specify how you want resource units or costs spread over the duration of an activity.

ResourceRate Resource rates provide a way of specifying multiple resource prices and maximum units per time values that vary over time.

ResourceRole A resource role object represents an association between a resource object and a role object.

Risk The risk object represents a probabilistic event or condition which if it occurs has an impact on the project.

RiskAndIssue A log for documenting, tracking, and estimating impacts of open issues and risks; Log of items that may impact schedule/scope/cost.

RiskAndIssueDetail Line items for Risk and Issue.


28


RiskImpact The risk impact object stores the pre-response qualitative value assigned to a risk for each of the risk thresholds.

RiskMatrix

The risk matrix object contains the name and description of each probability and impact diagram (PID). The Risk Matrix is then used to qualitatively assess each risk and assign a score.

RiskMatrixScore The risk matrix score object stores the score values from the probability and impact diagram (PID) of the risk score matrix.

RiskMatrixThreshold

The risk matrix threshold object creates a relationship between a RiskThreshold object and a RiskMatrix object. This allows a single RiskThreshold object to be associated with multiple RiskMatrix objects.

RiskResponseAction

The risk response action object contains the detailed steps that need to occur to complete the risk response plan. Multiple actions can be associated with one response plan and each action can be linked to an activity in the project.

RiskResponseActionImpact

The risk response action impact object is a post-risk response action qualitative value that is assigned to a risk for each of the risk thresholds.

RiskResponsePlan The risk response plan object communicates how the project team plans to address the identified risk.

RiskThreshold

The risk threshold object contains the name, description, and type of each risk threshold. Risk thresholds provide a mechanism for setting up the criteria that is used to assess the risk.

RiskThresholdLevel The risk threshold level object stores the level information (e.g. Low, Medium, High) for each risk threshold.

Role

Roles are project personnel job titles or skills, such as mechanical engineer, inspector, or carpenter. They represent a type of resource with a certain level of proficiency rather than a specific individual.

RoleLimit Role limits define the limits of the maximum work units per time for a Role in a time period.

RoleRate Role rates enable you to select a predefined price per unit for cost calculating when assigning the role to an activity.

ShellList Shell List

Timesheet Used to capture Employee Timesheets (project / non-project hrs)

TimesheetDetail Line Items for Timesheet


29


UDFType User-defined fields (UDFs) enable users to add custom fields and values to the project database.

UnitOfMeasure The unit of measure provides definitions of units of measure for material resources.

Vendor Company Vendor directory

VendorDetail Line items for Vendor

VendorEvaluation Document vendor performance for consideration for future work (simple)

WBS

The project work breakdown structure (WBS) is a hierarchical arrangement of the products and services produced during and by a project. Each element of a WBS may contain more-detailed WBS elements, activities, or both. WBS are hierarchical objects.

WBSCategory As their name implies, WBS categories are used to categorize WBS elements. They are defined globally.

WBSExpenseSpread Expense spread data per WBS per ExpenseCategory

WBSResourceSpread Spread data per WBS per Resource

WBSSpread Summarized spread data per WBS

WorkRelease

Process that is connected to Blanket Purchase Order Business Process that is deployed at company level. This process can be used to write against the Market purchase order.

WorkReleaseDetail Line items for Work Release


30

In This Section

Activity ..................................................................................................................... 32 ActivityCode ............................................................................................................ 39 ActivityCodeType .................................................................................................... 39 ActivityExpense ....................................................................................................... 40 ActivityRisk .............................................................................................................. 41 BaselineType .......................................................................................................... 41 BlanketPurchaseOrder ............................................................................................ 42 BlanketPurchaseOrderDetail ................................................................................... 42 BudgetApproval ....................................................................................................... 43 BudgetApprovalDetail .............................................................................................. 43 BudgetChange ........................................................................................................ 44 BudgetChangeDetail ............................................................................................... 44 BudgetChangeOrder ............................................................................................... 45 BudgetChangeOrderDetail ...................................................................................... 46 BudgetItem .............................................................................................................. 47 BudgetItemDetail ..................................................................................................... 47 BudgetTransfer ....................................................................................................... 48 BudgetTransferDetail .............................................................................................. 49 Calendar ................................................................................................................. 49 CBS ......................................................................................................................... 51 CBSDurationSummary ............................................................................................ 51 CBSExpenseSpread ............................................................................................... 52 CBSResourceSpread .............................................................................................. 53 ChangeOrder .......................................................................................................... 55 ChangeOrderDetail ................................................................................................. 55 Contract .................................................................................................................. 56 ContractDetail ......................................................................................................... 57 CostAccount ............................................................................................................ 58 CostColumn ............................................................................................................ 58 Currency ................................................................................................................. 59 EPS ......................................................................................................................... 59 Estimate .................................................................................................................. 67 EstimateDetail ......................................................................................................... 67 ExchangeRate ......................................................................................................... 68 ExpenseCategory .................................................................................................... 68 FinancialPeriod ....................................................................................................... 69 FundAppropriation ................................................................................................... 69 FundAppropriationDetail .......................................................................................... 69 Invoice ..................................................................................................................... 70 InvoiceDetail ............................................................................................................ 71 JournalEntry ............................................................................................................ 71 JournalEntryDetail ................................................................................................... 72 Location .................................................................................................................. 72 NotebookTopic ........................................................................................................ 73 Payment .................................................................................................................. 74 PaymentApplication ................................................................................................. 74


31

PaymentApplicationDetail ........................................................................................ 75 PaymentApplicationtoOwner ................................................................................... 75 PaymentApplicationtoOwnerDetail .......................................................................... 76 PaymentDetail ......................................................................................................... 77 PaymentFromOwner ............................................................................................... 78 PaymentFromOwnerDetail ...................................................................................... 78 POAmendment ........................................................................................................ 79 POAmendmentDetail ............................................................................................... 80 PotentialChangeOrder ............................................................................................. 80 PotentialChangeOrderDetail .................................................................................... 81 Project ..................................................................................................................... 81 ProjectCode ............................................................................................................ 90 ProjectCodeType ..................................................................................................... 90 ProjectFinance ........................................................................................................ 90 ProjectFinanceElement ........................................................................................... 92 ProjectFinanceSnapshot ......................................................................................... 93 ProjectInformation ................................................................................................... 94 ProjectResource ...................................................................................................... 94 PurchaseOrder ........................................................................................................ 95 PurchaseOrderDetail ............................................................................................... 95 Relationship ............................................................................................................ 96 RequestForSubstitution ........................................................................................... 97 RequestForSubstitutionDetail .................................................................................. 97 Resource ................................................................................................................. 98 ResourceAssignment .............................................................................................. 99 ResourceCode ...................................................................................................... 104 ResourceCodeType .............................................................................................. 104 ResourceCurve ..................................................................................................... 104 ResourceRate ....................................................................................................... 105 ResourceRole ....................................................................................................... 105 Risk ....................................................................................................................... 106 RiskAndIssue ........................................................................................................ 107 RiskAndIssueDetail ............................................................................................... 107 RiskImpact ............................................................................................................ 108 RiskMatrix ............................................................................................................. 108 RiskMatrixScore .................................................................................................... 109 RiskMatrixThreshold .............................................................................................. 110 RiskResponseAction ............................................................................................. 111 RiskResponseActionImpact ................................................................................... 112 RiskResponsePlan ................................................................................................ 113 RiskThreshold ....................................................................................................... 114 RiskThresholdLevel ............................................................................................... 114 Role....................................................................................................................... 115 RoleLimit ............................................................................................................... 115 RoleRate ............................................................................................................... 116 ShellList ................................................................................................................ 116 Timesheet ............................................................................................................. 117 TimesheetDetail .................................................................................................... 117 UDFType ............................................................................................................... 118


32

UnitOfMeasure ...................................................................................................... 118 Vendor .................................................................................................................. 118 VendorDetail ......................................................................................................... 119 VendorEvaluation .................................................................................................. 119 WBS ...................................................................................................................... 120 WBSCategory ....................................................................................................... 121 WBSExpenseSpread ............................................................................................. 121 WBSResourceSpread ........................................................................................... 122 WBSSpread .......................................................................................................... 124 WorkRelease ......................................................................................................... 127 WorkReleaseDetail ................................................................................................ 128

Activity

Description: An activity is a unit of work performed during the course of a project.


ActualDuration

The activity actual duration percent of planned. Computed as actual duration / BL duration * 100. The value can exceed 100. The BL duration is the activity's at completion duration from the project baseline.

No

ActualFinishDate The actual finish date of the activity.

No

ActualStartDate The actual start date of the activity.

No

ActualTotalCost

The actual total cost for the activity, including labor resources, nonlabor resources, and project expenses. Actual total cost = actual labor costs + actual nonlabor costs + actual expense costs.

No

AtCompletionDuration The total working time from the activity's current start date to the current finish date.

No

AtCompletionTotalCost

The total cost at completion for the activity, including labor resources, nonlabor resources, and project expenses. At completion total cost = at completion labor cost + at

No


33


completion nonlabor cost + at completion expense cost.

BaselineDuration The duration for the activity in the project baseline.

No

BaselineFinishDate The current finish date of the activity in the project baseline.

No

BaselinePlannedLaborUnits The planned units for all labor resources assigned to the activity.

No

BaselinePlannedNonLaborUnits The planned units for all nonlabor resources assigned to the activity.

No

BaselineStartDate The current start date of the activity in the project baseline.

No

CalendarCode The unique code of the calendar. No

CalendarName The name of the calendar. No

CalendarObjectId The unique ID of the calendar. No

DataDate An Activity field to define Data Date.

No

DurationType

The duration type of the activity. One of 'Fixed Units/Time', 'Fixed Duration and Units/Time', 'Fixed Units', or 'Fixed Duration and Units'.

No

EarlyFinishDate The early finish date of the activity.

No

EarlyStartDate The early start date of the activity. No

EBSBdugetCurrentCost Current Budget Activity Level No

EBSBdugetCurrentQuantity A project UDF to define BudgetCurrentQuantity.

No

EBSBdugetOriginalCost Current Budget Original Level No

EBSBdugetOriginalQuantity A project UDF to define BudgetOriginalQuantity.

No

EBSBdugetProposedCost Proposed Budget Activity Level No


34


EBSBdugetProposedQuantity A project UDF to define BudgetProposedQuantity.

No

EBSBdugetStatusCode A project UDF to define BudgetStatusCode.

No

EBSVersionName A project UDF to define BudgetVersionName.

No

EBSVersionNumber A project UDF to define BudgetVersionNumber.

No

ExpectedFinishDate

The date the activity is expected to be finished according to the progress made on the activity's work products. The expected finish date is entered manually by people familiar with progress of the activity's work products.

No

FinishDate The early finish date of the activity.

No

Id The unique identifier of the activity.

No

IsStarred The flag that indicates whether this activity is marked as starred activity.

No

IsWorkPackage The flag that indicates whether this activity is the child of a work package WBS.

No

LateFinishDate The late finish date of the activity. No

LateStartDate The late start date of the activity. No

LessonsLearned An activity note field to store notes.

No

LocationCode The code of the location assigned to the Activity.

No

LocationName The name of the location assigned to the activity.

No

LocationObjectId The unique ID of the location assigned to the activity.

No

LongText The long text value. No

MaximumDuration The maximum duration of the No


35


activity

MinimumDuration The minimum duration of the activity

No

MostLikelyDuration The most likely duration of the activity

No

Name The name of the activity. The activity name does not have to be unique.

No

ObjectId The unique ID generated by the system.

No

PercentComplete

The activity percent complete. This value is tied to the activity duration % complete, units % complete, or physical % complete, depending on the setting for the activity's percent complete type.

No

Phase An activity code to track the phase of the activity.

No

PhysicalPercentComplete

The physical percent complete which can either be user entered or calculated from the activity's weighted steps.

No

PlannedDuration The activity planned duration. No

PlannedFinishDate

The date the activity is scheduled to finish. This date is computed by the project scheduler but can be updated manually by the project manager. This date is not changed by the project scheduler after the activity has been started.

No

PlannedStartDate

The date the activity is scheduled to begin. This date is computed by the project scheduler but can be updated manually by the project manager. This date is not changed by the project scheduler after the activity has been started.

No


36


PlannedTotalCost

The planned total cost for the activity, including labor resources, nonlabor resources, and project expenses. Planned total cost = planned labor cost + planned nonlabor cost + planned expense cost.

No

PostResponsePessimisticFinish The post-response pessimistic finish date for the activity.

No

PostResponsePessimisticStart The post-response pessimistic start date for the activity.

No

PreResponsePessimisticFinish The pre-response pessimistic finish date for the activity.

No

PreResponsePessimisticStart The pre-response pessimistic start date for the activity.

No

PrimaryConstraintDate The primary constraint date of the activity.

No

PrimaryConstraintType The primary constraint type of the activity.

No

ProjectId The short code of the associated project.

No

ProjectObjectId The unique ID of the associated project.

No

RemainingDuration No

RemainingEarlyFinishDate The remaining late end date, which is calculated by the scheduler.

No

RemainingEarlyStartDate

The date the remaining work for the activity is scheduled to begin. This date is computed by the project scheduler but can be updated manually by the project manager.

No

RemainingLateFinishDate The remaining late finish date of the project.

No

RemainingLateStartDate The remaining late start date of the project.

No


37


RemainingTotalCost

The remaining total cost for the activity, including labor resources, nonlabor resources, and project expenses. Remaining total cost = remaining labor costs + remaining nonlabor costs + remaining expense costs.

No

ResourceType The resource type: "Labor", "Nonlabor", or "Material".

No

ResumeDate The resume of the project. No

RolledupWBSObjectId Rolled up WBS Object Ids after filtering either by levels or tagging

No

SecondaryConstraintDate

The date to be used for the cstr_type2 assignment, if the activity has a cstr_type2 value. The activity's constraint type determines whether this is a start date or finish date. Activity constraints are used by the project scheduler.

No

SecondaryConstraintType The additional constraint to be used by the scheduler.

No

StartDate The early start date of the activity. No

Status The current status of the activity, either 'Not Started', 'In Progress', or 'Completed'.

No

SuspendDate The suspend of the project. No

TotalActualCost An Activity UDF to store Total Actual Cost for the Activity.

No

TotalCommitmentCost An Activity UDF to store Total Commitment Cost for the Activity.

No

TotalPlannedCost An Activity UDF to store Total Planned Cost for the Activity.

No

Type

The type of activity, either 'Task Dependent', 'Resource Dependent', 'Level of Effort', 'Start Milestone', 'Finish Milestone', or 'WBS Summary'.

No


38


VCPActDemandPeggedAvlDate No

VCPActDemandPeggedOrderNumber

No

VCPActDemandPeggedOrderType

No

VCPActItemSelection No

VCPActItemSelectionCode No

VCPActivityObjectId VCP Activity Object Id No

VCPActSupplyActualStartDate No

VCPActSupplyDockDate No

VCPActSupplyDueDate No

VCPActSupplyItemId No

VCPActSupplyItemName No

VCPActSupplyOrderDate No

VCPActSupplyOrderNumber No

VCPActSupplyOrderType No

VCPActSupplyOrganization No

VCPActSupplyPeggedActivityId No

VCPActSupplyPeggedOrderNumber

No

VCPActSupplyQuantity No

VCPActSupplyShipDate No

VCPActSupplyStartDate No

VCPActSupplyUpdatedArrivalDate No

WBSCode WBSCode No

WBSName The name of the WBS element. No

WBSObjectId The unique ID of the WBS for the activity.

No

WBSPath The WBS path of the Activity. No


39

ActivityCode

Description: Activity codes are user-defined codes to classify and categorize activities according to the organization's and project's needs.


CodeTypeName The name of the activity code type. No

CodeTypeObjectId The unique ID of the activity code type. No

CodeValue The value of the activity code. No

Color The Hex representation for the color. No

Description The description of the activity code. No

ObjectId The unique ID generated by the system. No

ParentObjectId The unique ID of the parent activity code. No

SequenceNumber The sequence number for sorting. No

ActivityCodeType

Description: Activity code types provide a way of classifying activity codes. Activity codes are user-defined codes to classify and categorize activities according to the organization's and project's needs.


EPSObjectId The unique ID of the EPS. No

Length The maximum number of characters allowed for values of this activity code.

No


40


Name The name of the activity code type. No


ProjectObjectId The unique ID of the project. No

Scope The scope of activity code type. No

ActivityExpense

Description: Activity expenses are non-resource costs associated with a project and assigned to a project's activities. They are typically one-time expenditures for non-reusable items.


ActivityObjectId

The unique ID of the activity to which the project expense is linked. Every project expense is associated with one activity in the project.

No

ActualCost The actual cost for the project expense. No

ActualUnits The actual units for the project expense. No

AtCompletionCost The sum of the actual plus remaining costs for the project expense. Computed as actual cost + remaining cost.

No

AtCompletionUnits The at completion units for the project expense.

No

CostAccountId The ID of the cost account. No

CostAccountName The name of the cost account. No

CostAccountObjectId The unique ID of the cost account. No

ExpenseCategoryName The name of the expense category. No

ExpenseCategoryObjectId

The unique ID of the expense category. No

ExpenseItem The name of the project expense. No


PlannedCost

The planned cost for the project expense. This field is named BudgetedCost in Primavera's Engineering and Construction and Maintenance and Turnaround solutions.

No


41


PlannedUnits The planned number of units for the project expense. This number is multiplied by the price per unit to compute the planned cost.

No

RemainingCost

The remaining cost for the project expense. Before actual expenses are made, remaining cost should be the same as planned cost.

No

RemainingUnits The remaining units for the project expense.

No

ActivityRisk

Description: The activity risk object stores the relationship between a single Activity and a single Risk.


ActivityId The short name of the associated activity. No

ActivityName The name of the associated activity. No

ActivityObjectId The unique ID of the associated activity. No


ProjectId The short name of the associated project. No

ProjectObjectId The unique ID of the associated project. No

RiskId The short name of the associated risk. No

RiskName The name of the associated risk. No

RiskObjectId The unique ID of the associated risk. No

BaselineType

Description: BaselineType Fields


CreateDate The create Date for currency No

CreateUser The name of the user that created this user-defined field.

No


42


LastUpdateDate The Last Update Date for currency No

LastUpdateUserThe name of the user that last updated this user-defined field.

No

Name The name for BaselineType No


SequenceNumber

Sequence Number for BaselineType No

BlanketPurchaseOrder

Description: A company level purchase order, which enables agreements with vendors to provide services across multiple projects, released on a per-project/per-period basis with work authorizations against a previously determined maximum.


Amount Amount No

CreateDate Creation Date No

CreateUserId Creator No

ObjectId The unique ID generated by the system No

RecordNo Record Number No

Status Status No

Title Title No

BlanketPurchaseOrderDetail

Description: Line Items for Blanket Purchase Order


Amount Amount No

LineNo Line No. No

Objectid The unique ID generated by the system No

ParentObjectId The unique ID of the blanket purchase order No

PricePerUnit Item Unit Cost No


43


Quantity Item Quantity No

RecordNo Parent Record Number No

ShortDesc Short Description No

TabId Tab Name No

BudgetApproval

Description: Used to approve project budget


Amount Amount No



DMPublishPath Publish Path No


ProjectObjectId The unique ID of the project No


Status Status No

Title Title No

BudgetApprovalDetail

Description: Line items for Budget Approval


Amount Amount No

BitemId Cost Code No

Descriptions Description No

EffectiveDate Effective Date No

FundCode Fund Code No

LineNo Line No. No



44







TabId Tab Name No

WPId Work Package No

BudgetChange

Description: For requesting additional (or reduced) budget beyond the existing budget.


Amount Amount No







Status Status No

Title Title No

BudgetChangeDetail

Description: Line items for Budget Change


Amount Amount No


Description Description No



45



LineNo Line No. No







TabId Tab Name No


BudgetChangeOrder

Description: A change to a budget that is typically created for a contractor that is based on changes to a contract between the contractor and owner.



Amount Amount No



CurrencyId Transaction Currency No

CurrencyRate Rate in Project Currency No



DueDate Due Date No






46


RefBPO Reference BPO No

RefId Contract/PO No

Status Status No

Title Title No

BudgetChangeOrderDetail

Description: Line Items for Budget Change Orders



Amount Amount No



LineNo Line No No


ParentDetailId The unique ID of the parent contract detail No

ParentObjectId The unique ID of the parent contract No




RefBPOLineItem

Reference BPO Lineitem No


SOVLineNo Reference No

TabId Tab Name No



47

BudgetItem

Description: A budget that is typically created for a contractor that is based on a contract they have with an owner for a project.



Amount Amount No







DueDate Due Date No







Status Status No

Title Title No

BudgetItemDetail

Description: Line Items for Budget Items



Amount Amount No


48




LineNo Line No No







RefBPOLineItem




TabId Tab Name No


BudgetTransfer

Description: For transferring budget from one WBS code to another. Most typically used to release budget contingency to other cost items.


Amount Amount No







Status Status No

Title Title No


49

BudgetTransferDetail

Description: Line items for Budget Transfer


Amount Amount No



EffectiveDate

Effective Date No


LineNo Line No. No

Objectid The unique ID generated by the system

No

ParentObjectId

The unique ID of the blanket purchase order

No

PricePerUnit

Item Unit Cost No




TabId Tab Name No


Calendar

Description: Calendars defined the available work hours in each calendar day, and includes global and resource types.


BaseCalendarObjectId

The unique ID of the global calendar to which this calendar is linked. Any changes to the global calendar are automatically propagated to this calendar.

No

Code The Code of the calendar. No

CreateDate The date this calendar was created. No


50


CreateUser The name of the user that created this calendar.

No

HolidayOrExceptionsAll dates with holidays or exceptions in this calendar.

No

HoursPerDay The max hours per day value for a calendar No

HoursPerMonth The max hours per month value for a calendar

No

HoursPerWeek The max hours per week value for a calendar

No

HoursPerYear The max hours per year value for a calendar

No

IsBaseline The boolean value indicating if this business object is related to a Project or Baseline.

No

IsDefault The flag that identifies the default global calendar (applies to global calendars only)

No

IsPersonal The flag indicating if this calendar is a personal calendar (applies to resource calendars only).

No

IsTemplate The flag that identifies if the calendar is a template.

No

LastUpdateDate The date this resource code was last updated.

No

LastUpdateUser The name of the user that last updated this resource code.

No

Name The name of the calendar. No


ProjectId The short name of the project. No


StandardWorkWeek Standard detailed work hours for each day of week

No

Type The calendar type - either 'Global' or 'Resource'.

No


51

CBS

Description: CBS business object


CBSCode CBS Code associated with the Project No

CBSDescription CBS Code Description No

CBSStatus CBS Code Status. Valid values are "Active" and "InActive".

No


ProjectObjectId The unique ID of the associated Project No

ParentObjectId The unique ID of the parent CBS No

CBSDurationSummary

Description: CBSDurationSummary business object


BaselineType Baseline type of the associated baseline

No

CBSObjectId The unique ID of the associated CBS.

No

DataDate Data date of the associated project No

ObjectId The unique ID generated by the system

No

OriginalProjectObjectId The original object ID of the associated Project

No

ProjectId The short name of the associated Project

No

ProjectName The name of the associated Project No

ProjectObjectId The unique ID of the associated Project

No

SummaryActualDuration Summarized Actual Duration the project

No

SummaryActualFinishDate

Summarized Actual Finish Date of the project

No

SummaryActualStartDate Summarized Actual Start Date of the No


52


project

SummaryPercentComplete

Summarized Percent Complete the project

No

SummaryPlannedDurationSummarized Planned Duration the project

No

SummaryPlannedFinishDate

Summarized Planned Finish Date of the project

No

SummaryPlannedStartDate

Summarized Planned Start Date of the project

No

SummaryRemainingDuration

Summarized Remaining Duration the project

No

SummaryRemainingFinishDate

Summarized Remaining Finish Date of the project

No

SummaryRemainingStartDate

Summarized Remaining Start Date of the project

No

CBSExpenseSpread

Description: Summarized spread data per CBS per expense category


ActualCost Actual Cost No

ActualUnits Actual Units No

AtCompletionCost At Completion Cost No

AtCompletionUnits At Completion Units No

BaselineType Baseline Type No

CBSObjectId The unique ID of CBS. No

DataDate Date date No

EndDate End date No

ExpenseCategoryName Expense Category No


No

PlannedCost Planned Cost No

PlannedUnits Planned Units No


53


ProjectId Project short name No

ProjectName Project name No

ProjectObjectId The unique ID of Project. No

ProjectOrigObjectId The original object id of the associated Project

No

RemainingCost Remaining Cost No

RemainingUnits Remaining Units No

StartDate Start date No

SummaryActualCost Summarized Actual cost No

SummaryActualUnits Summarized Actual Units No

SummaryAtCompletionCost Summarized At completion cost No

SummaryAtCompletionUnits Summarized At Completion Units No

SummaryPlannedCost Summarized Planned cost No

SummaryPlannedUnits Summarized Planned Units No

SummaryRemainingCost Summarized Remaining cost No

SummaryRemainingUnits Summarized Remaining Units No

CBSResourceSpread

Description: Summarized spread data per CBS per resource assignment



ActualUnits Actual Units No





CurrencyId Currency Id No

CurrencyName Currency Name No

DataDate Date date No


54


EndDate End date No


No

OriginalProjectObjectId The original object id of the associated Project

No




ProjectName Project name No




ResourceId Resource short name No

ResourceName Resource Name No

ResourceType Resource Type No

StartDate Start date No


SummaryActualFinish Summarized Actual finish date No

SummaryActualStart Summarized Actual Start date No



SummaryAtCompletionUnits Summarized At Completion Units No

SummaryPlannedCost Summarized Planned cost No

SummaryPlannedFinish Summarized Planned finish date No

SummaryPlannedStart Summarized Planned Start date No

SummaryPlannedUnits Summarized Planned Units No


SummaryRemainingFinish Summarized Remaining finish date No

SummaryRemainingStart Summarized Remaining Start date No


UnitAbbreviation Unit Abbreviation No


55


UnitName Unit Name No

ChangeOrder

Description: A formal commit change to the contract.



Amount Amount No







DueDate Due Date No







Status Status No

Title Title No

ChangeOrderDetail

Description: Line Items for Change Order


56



Amount Amount No



LineNo Line No No







RefBPOLineItem Reference BPO Lineitem No



TabId Tab Name No


Contract

Description: Base commit for EPC Activities (SOV = Payment Application)


Amount Amount No







DueDate Due Date No


57








Status Status No

Title Title No

ContractDetail

Description: Line Items for Contract


Amount Amount No



LineNo Line No No










TabId Tab Name No



58

CostAccount

Description: Cost accounts contain the organization's cost account IDs. Available across all projects, they support tracking of costs and earned value based on the organization's cost account IDs. Cost accounts are hierarchical objects.


Description The description of the cost account. No

Id The short code that uniquely identifies this cost account.

No

Name The name of the cost account. No

ObjectId The unique ID of the cost account. No

ParentObjectId The unique ID of the parent cost account of this cost account in the hierarchy.

No


CostColumn

Description: CostColum is used to exchange the cost sheet data. Cost Sheet is a sheet which will have all the Costs related to different WBS codes for a particular project listed in it.



Amount Amount No

LongDesc Long Description No


Quantity Quantity No


SpendCategory Spends Category No

UnitCost Unit Cost No

UnitOfMeasure Unit of Measure No

WBSCode Cost Code No


59

Currency

Description: Currency fields


CreateDate The create Date for currency. No


No

DecimalSymbol The symbol for decimal. No

DigitGroupingSymbol The symbol for Digit Groups. No

ExchangeRate The exchange rate for currency. No

Id The ID for currency. No

LastUpdateDate The Last Update Date for currency No

LastUpdateUser The name of the user that last updated this user-defined field.

No

Name The Name of currency. No

NegativeSymbol The symbol for negative currency. No


PositiveSymbol The symbol for positive currency. No

Symbol The symbol for decimal. No

EPS

Description: EPS


AnticipatedFinishDate Anticipated Finish Date. No

AnticipatedStartDate Anticipated Start Date. No

CreateDate The date this EPS was created.

No

CreateUser The name of the user that created this EPS.

No

CurrentBudget Current Budget. No

CurrentVariance Current Variance. No

DistributedCurrentBudget DistributedCurrentBudget. No


60


FinishDate Finish Date. No

GUID GUID. No

Id The short name of the EPS. No

IndependentETCLaborUnits Independent ETC Labor Units. No

IndependentETCTotalCost Independent ETC Total Cost. No

LastSummarizedDate Last Summarized Date. No

LastUpdateDate Last Update Date. No

LastUpdateUser Last Update User. No

Name The name of the EPS. No

ObjectId The unique id that uniquely identifies this EPS.

No

OBSName OBS Name. No

OBSObjectId OBS Object ID. No

OriginalBudget Original Budget. No

ParentObjectId Parent EPS Object ID. No

PlannedStartDate Planned Start Date. No

ProjectObjectId Project Object ID. No

ProposedBudget Proposed Budget. No

SequenceNumber Sequence Number. No

StartDate StartDate. No

SummaryAccountingVarianceByCost Summary Accounting Variance By Cost.

No

SummaryAccountingVarianceByLaborUnits

Summary Accounting Variance By Labor Units.

No

SummaryActivityCount Summary Activity Count. No

SummaryActualDuration Summary Actual Finish Date. No

SummaryActualExpenseCost Summary Actual Expense Cost.

No

SummaryActualFinishDate Summary Actual Finish Date. No

SummaryActualLaborCost Summary Actual Labor Cost. No

SummaryActualLaborUnits Summary Actual Labor Units. No

SummaryActualMaterialCost Summary Actual Material Cost. No


61


SummaryActualNonLaborCost Summary Actual Non Labor Cost.

No

SummaryActualNonLaborUnits Summary Actual Non Labor Units.

No

SummaryActualStartDate Summary Actual Start Date. No

SummaryActualThisPeriodCost Summary Actual This Period Cost.

No

SummaryActualThisPeriodLaborCost Summary Actual This Period Labor Cost.

No

SummaryActualThisPeriodLaborUnits Summary Actual This Period Labor Units.

No

SummaryActualThisPeriodMaterialCostSummary Actual This Period Material Cost.

No

SummaryActualThisPeriodNonLaborCost

Summary Actual This Period Non Labor Cost.

No

SummaryActualThisPeriodNonLaborUnits

Summary Actual This Period Non Labor Units.

No

SummaryActualTotalCost Summary Actual Total Cost. No

SummaryActualValueByCost Summary Actual Value By Cost.

No

SummaryActualValueByLaborUnits Summary Actual Value By Labor Units.

No

SummaryAtCompletionDuration Summary At Completion Duration.

No

SummaryAtCompletionExpenseCost Summary At Completion Expense Cost.

No

SummaryAtCompletionLaborCost Summary At Completion Labor Cost.

No

SummaryAtCompletionLaborUnits Summary At Completion Labor Units.

No

SummaryAtCompletionMaterialCost Summary At Completion Material Cost.

No

SummaryAtCompletionNonLaborCost Summary At Completion Non Labor Cost.

No

SummaryAtCompletionNonLaborUnits Summary At Completion Non Labor Units.

No


62


SummaryAtCompletionTotalCost Summary At Completion Total Cost.

No

SummaryAtCompletionTotalCostVariance

Summary At Completion Total Cost Variance.

No

SummaryBaselineCompletedActivityCount

Summary Baseline Completed Activity Count.

No

SummaryBaselineDuration Summary Baseline Duration. No

SummaryBaselineExpenseCost Summary Baseline Expense Cost.

No

SummaryBaselineFinishDate Summary Baseline Finish Date.

No

SummaryBaselineInProgressActivityCount

Summary Baseline In Progress Activity Count.

No

SummaryBaselineLaborCost Summary Baseline Labor Cost. No

SummaryBaselineLaborUnits Summary Baseline Labor Units.

No

SummaryBaselineMaterialCost Summary Baseline Material Cost.

No

SummaryBaselineNonLaborCost Summary Baseline Non Labor Cost.

No

SummaryBaselineNonLaborUnits Summary Baseline Non Labor Units.

No

SummaryBaselineNotStartedActivityCount

Summary Baseline Not Started Activity Count.

No

SummaryBaselineStartDate Summary Baseline Start Date. No

SummaryBaselineTotalCost Summary Baseline Total Cost. No

SummaryBudgetAtCompletionByCost Summary Budget At Completion By Cost.

No

SummaryBudgetAtCompletionByLaborUnits

Summary Budget At Completion By Labor Units.

No

SummaryCompletedActivityCount Summary Completed Activity Count.

No

SummaryCostPercentComplete Summary Cost Percent Complete.

No

SummaryCostPercentOfPlanned Summary Cost Percent Of Planned.

No


63


SummaryCostPerformanceIndexByCost

Summary Cost Performance Index By Cost.

No

SummaryCostPerformanceIndexByLaborUnits

Summary Cost Performance Index By Labor Units.

No

SummaryCostVarianceByCost Summary Cost Variance By Cost.

No

SummaryCostVarianceByLaborUnits Summary Cost Variance By Labor Units.

No

SummaryCostVarianceIndex Summary Cost Variance Index. No

SummaryCostVarianceIndexByCost Summary Cost Variance Index By Cost.

No

SummaryCostVarianceIndexByLaborUnits

Summary Cost Variance Index By Labor Units.

No

SummaryDurationPercentComplete Summary Duration Percent Complete.

No

SummaryDurationPercentOfPlanned Summary Duration Percent Of Planned.

No

SummaryDurationVariance Summary Duration Variance. No

SummaryEarnedValueByCost Summary Earned Value By Cost.

No

SummaryEarnedValueByLaborUnits Summary Earned Value By Labor Units.

No

SummaryEstimateAtCompletionByCostSummary Estimate At Completion By Cost.

No

SummaryEstimateAtCompletionByLaborUnits

Summary Estimate At Completion By Labor Units.

No

SummaryEstimateAtCompletionHighPercentByLaborUnits

Summary Estimate At Completion High Percent By Labor Units.

No

SummaryEstimateAtCompletionLowPercentByLaborUnits

Summary Estimate At Completion Low Percent By Labor Units.

No

SummaryEstimateToCompleteByCost Summary Estimate To Complete By Cost.

No

SummaryEstimateToCompleteByLaborUnits

Summary Estimate To Complete By Labor Units.

No

SummaryExpenseCostPercentComplet Summary Expense Cost No


64


e Percent Complete.

SummaryExpenseCostVariance Summary Expense Cost Variance.

No

SummaryFinishDateVariance Summary Finish Date Variance.

No

SummaryInProgressActivityCount Summary In Progress Activity Count.

No

SummaryLaborCostPercentComplete Summary Labor Cost Percent Complete.

No

SummaryLaborCostVariance Summary Labor Cost Variance.

No

SummaryLaborUnitsPercentComplete Summary Labor Units Percent Complete.

No

SummaryLaborUnitsVariance Summary Labor Units Variance.

No

SummaryMaterialCostPercentCompleteSummary Material Cost Percent Complete.

No

SummaryMaterialCostVariance Summary Material Cost Variance.

No

SummaryNonLaborCostPercentComplete

Summary Non Labor Cost Percent Complete.

No

SummaryNonLaborCostVariance Summary Non Labor Cost Variance.

No

SummaryNonLaborUnitsPercentComplete

Summary Non Labor Units Percent Complete.

No

SummaryNonLaborUnitsVariance Summary Non Labor Units Variance.

No

SummaryNotStartedActivityCount Summary Not Started Activity Count.

No

SummaryPerformancePercentCompleteByCost

Summary Performance Percent Complete By Cost.

No

SummaryPerformancePercentCompleteByLaborUnits

Summary Performance Percent Complete By Labor Units.

No

SummaryPlannedCost Summary Planned Cost. No

SummaryPlannedDuration Summary Planned Duration. No

SummaryPlannedExpenseCost Summary Planned Expense No


65


Cost.

SummaryPlannedFinishDate Summary Planned Finish Date. No

SummaryPlannedLaborCost Summary Planned Labor Cost. No

SummaryPlannedLaborUnits Summary Planned Labor Units.

No

SummaryPlannedMaterialCost Summary Planned Material Cost.

No

SummaryPlannedNonLaborCost Summary Planned Non Labor Cost.

No

SummaryPlannedNonLaborUnits Summary Planned Non Labor Units.

No

SummaryPlannedStartDate Summary Planned Start Date. No

SummaryPlannedValueByCost Summary Planned Value By Cost.

No

SummaryPlannedValueByLaborUnits Summary Planned Value By Labor Units.

No

SummaryProgressFinishDate Summary Progress Finish Date.

No

SummaryRemainingDuration Summary Remaining Duration. No

SummaryRemainingExpenseCost Summary Remaining Expense Cost.

No

SummaryRemainingFinishDate Summary Remaining Finish Date.

No

SummaryRemainingLaborCost Summary Remaining Labor Cost.

No

SummaryRemainingLaborUnits Summary Remaining Labor Units.

No

SummaryRemainingMaterialCost Summary Remaining Material Cost.

No

SummaryRemainingNonLaborCost Summary Remaining Non Labor Cost.

No

SummaryRemainingNonLaborUnits Summary Remaining Non Labor Units.

No

SummaryRemainingStartDate Summary Remaining Start Date.

No

SummaryRemainingTotalCost Summary Remaining Total No


66


Cost.

SummarySchedulePercentComplete Summary Schedule Percent Complete.

No

SummarySchedulePercentCompleteByLaborUnits

Summary Schedule Percent Complete By Labor Units.

No

SummarySchedulePerformanceIndexByCost

Summary Schedule Performance Index By Cost.

No

SummarySchedulePerformanceIndexByLaborUnits

Summary Schedule Performance Index By Labor Units.

No

SummaryScheduleVarianceByCost Summary Schedule Variance By Cost.

No

SummaryScheduleVarianceByLaborUnits

Summary Schedule Variance By Labor Units.

No

SummaryScheduleVarianceIndex Summary Schedule Variance Index.

No

SummaryScheduleVarianceIndexByCost

Summary Schedule Variance Index By Cost.

No

SummaryScheduleVarianceIndexByLaborUnits

Summary Schedule Variance Index By Labor Units.

No

SummaryStartDateVariance Summary Start Date Variance. No

SummaryToCompletePerformanceIndexByCost

Summary To Complete Performance Index By Cost.

No

SummaryTotalCostVariance Summary Total Cost Variance. No

SummaryTotalFloat Summary Total Float. No

SummaryUnitsPercentComplete Summary Units Percent Complete.

No

SummaryVarianceAtCompletionByLaborUnits

Summary Variance At Completion By Labor Units.

No

TotalBenefitPlan Total Benefit Plan. No

TotalBenefitPlanTally Total Benefit Plan Tally. No

TotalFunding Total Funding. No

TotalSpendingPlan Total Spending Plan. No

TotalSpendingPlanTally Total Spending Plan Tally. No

UnallocatedBudget Unallocated Budget. No


67


UndistributedCurrentVariance Undistributed Current Variance.

No

Estimate

Description: Used to create multiple project estimates and identify the preferred scenario.


Amount Amount No







Status Status No

Title Title No

EstimateDetail

Description: Line items for Estimate


Amount Amount No





LineNo Line No. No





68





TabId Tab Name No


ExchangeRate

Description: Exchange Rate allows the use of multiple currencies within a project for cost purposes and are defined at the Company level. ExchangeRate would be used to define the current exchange rate for a currency as compared to the base currency of the Company.



CurrencyCode Currency Code No



Rate Currency Exchange Rate No

ExpenseCategory

Description: Expense categories are used to categorize project expenses. They are used for standardizing expenses and for rolling up expenses across projects.


ExpenseCategory The Expense Category Name. No



69

FinancialPeriod

Description: Financial periods are used to provide accurate display and reporting of actual units and costs. Financial periods may not overlap each other and do not have to be contiguous.


EndDate The end date of the financial period. No

Name The name of the financial period. No

ObjectId The unique ID of the financial period. No

StartDate The start date of the financial period. No

FundAppropriation

Description: Fund accounts as assigned to projects.


Amount Amount No







Status Status No

Title Title No

FundAppropriationDetail

Description: Line Items for Fund Appropriation


Amount Amount No




70




LineNo Line No. No







TabId Tab Name No


Invoice

Description: A general process for requesting and approving payments against commitments (invoice at the WBS or breakdown level do not calculate retainage or stored materials)


Amount Amount No





DueDate Due Date No






Status Status No

Title Title No


71

InvoiceDetail

Description: Line items for invoice


Amount Amount No


BreakDown Break Down No



LineNo Line No No







RefNum Reference Number No

ScheduledValue Scheduled Value No


TabId Tab Name No


JournalEntry

Description: A process for adjusting spends line items. Most commonly used to reassign costs to alienate cost centers or GL code. Generic spend to transfer across cost codes.


Amount Amount No






72




Status Status No

Title Title No

JournalEntryDetail

Description: Line items for Journal Entry


Amount Amount No





LineNo Line No. No







TabId Tab Name No


Location

Description: The location is used to store address information including latitude and longitude. Locations can be assigned to resources, projects and/or activities.


AddressLine1 The first line of the address with street number and street name.

No


73


AddressLine2 The second line of the address with street number and street name.

No

City The city name of the address. No

Country The country of the address. No

CountryCode The country code of the address. No

Latitude The latitude of the location. No

LocationCode The code that identifies this location. No

Longitude The longitude of the location. No

Municipality The municipality name of the address. No

Name The name of the location. No


PostalCode The postal code of the address. No

State The state name of the address. No

StateCode The state abbreviation of the address. No

NotebookTopic

Description: The NotebookTopic Object


AvailableForActivity The flag indicating that the topic will be available to assign to activities.

No

AvailableForEPS The flag indicating that the topic will be available to assign to EPS.

No

AvailableForProject The flag indicating that the topic will be available to assign to projects.

No

AvailableForWBS The flag indicating that the topic will be available to assign to WBS.

No

Name The name of the NotebookTopic. No

ObjectId The unique ID of the NotebookTopic. No


74

Payment

Description: BP to hold Checks Processed Information from Financial System.


Amount Amount No







Status Status No

Title Title No

PaymentApplication

Description: A process to track your payment information using a standard payment application method (for example, tracking retainage, stored materials, past payments, etc.)


Amount Amount No





DueDate Due Date No






Status Status No

Title Title No


75

PaymentApplicationDetail

Description: Line items for Payment Application


Amount Amount No





LineNo Line No No










TabId Tab Name No


PaymentApplicationtoOwner

Description: A payment application that is raised by a contractor to the owner in order for the contractor to receive payment.



Amount Amount No



76





LineNo Line No No










TabId Tab Name No


PaymentApplicationtoOwnerDetail

Description: Line Items for Payment Applications to Owner.



Amount Amount No





LineNo Line No No




77









TabId Tab Name No


PaymentDetail

Description: Line Items for Payment


Amount Amount No





LineNo Line No. No







TabId Tab Name No



78

PaymentFromOwner

Description: A record of the actual payments a contractor will have received from the owner based on the payment application they presented to the owner.



Amount Amount No







Status Status No

Title Title No

PaymentFromOwnerDetail

Description: Line Items for Payments From Owner



Amount Amount No





LineNo Line No. No




79






TabId Tab Name No


POAmendment

Description: Approval process for purchase order changes


Amount Amount No







DueDate Due Date No







Status Status No

Title Title No


80

POAmendmentDetail

Description: Line items for PO Amendment


Amount Amount No



LineNo Line No No










TabId Tab Name No


PotentialChangeOrder

Description: Contractor initiated potential change order.


Amount Amount No







Status Status No


81


Title Title No

PotentialChangeOrderDetail

Description: Line items for Potential Change Order


Amount Amount No





LineNo Line No. No







TabId Tab Name No


Project

Description: A project is a temporary endeavor undertaken to create a unique product, service, or result. Projects usually contain a work breakdown structure (WBS) and activities.


ActivityDefaultCalendarCode The default activity calendar code

No

ActivityDefaultCalendarName The name of the Activity Default Calendar of this project.

No


82


ActivityDefaultCalendarObjectId The unique id of the Activity Default Calendar of this project.

No

ActivityDefaultDurationType Indicates the activity default duration type of the activity..

No

ActualCost The actual cost of the project No

ActualDuration The actual duration of the project.

No

AcutalFinishDate The date on which the project is actually finished.

No

ActualStartDate The date on which the project is actually started.

No

AnnualDiscountRate The annual discount rate value of the project.

No

AnticipatedFinishDate The anticipated finish date of the project.

No

AnticipatedStartDate The anticipated start date of the project.

No

AtCompletionCost The at completion cost of the project.

No

BusinessSegment A Project Code field to define the Business Segment of the project.

No

BusinessUnit Organization Hierarchy-Business Unit

No

CalculateFloatBasedOnFinishDate

The flag that indicates how each activity's float will be calculated with respect to other projects in the scheduling batch. This setting only has an effect when scheduling multiple projects at the same time

No

Comments A Project UDF to define additional comments for the project.

No

ComputeTotalFloatType The method for calculating total float for all activities.

No

ConsiderForFinances Consider for Finances flag. No


83


CostPerformanceIndex The cost performance index of the project.

No

CostVariance The cost variance of the project. No

CriticalActivityFloatThreshold The maximum float time for activities before they are marked critical.

No

CriticalActivityPathType Indicates Activity critical path type.

No

CriticalFloatThreshold The option used for setting the critical float threshold value when scheduling projects.

No

CurrencyCode Project currency. No

CurrentBaselineProjectObjectId The current baseline project objectId of the project.

No

CurrentBudget The current budget of the project.

No

DataDate Data date of the project. No

DatesDuration External mode- Dates Duration. No

DefaultLaborExpenseType Default expense type. No

Description The description of the project. No

Division Organization Hierarchy - Division.

No

DurationEffort External mode- Duration Effort No

EarnedValueCost The earned value cost of the project.

No

EBSBudgetCurrentCost Current Budget Project Level No

EBSBudgetCurrentQuantity A project UDF to define BudgetCurrentQuantity.

No

EBSBudgetOriginalCost Original Budget Project Level No


84


EBSBudgetOriginalQuantity A project UDF to define BudgetCurrentQuantity.

No

EBSBudgetProposedCost Proposed Budget Project Level No

EBSBudgetProposedQuantity A project UDF to define BudgetProposedQuantity.

No

EBSBudgetStatusCode A project UDF to define BudgetStatusCode.

No

EBSBudgetVersionName A project UDF to define BudgetVersionName.

No

EBSBudgetVersionNumber A project UDF to define BudgetVersionNumber.

No

EBSCalendarWorkingHours

Calendar mulitiplier for days to hours conversion days as defined in P6. Contains the numeric value representing the working hours in a day.

No

EBSETCurrencyCode EBS currency code for ET. No

EBSEFTinTemplateId EBS financial template ID for ET.

No

EBSPlannedCost A project UDF to define EBSPlannedCost.

No

EBSProjectOrgName A project UDF to define EBSProjectOrgName.

No

EBSProjectStatus A project UDF to define EBSProjectStatus

No

EBSProjectType A project UDF to define EBSProjectType.

No

EffortCost External mode- Effort Cost No

EMailNotificationFlag Email notification flag No

EstimateAtCompletionCost The estimate at completion cost of the project.

No

EstimateToCompletionCost The estimate to completion cost of the project.

No


85


FinanceApprvoalTemplate Finance approval template No

FinanceEditMode Finance edit mode No

FinanceLockDate Project finance lock date No

FinanceTemplateid Finance template No

FinanceTrackStartDate Finance tracking start month No

FinishDate The finish date of the project. No

ForecastCost Initial Forecast - Cost No

ForecaseGroup4 Initial forecast - Group 4 No

ForecastGroup5 Initial forecast - Group 5 No

ForecastNonRollup Initial forecast - Nonrollup No

ForecastTotal Initial forecast - Total No

FunctionalArea Functional area No

GracePeriodForCompletedActiitiesGrace period for completed activities in timesheet

No

GracePeriodForFutureActiities Grace period for future activities in timesheet

No

Id The short code of the Project No

IgnoreOtherProjectRelationships

The option used by the scheduler for treating activity relationships between projects when scheduling.

No

InitialForecast Initial forecast - Savings No

IntegratedType

The indicator that determines whether the resource is integrated with an Enterprise Resource Planning (ERP) system. 'Fusion' indicates the resource is integrated with Oracle Fusion. 'ERP' indicates the resource is integrated with another ERP system.

No


86


IsCapitalizationEnabled Is capitalization enabled flag No

IsCapitalized Is capitalized flag No

IsETCEnabledForTS ETC enabled for timesheets flag

No

IsETCRequiredForTS ETC required for timesheets flag

No

IsFinanceLockGlobal Global finance lock flag No

IsLaborExpenseMandatory Labor Expense mandatory flag No

Keywords Project Keywords No

LimitMultipleFloatPaths The number of critical float paths to calculate.

No

Location Organization hierarchy - Location

No

LocationCode The code of the location assigned to the project.

No

LocationId Location ID No

LocationName The name of the location assigned to the project.

No

LocationObjectId The unique ID of the location assigned to the project.

No

MakeOpenEndedActivitiesCritical

The option used by the scheduler for automatically leveling resources when scheduling projects.

No

MaximumMultipleFloatPaths The number of critical float paths to calculate

No

MultipleFloatPathsEnabled

The Boolean value that indicates whether multiple critical float paths (sequences of activities) should be calculated in the project schedule.

No

MultipleFloatPathsEndingActivityObjectId

The activity in the WBS that you want to represent the end of the float paths.

No

MultipleFloatPathsUseTotalFloat The Boolean value that decides whether or not to use total float in multiple float path

No


87


calculations.

MustFinishByDate The expected completion date of the project.

No

Name The name of the Project No

NetPresentValue The net present value of the project.

No


No

OriginalBudget The original budget of the project.

No

OriginalProjectObjectId The unique ID of the original project. It is a baseline project if this field is not null.

No

OutOfSequenceScheduleType

The type of logic used to schedule the progressed activities: 'Retained Logic', 'Progress Override', or 'Actual Dates'.

No

Owner Owner of the project No

ParentEPSId The parent eps id of the project. No

ParentEPSObjectId The unique ID of the parent EPS of this project.

No

PaybackPeriod The payback period of the project.

No

PCS Project initiative No

PercentComplete Project percent completion value

No

PercentCompleteType Project percent completion type No

PlannedBudget The planned budget of the project.

No

PlannedDuration The planned duration of the project.

No

PlannedStartDate The expected start date of the project.

No

PlannedValueCost The summary planned value by cost of the project.

No


88


PrimeWorkspace A Project Code fied to define the Prime Workspace of the Project.

No

Priority Priority No

Process Process No

Product Product No

ProjectScheduleType Schedule type of the project - Valid values are 'Duration' or 'Resource' or 'Cost'.

No

ProjectSource Project source No

ProjectType Project type No

PropertyType The project property name associated with the scheduling of projects.

No

ProposedBudget The proposed budget of the property.

No

Region Organization hierarchy- Region No

RelationshipLagCalendar The calendar used to calculate the lag between predecessors and successors for all activities.

No

RemainingDuration The remaining duration of the project.

No

RemainingTotalCost The remaining total cost of the project.

No

ResourceComputationEnable Resource computation enabled flag

No

ReturnInvestment The return on investment of the project.

No

RiskMatrixCode The code of the risk matrix. No

RiskMatrixName The name of the associated risk matrix.

No

RiskScore The risk score of the project. No


89


Roadmap Project roadmap No

SchedulePerformanceIndex The schedule performance index of the project.

No

ScheduleVariance The schedule variance of the project.

No

StartDate The start date of the project. No

StartToStartLagCalculationType

The method used to calculate lag when a start-to-start relationship exists and the predecessor starts out of sequence.

No

Status

The status of the project. valid values are PLANNED, ACTIVE, INACTIVE, WHAT-IF, REQUESTED.

No

StrategicPriority The strategic priority of the project.

No

SubUnit Organization hierarchy - Sub Unit

No

SummaryRemainingTotalCost The summary remaining total cost of the project.

No

URL The string web site URL of the project.

No

UseExpectedFinishDates

The option used for setting activity finish dates as the expected finish dates when scheduling projects.

No

VarianceFinishDate The variance finish date of the project.

No

VarianceStartDate The variance start date of the project.

No

VCPProjectObjectId VCP Project Object ID No


90

ProjectCode

Description: Project codes are user-defined codes to classify and categorize projects across the enterprise.


CodeTypeName The name of the project code type. No

CodeTypeObjectId

The unique ID of the project code type. No

CodeValue The value of the project code. No

Description The description of the project code. No


ParentId The short code that uniquely identifies the parent Project code.

No

ParentObjectId The unique ID of the parent project code. No

SequenceNumber

The sequence number for sorting. No

Weight The weight for this project code. No

ProjectCodeType

Description: Project code types provide a way of classifying project codes. Project codes are user-defined codes to classify and categorize projects across the enterprise.


Length The maximum number of characters allowed for values of this project code.

No

MaxCodeValueWeight The maximum weight of the code values for this project code type.

No

Name The name of the project code type. No


Weight The weight for this project code type. No

ProjectFinance

Description: EnterpriseTrack Project Finance.


91


FinanceDataType

Finance Data Type ( current / snapshot / structure )

Current - Indicates data from the current project finance table.

Snapshot - This indicates data from a snapshot of the project finance table.

Structure - Indicates metadata that describes the project finance table and its structure.

No

FinanceEditMode

Finance Edit Mode ( M / Y / A ) This is to be used only when editing.

M Finance Mode: Monthly

Y Finance Mode: Yearly

A Finance Mode: Aggregate

No

FinanceSearchMode

Finance Search Mode ( M / Y / A ). This is to be used only when searching.

M Finance Mode: Monthly

Y Finance Mode: Yearly

A Finance Mode: Aggregate

No

FinanceTemplateId The name of the project's finance template. No

FinanceTemplateVersionId

The version of the project's finance template. No

FromMonth

From (Start) Month when Searching or Updating. Applicable only if fin_search_mode or fin_edit_mode = M. (YYYY/MM Format) The element level period must be within range of from_month and to_month

No

FromYear

From (Start) Year when Searching or Updating. Applicable only if fin_search_mode or fin_edit_mode = Y. (YYYY Format) The element level period must be within range of from_year and to_year.

No


OperationType Operation Type. Specifies the operation being performed.

No



92


ToMonth

To (End) Month when Searching or Updating. Applicable only if fin_search_mode or fin_edit_mode = M. (YYYY/MM Format) The element level period must be within range of from_month and to_month

No

ToYear

To (End) Year when Searching or Updating. Applicable only if fin_search_mode or fin_edit_mode = Y. (YYYY Format) The element level period must be within range of from_year and to_year.

No


Description: EnterpriseTrack Project Finance Element


DisplayName Display Name of the element. No

ElementClass

Classification of element. This indicates the element's class within the project finance structure.

Total Type: Total (There can be only one instance of this type. This is the root for all groups.

Group Element type : Group

Category Element type : Category

Element Element type : Element

No

ElementType Indicates whether the element is currency or some user-specified, non-currency type (such as kilowatts, hours, etc.)

No

Id Element ID No

MultiplicationFactorType

Multiplication Factor Type of the element.

Static Use 'Static' if the value of mf_tag is used to multiply element value to compute parent element value.

Expr Use 'Expr' if the value of mf_tag is evaluated at runtime and its value is used to mulitply element value to compute parent element value.

No


93


MultiplicationFactorValue

Multiplication factor of the element. This indicates its impact (contribution) toward computation of parent element values.

No

NumberOfUnits This represents raw data, if element_type is non currency.

No


ParentId ID of the parent element. This will be empty if element_id is 'Total'.

No

ProjectFinanceObjectId


No


SequenceNumber Sequence of this element within parent. 10, 20, 30, etc.

No

Value

This tag represents actual value of element. If element_type is not currency, it is not editable. It is computed internally from number_of_units.

No


Description: EnterpriseTrack Project Finance Snapshot


IsDefaultSnapshot Indicates whether or not this is the default snapshot.

No

IsEditableSnapshot Indicates whether or not snapshot can be edited. Used only during export, as this is a read-only attribute.

No


ProjectFinanceObjectId


No


SnapshotCreatedBy Login ID of user who created snapshot. No

SnapshotCreatedDate

Date on which snapshot was created. No

SnapshotDescription Snapshot Description No


94


SnapshotName Snapshot Name No

SnapshotUpdatedBy Login ID of user who last updated snapshot. No

SnapshotUpdatedDate

Date on which snapshot was last updated. No

ProjectInformation

Description: Project attribute information








Status Status No

Title Title No

ProjectResource

Description: Primavera's resource planning feature allows you to do high-level project planning for future project or project that does not require resource assignments at the activity level.




ResourceName The name of the associated resource. No

ResourceObjectId The unique ID of the associated resource. No

WBSObjectId The unique ID of the associated WBS. No


95

PurchaseOrder

Description: To track money committed to spend (General Spends type Base Commit)


Amount Amount No







DueDate Due Date No






Status Status No

Title Title No

PurchaseOrderDetail

Description: Line items for Purchase Order


Amount Amount No



LineNo Line No No






96







TabId Tab Name No


Relationship

Description: A relationship defines how an activity relates to the start or finish of another activity or assignment. These relationships, which form the logic of the project network, are used together with activity durations to determine schedule dates.


Lag

The time lag of the relationship. This is the time lag between the predecessor activity's start or finish date and the successor activity's start or finish date, depending on the relationship type.

No


No

PredecessorActivityId The unique ID of the predecessor activity.

No

PredecessorActivityObjectIdThe unique ID of the predecessor activity.

No

PredecessorActivityType

The type of the predecessor activity, either 'Task Dependent', 'Resource Dependent', 'Level of Effort', or 'Milestone'.

No

PredecessorProjectId The unique ID of the project that owns the predecessor activity.

No

PredecessorProjectObjectIdThe unique ID of the project that owns the predecessor activity.

No

SuccessorActivityId The unique ID of the successor activity. No

SuccessorActivityObjectId The unique ID of the successor activity. No


97


SuccessorActivityType

The type of the successor activity, either 'Task Dependent', 'Resource Dependent', 'Level of Effort', or 'Milestone'.

No

SuccessorProjectId The unique ID of the project that owns the successor activity.

No

SuccessorProjectObjectId The unique ID of the project that owns the successor activity.

No

Type The type of relationship: 'Finish to Start', 'Finish to Finish', 'Start to Start', or 'Start to Finish'.

No

RequestForSubstitution

Description: A change of identical material or equipment.









Status Status No

Title Title No

RequestForSubstitutionDetail

Description: Line items for Request For Substitution


IssueDate Issue Date No

LineItemStatus Line Item Status No


98


LineNo Line No. No

Name Name No





Status Status No

Title Title No

Resource

Description: Resources include labor, nonlabor, and materials that are used for activities across all projects.


BusinessUnit A Resource Code field to define the Business Unit of the Resource.

No

CalculateCostFromUnits

The option that determines whether any new assignments for this resource will have its costs recalculated whenever any quantity changes occur.

No


CalendarName The name of the calendar that is assigned to the resource.

No

CalendarObjectId The unique ID of the calendar that is assigned to the resource.

No

DefaultUnitsPerTime The Default units/time setting for resource.

No

DepartmentId A Resource UDF to define the Department Id of the Resource.

No

EmailAddress The resource's email address. No

EmployeeId The resource identifier within the organization, typically the employee number or social security number.

No

Id The unique identifier of the Resource No


99


IsActive The option that determines whether the resource is active. A value of true indicates the resource is active.

No

IsOverTimeAllowed The option that determines whether overtime is allowed to be entered into a timesheet for the resource.

No

LocationCode The code of the location assigned to the resource.

No

LocationName The name of the location assigned to the resource.

No

LocationObjectId The unique ID of the location assigned to the resource.

No

Name The name of the resource. No

ObjectId The unique ID for the Resource which is generated by the Primavera Data Integration application.

No

OfficePhone The resource's work phone number. No

OtherPhone Other phone for the resource. No

OvertimeFactor The overtime factor used to compute the overtime price for the resource.

No

ParentObjectId The unique ID of the parent resource of this resource in the hierarchy.

No

PrimaryRoleId The short code that uniquely identifies the primary role for this resource.

No

ResourceType The indicator that determines the resource type. Valid values are LABOR, NON_LABOR, MATERIAL.

No

Title The title of the resource. No

UnitOfMeasureAbbreviation

The unit of measure for a resource. No

ResourceAssignment

Description: Resource assignments track the work of resources or roles that are performing various activities.


100


ActivityId The short ID that uniquely identifies the activity within the project.

No

ActivityObjectId The unique ID of the activity to which the resource is assigned.

No

ActivityType The type of the activity, either 'Task Dependent', 'Resource Dependent', 'Level of Effort', or 'Milestone'.

No

ActualCost A Resource Assignment field to define Actual Cost.

No

ActualRegularUnits

The actual non-overtime units worked by the resource on this activity. This value is computed from timesheets when project actuals are applied or may be entered directly by the project manager.

No

ActualUnits The actual non-overtime plus overtime units worked by the resource on this activity.

No

AssignmentCode The code that identifies this assignment

No

AtCompletionUnits The sum of the actual plus remaining units for the resource assignment on the activity.

No

EBS_TA_DISPLAY_FLAG EBS_TA_DISPLAY_FLAG No

EBSBudgetCurrentCost A Resource Assignment UDF to define BudgetCurrentCost.

No

EBSBudgetCurrentQuantity A Resource Assignment UDF to define BudgetCurrentQuanttity.

No

EBSBudgetOriginalCost A Resource Assignment UDF to define BudgetOriginalCost.

No

EBSBudgetOriginalQuantity A Resource Assignment UDF to define BudgetOriginalQuantity.

No

EBSBudgetProposedCost A Resource Assignment UDF to define BudgetProposedCost.

No

EBSBudgetProposedQuantity A Resource Assignment UDF to define BudgetProposedQuantity.

No

EBSBudgetStatusCode A Resource Assignment UDF to define BudgetStatusCode.

No


101


EBSBudgetVersionName A Resource Assignment UDF to define BudgetVersionName.

No

EBSBudgetVersionNumber A Resource Assignment UDF to define BudgetVersionNumber.

No

EBSPlannedCost A Resource Assignment UDF to define EBSPlannedCost.

No

IsActivityFlagged

The flag that indicates whether the resource who is assigned to the activity assignment has flagged the activity as important to the resource.

No

IsPrimaryResource The flag that indicates whether this resource is the activity's primary resource.

No


No


PlannedDuration

The planned working time for the resource assignment on the activity, from the resource's planned start date to the planned finish date.

No

PlannedFinishDate

The date the resource is scheduled to finish working on the activity. This date is computed by the project scheduler but can be updated manually by the project manager.

No

PlannedLag

The planned time lag between the activity's planned start date and the resource's planned start date on the activity.

No

PlannedStartDate

The date the resource is scheduled to begin working on the activity. This date is computed by the project scheduler but can be updated manually by the project manager.

No

PlannedUnits The planned units of work for the resource assignment on the activity.

No

PlannedUnitsPerTime The planned units per time at which the resource is to perform work on this activity.

No


102


ProjectId The short code that uniquely identifies the project.

No


RateSource

The value that indicates which price/unit will be used to calculate costs for the assignment, such as 'Resource', 'Role', and 'Override'.

No

RemainingUnits The remaining units of work to be performed by this resource on this activity.

No

ResourceId The name that uniquely identifies the resource.

No


ResourceObjectId The unique ID of the associated resource.

No

ResourceType The resource type: 'Labor', 'Nonlabor', or 'Material'.

No

RoleId The short code that uniquely identifies the role.

No

RoleObjectId The unique ID of the associated role. No

RolledupWBSObjectId Rolled up WBS key after filtering either by levels or tagging

No

TotalActualCost A Resource Assignment UDF to store Total Actual Cost for the Resource Assignment.

No

TotalCommitmentCost A Resource Assignment UDF to store Total Commitment Cost for the Resource Assignment.

No

TotalPlannedCost A Resource Assignment UDF to store Total Planned Cost for the Resource Assignment.

No

VCPPlannedStartDate A field to check if Resource Assignment VCP Planned StartDate

No

VCPRasDemandPeggedAvldate

No

VCPRasDemandPeggedOrderN No


103


umber

VCPRasDemandPeggedOrderType

No

VCPRasDemandSupplyFlag No

VCPRasInventoryOrgCode VCP Resource Assignment Inventory Organization Code (UDF)

No

VCPRasSelection A field to check if Resource Assignment is to be selected in VCP demand (YES/NO)

No

VCPRasSelectionCode A field to check if Resource Assignment is to be selected in VCP demand (YES/NO)

No

VCPRasSupplyActualStartDate No

VCPRasSupplylDockDate No

VCPRasSupplyDueDate No

VCPRasSupplyItemId No

VCPRasSupplyItemName No

VCPRasSupplyOrderDate No

VCPRasSupplyOrderNumber No

VCPRasSupplyOrderType No

VCPRasSupplyOrganization No

VCPRasSupplyPeggedOrderNumber

No

VCPRasSupplyProjectId No

VCPRasSupplyQuantity No

VCPRasSupplyShipDate No

VCPRasSupplyStartDate No

VCPRasSupplyTaskId No

VCPRasSupplyStartDate No

VCPRasSupplyUpdatedArrivalDate

No


104


VCPResourceAssignmentObjectId

VCP Resource Assignment Object Id No

WBSObjectId WBS key No

ResourceCode

Description: Resource codes are user-defined codes to classify and categorize resources across the enterprise.


CodeTypeName The name of the resource code type. No

CodeTypeObjectId The unique ID of the resource code type. No

CodeValue The value of the resource code. No

Description The description of the resource code. No


ParentObjectId The unique ID of the parent resource code. No

ResourceCodeType

Description: Resource code types provide a way of classifying resource codes. Resource codes are user-defined codes to classify and categorize resources across the enterprise.


Length The maximum number of characters allowed for values of this resource code.

No

Name The name of the resource code type. No


ResourceCurve

Description: Resource curves enable you to specify how you want resource units or costs spread over the duration of an activity.


105


CurveData The 21 point curve data. No

IsDefault The flag that indicates the default curve. No

Name The name of the resource curve. No


ResourceRate

Description: Resource rates provide a way of specifying multiple resource prices and maximum units per time values that vary over time.


EffectiveDate The effective time period of Resource Rate. No

MaxUnitsPerTime The maximum work units per time this resource can perform on all their assigned activities.

No


PricePerUnit The non-overtime price per time for the resource.

No

PricePerUnit2 The non-overtime price per time for the resource.

No


No


No


No


ResourceRole

Description: A resource role object represents an association between a resource object and a role object.




106


Proficiency The resource's profiiciency at performing this role.

No

ResourceId The short code that uniquely identifies the resource.

No

ResourceName The name of the resource. No

ResourceObjectId The unique ID of the resource. No

RoleId The short code that uniquely identifies the role. No

RoleName The name of the role. No

RoleObjectId The unique ID of the role. No

Risk

Description: The risk object represents a probabilistic event or condition which if it occurs has an impact on the project.


Cause The description of the cause of the risk. No

Description The description of the risk. No

Effect The description of the risk's effect on the project.

No

Id The ID of the risk. Must be unique within a project.

No

IdentifiedDate The date this risk was identified. No

Name The name of the risk. Does not need to be unique.

No




ResponseTotalCost The total estimated cost for the risk. No

Status The current status of the risk. Valid values are 'Proposed', 'Open', 'Rejected', 'Managed', and 'Impacted'.

No

Type The type of the risk. Valid values are 'Threat' and 'Opportunity'.

No


107

RiskAndIssue

Description: A log for documenting, tracking, and estimating impacts of open issues and risks; Log of items that may impact schedule/scope/cost.


Amount Amount No







Status Status No

Title Title No

RiskAndIssueDetail

Description: Line items for Risk and Issue.


Amount Amount No





LineNo Line No. No








108


TabId Tab Name No


RiskImpact

Description: The risk impact object stores the pre-response qualitative value assigned to a risk for each of the risk thresholds.








RiskThresholdCode The code of the risk threshold. No

RiskThresholdLevelCode The short name of the associated risk threshold level.

No

RiskThresholdLevelName The name of the associated risk threshold level.

No

RiskThresholdLevelObjectId

The unique ID of the associated risk threshold level.

No

RiskThresholdName The name of the associated risk threshold.

No

RiskThresholdObjectId The unique ID of the associated risk threshold.

No

RiskMatrix

Description: The risk matrix object contains the name and description of each probability and impact diagram (PID). The Risk Matrix is then used to qualitatively assess each risk and assign a score.


109


Code The code of the risk matrix. No

Description The description of the risk matrix. No

ImpactThresholdLevel

The number of levels for the impact thresholds assigned to the risk scoring matrix. This impact level with the probability level determines the size of the matrix.

No

IsActive

The indication of whether the response plan is currently active for the associated risk. Only one response plan can be active at a given time for a risk.

No

Name The name of the risk matrix. No


ProbabilityThresholdLevel

The number of levels for the probability threshold assigned to the risk matrix. This probability level with the impact level determines the size of the matrix.

No

RiskScoringMethod

The calculation method used to determine the risk score. Valid values are 'Highest', 'Average of Impacts', 'Average of Individual Scores'.

No

RiskMatrixScore

Description: The risk matrix score object stores the score values from the probability and impact diagram (PID) of the risk score matrix.




The level number of the probability threshold. Valid numbers are 1-9.

No


RiskMatrixName The name of the associated risk matrix. No

RiskMatrixObjectId The unique ID of the associated risk matrix.

No

Severity1 The first severity level of the Risk Matrix Score.

No


110


Severity1Label The label for the first severity level. No

Severity2 The second severity level of the Risk Matrix Score.

No

Severity2Label The label for the second severity level. No

Severity3 The third severity level of the Risk Matrix Score.

No

Severity3Label The label for the third severity level. No

Severity4 The fourth severity level of the Risk Matrix Score.

No

Severity4Label The label for the fourth severity level. No

Severity5 The fifth severity level of the Risk Matrix Score.

No

Severity5Label The label for the fifth severity level. No

Severity6 The sixth severity level of the Risk Matrix Score.

No

Severity6Label The label for the sixth severity level. No

Severity7 The seventh severity level of the Risk Matrix Score.

No

Severity7Label The label for the seventh severity level. No

Severity8 The eighth severity level of the Risk Matrix Score.

No

Severity8Label The label for the eighth severity level. No

Severity9 The ninth severity level of the Risk Matrix Score.

No

Severity9Label The label for the ninth severity level. No

RiskMatrixThreshold

Description: The risk matrix threshold object creates a relationship between a RiskThreshold object and a RiskMatrix object. This allows a single RiskThreshold object to be associated with multiple RiskMatrix objects.




111




RiskMatrixObjectId The unique ID of the associated risk matrix.

No

RiskThresholdCode The name of the associated risk threshold. No

RiskThresholdName The name of the associated risk threshold. No


No

RiskResponseAction

Description: The risk response action object contains the detailed steps that need to occur to complete the risk response plan. Multiple actions can be associated with one response plan and each action can be linked to an activity in the project.



ActivityName The name of the associated activity. No


ActualCost The actual cost. No

FinishDate The finish date of the risk response action. If an activity is assigned, the risk response action uses the activity finish date.

No

Id The short name of the risk response plan. No

Name The name of the risk response plan. No


PlannedCost The planned cost. No

PlannedFinishDate The planned finish date. No

PlannedStartDate The planned start date. No



RemainingCost The remaining cost associated with the risk response action.

No


112


ResourceId The short name of the associated resource.

No




RiskResponsePlanId The short name of the associated risk response plan.

No

RiskResponsePlanName

The name of the associated risk response plan.

No

RiskResponsePlanObjectId

The unique ID of the associated risk response plan.

No

StartDate The start date of the risk response action. If an activity is assigned, the risk response action uses the activity start date.

No

Status The status of the risk response action. Valid values are 'Proposed', 'Sanctioned', 'Rejected', 'InProgress', and 'Complete'.

No


Description: The risk response action impact object is a post-risk response action qualitative value that is assigned to a risk for each of the risk thresholds.



No

ProjectId The short name of the associated project.

No


No

RiskId The short name of the associated risk.

No

RiskResponseActionId The short name of the associated risk response action.

No

RiskResponseActionName The name of the associated risk response action.

No


113


RiskResponseActionObjectId The unique ID of the associated risk response action.

No


RiskThresholdLevelCode The short name of the associated risk threshold level.

No


No

RiskThresholdLevelObjectId The unique ID of the associated risk threshold level.

No


No


No

RiskResponsePlan

Description: The risk response plan object communicates how the project team plans to address the identified risk.



IsActive


No





ResponseType

The risk response plan type. If the risk is a threat, the valid types are 'Avoid', 'Transfer', 'Reduce', and 'Accept'. If the risk is a opportunity, the valid types are 'Exploit', 'Facilitate', 'Enhance', and 'Reject'.

No




114


RiskThreshold

Description: The risk threshold object contains the name, description, and type of each risk threshold. Risk thresholds provide a mechanism for setting up the criteria that is used to assess the risk.



Name The name of the risk threshold. No


ThresholdType

The type of Risk Threshold. Valid types are 'Probability', 'Tolerance', 'Schedule', 'Cost', 'Relative Schedule', 'Relative Cost' and 'User Defined'.

No

RiskThresholdLevel

Description: The risk threshold level object stores the level information (e.g. Low, Medium, High) for each risk threshold.


Code The 10 character code for the threshold level.

No

Color The Hex representation for the color e.g. 0xFFFFFF.

No

CostRange The cost range of the threshold level. No

Level The valid values are between 0 and 9. Defines a level for the Risk Threshold.

No

Name The 40 character name for the threshold level.

No


ProbabilityRange The probability range of the threshold level. No

Range The user defined range. No



115




No

ScheduleRange The schedule range of the threshold level. No

ThresholdType

The type of risk threshold. Valid types are, 'Probability', 'Tolerance', 'Schedule', 'Cost', 'Relative Schedule', 'Relative Cost' and 'User Defined'.

No

ToleranceRange The tolerance range of the threshold level. No

Role

Description: Roles are project personnel job titles or skills, such as mechanical engineer, inspector, or carpenter. They represent a type of resource with a certain level of proficiency rather than a specific individual.



The option that indicates whether costs and quantities are linked, and whether quantities should be updated when costs are updated.

No

Description The responsibilities for the role. No

Id The unique identifier of the Role No

Name The name of the resource or role. No


ParentObjectId The unique ID of the parent role of this role in the hierarchy.

No

RoleLimit

Description: Role limits define the limits of the maximum work units per time for a Role in a time period.


EffectiveDate The effective date for the role maximum units No


116


per time.

MaxUnitsPerTime the maximum work units per time this role can perform on all their assigned activities.

No



RoleRate

Description: Role rates enable you to select a predefined price per unit for cost calculating when assigning the role to an activity.



PricePerUnit The non-overtime price per time for the resource. No

PricePerUnit2 The non-overtime price per time for the resource. No





ShellList

Description: Shell List


Description The description of the project No

Id The short code of the Project. No

Name The name of the project. No

ObjectId The unique identifier of the project No

PlannedStartDate The expected start date of the Project. No

ProjectScheduleType Schedule type of the project. Valid values are "Duration" or "Resource" or "Cost"

No


117


Status The status of the project No

Timesheet

Description: Used to capture Employee Timesheets (project / non-project hrs)





DueDate Due Date No



Status Status No

Title Title No

WeekPicker Week Of No

TimesheetDetail

Description: Line items for Timesheet


LineNo Line No No


ParentObjectId The unique ID of the timesheet. No



TabId Tab Name No



118

UDFType

Description: User-defined fields (UDFs) enable users to add custom fields and values to the project database.


DataType The data type of the user-defined field: 'Text', 'Start Date', 'Finish Date', 'Cost', 'Double', 'Integer', 'Indicator', or 'Code'.

No


SubjectArea The subject area of the user-defined field. No

Title The name/title of the user-defined field. v

UnitOfMeasure

Description: The unit of measure provides definitions of units of measure for material resources.


Abbreviation the abbreviation of the unit of measure No

Name The name of the unit of measure. No


SequenceNumber The sequence number for sorting. v

Vendor

Description: Company vendor directory





DueDate Due Date No



Status Status No


119


Title Title No


VendorDetail

Description: Line Items for Vendor.


LineNo Line No No


ParentObjectId The unique ID of the timesheet. No



TabId Tab Name No


VendorEvaluation

Description: Document vendor performance for consideration for future work (Simple)





DueDate Due Date No




Status Status No

Title Title No


120

WBS

Description: The project work breakdown structure (WBS) is a hierarchical arrangement of the products and services produced during and by a project. Each element of a WBS may contain more-detailed WBS elements, activities, or both. WBS are hierarchical objects.


AnticipatedStartDate The anticipated start date of WBS, project and EPS elements.

No

AnticipatedFinishDate The anticipated finish date of WBS, project and EPS elements.

No

Code The short name of the WBS. No

CurrentBudget The current budget of the WBS. No

EBSBudgetCurrentCost Current Budget WBS Level No

EBSBudgetCurrentQuantity A WBS UDF to define BudgetCurrentQuantity

No

EBSBudgetOriginalCost Original Budget WBS level No

EBSBudgetOriginalQuantityA WBS UDF to define BudgetOriginalQuantity

No

EBSBudgetProposedCost Proposed Budget WBS level No

EBSBudgetProposedQuantity

A WBS UDF to define BudgetProposedQuantity

No

EBSBudgetStatusCode A WBS UDF to define BudgetStatusCode

No

EBSBudgetVersionName A WBS UDF to define BudgetVersionName

No

EBSBudgetVersionNumber A WBS UDF to define BudgetVersionNumber

No

EBSPlannedCost A WBS UDF to define EBSPlannedCost No

FinishDate The date finish date of the WBS. No

IsWorkPackage Whether this WBS is a work package. No

Name The name of the WBS. No


ParentObjectId The unique ID of the parent WBS of this WBS in the hierarchy.

No

ProjectId The project Id of the WBS. No



121


SequenceNumber The sequence number of the WBS. No

StartDate The start date of the WBS. No

SummaryActualFinishDate Actual Finish Date No

SummaryActualStartDate Actual Start Date No


Planned Finish Date No

SummaryPlannedStartDate Planned Start Date No

TotalActualCost A WBS UDF to store Total Actual Cost for the WBS

No

TotalCommitmentCost A WBS UDF to store Total Commitment Cost for the WBS

No

TotalPlannedCost A WBS UDF to store Total Planned Cost for the WBS

No

VCPWBSObjectId VCP WBS Object ID No

WBSCategoryObjectId The unique wbs category objectIdof the WBS.

No

WBSCategory

Description: As their name implies, WBS categories are used to categorize WBS elements. They are defined globally.



Name The name of the WBS category. No

WBSExpenseSpread

Description: Expense spread data per WBS per expense category.


ActualCost Actual cost. No

AtCompletionCost At completion cost. No


122


EndDate Spread end date. No


The unique ID of ExpenseCategory. No

ExpenseCategoryName ExpenseCategory name. No


PeriodType The type of period for summarized spread data.

No

PlannedCost Planned cost. No

RemainingCost Remaining cost. No

StartDate Spread start date. No

WBSCode WBS Code. No

WBSObjectId The unique ID of WBS. No

WBSResourceSpread

Description: Spread data per WBS per Resource


ActualCost Actual Cost. No

ActualOvertimeCost Actual Overtime Cost. No

ActualOvertimeUnits Actual Overtime Units. No

ActualRegularCost Actual Regular Cost. No

ActualRegularUnits Actual Regular Units. No

ActualUnits Actual Units. No

AtCompletionCost At Completion Cost. No

AtCompletionUnits At Completion Units. No


Limit Limit. No


No

PeriodActualCost Period Actual Cost. No

PeriodActualUnits Period Actual Units. No


123


PeriodAtCompletionCost Period At Completion Cost. No

PeriodAtCompletionUnits Period At Completion Units. No


No

PlannedCost Planned Cost. No

PlannedUnits Planned Units. No

ProjectId Project short name. No


RemainingCost Remaining Cost. No

RemainingLateCost Remaining Late Cost. No

RemainingLateUnits Remaining Late Units. No

RemainingUnits Remaining Units. No

ResourceId Resource short name. No

ResourceObjectId The unique ID of Resource. No

RoleId Role short name. No

RoleObjectId The unique ID of Role. No

StaffedActualCost Staffed Actual Cost. No

StaffedActualOvertimeCost Staffed Actual Overtime Cost. No

StaffedActualOvertimeUnits Staffed Actual Overtime Units. No

StaffedActualRegularCost Staffed Actual Regular Cost. No

StaffedActualRegularUnits Staffed Actual Regular Units. No

StaffedActualUnits Staffed Actual Units. No

StaffedAtCompletionCost Staffed At Completion Cost. No

StaffedAtCompletionUnits Staffed At Completion Units. No

StaffedPlannedCost Staffed Planned Cost. No

StaffedPlannedUnits Staffed Planned Units. No

StaffedRemainingCost Staffed Remaining Cost. No

StaffedRemainingLateCost Staffed Remaining Late Cost. No

StaffedRemainingLateUnits Staffed Remaining Late Units. No

StaffedRemainingUnits Staffed Remaining Units. No



124


WBSCode WBS short name. No


WBSSpread

Description: Summarized spread data per WBS



ActualExpenseCost Actual Expense Cost. No

ActualLaborCost Actual Labor Cost. No

ActualLaborUnits Actual Labor Units. No

ActualMaterialCost Actual Material Cost. No

ActualNonlaborCost Actual Nonlabor Cost. No

ActualNonlaborUnits Actual Nonlabor Units. No

ActualTotalCost Actual Total Cost. No

AtCompletionExpenseCost At Completion Expense Cost. No

AtCompletionLaborCost At Completion Labor Cost. No

AtCompletionLaborUnits At Completion Labor Units. No

AtCompletionMaterialCost At Completion Material Cost. No

AtCompletionNonlaborCost At Completion Nonlabor Cost. No

AtCompletionNonlaborUnits At Completion Nonlabor Units. No

AtCompletionTotalCost At Completion Total Cost. No

BaselinePlannedExpenseCost Baseline Planned Expense Cost.

No

BaselinePlannedLaborCost Baseline Planned Labor Cost. No

BaselinePlannedLaborUnits Baseline Planned Labor Units. No

BaselinePlannedMaterialCost Baseline Planned Material Cost. No

BaselinePlannedNonlaborCost Baseline Planned Nonlabor Cost.

No

BaselinePlannedNonlaborUnits Baseline Planned Nonlabor Units.

No


125


BaselinePlannedTotalCost Baseline Planned Total Cost. No

EarnedValueCost Earned Value Cost. No

EarnedValueLaborUnits Earned Value Labor Units. No


EstimateAtCompletionCost Estimate At Completion Cost. No

EstimateAtCompletionLaborUnits Estimate At Completion Labor Units.

No

EstimateToCompleteCost Estimate To Complete Cost. No

EstimateToCompleteLaborUnits Estimate To Complete Labor Units.

No


No


PeriodActualExpenseCost Period Actual Expense Cost. No

PeriodActualLaborCost Period Actual Labor Cost. No

PeriodActualLaborUnits Period Actual Labor Units. No

PeriodActualMaterialCost Period Actual Material Cost. No

PeriodActualNonLaborCost Period Actual NonLabor Cost. No

PeriodActualNonLaborUnits Period Actual NonLabor Units. No

PeriodAtCompletionExpenseCost Period At Completion Expense Cost.

No

PeriodAtCompletionLaborCost Period At Completion Labor Cost.

No

PeriodAtCompletionLaborUnits Period At Completion Labor Units.

No

PeriodAtCompletionMaterialCost Period At Completion Material Cost.

No

PeriodAtCompletionNonLaborCost Period At Completion NonLabor Cost.

No

PeriodAtCompletionNonLaborUnits Period At Completion NonLabor Units.

No

PeriodAtCompletionTotalCost Period At Completion Total Cost.

No

PeriodEarnedValueCost Period Earned Value Cost. No


126


PeriodEarnedValueLaborUnits Period Earned Value Labor Units.

No

PeriodEstimateAtCompletionCost Period Estimate At Completion Cost.

No

PeriodEstimateAtCompletionLaborUnits

Period Estimate At Completion Labor Units.

No

PeriodPlannedValueCost Period Planned Value Cost. No

PeriodPlannedValueLaborUnits Period Planned Value Labor Units.

No


No

PlannedExpenseCost Planned Expense Cost. No

PlannedLaborCost Planned Labor Cost. No

PlannedLaborUnits Planned Labor Units. No

PlannedMaterialCost Planned Material Cost. No

PlannedNonlaborCost Planned Nonlabor Cost. No

PlannedNonlaborUnits Planned Nonlabor Units. No

PlannedTotalCost Planned Total Cost. No

PlannedValueCost Planned Value Cost. No

PlannedValueLaborUnits Planned Value Labor Units. No



RemainingExpenseCost Remaining Expense Cost. No

RemainingLaborCost Remaining Labor Cost. No

RemainingLaborUnits Remaining Labor Units. No

RemainingLateExpenseCost Remaining Late Expense Cost. No

RemainingLateLaborCost Remaining Late Labor Cost. No

RemainingLateLaborUnits Remaining Late Labor Units. No

RemainingLateMaterialCost Remaining Late Material Cost. No

RemainingLateNonlaborCost Remaining Late Nonlabor Cost. No

RemainingLateNonlaborUnits Remaining Late Nonlabor Units. No

RemainingLateTotalCost Remaining Late Total Cost. No


127


RemainingMaterialCost Remaining Material Cost. No

RemainingNonlaborCost Remaining Nonlabor Cost. No

RemainingNonlaborUnits Remaining Nonlabor Units. No

RemainingTotalCost Remaining Total Cost. No




WorkRelease

Description: Process that is connected to Blanket Purchase Order Business Process that is deployed at company level. This process can be used to write against the Market purchase order.


Amount Amount No







DueDate Due Date No







Status Status No

Title Title No


128

WorkReleaseDetail

Description: Line Items for Work Release


Amount Amount No



LineNo Line No No







RefBPOLineItem




TabId Tab Name No


129

P6 Business Objects List

For the P6 provider, the following business objects are available in the data dictionary. Select a specific business object to review a detailed list of fields supported for that business object.



ActivityCode Activity codes are user-defined codes to classify and categorize activities according to the organization's and project's needs.

ActivityCodeType

Activity codes types provide a way of classifying activity codes. Activity codes are user-defined codes to classify and categorize activities according to the organization's and project's needs.

ActivityExpense Activity expenses are non-resource costs associated with a project and assigned to a project's activities. They are typically one-time expenditures for non-reusable items.

ActivityRisk The activity risk object stores the relationship between a single Activity and a single Risk.

BaselineType BaselineType fields.

Calendar Calendars define the available work hours in each calendar day, and include global, resource, and project types.

CBS CBS business object.

CBSDurationSummary CBSDurationSummary business object.



CostAccount

Cost accounts contain the organization's cost account IDs. Available across all projects, they support tracking of costs and earned value based on the organization's cost account IDs. Cost accounts are hierarchical objects.

Currency Currencies are the monetary units used to store costs for all projects in the database. Monetary units are stored in the database with a base currency but can be viewed in other


130


currencies using the exchange for each currency.

EPS Enterprise Project Structure.

ExpenseCategory Expense categories are used to categorize project expenses. They are used for standardizing expenses and for rolling up expenses across projects.

FinancialPeriod Financial periods are used to provide accurate display and reporting of actual units and costs. Financial periods may not overlap each other and do not have to be contiguous.

Location The location is used to store address information including latitude and longitude. Locations can be assigned to resources, projects and/or activities.

NotebookTopic Notebook topics are used to categorize notes on EPS, project, WBS,and activity objects.

Project A project is a temporary endeavor undertaken to create a unique product, service, or result. Projects usually contain a work breakdown structure (WBS) and activities.


ProjectCodeType Project code types provide a way of classifying project codes. Project codes are user-defined codes to classify and categorize projects across the enterprise.

ProjectResource Primavera's resource planning feature allows you to do high-level project planning for future project or project that does not require resource assignments at the activity level.

Relationship




ResourceCode Resources codes are user-defined codes to classify and categorize resources across the enterprise.


131


ResourceCodeType Resource code types provide a way of classifying resource codes. Resources codes are user-defined codes to classify and categorize resources across the enterprise.

ResourceRate Resource rates specify multiple resource prices and maximum units per time values that vary over time.



RiskMatrix



RiskMatrixThreshold


RiskResponseAction





RiskThreshold



Role

Roles are project personnel job titles or skills, such as mechanical engineer, inspector, or carpenter. They represent a type of resource with a certain level of proficiency rather than a specific individual.


132


RoleRate Role rates enable you to select a predefined price per unit for cost calculating when assigning the role to an activity.


WBS


WBSCategory WBS categories group WBS elements based on a shared attribute. They are defined globally.

WBSExpenseSpread Expense spread data per WBS per ExpenseCategory.

WBSResourceSpread Spread data per WBS per Resource

WBSSpread Summarized spread data per WBS.


133

In This Section

Activity ................................................................................................................... 134 ActivityCode .......................................................................................................... 153 ActivityCodeType .................................................................................................. 154 ActivityExpense ..................................................................................................... 154 ActivityRisk ............................................................................................................ 157 BaselineType ........................................................................................................ 157 Calendar ............................................................................................................... 158 CBS ....................................................................................................................... 161 CBSDurationSummary .......................................................................................... 162 CBSExpenseSpread ............................................................................................. 163 CBSResourceSpread ............................................................................................ 164 CostAccount .......................................................................................................... 166 Currency ............................................................................................................... 167 EPS ....................................................................................................................... 168 ExpenseCategory .................................................................................................. 181 FinancialPeriod ..................................................................................................... 181 Location ................................................................................................................ 182 NotebookTopic ...................................................................................................... 183 Project ................................................................................................................... 183 ProjectCode .......................................................................................................... 199 ProjectCodeType ................................................................................................... 200 ProjectResource .................................................................................................... 201 Relationship .......................................................................................................... 202 Resource ............................................................................................................... 204 ResourceAssignment ............................................................................................ 207 ResourceCode ...................................................................................................... 215 ResourceCodeType .............................................................................................. 216 ResourceRate ....................................................................................................... 217 ResourceCurve ..................................................................................................... 218 ResourceRole ....................................................................................................... 218 Risk ....................................................................................................................... 219 RiskImpact ............................................................................................................ 219 RiskMatrix ............................................................................................................. 220 RiskMatrixScore .................................................................................................... 221 RiskMatrixThreshold .............................................................................................. 222 RiskResponseAction ............................................................................................. 222 RiskResponseActionImpact ................................................................................... 224 RiskResponsePlan ................................................................................................ 224 RiskThreshold ....................................................................................................... 225 RiskThresholdLevel ............................................................................................... 225 Role....................................................................................................................... 226 RoleLimit ............................................................................................................... 227 RoleRate ............................................................................................................... 227 UDFType ............................................................................................................... 228 UnitOfMeasure ...................................................................................................... 229 WBS ...................................................................................................................... 229


134

WBSCategory ....................................................................................................... 239 WBSExpenseSpread ............................................................................................. 240 WBSResourceSpread ........................................................................................... 240 WBSSpread .......................................................................................................... 243

Activity

Description: An activity in P6 EPPM is a unit of work performed during the course of a project.


AccountingVariance

The difference between the planned value of work scheduled and the actual cost of work performed. Computed as accounting variance = planned value - actual cost . A negative value indicates that actual costs have exceeded the scheduled costs.

Yes

AccountingVarianceLaborUnits

The difference between the planned value of work scheduled and the actual work performed. Computed as accounting variance labor units = planned value labor units - actual units.

Yes

ActualDuration


No

ActualExpenseCost The actual costs for all project expenses associated with the activity.

Yes

ActualFinishDate The date on which the activity is actually finished.

No

ActualLaborCost

The actual costs for all labor resources assigned to the activity. If no resources are assigned, computed as the activity actual labor units * project default price / time.

No

ActualLaborUnits The actual units for all labor resources assigned to the activity.

No

ActualMaterialCost The sum of all regular and overtime costs for material resources.

Yes

ActualNonLaborCost The actual costs for all nonlabor resources assigned to the activity. If no resources are assigned, computed as the activity actual

No


135


nonlabor units * project default price / time.

ActualNonLaborUnits The actual units for all nonlabor resources assigned to the activity.

No

ActualStartDate The date on which the activity is actually started.

No

ActualThisPeriodLaborCostThe actual this period labor cost for all labor resources assigned to the activity.

No

ActualThisPeriodLaborUnits

The actual this period labor units (hours) for all labor resources assigned to the activity.

No

ActualThisPeriodMaterialCost

The sum of all material resource costs for the current period.

No

ActualThisPeriodNonLaborCost

The actual this period nonlabor cost for all nonlabor resources assigned to the activity. If no resources are assigned, computed as the activity actual nonlabor units * project default price / time.

No

ActualThisPeriodNonLaborUnits

The actual this period nonlabor units (hours) for all nonlabor resources assigned to the activity.

No

ActualTotalCost

The actual total cost for the activity, including labor resources, nonlabor resources, and project expenses. Actual total cost = actual labor costs + actual nonlabor costs + actual expense costs.

Yes

ActualTotalUnits The sum of Actual Labor Units and Actual Nonlabor Units.

Yes


No

AtCompletionExpenseCost

The sum of the actual plus remaining costs for all expenses associated with the activity. Computed as actual expense cost + remaining expense cost.

Yes

AtCompletionLaborCost

The sum of the actual plus remaining costs for all labor resources assigned to the activity. Computed as actual labor cost + remaining labor cost.

No

AtCompletionLaborUnits

The sum of the actual plus remaining units for all labor resources assigned to the activity. Computed as actual labor units + remaining labor units.

No


136


AtCompletionLaborUnitsVariance

The project baseline planned total labor units minus the estimate at completion labor units.

Yes

AtCompletionMaterialCost The sum of all actual and remaining costs for material resources.

Yes

AtCompletionNonLaborCost

The sum of the actual plus remaining costs for all nonlabor resources assigned to the activity. Computed as actual nonlabor cost + remaining nonlabor cost.

No

AtCompletionNonLaborUnits

The sum of the actual plus remaining units for all nonlabor resources assigned to the activity. Computed as actual nonlabor units + remaining nonlabor units.

No

AtCompletionTotalCost

The total cost at completion for the activity, including labor resources, nonlabor resources, and project expenses. At completion total cost = at completion labor cost + at completion nonlabor cost + at completion expense cost.

Yes

AtCompletionTotalUnits The sum of the actual plus remaining units for the resource assignment on the activity.

Yes

AtCompletionVariance

The difference between the project baseline total cost and the current estimate of total cost. Computed as VAC = BAC - EAC. A negative value indicates an estimated cost overrun. BAC is computed from the current project baseline.

Yes

AutoComputeActuals

The option that determines whether the activity's actual and remaining units, start date, finish date, and percent complete are computed automatically using the planned dates, planned units and the schedule percent complete.

No

Baseline1Duration The duration for the activity in the primary baseline.

Yes

Baseline1FinishDate The current finish date of the activity in the primary baseline.

Yes

Baseline1PlannedDuration

The planned duration for the activity in the primary baseline. Planned duration is the total working time from the activity current start date to the current finish date.

Yes


137


Baseline1PlannedExpenseCost

The planned costs for all project expenses associated with the activity. This field is named Baseline 1 Budgeted Expense Cost in Primavera's Engineering and Construction and Maintenance and Turnaround solutions.

Yes

Baseline1PlannedLaborCost

The cost at completion for all labor resources assigned to the activity in the primary baseline. Computed from the primary baseline at completion labor units.

Yes

Baseline1PlannedLaborUnits

The planned units for all labor resources assigned to the activity. This field is named Baseline 1 Budgeted Labor Units in Primavera's Engineering and Construction and Maintenance and Turnaround solutions.

Yes

Baseline1PlannedMaterialCost

The Planned Material Cost for a primary baseline activity.

Yes

Baseline1PlannedNonLaborCost

The planned costs for all nonlabor resources assigned to the activity. If no resources are assigned, computed as the activity planned nonlabor units * project default price / time.

Yes

Baseline1PlannedNonLaborUnits

The planned units for all nonlabor resources assigned to the activity. This field is named Baseline 1 Budgeted Non Labor Units in Primavera's Engineering and Construction and Maintenance and Turnaround solutions.

Yes

Baseline1PlannedTotalCost

The planned total cost for the activity, including labor resources, nonlabor resources, and project expenses. Planned total cost = planned labor cost + planned nonlabor cost + planned expense cost.

Yes

Baseline1StartDate

The current start date of the activity in the primary baseline. Set to the planned start date until the activity is started, then set to the actual start date.

Yes

BaselineDuration The duration for the activity in the project baseline.

Yes

BaselineFinishDate The current finish date of the activity in the project baseline.

Yes

BaselinePlannedDuration The planned duration for the activity in the Yes


138


project baseline.

BaselinePlannedExpenseCost

The planned costs for all project expenses associated with the activity.

Yes

BaselinePlannedLaborCostThe cost at completion for all labor resources assigned to the activity in the project baseline.

Yes

BaselinePlannedLaborUnits

The planned units for all labor resources assigned to the activity.

Yes

BaselinePlannedMaterialCost

The Planned Material Cost for a project baseline activity.

Yes

BaselinePlannedNonLaborCost

The planned costs for all nonlabor resources assigned to the activity.

Yes

BaselinePlannedNonLaborUnits

The planned units for all nonlabor resources assigned to the activity.

Yes

BaselinePlannedTotalCost The planned total cost for the activity, including labor resources, nonlabor resources, and project expenses.

Yes

BaselineStartDate The current start date of the activity in the project baseline.

Yes

BudgetAtCompletion The planned total cost through activity completion.

Yes

CalendarName The name of the calendar. Yes

CalendarObjectId

The unique ID of the calendar assigned to the activity. Activity calendars can be assigned from the global calendar pool or the project calendar pool.

No

CostPercentComplete The percent complete of costs for all labor resources, nonlabor resources, and expenses for the activity.

Yes

CostPercentOfPlanned The percent complete of planned costs for all labor resources, nonlabor resources, and expenses for the activity.

Yes

CostPerformanceIndex The earned value divided by the actual cost. A value less than 1 indicates that actual cost have exceeded the planned value.

Yes

CostPerformanceIndexLaborUnits

The ratio of the earned value labor units and the actual work performed. Computed as CPI labor units = earned value labor units / actual labor units.

Yes


139


CostVariance

The difference between the earned value and the actual cost of work performed. Computed as CV = earned value - actual costs.

Yes

CostVarianceIndex The ratio of the cost variance and the earned value of work performed. Computed as CVI = cost variance / earned value.

Yes

CostVarianceIndexLaborUnits

The ratio of the cost variance labor units and the earned value of work performed. Computed as CVI labor units = CV labor units / earned value labor units.

Yes

CostVarianceLaborUnits

The difference between the earned value of labor units and the actual cost of labor units. Calculated as CV labor units = earned value planned units - actual units.

Yes

CreateDate The date this activity was created. Yes

CreateUser The name of the user that created this activity.

Yes

DataDate

The current data date for the project. The project status is up to date as of the data date. The data date is modified when project actuals are applied.

Yes

Duration1Variance

The duration between the activity's primary baseline duration and the at complete duration. Computed as primary baseline duration - at completion duration.

Yes

DurationPercentComplete

The percent complete of the activity duration. Computed as (planned duration - remaining duration) / planned duration * 100. Always in the range 0 to 100.

No

DurationPercentOfPlanned


Yes

DurationType

The duration type of the activity. One of 'Fixed Units/Time', 'Fixed Duration and Units/Time', 'Fixed Units', or 'Fixed Duration and Units'.

No


140


DurationVariance

The duration between the activity's project baseline duration and the at complete duration. Computed as project baseline duration - at completion duration.

Yes

EarlyFinishDate

The earliest possible date the activity can finish. This date is computed by the project scheduler based on network logic, schedule constraints, and resource availability.

Yes

EarlyStartDate

The earliest possible date the remaining work for the activity can begin. This date is computed by the project scheduler based on network logic, schedule constraints, and resource availability.

Yes

EarnedValueCost

The portion of the project baseline total cost of the activity that is actually completed as of the project data date. Computed as earned value = BAC * performance % complete.

Yes

EarnedValueLaborUnits

The portion of the project baseline labor units that is actually completed as of the project data date. Computed as labor units earned value = project baseline labor units * performance % complete.

Yes

EBSBudgetCurrentCost EBS_ACT_Budget_Current_Cost No

EBSBudgetCurrentQuantity EBS_ACT_Budget_Current_Qty No

EBSBudgetOriginalCost EBS_ACT_Budget_Original_Cost No

EBSBudgetOriginalQuantity

EBS_ACT_Budget_Original_Qty No

EBSBudgetProposedCost EBS_ACT_Budget_Proposed_Cost No


EBS_ACT_Budget_Proposed_Qty No

EBSBudgetStatusCode EBS_ACT_Budget_Status_Code No

EBSBudgetVersionName EBS_ACT_Budget_Version_Name No

EBSBudgetVersionNumber EBS_ACT_Budget_Version_Number No

EstimateAtCompletionCost

The estimated cost at completion for the activity. Computed as the actual total cost plus the estimate-to-complete cost; EAC = ACWP + ETC.

Yes


141


EstimateAtCompletionLaborUnits

The estimated labor units at completion of the activity. Calculated as actual labor units + estimate to complete labor units.

Yes

EstimateToComplete

The estimated cost to complete the activity. Computed as either the remaining total cost for the activity (remaining total cost), or as PF * (BAC - earned value), depending on the earned-value technique selected for the activity's WBS..

Yes

EstimateToCompleteLaborUnits

The estimated quantity to complete the activity. Computed as either the remaining total units for the activity (remaining total units), or as PF * (BL labor units - earned value), depending on the earned-value technique selected for the activity's WBS.

Yes

ExpectedFinishDate


No

ExpenseCost1Variance The difference between primary baseline expense cost and at completion expense cost.

Yes

ExpenseCostPercentComplete

The percent complete of costs for all expenses associated with the activity. Computed as actual expense cost / at completion expense cost * 100. Always in the range 0 to 100.

Yes

ExpenseCostVariance

The difference between project baseline expense cost and at completion expense cost. Calculated as project baseline expense cost - at completion expense cost (at completion expense cost = actual expense cost + remaining expense cost).

Yes

ExternalEarlyStartDate

The date value that determines the early start date for imported activities with external constraints lost (relations from/to external projects that do not exist in the database).

No

ExternalLateFinishDate The date value that determines the Late Finish Date for imported activities with

No


142


external constraints lost (from/to external projects that do not exist in the database).

Feedback The feedback from the resource. No

FinishDate

The current finish date of the activity. Set to the activity planned finish date while the activity is not started, the remaining finish date while the activity is in progress, and the actual finish date once the activity is completed.

No

FinishDate1Variance

The duration between the finish date in the current project and the primary baseline finish date. Calculated as finish date - primary baseline finish date.

Yes

FloatPath

The integer representing the critical path this activity is on. The value 1 is the most critical path, value 2 is the second most critical path, etc.

Yes

FreeFloat The amount of time the activity can be delayed before delaying the start date of any successor activity.

Yes

GUID The globally unique ID generated by the system.

No

HasFutureBucketData The flag that indicates whether a resource assignment on the activity has future bucket data.

Yes

Id The short ID that uniquely identifies the activity within the project.

No

IsBaseline The Boolean value indicating if this business object is related to a Project or Baseline

Yes

IsCritical

The flag that indicates whether the activity is critical. An activity is critical when its total Float is below the critical duration specified for the project. Delaying critical activities will delay the finish date of the project.

Yes

IsLongestPath The flag that indicates whether an activity is on the longest path.

Yes

IsNewFeedback The flag that indicates that a resource has sent feedback notes about this activity which have not been reviewed yet.

No


143


IsStarred The flag that indicates whether this activity is marked as starred activity.

No

IsTemplate The Boolean value indicating if this business object is related to a template Project.

Yes

IsWorkPackage The flag that indicates whether this activity is the child of a work package WBS.

Yes

LaborCost1Variance

The difference between primary baseline labor cost and at completion labor cost. Calculated as BL labor cost - at completion labor cost.

Yes

LaborCostPercentComplete

The percent complete of costs for all labor resources assigned to the activity. Computed as actual labor cost / at completion labor cost * 100. Always in the range 0 to 100.

Yes

LaborCostVariance

The difference between project baseline labor cost and at completion labor cost. Calculated as BL labor cost - at completion labor cost.

Yes

LaborUnits1Variance

The difference between primary baseline labor units and at completion labor units. Calculated as BL labor units - at completion labor units.

Yes

LaborUnitsPercentComplete

The percent complete of units for all labor resources for the activity. Computed as actual labor units / at completion labor units * 100. Always in the range 0 to 100.

Yes

LaborUnitsVariance

The difference between project baseline labor units and at completion labor units. Calculated as BL labor units - at completion labor units.

Yes

LastUpdateDate The date this activity was last updated. Yes

LastUpdateUser The name of the user that last updated this activity.

Yes

LateFinishDate

The latest possible date the activity must finish without delaying the project finish date. This date is computed by the project scheduler based on network logic, schedule constraints, and resource availability.

Yes


144


LateStartDate

The latest possible date the remaining work for the activity must begin without delaying the project finish date. This date is computed by the project scheduler based on network logic, schedule constraints, and resource availability.

Yes

LessonsLearned An activity note field to store notes. No

LevelingPriority

The activity priority used to prioritize activities in a project when performing resource leveling. Valid values are 'Top', 'High', 'Normal', 'Low', and 'Lowest'.

No

LocationName The name of the location assigned to the activity.

Yes

LocationObjectId The unique ID of the location assigned to the activity.

No

MaterialCost1Variance The primary Baseline Planned Material Cost minus the At Completion Material Cost.

Yes

MaterialCostPercentComplete

The percent complete of costs for all material resources assigned to the activity. Computed as actual nonlabor cost / at completion nonlabor cost * 100. Always in the range 0 to 100.

Yes

MaterialCostVariance The project BaselinePlannedMaterialCost minus the AtCompletionMaterialCost.

Yes

MaximumDuration The maximum duration of the activity. No

MinimumDuration The minimum duration of the activity. No

MostLikelyDuration The most likely duration of the activity. No

Name The name of the activity. The activity name does not have to be unique.

No

NonLaborCost1Variance

The difference between the primary baseline nonlaborcost and at completion nonlabor cost. Calculated as BL nonlabor cost - at completion nonlabor cost.

Yes

NonLaborCostPercentComplete

The percent complete of costs for all nonlabor resources assigned to the activity. Computed as actual nonlabor cost / at completion nonlabor cost * 100. Always in

Yes


145


the range 0 to 100.

NonLaborCostVariance

The difference between the project baseline labor cost and at completion labor cost. Calculated as BL nonlabor cost - at completion nonlabor cost.

Yes

NonLaborUnits1Variance

The difference between the primary baseline nonlabor units and at completion nonlabor units. Calculated as BL nonlabor units - at completion nonlabor units.

Yes

NonLaborUnitsPercentComplete

The percent complete of units for all nonlabor resources for the activity. Computed as actual nonlabor units / at completion nonlabor units * 100. Always in the range 0 to 100.

No

NonLaborUnitsVariance

The difference between the project baseline labor units and at completion labor units. Calculated as BL nonlabor units - at completion nonlabor units.

Yes

NotesToResources The notes from the project manager to the timesheet resources.

No


PercentComplete

The activity percent complete. This value is tied to the activity duration % complete, units % complete, or physical % complete, depending on the setting for the activity's percent complete type.

No

PercentCompleteType The activity percent complete type: 'Physical', 'Duration', or 'Units'.

No

PerformancePercentComplete

The activity performance percent complete. The performance percent complete is used to compute earned value.

Yes

Phase An activity code filed to track the phase of the Activity.

No

PhysicalPercentComplete The physical percent complete, which can either be user entered or calculated from the activity's weighted steps.

No

PlannedDuration The total working time from the activity planned start date to the planned finish date. The planned working time is computed

No


146


using the activity's calendar.

PlannedExpenseCost

The planned costs for all project expenses associated with the activity. This field is named BudgetedExpenseCost in Primavera's Engineering and Construction and Maintenance and Turnaround solutions.

Yes

PlannedFinishDate


No

PlannedLaborCost

The planned costs for all labor resources assigned to the activity. If no resources are assigned, computed as the activity planned labor units * project default price / time.

No

PlannedLaborUnits

The planned units for all labor resources assigned to the activity. This field is named BudgetedLaborUnits in Primavera's Engineering and Construction and Maintenance and Turnaround solutions.

No

PlannedMaterialCost The sum of all material resource costs. Yes

PlannedNonLaborCost

The planned costs for all nonlabor resources assigned to the activity. If no resources are assigned, computed as the activity planned nonlabor units * project default price / time.

No

PlannedNonLaborUnits

The planned units for all nonlabor resources assigned to the activity. This field is named BudgetedNonLaborUnits in Primavera's Engineering and Construction and Maintenance and Turnaround solutions.

No

PlannedStartDate

The date the activity is scheduled to begin. This date is computed by the project scheduler but can be updated manually by the project manager. This date is not changed by the project scheduler after the activity has been started.

No

PlannedTotalCost The planned total cost for the activity, including labor resources, nonlabor

Yes


147


resources, and project expenses. Planned total cost = planned labor cost + planned nonlabor cost + planned expense cost.

PlannedTotalUnits

The sum of Planned Labor Units and Planned Nonlabor Units. This field is named BudgetedTotalUnits in Primavera's Engineering and Construction and Maintenance and Turnaround solutions.

Yes

PlannedValueCost

The portion of the project baseline total cost of the activity that is scheduled to be completed as of the project data date. Computed as BAC * schedule % complete. Also known as the work scheduled to be performed for the activity.

Yes

PlannedValueLaborUnits

The portion of the project baseline labor units that is scheduled to be completed as of the project data date. Computed as BL labor units * schedule % complete.

Yes

PostResponsePessimisticFinish

The post-response pessimistic finish date for the activity.

No

PostResponsePessimisticStart

The post-response pessimistic start date for the activity.

No

PreResponsePessimisticFinish

The pre-response pessimistic finish date for the activity.

No

PreResponsePessimisticStart

The pre-response pessimistic start date for the activity.

No

PrimaryConstraintDate

The constraint date for the activity, if the activity has a constraint. The activity's constraint type determines whether this is a start date or finish date. Activity constraints are used by the project scheduler.

No

PrimaryConstraintType The type of constraint applied to the activity start or finish date. Activity constraints are used by the project scheduler.

No

PrimaryResourceId The name of the resource. Yes

PrimaryResourceName The name of the resource. Yes

PrimaryResourceObjectId

The unique ID of the primary resource for the activity. The primary resource is responsible for the overall work on the activity and updates the activity status using

No


148


Timesheets.

ProjectId The short code of the associated project. Yes

ProjectName The name of the associated project. Yes


RemainingDuration

The remaining duration of the activity. The remaining duration is the remaining working time for the activity on the project, from the activity's remaining start date to the remaining finish date.

No

RemainingEarlyFinishDate The remaining late end date, which is calculated by the scheduler.

No

RemainingEarlyStartDate

The date the remaining work for the activity is scheduled to begin. This date is computed by the project scheduler but can be updated manually by the project manager.

No

RemainingExpenseCost The remaining costs for all project expenses associated with the activity.

Yes

RemainingFloat

The amount of time remaining by which the activity can be delayed before delaying the project finish date. Computed as late finish - remaining finish.

Yes

RemainingLaborCost

The remaining costs for all labor resources assigned to the activity. If no resources are assigned, computed as the activity remaining labor units * project default price / time.

No

RemainingLaborUnits

The remaining units for all labor resources assigned to the activity. The remaining units reflects the work remaining to be done for the activity.

No

RemainingLateFinishDate The remaining late finish date calculated by the scheduler.

No

RemainingLateStartDate The remaining late start date calculated by the scheduler.

No

RemainingMaterialCost The sum of all material resource remaining costs.

Yes


149


RemainingNonLaborCost

The remaining costs for all nonlabor resources assigned to the activity. If no resources are assigned, computed as the activity remaining nonlabor units * project default price / time.

No

RemainingNonLaborUnits

The remaining units for all nonlabor resources assigned to the activity. The remaining units reflects the work remaining to be done for the activity.

No

RemainingTotalCost

The remaining total cost for the activity, including labor resources, nonlabor resources, and project expenses. Remaining total cost = remaining labor costs + remaining nonlabor costs + remaining expense costs.

Yes

RemainingTotalUnits The sum of Remaining Labor Units and Remaining Nonlabor Units.

Yes

ResumeDate

The date when a suspended task or resource dependent activity should be resumed. The resume date must be later than the suspend date and earlier than the actual finish date.

No

ReviewFinishDate

The finish date of the activity as proposed by the primary resource using Timesheets, while the activity is in "For Review" state. If the project manager approves the activity completion, the review finish is copied to the actual finish.

Yes

ReviewStatus

The activity review status. Valid values are 'OK', 'For Review', and 'Rejected'. Primary resources set the status to 'For Review' when they believe the activity is completed but are not allowed to mark activities as completed.

No

RolledupWBSObjectId Rolled up WBS Object IDs after filtering either by levels or tagging.

No

SchedulePercentComplete

The activity schedule percent complete, which specifies how much of the activity's project baseline duration has been completed so far.

Yes


150


SchedulePerformanceIndex

The ratio of the earned value of work performed and the work scheduled to be performed. Computed as SPI = earned value/ planned value. A value less than 1 indicates that less work was actually performed than was scheduled.

Yes

SchedulePerformanceIndexLaborUnits

The ratio of the earned value of labor units and the planned value of labor units. Computed as SPI labor units = earned value labor units / planned value labor units.

Yes

ScheduleVariance

The difference between the earned value of work performed and the work scheduled to be performed. Computed as SV = earned value - planned value. A negative value indicates that less work was actually performed than was scheduled.

Yes

ScheduleVarianceIndex The ratio of the schedule variance and the work scheduled to be performed. Computed as SVI = SV / planned value.

Yes

ScheduleVarianceIndexLaborUnits

The ratio of the schedule variance and the work scheduled to be performed. Computed as SVI labor units = SV labor units / planned value labor units.

Yes

ScheduleVarianceLaborUnits

The difference between the earned value of work performed and the work scheduled to be performed. Computed as SV labor units = earned value labor units - planned value labor units.

Yes

SecondaryConstraintDate

The date to be used for the cstr_type2 assignment, if the activity has a cstr_type2 value. The activity's constraint type determines whether this is a start date or finish date. Activity constraints are used by the project scheduler.

No

SecondaryConstraintType The additional constraint to be used by the scheduler.

No

StartDate The start date of the activity. Set to the remaining start date until the activity is started, then set to the actual start date.

No


151


StartDate1Variance

The duration between the start date in the current project and the primary baseline start date. Calculated as start date - primary baseline start date.

Yes

StartDateVariance

The duration between the start date in the current project and the project baseline start date. Calculated as start date - project baseline start date.

Yes

Status The current status of the activity, either 'Not Started', 'In Progress', or 'Completed'.

No

SuspendDate

The start date when the progress of a task or resource dependent activity is delayed from. The suspend date must be later than the actual start date, which the activity must have.

No

ToCompletePerformanceIndex

The TCPI, which is calculated as (budget at completion - earned value) / (estimate at completion - ACWP).

Yes

TotalActualCost An Activity UDF to store Total Actual Cost for the Activity.

No

TotalCommitmentCost An Activity UDF to store Total Commitment Cost for the Activity.

No

TotalCost1Variance

The difference between the primary baseline total cost and the at completion total cost. Calculated as BL total cost - at completion total cost.

No

TotalCostVariance

The difference between the project baseline total cost and the at completion total cost. Calculated as BL total cost - at completion total cost.

Yes

TotalFloat

The amount of time the activity can be delayed before delaying the project finish date. Total float can be computed as late start - early start or as late finish - early finish; this option can be set when running the project scheduler.

Yes

TotalPlannedCost An Activity UDF to store Total Planned Cost for the activity.

No


152


Type


No

UnitsPercentComplete

The percent complete of units for all labor and nonlabor resources assigned to the activity. Computed as actual units / at completion units * 100. Always in the range 0 to 100.

No

VCPActDemandPeggedAvlDate

VCP Activity Demand Pegged Avl Date (UDF)

No

VCPActDemandPeggedOrderNumber

VCP Activity Demand Pegged Order Number (UDF)

No

VCPActDemandPeggedOrderType

VCP Activity Demand Pegged Order Type (UDF)

No

VCPActItemSelection VCP Activity Item Selection (UDF) No

VCPActItemSelectionCode VCP Activity Item Selection Code (UDF) No

VCPActSupplyActualStartDate

VCP Activity Supply Actual Start Date (UDF)

No

VCPActSupplyDockDate VCP Activity Supply Dock Date (UDF) No

VCPActSupplyDueDate VCP Activity Supply Due Date (UDF) No

VCPActSupplyItemId VCP Activity Supply Item Id (UDF) No

VCPActSupplyItemName VCP Activity Supply Item Name (UDF) No

VCPActSupplyOrderDate VCP Activity Supply Order Date (UDF) No

VCPActSupplyOrderNumber

VCP Activity Supply Order Number (UDF) No

VCPActSupplyOrderType VCP Activity Supply Order Type (UDF) No

VCPActSupplyOrganization VCP Activity Supply Organization (UDF) No

VCPActSupplyPeggedActivityId

VCP Activity Supply Pegged Activity Id (UDF)

No

VCPActSupplyPeggedOrderNumber

VCP Activity Supply Pegged Order Number (UDF)

No

VCPActSupplyQuantity VCP Activity Supply Quantity (UDF) No

VCPActSupplyShipDate VCP Activity Supply Ship Date (UDF) No

VCPActSupplyStartDate VCP Activity Supply Start Date (UDF) No


153


VCPActSupplyUpdatedArrivalDate

VCP Activity Supply Updated Arrival Date (UDF)

No

WBSCode

The short code assigned to each WBS element for identification. Each WBS element is uniquely identified by concatenating its own code together with its parents' codes.

Yes

WBSName The name of the WBS element. Yes

WBSObjectId The unique ID of the WBS for the activity. No

WBSPath The unique ID of the WBS for the activity. Yes

ActivityCode

Description: Activity codes are user-defined codes to classify and categorize activities according to the organization's and project's needs.


CodeTypeName The name of the activity code type. Yes

CodeTypeObjectId The unique ID of the activity code type. No

CodeTypeScope The scope of the parent activity code type. Yes

CodeValue The value of the activity code. No

Color The Hex representation for the color No

CreateDate The date this activity code was created. Yes

Description The description of the activity code. No

LastUpdateDate The date this activity code was last updated. Yes

LastUpdateUser The name of the user that last updated this activity code.

Yes


ParentObjectId The unique ID of the parent activity code. No

ProjectObjectId The unique project ID of the parent code type for this code if code type scope is 'Project' or 'EPS', null for code types with scope 'Global'.

Yes



154

ActivityCodeType

Description: Activity code types provide a way of classifying activity codes. Activity codes are user-defined codes to classify and categorize activities according to the organization's and project's needs.


CreateDate The date this activity code type was created. Yes

CreateUser The name of the user that created this activity code type.

Yes

EPSObjectId The unique ID of the EPS. No

IsBaseline The Boolean value indicating if this business object is related to a project or baseline.

Yes

IsSecureCode The flag indicating whether this is a secure activity code type.

No

IsTemplate The Boolean value indicating if this business object is related to a template project.

Yes

LastUpdateDate The date this activity code type was last updated. Yes

LastUpdateUser The name of the user that last updated this activity code type.

Yes

Length The maximum number of characters allowed for values of this activity code type.

No

Name The name of the activity code type. No



Scope The scope of the activity code type. No


ActivityExpense

Description: Activity expenses in P6 EPPM are non-resource costs associated with a project and assigned to a project's activities. They are typically one-time expenditures for non-reusable items. When importing expenses into P6, you can add a cost account dynamically for the expense as long as the cost account fields are included in the Expense field mapping template.


AccrualType The accrual type for the project expense. If the accrual type is 'Start of Activity', the entire expense costs are accrued at the start date of

No


155


the activity.


Yes

ActivityName The name of the activity. The activity name does not have to be unique.

Yes

ActivityObjectId

The unique ID of the activity to which the project expense is linked. Every project expense is associated with one activity in the project.

No

ActualCost The actual cost for the project expense. No

ActualUnits The actual units for the project expense. No

AtCompletionCost The sum of the actual plus remaining costs for the project expense. Computed as actual cost + remaining cost.

Yes

AtCompletionUnits The at completion units for the project expense.

Yes

AutoComputeActuals

The flag that identifies whether the actual and remaining costs for the expense are computed automatically using the planned cost and the activity's schedule percent complete.

No

CostAccountId The ID of associated cost account. Yes

CostAccountName The name of the associated cost account. Yes

CostAccountObjectId The unique ID of the cost account associated with the project expense.

No

CreateDate The date this expense was created. Yes

CreateUser The name of the user that created this expense.

Yes

DocumentNumber

The document number for the expense. Use this for the purchase order number, invoice number, requisition number, or similar, as needed.

No

ExpenseCategoryName The name of the expense category. Yes


The unique ID of the expense category for the project expense.

No

ExpenseDescription The description of the expense. No

ExpenseItem The name of the project expense. No


156


ExpensePercentComplete

The percent complete of the project expense. No

IsBaseline The Boolean value indicating if this business object is related to a Project or Baseline.

Yes


Yes

LastUpdateDate The date this expense was last updated. Yes

LastUpdateUser The name of the user that last updated this expense.

Yes


OverBudget

The indicator that reflects whether the project expense is over budget. An expense is over budget when the actual cost + remaining cost exceeds the planned cost.

Yes

PlannedCost

The planned cost for the project expense. This field is named BudgetedCost in Primavera's Engineering and Construction and Maintenance and Turnaround solutions.

No

PlannedUnits The planned number of units for the project expense. This number is multiplied by the price per unit to compute the planned cost.

No

PricePerUnit

The planned price per unit for the project expense. This number is multiplied by the planned number of units to compute the planned cost.

No


Yes

ProjectObjectId The unique ID of the associated project. Yes

RemainingCost The remaining cost for the project expense. Before actual expenses are made, remaining cost should be the same as planned cost.

No

RemainingUnits The remaining units for the project expense. No

UnitOfMeasure The unit of measure for the project expense. No

Vendor The name of the vendor providing the product or service associated with the expense.

No

WBSObjectId The unique ID of the WBS for the activity. Yes


157

ActivityRisk

Description: The activity risk object stores the relationship between a single activity and a single risk.


ActivityId The short name of the associated activity. Yes

ActivityName The name of the associated activity. Yes



ProjectId The short name of the associated project. Yes


RiskId The short name of the associated risk. Yes

RiskName The name of the associated risk. Yes

RiskObjectId The unique ID of the associated risk. Yes

BaselineType

Description: Baseline Type fields


CreateDate The create Date for currency. Yes


Yes

LastUpdateDate The Last Update Date for currency. Yes


Yes

Name The name for BaselineType. No


SequenceNumber Sequence Number for BaselineType. No


158

Calendar

Description: The Calendar business object is used to import calendars into P6 EPPM. Calendars define the available work hours in each calendar day, and include global, resource, and project types. Global and resource calendars are supported during import. Existing resource calendars can be promoted to global or shared resource calendars.The following flows support calendar import into P6 EPPM:

Master Data

Note: No mapping template is available for the Calendar object. However, to ensure it will be imported when selected in the Master Data flow, add an option for the Calendar object in the field mapping selection template.

Project Data, only if the Calendar object exists in the project xml file

Support for Global Calendars

Providers must send the start time and end time for each day of the standard work week. All exception time must also be sent.

Support for Resource Calendars

During import, resource calendars are processed as follows:

All resource calendars are created using the default calendar's settings, including the standard work week. values. If the workweek values are not available, the default calendar workweek is used. If a default calendar workweek is not set, then the default global calendar will be used as the default calendar.

The incoming resource calendar must be assigned to a resource or as a shared calendar. By default, all resource calendars are created as Shared, unless the isPersonal flag is set to True.

If a resource has been assigned to a resource calendar, then the existing resource calendar will be updated by the incoming resource calendar using a cross-reference mapping.

If a resource calendar does not have a resource assignment, then it must be created as a shared calendar. This enables you to convert the resource calendar in P6 to Personal without having to re-import.

See the following example of a resource calendar imported into P6.




No

CreateDate The date this calendar was created. Yes

CreateUser The name of the user that created this calendar. Yes


159




No

HolidayOrExceptions

All dates with holidays or exceptions in this calendar. A child object that describes all the dates that the working hours are different from those in the standard work week.

No

IsPersonal The flag indicating if this calendar is a personal calendar (applies to resource calendars only).

No

IsDefault The flag that identifies the default global calendar (applies to global calendars only).

No

LastUpdateDate The date this calendar was last updated. Yes

LastUpdateUser The name of the user that last updated this calendar.

Yes



ProjectObjectId The unique ID of the project. Yes

ProjectId The short name of the project. No

StandardWorkWeek

Standard detailed work hours for each day of week.

No

Type The calendar type - either 'Global', 'Resource', or 'Project'.

No

161

Example of Importing a Global Calendar

The following is an example of modifying a global calendar imported into P6:

The existing imported workweek is:

Sunday Monday Tuesday Wednesday Thursday Friday Saturday

Start and Stop Time

8 to 5 8 to 5 8 to 5 8 to 5 8 to 5

The subsequent import is:


Start and Stop Time

9 to 3 9 to 3 9 to 3

After import, the workweek is:


Start and Stop Time

9 to 3 9 to 3 9 to 3

The following changes have been made:

The existing work time for Monday and Friday have been removed.

In the source calendar, Exception time (Holiday) is April 24, 2013 and workday exception is April 27, 2013 (Saturday).

The incoming updates made to the calendar are: Holiday is April 26, 2013 and Workday exception is April 28, 2013 (Sunday).

Note: April 24, 2013 and April 26, 2013 are still exceptions as the exception list has been merged in the existing calendar.

CBS

Description: CBS business object.


CBSCode CBS Code associated with the Project No


162


CBSDescription CBS Code Description No

CBSStatus CBS Code Status. Valid values are "Active" and "InActive"

No


ParentObjectId The unique ID of the parent CBS. No

ProjectObjectId The unique ID of the associated Project No

CBSDurationSummary

Description: CBSDurationSummary business object.


BaselineType Baseline type of the associated baseline.

No

CBSObjectId The unique ID of the associated CBS. Yes

DataDate Data date of the associated project. No


No

OriginalProjectObjectId The original object ID of the associated project.

Yes


Yes



Yes

SummaryActualDuration Summarized Actual Duration the project.

Yes

SummaryActualFinishDate Summarized Actual Finish Date of the project.

Yes

SummaryActualStartDate Summarized Actual Start Date of the project.

Yes

SummaryPercentComplete Summarized Percent Complete the project

Yes

SummaryPlannedDuration Summarized Planned Duration the project.

Yes


163



Summarized Planned Finish Date of the project.

Yes

SummaryPlannedStartDate Summarized Planned Start Date of the project.

Yes

SummaryRemainingDuration

Summarized Remaining Duration the project.

Yes


Summarized Remaining Finish Date of the project.

Yes

SummaryRemainingStartDate

Summarized Remaining Start Date of the project.

Yes

CBSExpenseSpread




Actual Units Actual Units No





DateDate Date date No

EndDate End date. No

ExpenseCategoryName Expense Category No


No

OriginalProjectObjectId The original object id of the associated Project.

No




ProjectName Project name. No


164





StartDate Start date. No




SummaryAtCompletionUnits

Summarized At Completion Units No

SummaryPlannedCost Summarized Planned Cost. No

SummaryPlannedUnits Summarized Planned Units. No



CBSResourceSpread



ActualCost Actual Cost of the resource assignments when summarized by CBS

No

Actual Units The actual units of the resource assignments when summarized by CBS.

No

AtCompletionCost At completion cost of the resource assignments when summarized by CBS.

No

AtCompletionUnits At completion units of the resource assignments when summarized by CBS.

No

BaselineType The name of the baseline type for this project baseline. Baseline types are used to categorize project baselines.

No

CBSObjectId The unique ID of CBS. Yes

CurrencyId Currency ID No



165


DataDate The data date of the project when it was last summarized by CBS.

No

EndDate End date of the resource assignments when summarized by CBS.

No


OriginalProjectObjectId

The original object id of the associated project. Yes

PlannedCost Planned cost of the resource assignments when summarized by CBS

No

PlannedUnits The planned units of the resource assignments when summarized by CBS.

No

ProjectId The short code that uniquely identifies the project. Yes



RemainingCost Remaining cost of the resource assignments when summarized by CBS.

No

RemainingUnits The remaining cost of the resource assignments when summarized by CBS.

No

ResourceId The short code that uniquely identifies the resource. Yes

ResourceName The name of the resource. Yes

ResourceType The resource type: "Labor", "Nonlabor", or "Material". No

StartDate Start date of the resource assignments when summarized by CBS.

No

SummaryActualCost

Actual cost of the resource assignments when summarized by CBS.

Yes

SummaryActualFinish

Actual finish date of the resource assignments when summarized by CBS.

Yes

SummaryActualStart

Actual Start date of the resource assignments when summarized by CBS.

Yes

SummaryActualUnits

Actual Units of the resource assignments when summarized by CBS.

Yes

SummaryAtCompletionCost

At completion cost of the resource assignments when summarized by CBS.

Yes


At Completion Units of the resource assignments when summarized by CBS.

Yes


166


SummaryPlannedCost

Planned cost of the resource assignments when summarized by CBS.

Yes

SummaryPlannedFinish

Finish date of the resource assignments when summarized by CBS.

Yes

SummaryPlannedStart

Planned start of the resource assignments when summarized by CBS.

Yes

SummaryPlannedUnits

Planned Units of the resource assignments when summarized by CBS.

Yes

SummaryRemainingCost

Remaining cost of the resource assignments when summarized by CBS.

Yes

SummaryRemainingFinish

Remaining finish date of the resource assignments when summarized by CBS.

Yes

SummaryRemainingStart

Remaining Start date of the resource assignments when summarized by CBS.

Yes

SummaryRemainingUnits

Remaining Units of the resource assignments when summarized by CBS.

Yes

UnitAbbreviation Unit Abbreviation No

UnitName Unit Name No

CostAccount

Description: Cost accounts contain the organization's cost account IDs. Available across all projects, they support tracking of costs and earned value based on the organization's cost account IDs. Cost accounts are hierarchical objects.


CreateDate The date this cost account was created. Yes

CreateUser The name of the user that created this cost account. Yes

Description The description of the cost account. No

Id The short code that uniquely identifies this cost account. No

LastUpdateDate

The date this cost account was last updated. Yes

LastUpdateUser

The name of the user that last updated this cost account. Yes

Name The name of the cost account. No


167



ParentObjectIdThe unique ID of the parent cost account of this cost account in the hierarchy.

No

SequenceNumber


Currency

Description: Currencies are the monetary units used to store costs for all projects in the database. Monetary units are stored in the database with a base currency but can be viewed in other currencies using the exchange for each currency.


CreateDate The create date for the currency. Yes


Yes

DecimalSymbol The symbol for decimal. No

DigitGroupingSymbol

The symbol for Digit Groups. No

ExchangeRate The exchange rate for the currency. No

Id The ID for currency. No

LastUpdateDate The Last Update Date for currency Yes


Yes

Name The Name of currency No

NegativeSymbol The symbol for negative currency. No


PositiveSymbol The symbol for positive currency. No

Symbol The symbol for decimal. No


168

EPS

Description: EPS (Enterprise Project Structure). To export an EPS hierarchy from P6, the EPS ID and EPS Name fields are required and must be included in the default EPS field mapping template.


AnticipatedFinishDate The anticipated finish date of the EPS. No

AnticipatedStartDate The anticipated start date of the EPS. No

CreateDate The date this EPS was created. Yes

CreateUser The name of the user that created this EPS.

Yes

CurrentBudget The sum of the original budget plus the approved and pending budgets from the budget change log.

Yes

CurrentVariance The difference between the current budget and the total spending plan.

Yes

DistributedCurrentBudget The current budget values from one level lower.

Yes

FinishDate The finish date of the EPS. Yes


No


IndependentETCLaborUnits The user-entered ETC total labor. Yes

IndependentETCTotalCost The user-entered ETC total cost. Yes

LastSummarizedDate The date the project was last summarized.

Yes

LastUpdateDate The date this EPS was last updated. Yes

LastUpdateUser The name of the user that last updated this EPS.

Yes



OBSName The name of the person/role in the organization, sometimes referred to as the "responsible manager".

Yes

OBSObjectId The unique ID of the project manager from the project's OBS tree who is responsible for the EPS.

No


169


OriginalBudget The original budget for the project. No

ParentObjectId The unique ID of the associated project. No

PlannedStartDate The planned start date of the project. Used by the project scheduler.

Yes

ProjectObjectId The internal Project ID of the EPS. This ID cannot be used to load a Project object directly.

Yes

ProposedBudget

The Proposed Budget, which is the sum of the original budget plus the approved and pending budgets from the budget change log.

Yes


StartDate The start date of the EPS. Yes

SummaryAccountingVarianceByCost

The Planned Value minus the Actual Cost.

Yes


The Planned Value Labor Units minus the Actual Units.

Yes

SummaryActivityCount The number of activities that are currently in progress.

Yes

SummaryActualDuration The actual duration. Yes

SummaryActualExpenseCost The actual costs for all project expenses associated with the EPS.

Yes

SummaryActualFinishDate The latest actual finish date of all activities in the EPS.

Yes

SummaryActualLaborCost The actual cost for all labor resources assigned to the activity.

Yes

SummaryActualLaborUnits The actual labor units. Yes

SummaryActualMaterialCost The actual units for all material resources assigned to the activity.

Yes

SummaryActualNonLaborCost The actual cost for all nonlabor resources assigned to the activity.

Yes

SummaryActualNonLaborUnits The actual nonlabor units. Yes

SummaryActualStartDate The earliest actual start date of all activities in the EPS.

Yes


170


SummaryActualThisPeriodCostThe actual this period cost (will be labor or nonlabor).

Yes

SummaryActualThisPeriodLaborCost

The actual this period labor cost. Yes

SummaryActualThisPeriodLaborUnits

The actual this period labor units. Yes

SummaryActualThisPeriodMaterialCost

The actual this period material cost. Yes


The actual this period nonlabor cost. Yes


The actual this period nonlabor units. Yes

SummaryActualTotalCost The actual labor cost + actual nonlabor cost + actual expense cost as of the project data date.

Yes

SummaryActualValueByCost

The actual total cost incurred on the activity as of the project data date, computed as Actual Labor Cost + Actual Nonlabor Cost + Actual Material Cost + Actual Expense Cost.

Yes

SummaryActualValueByLaborUnits

The actual total labor units for the activity as of the project data date (i.e., actual total cost by labor units).

Yes

SummaryAtCompletionDuration

The duration at completion. Yes

SummaryAtCompletionExpenseCost

The sum of the actual plus remaining cost for all project expenses associated with the cost account. Computed as Actual Expense Cost + Remaining Expense Cost.

Yes

SummaryAtCompletionLaborCost

The sum of the actual plus remaining costs for all labor resources assigned to the activity. Computed as actual labor cost + remaining labor cost. Same as the planned labor costs if the activity is not started and the actual labor costs once the activity is completed.

Yes

SummaryAtCompletionLaborUnits

The sum of the actual plus remaining units for all labor resources assigned to the activity. Computed as actual labor

Yes


171


units + remaining labor units. Same as the planned labor units if the activity is not started and the actual labor units once the activity is completed.

SummaryAtCompletionMaterialCost

The material cost at completion. It is the sum of the actual plus remaining costs for all material resources assigned to the activity. Computed as actual material cost + remaining material cost. Same as the planned material costs if the activity is not started and the actual material costs once the activity is completed.

Yes

SummaryAtCompletionNonLaborCost

The nonlabor cost at completion. It is the sum of the actual plus remaining costs for all nonlabor resources assigned to the activity. Computed as actual nonlabor cost + remaining nonlabor cost. Same as the planned nonlabor costs if the activity is not started and the actual nonlabor costs once the activity is completed.

Yes

SummaryAtCompletionNonLaborUnits

The nonlabor units at completion. It is the sum of the actual plus remaining units for all nonlabor resources assigned to the activity. Computed as actual nonlabor units + remaining nonlabor units. Same as the planned nonlabor units if the activity is not started and the actual nonlabor units once the activity is completed.

Yes

SummaryAtCompletionTotalCost

The estimated cost at completion for the activity. Computed as the actual total cost plus the estimate-to-complete cost; EAC = ACWP + ETC. Note that the method for computing ETC depends on the earned-value technique selected for the activity's WBS.

Yes


The Baseline Planned Total Cost - At Completion Total Cost.

Yes


The number of completed activities in the baseline.

Yes

SummaryBaselineDuration The planned duration for the activity in the primary baseline. Planned duration is

Yes


172


the total working time from the activity current start date to the current finish date. Same as the actual duration plus the remaining duration. The total working time is computed using the activity's calendar.

SummaryBaselineExpenseCost

The planned cost for all project expenses associated with the activity in the primary baseline. Computed as the baseline actual expense cost plus the baseline remaining expense cost.

Yes

SummaryBaselineFinishDate The current latest finish date of all activities in the EPS for the current baseline.

Yes


The number of activities that should be currently in progress, according to the primary baseline. Computed using the baseline start and finish dates and the current data date.

Yes

SummaryBaselineLaborCost

The planned cost for all labor resources assigned to the activity in the primary baseline. Computed from the baseline At Completion labor units. If no resources are assigned, computed as the activity Baseline Planned Labor Units * Project Default Price / Time.

Yes

SummaryBaselineLaborUnits

The planned units for all labor resources assigned to the activity in the primary baseline. Computed as the baseline actual labor units plus the baseline remaining labor units.

Yes

SummaryBaselineMaterialCost

The planned cost for all material resources assigned to the activity in the primary baseline. Computed from the baseline At Completion nonlabor units. If no resources are assigned.

Yes

SummaryBaselineNonLaborCost

The planned cost for all nonlabor resources assigned to the activity in the primary baseline. Computed from the baseline At Completion nonlabor units. If no resources are assigned, computed as the activity Baseline Planned Nonlabor Units * Project Default Price / Time.

Yes


173


SummaryBaselineNonLaborUnits

The planned units for all nonlabor resources assigned to the activity in the primary baseline. Computed as the baseline actual nonlabor units plus the baseline remaining nonlabor units.

Yes


The number of activities not started in the baseline.

Yes

SummaryBaselineStartDate The current earliest start date of all activities in the EPS for the current baseline.

Yes

SummaryBaselineTotalCost

The Planned Total Cost for the activity in the primary baseline, including labor resources, nonlabor resources, and project expenses. Baseline Planned Total Cost = Baseline Planned Labor Cost + Baseline Planned Nonlabor Cost + Baseline Planned Expense Cost.

Yes

SummaryBudgetAtCompletionByCost

The Planned Total Cost through activity completion. Computed as Planned Labor Cost + Planned Nonlabor Cost + Planned Expense Cost, same as the Planned Total Cost.

Yes


The Baseline Labor Units. Yes

SummaryCompletedActivityCount

The number of activities that have an Actual Finish in the EPS.

Yes

SummaryCostPercentComplete

The percent complete of costs for the resource assignments in the EPS. Computed as Actual Units / At Complete Units * 100. Always in the range 0 to 100.

Yes

SummaryCostPercentOfPlanned

The activity actual cost percent of planned. Computed as actual total cost / baseline total cost * 100, or equivalently as ACWP / BAC * 100. The value can exceed 100. The baseline total cost is the activity's at completion cost from the current baseline. This field is named SummaryCostPercentOfBudget in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

Yes


174



The Earned Value divided by the Actual Cost. A value less than 1 indicates that the Actual Cost has exceeded the Planned Value.

Yes


The Earned Value Labor Units / Actual Labor Units.

Yes

SummaryCostVarianceByCost

The Earned Value minus the Actual Cost. A negative value indicates that the Actual Cost has exceeded the Planned Value.

Yes

SummaryCostVarianceByLaborUnits

The Earned Value Labor Cost minus Actual Value Labor Cost.

Yes

SummaryCostVarianceIndex The value that is calculated as the Cost Variance divided by Earned Value.

Yes

SummaryCostVarianceIndexByCost

The Cost Variance divided by Earned Value.

Yes


The Cost Variance Labor Units divided by Earned Value Labor Units.

Yes

SummaryDurationPercentComplete

The activity actual duration percent of planned. Computed as (baseline planned duration - remaining duration) / baseline planned duration * 100.

Yes

SummaryDurationPercentOfPlanned

The summary actual duration percent of planned of all activities under this EPS. Computed as actual duration / baseline duration * 100. The value can exceed 100. The Baseline duration is the activity's at complete duration from the current baseline.

Yes

SummaryDurationVariance

The duration between the activity's baseline duration and the at complete duration. Computed as baseline duration - at completion duration.

Yes

SummaryEarnedValueByCost

The Budget at Completion * Performance % Complete. The method for computing the Performance Percent Complete depends on the Earned Value technique selected for the activity's WBS. Budget at Completion is computed from the primary baseline.

Yes


175


SummaryEarnedValueByLaborUnits

The Schedule Variance Labor Units divided by the Planned Value Labor Units.

Yes

SummaryEstimateAtCompletionByCost

The Actual Cost plus the Estimate to Complete Cost. The method for computing Estimate to Complete depends on the Earned Value technique selected for the activity's WBS.

Yes


The Actual Labor Units + Estimate To Complete Labor Units. (Estimate To Complete Labor Units is calculated based off of the Earned Value setting on the EPS.)

Yes


The high forecast of Estimate At Completion (EAC) by labor units.

Yes


The low forecast of Estimate At Completion (EAC) by labor units.

Yes

SummaryEstimateToCompleteByCost

The Remaining Total Cost for the activity or the Performance Factor * (Budget at Completion - Earned Value), depending on the Earned Value technique selected for the activity's WBS (calculated from the primary baseline).

Yes


The estimated quantity to complete the activity. Computed as either the remaining total units for the activity, or as Performance Factor * (Baseline Planned Labor Units - Planned Quantity of Work Performed), depending on the Earned Value Technique selected for the activity's WBS.

Yes

SummaryExpenseCostPercentComplete

The percent complete of cost for all expenses associated with the EPS. It is computed as Actual Expense Cost / At Complete Expense Cost * 100, and it is always in the range of 0 to 100.

Yes

SummaryExpenseCostVariance

The Baseline Planned Expense Cost - At Completion Expense Cost (At Completion Expense Cost = Actual Expense Cost + Remaining Expense Cost).

Yes


176


SummaryFinishDateVariance

The duration between the finish date in the current project and the baseline finish date. Calculated as finish date - baseline finish date.

Yes

SummaryInProgressActivityCount

The number of activities that are currently in progress.

Yes

SummaryLaborCostPercentComplete

The percent complete of cost for all labor resources assigned to the EPS. It is computed as Actual Labor Cost / At Complete Labor Cost * 100, and it is always in the range of 0 to 100.

Yes

SummaryLaborCostVariance The Baseline Planned Labor Cost - At Completion Labor Cost.

Yes

SummaryLaborUnitsPercentComplete

The percent complete of units for all labor resources for the EPS. Computed as actual labor units / at complete labor units * 100. Always in the range 0 to 100.

Yes

SummaryLaborUnitsVariance

The difference between baseline labor units and at completion labor units. Calculated as Baseline labor units - at completion labor units.

Yes

SummaryMaterialCostPercentComplete

The percent complete of cost for all material resources assigned to the EPS. It is computed as Actual Material Cost / At Complete Material Cost * 100, and it is always in the range of 0 to 100.

Yes

SummaryMaterialCostVarianceThe variance that is calculated as Baseline Material Cost - At Completion Material Cost.

Yes


The percent complete of cost for all non-labor resources assigned to the EPS. It is computed as Actual Nonlabor Cost / At Complete Nonlabor Cost * 100, and it is always in the range of 0 to 100.

Yes

SummaryNonLaborCostVariance

The Baseline Planned Nonlabor Cost - At Completion Nonlabor Cost.

Yes


The percent complete of units for all nonlabor resources for the EPS. Computed as Actual Nonlabor Cost / At Completion Nonlabor Cost * 100. Always in the range 0 to 100.

Yes


177


SummaryNonLaborUnitsVariance

The difference between baseline nonlabor units and at completion non labor units. Calculated as Baseline nonlabor units - at completion nonlabor units.

Yes

SummaryNotStartedActivityCount

The number of activities that are currently not started.

Yes


The percent complete of performance for all labor resources, nonlabor resources, and expenses. Computed as Earned Value / Budget At Completion * 100. Always in the range 0 to 100.

Yes


The percent complete of performance for all labor resources. Computed as earned value labor units / baseline labor units * 100. Always in the range 0 to 100.

Yes

SummaryPlannedCost The sum of all planned expense, non labor, labor, and material costs in the EPS.

Yes

SummaryPlannedDuration The total working days between planned start and finish dates in the EPS.

Yes

SummaryPlannedExpenseCostThe sum of all planned expense costs in the EPS.

Yes

SummaryPlannedFinishDate The latest planned finish date of all activities in the EPS.

Yes

SummaryPlannedLaborCost The sum of all planned labor costs in the EPS.

Yes

SummaryPlannedLaborUnits The sum of all planned labor units in the EPS.

Yes

SummaryPlannedMaterialCost The sum of all planned material costs in the EPS.

Yes

SummaryPlannedNonLaborCost

The sum of all planned non labor costs in the EPS.

Yes

SummaryPlannedNonLaborUnits

The sum of all planned non labor units in the EPS.

Yes

SummaryPlannedStartDate The earliest planned start date of all activities in the EPS.

Yes


178


SummaryPlannedValueByCost

The Budget at Completion * Schedule % Complete. The Schedule % Complete specifies how much of the activity's baseline duration has been completed so far. Budget at Completion is computed from the primary baseline

Yes

SummaryPlannedValueByLaborUnits

The portion of the baseline labor units that is scheduled to be completed as of the project data date. Computed as Baseline Labor Units * Schedule % Complete. The Schedule % Complete specifies how much of the activity's baseline duration has been completed so far. The Baseline Labor Units is taken from the current baseline.

Yes

SummaryProgressFinishDate


Yes

SummaryRemainingDuration The total working time from the EPS remaining start date to the remaining finish date.

Yes

SummaryRemainingExpenseCost

The remaining costs for all project expenses associated with the activities in the EPS.

Yes


The date the resource is scheduled to finish the remaining work for the activity. This date is computed by the project scheduler but can be updated manually by the project manager. Before the activity is started, the remaining finish date is the same as the planned finish date.

Yes

SummaryRemainingLaborCost

The remaining costs for all labor resources assigned to the activities. The remaining cost reflects the cost remaining for the EPS.

Yes

SummaryRemainingLaborUnitsThe remaining units for all labor resources assigned to the activities. The remaining units reflects the work

Yes


179


remaining to be done for the EPS.

SummaryRemainingMaterialCost

The remaining material costs for all project expenses associated with the activities in the EPS.

Yes

SummaryRemainingNonLaborCost

The remaining nonlabor costs for all project expenses associated with the activities in the EPS.

Yes

SummaryRemainingNonLaborUnits

The remaining units for all nonlabor resources assigned to the activities. The remaining units reflects the work remaining to be done for the EPS.

Yes

SummaryRemainingStartDate The earliest remaining start of all activities assigned to the EPS.

Yes

SummaryRemainingTotalCost The sum of all remaining total costs in the EPS.

Yes

SummarySchedulePercentComplete

The measure that indicates how much of the EPS baseline duration has been completed so far. Computed based on where the current data date falls between the activity's baseline start and finish dates. If the data date is earlier than the Baseline start, the schedule % complete is 0. If the data date is later than the Baseline finish, the schedule % complete is 100. The schedule % complete indicates how much of the EPS duration should be currently completed, relative to the selected baseline.

Yes


The percent complete of units for all labor resources. Computed as Actual Labor Units / At Completion Labor Units * 100. Always in the range 0 to 100.

Yes


The Earned Value divided by the Planned Value. A value less than 1 indicates that less work was actually performed than was scheduled.

Yes


The Earned Value Labor Units divided by Planned Value Labor Units.

Yes


180


SummaryScheduleVarianceByCost

The Earned Value divided by the Planned Value. A negative value indicates that less work was actually performed than was scheduled.

Yes


The Earned Value Labor Units minus the Planned Value Labor Units.

Yes

SummaryScheduleVarianceIndex

The value that is calculated as the Schedule Variance Labor Units divided by Planned Value Labor Units.

Yes


The value that is calculated as the Schedule Variance Labor Units divided by Planned Value Labor Units.

Yes


The Schedule Variance Labor Units divided by the Planned Value Labor Units.

Yes

SummaryStartDateVariance The (Budget at Completion - Earned Value) divided by (Estimate at Completion - Actual Cost).

Yes


The (Budget at Completion - Earned Value) divided by (Estimate at Completion - Actual Cost).

Yes

SummaryTotalCostVariance The value that is calculated as baseline total cost - total cost.

Yes

SummaryTotalFloat

The amount of time the EPS can be delayed before delaying the project finish date. Total float can be computed as late start - early start or as late finish - early finish; this option can be set when running the project scheduler.

Yes

SummaryUnitsPercentComplete

The percent complete of units for the resource assignments in the EPS. Computed as Actual Units / At Complete Units * 100. Always in the range 0 to 100.

Yes


The Baseline Planned Total Labor Units minus Estimate at Completion Labor Units.

Yes

TotalBenefitPlan The sum of the monthly benefit plan. Yes

TotalBenefitPlanTally The sum of the monthly benefit plan tally. Yes


181


TotalFunding The total amount of funding contributed to the project by your funding sources.

Yes

TotalSpendingPlan The sum of the monthly spending plan. Yes

TotalSpendingPlanTally The sum of the monthly spending plan tally.

Yes

UnallocatedBudget The total current budget minus the distributed current budget.

Yes

UndistributedCurrentVariance The total spending plan minus the total spending plan tally.

Yes

ExpenseCategory

Description: Expense categories are used to categorize project expenses. They are used for standardizing expenses and for rolling up expenses across projects.


CreateDate The date this expense category was created. Yes

CreateUser The name of the user that created this expense category.

Yes

LastUpdateDate The date this expense category was last updated. Yes

LastUpdateUser The name of the user that last updated this expense category.

Yes


Name The name of the expense category. No


FinancialPeriod

Description: Financial periods are used to provide accurate display and reporting of actual units and costs. When importing financial periods to P6 ensure that the periods do not overlap or contain gaps. Otherwise errors display during import. Financial periods must be sequential, but do not have to be contiguous. To import a financial period to P6, the StartDate, EndDate, and the Name must be specified.


182

Note: Partial success is not supported for importing a financial period.


CreateDate The date this financial period was created. Yes

CreateUser The name of the user that created this financial period.

Yes

EndDate The end date of the financial period. No

LastUpdateDate

The date this financial period was last updated. Yes

LastUpdateUser

The name of the user that last updated this financial period.

Yes

Name The name of the financial period. No


StartDate The start date of the financial period. No

Location


Location codes from P6 can be exported to Prime or Sample providers using the Master Global Data flow. To export location codes, all fields must be included in the field mapping template.



No


No

City The city name of the address. No

Country The country of the address. No


CreateDate The date this location was created. Yes

CreateUser The name of the user that created this location. Yes

LastUpdateDate The date this location was last updated. Yes

LastUpdateUser The name of the user that last updated this location.

Yes


183




Municipality The municipality name of the address. No

Name The name of the location. No



State The state name of the address. No


NotebookTopic

Description: Notebook topics are used to categorize notes on EPS, project, WBS,and activity objects.


AvailableForActivity

The flag indicating that the topic will be available to assign to activities.

No

AvailableForEPS The flag indicating that the topic will be available to assign to EPS.

No

AvailableForProject

The flag indicating that the topic will be available to assign to projects.

No

AvailableForWBSThe flag indicating that the topic will be available to assign to WBS.

No

ObjectId The unique ID of the NotebookTopic. No

Name The name of the NotebookTopic. No

Project



ActivityDefaultActivityType Indicates the activityType of the No


184


activity.

ActivityDefaultCalendarName The name of the Activity Default Calendar of this project.

Yes

ActivityDefaultCalendarObjectId The unique ID of the Activity Default Calendar of this project.

No

ActivityDefaultCostAccountObjectId The unique ID of the Activity Default Cost Account of this project.

No

ActivityDefaultDurationType Indicates the activity default duration type of the activity.

No

ActivityDefaultPercentCompleteType Indicates the activity default percent complete type of the activity.

No

ActivityDefaultPricePerUnit The activity default price per unit for an activity.

No

ActivityIdBasedOnSelectedActivity The Boolean activity ID based on selected activity indicator of the activity.

No

ActivityIdIncrement The increment value of the activity ID.

No

ActivityIdPrefix The prefix value of the activity ID. No

ActivityIdSuffix The suffix value of the activity ID. No

ActivityPercentCompleteBasedOnActivitySteps

The Boolean activity percent complete based on activity steps value of the project.

No

AddActualToRemaining The Boolean add actual to remaining value of the activity.

No

AddedBy The addedBy value of the project. No

AllowNegativeActualUnitsFlag The Boolean allow negative actual units flag value of the activity.

No


No

AnticipatedFinishDate The anticipated finish date of the project.

No

AnticipatedStartDate The anticipated start date of the project.

No


185


AssignmentDefaultDrivingFlag The Boolean assignment default driving flag value of the assignment.

No

AssignmentDefaultRateType Indicates the default rate type of the assignment.

No

BusinessSegment A Project Code field to define th Business Segment of the Project.

No

Calculate FloatBasedOnFinishDate

The flag that indicates how each activity's float will be calculated with respect to other projects in the scheduling batch. This setting only has an effect when scheduling multiple projects at the same time.

Yes

CheckOutDate The check out date of the project. Yes

CheckOutStatus The Boolean check out status flag value of the project.

No

CheckOutUserObjectId The check out user objectId value.

Yes

Comments A Project UDF to define additional comments for the Project.

No


Yes

ContainsSummaryData The Boolean contains summary data flag of the project.

Yes

ContractManagementGroupName The contract management group name value of the project.

No

ContractManagementProjectName The contract management project name value of the project.

No

CostQuantityRecalculateFlag The Boolean cost quantity recalculate flag of the project.

No

CreateDate The created date of the project. Yes

CreateUser The user who created the project. Yes

CriticalActivityFloatLimit The critical activity float limit. No

CriticalActivityPathType Indicates Activity critical path type.

Yes

CurrentBaselineProjectObjectId The current baseline project No


186


objectId of the project.

CurrentBudget The current budget of the project. Yes

CurrentVariance The current variance of the project.

Yes

DataDate The data date of the project. No

DateAdded The date added of the project. No

DefaultPriceTimeUnits Indicates default price time units of the activity.

No

Description The description of the project. No

DiscountApplicationPeriod Indicates discount application period of the project.

No

DistributedCurrentBudget The distributed current budget of the project.

Yes

EarnedValueComputeType Indicates earned value compute type of the project.

No

EarnedValueETCComputeType Indicates earned value ETC compute type of the project.

No

EarnedValueETCUserValue The earned value ETC user value for project computing earned value.

No

EarnedValueUserPercent The earned value user percent for project to compute earned value.

No

EBSBudgetCurrentCost EBS_PRU_Budget_Current_Cost No

EBSBudgetCurrentQuantity EBS_PRU_Budget_Current_Qty No

EBSBudgetOriginalCost EBS_PRU_Budget_Original_Cost No

EBSBudgetOriginalQuantity EBS_PRU_Budget_Original_Qty No

EBSBudgetProposedCost EBS_PRU_Budget_Proposed_Cost

No

EBSBudgetProposedQuantity EBS_PRU_Budget_Proposed_Qty

No

EBSBudgetStatusCode EBS_PRU_Budget_Status_Code No

EBSBudgetVersionName EBS_PRU_Budget_Version_Name

No

EBSBudgetVersionNumber EBS_PRU_Budget_Version_Number

No


187


EBSCalendarWorkingHours

Calendar mulitiplier for days to hours conversion days as defined in P6. Contains the numeric value representing the working hours in a day.

No

EBSPlannedCost EBS_PRU_Planned_Cost No

EBSProjectOrgName EBS_PROJECT_ORGANIZATION

No

EBSProjectStatus EBS_PROJECT_STATUS No

EBSProjectType EBS_PROJECT_TYPE No

EnablePublication The Boolean enable publication flag of the project.

No

EnableSummarization The Boolean enable summarization flag of the project.

No

FinishDate The date finish date of the project. Yes

FiscalYearStartMonth The fiscal year start month of the project.

No

ForecastFinishDate The date forecast finish date of the project.

Yes

ForecastStartDate The date forecast start date of the project.

Yes

GUID The GUID of the project. No

HasFutureBucketData The Boolean has future bucket data flag of the project.

Yes

Id The short ID assigned to each project for identification.

No



Yes

IndependentETCLaborUnits The independent ETC labor units of the project.

No

IndependentETCTotalCost The independent ETC total cost of the project.

No

IntegratedType The type of system integration, if any, in place at the organization.

No

IsTemplate The Boolean is template flag of Yes


188


the project.

LastApplyActualsDate The last apply actuals date of the project.

Yes

LastFinancialPeriodObjectId The last financial period objectId of the project.

No

LastLevelDate The last leveling date of the project.

Yes

LastPublishedOn The date last published on of the project.

Yes

LastScheduleDate The last schedule date of the project.

Yes

LastSummarizedDate The last summarized date of the project.

Yes

LastUpdateDate The last update date of the project.

Yes

LastUpdateUser The last update user of the project.

Yes

LevelingPriority The leveling priority of the project. No

LimitMutualFloatPaths The number of critical float paths to calculate.

Yes

LinkActualToActualThisPeriod The Boolean link actual to actual this period of the project.

No

LinkPercentCompleteWithActual The Boolean link percent complete with actual of the project.

No

LinkPlannedAndAtCompletionFlag The Boolean link planned and atCompletion flag of the project.

No

LocationName The name of the location assigned to the project.

Yes


No



Yes

MaximumMultipleFloatPaths The number of critical float paths to calculate.

Yes


189




Yes



Yes

MultipleFloatPathsUseTotalFloat The Boolean value that decides whether or not to use total float in multiple float path calculations.

Yes

MustFinishByDate The date by which all project activities must finish.

No

Name The name of the project. No

NetPresentValue The net present value of the project.

Yes


No

OBSName The obs name of the project. Yes

OBSObjectId The obs object ID of the project. No

OriginalBudget The original budget of the project. No

OriginalProjectObjectId The unique ID of the original project. It is a baseline project if this field is not null.

Yes


The type of logic used to schedule the progressed activities: 'Retained Logic, 'Progress Override', or 'Actual Dates'.

Yes

OverallProjectScore The overall project score of the project.

Yes

OwnerResourceId The short code that uniquely identifies the owner resource.

No

OwnerResourceObjectId The owner resource objectID of the project.

No

ParentEPSId The parent eps ID of the project. No

ParentEPSObjectId The unique ID of the parent EPS of this project.

No


190


PaybackPeriod The pay back period of the project.

Yes

PlannedBudget A Project UDF to define planned budget for the project.

No

PlannedStartDate The planned start date of the project.

No

PrimaryResourcesCanMarkActivitiesAsCompleted

The Boolean primary resources can mark activities as completed flag of the project.

No

PrimeWorkspace A Project Code field to define the Prime Workspace of the Project.

No

ProjectForecastStartDate The forecast start date of the project.

No

ProjectScheduleType Schedule type of the project. Valid values are 'Duration', or 'Resource', or 'Cost'.

No

PropertyType The project property name associated with the scheduling of projects.

Yes

ProposedBudget The proposed budget of the project.

Yes

PublicationPriority The publication priority of the project.

No


Yes

ResetPlannedToRemainingFlag The Boolean reset planned to remaining flag of the project.

No

ResourceCanBeAssignedToSameActivityMoreThanOnce

The Boolean resource can be assigned to same activity more than once flag of the project.

No

ResourcesCanAssignThemselvesToActivities

The Boolean resource can assign themselves to activities of the project.

No

ResourcesCanEditAssignmentPercentComplete

The Boolean resource can edit assignment percent complete of the project.

No

ResourcesCanMarkAssignmentAsCoThe Boolean resource can mark assignment as completed of the

No


191


mpleted project.

ResourcesCanViewInactiveActivities The Boolean resource can view inactive activities of the project.

No

ReturnOnInvestment The return on investment of the project.

Yes

RiskExposure The proposed budget of the project.

Yes

RiskLevel Indicates risk level of the project No


Yes

RiskMatrixObjectId The risk matrix objectId of the project.

No

RiskScore The risk score of the project. Yes

ScheduledFinishDate The scheduled finish date of the project.

No

SourceProjectObjectId The source project objectId of the project.

Yes

StartDate The start date of the project. Yes



Yes

Status The status of the project. No

StrategicPriority The strategic priority of the project.

N

SummarizedDataDate The summarized data date of the project.

No

SummarizeToWBSLevel The summarize to wbs level of the project.

No

SummaryAccountingVarianceByCost The summary accounting variance by cost of the project.

Yes


The summary accounting variance by labor units of the project.

Yes

SummaryActivityCount The summary activity count of the project.

Yes


192


SummaryActualDuration The summary actual duration of the project.

Yes

SummaryActualExpenseCost The summary actual expense cost of the project.

Yes

SummaryActualFinishDate The summary actual finish date of the project.

Yes

SummaryActualLaborCost The summary actual labor cost of the project.

Yes

SummaryActualLaborUnits The summary actual labor units of the project.

Yes

SummaryActualMaterialCost The summary actual material cost of the project.

Yes

SummaryActualNonLaborCost The summary actual nonlabor cost of the project.

Yes

SummaryActualNonLaborUnits The summary actual nonlabor units of the project.

Yes

SummaryActualStartDate The summary actual start date of the project.

Yes

SummaryActualThisPeriodCost The summary actual this period cost of the project.

Yes

SummaryActualThisPeriodLaborCost The summary actual this period labor cost of the project.

Yes

SummaryActualThisPeriodLaborUnitsThe summary actual this period labor unit of the project.

Yes


The summary actual this period material cost of the project.

Yes


The summary actual this period nonlabor cost of the project.

Yes


The summary actual this period nonlabor unit of the project.

Yes

SummaryActualTotalCost The summary actual total cost of the project.

Yes

SummaryActualValueByCost The summary actual value by cost of the project.

Yes

SummaryActualValueByLaborUnits The summary actual value by labor units of the project.

Yes

SummaryAtCompletionDuration The summary at completion Yes


193


duration of the project.

SummaryAtCompletionExpenseCost The summary at completion expense cost of the project.

Yes

SummaryAtCompletionLaborCost The summary at completion labor cost of the project.

Yes

SummaryAtCompletionLaborUnits The summary at completion labor units of the project.

Yes

SummaryAtCompletionMaterialCost The summary at completion material cost of the project.

Yes

SummaryAtCompletionNonLaborCostThe summary at completion nonlabor cost of the project.

Yes

SummaryAtCompletionNonLaborUnitsThe summary at completion nonlabor units of the project.

Yes

SummaryAtCompletionTotalCost The summary at completion total cost of the project.

Yes


The summary at completion total cost variance of the project.

Yes


The summary baseline completed activity count of the project.

Yes

SummaryBaselineDuration The summary baseline duration of the project.

Yes

SummaryBaselineExpenseCost The summary baseline expense cost of the project.

Yes

SummaryBaselineFinishDate The summary baseline finish date of the project.

Yes


The summary baseline in progress activity count of the project.

Yes

SummaryBaselineLaborCost The summary baseline labor cost of the project.

Yes

SummaryBaselineLaborUnits The summary baseline labor units of the project.

Yes

SummaryBaselineMaterialCost The summary baseline material cost of the project.

Yes

SummaryBaselineNonLaborCost The summary baseline nonlabor cost of the project.

Yes

SummaryBaselineNonLaborUnits The summary baseline nonlabor Yes


194


Units of the project.


The summary baseline not start activity count of the project.

Yes

SummaryBaselineStartDate The summary baseline start date of the project.

Yes

SummaryBaselineTotalCost The summary baseline total cost of the project.

Yes

SummaryBudgetAtCompletionByCostThe summary budget at completion by cost of the project.

Yes


The summary budget at completion by labor units of the project.

Yes

SummaryCompletedActivityCount The summary completed activity count of the project.

Yes

SummaryCostPercentComplete The summary cost percent complete of the project.

Yes

SummaryCostPercentOfPlanned The summary cost percent of planned of the project.

Yes


The summary cost performance index by cost of the project.

Yes


The summary cost performance index by labor units of the project.

Yes

SummaryCostVarianceByCost The summary cost variance by cost of the project.

Yes

SummaryCostVarianceByLaborUnits The summary cost variance by labor units of the project.

Yes

SummaryCostVarianceIndex The summary cost variance index of the project.

Yes

SummaryCostVarianceIndexByCost The summary cost variance index by cost of the project.

Yes


The summary cost variance index by labor unit of the project.

Yes

SummaryDurationPercentComplete The summary duration percent complete of the project.

Yes

SummaryDurationPercentOfPlanned The summary duration percent of planned of the project.

Yes

SummaryDurationVariance The summary duration variance Yes


195


of the project.

SummaryEarnedValueByCost The summary earned value by cost of the project.

Yes

SummaryEarnedValueByLaborUnits The summary earned value by labor units of the project.

Yes


The summary estimate at completion by cost of the project.

Yes


The summary estimate at completion by labor units of the project.

Yes


The summary estimate at completion high percent by labor units of the project.

Yes


The summary estimate at completion low percent by labor units of the project.

Yes

SummaryEstimateToCompleteByCostThe summary estimate to completion by cost of the project.

Yes


The summary estimate to completion by labor units of the project.

Yes


The summary expense cost percent complete of the project.

Yes

SummaryExpenseCostVariance The summary expense cost variance of the project.

Yes

SummaryFinishDateVariance The summary finish date variance of the project.

Yes

SummaryInProgressActivityCount The summary in progress activity count of the project.

Yes

SummaryLaborCostPercentComplete The summary labor cost percent complete of the project.

Yes

SummaryLaborCostVariance The summary labor cost variance of the project.

Yes

SummaryLaborUnitsPercentCompleteThe summary labor units percent complete of the project.

Yes

SummaryLaborUnitsVariance The summary labor units variance of the project.

Yes


196


SummaryLevel Indicates summary level of the project

No


The summary material cost percent complete of the project.

Yes

SummaryMaterialCostVariance The summary material cost variance of the project.

Yes


The summary nonlabor cost percent complete of the project.

Yes

SummaryNonLaborCostVariance The summary nonlabor cost variance of the project.

Yes


The summary nonlabor units percent complete of the project.

Yes

SummaryNonLaborUnitsVariance The summary nonlabor units variance of the project.

Yes

SummaryNotStartedActivityCount The summary non started activity count of the project.

Yes


The summary performance percent complete by cost of the project.

Yes


The summary performance percent complete by labor units of the project.

Yes

SummaryPlannedCost The summary planned cost of the project.

Yes

SummaryPlannedDuration The summary planned duration of the project.

Yes

SummaryPlannedExpenseCost The summary planned expense cost of the project.

Yes

SummaryPlannedFinishDate The summary planned finish date of the project.

Yes

SummaryPlannedLaborCost The summary planned labor cost of the project.

Yes

SummaryPlannedLaborUnits The summary planned labor units of the project.

Yes

SummaryPlannedMaterialCost The summary planned material cost of the project.

Yes

SummaryPlannedNonLaborCost The summary planned non labor Yes


197


cost of the project.

SummaryPlannedNonLaborUnits The summary planned non labor units of the project.

Yes

SummaryPlannedStartDate The summary planned start date of the project.

Yes

SummaryPlannedValueByCost The summary planned value by cost of the project.

Yes

SummaryPlannedValueByLaborUnits The summary planned value by labor units of the project.

Yes

SummaryProgressFinishDate The summary progress finish date of the project.

Yes

SummaryRemainingDuration The summary remaining duration of the project.

Yes

SummaryRemainingExpenseCost The summary remaining expense cost of the project.

Yes

SummaryRemainingFinishDate The summary remaining finish date of the project.

Yes

SummaryRemainingLaborCost The summary remaining labor cost of the project.

Yes

SummaryRemainingLaborUnits The summary remaining labor units of the project.

Yes

SummaryRemainingMaterialCost The summary remaining material cost of the project.

Yes

SummaryRemainingNonLaborCost The summary remaining non labor cost of the project.

Yes

SummaryRemainingNonLaborUnits The summary remaining non labor units of the project.

Yes

SummaryRemainingStartDate The summary remaining start date of the project.

Yes

SummaryRemainingTotalCost The summary remaining total cost of the project.

Yes

SummarySchedulePercentComplete The summary schedule percent complete of the project.

Yes


The summary schedule percent complete by labor units of the project.

Yes

SummarySchedulePerformanceIndex The summary schedule Yes


198


ByCost performance index by cost of the project.


The summary schedule performance index by labor units of the project.

Yes

SummaryScheduleVarianceByCost The summary schedule variance by cost of the project.

Yes


The summary schedule variance by labor units of the project.

Yes

SummaryScheduleVarianceIndex The summary schedule variance index of the project.

Yes


The summary schedule variance index by cost of the project.

Yes


The summary schedule variance index by labor units of the project.

Yes

SummaryStartDateVariance The summary start date variance of the project.

Yes


The summary to complete performance index by cost of the project.

Yes

SummaryTotalCostVariance The summary total cost variance of the project.

Yes

SummaryTotalFloat The summary total float of the project.

Yes

SummaryUnitsPercentComplete The summary units percent complete of the project.

Yes


The summary variance at completion by labor units of the project.

Yes

TotalBenefitPlan The total benefit plan of the project.

Yes

TotalBenefitPlanTally The total benefit plan tally of the project.

Yes

TotalFunding The total funding of the project. Yes

TotalSpendingPlan The total spending plan of the project.

Yes

TotalSpendingPlanTally The total spending plan tally of the project.

Yes


199


UnallocatedBudget The unallocated budget of the project.

Yes

UndistributedCurrentVariance The undistributed current variance of the project.

Yes

UseExpectedFinishDates The option used for setting activity finish dates as the expected finish dates when scheduling projects.

Yes

UseProjectBaselineForEarnedValue The Boolean use project baseline for earned value of the project.

No

WBSCodeSeparator The string wbs code separator of the project.

No

WBSMilestonePercentComplete The wbs milestone percent complete of the project.

Yes

WBSObjectId The unique ID of the associated WBS.

Yes

WebSiteURL The string web site URL of the project.

No

ProjectCode


Project codes from P6 can be exported to Prime or Sample providers using the Master Global Data flow. To export project codes, the following fields are required and must be specified: ID, Name, Code Length, Sequence, Secure Code Indicator, Code values and hierarchy of those values.


CodeTypeName The name of the project code type. Yes

CodeTypeObjectId The unique ID of the project code type. No


CreateDate The date this project code was created. Yes

CreateUser The name of the user that created this project code.

Yes


LastUpdateDate The date this project code was last updated. Yes


200


LastUpdateUser The name of the user that last updated this project code.

Yes





ProjectCodeType



CreateDate The date this project code type was created. Yes

CreateUser The name of the user that created this project code type.

Yes

IsSecureCode The flag indicating whether this is a secure project code type.

No

LastUpdateDate The date this project code type was last updated.

Yes

LastUpdateUser The name of the user that last updated this project code type.

Yes


No

MaxCodeValueWeight The maximum weight of the code values for this project code type.

No




Weight The weight for this project code type. No


201

ProjectResource

Description: Primavera's resource planning feature allows you to do high-level project planning for future project or project that does not require resource assignments at the activity level.


CommittedFlag

The Boolean value that determines whether a resource is committed, and so, the resource assignment is stable and unlikely to change. When calculating availability, Primavera considers only assignments that are marked as committed.

No

CreateDate The date this project resource was created.

Yes

CreateUser The name of the user that created this project resource.

Yes

FinishDate

The finish date of the assignment. By default, it is set to the Planned Start date of the project + 1 day, finishing at 5:00pm.

No

IsBaseline The Boolean value indicating if this business object is related to a Project or Baseline.

Yes


Yes

LastUpdateDate The date this project resource was last updated.

Yes

LastUpdateUser The name of the user that last updated this project resource.

Yes

LifeOfProjectFlag

The Boolean value that determines whether a resource that is assigned to a project at Project or WBS level, has that assignment for the duration of the project.

No


No

ProjectId The short code that uniquely identifies the associated project.

Yes


No


202


ProjectResourceCategoryName

The name of the associated project resource category.

No

ProjectResourceCategoryObjectId

The unique ID of the associated project resource category.

No

ResourceName The name of the associated resource. Yes


No

RoleName The name of the associated role. Yes


StartDate

The start date of the assignment. By default, it is set to the Planned Start date of the project. If LifeOfProjectFlag is set to true, this date is set to the Project Planned Start date.

No

Status The project or WBS status: 'Planned', 'Active', 'Inactive', 'What-If', or 'Requested'.

No

WBSCode The short code assigned to the associated WBS element for identification.

Yes

WBSObjectId The unique ID of the associated WBS. Yes

Relationship



CreateDate The date this relationship was created. Yes

CreateUser The name of the user that created this relationship.

Yes

IsPredecessorBaseline The Boolean value indicating if the predecessor activity is related to a Project or Baseline.

Yes


203


IsPredecessorTemplate The Boolean value indicating if this business object is related to a template project.

Yes

IsSuccessorBaseline The Boolean value indicating if the successor activity is related to a Project or Baseline.

Yes

IsSuccessorTemplate The Boolean value indicating if this business object is related to a template project.

Yes

Lag

The time lag of the relationship. This is the time lag between the predecessor activity's start or finish date and the successor activity's start or finish date, depending on the relationship type.

Yes


Yes


Yes


PredecessorActivityId The unique ID of the predecessor activity. Yes

PredecessorActivityName The name of the predecessor activity. Yes

PredecessorActivityObjectId

The unique ID of the predecessor activity. No

PredecessorActivityType The type of the predecessor activity, either 'Task Dependent', 'Resource Dependent', 'Level of Effort', or 'Milestone'.

Yes


No

PredecessorProjectObjectId

The unique ID of the project that owns the predecessor activity.

No

SuccessorActivityId The unique ID of the successor activity. Yes

SuccessorActivityName The name of the successor activity. Yes



The type of the successor activity, either 'Task Dependent', 'Resource Dependent', 'Level of Effort', 'Start Milestone', 'Finish Milestone', or 'WBS Summary'.

Yes


204



Yes

SuccessorProjectObjectId The unique ID of the project that owns the successor activity.

No


No

Resource



AutoComputeActuals

The option that determines whether the activity actual and remaining units, and start and finish dates for the resource are calculated automatically using the planned dates, planned units, and the activity's schedule percent complete.

No

BusinessUnit A Resource Code field to define the Business Unit of the Resource.

No



No


Yes

CalendarObjectId The unique ID of the calendar assigned to the resource.

No

CreateDate The date this resource was created. Yes

CreateUser The name of the user that created this resource.

Yes

CurrencyId The unique currency abbreviation for the currency associated with this resource.

Yes

CurrencyName The name of the currency associated with this resource.

Yes


205


CurrencyObjectId The unique ID of the currency associated with this resource.

No

DefaultUnitsPerTime

The default units/time setting, which determines the value of the remaining units/time and planned units/time when a resource assignment is added.

No

DepartmentId A Resource Code field to define the Department ID of the Resource.

No

EffectiveDate The earliest day when the resource becomes over allocated. This date is calculated during the summarization.

Yes

EmailAddress The e-mail address for the resource. No


No


No

Id The short code that uniquely identifies the resource.

No

IntegratedType


No

IsActive

The option that determines whether the resource is currently active. Non-active resources may be resources that have left the organization but not deleted from the system since they may have actual hours.

No

IsOverTimeAllowed The option that determines whether the resource is allowed to log overtime hours.

No

LastUpdateDate The date this resource was last updated.

Yes

LastUpdateUser The name of the user that last updated this resource.

Yes


206



Yes


No


Yes



No

OfficePhone The office phone number for the resource.

No

OtherPhone The other phone numbers for the resource - pager, home phone, cell phone, etc.

No

OvertimeFactor The overtime factor used to compute the overtime price for the resource.

No


No

PricePerUnit

The planned price per unit for the project expense. This number is multiplied by the planned number of units to compute the planned cost.

Yes


Yes

PrimaryRoleName The name of the primary role for this resource.

Yes

PrimaryRoleObjectId The unique ID of the role that is assigned as the resource's primary role.

No

ResourceNotes The notes about the resource. No

ResourceType

The resource type: Labor resource performs labor and is measured in units of time, Nonlabor resource does not perform labor and is measured in units of time, Material resource has a unit of measure other than time.

No



207


ShiftObjectId The unique ID of the shift associated with the resource.

No

TimesheetApprovalManager

The resource manager assigned to approve timesheets for the resource.

Yes

TimesheetApprovalManagerObjectId

The unique ID of the resource manager assigned to approve timesheets for the resource.

Yes

Title The title of the resource. Yes

UnitOfMeasureAbbreviation

The unique ID of the unit of measure this material resource uses.

Yes

UserName The user's login name. Yes

UserObjectId The unique ID of the associated user. No

UseTimesheets The option that determines whether the resource uses timesheets.

Yes

ResourceAssignment

Description: Resource assignments track the work of resources or roles that are performing various activities.



Yes

ActivityName The name of the activity. The activity name does not have to be unique.

Yes


No

ActivityType Yes

ActualCost

The actual non-overtime plus overtime cost for the resource assignment on the activity. Computed as actual cost = actual regular cost + actual overtime cost.

No

ActualDuration The actual duration for the resource assignment on the activity.

Yes

ActualFinishDate The date the resource actually finished working on the activity.

No


208


ActualOvertimeCost

The actual overtime cost for the resource assignment on the activity. Computed as actual overtime cost = actual overtime units * cost per time * overtime factor.

No

ActualOvertimeUnits

The actual overtime units worked by the resource on this activity. This value is computed from timesheets when project actuals are applied or may be entered directly by the project manager.

No

ActualRegularCost

The actual non-overtime cost for the resource assignment on the activity. Computed as actual regular cost = actual regular units * cost per time.

No

ActualRegularUnits


No

ActualStartDate The date the resource actually started working on the activity.

No

ActualThisPeriodCost The actual this period cost (will be labor or nonlabor).

No

ActualThisPeriodUnits The actual this period units (hours) (will be labor or nonlabor).

No

ActualUnits

The actual non-overtime plus overtime units worked by the resource on this activity. This value is computed from timesheets when project actuals are applied or may be entered directly by the project manager.

No

AtCompletionCost The sum of the actual plus remaining costs for the resource assignment on the activity.

No


Yes


No

AutoComputeActuals The option that determines whether the activity's actual and remaining units, start date, finish date, and percent complete are

Yes


209


computed automatically using the planned dates, planned units and the schedule percent complete.


CalendarObjectId The unique ID generated by the system for the calendar associated with the resource assignment.

Yes

CostAccountId The ID of associated cost account. Yes

CostAccountName The name of the associated cost account. Yes

CostAccountObjectId The unique ID of the cost account associated with this resource assignment.

No

CreateDate The date this assignment was created. Yes

CreateUser The name of the user that created this assignment.

Yes

Designator A Resource Assignment UDF. No

DrivingActivityDatesFlag The flag indicating whether new resource/role assignments drive activity dates, by default.

No

EBSBudgetCurrentCost EBS_RAS_Budget_Current_Cost No

EBSBudgetCurrentQuantity EBS_RAS_Budget_Current_Qty No

EBSBudgetOriginalCost EBS_RAS_Budget_Original_Cost No

EBSBudgetOriginalQuantity

EBS_RAS_Budget_Original_Qty No

EBSBudgetProposedCost EBS_RAS_Budget_Proposed_Cost No


EBS_RAS_Budget_Proposed_Qty No

EBSBudgetStatusCode EBS_RAS_Budget_Status_Code No

EBSBudgetVersionName EBS_RAS_Budget_Version_Name No

EBSBudgetVersionNumber EBS_RAS_Budget_Version_Number No

EBSPlannedCost EBS_RAS_Planned_Cost No

FinishDate

The finish date of the resource assignment on the activity. Set to the remaining finish date until the activity is completed, then set to the actual finish date.

No


No


210


HasFutureBucketData The flag that indicates whether the assignment has future bucket data.

Yes

IsActive

The option that determines whether the resource is currently active. Non-active resources may be resources that have left the organization but not deleted from the system since they may have actual hours.

Yes

IsActivityFlagged No

IsBaseline The flag that indicates whether this resource assignment is active.

Yes

IsCostUnitsLinked The flag that determines whether or not cost should be calculated based on units.

No

IsOvertimeAllowed The flag that indicates whether the resource is allowed to log overtime hours.

Yes


No

IsTemplate The boolean value indicating if this business object is related to a template Project.

Yes

LastUpdateDate The date this assignment was last updated.

Yes

LastUpdateUser The name of the user that last updated this assignment.

Yes


OvertimeFactor

The overtime factor used to compute the overtime price for the resource assignment on this activity. Overtime price = standard price * overtime factor.

No

PendingActualOvertimeUnits

The actual overtime units worked by the resource on this activity.

Yes

PendingActualRegularUnitsThe actual nonovertime units worked by the resource on this activity.

Yes

PendingPercentComplete

The estimate of the percentage of the resource's units of work completed on this activity. The pending percent complete is entered by each resource using Timesheets.

No

PendingRemainingUnits The estimate of the resource's remaining units on this activity. The pending

No


211


remaining units is entered by each resource using Timesheets.

PlannedCost

The planned cost for the resource assignment on the activity. Computed as planned cost = planned units * price per time.

No

PlannedDuration


No

PlannedFinishDate

The date the resource is scheduled to finish working on the activity. This date is computed by the project scheduler but can be updated manually by the project manager.

No

PlannedLag

The planned time lag between the activity's planned start date and the resource's planned start date on the activity. If the resource is planned to start work when the activity is planned to start, the planned lag is zero.

No

PlannedStartDate

The date the resource is scheduled to begin working on the activity. This date is computed by the project scheduler but can be updated manually by the project manager.

No

PlannedUnits

The planned units of work for the resource assignment on the activity. This field is named BudgetedUnits in Primavera's Engineering and Construction and Maintenance and Turnaround solutions.

No


No

PricePerUnit The price per time for the resource on this activity. This price is used to compute the resource's cost for the activity.

No

PriorActualOvertimeUnits

The difference between the pending quantity value and the actual quantity value for overtime before applying the new actual value.

Yes

PriorActualRegularUnits The difference between the pending Yes


212


quantity value and the actual quantity value before applying the new actual value.

Proficiency The skill level that is associated with the role. The values are 'Master', 'Expert', 'Skilled', 'Proficient', and 'Inexperienced'.

No


Yes


RateSource

The value that indicates which price/unit will be used to calculate costs for the assignment, such as 'Resource', 'Role', and 'Override'.

No

RateType

The rate type that determines which of the five prices specified for the resource will be used to calculate the cost for the resource assignment.

No

RemainingCost

The remaining cost for the resource assignment on the activity. Computed as remaining cost = remaining units * cost per time.

No

RemainingDuration

The remaining duration of the resource assignment. The remaining duration is the remaining working time for the resource assignment on the activity, from the resource's remaining start date to the remaining finish date.

No

RemainingFinishDate

The date the resource is scheduled to finish the remaining work for the activity. This date is computed by the project scheduler but can be updated manually by the project manager.

No

RemainingLag The time lag between the activity's remaining start date and the resource's remaining start date on the activity.

No

RemainingLateFinishDate The remaining late finish date calculated by the scheduler.

Yes

RemainingLateStartDate The remaining late start date calculated by the scheduler.

Yes

RemainingStartDate The date the resource is scheduled to No


213


begin the remaining work for the activity. This date is computed by the project scheduler but can be updated manually by the project manager.

RemainingUnits

The remaining units of work to be performed by this resource on this activity. Before the activity is started, the remaining units are the same as the planned units. After the activity is completed, the remaining units are zero.

No

RemainingUnitsPerTime The units per time at which the resource will be performing work on the remaining portion of this activity.

No

ResourceCalendarName The name of the calendar for the resource. Yes

ResourceCurveName The name of the resource curve that determines how resources and costs are distributed over time for this activity.

Yes

ResourceCurveObjectId The unique ID of the resource curve. No


Yes




No


Yes

RoleName The name of the role. The role name uniquely identifies the role.

Yes

RoleObjectId

The unique ID of the role the resource is performing on this activity. A resource may be assigned to the same activity more than once, performing different roles.

No

RolledUpWBSObjectId Rolled up WBS Object Ids after filtering either by levels or tagging.

No

StaffedRemainingCost The time distribution of the resource's remaining cost for resource assignments that have filled a role.

Yes

StaffedRemainingUnits The time distribution of the resource's remaining units for resource assignments

Yes


214


that have filled a role.

StartDate

The start date of the resource assignment on the activity. Set to the remaining start date until the activity is started, then set to the actual start date.

No

TotalActualCost A Resource Assignment UDF to store Total Actual Cost for the Resource Assignment.

No

TotalCommitmentCost A Resource Assignment UDF to store Total Commitment Cost for the Resource Assignment.

No

TotalPlannedCost A Resource Assignment UDF to store Total Planned Cost for the Resource Assignment.

No


The percent complete of units for the resource assignment on the activity. Computed as actual units / at completion units * 100. Always in the range 0 to 100.

No

UnstaffedRemainingCost The time distribution of the resource's remaining cost for resource assignments that have not filled a role.

Yes

UnstaffedRemainingUnits The time distribution of the resource's remaining units for resource assignments that have not filled a role.

Yes

VCPRasDemandPeggedAvlDate

VCP Resource Assignment Demand Pegged Avl Date (UDF)

No

VCPRasDemandPeggedAvlOrderNumber

VCP Resource Assignment Demand Pegged Order Number (UDF)

No

VCPRasDemandPeggedAvlOrderType

VCP Resource Assignment Demand Pegged Order Type (UDF)

No

VCPRasInventoryOrgCode VCP Resource Assignment Inventory Organization Code (UDF)

No

VCPRasSelection VCP Resource Assignment code for filtering (UDF)

No

VCPRasSelectionCode VCP Resource Assignment code for filtering (UDF)

No

VCPRasSupplyActualStartDate

VCP Resource Assignment Supply Actual Start Date (UDF)

No


215


VCPRasSupplyDockDate VCP Resource Assignment Supply Dock Date (UDF)

No

VCPRasSupplyDueDate VCP Resource Assignment Supply Due Date (UDF)

No

VCPRasSupplyItemId VCP Resource Assignment Supply Item Id (UDF)

No

VCPRasSupplyItemName VCP Resource Assignment Supply Item Name (UDF)

No

VCPRasSupplyOrderDate VCP Resource Assignment Supply Order Date (UDF)

No

VCPRasSupplyOrderNumber

VCP Resource Assignment Supply Order Number (UDF)

No

VCPRasSupplyOrderType VCP Resource Assignment Supply Order Type (UDF)

No

VCPRasSupplyOrganization

VCP Resource Assignment Supply Organization (UDF)

No

VCPRasSupplyPeggedOrderNumber

VCP Resource Assignment Supply Pegged Order Number (UDF)

No

VCPRasSupplyQuantity VCP Resource Assignment Supply Quantity (UDF)

No

VCPRasSupplyShipDate VCP Resource Assignment Supply Ship Date (UDF)

No

VCPRasSupplyStartDte VCPRasSupplyStartDte No

VCPRasSupplyUpdatedArrivalDate

VCP Resource Assignment Supply Updated Arrival Date (UDF)

No

WBSObjectId The unique ID of the WBS for the activity. Yes

ResourceCode

Description: Resource codes are user-defined to classify and categorize resources across the enterprise.


CodeTypeName The name of the resource code type. Yes

CodeTypeObjectId The unique ID of the resource code type. No


216



CreateDate The date this resource code was created. Yes

CreateUser The name of the user that created this resource code.

Yes

Description The description of the resource code. No


Yes


Yes


ParentObjectId The unique ID of the parent resource code. No


ResourceCodeType

Description: Resource code types provide a way of classifying resource codes. Resource codes are user-defined codes to calssify and categorize resources across the enterprise.


CreateDate The date this resource code type was created. Yes

CreateUser The name of the user that created this resource code type.

Yes

IsSecureCode The flag indicating whether this is a secure resource code type.

No

LastUpdateDate The date this resource code was last updated. Yes


Yes


No





217

ResourceRate

Description: Resource rates provide a way of specifying multiple resource prices and maximum units per time values that vary over time.


CreateDate The date this resource rate was created. Yes

CreateUser The name of the user that created this resource rate.

Yes

EffectiveDate The effective date for the resource price and maximum units per time.

No

LastUpdateDate The date this resource rate was last updated. Yes

LastUpdateUser The name of the user that last updated this resource rate.

Yes


No


PricePerUnit The non-overtime price per time for the resource. This price is used to compute costs for any activities the resource is assigned to.

No

PricePerUnit2 The non-overtime price per time for the resource. This price is used to compute costs for any activities the resource is assigned to.

No


No


No


No


Yes



ShiftPeriodObjectId The unique ID of the associated shift. No


218

ResourceCurve

Description: Resource curves enable you to specify how you want resource units or costs spread over the duration of an activity.




Yes

CurveData The 21-point curve data. No

IsDefault The flag that identifies the default curve. Yes

LastUpdateDate The date this resource code was last updated..

Yes


Yes

Name The name of the resource curve No


ResourceRole

Description: A resource role object represents an association between a resource object and a role object.




Yes


Yes


Yes


Proficiency The resource's proficiency at performing this role.

No


Yes



219




Yes

RoleName The name of the role. Yes


Risk



Cause The description of the cause of the Risk. No

Description The description of the Risk. No

Effect The description of the risks effect on the project. No

Id The ID of the Risk. Must be unique within a project. No


Name The name of the Risk. Does not need to be unique. No




ResponseTotalCost

The total estimated cost for the risk. No

Status The current status of the Risk. Valid values are 'Proposed', 'Open', 'Rejected', 'Managed', and 'Impacted'.

No


No

RiskImpact



220








RiskThresholdLevelCode

The short name of the associated risk threshold level.

Yes

RiskThresholdLevelName

The name of the associated risk threshold level.

Yes



No

RiskThresholdName The name of the associated risk threshold. Yes

RiskThresholdObjectId The unique ID of the associated risk threshold. Yes

RiskMatrix






Yes

IsActive


No




221




Yes

RiskScoringMethod The calculation method used to determine the risk score. Valid values are 'Highest', 'Average of Impacts', 'Average of Individual Scores'.

No

RiskMatrixScore






No

RiskMatrixName The name of the associated risk matrix. Yes

RiskMatrixObjectId The unique ID of the associated risk matrix. No

Severity1 The first severity level of the Risk Matrix Score.

No


Severity2 The second severity level of the Risk Matrix Score.

No


Severity3 The third severity level of the Risk Matrix Score.

No


Severity4 The fourth severity level of the Risk Matrix Score.

No


Severity5 The fifth severity level of the Risk Matrix Score.

No



222


Severity6 The sixth severity level of the Risk Matrix Score.

No


Severity7 The seventh severity level of the Risk Matrix Score.

No


Severity8 The eighth severity level of the Risk Matrix Score.

No


Severity9 The ninth severity level of the Risk Matrix Score.

No


RiskMatrixThreshold




RiskMatrixName The name of the associated risk matrix. Yes




No

RiskResponseAction



223


ActivityId The short name of the associated activity. Yes




FinishDate The finish date of the risk response action. If an activity is assigned, the risk response action uses the activity finish date.

No










No

ResourceId The short name of the associated resource. Yes




RiskResponsePlanIdThe short name of the associated risk response plan.

Yes

RiskResponsePlanName

The name of the associated risk response plan. Yes

RiskResponsePlanObjectId

The unique ID of the associated risk response plan.

No

StartDate The start date of the risk response action. If an activity is assigned, the risk response action uses the activity start date.

No

Status The status of the risk response action. Valid values are 'Proposed', 'Sanctioned', 'Rejected', 'InProgress', and 'Complete'.

No


224








RiskResponseActionId

The short name of the associated risk response action.

Yes

RiskResponseActionName

The name of the associated risk response action.

Yes

RiskResponseActionObjectId

The unique ID of the associated risk response action.

No

RiskThresholdLevelCode

The short name of the associated risk threshold level.

Yes


The name of the associated risk threshold level. Yes



No


RiskThresholdObjectId

The unique ID of the associated risk threshold. Yes

RiskResponsePlan




IsActive The indication of whether the response plan is currently active for the associated risk. Only one response plan can be active at a given time for a risk.

No



225





ResponseType


No




RiskThreshold





ThresholdType The type of Risk Threshold. Valid types are 'Probability', 'Tolerance', 'Schedule', 'Cost', 'Relative Schedule', 'Relative Cost' and 'User Defined'.

Yes

RiskThresholdLevel



Code The 10 character code for the threshold level. No


No



226



No

Name The 40 character name for the threshold level. No


ProbabilityRange The probability range of the threshold level. No


RiskThresholdName

The name of the associated risk threshold. Yes

RiskThresholdObjectId

The unique ID of the associated risk threshold. No


ThresholdType The type of Risk Threshold. Valid types are 'Probability', 'Tolerance', 'Schedule', 'Cost', 'Relative Schedule', 'Relative Cost' and 'User Defined'.

Yes


Role





No

CreateDate The date this role was created. Yes

CreateUser The name of the user that created this role. Yes

Id The short code that uniquely identifies the role. No

LastUpdateDate The date this role was last updated. Yes

LastUpdateUser The name of the user that last updated this role. Yes

Name The name of the role. No


ParentObjectId The unique ID of the parent role of this role in the No


227


hierarchy.

Responsibilities The responsibilities for the role. No

SequenceNumber


RoleLimit

Description: Role limits define the limits of the maximum work units per time for a Role in a time period.




Yes

EffectiveDate The effective date for the role maximum units per time.

No


Yes


Yes

MaxUnitsPerTime the maximum work units per time this role can perform on all their assigned activities.

No

Role ObjectId The unique ID generated by the system. No

SequenceNumber The sequence number for sorting No

RoleRate

Description: Role rates enable you to select a predefined price per unit for cost calculating when assigning the role to an activity.


CreateDate The date this role rate was created. Yes

CreateUser The name of the user that created this role rate. Yes

LastUpdateD The date this role rate was last updated. Yes


228


ate

LastUpdateUser

The name of the user that last updated this role rate. Yes


PricePerUnit The non-overtime price per time for the role. This price is used to compute costs for any activities the role is assigned to.

No

PricePerUnit2The non-overtime price per time for the role. This price is used to compute costs for any activities the role is assigned to.

No


No


No


No

RoleId The short code that uniquely identifies the role. Yes

RoleName The name of the role. Yes


UDFType


UDF codes from P6 can be exported to Prime or Sample providers using the Export Global Data flow. However, first export the project UDFs, and then export all other UDF dictionaries. The default field mapping template must included all fields listed below.


CreateDate The date this user-defined field was created. Yes


Yes

DataType The data type of the user-defined field: "Text", "Start Date", "Finish Date", "Cost", "Double",

No


229


"Integer", "Indicator", or "Code".

IsCalculated The flag indicating whether this is a calculated user defined field type.

Yes

IsConditional The flag indicating whether this is a indicator user defined field type.

Yes

IsSecureCode The flag indicating whether this is a secure code type.

No

LastUpdateDate The date this user-defined field was last updated. Yes


Yes


SubjectArea The subject area of the user-defined field. No

Title The name/title of the user-defined field. No

UnitOfMeasure

Description: The unit of measure provides definition of units of measure for material resources.




Yes

LastUpdateDate The date this resource code was last updated. Yes


Yes

Name The name of the unit of measure. No


SequenceNumber The sequence number for sorting No

WBS



230


AnticipatedFinishDate The anticipated finish date of WBS, project and EPS elements.

No

AnticipatedStartDate The anticipated start date of WBS, project and EPS elements.

No

Code The short code assigned to each WBS element for identification.

Ni

ContainsSummaryData The Boolean contains summary data flag of the WBS.

Yes

CreateDate The created date of the WBS. Yes

CreateUser The user who created the WBS. Yes

CurrentBudget The current budget of the WBS. Yes

CurrentVariance The current variance of the WBS. Yes

DistributedCurrentBudget The distributed current budget of the WBS.

Yes

EarnedValueComputeType Indicates earned value compute type of the WBS

No

EarnedValueETCComputeType Indicates earned value ETC compute type of the WBS

No

EarnedValueETCUserValue The earned value ETC user value for WBS computing earned value.

No

EarnedValueUserPercent The earned value user percent for WBS to compute earned value.

No

EBSBudgetCurrentCost EBS_WBS_Budget_Current_Cost No

EBSBudgetCurrentQuantity EBS_WBS_Budget_Current_Qty No

EBSBudgetOriginalCost EBS_WBS_Budget_Original_Cost No

EBSBudgetOriginalQuantity EBS_WBS_Budget_Original_Qty No

EBSBudgetProposedCost EBS_WBS_Budget_Proposed_Cost

No

EBSBudgetProposedQuantity EBS_WBS_Budget_Proposed_Qty

No

EBSBudgetStatusCode EBS_WBS_Budget_Status_Code No

EBSBudgetVersionName EBS_WBS_Budget_Version_Name

No

EBSBudgetVersionNumber EBS_WBS_Budget_Version_Num No


231


ber

EBSPlannedCost EBS_WBS_Planned_Cost No

FinishDate The date finish date of the WBS. Yes

ForecastFinishDate The date forecast finish date of the WBS.

Yes

ForecastStartDate The date forecast start date of the WBS.

Yes

GUID The GUID of the WBS. No

IndependentETCLaborUnits The independent ETC labor units of the WBS.

No

IndependentETCTotalCost The independent ETC total cost of the WBS.

No

IntegratedType Indicates integrated type of the WBS

No

IsBaseline The Boolean is baseline flag of the WBS.

Yes

IsTemplate The Boolean is template flag of the WBS.

Yes

IsWorkPackage Whether this WBS is a work package.

No

LastUpdateDate The last update date of the WBS. Yes

LastUpdateUser The last update user of the WBS. Yes



No

OBSName The obs name of the WBS. Yes

OBSObjectId The obs object id of the WBS. No

OriginalBudget The original budget of the project. No


No

ProjectId The project Id of the WBS. Yes


No

ProposedBudget The proposed budget of the WBS. Yes


232


SequenceNumber The sequence number of the WBS.

No

StartDate The start date of the WBS. Yes

Status The status of the WBS. No

SummaryAccountingVarianceByCost

The summary accounting variance by cost of the WBS.

Yes


The summary accounting variance by labor units of the WBS.

Yes

SummaryActivityCount The summary activity count of the WBS.

Yes

SummaryActualDuration The summary actual duration of the WBS.

Yes

SummaryActualExpenseCost The summary actual expense costof the WBS.

Yes

SummaryActualFinishDate The summary actual finish date of the WBS.

Yes

SummaryActualLaborCost The summary actual labor cost of the WBS.

Yes

SummaryActualLaborUnits The summary actual labor units of the WBS.

Yes

SummaryActualMaterialCost The summary actual material cost of the WBS.

Yes

SummaryActualNonLaborCost The summary actual nonlabor cost of the WBS.

Yes

SummaryActualNonLaborUnits The summary actual nonlabor units of the WBS.

Yes

SummaryActualStartDate The summary actual start date of the WBS.

Yes

SummaryActualThisPeriodCost The summary actual this period cost of the WBS.

Yes

SummaryActualThisPeriodLaborCost

The summary actual this period labor cost of the WBS.

Yes

SummaryActualThisPeriodLaborUnits

The summary actual this period labor unit of the WBS.

Yes


The summary actual this period material cost of the WBS.

Yes


233



The summary actual this period nonlabor cost of the WBS.

Yes


The summary actual this period nonlabor unit of the WBS.

Yes

SummaryActualTotalCost The summary actual total cost of the WBS.

Yes

SummaryActualValueByCost The summary actual value by cost of the WBS.

Yes

SummaryActualValueByLaborUnits

The summary actual value by labor units of the WBS.

Yes

SummaryAtCompletionDuration The summary at completion duration of the WBS.

Yes

SummaryAtCompletionExpenseCost

The summary at completion expense cost of the WBS.

Yes

SummaryAtCompletionLaborCost

The summary at completion labor cost of the WBS.

Yes

SummaryAtCompletionLaborUnits

The summary at completion labor units of the WBS.

Yes

SummaryAtCompletionMaterialCost

The summary at completion material cost of the WBS.

Yes

SummaryAtCompletionNonLaborCost

The summary at completion nonlabor cost of the WBS.

Yes

SummaryAtCompletionNonLaborUnits

The summary at completion nonlabor units of the WBS.

Yes

SummaryAtCompletionTotalCostThe summary at completion total cost of the WBS.

Yes


The summary at completion total cost variance of the WBS.

Yes


The summary baseline completed activity count of the WBS.

Yes

SummaryBaselineDuration The summary baseline duration of the WBS.

Yes

SummaryBaselineExpenseCost The summary baseline expense cost of the WBS.

Yes

SummaryBaselineFinishDate The summary baseline finish date of the WBS.

Yes

SummaryBaselineInProgressActi The summary baseline in progress Yes


234


vityCount activity count of the WBS.

SummaryBaselineLaborCost The summary baseline labor cost of the WBS.

Yes

SummaryBaselineLaborUnits The summary baseline labor units of the WBS.

Yes

SummaryBaselineMaterialCost The summary baseline material cost of the WBS.

Yes

SummaryBaselineNonLaborCostThe summary baseline nonlabor cost of the WBS.

Yes

SummaryBaselineNonLaborUnitsThe summary baseline nonlabor Units of the WBS.

Yes


The summary baseline not start activity count of the WBS.

Yes

SummaryBaselineStartDate The summary baseline start date of the WBS.

Yes

SummaryBaselineTotalCost The summary baseline total cost of the WBS.

Yes

SummaryBudgetAtCompletionByCost

The summary budget at completion by cost of the WBS.

Yes


The summary budget at completion by labor units of the WBS.

Yes

SummaryCompletedActivityCount

The summary completed activity count of the WBS.

Yes

SummaryCostPercentComplete The summary cost percent complete of the WBS.

Yes

SummaryCostPercentOfPlanned The summary cost percent of planned of the WBS.

Yes


The summary cost performance index by cost of the WBS.

Yes


The summary cost performance index by labor units of the WBS.

Yes

SummaryCostVarianceByCost The summary cost variance by cost of the WBS.

Yes

SummaryCostVarianceByLaborUnits

The summary cost variance by labor units of the WBS.

Yes

SummaryCostVarianceIndex The summary cost variance index Yes


235


of the WBS.

SummaryCostVarianceIndexByCost

The summary cost variance index by cost of the WBS.

Yes


The summary cost variance index by labor unit of the WBS.

Yes

SummaryDurationPercentComplete

The summary duration percent complete of the WBS.

Yes

SummaryDurationPercentOfPlanned

The summary duration percent of planned of the WBS.

Yes

SummaryDurationVariance The summary duration variance of the WBS.

Yes

SummaryEarnedValueByCost The summary earned value by cost of the WBS.

Yes

SummaryEarnedValueByLaborUnits

The summary earned value by labor units of the WBS.

Yes


The summary estimate at completion by cost of the WBS.

Yes


The summary estimate at completion by labor units of the WBS.

Yes


The summary estimate at completion high percent by labor units of the WBS.

Yes


The summary estimate at completion low percent by labor units of the WBS.

Yes

SummaryEstimateToCompleteByCost

The summary estimate to completion by cost of the WBS.

Yes


The summary estimate to completion by labor units of the WBS.

Yes


The summary expense cost percent complete of the WBS.

Yes

SummaryExpenseCostVariance The summary expense cost variance of the WBS.

Yes

SummaryFinishDateVariance The summary finish date variance of the WBS.

Yes


236


SummaryInProgressActivityCount

The summary in progress activity count of the WBS.

Yes

SummaryLaborCostPercentComplete

The summary labor cost percent complete of the WBS.

Yes

SummaryLaborCostVariance The summary labor cost variance of the WBS.

Yes

SummaryLaborUnitsPercentComplete

The summary labor units percent complete of the WBS.

Yes

SummaryLaborUnitsVariance The summary labor units variance of the WBS.

Yes


The summary material cost percent complete of the WBS.

Yes

SummaryMaterialCostVariance The summary material cost variance of the WBS.

Yes


The summary nonlabor cost percent complete of the WBS.

Yes

SummaryNonLaborCostVarianceThe summary nonlabor cost variance of the WBS.

Yes


The summary nonlabor units percent complete of the WBS.

Yes

SummaryNonLaborUnitsVariance

The summary nonlabor units variance of the WBS.

Yes

SummaryNotStartedActivityCount

The summary non started activity count of the WBS.

Yes


The summary performance percent complete by cost of the WBS.

Yes


The summary performance percent complete by labor units of the WBS.

Yes

SummaryPlannedCost The summary planned cost of the WBS.

Yes

SummaryPlannedDuration The summary planned duration of the WBS.

Yes

SummaryPlannedExpenseCost The summary planned expense cost of the WBS.

Yes

SummaryPlannedFinishDate The summary planned finish date Yes


237


of the WBS.

SummaryPlannedLaborCost The summary planned labor cost of the WBS.

Yes

SummaryPlannedLaborUnits The summary planned labor units of the WBS.

Yes

SummaryPlannedMaterialCost The summary planned material cost of the WBS.

Yes

SummaryPlannedNonLaborCost The summary planned non labor cost of the WBS.

Yes

SummaryPlannedNonLaborUnitsThe summary planned non labor units of the WBS.

Yes

SummaryPlannedStartDate The summary planned start date of the WBS.

Yes

SummaryPlannedValueByCost The summary planned value by cost of the WBS.

Yes

SummaryPlannedValueByLaborUnits

The summary planned value by labor units of the WBS.

Yes

SummaryProgressFinishDate The summary progress finish date of the WBS.

Yes

SummaryRemainingDuration The summary remaining duration of the WBS.

Yes

SummaryRemainingExpenseCost

The summary remaining expense cost of the WBS.

Yes

SummaryRemainingFinishDate The summary remaining finish date of the WBS.

Yes

SummaryRemainingLaborCost The summary remaining labor cost of the WBS.

Yes

SummaryRemainingLaborUnits The summary remaining labor units of the WBS.

Yes

SummaryRemainingMaterialCostThe summary remaining material cost of the WBS.

Yes

SummaryRemainingNonLaborCost

The summary remaining non labor cost of the WBS.

Yes

SummaryRemainingNonLaborUnits

The summary remaining non labor units of the WBS.

Yes

SummaryRemainingStartDate The summary remaining start date of the WBS.

Yes


238


SummaryRemainingTotalCost The summary remaining total cost of the WBS.

Yes

SummarySchedulePercentComplete

The summary schedule percent complete of the WBS.

Yes


The summary schedule percent complete by labor units of the WBS.

Yes


The summary schedule performance index by cost of the WBS.

Yes


The summary schedule performance index by labor units of the WBS.

Yes

SummaryScheduleVarianceByCost

The summary schedule variance by cost of the WBS.

Yes


The summary schedule variance by labor units of the WBS.

Yes

SummaryScheduleVarianceIndex

The summary schedule variance index of the WBS.

Yes


The summary schedule variance index by cost of the WBS.

Yes


The summary schedule variance index by labor units of the WBS.

Yes

SummaryStartDateVariance The summary start date variance of the WBS.

Yes


The summary to complete performance index by cost of the WBS.

Yes

SummaryTotalCostVariance The summary total cost variance of the WBS.

Yes

SummaryTotalFloat The summary total float of the WBS.

Yes

SummaryUnitsPercentComplete The summary units percent complete of the WBS.

Yes


The summary variance at completion by labor units of the WBS.

Yes

TotalActualCost A WBS UDF to store Total Actual No


239


Cost for the WBS.

TotalBenefitPlan The total benefit plan of the WBS. Yes

TotalBenefitPlanTally The total benefit plan tally of the WBS.

Yes

TotalCommitmentCost A WBS UDF to store Total Commitment Cost for the WBS.

No

TotalPlannedCost A WBS UDF to store Total Planned Cost for the WBS.

No

TotalSpendingPlan The total spending plan of the WBS.

Yes

TotalSpendingPlanTally The total spending plan tally of the WBS.

Yes

UnallocatedBudget The unallocated budget of the WBS.

Yes

UndistributedCurrentVariance The undistributed current variance of the WBS.

Yes

WBSCategoryObjectId The unique WBS category objectId of the WBS.

No

WBSMilestonePercentComplete The wbs milestone percent complete of the WBS.

Yes

WBSCategory

Description: As their name implies, WBS categories are used to categorize WBS elements. They are defined globally.


CreateDate The date this WBS category was created. Yes

CreateUser The name of the user that created this WBS category.

Yes

LastUpdateDate The date this WBS category was last updated. Yes

LastUpdateUser The name of the user that last updated this WBS category.

Yes

Name The name of the WBS category. No



240


SequenceNumber

The sequence number of the WBS category. No

WBSExpenseSpread

Description: Expense spread data per WBS per ExpenseCategory.

Note: Expense category summaries are only supported by financial period.



AtCompletionCost At completion cost. No


ExpenseCategoryName

Expense Category name. No


The unique ID of expense category. No



No

PlannedCost Planned cost. No

RemainingCost Remaining cost. No



WBSObjectId The unique ID of the WBS. No

WBSResourceSpread

Description: Spread data per WBS per Resource


241


ActualCost

Actual cost.

The actual non-overtime plus overtime cost for the resource for the wbs or project. Computed as actual cost = actual regular cost + actual overtime cost.

No

ActualOvertimeCost

Actual Overtime Cost. No

ActualOvertimeUnits

Actual Overtime Units. No

ActualRegularCost Actual Regular Cost. No

ActualRegularUnits Actual Regular Units. No

ActualUnits Actual Units. No

AtCompletionCost At Completion Cost. No



Limit Limit. No



PeriodActualUnits Period Actual Units. No

PeriodAtCompletionCost

Period At Completion Cost. No

PeriodAtCompletionUnits

Period At Completion Units. No

PeriodType The type of period for summarized spread data. No


242


PlannedCost Planned Cost. No

PlannedUnits Planned Units. No



RemainingCost Remaining Cost. No

RemainingLateCost

Remaining Late Cost. No

RemainingLateUnits

Remaining Late Units. No


ResourceId Resource short name. No


RoleId Role short name. No


StaffedActualCost Staffed Actual Cost. No

StaffedActualOvertimeCost

Staffed Actual Overtime Cost. No

StaffedActualOvertimeUnits

Staffed Actual Overtime Units. No

StaffedActualRegularCost

Staffed Actual Regular Cost. No

StaffedActualRegularUnits

Staffed Actual Regular Units. No

StaffedActualUnits Staffed Actual Units. No

StaffedAtCompletionCost

Staffed At Completion Cost. No

StaffedAtCompletionUnits

Staffed At Completion Units. No

StaffedPlannedCost

Staffed Planned Cost. No

StaffedPlannedUnits

Staffed Planned Units. No

StaffedRemainingCost

Staffed Remaining Cost. No


243


StaffedRemainingLateCost

StaffedRemainingLateCost. No

StaffedRemainingLateUnits

Staffed Remaining Late Units. No

StaffedRemainingUnits

Staffed Remaining Units. No


WBSCode WBS code. No

WBSObjectId The unique ID of the WBS. No

WBSSpread

Description: Summarized spread data in each WBS



ActualExpenseCost Actual Expense Cost. No

ActualLaborCost Actual Labor Cost. No

ActualLaborUnits Actual Labor Units.

No

ActualMaterialCost Actual Material Cost.

No

ActualNonlaborCost Actual Nonlabor Cost.

No

ActualNonlaborUnits Actual Nonlabor Units.

No

ActualTotalCost

Actual Total Cost.

No

AtCompletionExpenseCost

At Completion Expense Cost.

No

AtCompletionLaborCost At Completion Labor Cost.

No


244


AtCompletionLaborUnits At Completion Labor Units.

No

AtCompletionMaterialCost

At Completion Material Cost. No

AtCompletionNonlaborCost

At Completion Nonlabor Cost. No

AtCompletionNonlaborUnits

At Completion Nonlabor Units. No

AtCompletionTotalCost At Completion Total Cost.

No

BaselinePlannedExpenseCost

Baseline Planned Expense Cost. No

BaselinePlannedLaborCost

Baseline Planned Labor Cost. No

BaselinePlannedLaborUnits

Baseline Planned Labor Units. No

BaselinePlannedMaterialCost

Baseline Planned Material Cost. No

BaselinePlannedNonlaborCost

Baseline Planned Nonlabor Cost. No

BaselinePlannedNonlaborUnits

Baseline Planned Nonlabor Units. No

BaselinePlannedTotalCost

Baseline Planned Total Cost. No

EarnedValueCost Earned Value Cost. No


245


EarnedValueLaborUnits Earned Value Labor Units. No


EstimateAtCompletionCost

Estimate At Completion Cost. No

EstimateAtCompletionLaborUnits

Estimate At Completion Labor Units. No

EstimateToCompleteCost

Estimate To Complete Cost. No

EstimateToCompleteLaborUnits

Estimate To Complete Labor Units. No



PeriodActualExpenseCost

Period Actual Expense Cost. No

PeriodActualLaborCost Period Actual Labor Cost. No

PeriodActualLaborUnits Period Actual Labor Units. No

PeriodActualMaterialCost

Period Actual Material Cost. No

PeriodActualNonLaborCost

Period Actual NonLabor Cost. No

PeriodActualNonLaborUnits

Period Actual NonLabor Units. No

PeriodAtCompletionExpenseCost

Period At Completion Expense Cost. No

PeriodAtCompletionLaborCost

Period At Completion Labor Cost. No


246


PeriodAtCompletionLaborUnits

Period At Completion Labor Units. No

PeriodAtCompletionMaterialCost

Period At Completion Material Cost. No

PeriodAtCompletionNonLaborCost

Period At Completion NonLabor Cost. No

PeriodAtCompletionNonLaborUnits

Period At Completion NonLabor Units. No

PeriodAtCompletionTotalCost

Period At Completion Total Cost. No

PeriodEarnedValueCost Period Earned Value Cost. No

PeriodEarnedValueLaborUnits

Period Earned Value Labor Units. No

PeriodEstimateAtCompletionCost

Period Estimate At Completion Cost. No

PeriodEstimateAtCompletionLaborUnits

Period Estimate At Completion Labor Units. No

PeriodPlannedValueCost Period Planned Value Cost. No

PeriodPlannedValueLaborUnits

Period Planned Value Labor Units. No


No

PlannedExpenseCost Planned Expense Cost. No

PlannedLaborCost Planned Labor Cost. No

PlannedLaborUnits Planned Labor Units. No

PlannedMaterialCost Planned Material Cost. No

PlannedNonlaborCost Planned Nonlabor Cost. No

PlannedNonlaborUnits Planned Nonlabor Units. No


PlannedValueCost Planned Value Cost. No

PlannedValueLaborUnits Planned Value Labor Units. No



RemainingExpenseCost Remaining Expense Cost. No


247


RemainingLaborCost Remaining Labor Cost. No

RemainingLaborUnits Remaining Labor Units. No

RemainingLateExpenseCost

Remaining Late Expense Cost. No

RemainingLateLaborCost

Remaining Late Labor Cost. No

RemainingLateLaborUnits

Remaining Late Labor Units. No

RemainingLateMaterialCost

Remaining Late Material Cost. No

RemainingLateNonlaborCost

Remaining Late Nonlabor Cost. No

RemainingLateNonlaborUnits

Remaining Late Nonlabor Units. No

RemainingLateTotalCost Remaining Late Total Cost. No

RemainingMaterialCost Remaining Material Cost. No

RemainingNonlaborCost Remaining Nonlabor Cost. No

RemainingNonlaborUnits Remaining Nonlabor Units. No

RemainingTotalCost Remaining Total Cost. No




249

Prime Business Objects List

The following Prime business objects are available in the Data Dictionary menu of the Gateway user interface. Select a specific business object to review a detailed list of fields supported for that business object.



ActivityRisk The activity risk object stores the relationship between a single Activity and a single Risk.

Calendar Calendars defined the available work hours in each calendar day, and includes global and resource types.

CBSSegment CBS Segment Fields

CBSTemplate CBS Template Fields

CBSTemplateCode CBS TemplateCode Fields

CostCategory CostCategory Fields

CostSheetWorkspaceTotalCostRow CostSheetWorkspaceTotalCostRow

CostSheetWorkspaceTotalItem CostSheetWorkspaceTotalItem

Currency Currencies are the monetary units used to store costs for all projects in the database.

EPS EPS

ExchangeRate ExchangeRate Fields

Holiday Calendar Holiday

HolidayGroup Calendar Holiday group

Location

The location is used to store address information including latitude and longitude. Locations can be assigned to resources, projects and/or activities.

Project

A project is a temporary endeavor undertaken to create a unique product, service, or result. Projects usually contain a work breakdown structure (WBS) and activities.


250


ProjectBudget ProjectBudget Fields

ProjectBudgetChange ProjectBudgetChange Fields

ProjectBudgetTransfer ProjectBudgetTransfer Fields


ProjectCodeType

Project code types provide a way of classifying project codes. Project codes are user-defined codes to classify and categorize projects across the enterprise.

Relationship




ResourceCode Resource codes are user-defined codes to classify and categorize resources across the enterprise.

ResourceCodeType

Resource code types provide a way of classifying Resource codes. Resource codes are user defined codes to classify and categorize resources across the enterprise

ResourceRate Resource rates provide a way of specifying multiple resource prices and maximum units per time values that vary over time.

ResourceRoleAssignment ResourceRoleAssignment Fields



251



RiskMatrix



RiskMatrixThreshold


RiskResponseAction





RiskThreshold




252


Role

Roles are project personnel job titles or skills, such as mechanical engineer, inspector, or carpenter. They represent a type of resource with a certain level of proficiency rather than a specific individual


UnitOfMeasure UnitOfMeasure Fields

WBS


WBSSpread Project phase/curve/spread data for the project cash flow.


253

In This Section

Activity ................................................................................................................... 254 ActivityRisk ............................................................................................................ 261 Calendar ............................................................................................................... 261 CBSSegment ........................................................................................................ 262 CBSTemplate ........................................................................................................ 262 CBSTemplateCode ............................................................................................... 263 CostCategory ........................................................................................................ 264 CostSheetWorkspaceTotalCostRow ...................................................................... 264 CostSheetWorkspaceTotalItem ............................................................................. 266 Currency ............................................................................................................... 267 EPS ....................................................................................................................... 268 ExchangeRate ....................................................................................................... 268 Holiday .................................................................................................................. 269 HolidayGroup ........................................................................................................ 269 Location ................................................................................................................ 270 Project ................................................................................................................... 270 ProjectBudget ........................................................................................................ 278 ProjectBudgetChange ........................................................................................... 279 ProjectBudgetTransfer........................................................................................... 280 ProjectCode .......................................................................................................... 281 ProjectCodeType ................................................................................................... 281 Relationship .......................................................................................................... 281 Resource ............................................................................................................... 282 ResourceAssignment ............................................................................................ 284 ResourceCode ...................................................................................................... 287 ResourceCodeType .............................................................................................. 288 ResourceRate ....................................................................................................... 288 ResourceRoleAssignment ..................................................................................... 288 Risk ....................................................................................................................... 289 RiskImpact ............................................................................................................ 290 RiskMatrix ............................................................................................................. 290 RiskMatrixScore .................................................................................................... 291 RiskMatrixThreshold .............................................................................................. 292 RiskResponseAction ............................................................................................. 293 RiskResponseActionImpact ................................................................................... 294 RiskResponsePlan ................................................................................................ 295 RiskThreshold ....................................................................................................... 296 RiskThresholdLevel ............................................................................................... 296 Role....................................................................................................................... 297 UDFType ............................................................................................................... 297 UnitOfMeasure ...................................................................................................... 298 WBS ...................................................................................................................... 298 WBSSpread .......................................................................................................... 299


254

Activity

Description: An activity is a unit of work performed during the course of a project.


ActivityPercentComplete

The percent of the activity that has been completed. The value is based on the formula for the selected Percent Complete Type. The Percent Complete Type can be Physical, Duration, or Units.

No

ActivityPriority Determines the priority of the activity when performing role leveling.

No

ActualDuration


Yes

ActualFinishDate The date when the activity was completed.

Yes

ActualLaborUnits The number of units expended for all labor resources assigned to the activity.

No

ActualNonLaborUnits The number of nonlabor units that have been expended on the activity.

No

ActualStartDate The date work on the activity began. No

ActualThisPeriodLaborCost ActualThisPeriodLaborCost No

AtCompletionBudgetLaborUnits

AtCompletionBudgetLaborUnits Yes


Yes

AtCompletionLaborUnits

The sum of the actual plus remaining units for all nonlabor resources assigned to the activity. It is the same as the planned nonlabor units if the activity is not started, and the actual nonlabor units once the activity is completed.

No

CalendarCode The unique code of the calendar. Yes


255


CalendarObjectId The calendar assigned to the activity. No

CompletedWeight CompletedWeight Yes

CostVarianceLaborUnits CostVarianceLaborUnits Yes

DistributionShape DistributionShape of the activity. No

DrivingPath

The sequence of project activities from start to finish where the Total Duration is no longer than any other path.

Yes

DurationPercentComplete

The duration percent complete for the activity. Calculated as Planned Duration minus Remaining Duration divided by Planned Duration multiplied by 100.

No

DurationPercentOfPlanned

The actual duration percent of planned duration for the activity. Calculated as Actual Duration divided by BL Duration multiplied by 100.

Yes

DurationType

Determines how remaining duration, units, and units/time are calculated when you update an activity that has resources assigned. The valid values are Fixed Units/time, Fixed Units, Fixed Duration & Units, and Fixed Duration & Units/Time.

No

EarlyFinishDate

The earliest possible date the activity can finish. This date is calculated based on network logic, schedule constraints, and resource availability.

No

EarlyStartDate

The earliest possible date the remaining work for the activity can begin. This date is calculated based on network logic, schedule constraints, and resource availability.

No

ExistenceProbability

Signifies the probability that a particular activity occurs (exists) in a given project. For example, an activity that may or may not have to be done depending on circumstances.

No


256

ExpectedFinishDate The expected finish date of the activity in the project baseline.

No

FinishDate The current finish date of the activity. Yes

FreeFloat The amount of time the activity can be delayed before delaying the start date of any successor activity.

Yes

Id The unique identifier of the activity. Yes

IsCritical

Designates an activity as critical. An activity is defined as critical based upon the project settings configured for the project.

Yes


No

LaborUnitsCompletePercent

The percent complete of units for all labor resources for the activity. Calculated as Actual Labor Units divided by At Completion Labor Units multiplied by 100.

Yes

LateFinishDate

The latest possible date the activity can finish without delaying the project finish date. This date is calculated based on activity relationships, schedule constraints, and resource availability.

No

LateStartDate

The latest possible date the remaining work for the activity can begin without delaying the project finish date. This date is calculated based on activity relationships, schedule constraints, and resource availability.

No

LocationObjectId The physical location associated with the activity.

No

MaterialCostPercentComplete

MaterialCostPercentComplete No

MaximumDuration The maximum duration of the activity No

MinimumDuration The minimum duration of the activity No

MonteCarloScenario The Risk Analysis scenario Yes

MostLikelyDuration The most likely duration of the activity

No


257

Name The name of the activity. No

NonLaborUnitsCompletePercent

The percent complete of units for all nonlabor resources for the activity. Calculated as Actual Nonlabor Units divided by At Completion Nonlabor Units multiplied by 100.

Yes


Yes

OwnerId The user responsible for the activity. No

ParentActivity The ID of the summary activity to which the activity belongs, if summary activities are used.

No

PercentCompleteType PercentCompleteType of the activity No

PercentCompleteWeightedBy

PercentCompleteWeightedBy of the activity

No

PhysicalPercentComplete The activity percent complete, manually entered by the user.

Yes

PlannedDuration

The expected amount of time required to complete an activity. The planned working time is calculated using the activity's calendar. The duration is measured from the activity's planned start date to its planned finish date.

No

PlannedFinishDate


Yes

PlannedLaborUnits The planned number of units for all labor resources assigned to the activity.

Yes

PlannedNonLaborCost PlannedNonLaborCost No

PlannedNonLaborUnits The planned units for all non labor resources assigned to the activities in the project.

Yes

PlannedStartDate

The date the activity is scheduled to begin. This date is computed by the project scheduler but can be updated manually by the project manager.

Yes


258

This date is not changed by the project scheduler after the activity has been started.

PlannedValueCost PlannedValueCost No

PostResponsePessimisticFinish

The post-response pessimistic finish date for the activity.

Yes

PostResponsePessimisticStart

The post-response pessimistic start date for the activity.

Yes

PreResponsePessimisticFinish

The pre-response pessimistic finish date for the activity.

Yes

PreResponsePessimisticStart

The pre-response pessimistic start date for the activity.

Yes

PrimaryConstraintDate The constraint date for the activity, if the activity has a constraint.

No

PrimaryConstraintType The main restriction impacting the activity start or finish date

No

PrimaryResource The user designated as the primary resource for the activity.

No

ProjectId The unique identifier of the project to which the activity was added.

Yes

ProjectObjectId The unique identifier of the project to which the activity was added.

Yes

RecordCount The number of activities added to the project.

Yes

RemainingDuration The total working time from the activity remaining start date to the remaining finish date.

Yes

RemainingFinish

The date the remaining work for the activity is scheduled to finish. If this activity is not started, this date is the planned finish. This date can be updated manually by the user, but it is overwritten when you schedule the project.

Yes

RemainingFloat

The amount of time remaining in which the activity can be delayed before delaying the project finish date. Calculated as Late Finish minus Remaining Finish.

Yes

RemainingLaborUnits The remaining units for all labor resources assigned to the activity.

No


259

The Remaining Labor Units reflect the work remaining to be done for the activity. Before the activity is started, the remaining units are the same as the planned units.

RemainingLateFinish The remaining late finish date of the project.

Yes

RemainingLateStart The remaining late start date of the project.

Yes

RemainingNonLaborCost RemainingNonLaborCost No

RemainingNonLaborUnits

The remaining units for all nonlabor resources assigned to the activity. The remaining units reflect the work remaining to be done for the activity. Before the activity is started, the remaining units are the same as the planned units

No

RemainingStart

The date the remaining work for the activity is scheduled to begin. This date can be updated manually by the user. Before the activity is started, this date is the same as the planned start.

No

ResumeDate The date when a suspended task or activity is resumed.

No

RolledupWBSObjectId Rolled up WBS Object Ids after filtering either by levels or tagging

Yes

SchedulePercentComplete

The activity schedule percent complete, which specifies how much of the activity's project baseline duration is complete so far. Calculated based on where the current data date falls relative to the activity's project baseline start and finish dates.

Yes

SchedulePerfIndexLaborUnits

The ratio of the earned value of labor units to the planned value of labor units. Calculated as Earned Value Labor Units divided by Planned Value Labor Units.

Yes

ScheduleVarIndexLaborUnits

The ratio of schedule variance labor units and the planned value labor units. Calculated as Schedule

Yes


260

Variance Labor Units divided by Planned Value Labor Units.

ScopePercentComplete

The percentage completion of the scope items linked to the activity. It is calculated as the sum of the Quantity Completed Weight for the scope items assigned to the activity divided by the total Revised Quantity for the scope items.

Yes

SecondaryConstraintDate The date for the activity's secondary constraint, if the activity has a secondary constraint.

No

SecondaryConstraintType The secondary restriction impacting the activity start or finish date.

No

SequenceNumber The number that specifies the position of the activity relative to others within the view.

No

StartDate The early start date of the activity. No

Status The current status of the activity, either "Not started", "In Progress", or "Completed".

No

SuspendDate The date work was temporarily stopped on a given activity.

No

TotalFloat

The amount of time the activity can be delayed before delaying the project finish date. Calculated as Late Start minus Early Start or as Late Finish minus Early Finish.

Yes

Type


No


The percent complete of units for all labor and nonlabor resources assigned to the activity.Calculated as Actual Units divided by At Completion Units multiplied by 100.

Yes

VarCost VarCost Yes

WBSCode The short code assigned to each WBS element for identification. Each WBS element is uniquely identified

Yes


261

by concatenating its own code together with its parents' codes.

WBSObjectId The unique ID of the WBS for the activity.

No

Weight The importance of the activity in relation to other activities.

No

WorkPackageId The unique identifier for the work package that the activity is associated with.

No

ActivityRisk

Description: The activity risk object stores the relationship between a single Activity and a single Risk.





ObjectId The unique ID generated by the system. Yes






Calendar

Description: Calendars defined the available work hours in each calendar day, and includes global and resource types.


Code The unique code for the calendar. No

HolidayOrExceptions All dates with holidays or exceptions in this calendar.

No

IsPersonal The flag indicating if this calendar is a No


262


personal calendar (applies to resource calendars only).



StandardWorkWeek Standard detailed work hours for each day of week

No

Type The calendar type - either 'Global' or 'Resource'.

No

CBSSegment

Description: CBS Segment Fields


CopiedFrom CopiedFrom No

Extensible Extensible No

ObjectId The unique ID generated by the system Yes

SegmentDefaultValue A value that is added to the concatenated code by default. This is not a required field.

No

SegmentDefinitionName

The name of the CBS segment. No

SegmentId The unique identifier of the segmentId. No

SegmentSeparator

The separator determines how the concatenated code is separated. The separator can be a period, space, or hyphen.

No

CBSTemplate

Description: CBS Template Fields


CBSTemplateId The unique identifier of the CBSTemplateId. No

Description The description of the CBS template. No


263


Name The name of the CBS template. No

ObjectId The unique identifier of the segmentId. Yes

WorkspaceId The unique identifier of the segmentId. No

CBSTemplateCode

Description: CBS TemplateCode Fields


CBSItemId The unique identifier of the CBSTemplateCodeId.

No

CBSTemplateObjectId The unique identifier of the CBS template. No

Code

The cost breakdown structure code is a code that is concatenated with its parent and child according to the segment definition.

No

CopiedFromItem The unique identifier of the CBSTemplateCode.

No

CostType

The category of the cost breakdown structure code. Expense: Represents an expense. Capital: Represents capital. None: Type is not divided into expense or capital. None is selected by default if no other choice is made.

No

IsCodeCopied The flag represents is templateCode copied or not

No

Name The name of the CBS template. No


ParentObjectId The unique ID of the parent of CBS templateCode.

No

PushDownStatus The active field indicates the CBS code is active for use.

No

SequenceNumber CBS template item sequence Nmber. No


264

CostCategory

Description: CostCategory Fields


Abbreviation The abbreviation for the cost category name.

No

CostCategoryName The name of the cost category. No

CostcategoryType The classification of the cost category. Valid values are 'Labor', 'Equipment', 'Materials, and 'Other'.

No

CostCategoryId The unique identifier of the CostCategory. No


WorkspaceId The unique identifier of the workspace. No

CostSheetWorkspaceTotalCostRow

Description: CostSheetWorkspaceTotalCostRow


ActualCostToDate actualCostToDate No

ActualHoursToDate actualHoursToDate No

AdjustedCost adjustedCost No

ApprovedChangedCost approvedChangedCost No

ApprovedChangedHours approvedChangedHours No

ApprovedManualBudget approvedManualBudget No

ApprovedManualBudgetChanges

approvedManualBudgetChanges No

ApprovedManualBudgetTransfers

approvedManualBudgetTransfers No

ApprovedManualCurrentBudget

approvedManualCurrentBudget No

AtCompletionCost atCompletionCost No

AtCompletionHours atCompletionHours No

BacCost bacCost No

BacHours bacHours No


265


BaselineCost baselineCost No

CostSheetWorksspaceTotalCostRowId

The unique identifier for the CostSheetWorksspaceTotalCostRowId.

No

CostSheetWorksspaceTotalItemObjectId

The unique identifier for the CostSheetWorksspaceTotalItemObjectId

Yes

EacCost eacCost No

EacHours eacHours No

EarnedCost earnedCost No

EarnedHours earnedHours No

EtcAdjustedHours etcAdjustedHours No

EtcCost etcCost No

EtcHours etcHours No

InstalledCost installedCost No

InstalledHours installedHours No


Yes

PendingChangedCost pendingChangedCost No

PendingChangedHours pendingChangedHours No

PendingManualBudget pendingManualBudget No

PendingManualBudgetChanges

pendingManualBudgetChanges No

PendingManualBudgetTransfers

pendingManualBudgetTransfers No

PlannedCost plannedCost No

PlannedHours plannedHours No

RemainingCost remainingCost No

RemainingHours remainingHours No

RevisedCost revisedCost No

RevisedHours revisedHours No


266

CostSheetWorkspaceTotalItem

Description: CostSheetWorkspaceTotalItem


ActualCostToDate actualCostToDate

ActualHoursToDate actualHoursToDate

AdjustedCost adjustedCost

ApprovedChangedCost approvedChangedCost

ApprovedChangedHours

approvedChangedHours

ApprovedManualBudget approvedManualBudget

ApprovedManualBudgetChanges

approvedManualBudgetChanges

ApprovedManualBudgetTransfers

approvedManualBudgetTransfers

ApprovedManualCurrentBudget

approvedManualCurrentBudget

AtCompletionCost atCompletionCost

AtCompletionHours atCompletionHours

BacCost bacCost

BacHours bacHours

BaselineCost baselineCost

CostSheetWorkspaceTotalItemId

The unique identifier for the CostSheetWorkspaceTotalItem.

No

CostSheetWorkspaceTotalItemObjectId

The unique identifier for the CostSheetWorkspaceTotalItemId.

EacCost eacCost

EacHours eacHours

EtcAdjustedHours etcAdjustedHours

EtcCost etcCost

EtcHours etcHours

EarnedCost earnedCost

EarnedHours earnedHours

InstalledCost installedCost


267


InstalledHours installedHours


ParentWorkspaceId The unique identifier of the parent workspace.

No

PlannedCost plannedCost

PlannedHours plannedHours

PendingChangedCost pendingChangedCost

PendingChangedHours pendingChangedHours

PendingManualBudget pendingManualBudget

PendingManualBudgetChanges

pendingManualBudgetChanges

PendingManualBudgetTransfers

pendingManualBudgetTransfers

ReferenceObjectId ReferenceObjectId No

ReferenceTemplateType

ReferenceTemplateType No

RemainingCost remainingCost

RemainingHours remainingHours

RevisedCost revisedCost

RevisedHours revisedHours

Currency

Description: Currencies are the monetary units used to store costs for all projects in the database.


ConfiguredByUser The currency can be configured by the user. Yes

CurrencyCode The unique identifier for the currency. The currency code is 3 characters.

No

CurrencyId The ID for currency. No

CurrencyName The Name of currency. No

CurrencySymbol The symbol for the currency. No


268


DecimalsToDisplay The number of decimals to display. No


SystemCurrencyFlag The default currency. Any currency conversions will be measured against this form of currency.

No

WorkspaceId The ID for Workspace. No

EPS

Description: EPS




ObjectId The unique ID that uniquely identifies this EPS.

Yes

SequenceNumber Sequence Number. No

ExchangeRate

Description: ExchangeRate Fields.


BaseExchangeRate The exchange rate for a currency. No

CurrencyObjectId The unique ID of the currency. No

EffectiveEndDate The date the exchange rate ends effect.

No

EffectiveStartDate The date the exchange rate goes into effect.

No

ExchangeRateId The unique identifier of the ExchangeRate.

No


Yes


269

Holiday

Description: Calendar Holiday.


DayOfMonth The day of the month the holiday is in.

No

DayOfWeek The day of the week the holiday is in.

No

HolidayDate The date of the holiday. No

HolidayGroupObjectId The unique identifier for the holiday list.

No

HolidayId The unique identifier for the holiday.

Yes

HolidayName The name of the holiday. No

Month The month the holiday is in. No


Yes

Week The week of the month the holiday is in.

No

WorkTime This fields is always NULL. No

HolidayGroup

Description: Calendar Holiday group.


HolidayGroupid The unique identifier for the holiday list.

No

HolidayGroupName The name of the holiday list. No


Yes

WorkspaceId The unique identifier of the workspace.

No


270

Location




No


No

CityName The city name of the address. No



LocationCode LocationCode No

LocationName The name of the location. No


MunicipalityName

The municipality name of the address. No




StateName The state name of the address. No

Project



ActivityDefaultCalendarCode The default activity calendar object ID.

No

ActivityDefaultCalendarName The name of the Activity Default No


271


Calendar of this project.

ActivityDefaultCalendarObjectId

The unique ID of the Activity Default Calendar of this project.

No

ActualCost The actual cost of the project. No

ActualDuration The actual duration of the project. Yes

ActualFinishDate The date on which the project is actually finished.

No

ActualStartDate The date on which the project is actually started.

No

AddressLine1 The first line of the address of a location. This might be the building number and the street address.

No

AddressLine2 The second line of the address of a location. This might be a neighborhood or town.

No


No

AtCompletionCost The at completion cost of the project.

No

BusinessSegment A Project Code field to define the Business Segment of the Project.

No

CalculateFloatBasedOnFinishDate

The flag that indicates how each activity's float will be calculated with respect to other projects in the scheduling batch. This setting only has an effect when scheduling multiple projects at the same time

No

CalendarId The calendar associated with the project.

Yes

CalendarObjectId The unique identifier of the calendar associated with the project.

No

CityName The city name for a location. No


No

CostPerformanceIndex The cost performance index of the project.

No

CostVariance The cost variance of the project. No


272


CountryCode The Country for a location. No

CriticalActivityFloatThresholdThe maximum float time for activities before they are marked critical.

No

CriticalActivityPathType Indicates Activity critical path type. No

CurrencyId The currency used by the project. The project currency can differ from the base currency.

Yes

CurrencyObjectId The unique identifier of the currency used by the project.

No

CurrentApprovedBudget The current approved budget of the project.

Yes

CurrentApprovedBudgetBaseDistributed

The amount of approved budget currently allocated across the project timescale.

Yes

CurrentApprovedBudgetBaseUndistributed

The amount of approved budget unallocated across the project timescale.

Yes

CurrentApprovedFinishDate The finish date for the Current Approved Budget set by the capital planner.

Yes

CurrentApprovedSpendVariance

The total and time phased variance between the project's Current Approved Budget and Spends.

Yes

CurrentApprovedStartDate The start date for the Current Approved Budget set by the capital planner.

Yes

DataDate The data date of the project. No

Description Description of the project No

EarnedValueCost The earned value cost of the project. No

EstimateAtCompletionCost The estimate at completion cost of the project.

No

EstimateToCompletionCost The estimate to completion cost of the project.

No

ExchangeRateType

The type of exchange rate. Floating: A fixed, user-defined exchange rate. Pegged: Follows the exchange rates defined at the workspace.

No


273


ExchangeRate The custom exchange rate for a pegged exchange rate.

No

FinishDate Project finish date No

ForecastCost

The total estimation of a project's remaining costs. Once projects have begun, project managers update the project forecast to represent remaining cost estimates for the duration of the project's life cycle.

No

ForecastCostDistributed The amount of forecast cost currently allocated across the project timescale.

Yes

ForecastCostUnDistributed The amount of forecast cost unallocated across the project timescale.

Yes

ForecastCurrApprVar The total and time phased variance between the project's Forecast and Current Approved Budget.

Yes

ForecastFinishDate The planned finish date of a project's remaining Forecast cost.

No

ForecastStartDate The planned start date of a project's remaining Forecast cost.

No



No

IntegratedType


Yes

IntRateReturn

The quantitative measurement used to compare the profitability of project investments. The rate at which investors will receive returns on their investments in a project.

No

Latitude The geographical coordinate for the latitude of the location. The default format for latitude is decimal

No


274


degrees format, but the format you need to use will depend on your geolocation service.

LinkForecastToSpend

Enables you to link Forecast data to project Spends data. When linked any updates to the project's Spends values will automatically be applied to the project's Forecast values.

No

LocationCode The code of the location assigned to the project.

Yes

LocationId Location Id Yes

LocationName A name for the location that your users will understand and recognize.

No


No

Longitude

The geographical coordinate for the longitude of the location. The default format for longitude is decimal degrees format, but the format you need to use will depend on your geolocation service.

No



No

MaximumMultipleFloatPaths The number of critical float paths to calculate

No



No



No

MultipleFloatPathsUseTotalFloat

The Boolean value that decides whether or not to use total float in multiple float path calculations.

No

MustFinishByDate The planned finish date of the project.

No

NetPresentValue The net present value of the project. No


275



The type of logic used to schedule the progressed activities: 'Retained Logic', 'Progress Override', or 'Actual Dates'.

No

Owner Owner of the project No

ParentEPSId The parent eps ID of the project. No

PaybackPeriod The pay back period of the project. No

PercentComplete Percent complete of the project. No

PercentCompleteWeightedBy

The weight for scope items is calculated using quantity.

No

PlannedBudget The planned budget of the project. No

PlannedBudgetDistributed The amount of planned budget allocated across the project timescale.

Yes

PlannedBudgetUnDistributedThe amount of planned budget unallocated across the project timescale.

No

PlannedDuration The planned duration of the project. Yes

PlannedFinishDate The planned finish date of the project.

No

PlannedStartDate The planned start date of the project. No

PlannedValueCost The planned value cost of the project.

No

PostalCode The postal code, post code, or zip code of a location.

No

PrimeWorkspace A Project Code field to define the Prime Workspace of the Project.

No

ProjectCode Project short name. No

ProjectId The unique ID generated by the system.

No

ProjectName The name of the project. No

ProposedBudget The proposed budget of the project. No

ProposedBudgetBaseDistributed

The amount of proposed budget unallocated across the project timescale.

Yes

ProposedBudgetBaseUnDistr The amount of proposed budget Yes


276


ibuted unallocated across the project timescale.

ProposedFinishDate The finish date for the Proposed Budget of the project.

Yes

ProposedForecastVariance The total and time phased variance between the project's Proposed Budget and Forecast.

Yes

ProposedPlannedVar The total and time phased variance between the project's Proposed Budget and Planned Budget.

Yes

ProposedStartDate The start date for the Proposed Budget of the project.

Yes


No

RemainingCost

The remaining total cost for the project, including labor resources, nonlabor resources, and project expenses.

No

RemainingDuration The duration between the Project Start and Project Finish.

No

ReportCycleId ReportCycle of the project. No

ReportCycleNamingBoundary

Determines when period names will be reset. The options available are based on the selection for Reporting Cycle. The standard calendar start and end dates are used as boundaries for resetting periods.

No

ReturnInvestment The return on investment of the project.

No

RiskLevel

The risk level assigned to the project. You can use risk level to determine what projects should be included in your plans as well as which projects should be of priority.

No

RiskMatrixCode The code of the risk matrix. Yes

RiskMatrixId The risk matrix assigned to the project for calculating project risk scores.

Yes


277



Yes

RiskMatrixObjectId The unique identifier of the risk matrix assigned to the project for calculating project risk scores.

No

RiskScore

The risk score is based on the probability and impacts of a risk. It is derived from the probability impact matrix and any associated rules.

Yes

ScheduledFinishDate

The calculated latest early finish date, which is based on the schedule most recently generated for the project.

Yes

SchedulePerformanceIndex The schedule performance index of the project.

No

ScheduleVariance The schedule variance of the project.

No

SecurityGrid SecurityGrid of the project. Yes

SequenceNumber SequenceNumber of the project. No

SpendCost

Linking Spends and Forecast enables you to combine costs already incurred on a project with the project's predicted future costs effectively creating an at completion curve. Spends cannot be edited if a project has a status of Proposal.

No

SpendEffectiveDate The month in which a spend value was last added to the project.

Yes

SpendFinishDate The finish date for the project spends.

No

SpendForecastVar The total and time phased variance between the project's Spends and Forecast.

Yes

SpendPlannedVariance The total and time phased variance between the project's Spends and Planned Budget.

Yes

SpendStartDate The start date for the project spends. No

StartDate The date on which work on the project starts.

No


278




No

StateCode A unique identifier for the state or province.

No

StateName The state, region, or province of a location.

No

Status The status of the project. No

StrategicPriority The strategic priority of the project. No

SummaryRemainingTotalCost

The summary remaining total cost of the project.

No

URL The string web site URL of the project.

No

UseExpectedFinishDates The option used for setting activity finish dates as the expected finish dates when scheduling projects.

No

VarianceFinishDate The variance finish date of the project.

Yes

VarianceStartDate The variance start date of the project.

Yes

WorkspaceId The unique identifier of the Workspace.

No

YearEndForecastCost Total forecast at the end of year actuals till date, with respect to the current year.

No

YtdSpendCost

A measurement of capital spent on a project starting from the beginning of the year up to the present date. YTD Spends provide an overview of the total amount of spends accrued on a project over the current Period Year.

No

ProjectBudget

Description: ProjectBudget Fields.


279


ApprovedDate The date the project budget was approved.

No

BudgetSource BudgetSource of the projectBudget.

No

BudgetStatus

The state of the project budget change request. The change request is awaiting a decision. Approved: The change request was approved. Rejected: The change request was not approved.

No

ManualBudgetEnabled ManualBudgetEnabled flag. No


Yes

ProjectBudgetPegRate ProjectBudgetPegRate No

ProjectObjectId The unique identifier of the project. No

WithDrawDate The date the approval of the budget is withdrawn.

No

ProjectBudgetChange

Description: ProjectBudgetChange Fields.


BudgetStatus

The state of the project budget change request. Pending: the change request is awaiting a decision. Approved: The change request was approved. Rejected: The change request was not approved.

No

ChangeCode The unique identifier of the project budget change request.

No

Description Details supporting the change request. No

FinalizedBy The username of the user who accepted or rejected the transfer request.

No

LastModifiedBy The user name of the user who last made changes to the item.

Yes



280


ProjectBudgetChangeIdThe unique identifier of the ProjectBudgetChangeId.

No


SubmittedBy The username of the user that submitted the item.

Yes

TotalCost The cost to be added or subtracted from the project budget.

No

TotalCostProject TotalCostProject No

ProjectBudgetTransfer

Description: ProjectBudgetTransfer Fields.


Description Details supporting the change request. No

FinalizedBy The username of the user who accepted or rejected the transfer request.

No

LastModifiedBy The username of the user who last made changes to the item.

Yes


ProjectBudgetTransferIdThe unique identifier of the ProjectBudgetTransferId.

No


Status

The state of the project budget transfer request. Pending: The change request is awaiting a decision. Approved: The change request was approved. Rejected: The change request was not approved.

No

SubmittedBy The username of the user that submitted the item.

Yes

TransferCode The unique identifier of the project budget transfer budget.

No


281

ProjectCode



CodeTypeName The name of the project code type. No

CodeTypeObjectId The unique ID of the project code type. No




ParentId The short code that uniquely identifies the parent Project code.

Yes




ProjectCodeType




No



Relationship



Lag The time lag of the relationship. This is the time lag between the predecessor

No


282


activity's start or finish date and the successor activity's start or finish date, depending on the relationship type.


PredecessorActivityId The unique ID of the predecessor activity.

Yes

PredecessorActivityObjectId The unique ID of the predecessor activity.

No

PredecessorActivityType

The type of the predecessor activity, either 'Task Dependent', 'Resource Dependent', 'Level of Effort', or 'Milestone'.

No


No

SuccessorActivityId The unique ID of the successor activity. Yes



The type of the successor activity, either 'Task Dependent', 'Resource Dependent', 'Level of Effort', or 'Milestone'.

No


Yes


No

Resource



AddressLine1 The first line of the address of a location. This might be the building number and street address.

No

AddressLine2 The second line of the address of a location. This might be a neighborhood or town.

No


283




No



No

CalendarObjectId The unique ID of the calendar that is assigned to the resource.

No

CityName The city name for a location. No

CountryCode The Country for a location. No

DefaultUnitsPerTime The Default units/time setting for resource.

No

DepartmentId A Resource UDF to define the Department Id of the Resource.

No

EmailAddress The resource's email address. No


No

Id The unique identifier of the Resource. No

IsActive The option that determines whether the resource is active. A value of true indicates the resource is active.

No

Latitude

The geographical coordinate for the latitude of the location. The default format for longitude is decimal degrees format, but the format you need to use will depend on your geolocation service.

No

LocationCode The code of the location assigned to the resource.

No


No


No

Longitude

The geographical coordinate for the longitude of the location. The default format for longitude is decimal degrees format, but the format you need to use

No


284


will depend on your geolocation service.


ObjectId The unique Id for the Resource which is generated by the Primavera Data Integration application.

Yes

OfficePhone The resource's work phone number. No

OtherPhone Other phone for the resource. No


No

PostalCode The postal code, post code, or zip code of a location.

No


No

ResourceType The indicator that determines the resource type. Valid values are LABOR, NON_LABOR, MATERIAL.

No

StateCode A unique identifier for the state or province.

No

StateName The state, region, or province of a location.

No

Title The title of the resource. No

ResourceAssignment

Description: resources or roles that are performing various activities.



Yes


No

ActivityType The type of the activity, either 'Task Dependent', 'Resource Dependent', 'Level of Effort', or 'Milestone'.

No

ActualDuration the total working time from the assignment actual start date to the actual finish date for

Yes


285


completed assignments, or the total working time from the actual start date to the data date for in-progress assignments.

ActualFinish The date on which the assignment was completed.

No

ActualRegularUnits


No

ActualStart If the activity has started, the date work began on the activity.

No

ActualUnits The actual non-overtime plus overtime units worked by the resource on this activity.

No

AssignmentCode A unique identifier for the assignment. No

AtCompletionDuration The total working time from the assignment's current start date to the current finish date.

No


No

DriveActivityDates Determines whether new resource or role assignments determine activity dates.

No

EstimateToCompletionUnits

The estimated quantity to complete the assignment.

Yes

FinishDate The finish date for the assignment. No

IsActivityFlagged

The flag that indicates whether the resource who is assigned to the activity assignment has flagged the activity as important to the resource.

No


No


PlannedDuration


No

PlannedFinish The date the assignment is scheduled to be finished.

No


286


PlannedLag The planned time lag between the activity's planned start date and the resource's planned start date on the activity.

No

PlannedStart The planned start date for the assignment on the activity.

No

PlannedUnits The planned units of work for the resource assignment on the activity.

No


No

PlannedValueUnits PlannedValueUnits No

Proficiency

The skill level of the resource an activity is assigned to. The value values are Master, Expert, Skilled, Proficient, and Inexperienced.

No


Yes

RemainingDuration

The remaining working time for the resource assignment on the activity, from the resource's remaining start date to the remaining finish date.

No

RemainingFinish The date the assignment is scheduled to finish.

No

RemainingLag The time lag between the activity's remaining start date and the resource's remaining start date on the activity.

No

RemainingLateFinish The latest possible date the assignment must be finished to not delay the project finish date.

Yes

RemainingLateStart The latest possible date the assignment must begin to not delay the project finish date.

Yes

RemainingStart The date the assignment is scheduled to begin.

No

RemainingUnits The remaining units of work to be performed by this resource on this activity.

No

RemainingUnitsPerHourThe units per time required for the resource assignment to complete the activity.

No

ResourceId The name that uniquely identifies the Yes


287


resource.



No


Yes


RolledupWBSObjectId Rolled up WBS key after filtering either by levels or tagging

Yes

StaffedRemainingUnits StaffedRemainingUnits No

StartDate The start date for the activity assignment. No

SyncUnitsFrontCost Determines whether to recalculate actual or actual this period units and costs when one of these values is updated.

No

TotalRemainingLag TotalRemainingLag No

UnitsPercentComplete The percent complete of units for the resource assignment on the activity.

No

UnstaffedRemainingUnits

UnstaffedRemainingUnits No

WBSObjectId WBS key Yes

ResourceCode

Description: Resource codes are user-defined codes to classify and categorize resources across the enterprise.


CodeTypeName The name of the resource code type. No

CostTypeObjectId The unique ID of the resource code type Yes


Description The description of the resource code No


ParentId The short code that uniquely identifies the parent resource code.

No


288


ParentObjectId The unique ID of the parent resource code No


ResourceCodeType

Description: Resource code types provide a way of classifying resource codes. Resource codes are user-defined codes to classify and categorize resources across the enterprise.



No



ResourceRate

Description: resources or roles that are performing various activities.


EffectiveDate The effective time period of Resource Rate. No

MaxUnitsPerTime The maximum work unites per time this resource can perform all their assigned activities.

No



ResourceRoleAssignment

Description: Resource Role assignment fields




289


PrimaryFlag

Determines whether this is the resource's main role. You can only assign one primary role per resource. A resource is not required to have a primary role.

No

Proficiency The skill level of the resource. Skill levels are Master, Expert, Skilled, Proficient, and Inexperienced.

No

ResourceObjectId The identifier for the resource assigned to the role.

No

ResourceRoleAssignmentId

The unique identifier of the ResourceRoleAssignment.

No

RoleObjectId The identifier for the role assigned to the resource.

No

Risk



Cause The description of the cause of the Risk. No

Description The description of the Risk. No

Effect The description of the risks effect on the project.

No

Id The ID of the Risk. Must be unique within a project.

No


Name The name of the Risk. Does not need to be unique.

No




ResponseTotalCost The total estimated cost for the risk. No

Status The current status of the Risk. Valid values are 'Proposed', 'Open', 'Active', 'Rejected', 'Managed', and 'Impacted'.

No


290



No

RiskImpact










RiskThresholdLevelCodeThe short name of the associated risk threshold level.

No


The name of the associated risk threshold level.

Yes



No


RiskThresholdObjectId The unique ID of the associated risk threshold. No

RiskMatrix






291




No

IsActive


No





No

RiskScoringMethod

The calculation method used to determine the risk score. Valid values are 'Highest', 'Average of Impacts', 'Average of Individual Scores'.

No

RiskMatrixScore






No




Severity1 The first severity level of the Risk Matrix Score. No


Severity2 The second severity level of the Risk Matrix Score. No



292


Severity3 The third severity level of the Risk Matrix Score. No


Severity4 The fourth severity level of the Risk Matrix Score. No


Severity5 The fifth severity level of the Risk Matrix Score. No


Severity6 The sixth severity level of the Risk Matrix Score. No


Severity7 The seventh severity level of the Risk Matrix Score. No


Severity8 The eighth severity level of the Risk Matrix Score. No


Severity9 The ninth severity level of the Risk Matrix Score. No


RiskMatrixThreshold









RiskThresholdObjectIdThe unique ID of the associated risk threshold.

No


293

RiskResponseAction



ActivityId The short name of the associated activity.

Yes


ActivityObjectId The unique ID of the associated activity.

No


FinishDate

The finish date of the risk response action. If an activity is assigned, the risk response action uses the activity finish date.

No

Id The short name of the risk response plan.

No



Yes





Yes


No


No

ResourceId The short name of the associated resource.

Yes



No

RiskId The short name of the associated risk.

Yes


294


RiskResponsePlanId The short name of the associated risk response plan.

Yes

RiskResponsePlanName The name of the associated risk response plan.

Yes

RiskResponsePlanObjectId The unique ID of the associated risk response plan.

No

Score The risk score from the numeric PID after the response action has been completed.

StartDate

The start date of the risk response action. If an activity is assigned, the risk response action uses the activity start date.

No

Status

The status of the risk response action. Valid values are 'Proposed', 'Sanctioned', 'Rejected', 'In Progress', and 'Complete'.

No








RiskResponseActionId The short name of the associated risk response action.

Yes

RiskResponseActionName The name of the associated risk response action.

No

RiskResponseActionObjectId

The unique ID of the associated risk response action.

No

RiskThresholdCode The code of the risk threshold. Yes

RiskThresholdLevelCode The short name of the associated risk Yes


295


threshold level.


Yes



No


Yes


No

RiskResponsePlan




IsActive


No





ResponseType


No





296

RiskThreshold



Code The code of the risk threshold. No



ThresholdType


No

RiskThresholdLevel



Code The 10 character code for the threshold level.

No


No



No

Name The 40 character name for the threshold level.

No


ProbabilityRange The probability range of the threshold level.

No




No



297



ThresholdType


No


Role





No

Description Additional information for the role. No

Id The unique identifier of the Role No

Name The name of the role. No


Yes

ParentObjectId The unique ID of the parent role of this role in the hierarchy.

No

UDFType



DataType The data type of the user-defined field: "Text", "Start Date", "Finish Date", "Cost", "Double", "Integer", "Indicator", or "Code".

No



298


SubjectArea The subject area of the user-defined field: "Project", "Activity", "WBS", "Resource Assignment", "Activity Expense".

No

Title The name/title of the user-defined field. No

UnitOfMeasure

Description: Unit of Measure fields.


DisplayValue The name of the unit of measure No

Key The abbreviation for the unit of measure name. No


UnitOfMeasureId The unique identifier of the unit of measure No

WorkspaceId The unique ID of the workspace. No

WBS



Code The short name of the WBS. No


No



Yes


No

ProjectId The project Id of the WBS. Yes

ProjectObjectId The unique ID of the No


299


associated project.

SequenceNumber The sequence number of the WBS.

No

WBSSpread

Description: Project phase / curve / spread data for the project cash flow.


ActualTotalCost Actual Total Cost. No

AtCompletionTotalCost At Completion Total Cost. No




No


ProjectId Project short name. Yes



301

Unifier Business Objects

The following Unifier business objects are available in the Data Dictionary menu of the Gateway user interface. Select a specific business object to review a detailed list of fields supported for that business object.


CBS CBS business object

CBSDurationSummary

Create/Update Duration Based Summary Sheet in Unifier.



CompanyCosts Company Costs Business Processes

CompanyCostsDetail Company Costs Detail Business Processes

CompanyLineItem Company LineItem Business Processes

CompanyLineItemDetail

Company LineItem Detail Business Processes

CompanySimple Company Simple Business Processes

OtherProjectCosts Other Project Costs Business Processes

OtherProjectsDetail Other Project Detail Business Processes

P6ActivitySheet P6 Activity Sheet business object.

Project Unifier Project Header

ProjectCommits Project Commits Business Processes

ProjectCommitsDetail Project Commits Detail Business Processes

ProjectDocument Project Document Business Processes

ProjectDocumentDetail

Project Document Detail Business Processes

ProjectInvoices Project Invoices Business Processes

ProjectInvoicesDetail Project Invoices Detail Business Processes

ProjectSimple Project Simple Business Processes

Resource The Unifier Provider Resource Object definition

Role The Sample Provider Role Object definition.

WBS WBS business object


302

In This Section

CBS ....................................................................................................................... 302 CBSDurationSummary .......................................................................................... 303 CBSExpenseSpread ............................................................................................. 303 CBSResourceSpread ............................................................................................ 305 CompanyCosts ...................................................................................................... 307 Column .................................................................................................................. 307 CompanyCostsDetail ............................................................................................. 308 CompanyLineItem ................................................................................................. 308 CompanyLineItemDetail ........................................................................................ 309 CompanySimple .................................................................................................... 309 ExchangeRate ....................................................................................................... 310 OtherProjectCosts ................................................................................................. 310 OtherProjectCostsDetail ........................................................................................ 310 P6ActivitySheet ..................................................................................................... 311 Project ................................................................................................................... 312 ProjectCommits ..................................................................................................... 313 ProjectCommitsDetail ............................................................................................ 314 ProjectDocument ................................................................................................... 314 ProjectDocumentDetail .......................................................................................... 315 ProjectInvoices ...................................................................................................... 315 ProjectInvoicesDetail ............................................................................................. 316 ProjectSimple ........................................................................................................ 317 Resource ............................................................................................................... 317 Role....................................................................................................................... 317 ShellList ................................................................................................................ 318 WBS ...................................................................................................................... 318

CBS

Description: CBS business object


bitemid The CBS Code id generated by system. No

code CBS code No

item CBS code description No

parentid Parent element ID No

ProjectNumber Project ID No

status CBS status No


303

CBSDurationSummary

Description: Create/Update Duration Based Summary Sheet in Unifier.


ActualDuration Actual Duration of work done for a CBS code No

ActualFinish Actual date when work gets finished for a CBS code No

ActualStart Actual date when work gets started for a CBS code No

BaselineType Baseline type of the associated baseline No

bitemid CBS code ID No

DataDate Progress As Of Date v

ElementId The unique identifier of the Duration Summary. No

OriginalProjectId The original Project id for a baseline project No

PercentComplete Percentage of total work completed for a CBS code No

PlannedDuration Planned Duration of work related to a CBS code No

PlannedFinish Planned date for work to get finished for a CBS code No

PlannedStart Planned date for work to get started for a CBS code No


RemainingDuration

Remaining Duration of work related to a CBS code No

RemainingFinish Date when Remaining work would finish for a CBS code

No

RemainingStart Date when Remaining work would get started for a CBS code

No

Title Project Title No

CBSExpenseSpread



ActualCost Actual Cost for a CBS-Expense combination on a date within Actual Duration

No

ActualUnits Actual Units for a CBS-Expense combination on a date within Actual Duration

No


304


AtCompletionCost At Completion Cost for a CBS-Expense combination on a date within At Completion Duration

No

AtCompletionUnits At Completion Units for a CBS-Expense combination on a date within At Completion Duration

No


bitemid CBS code ID. No

DataDate Progress As Of date No

ElementId The unique ID generated by the system. No

EndDate At Completion End date No

ExpenseCategory Expense Category viz. Equipment, Travel, Facilities, etc.

No

OriginalProjectId The original Project ID of a baseline Project No

PlannedCost Planned Cost for a CBS-Expense combination on a date within Planned Duration

No

PlannedUnits Planned Units for a CBS-Expense combination on a date within Planned Duration

No


ProjectNumber The unique Project Number. No

RemainingCost Remaining Cost for a CBS-Expense combination on a date within Remaining Duration

No

RemainingUnits Remaining Units for a CBS-Expense combination on a date within Remaining Duration

No

StartDate At completion Start date No

SummaryActualCost Actual Cost for a CBS-Expense combination No

SummaryActualUnits Actual Units for a CBS-Expense combination No


At Completion Cost for a CBS-Expense combination

No


At Completion Units for a CBS-Expense combination

No

SummaryPlannedCost Planned Cost for a CBS-Expense No


305


combination

SummaryPlannedUnits Planned Units for a CBS-Expense combination

No

SummaryRemainingCost

Remaining cost for a CBS-Expense combination

No

SummaryRemainingUnits

Remaining Units for a CBS-Expense combination

No


uuu_object_id The resource Element id of the associated Resource

No

CBSResourceSpread



ActualCost Actual Cost of work on a date within Actual Duration

No

ActualUnits Actual Units of work on a date within Actual Duration

No

AtCompletionCost At Completion Cost of work on a date within Actual Duration

No

AtCompletionUnits At Completion Units on a date within Actual Duration

No


bitemid CBS code ID. No

currencyid Currency Code No

DataDate Progress As Of date No


EndDate At Completion End date No

OriginalProjectId The Original Project id of a Baseline Project

No

PlannedCost Planned Cost of work on a date within Planned Duration

No


306


PlannedUnits Planned Units of work on a date within Planned Duration

No



RemainingCost Remaining Cost of work on a date within Actual Duration

No

RemainingUnits Remaining Units of work on a date within Remaining Duration

No

StartDate At Completion Start date No

SummaryActualCost Actual cost of work for a CBS-Resource combination

No

SummaryActualFinish Actual Finish Date of work for a CBS-Resource combination

No

SummaryActualStart Actual Start Date of work for a CBS-Resource combination

No

SummaryActualUnits Actual Units of work for a CBS-Resource combination

No


Cost when work for a CBS-Resource combination will be completed

No


Units to complete work for a CBS-Resource combination

No

SummaryPlannedCost Planned Cost of work related to a CBS-Resource combination

No

SummaryPlannedUnits Planned Units of work related to a CBS-Resource combination

No

SummaryPlannedStart Planned date for work to get started for a CBS-Resource combination

No

SummaryPlannedFinish Planned date for work to get finished for a CBS-Resource combination

No

SummaryRemainingCost Remaining cost of work for a CBS-Resource combination

No

SummaryRemainingFinishFinish Date of remaining work for a CBS-Resource combination

No

SummaryRemainingStart Start Date of remaining work for a CBS-Resource combination

No

SummaryRemainingUnits Remaining Units of work for a No


307


CBS-Resource combination


UnitName Role Unit of Measure Name No

uuu_object_id The resource Element id of the associated Resource

No

uuu_role_id Role Id No

uuu_role_name Role Name No

uuu_role_type Role Type No

uuu_role_uom Role Unit of Measure Abbreviation No

CompanyCosts

Description: Company Costs Business Processes


amount Amount No

creator_id Creator No

Elementid The unique ID generated by the system. No

record_no Record Number No

status Status No

title Title No

uuu_creation_date Creation Date No

Column

Description: Cost Sheet Column Data


amount Amount No

ElementId The unique ID generated by the system No

long_description Long Description No

quantity Quantity No


308


short_description Short Description No

spends_category Spends Category No

unit_cost Unit Cost No

unit_of_measure Unit of Measure No

wbs_code Cost Code No

CompanyCostsDetail

Description: Company Costs Detail Business Processes


amount Amount No


li_num Line No. No

ParentElementId Unique ID of the parent company cost No

record_no Parent Record Number No

short_desc Short Description No

uuu_quantity Item Quantity No

uuu_tab_id Tab Name No

uuu_unit_price Item Unit Cost No

CompanyLineItem

Description: Company LineItem Business Processes



due_date Due Date No



status Status No


309


title Title No


uuu_dm_publish_path Publish Path No

uuu_week_picker Week Of No

CompanyLineItemDetail

Description: Company LineItem Detail Business Processes



li_num Line No. No

ParentElementId Unique id of the parent company cost No




uuu_week_picker Week Of

CompanySimple

Description: Company Simple Business Processes



due_date Due Date



status Status No

title Title No


uuu_dm_publish_path Publish Path


310

ExchangeRate

Description: Exchange Rate


currency_code Currency Code No

currency_name Currency Name No

ElementId The unique ID generated by the system No

rate Currency Rate No

OtherProjectCosts

Description: Other Project Costs Business Processes


amount Amount No





status Status No

title Title No



OtherProjectCostsDetail

Description: Other Projects Detail Business Processes


amount Amount No

bItemId Cost Code No


311


description Description No


li_num Line No. No




uuu_effective_date Effective Date No

uuu_fund_code Fund Code No




wpid Work Package No

P6ActivitySheet

Description: P6 Activity Sheet business object.


ElementId The unique identifier of the project. No


uuu_P6ActivityId P6 Activity ID generated by system. No

uuu_P6ActivityName Activity Name No

uuu_P6ActivityStatus uuu_P6ActivityStatus No

uuu_P6ActivityType uuu_P6ActivityType No

uuu_P6ActualDuration uuu_P6ActualDuration No

uuu_P6ActualFinish uuu_P6ActualFinish No

uuu_P6ActualStart uuu_P6ActualStart No

uuu_P6ActualTotalCost uuu_P6ActualTotalCost No

uuu_P6AtCompletionDuration

uuu_P6AtCompletionDuration No

uuu_P6AtCompletionTotalCost

uuu_P6AtCompletionTotalCost No


312


uuu_P6Finish uuu_P6Finish No

uuu_P6PercentComplete

uuu_P6PercentComplete No

uuu_P6PlannedDuration uuu_P6PlannedDuration No

uuu_P6PlannedFinish uuu_P6PlannedFinish No

uuu_P6PlannedStart uuu_P6PlannedStart No

uuu_P6PlannedTotalCost

uuu_P6PlannedTotalCost No

uuu_P6PrimaryConstraint

Activity Primary Constraint Type No

uuu_P6RemainingDuration

uuu_P6RemainingDuration No

uuu_P6RemainingEarlyFinish

uuu_P6RemainingEarlyFinish No

uuu_P6RemainingEarlyStart

uuu_P6RemainingEarlyStart No

uuu_P6RemainingTotalCost

uuu_P6RemainingTotalCost No

uuu_P6SecondaryConstraint

Activity Secondary Constraint type No

uuu_P6Start uuu_P6Start No

uuu_P6WBSCode uuu_P6WBSCode No

uuu_P6WBSName uuu_P6WBSName No

uuu_P6WBSPath The WBS path of the activity. No

Project

Description: Unifier Project Header.

Field Description Read_Only

description The description of the project. No

ElementId The unique identifier of the project. No

ProjectName The name of the Project. No

ProjectNumber The Unique Project Number. No


313

Field Description Read_Only

uuu_int_internal_proj_id

P6 internal project ID No

uuu_int_schedule_type

Schedule type of the project - Valid values are "Duration" or "Resource" or "Cost".

No

uuu_location The Location of the project. No

uuu_project_start_date

Project Start Date No

uuu_shell_status The status of the project. No

ProjectCommits

Description: Project Commits Business Processes


amount Amount No


currencid Transaction Currency No

currencyrate Rate in Project Currency No





ref_bpo Reference BPO No

refid Contract/PO No

status Status No

title Title No





314

ProjectCommitsDetail

Description: Projects Commits Detail Business Processes


amount Amount No




li_num Line No. No

ParentDetailId Unique ID of the parent project commts detail

No



ref_bpo_lineitem Reference BPO LineItem No



uuu_sovlinum Reference No




ProjectDocument

Description: Project Document Business Processes







status Status No

title Title No


315




ProjectDocumentDetail

Description: Projects Document Detail Business Processes



li_num Line No. No




uuu_issue_date Issue Date No

uuu_line_item_status Line Item Status No

uuu_name Name No


ProjectInvoices

Description: Project Invoices Business Processes


amount Amount No


currencid Transaction Currency No

due_date Due Date No




refid Contract/PO No


316


status Status No

title Title No




ProjectInvoicesDetail

Description: Projects Invoices Detail Business Processes


_breakdown Break Down No

_refnum Reference Number No

amount Amount No




li_num Line No. No

ParentDetailId Unique id of the parent project commts detail

No



scheduled_value Scheduled Value No








317

ProjectSimple

Description: Project Simple Business Processes





status Status No

title Title No



Resource

Description: The Unifier Provider Resource Object definition.


default_role Resource Default Role Name No

ElementId The unique identifier for the resource No

uuu_resc_capacity Resource Capacity No

uuu_resc_code Resource Code No

uuu_resc_name Resource Name No

uuu_resc_status Resource Status No

uuu_user_email User Email ID No

uuu_user_firstname User First Name No

uuu_user_lastname User Last Name No

Role

Description: The Sample Provider Role Object definition.


ElementId The unique identifier for the resource No


318


uuu_role_id The unique identifier of the Role. No

uuu_role_name The name of the resource or role. No

ShellList

Description: Unifier Shell List Header


description The description of the project No

ElementId The unique identifier of the project No

ProjectName The name of the project. No

ProjectNumber The Unique Project Number No

uuu_int_internal_proj_id P6 Internal Project Id No

uuu_int_schedule_type Schedule type of the project. Valid values are "Duration" or "Resource" or "Cost"

No

uuu_location The Location of the project No

uuu_project_start_date Project Start Date No

uuu_shell_status The status of the project No

WBS

Description: WBS business object


bitemid The WBS Code id generated by system. No

code WBS code No

item WBS code description No

orderid WBS Order id identifying placement of sibling codes within a hierarchy

No

parentid Parent WBS id for a child WBS No


status WBS Status No


319

320

Oracle Primavera Gateway Providers Data Dictionary

Copyright © 2013, 2017, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are “commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate failsafe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

This software or hardware and documentation may provide access to or information on content, products and services from third-parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.

Legal Notices

Documents

Gateway Providers Data Dictionary - Oracle Cloud · wish to use this object to integrate data with your ERP application. ProjectFinanceElement The EnterpriseTrack ProjectFinanceSnapshot