| ColumnName |
Domain |
Datatype |
NULL |
Definition |
PlanID |
|
varchar(32) |
NO |
Internal identifier for the Plan record. |
| PlanName |
|
nvarchar(255) |
YES |
The Plan name. |
| PlanNumber |
|
nvarchar(30) |
YES |
The Plan's number. |
| OpportunityID |
|
varchar(32) |
YES |
Internal identifier for the Opportunity for which the Plan was created. |
| ClientID |
|
varchar(32) |
YES |
Internal identifier for the Client for which the Plan was created. |
| ProjMgr |
|
nvarchar(20) |
YES |
The Project Manager associated with the Plan, as specified by the user. |
| Principal |
|
nvarchar(20) |
YES |
The Principal associated with the Plan, as specified by the user. |
| Supervisor |
|
nvarchar(20) |
YES |
The Supervisor associated with the Plan, as specified by the user. |
| Org |
|
nvarchar(30) |
YES |
The Organization associated with the Plan, as specified by the user. |
| StartDate |
|
datetime |
YES |
The Plan's start date. |
| EndDate |
|
datetime |
YES |
The Plan's end date. |
| BaselineLaborHrs |
|
decimal(19, 4) |
NO |
The total BaselineLaborHrs for the PlanID. |
| BaselineLabCost |
|
decimal(19, 4) |
NO |
The total BaselineLabCost for the PlanID. |
| BaselineLabBill |
|
decimal(19, 4) |
NO |
The total BaselineLabBill for the PlanID. |
| BaselineExpCost |
|
decimal(19, 4) |
NO |
The total BaselineExpCost for the PlanID. |
| BaselineExpBill |
|
decimal(19, 4) |
NO |
The total BaselineExpBill for the PlanID. |
| BaselineConCost |
|
decimal(19, 4) |
NO |
The total BaselineConCost for the PlanID. |
| BaselineConBill |
|
decimal(19, 4) |
NO |
The total BaselineConBill for the PlanID. |
| BaselineRevenue |
|
decimal(19, 4) |
NO |
Reserved for future use. |
| BaselineStart |
|
datetime |
YES |
This column is populated with the Start Date when the user selects Save Baseline. |
| BaselineFinish |
|
datetime |
YES |
This column is populated with the End Date when the user selects Save Baseline. |
| PlannedLaborHrs |
|
decimal(19, 4) |
NO |
The total PlannedLaborHrs for the PlanID. |
| PlannedLabCost |
|
decimal(19, 4) |
NO |
The total PlannedLabCost for the PlanID. |
| PlannedLabBill |
|
decimal(19, 4) |
NO |
The total PlannedLabBill for the PlanID. |
| PlannedExpCost |
|
decimal(19, 4) |
NO |
The total PlannedExpCost for the PlanID. |
| PlannedExpBill |
|
decimal(19, 4) |
NO |
The total PlannedExpBill for the PlanID. |
| PlannedConCost |
|
decimal(19, 4) |
NO |
The total PlannedConCost for the PlanID. |
| PlannedConBill |
|
decimal(19, 4) |
NO |
The total PlannedConBill for the PlanID. |
| LabRevenue |
|
decimal(19, 4) |
NO |
Labor revenue. |
| PlannedDirExpCost |
|
decimal(19, 4) |
NO |
Total Direct Expense at cost for the PlanID. |
| PlannedDirExpBill |
|
decimal(19, 4) |
NO |
Total Direct Expense at billing for the PlanID. |
| PlannedDirConCost |
|
decimal(19, 4) |
NO |
Total Direct Consultant Expense (excluding reimbursable) at cost for the PlanID. |
| PlannedDirConBill |
|
decimal(19, 4) |
NO |
Total Direct Consultant Expense (excluding reimbursable) at billing for the PlanID. |
| CostRtMethod |
|
smallint |
NO |
The Cost Rate Method specified by the user, when the BudgetType is Cost. |
| BillingRtMethod |
|
smallint |
NO |
The Billing Rate Method specified by the user, when the BudgetType is Billing. |
| CostRtTableNo |
|
int |
NO |
The Cost Rate Table specified by the user. The available options depend on the CostRtMethod specified by the user. |
| BillingRtTableNo |
|
int |
NO |
The Billing Rate Table specified by the user. The available options depend on the BillingRtMethod specified by the user. |
| CompensationFee |
|
decimal(19, 4) |
NO |
The Labor portion of the project fee, entered by the user. |
| ConsultantFee |
|
decimal(19, 4) |
NO |
The Consultant fee, entered by the user. |
| ContingencyPct |
|
decimal(19, 4) |
NO |
The contingency percent, entered by the user. |
| ContingencyAmt |
|
decimal(19, 4) |
NO |
The Contingency Amount, entered by the user. |
| OverheadPct |
|
decimal(19, 4) |
NO |
The Overhead Percent, entered by the user. |
| AvailableFlg |
|
varchar(1) |
NO |
Variable indicating whether the Plan is available to other users. |
| GenResTableNo |
|
int |
NO |
The Generic Resource category specified by the user. |
| UnPostedFlg |
|
varchar(1) |
NO |
Variable indicating whether unposted transactions are shown in the Actual row on the Labor, Expense, and Consultant tabs. |
| BudgetType |
|
varchar(1) |
NO |
The type of budget. Valid options are Cost, Billing, or Cost and Billing. |
| PctCompleteFormula |
|
smallint |
NO |
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. |
| PctComplete |
|
decimal(19, 4) |
NO |
The overall percent complete for the cost budget. |
| PctCompleteBill |
|
decimal(19, 4) |
NO |
The overall percent complete for the billing budget. |
| PctCompleteLabCost |
|
decimal(19, 4) |
NO |
Percent complete Labor based on cost amount. |
| PctCompleteLabBill |
|
decimal(19, 4) |
NO |
Percent complete Labor based on billing amount. |
| PctCompleteExpCost |
|
decimal(19, 4) |
NO |
Percent complete Expense based on cost amount. |
| PctCompleteExpBill |
|
decimal(19, 4) |
NO |
Percent complete Expense based on billing amount. |
| PctCompleteConCost |
|
decimal(19, 4) |
NO |
Percent complete Consultants based on cost amount. |
| PctCompleteConBill |
|
decimal(19, 4) |
NO |
Percent complete Consultants based on billing amount. |
| WeightedLabCost |
|
decimal(19, 4) |
NO |
PctCompleteLabCost * PlannedLabCost |
| WeightedLabBill |
|
decimal(19, 4) |
NO |
PctCompleteLabBill * PlannedLabBill |
| WeightedExpCost |
|
decimal(19, 4) |
NO |
PctCompleteExpCost * PlannedExpCost. |
| WeightedExpBill |
|
decimal(19, 4) |
NO |
PctCompleteExpBill * PlannedExpBill. |
| WeightedConCost |
|
decimal(19, 4) |
NO |
PctCompleteConCost * PlannedConCost. |
| WeightedConBill |
|
decimal(19, 4) |
NO |
PctCompleteConBill * PlannedConBill. |
| UtilizationIncludeFlg |
|
varchar(1) |
NO |
Variable indicating whether all of the Plan's resource assignments will be included in calculating the Resource Utilization level. |
| WBS1 |
|
nvarchar(30) |
YES |
The project number of the project mapped to the Plan's first project-level line item. |
| ReimbAllowance |
|
decimal(19, 4) |
NO |
The project's reimbursable allowance. |
| Probability |
|
smallint |
NO |
The value entered in the Probability field on the General tab of Project Planning. |
| LabMultType |
|
smallint |
NO |
Variable indicating which multiplier to use as labor multiplier in calculating labor revenue. |
| Multiplier |
|
decimal(19, 4) |
NO |
Depending on the LabMultType, the multiplier to apply to a labor cost/billing amount in calculating LabRevenue. |
| ProjectedMultiplier |
|
decimal(19, 4) |
NO |
The Planned Multiplier, on the Analysis tab. |
| ProjectedRatio |
|
decimal(19, 4) |
NO |
The Planned Ratio, on the Analysis tab. |
| CalcExpBillAmtFlg |
|
varchar(1) |
NO |
Variable indicating whether the expense billing amount should be calculated automatically. |
| CalcConBillAmtFlg |
|
varchar(1) |
NO |
Variable indicating whether the consultant billing amount should be calculated automatically. |
| ExpBillRtMethod |
|
smallint |
NO |
Variable indicating the method used to calculate billing amounts. |
| ExpBillRtTableNo |
|
int |
NO |
The table number of the table used to specify the billing rate for expenses. |
| ConBillRtMethod |
|
smallint |
NO |
Variable indicating the method to use for calculating consultant billing amounts. |
| ConBillRtTableNo |
|
int |
NO |
The table number of the table used to specify the billing rate for consultants. |
| GRBillTableNo |
|
int |
NO |
The table number of the table used to specify the billing rate for Generic Resources. |
| ExpBillMultiplier |
|
decimal(19, 4) |
NO |
Depending on the ExpBillRtMethod, the multiplier to apply to a cost amount to calculate the billing amount. |
| ConBillMultiplier |
|
decimal(19, 4) |
NO |
The multiplier to apply to a consultant cost amount to calculate the consultant billing amount, when the ExpBillRtMethod uses a multiplier. |
| ReimbMethod |
|
varchar(1) |
NO |
Variable indicating whether cost or billing amounts should be used to calculate ConRevenue and ExpRevenue. |
| ExpRevenue |
|
decimal(19, 4) |
NO |
The planned expense revenue amount. |
| ConRevenue |
|
decimal(19, 4) |
NO |
The planned consultant revenue amount. |
| TargetMultCost |
|
decimal(19, 4) |
NO |
The user-entered, organization-specific target multiplier for plan cost. It does not affect plan calculations or summaries. |
| TargetMultBill |
|
decimal(19, 4) |
NO |
The user-entered, organization-specific target multiplier for plan billing. It does not affect plan calculations or summaries. |
| BaselineUntQty |
|
decimal(19, 4) |
NO |
The total baseline unit quantity for the plan. |
| BaselineUntCost |
|
decimal(19, 4) |
NO |
Populated from PlannedUntCost when the user selects Save Baseline. |
| BaselineUntBill |
|
decimal(19, 4) |
NO |
Populated from PlannedUntBill when the user selects Save Baseline. |
| PlannedUntQty |
|
decimal(19, 4) |
NO |
Total unit quantity for the Plan ID. |
| PlannedUntCost |
|
decimal(19, 4) |
NO |
Total unit expense at cost for the PlanID. |
| PlannedUntBill |
|
decimal(19, 4) |
NO |
Total unit expense at billing for the PlanID. |
| PctCompleteUntCost |
|
decimal(19, 4) |
NO |
Per cent complete units, based on the cost amount. |
| PctCompleteUntBill |
|
decimal(19, 4) |
NO |
Per cent complete units, based on the billing amount. |
| PlannedDirUntCost |
|
decimal(19, 4) |
NO |
Total direct unit expense at cost for the PlanID. |
| PlannedDirUntBill |
|
decimal(19, 4) |
NO |
Total direct unit expense at billing for the PlanID. |
| WeightedUntCost |
|
decimal(19, 4) |
NO |
The product of PctCompleteUntCost * PlannedUntCost. |
| WeightedUntBill |
|
decimal(19, 4) |
NO |
The product of PctCompleteUntBill * PlannedUntBill. |
| UntRevenue |
|
decimal(19, 4) |
NO |
The planned unit revenue amount. |
| Status |
|
varchar(1) |
NO |
The Plan's status. |
| PctComplByPeriodFlg |
|
varchar(1) |
NO |
Flag indicating whether per cent completes will be entered by period, or on the left-hand side for each row. |
| RevenueMethod |
|
smallint |
NO |
The Plan's revenue method. |
| AnalysisBasis |
|
varchar(1) |
NO |
Variable indicating the basis for analysis calculations. |
| GRMethod |
|
smallint |
NO |
Variable indicating the method for planning generic resources. Valid options are Category and Labor Code. |
| Company |
|
nvarchar(14) |
NO |
The company whose Plan this is. |
| StartingDayOfWeek |
|
smallint |
NO |
The week's starting day. |
| CostCurrencyCode |
|
nvarchar(3) |
NO |
The cost currency code for the Plan; the same as the project currency code for the WBS1. |
| BillingCurrencyCode |
|
nvarchar(3) |
NO |
The billing currency code for the Plan; the same as the billing currency code for the WBS1. |
| CompensationFeeBill |
|
decimal(19, 4) |
NO |
The compensation fee in a multicurrency database, when CostCurrencyCode differs from BillingCurrencyCode. |
| ConsultantFeeBill |
|
decimal(19, 4) |
NO |
The consultant fee in a multicurrency database, when CostCurrencyCode differs from BillingCurrencyCode. |
| ReimbAllowanceBill |
|
decimal(19, 4) |
NO |
The reimbursable allowance in a multicurrency database, when CostCurrencyCode differs from BillingCurrencyCode. |
| EVFormula |
|
smallint |
NO |
The Plan's earned value formula. |
| LabBillMultiplier |
|
decimal(19, 4) |
NO |
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 |
| UntBillMultiplier |
|
decimal(19, 4) |
NO |
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 |
| BaselineDirExpCost |
|
decimal(19, 4) |
NO |
Populated from PlannedDirExpCost when the user selects Save Baseline. |
| BaselineDirExpBill |
|
decimal(19, 4) |
NO |
Populated from PlannedDirExpBill when the user selects Save Baseline. |
| BaselineDirConCost |
|
decimal(19, 4) |
NO |
Populated from PlannedDirConCost when the user selects Save Baseline. |
| BaselineDirConBill |
|
decimal(19, 4) |
NO |
Populated from PlannedDirConBill when the user selects Save Baseline. |
| BaselineDirUntCost |
|
decimal(19, 4) |
NO |
Populated from PlannedDirUntCost when the user selects Save Baseline. |
| BaselineDirUntBill |
|
decimal(19, 4) |
NO |
Populated from PlannedDirUntBill when the user selects Save Baseline. |
| CommitmentFlg |
|
varchar(1) |
NO |
Flag indicating whether committed expenses should be retrieved from the Purchasing application when retrieving the rest of the actual expenses. |
| TopdownFee |
|
decimal(19, 4) |
NO |
The fee amount used in top down planning. |
| JTDLabHrs |
|
decimal(19, 4) |
NO |
Not used. |
| JTDLabCost |
|
decimal(19, 4) |
NO |
Not used. |
| JTDLabBill |
|
decimal(19, 4) |
NO |
Not used. |
| JTDExpCost |
|
decimal(19, 4) |
NO |
Not used. |
| JTDExpBill |
|
decimal(19, 4) |
NO |
Not used. |
| JTDConCost |
|
decimal(19, 4) |
NO |
Not used. |
| JTDConBill |
|
decimal(19, 4) |
NO |
Not used. |
| JTDUntQty |
|
decimal(19, 4) |
NO |
Not used. |
| JTDUntCost |
|
decimal(19, 4) |
NO |
Not used. |
| JTDUntBill |
|
decimal(19, 4) |
NO |
Not used. |
| JTDRevenue |
|
decimal(19, 4) |
NO |
Not used. |
| NeedsRecalc |
|
varchar(1) |
NO |
Reserved for future use. |
| CheckedOutUser |
|
nvarchar(20) |
YES |
Reseved for future use. |
| CheckedOutDate |
|
datetime |
YES |
Reseved for future use. |
| CheckedOutID |
|
varchar(32) |
YES |
This is the unique ID that is assigned to each instance of a checked-out plan. |
| LastPlanAction |
|
nvarchar(30) |
YES |
|
| ConWBSLevel |
|
smallint |
NO |
The level where consultant rows are attached to the WBS tree. |
| ExpWBSLevel |
|
smallint |
NO |
The level where expense rows are attached to the WBS tree. |
| CompensationFeeDirLab |
|
decimal(19, 4) |
NO |
Direct labor compensation fee in cost currency. |
| CompensationFeeDirExp |
|
decimal(19, 4) |
NO |
Direct expense compensation fee in cost currency. |
| ReimbAllowanceExp |
|
decimal(19, 4) |
NO |
Expense reimbursable allowance in cost currency. |
| ReimbAllowanceCon |
|
decimal(19, 4) |
NO |
Consultant reimbursable allowance in cost currency. |
| CompensationFeeDirLabBill |
|
decimal(19, 4) |
NO |
Direct labor compensation fee in billing currency. |
| CompensationFeeDirExpBill |
|
decimal(19, 4) |
NO |
Direct expense compensation fee in billing currency. |
| ReimbAllowanceExpBill |
|
decimal(19, 4) |
NO |
Expense reimbursable allowance in billing currency. |
| ReimbAllowanceConBill |
|
decimal(19, 4) |
NO |
Consultant reimbursable allowance in billing currency. |
| CostGRRtMethod |
|
smallint |
NO |
|
| BillGRRtMethod |
|
smallint |
NO |
|
| VersionID |
|
varchar(32) |
YES |
|
| CreateUser |
|
nvarchar(30) |
YES |
Username of the user logged in when the Plan record was created. |
| CreateDate |
|
datetime |
YES |
Date and time when the Plan record was created. |
| ModUser |
|
nvarchar(30) |
YES |
Username of the user logged in when the Plan record was modified. |
| ModDate |
|
datetime |
YES |
Date and time when the Plan record was modified. |