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