Entity PayAllocation

Description of Entity PayAllocation

This entity will provide pay allocation to Daily Rated and Monthly Rated.


List of all Dependencies of the Entity PayAllocation

Name

Code

Class Name

Relation_66168

Relation_66168

Reference


List of Attributes of the Entity PayAllocation

Name

Code

EmployeeSysId

EmployeeSysId

Pay Allocation Sub Period

PayAllocationSubPeriod

Pay Allocation Value

PayAllocationValue

Pay Allocation Type ID

PayAllocationTypeId


Entity Attribute EmployeeSysId of the Entity PayAllocation

Card of Attribute EmployeeSysId of the Entity PayAllocation

Name

EmployeeSysId

Code

EmployeeSysId

Data Type

integer

Mandatory

Yes


Description of Attribute EmployeeSysId of the Entity PayAllocation

System generated identifier. It is blind to the user. It also holds the primary key for the Employee table.


Entity Attribute Pay Allocation Sub Period of the Entity PayAllocation

Card of Attribute Pay Allocation Sub Period of the Entity PayAllocation

Name

Pay Allocation Sub Period

Code

PayAllocationSubPeriod

Data Type

integer

Mandatory

Yes


Description of Attribute Pay Allocation Sub Period of the Entity PayAllocation

Shows the pay allocation for the sub period. This also acts as the primary table for the PayAllocation table.

Example:
"1" = 1 Payment Group (Hourly, Daily & Monthly rated)
"2" = 2 Payment Group (Hourly, Daily & Monthly rated)
"3" = 3 Payment Group (Hourly & Daily rated), divided by 3 and the balance is placed in the last sub-period.
"4" = 4 Payment Group (Hourly & Daily rated)


Entity Attribute Pay Allocation Value of the Entity PayAllocation

Card of Attribute Pay Allocation Value of the Entity PayAllocation

Name

Pay Allocation Value

Code

PayAllocationValue

Data Type

double

Mandatory

No


Description of Attribute Pay Allocation Value of the Entity PayAllocation

Shows the value of the pay allocation.


Entity Attribute Pay Allocation Type ID of the Entity PayAllocation

Card of Attribute Pay Allocation Type ID of the Entity PayAllocation

Name

Pay Allocation Type ID

Code

PayAllocationTypeId

Data Type

char(20)

Mandatory

Yes


Description of Attribute Pay Allocation Type ID of the Entity PayAllocation

Shows the identity type of the pay allocation.

For daily pay allocation:
- Fixed days: Set a fixed number of days per sub period
- Work Calendar: Use the employee's work calendar to determine the number of days
- Balance Fixed Calendar: Applicable only for last pay period

For monthly pay allocation: applies to the first sub period only. Balance is placed in the second sub period
- Fixed amount: Type in a fixed wage amount
- Percentage: Wage percentage expressed as whole numbers, i.e. 50% as 50. "%" symbol is not required.