Import Export Database Table Field Mappings
Review database table field mappings for data import and export.
| Microsoft Project Database Table Field | Vision Database Table Field |
|---|---|
| Project.Name | RPPlan.PlanName |
| Project.ProjectStart | RPPlan.StartDate |
| Project.ProjectFinish | RPPlan.EndDate |
| SUM(Task.BaselineWork / 60) WHERE Task.OutlineLevel = "0" | RPPlan.BaselineLaborHrs |
| SUM(Task.Work / 60) WHERE Task.OutlineLevel = "0" | RPPlan.PlannedLaborHrs |
| SUM(Task.BaselineCost) WHERE Task.OutlineLevel = "0" | RPPlan.BaselineLabCost |
| SUM(Task.Cost) WHERE Task.OutlineLevel = "0" | RPPlan.PlannedLabCost |
| Task.Name | RPTask.Name |
| Task.Start | RPTask.StartDate |
| Task.Finish | RPTask.EndDate |
| Task.OutlineNumber | RPTask.OutlineNumber |
| Task.OutlineChildren.Count | RPTask.ChildrenCount |
| Task.OutlineLevel - 1 | RPTask.OutlineLevel |
| Task.Priority | RPTask.Priority |
| (Task.BaselineWork / 60) | RPTask.BaselineLaborHrs |
| (Task.Work / 60) | RPTask.PlannedLaborHrs |
| Task.BaselineCost | RPTask.BaselineLabCost |
| Task.Cost | RPTask.PlannedLabCost |
| Resource.StandardRate | RPAssignment.CostRate |
| Assignment.Start | RPAssignment.StartDate |
| Assignment.Finish | RPAssignment.EndDate |
| (Assignment.BaselineWork / 60) | RPAssignment.BaselineLaborHrs |
| (Assignment.Work / 60) | RPAssignment.PlannedLaborHrs |
| Assignment.BaselineCost | RPAssignment.BaselineLabCost |
| Assignment.Cost | RPAssignment.PlannedLabCost
RPPlan.BudgetType is defaulted to "C" (Cost) RPPlan.PctCompleteFormula is defaulted to "0" (User Entered) RPPlan.AvailableFlg is defaulted to "Y" RPPlan.UnpostedFlg is defaulted to "N" RPPlan.UtilizationIncludeFlg is defaulted to "Y" RPPlan.GenResTableNo defaults to the first labor category billing rate table marked as available for Planning RPPlan.CostRtMethod is defaulted to "0" RPPlan.BillingRtMethod is defaulted to "0" RPPlan.CostRtTableNo is defaulted to "0" RPPlan.BillingRtTableNo is defaulted to "0" |