|
This entity would record all the foreign worker information, e.g. Work permit number, the issue date of the work permit number 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 |
|
Shows the effective date of the Foreign Worker Levy. It also holds the primary key for the FWLProgression table. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the identity of the career for the foreign worker levy. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
Stores the expiry date of the Foreign Worker Levy. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
Shows the application date for the Foreign Worker Levy, i.e. the date of when the employee applied for the FWL. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
Shows the arrival date of the FWL employee. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
Shows the cancellation date of the FWL. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
Shows the date of issue of the FWL. |
|
Name |
|
|
Code |
|
|
Data Type |
char(30) |
|
Mandatory |
No |
|
The FWL permit number. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the identity of the formula for the FWL. |
|
Name |
|
|
Code |
|
|
Data Type |
smallint |
|
Mandatory |
No |
|
Shows if the employee is currently employed in that company. |
|
Name |
|
|
Code |
|
|
Data Type |
char(255) |
|
Mandatory |
No |
|
Stores any remarks about the Foreign Worker Levy progression. |
|
|
|