Entity A8AS2

Description of Entity A8AS2

Section 2 of Appendix 8A is for declaring the value of furniture or fittings provided to the employee. The form shows you the list of furnishings and their value per month.


List of all Dependencies of the Entity A8AS2

Name

Code

Class Name

Relation_108359

Relation_108359

Reference


List of Attributes of the Entity A8AS2

Name

Code

PersonalSysId

PersonalSysId

Items No

Sec2ItemsNo

Items

Sec2Items

Selection

Sec2Selection

Units

Sec2Unit

Rate per unit p m

Sec2Rate

No of Day

Sec2Days

Value

Sec2Value

Sec2YEKeywordId

Sec2YEKeywordId


Entity Attribute PersonalSysId of the Entity A8AS2

Card of Attribute PersonalSysId of the Entity A8AS2

Name

PersonalSysId

Code

PersonalSysId

Data Type

integer

Mandatory

Yes


Description of Attribute PersonalSysId of the Entity A8AS2

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 Items No of the Entity A8AS2

Card of Attribute Items No of the Entity A8AS2

Name

Items No

Code

Sec2ItemsNo

Data Type

char(3)

Mandatory

Yes


Description of Attribute Items No of the Entity A8AS2

Shows the items number. This is the primary key for the A8AS2 table.


Entity Attribute Items of the Entity A8AS2

Card of Attribute Items of the Entity A8AS2

Name

Items

Code

Sec2Items

Data Type

char(100)

Mandatory

No


Description of Attribute Items of the Entity A8AS2

Shows a selection of items.
Example: Furniture / Refrigerator / Washing Machine etc


Entity Attribute Selection of the Entity A8AS2

Card of Attribute Selection of the Entity A8AS2

Name

Selection

Code

Sec2Selection

Data Type

smallint

Mandatory

No


Description of Attribute Selection of the Entity A8AS2

Indicates if the employee has selected that specific item, in a form of a checkbox.


Entity Attribute Units of the Entity A8AS2

Card of Attribute Units of the Entity A8AS2

Name

Units

Code

Sec2Unit

Data Type

double

Mandatory

No


Description of Attribute Units of the Entity A8AS2

Shows the unit for that specific item.


Entity Attribute Rate per unit p m of the Entity A8AS2

Card of Attribute Rate per unit p m of the Entity A8AS2

Name

Rate per unit p m

Code

Sec2Rate

Data Type

double

Mandatory

No


Description of Attribute Rate per unit p m of the Entity A8AS2

Shows the rate per unit per month.


Entity Attribute No of Day of the Entity A8AS2

Card of Attribute No of Day of the Entity A8AS2

Name

No of Day

Code

Sec2Days

Data Type

double

Mandatory

No


Description of Attribute No of Day of the Entity A8AS2

Shows the number of days in which the items were used.


Entity Attribute Value of the Entity A8AS2

Card of Attribute Value of the Entity A8AS2

Name

Value

Code

Sec2Value

Data Type

double

Mandatory

No


Description of Attribute Value of the Entity A8AS2

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


Entity Attribute Sec2YEKeywordId of the Entity A8AS2

Card of Attribute Sec2YEKeywordId of the Entity A8AS2

Name

Sec2YEKeywordId

Code

Sec2YEKeywordId

Data Type

char(20)

Mandatory

No


Description of Attribute Sec2YEKeywordId of the Entity A8AS2

Shows the identity of the keyword.
Example: WashingMachine / AirConSitting / GolfBag etc