|
This entity records the educational records of the employees. This feature is used to key in the education of the employee. It is divided into 3 sections, General (Education), Attachment (EduAttachment), Major/Minor (EduMajor). |
|
Name |
Code |
Class Name |
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
Reference |
|
Name |
Code |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
Yes |
|
This attribute is the system generated identifier. It is blind to the user. It also holds the primary key for the Personal table. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
Yes |
|
Shows the identity for the education record. This is a running number derived from the identity number of the employee. This is also the primary key for the EducationRec table. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
This attribute records the start date of the education for the employee. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
This attribute records the end date of the education for the employee. |
|
Name |
|
|
Code |
|
|
Data Type |
char(100) |
|
Mandatory |
No |
|
This attribute records the name of institution where the person takes the education. It can also be the name of the school which the education was received and completed. |
|
Name |
|
|
Code |
|
|
Data Type |
smallint |
|
Mandatory |
No |
|
Indicates if this is the highest education for the employee, in a form of a checkbox. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the results of the education. |
|
|
|