Entity A8AS3

Description of Entity A8AS3

Section 3 of Appendix 8A is to record the value of the hotel accommodation provided by the employer.


List of all Dependencies of the Entity A8AS3

Name

Code

Class Name

Relation_108360

Relation_108360

Reference


List of Attributes of the Entity A8AS3

Name

Code

PersonalSysId

PersonalSysId

No

Sec3No

Description

Sec3DisplayMsg

No of Persons

Sec3NoOfPersons

Rate per person p m

Sec3Rate

Period Provided No of days

Sec3Period

Value

Sec3Value

Sec3YEKeywordId

Sec3YEKeywordId


Entity Attribute PersonalSysId of the Entity A8AS3

Card of Attribute PersonalSysId of the Entity A8AS3

Name

PersonalSysId

Code

PersonalSysId

Data Type

integer

Mandatory

Yes


Description of Attribute PersonalSysId of the Entity A8AS3

This attribute is the system generated identifier. It is blind to the user. It also holds the primary key for the Personal table.


Entity Attribute No of the Entity A8AS3

Card of Attribute No of the Entity A8AS3

Name

No

Code

Sec3No

Data Type

char(3)

Mandatory

Yes


Description of Attribute No of the Entity A8AS3

This is a running number for each employee in the hotel accommodation. This is the primary key for the A8AS3 table.


Entity Attribute Description of the Entity A8AS3

Card of Attribute Description of the Entity A8AS3

Name

Description

Code

Sec3DisplayMsg

Data Type

char(50)

Mandatory

No


Description of Attribute Description of the Entity A8AS3

Stores the description about the hotel accommodation.


Entity Attribute No of Persons of the Entity A8AS3

Card of Attribute No of Persons of the Entity A8AS3

Name

No of Persons

Code

Sec3NoOfPersons

Data Type

integer

Mandatory

No


Description of Attribute No of Persons of the Entity A8AS3

Shows the number of persons that will be living in the hotel accommodation.


Entity Attribute Rate per person p m of the Entity A8AS3

Card of Attribute Rate per person p m of the Entity A8AS3

Name

Rate per person p m

Code

Sec3Rate

Data Type

double

Mandatory

No


Description of Attribute Rate per person p m of the Entity A8AS3

Shows the rate per person per month for the hotel.


Entity Attribute Period Provided No of days of the Entity A8AS3

Card of Attribute Period Provided No of days of the Entity A8AS3

Name

Period Provided No of days

Code

Sec3Period

Data Type

double

Mandatory

No


Description of Attribute Period Provided No of days of the Entity A8AS3

Shows the length of stay in the hotel.


Entity Attribute Value of the Entity A8AS3

Card of Attribute Value of the Entity A8AS3

Name

Value

Code

Sec3Value

Data Type

double

Mandatory

No


Description of Attribute Value of the Entity A8AS3

States a value of an item.
The formula is:
(Number of units x Rate x Number of days x 12) / 366


Entity Attribute Sec3YEKeywordId of the Entity A8AS3

Card of Attribute Sec3YEKeywordId of the Entity A8AS3

Name

Sec3YEKeywordId

Code

Sec3YEKeywordId

Data Type

char(20)

Mandatory

No


Description of Attribute Sec3YEKeywordId of the Entity A8AS3

Shows the identity of the keyword.
Example: Children <3 / Self / plus 2% etc