|
Contract Progression is for keeping track of employees who are on short-term contracts, especially the contract numbers. Alerts can be set up via the Alert Module to send email notification on contract end dates. |
|
Name |
Code |
Class Name |
|
Reference |
|
Name |
Code |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
Yes |
|
System generated identifier. It is blind to the user. It also holds the primary key for the Employee table. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
Yes |
|
This attribute holds the contract start date. It also acts as a primary key for the ContractProgression table. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
This attribute is the contract number of the contract. It uniquely identifies each contract. No other employee should share the same contract number even if it is the same in content. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
This attribute holds the contract end or termination date. |
|
Name |
|
|
Code |
|
|
Data Type |
char(100) |
|
Mandatory |
No |
|
Stores any remarks concerning the contract. |
|
Name |
|
|
Code |
|
|
Data Type |
smallint |
|
Mandatory |
No |
|
Indicates if the employee is currently employed in the company, in a form of a checkbox. |
|
|
|