Sage EasyPay Data Model

Entity PositionCode

Description of Entity PositionCode

This entity would hold a record of the position that is available in the company. This entity would serve as a look up table.

The positions within the company can be grouped and career paths can be set within each group. The entire structure can be exported to third party tools (e.g. OrgPublisher) for creating organisation charts.

List of all Dependencies of the Entity PositionCode

Reference

Reference

Reference

Reference

Reference

Reference

Reference

List of Attributes of the Entity PositionCode

Entity Attribute Position ID of the Entity PositionCode

Card of Attribute Position ID of the Entity PositionCode

Name	Position ID
Code	PositionId
Data Type	char(20)
Mandatory	Yes

Description of Attribute Position ID of the Entity PositionCode

Shows the identity of the employee's position. This holds the primary key for the PositionCode table.
Example: CEO / Finance Manager / Receptionist / Accountant etc

Entity Attribute Description of the Entity PositionCode

Card of Attribute Description of the Entity PositionCode

Name	Description
Code	PositionDesc
Data Type	char(80)
Mandatory	No

Description of Attribute Description of the Entity PositionCode

Shows the description of the employee's position.
Example: Chief Executive Officer / Finance Manager / Accountant etc

Entity Attribute Key Position of the Entity PositionCode

Card of Attribute Key Position of the Entity PositionCode

Name	Key Position
Code	KeyPosition
Data Type	smallint
Mandatory	No

Description of Attribute Key Position of the Entity PositionCode

Indicates if it is a key position in the company, in a form of a checkbox.

Home