|
Section 3 of Appendix 8A is to record the value of the hotel accommodation provided by the employer. |
|
Name |
Code |
Class Name |
|
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 |
char(3) |
|
Mandatory |
Yes |
|
This is a running number for each employee in the hotel accommodation. This is the primary key for the A8AS3 table. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
No |
|
Stores the description about the hotel accommodation. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
No |
|
Shows the number of persons that will be living in the hotel accommodation. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the rate per person per month for the hotel. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the length of stay in the hotel. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
States a value of an item. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the identity of the keyword. |
|
|
|