Reporting Leave Liability and Absence History

This topic provides an overview of leave liability and absence history.

Page Name

Definition Name

Usage

Leave Liability SGP Page

GPSG_RC_LVELIAB

Specify the population of employees you want to report the leave liability for. You can specify an as of date and you can report by element category.

Leave History SGP Page

GPSG_RC_ABS_HIST

Specify the population of employees you want to report the history of. You can specify an absence type and the period to be reported. You can set up to 3 sort orders.

The data that the report process extracts for leave liability reporting can be transferred to the general ledger through the GLI.

The reports and the interface depend upon data that is created the same way as any other data that's used for reports, the GLI—by the use of Global Payroll rules.

Note: In this topic, unless otherwise stated, reported means printed on a report and available for transfer to GLI.

Liability and absence history are calculated and reported to assist in the administration of employee absences and leave. They are used to identify trends in absence and for costing purposes.

Liability is reported for annual leave accrued in days. The values are calculated as earning LIAB ANN DYS. This earning does not contribute to accumulator SGP GROSS.

When you run the liability report, the parameters include the element category. Earning LIAB ANN DYS is category ANN. The category value is assigned as a variable entered as a supporting element override for each earning.

Note: The term pro rata refers to accrued leave that the payee may or may not be entitled to take. Pro rata becomes entitlement on an anniversary, usually of the payee's hire date. Entitlement refers to leave that the payee is entitled to take and that may have previously been pro rata leave. We make this distinction in this documentation because both entitlement and pro rata (as we have just defined them) are called entitlement in the system.

The calculation rule for LIAB ANN DYS is Unit × Rate where:

Unit = Accumulator ANN GENL ENT_BAL
Rate = DAILY RT

Leave liabilities are to be calculated at the end of each month for active employees, or when an employee terminates. Generation control GLI GC LIAB checks this by using the following formulas:

  • CMN FM MTH END — Checks that it is the last segment of the last pay for the month, and the employee is active.

  • TER FM TERM CHECK — Checks if the employee is terminating in this pay.

  • GLI FM LST PRD/SEG — Checks if it's the last segment of the month.

  • CMN FM TERM STAT — Checks whether the employee is currently terminating (their termination date is in this segment, or in the past and was entered in the current period). The termination leave liabilities are to be calculated only when an employee terminates, so that they reverse any remaining liabilities in the GL.

LIAB ANN DYS contributes to the LIAB ANN DYS_FPTDA accumulator.

The calculation rule for LIAB TER HRS is Amount where:

Amount = Earnings LIAB ANN DYS

Generation control CMN GC TERM STAT checks for terminated employees only using formula CMN FM TERM STAT. Formula CMN FM TERM STAT checks whether the employee is currently terminating (their termination date is in this segment, or in the past and was entered in the current period). The termination leave liabilities are to be calculated only when an employee terminates, so that they reverse any remaining liabilities in the GL. There is no proration.

LIAB TER DYS contributes to the LIAB TER DYS_FPTDA accumulator.

The calculation rule for SAL ACCRUAL is Base × Percentage where:

Base = Accumulator SGP GROSS
Percentage = Variable GLI VR ACCRUAL PCT

Variable GLI VR ACCRUAL PCT enables you to enter the percentage to be accrued. You add the variable as a calendar supporting element override on the last calendar for the month so the variable's override levels should be set to pay calendar. The value of the variable varies according to the gap between the end of the pay period and the end of the financial period. You enter the value on the Pay Calendar SOVR's page as it will depend on the number of days between the end of the pay period and the end of the month. So, the Override Level for Pay Calendar should be ticked.

Accruals need to be calculated only in the last segment of each month and only for active employees. Generation control GLI GC ACCRUAL therefore includes the formula GLI FM LST PRD/SEG which returns a value that determines whether to pay the SAL ACCRUAL earning.

SAL ACCRUAL contributes to the SAL ACCRUAL_FPTDA accumulator.

The calculation rule for GST is Base × Percent where:

Base = Accumulator SGP GST
Percentage = Variable GST VR PCT

The SGP GST accumulator accumulates earnings and deductions that are subject to GST. Members include MEAL and TRANSPORT earnings.

You use variable GST VR PCT to enter the percentage to be calculated for GST. The same percentage will be used across the company, so the value will be entered on the Pay Entity SOVR's page. The Override Level for Pay Entity should be ticked.

Generation control GLI GC ACCRUAL, using formula GLI FM LST PRD/SEG checks the last segment of each month and only for active employees.

GST contributes to the GST_FPTDA accumulator.

The calculation rule for BON ACCRUAL is Base × Percent where:

Base = Accumulator SGP GROSS
Percentage = Variable BON VR ACCRUAL PCT

You use variable BON VR ACCRUAL PCT to enter the percentage to be accrued for bonus. The same percentage will be used across the company, so the value will be entered on the Pay Entity SOVR's page. The Override Level for Pay Entity should be ticked.

Accruals need to be calculated only in the last segment of each month and only for active employees. Generation control GLI GC ACCRUAL therefore includes the formula GLI FM LST PRD/SEG which returns a value that determines whether to pay the BON ACCRUAL earning.

BON ACCRUAL contributes to the BON ACCRUAL_FPTDA accumulator.

The calculation rule for BONUS ACCRL is Base × Percent where:

Base = Accumulator SGP GROSS
Percent = Variable BON VR NON-ACC PCT

You use variable BON VR NON-ACC PCT to enter the non-contractual bonus accrual percentage. The same percentage will be used across the company, so the value will be entered on the Pay Entity SOVR's page. The Override Level for Pay Entity should be ticked.

Accruals need to be calculated only in the last segment of each month and only for active employees. Generation control GLI GC ACCRUAL therefore includes the formula CMN FM LST PRD/SEG which returns a value that determines whether to pay the BONUS ACCRL earning.

BONUS ACCRL contributes to the BONUS ACCRL_FPTDA accumulator.

The leave entitlements Application Engine program checks to see if there is a change of chartfield for each employee—where chartfields represent cost centres such as department and pay group. When the program detects a change, it reverses the liability from the centre storing the processed liability and sends the full amount of the new (unprocessed) liability (not the difference) to the new cost centre.