|
This entity contains the training dates, the venue, contact details and other required information for the National Service. Only employees who are in supervisory position are available for selection under the Authorisation Name field. It also stores the computation function related for NS. |
|
Name |
Code |
Class Name |
|
Reference |
||
|
Reference |
||
|
Reference |
|
Name |
Code |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
No |
|
System generated identifier. It is blind to the user. It also holds the primary key for the Employee table. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
Yes |
|
A system generated identity. It is blind to the user. It also holds the primary key for the NSPayCase table. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
The start date of the employee's National Service. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
The end date of the employee's National Service. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Stores the number of days the employee is serving NS. |
|
Name |
|
|
Code |
|
|
Data Type |
char(40) |
|
Mandatory |
No |
|
Shows the position of the employee in the company. |
|
Name |
|
|
Code |
|
|
Data Type |
char(100) |
|
Mandatory |
No |
|
The venue of the employee's National Service. |
|
Name |
|
|
Code |
|
|
Data Type |
char(40) |
|
Mandatory |
No |
|
First line of the address. |
|
Name |
|
|
Code |
|
|
Data Type |
char(40) |
|
Mandatory |
No |
|
Second line of the address. |
|
Name |
|
|
Code |
|
|
Data Type |
char(40) |
|
Mandatory |
No |
|
Third line of the address. |
|
Name |
|
|
Code |
|
|
Data Type |
char(6) |
|
Mandatory |
No |
|
Stores the postal code of the person's address. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
No |
|
Shows the name of the person to contact other than the employee. |
|
Name |
|
|
Code |
|
|
Data Type |
char(30) |
|
Mandatory |
No |
|
This field contains the contact number for the person. |
|
Name |
|
|
Code |
|
|
Data Type |
char(2) |
|
Mandatory |
No |
|
Shows the computation formula. |
|
Name |
|
|
Code |
|
|
Data Type |
char(1) |
|
Mandatory |
No |
|
Shows the code for the formula. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the identity of the pay element. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
No |
|
Shows the period when NS has commenced. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the payout amount for NS. |
|
Name |
|
|
Code |
|
|
Data Type |
timestamp |
|
Mandatory |
No |
|
Shows the last generation of the National Service. |
|
Name |
|
|
Code |
|
|
Data Type |
smallint |
|
Mandatory |
No |
|
States the time of the eBatch submission. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
Shows when the employee gets the first Saturday off. |
|
Name |
|
|
Code |
|
|
Data Type |
time |
|
Mandatory |
No |
|
Shows the start time of the shift work. |
|
Name |
|
|
Code |
|
|
Data Type |
time |
|
Mandatory |
No |
|
Shows the end time of the shift work. |
|
Name |
|
|
Code |
|
|
Data Type |
smallint |
|
Mandatory |
No |
|
Shows the pay element inserted |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
Shows the date of the payroll. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
No |
|
Shows the year for the payroll. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
No |
|
Shows the period of the payroll. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
No |
|
Shows the sub period for the payroll. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
Shows when the payment was processed. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Stores the identity for the pay record. |
|
Name |
|
|
Code |
|
|
Data Type |
char(60) |
|
Mandatory |
No |
|
The name and identity of the employee who gave authorisation. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the position of the employer who gave authorisation. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the string for the first NS month. String is a data type which includes letters, digits and special characters. It is a sequence of characters. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the string for the second NS month. String is a data type which includes letters, digits and special characters. It is a sequence of characters. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the string for the third NS month. String is a data type which includes letters, digits and special characters. It is a sequence of characters. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the string for the forth NS month. String is a data type which includes letters, digits and special characters. It is a sequence of characters. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the string for the fifth NS month. String is a data type which includes letters, digits and special characters. It is a sequence of characters. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the string for the sixth NS month. String is a data type which includes letters, digits and special characters. It is a sequence of characters. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the identity of the Batch. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
No |
|
Shows the start day for the payroll. |
|
|
|