|
This entity shows the funds of the employees and the employers, current basic rates for the Monthly Variably Component and the National Wages Council. |
|
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 acts as a primary key for the AdvanceReport table. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the identity of the exchange rate. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the exchange rate of the advance pay. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the full foreign amount for the basic rate. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the full foreign amount for the Monthly Variable Component. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the full foreign amount for the National Wage Council. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the foreign amount of the basic rate. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the foreign amount of the Monthly Variable Component. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the foreign amount of the National Wage Council. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the basic rate amount. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the Monthly Variable Component amount. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the National Wage Council amount. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Stores the first fund for the employee. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Stores the first fund for the employer. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Stores the second fund for the employee. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Stores the second fund for the employer. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Stores the third fund for the employee. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Stores the third fund for the employer. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Stores the forth fund for the employee. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Stores the forth fund for the employer. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Stores the fifth fund for the employee. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Stores the fifth fund for the employer. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Stores the sixth fund for the employee. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Stores the sixth fund for the employer. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Stores the seventh fund for the employee. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Stores the seventh fund for the employer. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Stores the eighth fund for the employee. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Stores the eighth fund for the employer. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Stores the ninth fund for the employee. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Stores the ninth fund for the employer. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Stores the tenth fund for the employee. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Stores the tenth fund for the employer. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Stores the foreign basic rate amount for the current hire days. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Stores the foreign Monthly Variable Component amount for the current hire days. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Stores the foreign National Wage Council amount for the current hire days. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
States the number of current hire days. |
|
|
|