- Home
- About OUS
- OUS Vision and Goals
- Chancellor's Office
- Campuses & Centers
- Diversity & Community Engagement
- Doing Business with OUS
- Employment Opportunities
- Policies & Procedures
- University Presidents
- Provosts' Council
- Research & Innovation
- Records Management
- Senate Bill 242
- American Recovery & Reinvestment Act
- OUS/SEIU Classified Staff Negotiations
- Departments
- Academic Strategies
- Board's Office
- Budget Operations
- Capital and Facilities Planning
- Chancellor
- College Access Programs
- Communications
- Contracts and Purchasing
- Controller's Division
- Finance & Administration
- Government Relations
- Human Resources
- Industry Partnerships
- Institutional Research
- Internal Audit
- Legal Counsel
- Student Success Initiatives
- Risk Management
- State Board of Higher Education
- Students and Counselors
- Campuses & Centers
- Counselor Resources
- Prospective Students
- Transfer Students
- Facts and Reports
- Alignment and Partnerships
- Contact Us
Payroll Processing Parameters
[1] PDPLIFE - This is the Banner "Life Insurance Calculation Process". It is run once each month prior to the beginning of the payroll process.
[2] PHPTIME - This is the Banner "Time Extraction Process". It is the baseline process that creates electronic timesheets, including default hours and labor distributions. The records created by this process are viewed in PHAHOUR. Once this process is run, NBAJOBS and PDADEDN are frozen, and no changes can be made through these forms unless the employee record is re-extracted.
[3] PHRDCON - This is the Banner baseline "Disposition Control Report" that lists each employee in the payroll process by disposition. This report is run several times throughout the payroll process. PHPTIME should be run in 'Re-Extract' mode, as many times as necessary, until all employees are at disposition 10 or greater.
[4] PHRDERR - This is the Banner baseline "Payroll Errors Display Report" that lists errors encountered during payroll processing. This report is run several times throughout the payroll process.
[5] Time Entry - Manual time entry in PHAHOUR for hourly employees.
[6] PHPMTIM - This is the Banner baseline "Mass Time Entry" process. Not all institutions use this process, but it is included on the checklist for those who do.
[7] PWPPDEL - This is an OUS process that deletes disposition 10 records from payroll history tables. A listing of the disposition count is printed before and after the deletion, if any occurs.
[8] PHPPROF - This is the Banner baseline "Pay Period Proof Batch Module" that validates time entered in PHAHOUR. It moves the records, assuming all errors are corrected, to disposition 25.
[9] PHPLEAV - This is the Banner baseline "Leave Accruals and Taken Process" that accrues and takes leaves based on leave categories and values on PHAHOUR and PEAEMPL. This process moves records to disposition 29 (The baseline version of this process moves records to disposition 30. A slight modification was made to this process by OUS so that records move to disposition 29 in order to accommodate PWPCBNC).
A/A>[10] PWPCBNC - This is an OUS process that calculates HMO and Rural subsidies, prorates part-time employee contributions, calculates a minimum guaranteed amount for part-time employees, and calculates cash back. Employee class codes, hours worked in a month, and deduction codes are used to determine eligibility and amounts.
[11] PHPCALC - This is the Banner baseline "Payroll Calculation Process" that calculates payroll gross to net, deductions and taxes. This process moves the records to disposition 40.
[12] PWRERRL - This is an OUS report that highlights five situations that will help find input problems and correct payroll errors as follows:
Gross and Net Pay - The audits identify employees with gross pay exceeding $10,000.00 and employees who have net pay exceeding $10,000.00. Both gross and net are checked, as it would be possible to make an error on the entry of an "add/replace" amount and give an employee an erroneous figure.
Hours - The audit lists employees with paid hours exceeding the number of available hours in the month or 173.33; which ever limit is greater. This should help identify situations of duplicate entry, data-entry errors, etc.
Arrears - Employees with "arrearage" deduction situations are identified.
Contributions - Employees who do not have 80 REG hours in a month are listed with their contribution deductions. Benefits personnel should review the entries. They can determine whether to stop these and other deductions.
[13] PWRVALD - This is an OUS FOAPAL validation report/process.
[14] PHRDCON - This is the Banner baseline "Disposition Control Report" that lists each employee in the payroll process by disposition. This report is run several times throughout the payroll process. PHPTIME should be run in 'Re-Extract' mode, as many times as necessary, until all employees are at disposition 10 or greater.
[15] PHRDERR - This is the Banner baseline "Payroll Errors Display Report" that lists errors encountered during payroll processing. This report is run several times throughout the payroll process.
[16] PHRPREG - This is the Banner baseline "Payroll Register" report.
[17] Garnishments Applied - Garnishments are applied by the Controller's Division for 5th Site Institutions. The large institutions enter them in accordance with the established payroll timeline.
[18] PWPBAKP - This is the OUS payroll backup procedure.
[19] PHPDOCM - This is the Banner baseline "Calculation, Check and Direct Deposit Amounts" process that calculates check and direct deposit amounts.
[20] PWPCHKL - This is the OUS process that generates checks.
[21] PWPCHKL - This is the OUS process that generates direct deposits.
[22] PWMCHK - This is the OUS print process for checks.
[23] PWMCHK - This is the OUS print process for direct deposit notices.
[24] PHRCISS - This is the Banner baseline "Check Issue Report".
[25] PHRCDST - This is the Banner baseline "Check Distribution List" report.
[26] PHRDIRD - This is the Banner baseline "Direct Deposit Distribution" report.
[27] PHPDIRD - This is the Banner baseline "Create Direct Deposit Tape" process that creates the direct deposit file that is sent to the clearinghouse bank.
[28] PHRTREG - This is the Banner baseline "Direct Deposit Tape Register" report that accompanies the direct deposit file.
[29] ACH Transfer - ACH file transferred to the Controller's Division.
*** NOTE: This should be a separate test, accomplished in coordination with John Craven and ITS.
[30] PHPUPDT - This is the Banner baseline "Pay Period Update Batch Module" process that updates permanent pay history records and leave taken balances. This process moves the payroll records to disposition 60.
[31] PWPXPAY - This is the OUS process, "Payroll Warehouse Data File Creation", that creates the aggregation file.
[32] PHRDREG - This is the Banner baseline "Deduction Register" report.
[33] PHRPREG - (Optionally PWRPREG) This is an OUS-modified version of the Banner baseline "Payroll Register" report. The modification makes the event date for adjustments the "driving factor" rather than the year & pay number. Two additional parameters were added to make it possible for payroll staff to look at portions of the current pay period as needed.
[35] NBPBUDM - This is the "Encumbrance Maintenance Process", and is a Banner baseline process that has been modified by OUS in order to accommodate the appropriate encumbrance processing. The date parameter should always be the first of the following month. This process takes the Salary Encumbrance from NBAJOBS and applies the job labor distribution (NBRJBLD) breakdowns. NBRJLBD stores the salary encumbrance value last processed by NBPBUDM (can be viewed on NBIJLHS). Any differences are calculated, by effective date, and the resulting difference is saved in the Enc to Post (can be viewed in NBIJLHS). This Enc to Post amount reduces the previous NBRJLBD Salary Encumbrance. This difference will post to the Encumbrance Number stored in NBRJLBD. The Salary Encumbrance and Enc to Post may be viewed on NBIJLHS, but some problems have been encountered with records not appearing in the query even when they exist in the history table.
[36] NHPFIN1 - This is the Banner baseline "Encumbrances - Finance Extract Process" It has been modified by OUS to perform an OPE encumbrance recast based on the Salary Encumbrance.
[37] PWRENCC - This program compares encumbrance amounts between the NBRBJOB, NBRJLBD and NHRDIST tables. When differences are found, details about the out-of-balance encumbrances are shown on the report.
[38] NHPFIN2 - This is the Banner baseline "Finance Interface - Extract Process" and has been modified by OUS. This process generates a large report and should not be printed.
[39] FURFEED - This is the "Finance Interface Table/Feed Sweep Process". It assigns a batch document number and should ALWAYS BE PRINTED!
[40] FGRTRNI - This process "Edits Documents (journal vouchers)".
[41] FGRTRNR - This process produces the "Error Report of Suspended Documents". Always run this report after FGRTRNI (on the same day) and PRINT IT.
[42] FGRACTG - This process "Posts Approved Documents to Finance Ledgers". It runs automatically - DO NOT RUN FROM JOB SUBMISSION.
Feeding Expenditures [43] PHPFEXP - This process populates the Finance Interface Collector Table (NHRFINC) in detail (i.e., employee-specific, broken down by every earn code and every deduction code within the appropriate rule class. The output from this process is, therefore, very detailed. During export to the General Interface Table (GURFEED), this data is summarized. The Finance entry can then be viewed either on the Detail Transaction Activity Form (FGITRND) or on the General Ledge Activity Form (FGIGLAC).
[44] PWPCDST - This is an OUS process that changes the feed distribution for specific areas. It changes the distribution in four specific classes: 1) College Work Study, 2) Mass Transit, 3) SAIF, 4) Deferred Payouts, and will also change the category for UDA and MEC. The process uses records at disposition 61. it will update the NHRDIST record first, then the corresponding NHRFINC record, which is fed to finance. If, for some reason, it cannot process both of these corresponding records, it will not save either. When complete, all records are set to disposition 62, ready for NHPFIN2. This process should always be run after PHPFEXP and before NHPFIN2.
[45] PZRDISP - This is the Banner baseline "Payroll History Disposition Report". It lists pay packages that remain in the Banner system below a specified disposition number for all payrolls.
[46] NHPFIN2 - This is the Banner baseline "Finance Interface - Extract Process" and has been modified by OUS. This process generates a large report and should not be printed.
[47] FURFEED - This is the "Finance Interface Table/Feed Sweep Process". It assigns a batch document number and should ALWAYS BE PRINTED!
[48] FGRTRNI - This process "Edits Documents (journal vouchers)".
[49] FGRTRNR - This process produces the "Error Report of Suspended Documents". Always run this report after FGRTRNI (on the same day) and PRINT IT.
[50] FGRACTG - This process "Posts Approved Documents to Finance Ledgers". It runs automatically - DO NOT RUN FROM JOB SUBMISSION.
| Parameters: | 01 | Deduction Effective Date | 01-MMM-YYYY |
Check GWIJOBR to ensure this process completed successfully. Record start and end times on the payroll processing checklist and initial this job.
[2] PHPTIME - This is the Banner "Time Extraction Process". It is the baseline process that creates electronic timesheets, including default hours and labor distributions. The records created by this process are viewed in PHAHOUR. Once this process is run, NBAJOBS and PDADEDN are frozen, and no changes can be made through these forms unless the employee record is re-extracted.
| Parameters: | 01 | Pay Year | 2000 |
| Payroll Year | |||
| 02 | Pay ID | MO | |
| Payroll ID | |||
| 03 | Pay Number | ## | |
| Payroll Number | |||
| 04 | Extract Indicator | I/R/C | |
| (I)nitial Extract, (R)e-Extract, (C) Re-Create***** | |||
| (*****NOTE: Running this process in Re-Create mode will wipe out all PHAHOUR records, including any manual time entry that's been done.) | |||
| 05 | ID Entry Choice Indicator | N | |
| (Y)es for individual employee Ids, (N)o for no individual Ids. | |||
| 06 | ID - DO NOT ENTER A VALUE FOR THIS PARAMETER | ||
| Enter employee's ID number if running in ID Indicator mode. | |||
| 07 | Supplemental/Regular Payroll | R | |
| (R)egular or (S)upplemental Payroll | |||
| 08 | Use Population Selection | N | |
| (Y)es, use population selection, (N)o population selection | |||
| 09 | Population Selection ID | ||
| DO NOT ENTER A VALUE FOR THIS PARAMETER | |||
| 10 | Creator ID | ||
| DO NOT ENTER A VALUE FOR THIS PARAMETER | |||
| 11 | Application ID | ||
| DO NOT ENTER A VALUE FOR THIS PARAMETER | |||
Check GWIJOBR to ensure this process completed successfully. Record start and end times on the payroll processing checklist and initial this job.
[3] PHRDCON - This is the Banner baseline "Disposition Control Report" that lists each employee in the payroll process by disposition. This report is run several times throughout the payroll process. PHPTIME should be run in 'Re-Extract' mode, as many times as necessary, until all employees are at disposition 10 or greater.
| Parameters: | 01 | Pay Year | 2000 |
| Payroll Year | |||
| 02 | Pay ID | MO | |
| Payroll ID | |||
| 03 | Pay Number | ## | |
| Payroll Number |
Check GWIJOBR to ensure this process completed successfully. Record start and end times on the payroll processing checklist and initial this job.
[4] PHRDERR - This is the Banner baseline "Payroll Errors Display Report" that lists errors encountered during payroll processing. This report is run several times throughout the payroll process.
| Parameters: | 01 | Pay Year | 2000 |
| Payroll Year | |||
| 02 | Pay ID | MO | |
| Payroll ID | |||
| 03 | Pay Number | ## | |
| Payroll Number |
Check GWIJOBR to ensure this process completed successfully. Record start and end times on the payroll processing checklist and initial this job.
[5] Time Entry - Manual time entry in PHAHOUR for hourly employees.
[6] PHPMTIM - This is the Banner baseline "Mass Time Entry" process. Not all institutions use this process, but it is included on the checklist for those who do.
[7] PWPPDEL - This is an OUS process that deletes disposition 10 records from payroll history tables. A listing of the disposition count is printed before and after the deletion, if any occurs.
| Parameters: | 01 | Pay Year | 2000 |
| Payroll Year | |||
| 02 | Pay ID | MO | |
| Payroll ID | |||
| 03 | Pay Number | ## | |
| Payroll Number |
Check GWIJOBR to ensure this process completed successfully. Record start and end times on the payroll processing checklist and initial this job.
[8] PHPPROF - This is the Banner baseline "Pay Period Proof Batch Module" that validates time entered in PHAHOUR. It moves the records, assuming all errors are corrected, to disposition 25.
| Parameters: | 01 | Pay Year | 2000 |
| Payroll Year | |||
| 02 | Pay ID | MO | |
| Payroll ID | |||
| 03 | Pay Number | ## | |
| Payroll Number | |||
| 04 | Delete Timesheets with No Hours | N | |
| (Y)es for deletion, (N)o otherwise | |||
Check GWIJOBR to ensure this process completed successfully. Record start and end times on the payroll processing checklist and initial this job.
[9] PHPLEAV - This is the Banner baseline "Leave Accruals and Taken Process" that accrues and takes leaves based on leave categories and values on PHAHOUR and PEAEMPL. This process moves records to disposition 29 (The baseline version of this process moves records to disposition 30. A slight modification was made to this process by OUS so that records move to disposition 29 in order to accommodate PWPCBNC).
| Parameters: | 01 | Pay Year | 2000 |
| Payroll Year | |||
| 02 | Pay ID | MO | |
| Payroll ID | |||
| 03 | Pay Number | ## | |
| Payroll Number |
Check GWIJOBR to ensure this process completed successfully. Record start and end times on the payroll processing checklist and initial this job.
A/A>[10] PWPCBNC - This is an OUS process that calculates HMO and Rural subsidies, prorates part-time employee contributions, calculates a minimum guaranteed amount for part-time employees, and calculates cash back. Employee class codes, hours worked in a month, and deduction codes are used to determine eligibility and amounts.
| Parameters: | 01 | Pay Year | 2000 |
| Payroll Year | |||
| 02 | Pay ID | MO | |
| Payroll ID | |||
| 03 | Pay Number | ## | |
| Payroll Number |
Check GWIJOBR to ensure this process completed successfully. Record start and end times on the payroll processing checklist and initial this job.
[11] PHPCALC - This is the Banner baseline "Payroll Calculation Process" that calculates payroll gross to net, deductions and taxes. This process moves the records to disposition 40.
| Parameters: | 01 | Pay Year | 2000 |
| Payroll Year | |||
| 02 | Pay ID | MO | |
| Payroll ID | |||
| 03 | Pay Number | ## | |
| Payroll Number | |||
| 04 | Re-Calculate All Employees? | N | |
| (Y)es or (N)o | |||
| 05 | Calcualtion Analysis Report? | Y | |
| (Y)es or (N)o | |||
| NOTE: View the output on-line as this creates a very large output file. | |||
Check GWIJOBR to ensure this process completed successfully. Record start and end times on the payroll processing checklist and initial this job.
[12] PWRERRL - This is an OUS report that highlights five situations that will help find input problems and correct payroll errors as follows:
Gross and Net Pay - The audits identify employees with gross pay exceeding $10,000.00 and employees who have net pay exceeding $10,000.00. Both gross and net are checked, as it would be possible to make an error on the entry of an "add/replace" amount and give an employee an erroneous figure.
Hours - The audit lists employees with paid hours exceeding the number of available hours in the month or 173.33; which ever limit is greater. This should help identify situations of duplicate entry, data-entry errors, etc.
Arrears - Employees with "arrearage" deduction situations are identified.
Contributions - Employees who do not have 80 REG hours in a month are listed with their contribution deductions. Benefits personnel should review the entries. They can determine whether to stop these and other deductions.
| Parameters: | 01 | Pay Year | 2000 |
| Payroll Year | |||
| 02 | Pay ID | MO | |
| Payroll ID | |||
| 03 | Pay Number | ## | |
| Payroll Number |
[13] PWRVALD - This is an OUS FOAPAL validation report/process.
| Parameters: | 01 | Pay Year | 2000 |
| Payroll Year | |||
| 02 | Pay ID | MO | |
| Payroll ID | |||
| 03 | Pay Number | ## | |
| Payroll Number |
[14] PHRDCON - This is the Banner baseline "Disposition Control Report" that lists each employee in the payroll process by disposition. This report is run several times throughout the payroll process. PHPTIME should be run in 'Re-Extract' mode, as many times as necessary, until all employees are at disposition 10 or greater.
| Parameters: | 01 | Pay Year | 2000 |
| Payroll Year | |||
| 02 | Pay ID | MO | |
| Payroll ID | |||
| 03 | Pay Number | ## | |
| Payroll Number |
Check GWIJOBR to ensure this process completed successfully. Record start and end times on the payroll processing checklist and initial this job.
[15] PHRDERR - This is the Banner baseline "Payroll Errors Display Report" that lists errors encountered during payroll processing. This report is run several times throughout the payroll process.
| Parameters: | 01 | Pay Year | 2000 |
| Payroll Year | |||
| 02 | Pay ID | MO | |
| Payroll ID | |||
| 03 | Pay Number | ## | |
| Payroll Number |
Check GWIJOBR to ensure this process completed successfully. Record start and end times on the payroll processing checklist and initial this job.
[16] PHRPREG - This is the Banner baseline "Payroll Register" report.
| Parameters: | 01 | Pay Year | 2000 |
| Payroll Year | |||
| 02 | Pay ID | MO | |
| Payroll ID | |||
| 03 | Pay Number | ## | |
| Payroll Number | |||
| 04 | Report Choice | O | |
| Enter (O)riginal Event, (A)djustments or (B)oth | |||
[17] Garnishments Applied - Garnishments are applied by the Controller's Division for 5th Site Institutions. The large institutions enter them in accordance with the established payroll timeline.
[18] PWPBAKP - This is the OUS payroll backup procedure.
Parameters: This process is run from job submission; there are no parameters to be entered.
[19] PHPDOCM - This is the Banner baseline "Calculation, Check and Direct Deposit Amounts" process that calculates check and direct deposit amounts.
| Parameters: | 01 | Pay Year | 2000 |
| Payroll Year | |||
| 02 | Pay ID | MO | |
| Payroll ID | |||
| 03 | Pay Number | ## | |
| Payroll Number | |||
| 04 | Check Date | DD-MMM-YYYY | |
| Enter the date of issue to be printed on check. | |||
| 05 | Just Checks | N | |
| (Y)es for just checks, (N)o for more than just checks. | |||
| 06 | ID | ||
| Enter an ID number if running for a single employee. Leave null to run for all employees. | |||
[20] PWPCHKL - This is the OUS process that generates checks.
| Parameters: | 01 | Pay Year | 2000 |
| Payroll Year | |||
| 02 | Pay ID | MO | |
| Payroll ID | |||
| 03 | Pay Number | ## | |
| Payroll Number | |||
| 04 | Check or Direct Deposit (C/D) | C | |
| Enter (C)heck | |||
| 05 | Beginning Document Number | ||
| Required value - enter next valid document number | |||
| 06 | Last Good Document Number | ||
| Optional - usually left null | |||
| 07 | Address Type | ||
| Optional - (Note: 'PR' is used by all institutions except OIT) | |||
[21] PWPCHKL - This is the OUS process that generates direct deposits.
| Parameters: | 01 | Pay Year | 2000 |
| Payroll Year | |||
| 02 | Pay ID | MO | |
| Payroll ID | |||
| 03 | Pay Number | ## | |
| Payroll Number | |||
| 04 | Check or Direct Deposit (C/D) | D | |
| Enter (D)irect Deposit | |||
| 05 | Beginning Document Number | Enter an 8-digit # (no char) | |
| Required value - enter next valid document number | |||
| 06 | Last Good Document Number | ||
| Optional - usually left null | |||
| 07 | Address Type | ||
| Optional - (Note: 'PR' is used by all institutions except OIT) | |||
[22] PWMCHK - This is the OUS print process for checks.
[23] PWMCHK - This is the OUS print process for direct deposit notices.
[24] PHRCISS - This is the Banner baseline "Check Issue Report".
| Parameters: | 01 | Pay Year | 2000 |
| Payroll Year | |||
| 02 | Pay ID | MO | |
| Payroll ID | |||
| 03 | Pay Number | ## | |
| Payroll Number |
[25] PHRCDST - This is the Banner baseline "Check Distribution List" report.
| Parameters: | 01 | Pay Year | 2000 |
| Payroll Year | |||
| 02 | Pay ID | MO | |
| Payroll ID | |||
| 03 | Pay Number | ## | |
| Payroll Number |
[26] PHRDIRD - This is the Banner baseline "Direct Deposit Distribution" report.
| Parameters: | 01 | Pay Year | 2000 |
| Payroll Year | |||
| 02 | Pay ID | MO | |
| Payroll ID | |||
| 03 | Pay Number | ## | |
| Payroll Number |
[27] PHPDIRD - This is the Banner baseline "Create Direct Deposit Tape" process that creates the direct deposit file that is sent to the clearinghouse bank.
| Parameters: | 01 | Pay Year | 2000 |
| Payroll Year | |||
| 02 | Pay ID | MO | |
| Payroll ID | |||
| 03 | Pay Number | ## | |
| Payroll Number |
[28] PHRTREG - This is the Banner baseline "Direct Deposit Tape Register" report that accompanies the direct deposit file.
| Parameters: | 01 | Pay Year | 2000 |
| Payroll Year | |||
| 02 | Pay ID | MO | |
| Payroll ID | |||
| 03 | Pay Number | ## | |
| Payroll Number |
[29] ACH Transfer - ACH file transferred to the Controller's Division.
*** NOTE: This should be a separate test, accomplished in coordination with John Craven and ITS.
[30] PHPUPDT - This is the Banner baseline "Pay Period Update Batch Module" process that updates permanent pay history records and leave taken balances. This process moves the payroll records to disposition 60.
[31] PWPXPAY - This is the OUS process, "Payroll Warehouse Data File Creation", that creates the aggregation file.
[32] PHRDREG - This is the Banner baseline "Deduction Register" report.
| Parameters: | 01 | Pay Year | 2000 |
| Payroll Year | |||
| 02 | Pay ID | MO | |
| Payroll ID | |||
| 03 | Pay Number | ## | |
| Payroll Number | |||
| 04 | Report Choice | O | |
| Enter (O)riginal Event, (A)djustments or (B)oth | |||
| 05 | Current Period Only | ||
| Enter (Y)es for current payroll only, (N)o for all deductions with YTD totals. | |||
| 06 | Process All Employer Codes | ||
| Enter (Y)es to process all employers, (N)o to process one employer. | |||
| 07 | Employer Code | ||
| Optional Value - usually left null. | |||
[33] PHRPREG - (Optionally PWRPREG) This is an OUS-modified version of the Banner baseline "Payroll Register" report. The modification makes the event date for adjustments the "driving factor" rather than the year & pay number. Two additional parameters were added to make it possible for payroll staff to look at portions of the current pay period as needed.
| Parameters: | 01 | Pay Year | 2000 |
| Payroll Year | |||
| 02 | Pay ID | MO | |
| Payroll ID | |||
| 03 | Pay Number | ## | |
| Payroll Number | |||
| 04 | Report Choice | O | |
| Enter (O)riginal Event, (A)djustments or (B)oth | |||
| 05 | Begin Date | DD-MMM-YYYY | |
| User-defined begin date, or leave blank to use pay period begin date. | |||
| 06 | End Date | DD-MMM-YYYY | |
| User-defined end date, or leave blank to use pay period end date. | |||
INTERFACES
Feed the payroll to finance and verify that all interface points are working correctly; verify that transactions have posted to the appropriate accounts.
HRIS FEED TO FINANCE
Feeding Encumbrances
[34] PWPSENC - This is the "Salary Encumbrance Recast Process", developed by OUS to recast encumbrance amounts each month, as OUS does not utilize the Banner baseline process. The date parameter should always be the first of the following month.
This process performs the automated data entry of the Salary Encumbrance and Fringe Encumbrance fields in the Encumbrance Information block of NBAJOBS. It also sets an indicator (NBRBJOB_ENCUMBRANCE_CHANGE_IND) to a "Y", which marks these records as changed for encumbrance processing. The Fringe Encumbrance is an estimate only, and is not used in further processing. The OUS OPE encumbrance processing is done solely in the NHPFIN1 process.
This process uses SCT's calculation for the salary encumbrance (NBPBUDM), which is based on calendar days. The calendar days become relevant when encumbering partial months or future-dated job labor distribution records.
The Contract Start and End Dates, from NBAJOBS, are used in encumbering to identify the length of the period to be encumbered; and both dates must be within the current fiscal year. If these dates are left blank, the fiscal year begin and end dates are used as a default. This process will only encumber Active jobs, so employees on leave status for the summer will not be encumbered until the job becomes active.
The calculation will generate a salary encumbrance based on the period beginning with the Encumbrance Date parameter entered, and ending with the least of the Contract End, Job End or fiscal year-end date. For example, if the Contract End was June 15, 1999, but the Job End was March 15, 1999 (terminated job), the process would encumber through March 15th. If this is the first month that a salary encumbrance was entered for this job, the entire amount will process through to finance. If this amount adjusts a current salary encumbrance value for the job, then the difference between last month's Salary Encumbrance and this newly calculated value will process through to finance.
| Parameters: | 01 | Encumbrance Date | 01-MMM-YYYY |
| 02 | Chart of Accounts | ||
| The institution chart of accounts | |||
Check GWIJOBR to ensure this process completed successfully. Record start and end times on the payroll processing checklist and initial this job.
[35] NBPBUDM - This is the "Encumbrance Maintenance Process", and is a Banner baseline process that has been modified by OUS in order to accommodate the appropriate encumbrance processing. The date parameter should always be the first of the following month. This process takes the Salary Encumbrance from NBAJOBS and applies the job labor distribution (NBRJBLD) breakdowns. NBRJLBD stores the salary encumbrance value last processed by NBPBUDM (can be viewed on NBIJLHS). Any differences are calculated, by effective date, and the resulting difference is saved in the Enc to Post (can be viewed in NBIJLHS). This Enc to Post amount reduces the previous NBRJLBD Salary Encumbrance. This difference will post to the Encumbrance Number stored in NBRJLBD. The Salary Encumbrance and Enc to Post may be viewed on NBIJLHS, but some problems have been encountered with records not appearing in the query even when they exist in the history table.
The salary encumbrance will post with an Encumbrance Item Number of "0" and the OPE encumbrance will post with an Encumbrance Item Number of "1". Any records processed with a Change Indicator of "D" will not show on this report, but will process into Finance.
| Parameters: | 01 | Process Mode | P |
| "P" for process updates (can be run as "R" for report to view what will be processed. | |||
| 02 | Budget Processing | N | |
| "N" to skip budget processing (can be run as "Y" for budget processing, but this is only for institutions that feed their HR budget to FIS). | |||
| 03 | Encumbrance Processing | Y | |
| "Y" to process salary and fringe encumbrances (can be run as "N" to skip encumbrance processing. | |||
| 04 | Active or Working Budgets | ||
| DO NOT ENTER A VALUE FOR THIS PARAMETER | |||
| 05 | Chart of Accounts Code | ||
| DO NOT ENTER A VALUE FOR THIS PARAMETER | |||
| 06 | Fiscal Year | ||
| DO NOT ENTER A VALUE FOR THIS PARAMETER | |||
| 07 | Budget ID | ||
| DO NOT ENTER A VALUE FOR THIS PARAMETER | |||
| 08 | Budget Phase | ||
| DO NOT ENTER A VALUE FOR THIS PARAMETER | |||
| 09 | Encumbrance Date | 01-MMM-YYYY | |
| The first of the month following the current payroll run. | |||
Check GWIJOBR to ensure this process completed successfully. Record start and end times on the payroll processing checklist and initial this job.
[36] NHPFIN1 - This is the Banner baseline "Encumbrances - Finance Extract Process" It has been modified by OUS to perform an OPE encumbrance recast based on the Salary Encumbrance.
The initial step of the encumbrance processing updates the Interfaced indicator in the NHRENCD table. It scans the Encumbrance Period Detail Table (FGBENCP) for any current records in NHRENCD, matching on encumbrance number, item, and sequence, and updates the Interfaced Indicator to "Y" if it is currently "N". This will assure that any salary encumbrance, which have already posted to finance, will not try to post as an original encumbrance.
The process then takes the Enc to Post and creates an NHRDIST and NHRFINC record. The NHRDIST record is an historical record, which can be viewed using the NHIDIST and NHIEDST forms. The NHRFINC record is used for the feed to finance. The NHRDIST and NHRFINC records will have a transaction date of the date the process was run, which will be the posting date to finance.
| Parameters: | 01 | Interface COBRA Flag | N |
| "N" to skip COBRA interface (can be run as "Y" for COBRA interface) | |||
| 02 | Interface Budget Flag | N | |
| "N" to skip budget interface (can be run as "Y" for budget interface) | |||
| 03 | Interface Encumbrance Flag | Y | |
| "Y" to interface encumbrances (can be run as "N" to skip encumbrance interface) | |||
| 04 | Encumbrance Date | 01-MMM-YYYY | |
| Enter encumbrance date if the value for parameter 03 is "Y" | |||
Check GWIJOBR to ensure this process completed successfully. Record start and end times on the payroll processing checklist and initial this job.
[37] PWRENCC - This program compares encumbrance amounts between the NBRBJOB, NBRJLBD and NHRDIST tables. When differences are found, details about the out-of-balance encumbrances are shown on the report.
The first page(s) of the report show differences between NBRBJOB and NBRJLBD salary encumbrances.
The next page(s) show differences between NBRBJOB and NHRDIST salary encumbrances.
The next page(s) show differences between NBRJLBD and NHRDIST salary encumbrances.
The last page(s) show differences between NBRJLBD and NHRDIST fringe encumbrances.
[Print this report]
| Parameters: | 01 | Encumbrance Date | 01-MMM-YYYY |
| The first of the month following the current payroll run. | |||
Check GWIJOBR to ensure this process completed successfully. Record start and end times on the payroll processing checklist and initial this job.
[38] NHPFIN2 - This is the Banner baseline "Finance Interface - Extract Process" and has been modified by OUS. This process generates a large report and should not be printed.
This process summarizes data by transaction date, rule class and FOAPAL, and transfers the salary and OPE encumbrance documents into the interface process for finance.
| Parameters: | 01 | Detail Report Flag | Y |
| "Y" to produce a detail report (can be run as "N" to skip production of a detail report) | |||
| 02 | Interface Flag | ||
| "Y" to interface transactions to Finance (can be run as "N" to skip transactions interface) | |||
| 03 | Pay ID | ||
| DO NOT ENTER A VALUE FOR THIS PARAMETER (for encumbrances) |
|||
Check GWIJOBR to ensure this process completed successfully. Record start and end times on the payroll processing checklist and initial this job.
[39] FURFEED - This is the "Finance Interface Table/Feed Sweep Process". It assigns a batch document number and should ALWAYS BE PRINTED!
| Parameters: | 01 | Report Mode | S |
| "S" for select, to run in update mode (can be run as "V" for view, to run in audit mode) | |||
| 02 | System ID/Time Stamp | PAYROLL | |
Check GWIJOBR to ensure this process completed successfully. Record start and end times on the payroll processing checklist and initial this job.
[40] FGRTRNI - This process "Edits Documents (journal vouchers)".
Parameters: There are no parameters for this report.
Following the completion of this process, check FGIJVCD for JV status, check FGIDOCR for posted information.Check GWIJOBR to ensure this process completed successfully. Record start and end times on the payroll processing checklist and initial this job.
[41] FGRTRNR - This process produces the "Error Report of Suspended Documents". Always run this report after FGRTRNI (on the same day) and PRINT IT.
Parameters: There are no parameters for this report.
Check GWIJOBR to ensure this process completed successfully. Record start and end times on the payroll processing checklist and initial this job.[42] FGRACTG - This process "Posts Approved Documents to Finance Ledgers". It runs automatically - DO NOT RUN FROM JOB SUBMISSION.
Feeding Expenditures [43] PHPFEXP - This process populates the Finance Interface Collector Table (NHRFINC) in detail (i.e., employee-specific, broken down by every earn code and every deduction code within the appropriate rule class. The output from this process is, therefore, very detailed. During export to the General Interface Table (GURFEED), this data is summarized. The Finance entry can then be viewed either on the Detail Transaction Activity Form (FGITRND) or on the General Ledge Activity Form (FGIGLAC).
[Archive]
| Parameters: | 01 | Process All Payrolls | Y |
| 02 | Process All Redistributions | Y/N | |
| 03 | Payroll Year | YYYY | |
| 04 | Payroll ID | MO | |
| 05 | Payroll Number |
Check GWIJOBR to ensure this process completed successfully. Record start and end times on the payroll processing checklist and initial this job. View the output on-line.
[44] PWPCDST - This is an OUS process that changes the feed distribution for specific areas. It changes the distribution in four specific classes: 1) College Work Study, 2) Mass Transit, 3) SAIF, 4) Deferred Payouts, and will also change the category for UDA and MEC. The process uses records at disposition 61. it will update the NHRDIST record first, then the corresponding NHRFINC record, which is fed to finance. If, for some reason, it cannot process both of these corresponding records, it will not save either. When complete, all records are set to disposition 62, ready for NHPFIN2. This process should always be run after PHPFEXP and before NHPFIN2.
| Parameters: | 01 | Print Errors Only | Y |
| "Y" to print errors only (can also be run as "N" to view or print all changed records) | |||
Check GWIJOBR to ensure this process completed successfully. Record start and end times on the payroll processing checklist and initial this job.
[45] PZRDISP - This is the Banner baseline "Payroll History Disposition Report". It lists pay packages that remain in the Banner system below a specified disposition number for all payrolls.
| Parameters: | 01 | Disposition | 60 |
[46] NHPFIN2 - This is the Banner baseline "Finance Interface - Extract Process" and has been modified by OUS. This process generates a large report and should not be printed.
This process summarizes data by transaction date, rule class and FOAPAL, and transfers the salary and OPE encumbrance documents into the interface process for finance.
| Parameters: | 01 | Detail Report Flag | Y |
| "Y" to produce a detail report (can be run as "N" to skip production of a detail report) | |||
| 02 | Interface Flag | Y | |
| "Y" to interface transactions to Finance (can be run as "N" to skip transactions interface) | |||
| 03 | Pay ID | MO | |
| Enter a value FOR EXPENDITURES ONLY. | |||
Check GWIJOBR to ensure this process completed successfully. Record start and end times on the payroll processing checklist and initial this job.
[47] FURFEED - This is the "Finance Interface Table/Feed Sweep Process". It assigns a batch document number and should ALWAYS BE PRINTED!
| Parameters: | 01 | Report Mode | S |
| "S" for select, to run in update mode (can be run as "V" for view, to run in audit mode) | |||
| 02 | System ID/Time Stamp | PAYROLL | |
Check GWIJOBR to ensure this process completed successfully. Record start and end times on the payroll processing checklist and initial this job.
[48] FGRTRNI - This process "Edits Documents (journal vouchers)".
Parameters: There are no parameters for this report.
Following the completion of this process, check FGIJVCD for JV status, check FGIDOCR for posted information.Check GWIJOBR to ensure this process completed successfully. Record start and end times on the payroll processing checklist and initial this job.
[49] FGRTRNR - This process produces the "Error Report of Suspended Documents". Always run this report after FGRTRNI (on the same day) and PRINT IT.
Parameters: There are no parameters for this report.
Check GWIJOBR to ensure this process completed successfully. Record start and end times on the payroll processing checklist and initial this job.[50] FGRACTG - This process "Posts Approved Documents to Finance Ledgers". It runs automatically - DO NOT RUN FROM JOB SUBMISSION.