Internal identifier for the Plan record.

The Plan name.

The Plan's number.

Internal identifier for the Opportunity for which the Plan was created.

Internal identifier for the Client for which the Plan was created.

The Project Manager associated with the Plan, as specified by the user.

The Principal associated with the Plan, as specified by the user.

The Supervisor associated with the Plan, as specified by the user.

The Organization associated with the Plan, as specified by the user.

The Plan's start date.

The Plan's end date.

The total BaselineLaborHrs for the PlanID.

The total BaselineLabCost for the PlanID.

The total BaselineLabBill for the PlanID.

The total BaselineExpCost for the PlanID.

The total BaselineExpBill for the PlanID.

The total BaselineConCost for the PlanID.

The total BaselineConBill for the PlanID.

Reserved for future use.

This column is populated with the Start Date when the user selects Save Baseline.

This column is populated with the End Date when the user selects Save Baseline.

The total PlannedLaborHrs for the PlanID.

The total PlannedLabCost for the PlanID.

The total PlannedLabBill for the PlanID.

The total PlannedExpCost for the PlanID.

The total PlannedExpBill for the PlanID.

The total PlannedConCost for the PlanID.

The total PlannedConBill for the PlanID.

Labor revenue.

Total Direct Expense at cost for the PlanID.

Total Direct Expense at billing for the PlanID.

Total Direct Consultant Expense (excluding reimbursable) at cost for the PlanID.

Total Direct Consultant Expense (excluding reimbursable) at billing for the PlanID.

The Cost Rate Method specified by the user, when the BudgetType is Cost.

The Billing Rate Method specified by the user, when the BudgetType is Billing.

The Cost Rate Table specified by the user. The available options depend on the CostRtMethod specified by the user.

The Billing Rate Table specified by the user. The available options depend on the BillingRtMethod specified by the user.

The Labor portion of the project fee, entered by the user.

The Consultant fee, entered by the user.

The contingency percent, entered by the user.

The Contingency Amount, entered by the user.

The Overhead Percent, entered by the user.

Variable indicating whether the Plan is available to other users.

The Generic Resource category specified by the user.

Variable indicating whether unposted transactions are shown in the Actual row on the Labor, Expense, and Consultant tabs.

The type of budget. Valid options are Cost, Billing, or Cost and Billing.

The method by which percent completes will be determined in the Plan.  Valid options are User-Entered % Complete, (Planned Cost-ETC Cost)/Planned Cost, JTD Cost/(JTD Cost + ETC Cost), (Baseline Cost - ETC Cost)/Baseline Cost.

The overall percent complete for the cost budget.

The overall percent complete for the billing budget.

Percent complete Labor based on cost amount.

Percent complete Labor based on billing amount.

Percent complete Expense based on cost amount.

Percent complete Expense based on billing amount.

Percent complete Consultants based on cost amount.

Percent complete Consultants based on billing amount.

PctCompleteLabCost * PlannedLabCost

PctCompleteLabBill * PlannedLabBill

PctCompleteExpCost * PlannedExpCost.

PctCompleteExpBill * PlannedExpBill.

PctCompleteConCost * PlannedConCost.

PctCompleteConBill * PlannedConBill.

Variable indicating whether all of the Plan's resource assignments will be included in calculating the Resource Utilization level.

The project number of the project mapped to the Plan's first project-level line item.

The project's reimbursable allowance.

The value entered in the Probability field on the General tab of Project Planning.

Variable indicating which multiplier to use as labor multiplier in calculating labor revenue.

Depending on the LabMultType, the multiplier to apply to a labor cost/billing amount in calculating LabRevenue.

The Planned Multiplier, on the Analysis tab.

The Planned Ratio, on the Analysis tab.

Variable indicating whether the expense billing amount should be calculated automatically.

Variable indicating whether the consultant billing amount should be calculated automatically.

Variable indicating the method used to calculate billing amounts.

The table number of the table used to specify the billing rate for expenses.

Variable indicating the method to use for calculating consultant billing amounts.

The table number of the table used to specify the billing rate for consultants.

The table number of the table used to specify the billing rate for Generic Resources.

Depending on the ExpBillRtMethod, the multiplier to apply to a cost amount to calculate the billing amount.

The multiplier to apply to a consultant cost amount to calculate the consultant billing amount, when the ExpBillRtMethod uses a multiplier.

Variable indicating whether cost or billing amounts should be used to calculate ConRevenue and ExpRevenue.

The planned expense revenue amount.

The planned consultant revenue amount.

The user-entered, organization-specific target multiplier for plan cost. It does not affect plan calculations or summaries.

The user-entered, organization-specific target multiplier for plan billing. It does not affect plan calculations or summaries.

The total baseline unit quantity for the plan.

Populated from PlannedUntCost when the user selects Save Baseline.

Populated from PlannedUntBill when the user selects Save Baseline.

Total unit quantity for the Plan ID.

Total unit expense at cost for the PlanID.

Total unit expense at billing for the PlanID.

Per cent complete units, based on the cost amount.

Per cent complete units, based on the billing amount.

Total direct unit expense at cost for the PlanID.

Total direct unit expense at billing for the PlanID.

The product of PctCompleteUntCost * PlannedUntCost.

The product of PctCompleteUntBill * PlannedUntBill.

The planned unit revenue amount.

The Plan's status.

Flag indicating whether per cent completes will be entered by period, or on the left-hand side for each row.

The Plan's revenue method.

Variable indicating the basis for analysis calculations.

Variable indicating the method for planning generic resources. Valid options are Category and Labor Code.

The company whose Plan this is.

The week's starting day.

The cost currency code for the Plan; the same as the project currency code for the WBS1.

The billing currency code for the Plan; the same as the billing currency code for the WBS1.

The compensation fee in a multicurrency database, when CostCurrencyCode differs from BillingCurrencyCode.

The consultant fee in a multicurrency database, when CostCurrencyCode differs from BillingCurrencyCode.

The reimbursable allowance in a multicurrency database, when CostCurrencyCode differs from BillingCurrencyCode.

The Plan's earned value formula.

The multiplier used to calculate the Labor Billing amount. This multiplier can be applied to the labor billing rate: Labor Billing Amount = Hours*Billing Rate * BillMultiplier

The multiplier used to calculate the Unit Billing amount. This multiplier can be applied to the unit billing rate: Unit Billing Amount = Hours*Billing Rate * BillMultiplier

Populated from PlannedDirExpCost when the user selects Save Baseline.

Populated from PlannedDirExpBill when the user selects Save Baseline.

Populated from PlannedDirConCost when the user selects Save Baseline.

Populated from PlannedDirConBill when the user selects Save Baseline.

Populated from PlannedDirUntCost when the user selects Save Baseline.

Populated from PlannedDirUntBill when the user selects Save Baseline.

Flag indicating whether committed expenses should be retrieved from the Purchasing application when retrieving the rest of the actual expenses.

The fee amount used in top down planning.

Not used.

Not used.

Not used.

Not used.

Not used.

Not used.

Not used.

Not used.

Not used.

Not used.

Not used.

Reserved for future use.

Reseved for future use.

Reseved for future use.

This is the unique ID that is assigned to each instance of a checked-out plan.

The level where consultant rows are attached to the WBS tree.

The level where expense rows are attached to the WBS tree.

Direct labor compensation fee in cost currency.

Direct expense compensation fee in cost currency.

Expense reimbursable allowance in cost currency.

Consultant reimbursable allowance in cost currency.

Direct labor compensation fee in billing currency.

Direct expense compensation fee in billing currency.

Expense reimbursable allowance in billing currency.

Consultant reimbursable allowance in billing currency.

Username of the user logged in when the Plan record was created.

Date and time when the Plan record was created.

Username of the user logged in when the Plan record was modified.

Date and time when the Plan record was modified.