Leave Provision Report {PLOPR1-10}

This report may be used to assist with determining the leave provision at the end of a specific month. It can only be run for specific months and the data will be calculated as at the last day of the month. The report will indicate how many days leave is due to a personnel member and what the financial implication is.

Note that leave applications entered through the Personnel iEnabler will not be taken into account, unless they are Copied into Leave Records {PLOP-8}.

General information (delete if not applicable).

Negative balances will be indicated with a "-" sign.

The rules for the calculation of the monetary values related to the selling of leave or the leave component of severance packages are explained in Monetary Value of Leave Days Sold.

User Selection	Prompt Text ^{* an item between square brackets [ ] is the default answer}	Type & Length	Comments
1	Enter Report Cycle	YYYYMM	The calendar month for which the report is run
2	Enter Leave Type	A3	This must be a valid Leave type as defined on {PLCS-2}, Use the list of values to select the correct value.
3	Generate (S)ummary Report, (D)etailed Report or Comma delimited (F)ile	A1	The (S)ummary Report does not print the following values used in the calculation process Leave Debits Leave Credits Prorated Credits Prorated Debits Prorated Entitlement Total Entitlement Total Leave Taken

Sort Order	Per	Comments
1	Leave type and Personnel Number

System Select

All Leave Records {PLOP-1} for the Leave Type.

Balance B/F

Balance of leave at the last credit calculation before the end (last day) of the Report Cycle

Leave Debits

Total of the Leave Debit Records between the last credit calculation date (before the end of the Report Cycle) and the Report Cycle, i.e.

The credit/debit indicator is (S)old or (D)ebit
The comments fields does not reflect a system generated record
The end date of leave record is after than last credit calculation date (before the end of the Report Cycle).
The end date of leave record is before the last day of the month corresponding to the Report Cycle

Leave Credits

Total of the Leave Credit Records between the last credit calculation date (before the end of the Report Cycle) and the report cycle, i.e.

The credit/debit indicator is (C)redit or C(A)ncelled
The comments field does not reflect system generated record
The end date of leave record is after the last credit calculation date (before the end of the Report Cycle)
The end date of the leave record is before the last day of the month corresponding to the Report Cycle

Prorated Leave Credits

This is a pro-ration of manually entered leave credits where the last day of the month corresponding to the Report Cycle is between the Start Date and the End Date of the Leave Record, i.e.

The credit/debit indicator is (C)redit or C(A)ncelled
The comments field does not reflect system generated record
The start date of leave is before the last day of the month corresponding to the Report Cycle
The end date of leave is on or after the last day of the month corresponding to the Report Cycle

Pro-ration for the leave type is based on working or calendar days as specified in the Leave Package Structure {PLCS-3}

Prorated Leave Debits

This is a pro-ration of manually entered leave debits where the last day of the month corresponding to the Report Cycle is between the Start Date and the End Date of the Leave Record, i.e.

The credit/debit indicator is (D)ebit or (S)old
The comments field does not reflect system generated record
The start date of leave is before the last day of the month corresponding to the Report Cycle
The end date of leave is on or after the last day of the month corresponding to the Report Cycle

Pro-ration for the leave type is based on working or calendar days as specified in the Leave Package Structure {PLCS-3}

Prorated Leave Entitlement

Leave Credit Earned between the last credit calculation before the end of the Report Cycle and the last day of the month corresponding to the Report Cycle.is calculated as the product of:

The number of leave days due per leave cycle is the "Leave Days Allowed" divided by the "Term" for the Leave Type and Package of the Person as indicated in the Leave Package Structure {PLCS-3}
The number of leave cycles since the last credit calculation before the end of the Report Cycle..

For example:

Prorated leave entitlement	=	Leave days due per cycle * Number of cycles passed
	=	(Leave Days Allowed / Term) * Number of cycles passed

Total entitlement

The sum of Balance B/F, Leave Credits and the Prorated Leave Entitlement as explained above

Total Leave Taken is the sum of Leave Debits and Prorated Leave Debits as explained above

Provision is the difference between Total Entitlement and Total Leave Taken.

Example Summary Report:

Example Detail Report:

16-FEB-2012                                          ITS Integrator                                     PAGE :    1
PROGRAM: placcc.pc v01.0.0.4
                                                   Leave Provision Report
                                                     End Cycle : 201201
                                              Leave Type : 001 - NORMAL LEAVE

Last Credit Personnel Name                           Balance Provision Selling Severance
Calc Date   Number                                   B/F               Value   Value

-------------------------------------------------------------------------------------------------------------------
31-OCT-2009 1         J.G. Patterson                    4.50
                                      Leave Debits :    0.00
                                     Leave Credits :    0.00
                                  Prorated Credits :    1.50
                                   Prorated Debits :    0.00
                              Prorated Entitlement :    1.50
                                 Total Entitlement :    1.50
                                 Total Leave Taken :    1.50    6.00   1345.00   1521.00
31-JUL-2009 20        M Van Den Berg                    2.50
                                      Leave Debits :    0.00
                                     Leave Credits :    0.00
                                  Prorated Credits :    0.00
                                   Prorated Debits :    0.00
                              Prorated Entitlement :    0.00
                                 Total Entitlement :    2.50
                                 Total Leave Taken :    0.00    2.50    624.00    645.00

Totals                                                                 1969.00   2166.00

                                                       ***End Of Report***

Processing Rules
	No special processing rules.

Date	System Version	By Whom	Job	Description
21-Jul-2009	v01.0.0.0	Allie	T158418	New manual format.
13-Aug-2009	v01.0.0.2	Precious	T160324	Add logic on how values on report are calculated.
16-Feb-2012	v02.0.0.0	Frans	T180782	Layout for Summary Report
28-May-2012	v03.0.0.0	Frans Pelser	T181123	Link to Selling of Leave