Opportunities - Employees Table Formats (OpportunityEMAssoc)

Follow DPS specifications for preparing a file containing opportunity-employee associations.

Field Name	Data Type	Length	Notes
OpportunityID	varchar	32	Opportunity's number; primary key; must exist in Opportunity (OpportunityID/Opportunity)
Employee	varchar	20	Employee's employee number; primary key; must exist in EM
Role	varchar	10	Employee's role in the opportunity; null or must exist in CFGEmployeeRole (Code/Description)
RoleDescription	text	16	Text describing the role