Employees - Contacts Table Formats (EMContactAssoc)

Follow Vision specifications for preparing a file containing employee-contact associations.

Field Name Data Type Length Notes

Employee

varchar 20 Employee number; primary key; must exist in EM

ContactID

varchar 32 Contact's number; primary key; must exist in ContactID or combination of ContactID/LastName,FirstName,ClientID/Client

Relationship

varchar 10 Contact's relationship to the employee; null or must exist in CFGEmployeeRelationship (Code/Description)

RelationshipDesc

text unlimited Text describing the relationship