Entity AdvanceProcess

Description of Entity AdvanceProcess

Advance pay processing is similar to Bonus pay processing.
One of the 2 methods used:
- Initialise Pay Period Method
- New Pay Record Method

There is an additional step when using the second method as Advance pay affects Normal pay. Re-processing is required for the normal record to take into account the new Advance pay.


List of all Dependencies of the Entity AdvanceProcess

Name

Code

Class Name

Relation_1275095

Relation_1275095

Reference

Relation_1275118

Relation_1275118

Reference


List of Attributes of the Entity AdvanceProcess

Name

Code

Advance Report ID

AdvReportId

Description

AdvDesc

AdvPayRecYear

AdvPayRecYear

Advance Pay Rec Period

AdvPayRecPeriod

Trial Run

AdvTrialRun

To include for terminated employee in this Period

AdvIncTerminated

To include for not confirmed employee in this Period

AdvIncNotConfirmed

To include for New Hire in this Period

AdvIncNewHire

CPF Deduction

AdvFundDeduct

Fixed Amount or Percentage

AdvBROption

Advance Basic Rate Value

AdvBRValue

Fixed Amount or Percentage or No Advance

AdvMVCOption

Advance MVC Value

AdvMVCValue

Fixed Amount Percentage or No Advance

AdvNWCOption

Advance NWC Value

AdvNWCValue

Salary Type

AdvSalaryType

Use Fixed Calendar

AdvFixedCalendarOption

Medisave Deduct

AdvTaxDeduct


Entity Attribute Advance Report ID of the Entity AdvanceProcess

Card of Attribute Advance Report ID of the Entity AdvanceProcess

Name

Advance Report ID

Code

AdvReportId

Data Type

char(20)

Mandatory

Yes


Description of Attribute Advance Report ID of the Entity AdvanceProcess

Shows the identity for the advance report. A report ID serves 2 purposes: Storing parameters and Reporting payments made. Any change in the existing ID will results in previous data (for the report) being lost. It holds the primary key for the AdvanceProcess table.
Example: Adv Pay Report 01


Entity Attribute Description of the Entity AdvanceProcess

Card of Attribute Description of the Entity AdvanceProcess

Name

Description

Code

AdvDesc

Data Type

char(200)

Mandatory

No


Description of Attribute Description of the Entity AdvanceProcess

Shows the description for the advance pay.


Entity Attribute AdvPayRecYear of the Entity AdvanceProcess

Card of Attribute AdvPayRecYear of the Entity AdvanceProcess

Name

AdvPayRecYear

Code

AdvPayRecYear

Data Type

integer

Mandatory

No


Description of Attribute AdvPayRecYear of the Entity AdvanceProcess

Shows the year for the advance pay.
Example: 2012


Entity Attribute Advance Pay Rec Period of the Entity AdvanceProcess

Card of Attribute Advance Pay Rec Period of the Entity AdvanceProcess

Name

Advance Pay Rec Period

Code

AdvPayRecPeriod

Data Type

integer

Mandatory

No


Description of Attribute Advance Pay Rec Period of the Entity AdvanceProcess

Shows the period for the advance pay.
Example: January = "1", February = "2", March = "3" etc.


Entity Attribute Trial Run of the Entity AdvanceProcess

Card of Attribute Trial Run of the Entity AdvanceProcess

Name

Trial Run

Code

AdvTrialRun

Data Type

smallint

Mandatory

No


Description of Attribute Trial Run of the Entity AdvanceProcess

If this box is ticked, no advance pay records will be created. You can preview results using the Advance Report.


Entity Attribute To include for terminated employee in this Period of the Entity AdvanceProcess

Card of Attribute To include for terminated employee in this Period of the Entity AdvanceProcess

Name

To include for terminated employee in this Period

Code

AdvIncTerminated

Data Type

smallint

Mandatory

No


Description of Attribute To include for terminated employee in this Period of the Entity AdvanceProcess

Select this option to include employees whose cessation date falls within this pay period.


Entity Attribute To include for not confirmed employee in this Period of the Entity AdvanceProcess

Card of Attribute To include for not confirmed employee in this Period of the Entity AdvanceProcess

Name

To include for not confirmed employee in this Period

Code

AdvIncNotConfirmed

Data Type

smallint

Mandatory

No


Description of Attribute To include for not confirmed employee in this Period of the Entity AdvanceProcess

Select this option to include employees whose confirmation date is later than this pay period.


Entity Attribute To include for New Hire in this Period of the Entity AdvanceProcess

Card of Attribute To include for New Hire in this Period of the Entity AdvanceProcess

Name

To include for New Hire in this Period

Code

AdvIncNewHire

Data Type

smallint

Mandatory

No


Description of Attribute To include for New Hire in this Period of the Entity AdvanceProcess

Select this option to include employees whose hire date is within this pay period.


Entity Attribute CPF Deduction of the Entity AdvanceProcess

Card of Attribute CPF Deduction of the Entity AdvanceProcess

Name

CPF Deduction

Code

AdvFundDeduct

Data Type

smallint

Mandatory

No


Description of Attribute CPF Deduction of the Entity AdvanceProcess

Stores any fund deductions, such as CPF deductions etc.


Entity Attribute Fixed Amount or Percentage of the Entity AdvanceProcess

Card of Attribute Fixed Amount or Percentage of the Entity AdvanceProcess

Name

Fixed Amount or Percentage

Code

AdvBROption

Data Type

smallint

Mandatory

No


Description of Attribute Fixed Amount or Percentage of the Entity AdvanceProcess

Shows the basic rate option for the advance pay.
Example: Percentage / Fixed Amount


Entity Attribute Advance Basic Rate Value of the Entity AdvanceProcess

Card of Attribute Advance Basic Rate Value of the Entity AdvanceProcess

Name

Advance Basic Rate Value

Code

AdvBRValue

Data Type

double

Mandatory

No


Description of Attribute Advance Basic Rate Value of the Entity AdvanceProcess

Shows the basic rate value for the advance pay.


Entity Attribute Fixed Amount or Percentage or No Advance of the Entity AdvanceProcess

Card of Attribute Fixed Amount or Percentage or No Advance of the Entity AdvanceProcess

Name

Fixed Amount or Percentage or No Advance

Code

AdvMVCOption

Data Type

smallint

Mandatory

No


Description of Attribute Fixed Amount or Percentage or No Advance of the Entity AdvanceProcess

Shows the Monthly Variable Component option for the advance pay.
Example: Percentage / Fixed Amount / No Advance


Entity Attribute Advance MVC Value of the Entity AdvanceProcess

Card of Attribute Advance MVC Value of the Entity AdvanceProcess

Name

Advance MVC Value

Code

AdvMVCValue

Data Type

double

Mandatory

No


Description of Attribute Advance MVC Value of the Entity AdvanceProcess

Shows the Monthly Variable Component value for the advance pay.


Entity Attribute Fixed Amount Percentage or No Advance of the Entity AdvanceProcess

Card of Attribute Fixed Amount Percentage or No Advance of the Entity AdvanceProcess

Name

Fixed Amount Percentage or No Advance

Code

AdvNWCOption

Data Type

smallint

Mandatory

No


Description of Attribute Fixed Amount Percentage or No Advance of the Entity AdvanceProcess

Shows the National Wage Council option for the advance pay.
Example: Percentage / Fixed Amount / No Advance


Entity Attribute Advance NWC Value of the Entity AdvanceProcess

Card of Attribute Advance NWC Value of the Entity AdvanceProcess

Name

Advance NWC Value

Code

AdvNWCValue

Data Type

double

Mandatory

No


Description of Attribute Advance NWC Value of the Entity AdvanceProcess

Shows the National Wage Council value for the advance pay.


Entity Attribute Salary Type of the Entity AdvanceProcess

Card of Attribute Salary Type of the Entity AdvanceProcess

Name

Salary Type

Code

AdvSalaryType

Data Type

char(20)

Mandatory

No


Description of Attribute Salary Type of the Entity AdvanceProcess

Shows the type of salary received for the advance pay.
Example: Daily rated / Monthly rated / Hourly rated


Entity Attribute Use Fixed Calendar of the Entity AdvanceProcess

Card of Attribute Use Fixed Calendar of the Entity AdvanceProcess

Name

Use Fixed Calendar

Code

AdvFixedCalendarOption

Data Type

smallint

Mandatory

No


Description of Attribute Use Fixed Calendar of the Entity AdvanceProcess

Selecting this option will cause wages for Hourly and Daily rated employees to be calculated based on the fixed days in the employee's calendar.
If this option is un-selected, the working days will be calculated from the Work Pattern.
In either case, the hours per day is retrieved from the employee's pay details.


Entity Attribute Medisave Deduct of the Entity AdvanceProcess

Card of Attribute Medisave Deduct of the Entity AdvanceProcess

Name

Medisave Deduct

Code

AdvTaxDeduct

Data Type

smallint

Mandatory

No


Description of Attribute Medisave Deduct of the Entity AdvanceProcess

Shows the tax deduction for the advance pay.