Employees File Links Table Formats (EmployeeFileLinks)
Follow Vision 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 |