Employees File Links Table Formats (EmployeeFileLinks)

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

Field Name Data Type Length Notes
LinkID varchar 32 Unique internal key for the file's link to the employee record; primary key
Employee varchar 20 Employee number; required field; must exist in EM
Description varchar 100 User-entered file description
FilePath varchar 255 File's file path location
Graphic varchar 1 Variable indicating whether the file is a graphic; valid options are Y (Yes) or N (No); default is N