Project Plan - Assignment Table Formats (RPAssignment)

Follow Vision specifications for preparing a file containing project plan-assignment associations.

Field Name Data Type Length Notes

PlanNumber

varchar 30 Required field; must exist in RPPlan

OutlineNumber

varchar 255 Required field

ResourceID

varchar 32 Required field; must exist in EM

AssignmentID

varchar 32

GenericResourceID

varchar 20 RPAssignment.GenericResourceID needs to be joined to GR.Code

ActivityID

varchar 32 Null or must exist in Activity

StartDate

datetime 8 Must exist in RPCalendarInterval

EndDate

datetime 8 Must exist in RPCalendarInterval

CostRate

decimal 9

BillingRate

decimal 9