Project Plan - Baseline Consultant Table Formats (RPBaselineConsultant)

Follow Vision specifications for preparing a file containing baseline consultant expenses for project plans.

Field Name Data Type Length Notes

PlanNumber

varchar 30 Required field; must exist in RPPlan

OutlineNumber

varchar 255 Required field

Account

varchar 13 Required field; must exist in CA

ConsultantID

varchar 32

StartDate

datetime 8 Must exist in RPCalendarInterval

EndDate

datetime 8 Must exist in RPCalendarInterval

PeriodScale

varchar 1

PeriodCount

int 4

PeriodCost

decimal 9

PeriodBill

decimal 9