Opportunities - Employees Table Formats (OpportunityEMAssoc)
Follow GovWin Capture Management 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 |