Contacts File Links Table Formats (ContactsFileLinks)

Follow DPS specifications for preparing a file containing contact file links.

Field Name	Data Type	Length	Notes
LinkID	varchar	32	Unique internal key for the file's link to the contact record; primary key
ContactID	varchar	32	Contact record number; required field; must exist in Contacts (ContactID/(LastName,FirstName,MiddleName,ClientID/Client))
Description	varchar	100	User-entered file description
FilePath	varchar	255	File's file path location
Graphic	varchar	1	Variable indicating whether or not the linked file is a graphic file; default is N (No)