Entity PayGroup

Description of Entity PayGroup

This Entity contains the common pay configuration.

Each Pay Group has a different Basic Rate Type:
1. Monthly Rated
2. Daily Rated
3. Hourly Rated

Pay Group Conversion Rule:
1. Target Pay Group will have a same number of Period as Source Pay Group.
2. Both Target and Source Pay Group last Sub Period must be locked and without initialising the new period.
3. Target and Source must be in the same Period.
4. It is the user duty to ensure the Cut-Off date is matched for both Pay Group.


List of all Dependencies of the Entity PayGroup

Name

Code

Class Name

Relation_71745

Relation_71745

Reference

Relation_70578

Relation_70578

Reference

Relation_67288

Relation_67288

Reference

Relation_43849

Relation_43849

Reference

Ref_5155

Ref_5155

Reference

Relation_175995

Relation_175995

Reference


List of Attributes of the Entity PayGroup

Name

Code

Pay Group ID

PayGroupId

No Of Sub Period

NoSubPeriod

Period Start Year

PeriodStartYear

Period Start PR Period

PeriodStartPRPeriod

Period Start PR Month

PeriodStartPRMonth

Description

PayGroupDesc

Pay Balance Last Sub Period

PayBalLastSubPeriod

Pay Bank Allocation Group ID

PayBankAllocGpId

Payment Exchange Rate ID

PaymentExRateId


Entity Attribute Pay Group ID of the Entity PayGroup

Card of Attribute Pay Group ID of the Entity PayGroup

Name

Pay Group ID

Code

PayGroupId

Data Type

char(20)

Mandatory

Yes


Description of Attribute Pay Group ID of the Entity PayGroup

Holds the identity for the pay group. This also acts as a primary key for the PayGroup table.

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


Entity Attribute No Of Sub Period of the Entity PayGroup

Card of Attribute No Of Sub Period of the Entity PayGroup

Name

No Of Sub Period

Code

NoSubPeriod

Data Type

integer

Mandatory

No


Description of Attribute No Of Sub Period of the Entity PayGroup

Holds the sub period.

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


Entity Attribute Period Start Year of the Entity PayGroup

Card of Attribute Period Start Year of the Entity PayGroup

Name

Period Start Year

Code

PeriodStartYear

Data Type

integer

Mandatory

No


Description of Attribute Period Start Year of the Entity PayGroup

Shows the period start year. It will automatically migrate to the next year upon initialising the next period.
Example: 2013


Entity Attribute Period Start PR Period of the Entity PayGroup

Card of Attribute Period Start PR Period of the Entity PayGroup

Name

Period Start PR Period

Code

PeriodStartPRPeriod

Data Type

integer

Mandatory

No


Description of Attribute Period Start PR Period of the Entity PayGroup

Shows the start period for the pay group.
Example: "1" = January / "2" = February / "3" = March etc


Entity Attribute Period Start PR Month of the Entity PayGroup

Card of Attribute Period Start PR Month of the Entity PayGroup

Name

Period Start PR Month

Code

PeriodStartPRMonth

Data Type

integer

Mandatory

No


Description of Attribute Period Start PR Month of the Entity PayGroup

Shows the start month for the pay group.
Example: "1" = January / "2" = February / "3" = March etc


Entity Attribute Description of the Entity PayGroup

Card of Attribute Description of the Entity PayGroup

Name

Description

Code

PayGroupDesc

Data Type

char(100)

Mandatory

No


Description of Attribute Description of the Entity PayGroup

Stores the description for the pay group.


Entity Attribute Pay Balance Last Sub Period of the Entity PayGroup

Card of Attribute Pay Balance Last Sub Period of the Entity PayGroup

Name

Pay Balance Last Sub Period

Code

PayBalLastSubPeriod

Data Type

smallint

Mandatory

No


Description of Attribute Pay Balance Last Sub Period of the Entity PayGroup

Stores the balance amount to be paid for the last sub period.


Entity Attribute Pay Bank Allocation Group ID of the Entity PayGroup

Card of Attribute Pay Bank Allocation Group ID of the Entity PayGroup

Name

Pay Bank Allocation Group ID

Code

PayBankAllocGpId

Data Type

char(20)

Mandatory

No


Description of Attribute Pay Bank Allocation Group ID of the Entity PayGroup

Shows the identity of the allocation for the payment to be made.
Example: Local


Entity Attribute Payment Exchange Rate ID of the Entity PayGroup

Card of Attribute Payment Exchange Rate ID of the Entity PayGroup

Name

Payment Exchange Rate ID

Code

PaymentExRateId

Data Type

char(20)

Mandatory

No


Description of Attribute Payment Exchange Rate ID of the Entity PayGroup

Shows the identity of the exchange rate.