|
This shows the progression for the employee's employment pass. When the pass was sent in for application, when does it expiry, the issue date etc. |
|
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 |
|
The effective date of the employment pass, i.e. when the pass was valid. It also acts as a primary key for the EmployPassProgression table. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the identity of the career for the employment pass holder. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
States the expiry date of the employment pass. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
Shows the application date of the employment pass. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
Shows the arrival date of the employment pass holder, i.e. the date the employee arrived in the country. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
States the cancellation date of the employment pass. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
States the issue date of the employment pass. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the Foreign Identification Number of the employee's employment pass. |
|
Name |
|
|
Code |
|
|
Data Type |
char(255) |
|
Mandatory |
No |
|
Stores remarks about the employee's employment pass. |
|
Name |
|
|
Code |
|
|
Data Type |
smallint |
|
Mandatory |
No |
|
Indicates if the employee is currently employed in the company. |
|
|
|