Employees Education Table Formats (EMDegree)
Follow Vision specifications for preparing a file containing employee education data.
Field Name | Data Type | Length | Notes |
---|---|---|---|
Employee | varchar | 20 | Employee number; required field; must exist in EM |
Seq | smallint | 2 | Internal sequence number for the degree, reflecting its user-specified order on the grid |
Degree | varchar | 10 | Educational degree; required field; must exist in CFGEMDegree (Code/Description) |
Specialty | varchar | 60 | Degree specialty or major area of study |
Institution | varchar | 60 | Educational institution from which the employee received the degree |
YearEarned | smallint | 4 | Year when the employee received the degree |
IncludeInProposal | varchar | 1 | Variable indicating whether or not this degree is to be included with the employee's data when the employee is included in proposals; default is Y (Yes) |