Leave Credit Calculation {PLOP-2}


This program does leave credit calculations.  A detailed control report is generated during the calculation.

Prerequisites to use this option:

General information

This option would normally be executed just after the beginning of a month, when all credits earned during the previous month or credits for the following month will be created, depending on whether crediting is done in arrears or in advance. 
It may be executed at any time, without any danger of credits being duplicated. 
The leave credits calculated may be queried in the Leave Records {PLOP-1}. Leave credit calculation records can be recognized with “* LEAVE EARNED IN ARREARS *” or “* LEAVE EARNED IN ADVANCE *” in the "Comment" field.
The program will also calculate credit in arrears for resigned personnel who were in service for the period of the leave calculation. (depending on the Calculation Method).

User Selection Prompt Text
* an item between square brackets [ ] is the default answer
Type
&
Length
Comments
1 Start Date for Credit Calculation. DD-MON-YYYY This date can only be captured once, when the leave calculation is run for the very first time.  Thereafter, this will be a display field. This date is used to determine from what date the leave credit calculation must be calculated for the first time that a leave calculation is done. 
2 Last Credit Calculation Date. DD-MON-YYYY This is a display field only.
3 Must the Report be sorted (A)lphabetically or (N)umerically? A1  
4 Enter Leave Package to be Used or (ALL)  (A3) Only valid Leave Packages or ALL
5 Enter Leave Type to be Used or (ALL)  (A4) Only valid Leave Types or ALL
6 Enter the 1st of 10 Employee Numbers or ALL. N9 Only valid employee numbers or ALL.
7 Is this a (T)est or (U)pdate Run? A1 Only T or U is valid.
 

Sort Order Per Comments
1 Personnel Number, or Surname and Initials. See user selection


System Select  
1 All personnel with a biographical record and a valid service record.  


Example
:

plop-2p1.jpg

plop-2p2.jpg




Processing Rules  
1 A list of personnel members will be generated for every person with a Service Record {PBOP-2} that contains a valid leave package and where the Start Date for credit calculation is on or after the Start Date of the Service Record and before the End Date of the Service Record (or where the Service Record does not have an End Date) or where leave is calculated in arrears and the personnel member is no longer in service.
2 Leave Structure breaks for a single person with multiple Service Records are determined by a change in Leave Package or breaks between Service Records of more than 1 day.
3 For each person, all the Leave Types linked to the Leave Package in the Service Record are used.
4 The previous leave calculation date for each person / leave type is determined from the highest of the "Start Date for Credit Calculation" as in the User Selection Parameters, and the last (highest) End Date of a Leave Record {PLOP-1} of the particular leave type for the person where the Remark starts with the word “* CREATION”, “* LEAVE”, “* BALANCE” or “BALANCE”. 
5 For each person / leave type, the information in the Leave Package Structure {PLCS-3} is used to calculate the number of leave days to be credited.
6 Note that, although the program may pro-rate leave for new appointments and resignations, it was not developed to pro-rated leave in the case where the leave package for an employee changes in the middle of a month.
If a personnel member is promoted in the middle of a month (or, the a new service record with a different leave package with a start date other than the first of the month is created), leave balances should be verified and corrected manually if required.
Calculation Methods  
1 - Monthly (1st of month)
  1. If no leave credit calculation records exist for the person being processed and the person’s appointment day is not the first of the month:
  • If the field "Leave Entitlement for Incomplete Service Period" in the Leave Package Structure {PLCS-3} is set to “N” – No Leave Entitlement:  
    • Leave will only be calculated from the next month onwards, for both leave in arrears (Field "Term" in the Leave Package Structure {PLCS-3} has a positive value) and in advance ("Term" has a negative value).
  • If the field "Leave Entitlement for Incomplete Service Period" is set to “Y” – Pro-rate Leave Entitlement:
      • For leave in advance, leave will be pro-rated for the last part of the first month, in the first month and then credited for full months thereafter.
      • For leave in arrears, leave will be pro-rated for the last part of the first month, but only in the next month, and then credited for full months thereafter.
  • If the field "Leave Entitlement for Incomplete Service Period” is set to “F” – Full Leave Entitlement):
      • For leave in advance, the full leave allocation will be credited in the first month and thereafter for subsequent months.
      • For leave in arrears, the full leave allocation will be credited for the first month in the following month and thereafter for subsequent months.
2. If no leave credit calculation records exist for the person being processed and the person’s appointment day is the first of the month.
        • If the field "Pro-Rated" is set to “N” – No Leave Entitlement
          • For leave in arrears, leave will be credited monthly in arrears from appointment date.
          • For leave in advance, leave will be credited monthly in advance from appointment date.
        • If the field "Pro-Rated" is set to “Y” – Pro-rate Leave Entitlement:
          • For leave in advance, leave will be calculated in the first month.
          • For leave in arrears, leave for first month will be calculated in the next month only.
        • If the field "Leave Entitlement for Incomplete Service Period” is set to “F” – Full Leave Entitlement):
          • For leave in advance, the full leave allocation will be credited in the first month and thereafter for subsequent months.
          • For leave in arrears, the full leave allocation will be credited for the first month in the following month and thereafter for subsequent months.
3. If history leave credit calculation records already exist, leave will be calculated from the latest leave record’s end date forward.
2 - Monthly (Appointment Day)
  1. If no leave credit calculation records exist for the person being processed, calculate leave as from the person’s appointment date.
  2. If past leave credit calculation records exist, leave will be calculated from latest leave record’s end date onwards.
  3. Pro-rating is not applicable to this calculation method.
  4. Leave will be calculated from the person’s appointment day per month.
  5. For Leave in arrears (Field "Term" in the Leave Package Structure {PLCS-3} has a positive value), the current month’s leave will only be calculated in the next month.
  6. For Leave in advance ("Term" has a negative value), the current month’s leave will be calculated in the current month.
3 - Yearly (January 1st)
  1. If no leave credit calculation records exist for the person being processed, calculate leave as from the person’s appointment date.
  2. If past leave credit calculation records exist, leave will be calculated from latest leave record’s end date onwards.
  3. If the field "Leave Entitlement for Incomplete Service Periods”  is “Y’’ – Pro-rate Leave Entitlement and Cycle Start Date in the Leave Package Structure {PLCS-3} has a value, leave will be pro-rated from the Cycle Start Date onwards, even in the first year of appointment.
  4. If the field "Leave Entitlement for Incomplete Service Periods”  in the Leave Package Structure {PLCS-3} is set to “N” – No Leave Entitlement, leave will be calculated in the second year of appointment for personnel appointed after 1 January of the year.
     5.   If the field "Leave Entitlement for Incomplete Service Periods”  is “F’’ – Full Leave Entitlement and Cycle Start Date in the Leave                 Package Structure {PLCS-3} has a value, the full leave allocation will be calculated from the Cycle Start Date onwards, even in the               first year of appointment
     6. For leave in arrears (Field "Term" in the Leave Package Structure {PLCS-3} has a positive value), the value for a year will only be calculated            the following year, i.e. leave for 2009 will only be calculated in 2010.
     7. For leave in advance (Field "Term" has a negative value), the value for the current year will be calculated in the current year, i.e.  leave for                2009 will be calculated in 2009.

4 - Yearly (Appointment Day)
  1. If leave is calculated in advance, leave will be calculated in first year of appointment as well.
  2. If leave is calculated in arrears, leave for the first year will only be calculated in second year of appointment.
  3. No pro-rate indicator functionality exists here. 
5 - Calc Leave for Hourly Paid Personnel
  1. The calculation will only be done if the new validation "HL - Hourly Paid Personnel Leave Credits" in the Validation Control {GOPS-22} is set to (Y)es.
  2. Only personnel with a Secondary Appointment {PAOP-2}, where the Appointment Type {PACS-1} that is linked to the Service Record {PBOP-2} has (T)emporary in the Equity Status - field will be included for leave calculations.
  3. Leave will be calculated in arrears, using salary claims that were included in salary calculations (i.e. has a record in the salary transactions file) for all payroll cycles since the previous leave credit calculation.
  4. Only payroll cycles before the current cycle as indicated by the C-Record in the Run Cycle Control File {FPRM-2} will be included.
  5. Only claims generated using Copy Claims to the Payroll System {FPRIC-3} or {FPRCPC-3} will be included.
  6. Calculate the total amount paid out for claims to be included in the calculation for the leave credit. The system will add one month to the last leave calculation date and use the year and month to create a new cycle (YYYYMM) and select all transactions in the salary transaction file where the payroll cycle of the transactions is greater than equal to the new cycle and the reference field contains a description or part of the description "A / CLAIM".
  7. Once the transactions are selected, the first four characters of the reference field represent the post on the secondary contract and this information is used to select the correct secondary contract and the Maximum Amount Allocated and Hours.    
  8. An "Hourly Rate" will be calculated by dividing the Maximum Amount Allocated by the Hours on the specific secondary appointment for which a claim exists. See the Secondary Appointment {PAOP-2} for more detail.
  9. The Hours Worked will be calculated by adding all the claims selected above and dividing the total amount claimed by the Hourly Rate calculated above.
  10. To calculate the leave credit, the Hours Worked  and the new fields on the Leave Package Structure {PLCS-3} will be used as follows:
    1. The Hours worked per leave type Determines how many hours a person should work to be entitled to the number of hours credited per Leave Type.
    2. The Number of Hours to be Credited is calculated as follows:
      1. Divide the Hours worked (calculated above) by the hours worked per leave type and multiply the result with the Hours Credit per leave type.
        Formula: Number of hours to be Credited = Hours worked / hours worked per leave type * Hours Credit per Leave type.  
    3. To calculate the Actual Leave credit, the Number of Hours to be credited is converted to days using Number of Hours per Leave Type per Day.  Formula: Actual Leave credit = Number of Hours to be Credited / Number of hours per leave type per day.


See Also:

History of Changes

Date System Version By Whom Job Description
05-Feb-2007 v01.0.0.0 Allie de Nysschen t123902 New manual format and leave calculation in arrears for resigned personnel.
30-May-2007 v01.0.0.0 Frans Pelser t117451 Leave for Hourly Paid Personnel.
15-Aug-2007 v01.0.0.0 Allie de Nysschen t117453 Correct Manuals.
16-Oct-2008 v01.0.0.0 Magda van der Westhuizen t151711 Update manual:  Language Editing:  Juliet Gillies.
22-Jun-2012 v03.0.0.0 Frans Pelser t178590 Improve description for hourly paid
21-Apr-2020 v04.1.0.0 Nomhle Lubisi t243398 Updated by adding the leave package and leave type batch prompts
22-apr-2021 v04.1.0.1 Kerrylee Naidoo t249262 Enhancement to leave entitlement