Entity UtilityUsage

Description of Entity UtilityUsage

Displays the employee's usage of the utility.


List of Attributes of the Entity UtilityUsage

Name

Code

Utility Year

UtilityYear

Period

UtilityMonth

Personal Usage

UtilityCnt

Employee Usage

UtilityEmployeeCnt


Entity Attribute Utility Year of the Entity UtilityUsage

Card of Attribute Utility Year of the Entity UtilityUsage

Name

Utility Year

Code

UtilityYear

Data Type

integer

Mandatory

Yes


Description of Attribute Utility Year of the Entity UtilityUsage

Shows the year of the utility usage. This is the primary key for the UtilityUsage table.
Example: 2013


Entity Attribute Period of the Entity UtilityUsage

Card of Attribute Period of the Entity UtilityUsage

Name

Period

Code

UtilityMonth

Data Type

integer

Mandatory

Yes


Description of Attribute Period of the Entity UtilityUsage

Shows the month of the utility usage. This is also the primary key for the UtilityUsage table.
Example: January = "1" / February = "2" / March = "3" etc


Entity Attribute Personal Usage of the Entity UtilityUsage

Card of Attribute Personal Usage of the Entity UtilityUsage

Name

Personal Usage

Code

UtilityCnt

Data Type

integer

Mandatory

No


Description of Attribute Personal Usage of the Entity UtilityUsage

Shows the personal usage of the utility.


Entity Attribute Employee Usage of the Entity UtilityUsage

Card of Attribute Employee Usage of the Entity UtilityUsage

Name

Employee Usage

Code

UtilityEmployeeCnt

Data Type

integer

Mandatory

No


Description of Attribute Employee Usage of the Entity UtilityUsage

Shows the employee usage of the utility.


Previous
Home
Next