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)