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)