Employees Education Table Formats (EMDegree)

Follow DPS 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)