Additional Info Regarding GL Interface (BORIF01) & Benefits Encumbrance Projection Interface (BORIF15)
Posted May 30, 2002.
Additional Information Regarding the Changes Made to the Payroll GL Interface (BORIF01) and the Benefits Encumbrance Projection Interface (BORIF15) in HRMS Release 2.09:
With the rollout of PeopleSoft Financials came the following issues:
- The legacy CUFA system zeroed all encumbrances prior to applying the transactions from the HRMS Benefit Encumbrance Projection interface. This took care of the previous projection for terminated or moved employees that were in an account number that was no longer used. The PeopleSoft Financials implementation did not execute this step so there can be extraneous encumbrances that need to manually zeroed using an Encumbrance Journal entry in Financials.
- Over and under projection of FICA for those employees who reach the FICA max. The HRMS Benefit Encumbrance Projection Interface did not address this issue.
- Projects and grants that ended prior to the fiscal year end on June 30th were over-projected. The HRMS system has no indicator for a project or grant end date so there was no way to detect this situation.
- Normally only one Account Number is used for FICA Medicare meaning that it would always be in the HRMS GL Encumb Object Codes table. The HRMS Payroll GL Accounting Interface always liquidated this tax expense regardless of the pay group.
Changes to resolve these issues are being delivered to either HRMS or PSFIN, whichever applicable, in three phases. Phase I of the changes to HRMS were delivered in Release 2.09. These changes are the solution to Issue #4.
The release notes for Release 2.09 state that BORIF01 and BORIF15 were modified to be consistent in liquidating and projecting encumbrances for earnings, taxes, and deductions across pay groups and earn codes. These modifications are detailed below (Phase 1):
Phase 1 BORIF01 - Payroll GL Interface
The sqr was modified to do encumbrance liquidation for those Account Numbers found in the GL Encumb Object Codes table as follows:
Earnings Expenses:
- Pay Group B06 - 100% liquidated for earn codes HOL, HOU, JUR, MIL, REG, SCK, and VAC.
- Pay Group M01 and M03 - 100 % liquidated for earn codes MLM, JRM, HOU, REG, and SUB.
- Pay Groups B07, B08, BFX, M04, MEX, MFX, RET, RTB, RTM, and SUM have no liquidation for any earn codes.
Deduction Expenses:
- Pay Groups B06, M01, and M03 have 100% liquidated if the Account Number is in the GL Encumb Object Codes table.
- Pay Groups B07, B08, M04, MEX, MFX, RET, RTB, RTM, and SUM have no liquidation for any deduction expenses.
Tax Expenses:
- Pay Groups B06, M01, and M03 have 100% of FICA and FICA Medicare liquidated if the account code is in the GL ENCUMB Object Codes table for earn codes REG, SUB, VAC, SCK, HOL, JUR, and FML. Note: The FICA and FICA Medicare are split among the different earnings chart field strings based on a percentage calculation of earnings per earn code / total earnings.
- Pay Groups B07, B08, M04, MEX, MFX, RET, RTB, RTM, and SUM have no liquidation for any deduction expenses.
Phase 1 BORIF15 - Benefits Encumbrance Projection Interface
The sqr was modified to do encumbrance projection for those Account Numbers found in the GL Encumb Object Codes table as follows:
Earnings Expenses:
- Pay Group B06 - projected for earn codes HOL, HOU, JUR, MIL, REG, SCK, and VAC.
- Pay Group M01 and M03 - projected for earn codes MLM, JRM, HOU, REG, and SUB.
- Pay Groups B07, B08, BFX, M04, MEX, MFX, RET, RTB, RTM, and SUM have no projection for any earn codes.
Deduction Expenses:
- Pay Groups B06, M01, and M03 are projected if the Account Number is in the GL Encumb Object Codes table.
- Pay Groups B07, B08, M04, MEX, MFX, RET, RTB, RTM, and SUM have no projection for any deduction expenses.
Tax Expenses:
- Pay Groups B06, M01, and M03 have of FICA and FICA Medicare projected if the account code is in the GL ENCUMB Object Codes table for earn codes REG, SUB, VAC, SCK, HOL, JUR, and FML. Note: The FICA and FICA Medicare are split among the different earnings chart field strings based on a percentage calculation of earnings per earn code / total earnings.
- Pay Groups B07, B08, M04, MEX, MFX, RET, RTB, RTM, and SUM have no projection for any deduction expenses
The following modifications are being delivered in future releases. The specific release has not yet been determined. When the modifications are made, the release notes will reference these changes.
Phase II modifications to HRMS:
Modify BORIF15 to send the number of pay periods left used in calculating the encumbrance projection for chart field strings that contain a project or a grant.
Phase III modifications to HRMS:
Modify BORIF15 to correctly project FICA for those employees who have reached the max for the calendar year.
If you have any questions, please contact OIIT Customer Services at 1-888-875-3697 or HelpDesk@usg.EDU.