|
This entity stores information about the employee. Some personal information like his/her address, name and date-of-birth. It also shows the flag rate for CPF and other wages. This entity is mainly for specific employees. |
|
Name |
Code |
Class Name |
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
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 year. This holds the primary key for the YEEmployee table. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the tax number of the employee. |
|
Name |
|
|
Code |
|
|
Data Type |
char(30) |
|
Mandatory |
No |
|
Displays the designation of the employee. |
|
Name |
|
|
Code |
|
|
Data Type |
char(30) |
|
Mandatory |
No |
|
Shows the block / house number of the employee. |
|
Name |
|
|
Code |
|
|
Data Type |
char(30) |
|
Mandatory |
No |
|
Shows the street name of the employee's address. |
|
Name |
|
|
Code |
|
|
Data Type |
char(30) |
|
Mandatory |
No |
|
Shows which level the employee is living on. |
|
Name |
|
|
Code |
|
|
Data Type |
char(30) |
|
Mandatory |
No |
|
Shows the unit number of the employee's address. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the type of address. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the country of the address location. |
|
Name |
|
|
Code |
|
|
Data Type |
char(6) |
|
Mandatory |
No |
|
Stores the postal code of the person's address. |
|
Name |
|
|
Code |
|
|
Data Type |
char(35) |
|
Mandatory |
No |
|
The first line for the employee's name. |
|
Name |
|
|
Code |
|
|
Data Type |
char(35) |
|
Mandatory |
No |
|
The second line for the employee's address. |
|
Name |
|
|
Code |
|
|
Data Type |
char(10) |
|
Mandatory |
No |
|
The third line for the employee's address. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
Stores the date of birth of the person. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
Shows when the employee's commencement was. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
Shows the cessation date for the employee. |
|
Name |
|
|
Code |
|
|
Data Type |
char(1) |
|
Mandatory |
No |
|
Indicates if the employee is under the iras section 45 - Non resident director and is withholding tax on the director's fee. |
|
Name |
|
|
Code |
|
|
Data Type |
char(1) |
|
Mandatory |
No |
|
The IR8S indicator is to track if employees have made excess CPF contributions on their wages and will claim the refund for excess CPF contributions. |
|
Name |
|
|
Code |
|
|
Data Type |
char(1) |
|
Mandatory |
No |
|
Shows if employees are provided with benefits-in-kind. |
|
Name |
|
|
Code |
|
|
Data Type |
char(1) |
|
Mandatory |
No |
|
Shows a flag rate of 100,000 on its chargeable income regardless of whether it is in a local or foreign company. |
|
Name |
|
|
Code |
|
|
Data Type |
char(1) |
|
Mandatory |
No |
|
Shows the flag percentage of the ordinary wage. |
|
Name |
|
|
Code |
|
|
Data Type |
char(1) |
|
Mandatory |
No |
|
Shows the overseas flag rate for CPF. |
|
Name |
|
|
Code |
|
|
Data Type |
char(1) |
|
Mandatory |
No |
|
Shows if the flag rate exceeds CPF. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the nationality code of each country. |
|
Name |
|
|
Code |
|
|
Data Type |
char(1) |
|
Mandatory |
No |
|
Shows the identity type of the payee. It refers to the Organisation ID type. |
|
Name |
|
|
Code |
|
|
Data Type |
char(1) |
|
Mandatory |
No |
|
Indicates if the employee is under cessation provision, in a form of a checkbox. |
|
Name |
|
|
Code |
|
|
Data Type |
char(60) |
|
Mandatory |
No |
|
This attribute holds the description or long name for the marital status code. |
|
Name |
|
|
Code |
|
|
Data Type |
char(1) |
|
Mandatory |
No |
|
Shows the gender of the family member. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the global identity for the current year end. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the global identity for the year end. |
|
Name |
|
|
Code |
|
|
Data Type |
char(1) |
|
Mandatory |
No |
|
Shows the tax clearance. |
|
Name |
|
|
Code |
|
|
Data Type |
timestamp |
|
Mandatory |
No |
|
Stores the date and time of when the previous changes were made. |
|
Name |
|
|
Code |
|
|
Data Type |
char(100) |
|
Mandatory |
No |
|
Stores the nationality of the employee. |
|
|
|