Entity EmployeeRecurAllowance

Description of Entity EmployeeRecurAllowance

This is where you set up a pay element that is automatically inserted every time you initialise payroll. Each employee can have one or more recurring pay element set up. If you do not see any records for a selected employee, it means that none has been set up yet. A recurring pay element set up can be deleted without affecting pay pay records. A recurring pay element is in essence, a set of instructions and rules to insert the pay element.


List of all Dependencies of the Entity EmployeeRecurAllowance

Name

Code

Class Name

Relation_42842

Relation_42842

Reference

Ref_5170

Ref_5170

Reference


List of Attributes of the Entity EmployeeRecurAllowance

Name

Code

EmployeeSysId

EmployeeSysId

Formula ID

FormulaId

RecurAlloSGSPGenId

RecurAlloSGSPGenId

Suspend Recurring

RecurAlloSuspense

Full Amount

RecurAlloFullAmount

Recur Amount

RecurAlloAmount

End Counter

RecurAlloEndCounter

Sub Period

RecurAlloSubPeriod

Start Year

RecurAlloStartYear

Start Period

RecurAlloStartPeriod

End Year

RecurAlloEndYear

End Period

RecurAlloEndPeriod

Remarks

RecurAlloDesc

Created Process

RecurCreated

Pay Record ID

RecurAlloPayRecId

UserDef1Value

UserDef1Value

UserDef2Value

UserDef2Value

UserDef3Value

UserDef3Value

UserDef4Value

UserDef4Value

UserDef5Value

UserDef5Value


Entity Attribute EmployeeSysId of the Entity EmployeeRecurAllowance

Card of Attribute EmployeeSysId of the Entity EmployeeRecurAllowance

Name

EmployeeSysId

Code

EmployeeSysId

Data Type

integer

Mandatory

Yes


Description of Attribute EmployeeSysId of the Entity EmployeeRecurAllowance

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


Entity Attribute Formula ID of the Entity EmployeeRecurAllowance

Card of Attribute Formula ID of the Entity EmployeeRecurAllowance

Name

Formula ID

Code

FormulaId

Data Type

char(20)

Mandatory

Yes


Description of Attribute Formula ID of the Entity EmployeeRecurAllowance

Shows the formula on what leave / deduction / allowance etc, the employee has taken. This is the primary key for the Formula table.
Example: ANL (Annual leave) / Deduction of Sick leave / HOL (Paid Holiday)


Entity Attribute RecurAlloSGSPGenId of the Entity EmployeeRecurAllowance

Card of Attribute RecurAlloSGSPGenId of the Entity EmployeeRecurAllowance

Name

RecurAlloSGSPGenId

Code

RecurAlloSGSPGenId

Data Type

char(30)

Mandatory

Yes


Description of Attribute RecurAlloSGSPGenId of the Entity EmployeeRecurAllowance

Shows the generating identity of the recur allowance. This acts as the primary key for the EmployeeRecurAllowance table.
Example: A1 / A2 / A3


Entity Attribute Suspend Recurring of the Entity EmployeeRecurAllowance

Card of Attribute Suspend Recurring of the Entity EmployeeRecurAllowance

Name

Suspend Recurring

Code

RecurAlloSuspense

Data Type

smallint

Mandatory

No


Description of Attribute Suspend Recurring of the Entity EmployeeRecurAllowance

Shows if the allowance should be suspended or not.


Entity Attribute Full Amount of the Entity EmployeeRecurAllowance

Card of Attribute Full Amount of the Entity EmployeeRecurAllowance

Name

Full Amount

Code

RecurAlloFullAmount

Data Type

double

Mandatory

No


Description of Attribute Full Amount of the Entity EmployeeRecurAllowance

Shows the full amount for the allowance.


Entity Attribute Recur Amount of the Entity EmployeeRecurAllowance

Card of Attribute Recur Amount of the Entity EmployeeRecurAllowance

Name

Recur Amount

Code

RecurAlloAmount

Data Type

double

Mandatory

No


Description of Attribute Recur Amount of the Entity EmployeeRecurAllowance

Shows the recurring amount for the allowance.


Entity Attribute End Counter of the Entity EmployeeRecurAllowance

Card of Attribute End Counter of the Entity EmployeeRecurAllowance

Name

End Counter

Code

RecurAlloEndCounter

Data Type

integer

Mandatory

No


Description of Attribute End Counter of the Entity EmployeeRecurAllowance

Shows the end counter for the recurring allowance. The counter is calculated from the start and end period / year. Set this counter to zero and the end period is ignored.


Entity Attribute Sub Period of the Entity EmployeeRecurAllowance

Card of Attribute Sub Period of the Entity EmployeeRecurAllowance

Name

Sub Period

Code

RecurAlloSubPeriod

Data Type

integer

Mandatory

No


Description of Attribute Sub Period of the Entity EmployeeRecurAllowance

Shows the sub period for the allowance.

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 Start Year of the Entity EmployeeRecurAllowance

Card of Attribute Start Year of the Entity EmployeeRecurAllowance

Name

Start Year

Code

RecurAlloStartYear

Data Type

integer

Mandatory

No


Description of Attribute Start Year of the Entity EmployeeRecurAllowance

States the start year of the recurring allowance.
Example: 2013


Entity Attribute Start Period of the Entity EmployeeRecurAllowance

Card of Attribute Start Period of the Entity EmployeeRecurAllowance

Name

Start Period

Code

RecurAlloStartPeriod

Data Type

integer

Mandatory

No


Description of Attribute Start Period of the Entity EmployeeRecurAllowance

Shows the start period of the recurring allowance.
Example: January = "1", February = "2", March = "3" etc.


Entity Attribute End Year of the Entity EmployeeRecurAllowance

Card of Attribute End Year of the Entity EmployeeRecurAllowance

Name

End Year

Code

RecurAlloEndYear

Data Type

integer

Mandatory

No


Description of Attribute End Year of the Entity EmployeeRecurAllowance

Shows the end year of the recurring allowance.
Example: 2014


Entity Attribute End Period of the Entity EmployeeRecurAllowance

Card of Attribute End Period of the Entity EmployeeRecurAllowance

Name

End Period

Code

RecurAlloEndPeriod

Data Type

integer

Mandatory

No


Description of Attribute End Period of the Entity EmployeeRecurAllowance

Shows the end period of the recurring allowance.
Example: October = "10" / November = "11" / December = "12" etc


Entity Attribute Remarks of the Entity EmployeeRecurAllowance

Card of Attribute Remarks of the Entity EmployeeRecurAllowance

Name

Remarks

Code

RecurAlloDesc

Data Type

char(100)

Mandatory

No


Description of Attribute Remarks of the Entity EmployeeRecurAllowance

Store any remarks about the recurring allowance.


Entity Attribute Created Process of the Entity EmployeeRecurAllowance

Card of Attribute Created Process of the Entity EmployeeRecurAllowance

Name

Created Process

Code

RecurCreated

Data Type

char(1)

Mandatory

No


Description of Attribute Created Process of the Entity EmployeeRecurAllowance

Shows the creating process of the recurring allowance.


Entity Attribute Pay Record ID of the Entity EmployeeRecurAllowance

Card of Attribute Pay Record ID of the Entity EmployeeRecurAllowance

Name

Pay Record ID

Code

RecurAlloPayRecId

Data Type

char(20)

Mandatory

No


Description of Attribute Pay Record ID of the Entity EmployeeRecurAllowance

Stores the identity for the pay record.
Example: Normal / Normal Time Sheet


Entity Attribute UserDef1Value of the Entity EmployeeRecurAllowance

Card of Attribute UserDef1Value of the Entity EmployeeRecurAllowance

Name

UserDef1Value

Code

UserDef1Value

Data Type

double

Mandatory

No


Description of Attribute UserDef1Value of the Entity EmployeeRecurAllowance

Shows the first user defined parameter value. The values for these user-defined fields will not be extracted from the system but to be entered by the user during pay record processing when the code is selected.


Entity Attribute UserDef2Value of the Entity EmployeeRecurAllowance

Card of Attribute UserDef2Value of the Entity EmployeeRecurAllowance

Name

UserDef2Value

Code

UserDef2Value

Data Type

double

Mandatory

No


Description of Attribute UserDef2Value of the Entity EmployeeRecurAllowance

Shows the second user defined parameter value. The values for these user-defined fields will not be extracted from the system but to be entered by the user during pay record processing when the code is selected.


Entity Attribute UserDef3Value of the Entity EmployeeRecurAllowance

Card of Attribute UserDef3Value of the Entity EmployeeRecurAllowance

Name

UserDef3Value

Code

UserDef3Value

Data Type

double

Mandatory

No


Description of Attribute UserDef3Value of the Entity EmployeeRecurAllowance

Shows the third user defined parameter value. The values for these user-defined fields will not be extracted from the system but to be entered by the user during pay record processing when the code is selected.


Entity Attribute UserDef4Value of the Entity EmployeeRecurAllowance

Card of Attribute UserDef4Value of the Entity EmployeeRecurAllowance

Name

UserDef4Value

Code

UserDef4Value

Data Type

double

Mandatory

No


Description of Attribute UserDef4Value of the Entity EmployeeRecurAllowance

Shows the forth user defined parameter value. The values for these user-defined fields will not be extracted from the system but to be entered by the user during pay record processing when the code is selected.


Entity Attribute UserDef5Value of the Entity EmployeeRecurAllowance

Card of Attribute UserDef5Value of the Entity EmployeeRecurAllowance

Name

UserDef5Value

Code

UserDef5Value

Data Type

double

Mandatory

No


Description of Attribute UserDef5Value of the Entity EmployeeRecurAllowance

Shows the fifth user defined parameter value. The values for these user-defined fields will not be extracted from the system but to be entered by the user during pay record processing when the code is selected.