Oracle Payroll delivers predefined elements and formulas for sick pay processing including RetroPay. You can use the secondary classifications that have been provided for sickness balances. The following table describes the predefined elements and formulas:
| Element Name | Description |
| FR_SICKNESS_INFORMATION | This is a recurring absence element and has these formulas associated with it - FR_SICKNESS_SKIP (skip formula), FR_SICKNESS_ITERATE (iterative formula), and FR_SICKNESS_PROCESSING (payroll formula) |
| FR_SICKNESS_DEDUCTION | This earnings adjustment element holds the deduction from gross for the absence. Uses indirect result from the FR_SICKNESS_PROCESSING formula. |
| FR_SICKNESS_DEDUCTION_RETRO | Retro element for Sickness Deduction that is processed once each period in the standard run type. The inputs are as for FR_SICKNESS_DEDUCTION but are mandatory so they are automatically populated on the retro entries. |
| FR_SICKNESS_ADJUSTMENT | Earnings element holds an adjustment to gross which is introduced when a net to gross calculation is required. The iterative formula modifies this Pay value until the desired net is achieved. |
| FR_SICKNESS_ADJUSTMENT_RETRO | Retro element for Sickness Adjustment that is processed once each period in the standard run type. The inputs are as for FR_SICKNESS_ADJUSTMENT. |
| FR_SICKNESS_INSURANCE_PAYMENT_SUBJECT | Earning element holds the component from third party insurance payment that is subject to deductions (indirect result from FR_INSURANCE_PROCESSING formula). |
| FR_SICKNESS_INSURANCE_PAYMENT_SUBJECT_RETRO | Retro element for Sickness Insurance Payment Subject that is processed once each period in the standard run type after earnings before deductions processing. The inputs are as for FR_SICKNESS_INSURANCE_PAYMENT_SUBJECT. |
| FR_SICKNESS_INSURANCE_PAYMENT_EXEMPT | Net payment element holds the third party insurance payment component that is exempt from deductions (indirect result from FR_INSURANCE_PROCESSING formula) |
| FR_SICKNESS_INSURANCE_PAYMENT_EXEMPT_RETRO | Retro element for Sickness Insurance Payment that is processed once each period in the standard run type after earnings before deductions processing. The inputs are as for FR_SICKNESS_INSURANCE_PAYMENT_EXEMPT. |
| FR_SICKNESS_INSURANCE_PAYMENT_REDUCTION | Net payment element - is included only if the employee receives payment directly from insurer (indirect result from FR_INSURANCE_PROCESSING formula) |
| FR_SICKNESS_INSURANCE_REDUCTION_RETRO | Retro element for Sickness Insurance Reduction that is processed once each period in the standard run type after earnings before deductions processing. The inputs are as for FR_SICKNESS_INSURANCE_REDUCTION |
| FR_IJSS_CPAM_PAYMENT | Information element for social security payment made by the social security office. |
| FR_IJSS_GROSS | This reduction element holds the gross component for the social security benefit payment. Gross IJSS to deduct from the guaranteed income. |
| FR_IJSS_GROSS_RETRO | Retro element for IJSS Gross that is processed once each period in the standard run type. The inputs are as for the FR_IJSS_GROSS elements. |
| FR_IJSS_GROSS_ADJUSTMENT | Element used to adjust gross IJSS if the most beneficial agreement changes over the duration of the absence. |
| FR_IJSS_NET | Information element that holds the net component for the social security payment. If subrogation is 'No' while recording absence details, FR_IJSS_NET run results are created to hold information about the IJSS net. Uses the indirect result from FR_SICKNESS_PROCESSING formula. |
| FR_IJSS_NET_RETRO | Retro element for IJSS Net that is processed once each period in the standard run type. The inputs are as for the FR_IJSS_NET element. |
| FR_IJSS_NET_PAYMENT | Net payment element for social security payment. IJSS Net actually paid when payment is subrogated. Uses the indirect result from FR_SICKNESS_PROCESSING formula. |
| FR_IJSS_NET_PAYMENT_RETRO | Retro element for IJSS Net Payment that is processed once each period in the standard run type. The inputs are as for the FR_IJSS_NET_PAYMENT element. |
| FR_SICKNESS_INSURANCE | Information element contains information for third party insurance payment. |
| FR_SICKNESS_INSURANCE_ADJUSTMENT | Earnings element used to adjust Gross Insurance. |
| FR_SICKNESS_INSURANCE_ADJUSTMENT_RETRO | Retro element for Sickness Insurance Adjustment that is processed once each period in the standard run type after earnings before deductions processing. The inputs are as for the FR_SICKNESS_INSURANCE_ADJUSTMENT element. |
| FR_SICKNESS_INSURANCE_GROSS | Reduction element that holds the gross component for the third party insurance payment |
| FR_SICKNESS_INSURANCE_NET | Information element for the net component of the third party insurance payment. |
| FR_SICKNESS_INSURANCE_PAYMENT | Net payment element for the third party insurance payment. This holds payment, employee percentage and recipient information from third party insurer. Third party insurance is entered in current period when payment is received for an absence. Uses the FR_INSURANCE_PROCESSING formula. |
| FR_SICKNESS_INSURANCE_PAYMENT_RETRO | Retro element for Sickness Insurance Payment that is processed once each period in the standard run type after earnings before deductions processing. The inputs are as for the FR_SICKNESS_INSURANCE_PAYMENT element. |
| FR_SICK_BENEFIT | Information element for the collective agreement benefit. This element is entered for the same date effective dates as the absence and holds the rules guarantee. For example, Net Guarantee with 0 delay - first 30 days paid at 100%, next 20 at 60%. Uses the FR_SICK_BENEFIT formula. |
| FR_GI_PAYMENT | Net payment element for the Sickness Guaranteed Income payment. |
| FR_GI_PAYMENT_RETRO | Retro element for Sickness Guarantee that is processed once each period in the standard run type. The element inputs are as for the FR_GI_PAYMENT elements but are mandatory ensuring that they are populated on the retro entries. |
| FR_SICKNESS_GI_INFORMATION | Non-Recurring information element for each income guarantee covering the sickness absence. |
| FR_SICKNESS_CPAM_INFO | Information element for details of IJSS payment made by CPAM. |
| FR_SICKNESS_CPAM_PROCESS | This element with a classification of CPAM Process Information holds details of the absence dates and the IJSS payment made by CPAM. Triggers the processing of the matching sickness absence. |
| Formula | Usage |
| FR_SICK_DEDUCT_WORKING_DAY_FORMULA | Used in calculating sickness deduction as per working days proration method |
| FR_SICK_DEDUCT_OPEN_DAY_FORMULA | Used in calculating sickness deduction as per open days proration method |
| FR_SICKNESS_SKIP | Skip formula for the element FR_SICKNESS_INFORMATION. This is responsible for deciding if the FR_SICKNESS_INFORMATION is processed |
| FR_SICKNESS_CONTROL | Iterative formula for sickness processing element FR_SICKNESS_INFORMATION |
| FR_SICKNESS_PROCESSING | Payroll formula for sickness processing element FR_SICKNESS_ELEMENT |
| FR_SICKNESS_AUDIT | Payroll formula for the audit element for sickness process. FR_GI_INFORMATION element uses this formula to create audit elements for each guarantee that cover the absence |
| FR_INSURANCE_PROCESSING | Used in calculating all direct values held by the sickness adjustment element |
| FR_INSURANCE_CONTROL | Formula for controlling processing of Sickness Insurance Payments |
| FR_SICKNESS_CPAM_CONTROL | Formula for controlling processing of CPAM payment |
Oracle Payroll provides predefined secondary classifications to process your sick pay. In the Balance Feed Control window, select the predefined sickness secondary classifications--Sickness Deduction Reference Salary, Sickness IJSS Reference Salary and Sickness Legal Guarantee Reference Salary--for the elements in the following primary classifications:
Earnings
Benefits
Earnings Adjustments
Supplementary Earnings
Reductions
Overtime
Note: If you do not want the element to feed these balances, which are used in sickness calculation, delete the classification rules which will remove the balance feeds.
If you are creating any balances as required by your collective agreements, and setting up the feeds for these balances you need to associate the ASG_PRO_RUN dimension with these balances. Oracle Payroll uses this dimension in sick pay calculation.