Contracts - Contacts Table Formats (PRContactAssoc)

Follow GovWin Capture Management specifications for preparing a file containing contract-contact associations.

Field Name Data Type Length Notes
WBS1 varchar 30 Contract record number; primary key; must exist in PR
ContactID varchar 32 Internal identifier for the contact; links to the Contacts Table; primary key; must exist in Contacts (ContactID/(LastName,FirstName,MiddleName,ClientID/Client))
Role varchar 10 Contact's contract role; null or must exist in CFGContactRole (Code/Description)
RoleDescription text 16 User-entered text describing the role
PrimaryInd varchar 1 Variable indicating whether or not the contact is the contract's Primary Contact; default is N (No)
TeamStatus varchar 8 Variable indicating the status of a contact being added to a contract team; valid options are Active (approved) or Proposed (awaiting approval)