Sorry, but your search for documentation yielded No Results.

There is not currently a document devoted specifically to
the function for which you requested information.

Use your browser's BACK button (or Click Here) to return to the previous screen.












Payroll System

Preliminary

Hotz Hall
University of Arkansas, Fayetteville
Previous Document Date: Sept 3,1998

Table of Contents

Introduction

Overview

Online Functions

Reports, conversions, and MSA requirements.

Data Dictionary

BASIS Team

June 25, 1998


Introduction


System and Revision Identification

These are the preliminary documents concerning the Employee Payroll (PAYROLL) system. In general, no revision marks will be printed on subsequent versions. The reader is advised to check under this heading for general descriptions of where changes have occured.

Major Changes have been made to this document since the Apr. 1st version. Please read this in its entirity.


Purpose of this Document

This document is meant to introduce concepts for BASIS Employee Payroll (PAYROLL), documenting 'user' understanding of the system, and will include goals and objectives, overall system requirements, on-line screens, data dictionaries when available, and descriptions of batch jobs. Process descriptions will be included where appropriate. This is a live working document and is meant to stimulate thought and discussion regarding the development and use of the system.

Overview


Purpose and Scope of the System

The Employee Payroll application is meant to provide a means for paying wages, taxing, accumulating and paying benefits, making corrections to the employee's pay and/or benefits, producing mandated reports, and all miscellaneous aspects of payroll as part of the BASIS project.

System Principles


Online Functions

The functions and list functions associated with Employee Payroll are defined on the following pages, and the associated descriptions are also used as the screen level help text within the on-line system.

PCAL - Payroll Calendar

Figure 1. PCAL (Payroll CALendar)



  EPOPCAL 1 PROD              Payroll CALendar - PCAL            
  Command:      Action: V Emp ID: 105651      Comp Type:    Date: 01/01/2001    
  Payroll Type: M                                                               
 -------------------------------------------------------------------------------
 Action: V Pay Date: 01/01/2001 Payroll Type: M                                 
                                                           Payroll              
            Payroll   Approval                            Date for   FY/       S
   Pay Date  Type      Due By      ---- Comp Period ---- Adjustments CY  Term  t
                                                                                
                                                                                
  01/10/2001  H   01/04/2001 21:00                       01/04/2001 2001 20011 L
                                                                    2001        
  01/16/2001  O   01/09/2001 21:00                       01/09/2001 2001 20011 L
                                                                    2001        
  01/25/2001  H   01/19/2001 21:00                       01/19/2001 2001 20011 L
                                                                    2001        
  01/31/2001  M   01/25/2001 19:00 01/01/2001 01/31/2001 01/25/2001 2001 20011 L
                                                                    2001        
  02/09/2001  H   02/05/2001 19:00                       02/05/2001 2001 20011 L
                                                                    2001        
                                                                                
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit  DCode                   Forwd                          
 Press PF8 to view more records or enter new keys                              
 

The following sections describe the PCAL (Payroll CALendar) function:

"Purpose"
"Key Fields Required in the Banner"
"Valid Actions"
"Processing"

Purpose

PCAL is used by the University Payroll office to establish a comprehensive calendar of payrolls and to coordinate BASIS activities for those payrolls. Pay dates and approval cut-off dates are established for each type of payroll.

Key Fields Required in the Banner

Valid Actions

Processing

For the monthly payroll, compensation periods are established which control the scheduling of payments and identify records as retroactive. A combination of pay date and type is used to positively identify a payroll for the loading of LABOR records. The status of the payroll can be viewed. The FY/CY field determines the fiscal year for which the payroll is to be posted to accounting and Labor. The CY part indicates in which calendar year the payroll is paid. Term, which is appropriate only for the hourly payrolls, is used to verify student records in order to determine Student/FICA eligibility.

The ST (Status) values are:


PDAY - Payroll Dates And due bYs

Figure 2. Payroll Dates And due bYs - PDAY


  EPOMENU 1 PROD           main MENU for payroll - MENU           06/16/04 10:10
  Command: pday Action: V Emp ID: 105651      Comp Type:    Date: 01/01/2001    
                                                                                
 -------------------------------------------------------------------------------
    CMD  Command description                      Required key fields           
                  Payroll Dates And due bYs - PDAY                  ------------
    Starting Pay Date: 05/27/2004                                   D           
    -------------------------------------------------------------               
    Payrolls with pay dates on or after: 05/27/2004                 & SP/Adj Typ
                                                                                
                  Payroll          Payroll         Updates and      omp Type    
     Pay Date  ____Type_____ ______Status_______ Approvals Due By               
    05/28/2004 M  Monthly    L Labor updated     05/24/2004 19:00   Adj Type, Dt
    06/10/2004 H  Hourly     L Labor updated     06/03/2004 19:00    Number     
    06/15/2004 O  OT/Suppl.  L Labor updated     06/09/2004 19:00               
    06/25/2004 H  Hourly       Not yet extracted 06/21/2004 19:00               
    06/30/2004 M  Monthly      Not yet extracted 06/23/2004 19:00               
    07/09/2004 H  Hourly       Not yet extracted 07/01/2004 19:00               
                                                                                
                 Payrolls 1   thru 6   displayed                                
                                                                                
    PF1=Help  PF3=Quit    PF5=RStrt             PF8=Forwd           F11--PF12---
   Press PF8 to page forward, or enter new keys                                 
 

The following sections describe the Payroll Dates And due bYs function:

"Purpose"
"Key Fields in the Banner"
"Processing"

Purpose

This application independent command is used by the campus community to determine when approvals are due for upcoming payrolls. Pay dates, approval cut-off dates, type of payroll, and status of the payrolls are displayed.

Key Fields Required in the Banner

Processing

This View only command reflects the cut-off times for approvals which have been previously entered on the comprehensive payroll calendar. The date in the banner area is used only as a starting point for the listing. The user may page forward or re-start this list. Changing the date will cause the list to begin with the new date. The payroll types and status are defined below:

Payroll Types

Status Types


XPAY - eXtra PAY

Figure 3. Data Entry screen - XPAY

  EPOXPAY 1 DEMO                 eXtra PAY - XPAY                 
  Command:      Action: V Emp ID: 100751      Comp Type: XN Date: 08/01/2001    
                                                                                
  ----------------------------------------------------------------------------  
 Action: V Emp ID: 999751 Tree, Brian W.                                      
   Comp Type: XN Extra Comp, non-credit    Comp Period Begin: 08/01/2001        
                                                         End: 08/15/2001        
 Supplemental Pay (check distribution) BU: HKRD Hlth Sci Kins Recr & Dan        
 Position: 143   Appt Period:    FTE Appt Pct: 100    Annual Salary:            
 Occ:                                                 Line Item Max:            
                                                      Payment Amount:  1,500.00 
   Funding Type: E                                    Payment Date:   09/28/2001
                                                      Payroll Type:   M         
                                                                                
 CCC: 0102 15020-11-0000                                          Pct: 75.00000 
                                                                                
 Comment: Cont Ed Program                                                       
                                                                                
 Attribute:                                                                     
                                                                                
 Requested 06/16/04 10:40 by PAY04                                              
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit  DCode                   NextR CCC                      
 
Figure 4. Distribution window for XPAY


  EPOXPAY 1 DEMO                 eXtra PAY - XPAY                
  Command:      Action: V Emp ID: 100751      Comp Type: XN Date: 08/01/2001    
                                                                                
  ----------------------------------------------------------------------------  
 Action: V Emp ID: 999751 Tree, Brian W.                                      
   Comp Type: XN Extra Comp, non-credit    Comp Period Begin: 08/01/2001        
                                                         End: 08/15/2001        
 Supplemental Pay (check distribution) BU: HKRD Hlth Sci Kins Recr & Dan        
                        Company Cost Center Distribution                        
    Co. Cost Center    Description                         Percent    Amount    
    0102 15020-11-0000                                     75.00000   1,125.00  
    0102 15020-12-0000                                     25.00000     375.00  
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
      _ Specify distribution by amount                                1,500.00  
   PF1=Help   PF3=Quit  PF4=DCode                                               
 

The following sections describe the XPAY function:

"Purpose"
"Access and Security"
"Key Fields Required in the Banner"
"Valid Actions"
"Approval Routing"
"Validations"
"Processing"

Purpose

The XPAY command provides a method for paying employees special types of compensation which are in addition to regular position based pay. The types of pay which may be processed on this command are:

Access and Security

Key Fields Required in the Banner

Valid Actions

Approval Routing

When the initiator of the transaction presses PF10, the transaction will be routed through the TARGET system to the following approvers (the exact approvers will vary by department):

Validations

Extra compensation payment validations

Summer research validations

Processing

Extra compensation payment processing


LTXP - List Transactions for eXtra Pay

Figure 7. List LTXP (Transactions for eXtra PAY)


  EPOLTXP 1 DEMO     List Txns for XPay for an employee - LTXP    
  Command:      Action: V Emp ID: 999751      Comp Type: XN Date: 08/01/2001    
                                                                                
 -------------------------------------------------------------------------------
  List of all PAYROLL XPAY transactions for                                     
      Employee: 999751 Tree, Brian W.                                         
                                                                                
       Comp ---Comp Period--- Action                    Status            Rj Num
    Cmd Typ   Begin    End    -    Requested   by       -  --Status Set-- Cd Com
  _ XPAY XN 08/01/01 08/15/01 A 09/16/01 10:40 PAY04    E  09/16/01 10:40       
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
           Transactions     1 thru     1 of     1 are displayed                 
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit  DCode RStrt             Q/Nxt                          
 Select an entry, or enter new keys                                            
 

The following sections describe the LTXP function:

"Purpose"
"Key Fields Required in the Banner"

Purpose

LTXP allows the user to track the activity of XPAY (eXtra PAY) that has been initiated for an employee and displays information as to the status of the transaction, time and date of initiation of the transaction, and when the current status was set.

Key Fields Required in the Banner


SUPP - Supplemental Payroll

Figure 8 is an example of the screen presented during processing of the SUPP function.

Figure 8. Data Entry Screen - SUPP


  EPOSUPP 1 DEMO              SUPplemental Pay - SUPP             
  Command:      Action: A Emp ID: 999751      Comp Type: SN Date: 08/16/2001    
                                                                                
 -------------------------------------------------------------------------------
   Action: A Employee: 999751 Tree, Brian W.                                  
     Comp Type: SN Salary - Non-classified   Comp Period Begin: 08/16/2001      
                                                           End: 08/31/2001      
 Supplemental Pay (check distribution) BU: HKRD Hlth Sci Kins Recr & Dan        
 Position: 143   Appt Period: 9  Occ: 2155 Professor                            
                                                                                
                                         Payment Amount:           7,500.00     
                                         Payment Date:           09/28/2001     
                                         True Supplemental Pay:  Y              
                                                                                
 CCC:   0102 15020-11-0000 HKRD-On-Campus Cr Instruc              Pct: 75.00000 
 Notes: Retroactive change not approved for August monthly                      
                                                                                
 Attr:                                                                          
                                                                                
                                                                                
 Entered                by                                                      
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit        RStrt EParm             CCC   Save               
 All entries are valid, press PF10 to Save                                     
 

Figure 9. Pop-up window for SUPP


  EPOSUPP 1 DEMO              SUPplemental Pay - SUPP             
  Command:      Action: A Emp ID: 999751      Comp Type: SN Date: 08/16/2001    
                                                                                
 -------------------------------------------------------------------------------
   Action: A Employee: 999751 Tree, Brian W.                                    
     Comp Type: SN Salary - Non-classified   Comp Period Begin: 08/16/2001      
                                                           End: 08/31/2001      
 Supplemental Pay (check distribution) BU: HKRD Hlth Sci Kins Recr & Dan        
                        Company Cost Center Distribution                        
    Co. Cost Center    Description                         Percent    Amount    
    0102 15020-11-0000                                     75.00000   5,625.00  
    0102 15020-12-0000                                     25.00000   1,875.00  
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
      _ Specify distribution by amount                                7,500.00  
   PF1=Help   PF3=Quit                                     PF10=Sav/Q           
   Enter data; press ENTER to validate or PF10 to save                          
                                                                                
 

The following sections describe the SUPP (SUPupplemental Payroll) function:

"Purpose"
"Key Fields Required in the Banner"
"Valid Actions"
"Approval Routing"
"Validations"
"Validations and processing for early retirement agreements"
"Validations and processing for career service awards"
"Validations and processing for summer school teaching"
"Validations and processing for traditional supplemental pay"

Purpose

The SUPP (SUPplemental Payroll) function is used to process:

Key Fields Required in the Banner

Valid Actions

Approval Routing

There is no TARGET routing for this command. Any changes are saved (effected) when PF10 is pressed. The Payroll Office will initiate these payments which are scheduled when the PF10 key is pressed.

Payments processed on this command are the result of previously approved transactions, therefore no TARGET approval is required. Payroll is informed of the need to pay in three ways:

Validations

Validations and processing for early retirement agreements

Validations and processing for career service awards

Validations and processing for summer school teaching

Validations and processing for traditional supplemental pay


LSPC - List Supplemental pay for a Payroll from CompTyp

Figure 10. LSPC (List Supp pay for a Payroll from CompType)


 Select an entry, or enter new keys
  EPOLSPC 1 DEMO  List Supp pay for a Payroll from CompTyp - LSPC 04/13/97 14:44
  Command:      Action: V Emp ID:             Comp Type: SN Date: 05/30/1997
  Payroll Type: M
 -------------------------------------------------------------------------------
 List suppl. pay for Date: 05/30/1997 Type: M  Monthly appointed (regular)
      starting from Comp Type: SN Salary - Non-classified   by name
 
        Comp                              SP/ -- Comp Period --        Suppl.
    Cmd Typ    Employee Name      Emp ID Adj Begin         End  BU     Amount
  _ XPAY SR Treeman, Dean R       999400 SP  05/20/97 05/31/97 HKRD    1,440.00
  _ XPAY SR Tree,  John A.        999384 SP  05/15/97 05/31/97 NURS      552.63
  _ SUPP ST Tree, John A.         999384 SP  05/15/97 05/31/97 NURS    1,500.00
  _ XPAY XC TRee, Walter L        999400 SP  05/01/97 05/14/97 GEOL      500.00
  _
  _
  _
  _
  _
  _
 
     Supplemental pay actions     1 thru     4 of     4 are displayed
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit        RStrt

The following sections describe the LSPC function:

"Purpose"
"Key Fields Required in the Banner"
"Processing"

Purpose

LSPC allows the user to view the supplemental pay to be paid on a specific payroll.

Key Fields Required in the Banner

Processing


LSBP - List Supplemental pay for a BU on or before Pay date

Figure 11. LSBP (List Supplemental pay for a BU on or before Pay date)


 Select an entry, or enter new keys
  EPOLSBP 1 DEMO  List Supp pay for a BU on or before PayD - LSBP 04/13/98 17:25
  Command:      Action: V Emp ID:             Comp Type:    Date: 08/16/1998
  BU: MEEG
 -------------------------------------------------------------------------------
 List supplemental pay for BU: MEEG MECHANICAL ENGINEERING
       on or before Pay Date: 08/16/1998 by employee name
 
                  T                        Com SP/ -- Comp Period --   Suppl.
    Cmd  Pay Date y Employee Name   Emp ID Ty Adj Begin        End     Amount
  _ SUPP 06/30/98 M Roe, Mary A.    999414 ST SP  06/01/98 06/30/98    1,352.00
  _ SUPP 05/30/98 M Roe, Mary A.    999414 ST SP  05/18/98 05/30/98      650.00
  _
  _
  _
  _
  _
  _
  _
  _
 
               Supplemental pay actions     1 thru     2 displayed
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit        RStrt

The following sections describe the LBSP function:

"Purpose"
"Key Fields Required in the Banner"

Purpose

This list allows the user to view, by Pay Date and BU, a list of employees scheduled to receive supplemental pay.

Key Fields Required in the Banner


LSAD - List Supplemental pay for an Attribute on/before pay Date

Figure 12. LSAD (List Supplemental pay for an Attribute on/before pay Date)


 Select an entry, or enter new keys
  EPOLSAD 1 DEMO  List Supp pay for an Attr on/before PayD - LSAD 04/14/97 08:31
  Command:      Action: V Emp ID:             Comp Type:    Date: 06/30/1997
  Attribute: SS1
 -------------------------------------------------------------------------------
 List supplemental pay with Attribute: SS1  Summer Session 1
      on or before Pay Date: 06/30/1997
 
                 Comp SP/  -- Comp Period --        Supplemental   Pay   Payroll
    Cmd   Emp ID Typ  Adj  Begin         End   BU      Amount      Date   Type
  _ SUPP  999384  ST  SP   06/01/97 06/27/97  NURS     1,500.00  06/30/97  M
  _ SUPP  999384  ST  SP   05/15/97 05/31/97  NURS     1,500.00  05/30/97  M
  _
  _
  _
  _
  _
  _
  _
  _
 
     Supplemental pay actions     1 thru     2 of     2 are displayed
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit        RStrt

The following sections describe the LSAD function:

"Purpose"
"Key Fields Required in the Banner"

Purpose

LSAD (List Supplemental pay for an Attribute on/before pay Date) allows the user to view the supplemental pay scheduled for payment by the specified Attribute. On this list, the Date serves as an end value designating the last Pay Date that you wish to review.

Key Fields Required in the Banner


LSCC - List Supp pay Calendar Year, Comp Type,Supp/Adj Type

Figure 13. List Supp pay for Calendar Year, Comp Type, Supp/Adj Type


  EPOLSCC 1 DEMO   List Supp pay for CY, CT, SP/Adj Type - LSCC   04/14/97 15:04
  Command:      Action: V Emp ID:             Comp Type: ST Date: 04/11/1997
  SP/Adj Type: SP  Payroll Calendar Year: 1997
 -------------------------------------------------------------------------------
 List supplemental pay for CY: 1997 Comp Type: ST Summer Teaching (9 mo.)
   SP/Adj Type: SP  Suppl. Pay   starting from Pay Date: 04/11/1997
 
           Pay                                -- Comp Period --         Suppl.
    Cmd    Date  Employee Name         Emp ID Begin         End  BU     Amount
  _ SUPP 05/30/97 Treecroft, John A.   999384 05/15/97 05/31/97 NURS    1,500.00
  _ SUPP 05/30/97 Treemitt, Neil M     999256 05/15/97 05/31/97 ENGR      750.00
  _ SUPP 06/30/97 Treecroft, John A.   999384 06/01/97 06/27/97 NURS    1,500.00
  _ SUPP 06/30/97 Tree, Neil A.		     999256 06/01/97 06/30/97 ENGR    1,500.00
  _ SUPP 07/31/97 Treeman, Dean W.     999400 07/01/97 07/30/97 MASC    1,200.00
  _
  _
  _
  _
  _
 
     Supplemental pay actions     1 thru     5 of     5 are displayed
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit        RStrt
 Select an entry, or enter new keys

The following sections describe the LSCC function:

"Purpose"
"Key Fields Required in the Banner"

Purpose

The LSCC list allows the user to view employees scheduled to be paid or adjustments to be made, by Comp Type, Pay Date, Sp/Adj Type and for Payroll Calendar Year.

Key Fields Required in the Banner


LSEC - List Supplemental pay for an Employee from a Comp type

Figure 14. LSEC (List Supp pay for an Employee from a Comp type)


 Select an entry, or enter new keys
  EPOLSEC 1 DEMO  List Supp pay for an Emp from Comp Type - LSEC  04/14/98 11:32
  Command:      Action: V Emp ID: 901164      Comp Type:    Date: 04/14/1998
  SP/Adj Type:
 -------------------------------------------------------------------------------
  List supplemental pay for Employee: 901164 Treeson, Charlie L
 starting from Comp Type:    --invalid comp type--     SP/Adj Type:
 
         Comp SP/ -- Comp Period --     Supplemental   Pay    Payroll
    Cmd  Typ  Adj Begin         End  BU     Amount     Date   Ty  --Attributes--
  _ XPAY  SR  SP  05/18/98 05/31/98 MEEG    2,694.44 05/30/98 M   BOTH
  _ XPAY  SR  SP  06/01/98 06/26/98 MEEG    4,898.99 06/30/98 M   BOTH
  _ SUPP  ST  SP  05/18/98 05/30/98 MEEG    1,200.38 05/30/98 M   SS1
  _ SUPP  ST  SP  06/01/98 06/30/98 MEEG    2,677.12 06/30/98 M   SS1  SS2
  _ SUPP  ST  SP  07/01/98 07/31/98 MEEG    3,080.00 07/31/98 M   SS2
  _ SUPP  ST  SP  08/01/98 08/07/98 MEEG      680.00 08/15/98 O   SS2
  _
  _
  _
  _
 
     Supplemental pay actions     1 thru     6 of     6 are displayed
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit        RStrt

The following sections describe the LSEC function:

"Purpose"
"Key Fields Required in the Banner"

Purpose

LSEC allows the user to view the supplemental pay scheduled for a specific employee. If the employee is paid from several comp types, the user can selectively expand or restrict the list by changing the Comp Type.

Key Fields Required in the Banner



Employee W-4 Taxing Information

Figure 20. W4 (Employee's Taxing Information)


  EPOW4   1 DEMO       Employee W-4 Taxing Information - W4       06/17/04 11:15
  Command:      Action: V Emp ID: 103400      Comp Type:    Date: 09/08/2001    
   SSN: 330-46-6798                                                             
 -------------------------------------------------------------------------------
 Action: V SSN: 330-46-6798 103400 Treeman, Dean W.                             
                 Last Paid: 01/15/2004                                          
 First : Dean                                                  Alien Cd: AC     
 Middle: W.                                                  Federal Cd:        
 Last  : Treeman                                     State Spec Rate Cd:        
 Address: 8526 W. Raymond Stree                           Date Address          
 City   : Fayetteville         State: AR  Zip: 72701      Effective: 09/08/2001 
                                                                                
             Tax Method       Marital Status  Exemptions   Amount/Percent       
 Federal  0 Standard                 S            001          31.50            
 State    0 Standard                 S            001          0.00             
                                                                                
 HR:  Name matches ss card.DO not change w/o new card.                          
                                                                                
 NRA: Non resident alien for tax purposes.Check with NRA coordinator before     
      changing taxing options.                                                  
 Updated: 06/17/04 11:15     By: PAY04                                          
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit  DCode                   NextR                          
 

The following sections describe the W4 function:

"Purpose"
"Key Fields Required in the Banner"
"Valid Actions"
"Validations"
"Processing"

Purpose

The W4 command is used by the Payroll Office to establish employee taxing for both Federal and Arkansas state tax and address information.

Key Fields Required in the Banner

Valid Actions

Validations

Processing


I9DF-I9 Drug-Free Check off

Figure 21. I9DF (I9 Drug-Free check off information)






   Update performed for SSN: 303-64-7689                     
  Command:      Action: U Emp ID: 145516      Comp Type:    Date: 09/08/2001    
   Emp SSN: 303-64-7689                                                         
 -------------------------------------------------------------------------------
 Action: U  SSN: 303-64-7689  145516  Treeman, Ralph                            
                                                                                
       Date Last Paid:                                                          
 First Name : Ralph                   Name and Address is                       
 Middle Name:                         from the W4 or I9                         
 Last Name  : Treeman                                                           
                                                                                
 Address: 8514 West Palm                                  Visa Type: J-1        
 City   : Fayetteville                       Date Work Auth Expires: 06/30/2004 
 State  : AR                                                                    
 Zip    : 72704                                                                 
                                                                                
 Date of Birth         : 01/01/1960        X Drug Free Signed                   
 Date Current I9 Signed: 09/08/2001                                             
                                                                                
                                        Updated: 06/17/04 15:35 By: PAY04       
                                                                                
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit  DCode RStrt             NextR       Save               
 

The following sections describe the I9DF function:

"Purpose"
"Key Fields Required in the Banner"
"Valid Actions"
"Validations"

Purpose

The I9DF command is used by the Human Resources Office to verify employment eligiblity for all employees. An I9DF form must be completed for all employees.

Key Fields Required in the Banner

Valid Actions

Validations

Processing


NRA - Non-Resident Alien

Figure 22. NRA


  EPONRA  1 DEMO       Non-Resident Alien maintenance - NRA       06/10/04 11:02
  Command:      Action: V  Emp ID: 145496      Comp Type: XN Date: 06/15/2001   
                                                                                
 -------------------------------------------------------------------------------
 Action: V  Emp Id: 145496   Tree, Luna Moon                                    
                                                                                
                                                                                
 Name   : Tree, Luna Moon                                  Alien Cd: AC         
 Address: 78965 West Ave.                                                       
 City   : Fayetteville         State: AR  Zip: 72701                            
                                                          Visa Type: H-1B       
                                             Date Work Auth Expires: 06/30/2006
                                                                                
                                                                                
                                                                                
 NRA: Employee completed all paper work necessary for treaty exempt. Please     
      check with Angie before changing taxing options.                          
                                                                                
                                                                                
                                                                                
 Updated: 06/10/04 11:02     By: PAY04                                          
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit  DCode                   NextR                          
 

The following sections describe the NRA function:

"Purpose"
"Key Fields Required in the Banner"
"Security and Access"
"Valid Actions"
"Validations"
"Processing"

Purpose

The NRA coordinator will use this command to establish employee non-resident alien , and current treaty status.

Key Fields Required in the Banner

Security and Access

The NRA coordinator and her backup will have update access to this function. The remainder of the Human Resources Department will have view access only. The access for this function will be established in Command Security through NSM.

Valid Actions

Validations

Processing


Oasdi/MEDicare rates

Figure 23. OMED


   Next Record after OASDI/MEDI retrieved                    OMED 03/24/99 12:04
  Command:      Action: V Emp ID:             Comp Type:    Date: 08/29/1998
 
 -------------------------------------------------------------------------------
   Action: V  Date Period Begin: 06/30/1998 Date Period End: 08/29/1998
 
 
    Pecentage for Employee OASDI (EOAS)  : 6.2000
    Percentage for Employer OASDI (ROAS) : 6.2000
 
    Maximum taxable wage for OASDI :   68400.00
 
    Percentage for Employee Medicare (EMED) : 1.4500
    Percentage for Employer Medicare (RMED) : 1.4500
 
    Maximum taxable wage for Medicare:
 
 Updated: 03/03/1999 By: MAZANTI
 
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit                          NextR
 OASDI/MEDI displayed; please enter new key fields

The following sections describe the Oasdi/Medicare Tax Table function:

"Purpose"
"Key Fields Required in the Banner"
"Valid Actions"
"Validations"
"Processing"

Purpose

OMED is an effective dated table used by the University of Arkansas Payroll office to maintain the Oasdi/Medicare taxing University payrolls. The table contains the Oasdi and Medicare percentages for each tax and maximum wage limits, if applicable. The information for the table is provided at least yearly by the Internal Revenue Service. The table is effective dated.

Key Fields Required in the Banner

Valid Actions

Validations

Processing

The following processing is performed based upon the action:

The system updates the audit log history group with the time, date and user performing the update.

EFIT - Employee Federal Income Tax

Figure 24. EFIT (Married Status)


   Decoding has been performed                               EFIT 06/18/04 14:42
  Command:      Action: V Emp ID:             Comp Type:    Date: 09/08/2001    
                                                                                
 -------------------------------------------------------------------------------
  Action: V                       Married    Begin: 01/01/1999     Screen 1 of 2
                                               End: 12/31/2099                  
                                                                                
                                  ------ Withholding ------      of Excess      
        Start       Through         Amount    +  Percentage         Over        
     ----------    ----------     -----------    ----------      ----------     
           0.01      6,450.00                                                   
       6,450.01     47,500.00                      15.00 %         6,450.00     
      47,500.01     98,500.00        6,157.50      28.00 %        47,500.00     
      98,500.01    163,000.00       20,437.50      31.00 %        98,500.00     
     163,000.01    287,600.00       40,432.50      36.00 %       163,000.00     
     287,600.01          0.00       85,288.50      39.60 %       287,600.00     
           0.01                          0.00       0.00 %                      
                                                                                
   The Annual Amount of One Withholding Exemption:   2,750.00                   
                                                                                
   Updated: 05/13/1999 17:26 By: PAY04    Jennifer C. Carey                     
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit  DCode                   NextS                          
 Press PF8 to view next screen or enter new keys                               
 

Figure 25. EFIT (Single Status)


  EPOEFIT 1 DEMO  Employee Federal Income Tax rate maint. - EFIT  06/18/04 14:42
  Command:      Action: V Emp ID:             Comp Type:    Date: 09/08/2001    
                                                                                
 -------------------------------------------------------------------------------
  Action: V                       Single     Begin: 01/01/1999     Screen 2 of 2
                                               End: 12/31/2099                  
                                                                                
                                  ------ Withholding ------      of Excess      
        Start       Through         Amount    +  Percentage         Over        
     ----------    ----------     -----------    ----------      ----------     
           0.01      2,650.00                                                   
       2,650.01     27,300.00                      15.00 %         2,650.00     
      27,300.01     58,500.00        3,697.50      28.00 %        27,300.00     
      58,500.01    131,800.00       12,433.50      31.00 %        58,500.00     
     131,800.01    284,700.00       35,156.50      36.00 %       131,800.00     
     284,700.01          0.00       90,200.50      39.60 %       284,700.00     
           0.01                          0.00       0.00 %                      
                                                                                
   The Annual Amount of One Withholding Exemption:   2,750.00                   
                                                                                
   Updated: 05/13/1999 17:26 By: PAY04    Jennifer C. Carey                     
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit                    PrevS NextR                          
  

The following sections describe the EFIT (Employee Federal Income Tax) function:

"Purpose"
"Key Fields Required in the Banner"
"Valid Actions"
"Validations"
"Processing"

Purpose

EFIT is an effective dated table used by the University of Arkansas Payroll office to maintain the Federal taxing controls for the University payrolls. The information for the table is provided at least yearly by the Internal Revenue Service. Federal tax tables (Married and Single) are updated here. The Federal tables are maintained using the "annual" method. The calculation for a particular payroll is dependent upon whether the payroll is monthly, semi-monthly, or supplemental.

Key Fields Required in the Banner

Valid Actions

Validations

Processing

A table is maintained using the formulas provided at least annually by the appropriate taxing authority. An "add" will be used initially to enter the amounts into the tables. After the initial "add", an "update" will be used to change amounts. The tables will be available for users to view. The date and User ID of the person who updated the tables will be available in the system. The Annual table provided in Circular E (IRS Employer Publication) will be used for the table entries. The calculation for federal tax is done from the standard IRS formula. Supplemental pay will use the "look back" method to calculate taxes as defined by the IRS.

ARkansas State Income tax

Figure 26. ARSI


   Next Record after ARSI 05/13/1998 retrieved               ARSI 03/22/99 14:08
  Command:      Action: V Emp ID:             Comp Type:    Date: 01/17/1999
 
 -------------------------------------------------------------------------------
  Action: V                                  Begin: 01/01/1999   Screen 1 of 2
                                               End: 01/17/1999
 
                                 ------ Withholding ------       of Excess
      Start         Through        Amount    +  Percentage          Over
   ----------     ----------     ----------     ----------       ----------
         0.00       3,000.00                        1.00 %             0.00
     3,000.01       6,000.00          30.00         2.50 %         3,000.00
     6,000.01       9,000.00         105.00         3.50 %         6,000.00
     9,000.01      15,000.00         210.00         4.50 %         9,000.00
    15,000.01      25,000.00         480.00         6.00 %        15,000.00
    25,000.01                      1,080.00         7.00 %        25,000.00
 
 
 
 
   Updated: 03/16/1999 16:32 By: MAZANTI
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit  DCode                   NextS
 ARSI 01/17/1999 displayed; press PF8 for next screen or enter new keys

Figure 27. ARSI2


  EPOARSI 1 TEST   ARkansas State Income Tax rate maint. - ARSI   03/22/99 14:09
  Command:      Action: V Emp ID:             Comp Type:    Date: 01/17/1999
 
 -------------------------------------------------------------------------------
  Action: V                                                      Screen 2 of 2
 
 
 
 
 
 
         Standard Deduction $ 2,000.00    Exemptions $ 20.00
 
 
 
         Special Rate Request Cd          Reduce By Percentage
         -----------------------          --------------------
                    1                             33.33 %
                    2                             66.66 %
 
 
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit                    PrevS NextR
 Please enter new key fields

The following sections describe the ARSI function:

"Purpose"
"Key Fields Required in the Banner"
"Valid Actions"
"Validations"
"Processing"

Purpose

ARSI is an effective dated table used by the University of Arkansas Payroll office to maintain the Arkansas State taxing controls for University payrolls. The information for the table is provide by the Arkansas Department of Finance and Administration. State tax table for (Married and Single) deductions are updated here. The Arkansas State tax table is maintained using the "annual" method. The calculation for a particular payroll is dependent upon whether the payroll is monthly, semi-monthly, or supplemental. The amount to be allowed for Arkansas State withholding exemptions are updated here also.

Key Fields Required in the Banner

Valid Actions

Validations

Processing

A table is maintained using the formulas provided by the appropriate Arkansas State taxing authority. An "add" will be used initially to enter the amounts into the tables. After the initial "add", an "update" will be used to change amounts. The tables will be available for users to view. The date and User ID of the person who updated the tables will be available in the system. The default method is the "look-back" method. The calculation for state tax is done from the standard State formula.

EIC - Earned Income Credit

Figure 28. EIC (Earned Income Credit Data, Single or Head of Household)


  EPOEIC  1 DEMO    Earned Income Credit data maintenance - EIC   06/18/04 16:02
  Command:      Action: V Emp ID:             Comp Type:    Date: 09/08/2001    
                                                                                
 -------------------------------------------------------------------------------
  Action: V  Type: 1 Single or Head of Household                                
                                                                  Screen 1 of 3
          Date Period Begin: 11/30/1998 Date Period End: 12/31/2099             
                                                                                
                                 ----Annual EIC Amount----       of Excess      
     Start          Through        Amount       Percentage          Over        
   ----------     ----------     ----------     ----------       ----------     
                    4,200                           20.400 %                    
      4,200        12,260          1,363                   %        4,200       
     12,260                        1,363            -9.588 %       12,260       
                                                           %                    
                                                           %                    
                                                                                
                                                                                
                                                                                
                  Maximum Wage for Eligibility:  26,473                         
   Updated: 07/07/1999 10:12 By: PBWS                                           
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit  DCode                   NextS                          
 

Figure 28. EIC (Earned Income Credit Data, one parent claiming credit)


  EPOEIC  1 DEMO    Earned Income Credit data maintenance - EIC   06/18/04 16:03
  Command:      Action: V Emp ID:             Comp Type:    Date: 09/08/2001    
                                                                                
 -------------------------------------------------------------------------------
  Action: V  Type: 2 Married without Spouse Filing Certificate                  
                                                                  Screen 2 of 3
          Date Period Begin: 11/30/1998 Date Period End: 12/31/2099             
                                                                                
                                 ----Annual EIC Amount----       of Excess      
     Start          Through        Amount       Percentage          Over        
   ----------     ----------     ----------     ----------       ----------     
                    4,200                           20.400 %                    
      4,200        12,260          1,363                   %        4,200       
     12,260                        1,363            -9.588 %       12,260       
                                                           %                    
                                                           %                    
                                                                                
                                                                                
                                                                                
                  Maximum Wage for Eligibility:  26,473                         
   Updated: 07/07/1999 10:12 By: PBWS                                           
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit                    PrevS NextS                          
 

Figure 29. EIC (Earned Income Credit Data, both parents claiming credit)


  EPOEIC  1 DEMO    Earned Income Credit data maintenance - EIC   06/18/04 16:04
  Command:      Action: V Emp ID:             Comp Type:    Date: 09/08/2001    
                                                                                
 -------------------------------------------------------------------------------
  Action: V  Type: 3 Married with Both Spouses Filing Certificate               
                                                                  Screen 3 of 3
          Date Period Begin: 11/30/1998 Date Period End: 12/31/2099             
                                                                                
                                 ----Annual EIC Amount----       of Excess      
     Start          Through        Amount       Percentage          Over        
   ----------     ----------     ----------     ----------       ----------     
                    3,340                           20.400 %                    
      3,340         6,130            681                   %        3,340       
      6,130                          681            -9.588 %        6,130       
                                                           %                    
                                                           %                    
                                                                                
                                                                                
                                                                                
                  Maximum Wage for Eligibility:  26,473                         
   Updated: 07/07/1999 10:12 By: PBWS                                           
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit                    PrevS NextR                          

The following sections describe the EIC (EIC data) function:

"Purpose"
"Key Fields Required in the Banner"
"Security and Access"
"Valid Actions"
"Validations"
"Processing"

Purpose

EIC is an effective dated table used by the University Payroll office to maintain the Advanced Earned Income Credit taxing controls for University payrolls. The information for the table is provided yearly by the Internal Revenue Service. The table contains the EIC salary limits and formulas for the calculations. This table uses the "annual" method and the calculation for a particular payroll is dependent upon whether the payroll is monthly, semi-monthly or supplemental.

Key Fields Required in the Banner

Security and Access

The Payroll Manager will have update access. Other Users will have view access.

Valid Actions

Validations

Processing


Advanced Earned Income Credit (EIC)

The advanced earned income credit is a special federal tax credit provided to qualifying low wage employees whereby their net pay for a payroll is increased by the amount of the credit. The funds for this come out of the federal income tax withheld from other employee's gross -- the University remits the difference in the federal income tax withheld and the EIC paid. This constitutes the advanced EIC since the credit is being advanced to the employee via our payroll process versus the employee waiting until their income tax has been filed for the year when the full Earned Income Credit can be claimed.

The employee must qualify and apply for EIC annually. To qualify the employee's salary must be below a defined limit and the employee must have an eligible child. There are two options: 1 - the employee is single or the employee is married and only one parent has applied for EIC, or 2 - the employee is married and both parents have applied for EIC. This EIC election will be defined on the Employee-BDOE-Setup with a Short-Comment of '1' or '2' indicating the appropriate option.

The calculation parameters for EIC are specified on command EIC where a maximum salary limit is defined (MSL) and a fixed amount (FA) and percentage (Pct) is defined for various salary ranges. The percentage is applied to the amount over the entry point to the salary range (EPSR). Currently there are three salary ranges but a maximum of 5 are permitted. Currently the first range (0 to 6680) has a zero fixed amount and a percentage, the second range has a fixed amount and a zero percentage, and the third range has a fixed amount and a negative percentage (the credit phases itself out the more you make). These parameters are defined separately for option 1 and option 2.

The EIC calculation is performed using the above parameters and the employee's option (1 or 2), current federal taxable wages (CFTW), YTD federal taxable wages (YFTW), and number of payroll periods in the year (NPPY). The following steps are performed:

  1. Check to see if the employee is over the salary limit. The current federal taxable wages (CFTW) are added to the YTD federal taxable wages and if these exceed the maximum salary limit (MSL) for EIC, the employee is no longer eligible. No further calculations are performed and the attribute ZEIC (Zero EIC) will be set on the Payroll-Summary file.
  2. Annualize the federal taxable wages (AFTW):

    AFTW = CFTW * NPPY

  3. Determine which parameters to use (FA and Pct), the entry point of the salary range (EPSR) based upon the AFTW and the defined salary ranges.
  4. Calculate an Annualized EIC amount (AEIC):

    AEIC = FA + (Pct * (AFTW - EPSR))

  5. If AEIC is less than or equal to zero no EIC will be taken but attribute ZEIC will be set on Payroll-Summary.
  6. Reduce the annual EIC to a current pay period basis -- calculate the current EIC amount (CEIC) to be added to the employee's net:

    CEIC = AEIC / NPPY

No other deductions are ever applied to the EIC amount. EIC will be held back until after all employee based deductions have been figured (including net based deductions) and then EIC will be added to the final employee net. In this manner, an employee with EIC will always receive a check for at least the amount of his or her EIC payment -- even when there are other deductions not taken that exceed this amount.


ARkansas State unemployment and Worker's compensation rates

Figure 31. ARSW


   Decoding has been performed                               ARSW 03/24/99 12:06
  Command:      Action: V Emp ID:             Comp Type:    Date: 08/29/1998
 
 -------------------------------------------------------------------------------
   Action: V  Date Period Begin: 05/20/1998 Date Period End: 12/19/1998
 
 
 
 
                Arkansas State Unemployment Rate is :  0.13
 
             Arkansas Worker's Compensation Rate is :  0.14
 
 
 
 
 
 
 
 Updated: 03/22/1999 By: MAZANTI
 
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit  DCode                   NextR
 Please enter new key fields

The following sections describe the ARSW function:

"Purpose"
"Key Fields Required in the Banner"
"Valid Actions"
"Validations"
. "Processing"

Purpose

ARSW is an effective dated table used by the University Payroll office to maintain state unemployment and worker's compensation taxing controls for University payrolls. The information for the table is provided by the Controller's office..

Key Fields Required in the Banner

Valid Actions

Validations

Processing

A table is maintained using the amounts provided at least annually by the Controller's Office. An "add" will be used initially to enter the amounts into the tables. After the initial "add", an "update" will be used to change amounts. The tables will be available for users to view. The date and User ID of the person who updated the tables will be available in the system.
Back to Contents

BDOE - Benefit, Deduction, Other earning, EIC

Figure 32. Benefit, Deduction, Other earning, EIC - BDOE



  EPOBDOE 1 DEMO  Benefit, Deduction, Other earning, Exemp - BDOE 06/21/04 15:16
  Command:      Action: V Emp ID:             Comp Type:    Date: 09/08/2001    
  BDOE Cd: ARSI                                                                 
 -------------------------------------------------------------------------------
   Action: V  BDOE Cd: ARSI Short Desc: Ark State Income Tax                    
                                                                                
 Long Desc: Arkansas State Income Tax                                           
 BDOE Type: ET  Category: 1  Status: A  Priority: 8    All or None code: N      
 Short Comment Use code: R   Base Pay Category codes:                           
                                                                                
                                 FIT    SIT    OAD    MED    WC     SUI         
 Tax exempt codes - exempt from:                                                
                                                                                
 CCC: 0102 01801-62-0000         Account: 00221007 Dept Catg: ARTAX    Check: N 
      HMRS-Employee Payroll               Ar Withholding Tax                    
 Payee Vendor ID:                                                               
                                                                                
 Comments:                                                                      
                                                                                
                                                                                
   Updated: 01/26/2004 09:08 by: PAY04    Jennifer C. Carey                     
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit  DCode                   NextR                          
 

The following sections describe the BDOE function:

"Purpose"
"Key Fields Required in the Banner"
"Valid Actions"
"Validations"
"Processing"

Purpose

The BDOE command is used exclusively by the Payroll office to establish a comprehensive listing and definition of the Uof A provided benefits, employee deductions, other taxable earnings, EIC and exempt wages. Access to this command is strictly controlled and update is restricted by command security, with internal reviews to be completed any time that an update is performed. Each code is defined by type, Active/Inactive Status, Extended Description, Benefit Category, Exempt from Withholding, Priority, Tax Exempt or Tax Deferred status.

Key Fields Required in the Banner

Valid Actions

Validations

Processing


Back to Contents

Pay Category

A goal of BASIS is to calculate and take the appropriate benefits and deductions without the extra effort required for special overrides. Problems resulted when appointed employees worked hourly, when nine month employees worked in the summer, and in most cases of supplemental pay. The design to address this involves categorizing the employee's gross pay and simultaneously defining the categories for which the various BDOEs are subject -- facilitating the automatic calculation of benefits and deductions.

The categorization of wages is primarily accomplished by the association of a Pay-Category with the various Compensation Types by which employees are paid. The following categories are currently used with the associated compensation types noted.

I (Insurance)

Insurance and all other deductions and benefits (including taxes) should be calculated on these earnings. These represent normal, periodic, recurring wages and are associated with compensation types SC, SG and SN.

N (Non-Insurance)

All non-insurance deductions and benefits (including taxes) should be calculated on these earnings. These wages are not subject to insurance deductions since they represent some type of special non-recurring compensation or compensation for which insurance benefits are not provided. Category N earnings are associated with compensation types GR, GT, Hn, SR, ST, Sn and Wn.

R (Retirement)

Employee and employer portions of retirement, taxes, and possibly some other selective deductions or benefits are calculated on these wages. These wages are even more selective and have been separated from category N primarily to exclude garnishments. The associated compensation types are AL and LS.

E (EE Retirement)

Employee retirement contributions and taxes are the only benefits and deductions to be calculated on these wages which are associated with overtime (compensation type On) and in the special circumstance (exception) noted below.

T (Taxes only)

Only taxes are to be calculated on these wages as defined by compensation types SA, SL, SP, XC, XN and XS.

There are three exceptions that override the assignment of the pay category based upon the compensation type.
  1. If an appointed employee is compensated for any hourly work, the category for those wages is automatically downgraded to an E.
  2. When entering supplemental pay on SUPP, the operator is required to indicate whether this is true supplemental pay. If it is supplemental pay and the category would have been an I or an N, it will be changed to an R. This would be desired when processing a retroactive salary change where only the difference in pay is being made.
  3. Nine month employees are paid a half month in August and another half month in May. However, they pay a full month's insurance premium in May and none in August. Therefore, a nine month employee paid on the end of month August payroll in a category that would have been an I will have the category changed to an N.

Each BDOE defines the pay categories to which the BDOE is subject. If there are no wages in the corresponding pay categories for a defined BDOE, no benefit or deduction will be calculated for that payroll. If there are wages and a P (percent of pay category) method is defined, then the BDOE amount will be calculated using only the associated pay category amounts.


Back to Contents

LBST - List Bdoes for a Status & Type

Figure 33. LBST (List Bdoes for a Status & Type)



  EPOLBST 1 DEMO       List Bdoes for a Status & Type - LBST      
  Command:      Action: V Emp ID:             Comp Type:    Date: 09/08/2001    
   BDOE Cd: 15   BDOE Status: A BDOE Type: ET                                   
 -------------------------------------------------------------------------------
          List BDOEs by priority for BDOE status: A and BDOE type: ET           
                                                                                
         BDOE                            Base Pay  BDOE  Shrt Com  All  Check   
    Cmd   Cd  Description          Prty  Cat Codes Catg   Use Cd   None  code   
  - ---- ---- -------------------- ----  --------- ----  -------- ----- -----   
    BDOE EOAS Emplyee OASDI Tax       5              1       N      N     N     
    BDOE EMED Emplye Medicare Tax     6              1       N      N     N     
    BDOE EFIT Emp Federal Inc Tax     7              1       R      N     N     
    BDOE ARSI Ark State Income Tax    8              1       R      N     N     
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
             BDOE records     1 thru     4 of     4 displayed;                  
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit        RStrt                                            
 

The following sections describe the LBST function:

"Purpose"
"Key Fields Required in the Banner"
"Valid Actions"
"Validations"
"Processing"

Purpose

LBST allows the user to view BDOE setups by their status and types. When the list is returned to the BDOEs will be listed in priority order, if no priority exists it will be returned in BDOE code order. The list will contain the BDOE code, description, priority, base pay category code, BDOE type, short comment use code, all or none code, and check code. If more detail is required, the default suspend command will be BDOE.

Key Fields Required in the Banner

Back to Contents

LBSC - List Bdoes for a Status and Category

Figure 34. LBSC (List Bdoes for a Status and Category)


  EPOLBSC 1 DEMO    List Bdoes for a Status and Category - LBSC   
  Command:      Action: V Emp ID:             Comp Type:    Date: 09/08/2001    
   BDOE Cd: 15   BDOE Status: A BDOE Category: 1                                
 -------------------------------------------------------------------------------
               List BDOEs for BDOE status: A and BDOE Category: 1               
                                                                                
         BDOE                            Base Pay   BDOE  Shrt Com All  Check   
    Cmd   Cd  Description          Prty  Cat Codes  Type   Use Cd  None  code   
  - ---- ---- -------------------- ----  ---------  ----  -------- ---- -----   
    BDOE ARSI Ark State Income Tax    8              ET      R       N    N     
    BDOE ARSU Ark State Unemp Tax     3              RT      N            N     
    BDOE ARWC Ark Worker's Comp       4              RT      N            N     
    BDOE EFIT Emp Federal Inc Tax     7              ET      R       N    N     
    BDOE EMED Emplye Medicare Tax     6              ET      N       N    N     
    BDOE EOAS Emplyee OASDI Tax       5              ET      N       N    N     
    BDOE RMED Employr Medicare Tax    2              RT      N            N     
    BDOE ROAS Employr OASDI Tax       1              RT      N            N     
                                                                                
                                                                                
                                                                                
             BDOE records     1 thru     8 of     8 displayed;                  
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit        RStrt                                            
 

The following sections describe the LBSC function:

"Purpose"
"Key Fields Required in the Banner"
"Valid Actions"
"Validations"
"Processing"

Purpose

LBSC allows the user to view BDOE setups by their status and category. When the list is returned to the BDOEs will be listed by in BDOE code order. The list will contain the BDOE code, description, priority, base pay category code, BDOE type, short comment use code, all or none code, and check code. If more detail is required, the default suspend command will be BDOE.

Key Fields Required in the Banner

Back to Contents

BDSC - BDoe Short Comment

Figure 35. Data Entry screen - BDSC


   Next Record after BDOE cd: 76   Short Comment: retrieve BDSC 
  Command:      Action: V Emp ID:             Comp Type:    Date: 12/31/2099    
  BDOE Cd: 76    Short Comment: All Area Reserv                                 
 -------------------------------------------------------------------------------
  Action: V BDOE Cd: 76   Comment: All Area Reserv   BDOE Start Date: 11/10/1998
   BDOE desc: Parking Permit                           BDOE End Date: 12/31/2099
                                                                                
   Tax Sheltered Equivalent BDOE: 7T                                            
                                                                                
                                                                                
   Short Comment rate code:   A                                                 
   Short Comment amount:      290.00000                                         
                                                                                
   Short Comment description: All Area Reserved                                 
                                                                                
   Comment:                                                                     
                                                                                
                                                                                
                                                                                
  Updated: 07/17/1999 10:51 By: PAY04                                           
    Ended: 01/02/0000 00:00 By:                                                 
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit  DCode                   NextR                          
 BDOE cd: 76   Short Comment: All Area Reserv for 12/31/99 displayed; please en
  

The following sections describe the BDSC function:

"Purpose"
"Key Fields Required in the Banner"
"Valid Actions"
"Validations"
"Processing"

Purpose

The BDSC (Bdoe Short Comment table) function is used to view and maintain the BDOE short comment values and rates. This function will also display for a non-tax sheltered BDOE it's tax sheltered equivalent BDOE. The data maintained will be stored on BDOE- Short-Comment file, and a thorough understanding of the data is required for the proper use of BDSC. The BDSC will be used by the Payroll and Benefits Departments of the University of Arkansas, with the security for those individuals to be setup through NSM function using command security. An example of the BDOEs having Short Comments are Medical insurance, Optional life and EIC.

Key Fields Required in the Banner

Valid Actions

Validations

Processing

The following processing is performed based upon the action.


Back to Contents

LSCD - List Short Comments for bdoe and Date

Figure 36. LSCD (List Short Comments for a bdoe and Date)


  EPOLSCD 1 DEMO  List Short Comments for a bdoe and Date - LSCD  
  Command:      Action: V Emp ID:             Comp Type:    Date: 12/31/2099    
   BDOE Cd: 76   Short Comment: All Area Reserv                                 
 -------------------------------------------------------------------------------
          List Short Comments for BDOE: 76   effective: 12/31/2099              
                                                                                
                             ---Effective  Period---   Rate  Short Comment      
      Cmd   Short Comment    Begin Date    End Date    Code     Amount          
  -   ----  ---------------  ----------   ----------   ----  -------------      
      BDSC  All Area Reserv  11/10/1998   12/31/2099     A      290.00000       
      BDSC  Commuter         11/10/1998   12/31/2099     A        7.00000       
      BDSC  Fac/Staff Reser  11/10/1998   12/31/2099     A      290.00000             
      BDSC  Garage All Area  11/10/1998   12/31/2099     A      413.00000       
      BDSC  Garage Res Resv  11/10/1998   12/31/2099     A      200.00000       
      BDSC  Garage Reserved  11/10/1998   12/31/2099     A      325.00000       
      BDSC  Motorcycle       11/10/1998   12/31/2099     A       20.00000       
                                                                                
   BDOE records     1 thru    10 displayed; 1    accessed, but not effective.   
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit        RStrt             Forwd                          

The following sections describe the LSCD function:

"Purpose"
"Key Fields Required in the Banner"

Purpose

LSCD allows the user to view short comments for a BDOE effective on the date and entered in the banner. The list will contain the short comment, effective begin and end date, rate code, short comment amount. If more detail is required, the default suspend command will be BDSC. The user can selectively expand or restrict the list by changing the Date, either to an earlier or later date.

Key Fields Required in the Banner

Back to Contents

LSCA - List Short Comments for a bdoe & All dates

Figure 37. LSCA (List Short Comments for a bdoe & All dates)


   EPOLSCA 1 DEMO  List Short Comments for a bdoe&All Dates - LSCA 
  Command:      Action: V Emp ID:             Comp Type:    Date: 12/31/2099    
   BDOE Cd: 76   Short Comment: All Area Reserv                                 
 -------------------------------------------------------------------------------
 List Short Comments for BDOE: 76   starting from short comment: All Area Reserv
                                                                                
                            ---Effective  Period---   Rate  Short Comment      
      Cmd   Short Comment    Begin Date    End Date    Code     Amount          
     ----  ---------------  ----------   ----------   ----  -------------      
      BDSC  All Area Reserv  11/10/1998   12/31/2099     A      290.00000       
      BDSC  Commuter         11/10/1998   12/31/2099     A        7.00000       
      BDSC  Fac/Staff Reser  11/10/1998   12/31/2099     A      290.00000       
      BDSC  Garage All Area  11/10/1998   12/31/2099     A      413.00000       
      BDSC  Garage Res Resv  11/10/1998   12/31/2099     A      200.00000       
      BDSC  Garage Reserved  11/10/1998   12/31/2099     A      325.00000       
                                                                                
             BDOE records     1 thru    10 of    17 displayed.                  
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit        RStrt             Forwd                          
 Select an entry, PF8 to page forward, or enter new keys                       

The following sections describe the LSCA function:

"Purpose"
"Key Fields Required in the Banner"

Purpose

LSCA allows the user to view short comments for a BDOE. The list will contain the short comment, effective begin and end date, rate code, short comment amount. If more detail is required, the default suspend command will be BDSC. The user can selectively expand or restrict the list by changing the Short Comment field.

Key Fields Required in the Banner

Back to Contents

EBDS - Employee BDoe Setup

Figure 59. Data Entry screen - EBDS


All entries are valid, press PF10 to Save
 EPOEBDS 1 TEST            Employee BDoe Setup - EBDS            03/29/99 16:40
 Command:      Action: U Emp ID: 100588      Comp Type:    Date: 12/31/2099
 BDOE Cd: 31    Payroll Type: EA
------------------------------------------------------------------------------
 Action: U Emp ID: 100588 BDOE Cd: 31   Tiaa/Cref Matched Deduction Tax Deff
 Emp Name: Brody, Myron R                                      Screen: 1 of  1
 
                                                 BDOE Start Date: 05/01/1998
                                                   BDOE End Date: 12/31/2099
   BDOE Determination Method Cd: P
   BDOE Setup Monthly Amount:
   BDOE Setup Percentage:    10.00
   BDOE Goal Amount:
   BDOE Actual Amount:
 
   Short Comment:
 
 Comment:
 
 
 Updated: 03/05/1999 15:20 By: EPBCDOE
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--
      Help  Suspd Quit  DCode RStrt             NextR       Save

The following sections describe the EBDS function:

"Purpose"
"Key Fields Required in the Banner"
"Valid Actions"
"Validations"
"Processing"

Purpose

The EBDS (Employee BDoe Setup) function is used to view and maintain an employee's benefits, deductions, other earnings, and EIC setup. This setup consist of the rules and amounts for determining specific employee BDOEs for future payrolls. It should be used for long term or recurring BDOEs. One time BDOE amounts should be specified on EBDO(Employee BDOE Override). The data maintained is stored on the Employee-BDOE-Setup file and a thorough understanding of the data elements of this file is required for the proper use of EBDS. The EBDS command will be used by University of Arkansas Payroll, Benefits and other selective administrative departments. (Special security setup is required through NSM for individuals to access this command.) The types of deductions to be maintained on this command include parking hang tags, parking tickets, HPER memberships, garnishments and long term overrides for insurance. Similarly, long term overrides for benefits can be specified here, as are other taxable wages such as housing allowances. Even EIC is defined here for the one year eligibility period. On the other hand, taxes and exempt wages for OASDI, Medicare, Worker's Comp or State Unemployment are not entered on EBDS.

Key Fields Required in the Banner

Valid Actions

Validations

Processing

The following processing is performed based upon the action:

Back to Contents

Pay Category

A goal of BASIS is to calculate and take the appropriate benefits and deductions without the extra effort required for special overrides. Problems resulted when appointed employees worked hourly, when nine month employees worked in the summer, and in most cases of supplemental pay. The design to address this involves categorizing the employee's gross pay and simultaneously defining the categories for which the various BDOEs are subject -- facilitating the automatic calculation of benefits and deductions.

The categorization of wages is primarily accomplished by the association of a Pay-Category with the various Compensation Types by which employees are paid. The following categories are currently used with the associated compensation types noted.

I (Insurance)

Insurance and all other deductions and benefits (including taxes) should be calculated on these earnings. These represent normal, periodic, recurring wages and are associated with compensation types SC, SG and SN.

N (Non-Insurance)

All non-insurance deductions and benefits (including taxes) should be calculated on these earnings. These wages are not subject to insurance deductions since they represent some type of special non-recurring compensation or compensation for which insurance benefits are not provided. Category N earnings are associated with compensation types GR, GT, Hn, SR, ST, Sn, and Wn.

R (Retirement)

Employee and employer portions of retirement, taxes and possibly some other selective deductions or benefits are calculated on these wages. These wages are even more selective and have been separated from category N primarily to exclude garnishments. The associated compensation types are AL and LS.

E (EE Retirement)

Employee retirement contributions and taxes are the only benefits and deductions to be calculated on these wages which are associated with overtime (compensation type On) and in the special circumstance (exception) noted below.

T (Taxes only)

Only taxes are to be calculated on these wages as defined by compensation types SA, SL, SP, XC, XN, and XS.

There are three exceptions that override the assignment of the pay category based upon the compensation type.

  1. If an appointed employee is compensated for any hourly work, the category for those wages is automatically downgraded to an E.
  2. When entering supplemental pay on SUPP, the operator is required to indicate whether this is true supplemental pay. If it is supplemental pay and the category would have been an I or an N, it will be changed to an R. This would be desired when processing a retroactive salary change where only the difference in pay is being made.
  3. Nine month employees are paid a half month in August and another half month in May. However, they pay a full month's insurance premium in May and none in August. Therefore, a nine month employee paid on the end of month August payroll in a category that would have been an I will have the category changed to an N.

Each BDOE defines the pay categories to which the BDOE is subject. If there are no wages in the corresponding pay categories for a defined BDOE, no benefit or deduction will be calculated for that payroll. If there are wages and a P (percent of pay category) method is defined, then the BDOE amount will be calculated using only the associated pay category amounts.

Back to Contents

LBSE - List Bdoes Setups for an Employee

Figure 60. LBSE (List Bdoes Setups for an Employee)


  EPOLBSE 1 TEST   List Bdoe Setups for an Employee - all - LBSE  04/07/99 11:07
  Command:      Action: V Emp ID: 123456      Comp Type:    Date: 05/13/1998
   BDOE Cd: C1    Payroll Type:
 -------------------------------------------------------------------------------
    List BDOEs setup for Emp ID: 123456  Jones, Jack/T
             starting from BDOE: C1
    BDOE                   Begin      End      Amt or Pct  Deducted   Total Amt
     Cd  Description       Date       Date     Ea Payroll  to Date    to Deduct
  - ---- --------------- ---------- ---------- ---------- ----------  ---------
  _ C1   Child Support G 06/01/1998 12/31/2099 $   225.00
  _ 7T   Parking Pemit 1 08/15/1998 12/31/2099
  _ 8H   HPER Membership 08/01/1998 12/31/1998 $    35.50
  _ 8W   AAUP-AM Associa 09/01/1998 05/15/1999 $    45.00
 
 
 
 
 
  Select/suspend to Cmd: EBDS
             BDOE records 1     thru 4     of 4     records.
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit        RStrt
 Select an entry, or enter new keys

Purpose

LBSE allows the user to view BDOE setups for an employee. When the list is returned to the BDOEs will be listed in BDOE code order. The list will contain the BDOE code, description, begin and end date date, amt or percent for each payroll, deducted to date (YTD amount) and total amount to deduct (goal amount). If more detail is required, the default suspend command will be EBDS. If the employee has several BDOE setups, the user can selectively expand or restrict the list by changing the BDOE Code, or removing the BDOE code from the banner.

Key Fields Required in the Banner

Back to Contents

LBSD - List Bdoes Setups for an Empl for a Date

Figure 61. LBSD (List Bdoes Setups for an Emp for a Date)


  EPOLBSD 1 TEST   List Bdoe Setups for an Emp for a Date - LBSD  04/07/99 11:14
  Command:      Action: V Emp ID: 923456      Comp Type:    Date: 12/31/1998
   BDOE Cd: C1    Payroll Type:
 -------------------------------------------------------------------------------
    List BDOEs setup for Emp ID: 923456  Jones, Jack/T
                   effective on: 12/31/1998
    BDOE                   Begin      End      Amt or Pct  Deducted   Total Amt
     Cd  Description       Date       Date     Ea Payroll  to Date    to Deduct
  - ---- --------------- ---------- ---------- ---------- ----------  ---------
  _ C1   Child Support G 06/01/1998 12/31/2099 $   225.00
  _ 7T   Parking Pemit 1 08/15/1998 12/31/2099
  _ 8H   HPER Membership 08/01/1998 12/31/1998 $    35.50
  _ 8W   AAUP-AM Associa 09/01/1998 05/15/1999 $    45.00
 
 
 
 
  Select/suspend to cmd: EBDS
   BDOE records     1 thru     4 displayed;       accessed but not effective.
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit        RStrt
 Select an entry, or enter new keys

Purpose

LBSD allows the user to view BDOE setups for an employee effective on the date entered in the banner. The list will contain the BDOE code, description, begin and end date, amt or percent for each payroll, deducted to date (YTD amount) and total amount to deduct (goal amount). If more detail is required, the default suspend command will be EBDS. The user can selectively expand or restrict the list by changing the date.

Key Fields Required in the Banner

Back to Contents

EBDO - Employee BDoe Override

Figure 62. Data Entry screen - EBDO


  EPOEBDO 1 TEST           Employee BDoe Override - EBDO
  Command:      Action: V Emp ID: 923456     Comp Type:    Date: 06/30/1998
  BDOE CD: 7T    Payroll Type: M
 -------------------------------------------------------------------------------
  Action: V Employee: Jones, Jack/T
  BDOE cd: 7T Parking Permit 125
 
         BDOE override type: R
         BDOE override amount: 15
 
         BDOE Short Comment: Blue
 
  Comment:
  New employee paying June portion of parking permit as per parking
  memo on file in payroll office.
 
 
 
 
   Updated: 06/16/1998 13:15 By: Pay04 Jennifer Carey
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit                          NextR

The following sections describe the EBDO function:

"Purpose"
"Key Fields Required in the Banner"
"Valid Actions"
"Validations"
"Processing"

Purpose

The EBDO (Employee BDoe Overrride) function is used to view and establish a one time override amount for employee benefits, deductions, other earnings and taxes. The data maintained is stored on the Employee-BDOE-Override file and thorough understanding of the data elements of this file is required for the proper use of EBDO. The EBDO command will be use by the University of Arkansas Payroll and Benefits departments with the security for those individuals to be setup through the NSM function using command security. The types of deductions that can be overridden on this command include discounted athletic tickets, employee deductions, employer benefits and employee taxes.

Key Fields Required in the Banner

Valid Actions

Validations

Processing

The following processing is performed based upon the action.

Back to Contents

LBOE - List Bdoes Override for an Employee

Figure 63. LBOE (List Bdoe Override for an Employee)


  EPOLBOE 1 TEST    List Bdoe Overrides for an Employee - LBOE    04/07/99 16:26
  Command:      Action: V Emp ID: 123456      Comp Type:    Date: 08/31/1998
   BDOE Cd:       Payroll Type: M
 -------------------------------------------------------------------------------
   List BDOE Overrides for Emp ID: 923456 Tree, Jack/T
             for Payroll Type: M  and Pay Date: 08/31/1998
         BDOE
    Cmd   Cd  Description                      Type   Amount
  - ---- ---- --------------------             ---- -----------
  _ EBDO EIC  Earned Income Credit               R      500.00
  _ EBDO EOAS Emplyee OASDI Tax                  I       99.99
 
 
 
 
 
 
 
 
                 BDOE records     1 thru     2 of     2 displayed
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit       RStrt
 Select an entry, or enter new keys

Purpose

LBOE allows the user to view overrides for an employee effective for a specific payroll date and type. The list will contain BDOE code, description, type of override code and amount of override. If more detail is required, the default suspend command will be EBDO.

Key Fields Required in the Banner


LBO - List Bdoes Overriden for a payroll

Figure 64. LBO (List Bdoe Overriden for a payroll)


  EPOLBO  1 DEMO     List Bdoes Overriden for a payroll - LBO     
  Command:      Action: V Emp ID: 101400      Comp Type:    Date: 09/30/1999    
  BDOE Cd:       Payroll Type:                                                  
 -------------------------------------------------------------------------------
               List BDOE Overrides starting from: 09/30/1999                    
                                                                                
         Payroll Date Payroll   BDOE                                            
    Cmd   Type     Override      Cd  Description           Count                
  - ---- ------- ------------   ---- --------------------  -----                
  _ LBOB    M     09/30/1999    GAEE GA Insurance Employe      1                
  _ LBOB    M     09/30/1999    GAER GA Insurance Emplyr       1                
  _ LBOB    M     09/30/1999    17   Foundation Payments       4                
  _ LBOB    M     05/31/2000    EIC  Earned Income Credit      1                
  _ LBOB    M     05/31/2000    5Z   Employer Fidelity         1                
  _ LBOB    M     05/31/2000    59   Employer TIAA/CREF        5                
  _ LBOB    M     06/30/2000    5Z   Employer Fidelity         4                
  _ LBOB    M     06/30/2000    59   Employer TIAA/CREF        2                
  _ LBOB    O     01/15/2004    LF   Library Fines             1                
  _ LBOB    O     01/15/2004    33   Tiaa/Cref SRA             1                
                                                                                
                        BDOE records     1 thru    10                           
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit        RStrt                                            
 

Purpose

LBO allows the user to view overrides effective on or after a date. The list will contain payroll type, payroll date, BDOE code, description, and number of overrides for a particular payroll. By changing the date in the banner, the user can increase or decrease the number of overrides listed. If more detail is required, the default suspend command will be LBOB.

Key Fields Required in the Banner


LBOB - List Bdoes Override for a Bdoe and payroll

Figure 65. LBOB (List Bdoe Override for a Bdoe and payroll)


  EPOLBOB 1 DEMO  List Bdoe Overrides for a Bdoe & payroll - LBOB 06/22/04 14:48
  Command:      Action: V Emp ID: 101400      Comp Type:    Date: 09/30/1999    
  BDOE Cd: GAER  Payroll Type: M                                                
 -------------------------------------------------------------------------------
 List BDOE Overrides for BDOE: GAER for Pay Date: 09/30/1999 & Payroll Type: M 
                                                                                
                                           ----Override----                     
    Cmd   Emp ID Emp Name                  Type    Amount                       
  - ----  ------ ------------------------- ---- -----------                     
  _ EBDO  999771 Tree, John                 I        16.94                     
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                 BDOE records     1 thru     1 of     1 displayed               
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit        RStrt                                            
 Select an entry, or enter new keys                                            
  

Purpose

LBOB allows the user to view overrides for a BDOE effective for a specific payroll date and type. The list will contain BDOE code, description, type of override code and amount of override. If more detail is required, the default suspend command will be EBDO.

Key Fields Required in the Banner


LBOU - List Bdoes Override Unattempted

Figure 66. LBOU (List Bdoe Override Unattempted)


  EPOLBOU 1 TEST      List Bdoe Overrides Unattempted - LBOU      04/07/99 16:28
  Command:      Action: V Emp ID: 100392      Comp Type:    Date: 08/31/1998
  BDOE Cd: EIC   Payroll Type: M
 -------------------------------------------------------------------------------
 List Unattempted BDOE Overrides for Pay Date: 08/31/1998 & Payroll Type M
 
         BDOE                                                  ----Override----
    Cmd   Cd  Description     Emp ID Emp Name                  Type   Amount
  - ---- ---- -------------   ------ ------------------------- ---- -----------
  _ EBDO EOAS Emplyee OASDI T 999392 Tree, Harold/C              I       99.99
  _ EBDO EIC  Earned Income C 999392 Tree, Harold/C              R      500.00
  _ EBDO 8W   AAUP-AM Associa 999715 Tree, Peter                 R       50.00
  _
  _
  _
  _
  _
  _
  _
 
                 BDOE records     1 thru     3 of     3 displayed
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit  DCode RStrt
 Select an entry, or enter new keys

Purpose

LBOU allows the user to view overrides unattempted for a payroll date and type. A BDOE is only unattempted if the employee is not paid on the payroll or the payroll has not yet run. The list will contain BDOE code, description, Employee Id, Employee name, override type and override amount. If more detail is required, the default suspend command will be EBDO.

Key Fields Required in the Banner


PADJ - Payroll ADJustments

Figure 67. Data Entry Screen - PADJ


  EPOPADJ 1 TEST             Payroll ADJustment - PADJ            
  Command:      Action: A Emp ID: 999484      Comp Type: SC Date: 01/01/1999
  Adj Type: CR  Paid: 01/31/1999 Adj No:
 -------------------------------------------------------------------------------
 Action: A Emp: 999484 Tree, Susan D.         Comp Type: SC     Screen 1 of 2
 Adj No:         Type: CR  Cash receipt Comp Period: 01/01/1999 - 01/31/1999
 Processed on:             Original Pay Date: 01/31/1999 1999
    BU: ENGR                      Position: 206   Appointment Period: 12
        ENGINEERING               Occ: R010
  Regular                        Wage Base    EE Taxes    ER Taxes ____Hours____
  Earnings:   -1,722.75 Fed IT   -1,521.47                         Reg:
 - EE Taxes     -312.64 Ark IT   -1,521.47                         OT:
 - EE Deds      -201.78 OASDI    -1,722.75
 + EIC                  Medica   -1,722.75                         Student:
            =========== Ark WC   -1,722.75                         Federal:
 = EE Net     -1,208.33 ArkSUI   -1,722.75                         Alien:
 
 Attr:
 CCC:   0112 02146-62-0000                                        Pct: 58.04673
 Notes:
 Entered                by
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit        RStrt             NextS CCC
 Enter values and press ENTER to validate
 

Figure 68. Pop-up window for cost center distribution on PADJ


  EPOPADJ 1 TEST             Payroll ADJustment - PADJ            
  Command:      Action: A Emp ID: 999484      Comp Type: SC Date: 01/01/1999
  Adj Type: CR  Paid: 01/31/1999 Adj No:
 -------------------------------------------------------------------------------
 Action: A Emp: 999484 Tree, Susan D.         Comp Type: SC     Screen 1 of 2
 Adj No:         Type: CR  Cash receipt Comp Period: 01/01/1999 - 01/31/1999
 Processed on:             Original Pay Date: 01/31/1999 1999
    BU: ENGR                      Position: 206   Appointment Period: 12
                        Company Cost Center Distribution
    Co. Cost Center    Description                         Percent    Amount
    0112 02146-62-0000                                     58.04673  -1,000.00
    0102 15020-12-0000                                     41.95327    -722.75
 
 
 
 
 
 
 
 
      _ Specify distribution by amount                               -1,722.75
   PF1=Help   PF3=Quit                                     PF10=Sav/Q
   Enter data; press ENTER to validate or PF10 to save
 

Figure 69. Second screen for PADJ


  EPOPADJ 1 TEST             Payroll ADJustment - PADJ            
  Command:      Action: A Emp ID: 999484      Comp Type: SC Date: 01/01/1999
  Adj Type: CR  Paid: 01/31/1999 Adj No:
 -------------------------------------------------------------------------------
 Action: A Emp: 999484 Tree, Susan D.         Comp Type: SC     Screen 2 of 2
 Adj No:         Type: CR  Cash receipt Comp Period: 01/01/1999 - 01/31/1999
 
  Type       Code Description               Amount
  EE Tax     EOAS Emplyee OASDI Tax        -103.99
             EMED Emplye Medicare Tax       -24.32
             EFIT Emp Federal Inc Tax      -140.77
             ARSI Ark State Income Tax      -43.56
  Deduction  31   TIAA-CREF Matched TS     -167.73
             32   Tiaa/Cref NM Reduct       -33.55
             ADD Accidental Death&Dis    -0.50
  ER Tax     ROAS Employr OASDI Tax        -103.99
             RMED Employr Medicare Tax      -24.32
             ARSU Ark State Unemp Tax        -2.35
 
                          BDOEs 1  thru 10 of 14
 
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit        RStrt Upd   PrevS Forwd CCC
 Enter data and press ENTER to validate

Figure 70. Pop-up window for BDOE entry and update on PADJ


  EPOPADJ 1 TEST             Payroll ADJustment - PADJ            
  Command:      Action: A Emp ID: 999484      Comp Type: SC Date: 01/01/1999
  Adj Type: CR  Paid: 01/31/1999 Adj No:
 -------------------------------------------------------------------------------
 Action: A Emp: 999484 Tree, Susan D.         Comp Type: SC     Screen 2 of 2
 Adj No:         Type: CR  Cash receipt Comp Period: 01/01/1999 - 01/31/1999
 
  Type       Code Description                 BDOE Entry and Update
  EE Tax     EOAS Emplyee OASDI     BDOE Type Description              Amount
             EMED Emplye Medicar    66                                  -5.46
             EFIT Emp Federal In    70                                  -3.50
             ARSI Ark State Inco    AD&D                            -0.50
  Deduction  31   TIAA-CREF Matc    59                                -167.73
             32   Tiaa/Cref NM R    31                                -167.73
             AD&D Accidental Dea32                                 -33.55
  ER Tax     ROAS Employr OASDI     EFIT                              -140.77
             RMED Employr Medica    ARSI                               -43.56
             ARSU Ark State Unem    EOAS                              -103.99
                                    EMED                               -24.32
                          BDOEs               BDOEs  1  thru  10
                                   PF1   PF3          PF7   PF8       PF10
 Enter-PF1---PF2---PF3---PF4---P   Help  Quit               Forwd     Sav/Q
       Help  Suspd Quit        R   Enter data; press ENTER to validate
 Enter data and press ENTER to v

Figure 71. Pop-up window for PF11 on PADJ


  EPOPADJ 1 TEST             Payroll ADJustment - PADJ            
  Command:      Action: A Emp ID: 999202      Comp Type: SN Paid: 04/06/1999
  Adj Type: TYP Period Begin: 02/01/1999 Adj No:
 -------------------------------------------------------------------------------
 Action: A Emp: 999202 Treeman, Mark         Comp Type: SN     Screen 2 of 2
 Adj No:         Type: TYP Typed check  Comp Period: 02/01/1999 - 02/15/1999
  ______________________________ BDOE ____________________________
  Type       Code Description          Short Comment        Amount
                                        Tax and BDOE Calculation Options
 
                                                             __Pay Category__
                                  Payroll Date: 04/06/1999   Code      Amount
                                          Type: M              I      1500.00
                                                               N
                                  Supplemental Pay (Y/N):      R
                                                               E
                                                               T
                                                                   ----------
                                                                      1500.00
                          BDOEs
                                  PF1   PF3                            PF10
 Enter-PF1---PF2---PF3---PF4---   Help  Quit                           CalcB
       Help  Suspd Quit           Press PF3 to quit or PF10 to Calc
 Enter data and press ENTER to

The following sections describe the Payroll Adjustment function:

"Purpose"
"Access and Security"
"Key Fields Required in the Banner"
"Valid Actions"
"Validations"
"Processing"
"List of Deductions"

Purpose

The Payroll ADJustment (PADJ) function is used in order to process corrections to an employee's pay and thereby, his W2 record. These adjustments are also loaded into LABOR and general ledger so that these records reconcile with the payroll records. These include:

Access and Security

The Payroll Office will initiate these changes via PADJ. Selected users in Human Resources Department will have view access.

Key Fields Required in the Banner

Valid Actions

Validations

Common validations

Cash receipt validations

Refunds validations

Typed vouchers validations

Petty Cash validations

Reversal validations

Processing

Typed Vouchers

The system will generate the Gross-to-Net calculation based on the employee information and existing BDOEs from all sources. These values will be defaulted. The user will be allowed to make adjustments to all existing BDOE's.

Cash Receipt

Existing BDOEs from PSUM, based on the date paid in the banner, will be defaulted in a pop-up screen for ease in adjusting values. All BDOE amounts will be negative or positive.

Petty Cash

This type adjustment is used to record, for W-2 purposes, payments that have been made "in-the-field" to temporary workers.

Refunds

The amount of an employee deduction or tax is decreased (refunded) and the net pay of the employee is increased by the amount of the refund.

Reversals

This type of adjustment is used to rectify:

List of Deductions

Command BDOE will be maintained by the payroll office with all BDOEs and the designation of whether they are Employee Deductions or Taxes, Employer Benefits or Taxes, Other Earnings, Exempt Wages or EIC. This list will be used by the system to determine which BDOEs to use when validating Employee Deductions as described in the "Validations" section. Information exists here as to what a BDOE is "exempt from or for". This information is used in calculating the taxable wage bases.


CANT - Cancel or Transfer

Figure 67. Data Entry Screen - CANT


  EPOCANT 1 DEMO             CANcel or Transfer - CANT            
  Command:      Action: A Emp ID: 100751      Comp Type: SN Date: 09/30/1999    
  Payroll Type: M  Calendar Yr: 1999 Adj Seq No:   Adj Type: CAN Adj No:        
 -------------------------------------------------------------------------------
 Action: A Year: 1999 Emp: 100751 Tree, Brian W.                   Screen 1 of 2
 Adj No:                                                                        
   Type: CAN          Original Payroll: 09/30/1999 Type: M  Adj Seq No: 0 CT: SN
   Date: 12/30/2099               Paid: 09/30/1999 Period: 09/01/99 - 09/30/99  
 BU: ENGL English                                            1 Source           
                                 Wage Base    EE Taxes    ER Taxes ____Hours____
  Earnings:    9,491.11 Fed IT    7,635.03    1,478.43             Reg:         
 - EE Taxes    2,618.35 Ark IT    7,635.03      463.62             OT:          
 - EE Deds     2,513.06 OASDI     8,840.40      548.11      548.11              
 + EIC                  Medica    8,840.40      128.19      128.19 Student:     
            =========== Ark WC    8,840.40                    5.31 Federal:     
 = EE Net      4,359.70 ArkSUI    8,840.40                    3.54 Alien:       
            ACH Payment                                                         
 Attr:                                                                          
 Notes: Dept input EE after monthly payroll run employee not due money          
                                                                                
 Entered                  by                                                    
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit        RStrt             NextS       Save               
 All entries are valid, press PF10 to Save                                     
   

Figure 68. Second Screen of CANT



  EPOCANT 1 DEMO             CANcel or Transfer - CANT            
  Command:      Action: A Emp ID: 100751      Comp Type: SN Date: 09/30/1999    
  Payroll Type: M  Calendar Yr: 1999 Adj Seq No:   Adj Type: CAN Adj No:        
 -------------------------------------------------------------------------------
 Action: A Year: 1999 Emp: 100751 Tree, Brian W.                   Screen 2 of 2
 Adj No:           Original Payroll Date: 09/30/1999 Type: M  Adj Seq No: 0     
   Type: CAN             Originally Paid: 09/30/1999 Period: 09/01/99 - 09/30/99
   Date: 12/30/2099                                                             
  ______________________________ BDOE ____________________________              
  Type       Code Description          Short Comment        Amount              
  EE Tax     EOAS Emplyee OASDI Tax                         548.11              
             EMED Emplye Medicare Tax                       128.19              
             EFIT Emp Federal Inc Tax                     1,478.43              
             ARSI Ark State Income Tax                      463.62              
  Deduction  LIFE Opt. Life Insurance                       611.04              
             31   TIAA-CREF Reduction                       949.11              
             32   Tiaa/Cref NM Reduct                       256.26              
             42   MSA Opt Life 2x sal                                           
             AD&D AD&D                                        6.00              
             D4   MSA Dep Life 20k                                              
                          BDOEs 1  thru 10 of 25                                
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit        RStrt       PrevS Forwd                          
 Go to screen 1 to validate data there                                         
  
 

The following sections describe the Cancel or Transfer function:

"Purpose"
"Access and Security"
"Key Fields Required in the Banner"
"Valid Actions"
"Validations"
"Processing"

Purpose

The cancel function of CANT is used in order to process a complete cancellation of an employee's pay and thereby, correct his W2 record. The transfer function of CANT is used in order to transfer employee's payment from one employee id number to other. These adjustments are also loaded into LABOR and general ledger so that these records reconcile with the payroll records.

Access and Security

The Payroll Office will initiate these changes in CANT. Selected users in Human Resources Department will have view access.

Key Fields Required in the Banner

Valid Actions

Validations

Cancel validations

Transfer validations

Processing


RP - Reissue Payment

Figure 30. Data Entry Screen - RP


 EPORP   1 DEMO               Reissue Payment - RP              
 Command:      Action: V Emp ID: 101400      Comp Type:    Date: 09/30/1999    
 Payment ID: 99876094  Check No:                                               
-------------------------------------------------------------------------------
 Action: V  Payment ID: 99876094    Type:   PC Payroll Check to Employee       
            Check No:   10002214    Status: IV                                 
                                    Amount:      3,847.32  Paid: 09/30/1999    
            Employee:   101400                          Cleared:               
                        Manger, Walt                                           
                                                                               
                                                                               
                                                                               
                                                                               
 Comment:                                                                      
  Account closed returned by bank                                              
                                                                               
                                                                               
 Original Iss: EPNBPLPM                                  on: 10/15/1999 15:31  
 Bank Recon'd:                                                                 
 Canceled:                                                                     
 Reissued:     PAY04                                         06/18/2004 16:17  
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Suspd Quit  DCode                   NextR                          

The following sections describe the RP (Reissue Payment ) function:

"Purpose"
"Access and Security"
"Key Fields Required in the Banner"
"Valid Actions"
"Validations"
"Processing"

Purpose

The RP (Reissue Payment) function is used to reissue a check to the employee, or to issue a check to the employee for an ACH payment which was returned from the bank.

Access and Security

Use of this function is restricted to the Payroll Manager or Payroll Manager's designee.

Key Fields Required in the Banner

Valid Actions

Validations

Processing

Entering a payment id or check number displays a payment record which includes the payment status, payment type, check number (there could be more than one occurrence of the check number, if the check had been reissued), check date, employee id, employee name, and any comments.

Reissuing a new check

Issuing a check from a payroll deposit


ATTR - ATTRibute Table

Figure 72. ATTRibute table - ATTR


 Press PF8 to view more records or enter new keys
  EPOATTR 1 DEMO              ATTRibute table - ATTR              04/15/97 08:13
  Command:      Action: V Emp ID:             Comp Type:    Date: 04/01/1997
  Attribute Type: PD Attribute Code: N
 -------------------------------------------------------------------------------
   Action: V  Attribute Type: PD Payroll Detail
              Attribute Code: N
                                                     Last
     Code     ----------- Description -----------   Updated  Updated By
 
     N        Non exempt extra compensation         03/31/97  PAY04
     RET      Early Retirement                      03/31/97  PAY04
     SERV     Service Award                         03/31/97  PAY04
     SS1      Summer Session 1                      03/31/97  PAY04
     SS2      Summer Session 2                      03/31/97  PAY04
     SS3      Summer Session 3                      03/31/97  PAY04
     SS4      Summer Session 4                      03/31/97  PAY04
     SS5      Summer Session 5                      03/31/97  PAY04
     SS6      Summer Session 6                      03/31/97  PAY04
     SS7      Summer Session 7                      03/31/97  PAY04
 
 
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit                          Forwd

The following sections describe the ATTR function:

"Purpose"
"Key Fields Required in the Banner"
"Valid Actions"
"Processing"

Purpose

The ATTR command is used by the Payroll Office to establish a coded list and definition of various types of payments and adjustments to previously paid amounts.

Key Fields Required in the Banner

Valid Actions

Processing

These attributes are used in conjunction with supplemental payments as a means of describing in better detail the type of payment being made. Additionally there are system assigned attributes which are assigned on any payroll when appropriate. The assigned attributes become keys to access records of a similar nature for display on a list. Some attributes, which are related to Extra Compensation Payments, are assigned by the system: These are:
C1= 1 Extra Comp Credit Hour
C2= 2 Extra Comp Credit Hours
C3= 3 Extra Comp Credit Hours
E= Exempt extra Compensation
N= Non-Exempt extra Compensation
The system will assign attributes to the payroll summary when normally scheduled deductions are not taken during the payroll process. These types include:
DNT= Deduction Not Taken
TSDN= Tax Sheltered Deduction Not taken

Additionally the user will assign appropriate attributes as descriptors for supplemental payments and for summer research. Currently defined attributes which must be used for summer research and summer teaching are:

BOTH= Joint Summer Research and Teaching
SS1= Summer Session I
SS2= Summer Session II
SS3= Summer Session III
SS4= Summer Session IV
SS5= Summer Session V
SS6= Summer Session VI
SS7= Summer Session VII
For adjustments, a different set of attributes will describe the reasons for making an adjustment to the employees pay record. For example:
INV= Invoice
403b= Compliance with Annuity 403b regs.
TRTY= Tax Treaty, Non-Resident Alien
Attributes may be defined on the table as the need to track specific types of payments and adjustments arises. However, since these records are retained, great care should be exercised in the assigning of these attributes.

PSUM - Payroll Summary

Figure 73. Payroll Summary - PSUM


  EPOPSUM 1 TEST              Payroll SUMmary - PSUM              07/19/99 15:02
  Command:      Action: V Emp ID: 102528      Comp Type: SN Date: 01/31/1999
  Adj Type:     Payroll Type: M  CY: 1999 Adj Seq No:
 -------------------------------------------------------------------------------
   Action: V Employee: 102528 Schwab, William A                    Screen 1 of 4
             CY: 1999 Paid: 01/31/99 Type: M  Adj Seq No:
 Pay Cat: I    5,771.75
                                 Wage Base    EE Taxes    ER Taxes ____Hours____
   EE Gross    5,771.75 Fed IT    4,965.62    1,144.22             Reg:
 - EE Taxes    1,848.33 Ark IT    4,965.62      280.09             OT:
 - EE Deds       880.53 OASDI     5,542.80      343.65      343.65
 + EIC                  Medica    5,542.80       80.37       80.37 Student:
            =========== Ark WC    5,542.80                    7.21 Federal:
 = EE Net      3,042.89 ArkSUI    5,542.80                    7.76 Alien:
 YTD Gross     5,771.75                                ===========
                                     ER Benefits-Taxes      438.99
 Attr:                                           Other      787.10
 
 
 Notes:
 
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit  DCode                   NextS

Figure 73a. Screen 2 of PSUM


 EPOPSUM 1 TEST              Payroll SUMmary - PSUM              07/19/99 15:03
 Command:      Action: V Emp ID: 102528      Comp Type: SN Date: 01/31/1999
 Adj Type:     Payroll Type: M  CY: 1999 Adj Seq No:
-------------------------------------------------------------------------------
  Action: V Employee: 102528 Schwab, William A                    Screen 2 of 4
            CY: 1999 Paid: 01/31/99 Type: M  Adj Seq No:
                                                                      Deduction
 Type       Code Description          Short Comment  Src     Amount   Not Taken
 EE Tax     EOAS Emplyee OASDI Tax                    T      343.65        0.00
            EMED Emplye Medicare Tax                  T       80.37        0.00
            EFIT Emp Federal Inc Tax  4 S  0   80.00  T    1,144.22        0.00
            ARSI Ark State Income Tax 0   0    0.00   T      280.09        0.00
 Deduction  LIFE Opt. Life Insurance  50-54 2X 139K   B       51.43        0.00
            31   TIAA-CREF Reduction  10.00 %         B      577.18        0.00
            ADD  Accidental Death&Dis Fam 150K    B        4.50        0.00
            4E   Medical Coverage 125 Ch  POS         B      128.95        0.00
            4F   Optional LTD         Over 20K        B       18.47        0.00
            5M   Flex Medical 125     1200 annual     B      100.00        0.00
 
                          BDOEs 1  thru 10 of 18
 
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit              YTD   PrevS Forwd
 Press PF8 to view next screen or enter new keys

Figure 73b. Year to Date PF6 key PSUM



  EPOPSUM 1 TEST              Payroll SUMmary - PSUM              07/19/99 15:06
  Command:      Action: V Emp ID: 102528      Comp Type: SN Date: 01/31/1999
  Adj Type:     Payroll Type: M  CY: 1999 Adj Seq No:
 -------------------------------------------------------------------------------
   Action: V Employee: 102528 Schwab, William A                    Screen 2 of 4
             CY: 1999 Paid: 01/31/99 Type: M  Adj Seq No:
                                                                          YTD
  Type       Code Description          Short Comment  Src     Amount     Amount
  EE Tax     EOAS Emplyee OASDI Tax                    T      343.65      343.65
             EMED Emplye Medicare Tax                  T       80.37       80.37
             EFIT Emp Federal Inc Tax  4 S  0   80.00  T    1,144.22     1144.22
             ARSI Ark State Income Tax 0   0    0.00   T      280.09      280.09
  Deduction  LIFE Opt. Life Insurance  50-54 2X 139K   B       51.43       51.43
             31   TIAA-CREF Reduction  10.00 %         B      577.18      577.18
             ADD  Accidental Death&Dis Fam 150K    B        4.50        4.50
             4E   Medical Coverage 125 Ch  POS         B      128.95      128.95
             4F   Optional LTD         Over 20K        B       18.47       18.47
             5M   Flex Medical 125     1200 annual     B      100.00      100.00
 
                          BDOEs 1  thru 10 of 18
 
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit              DNT   PrevS Forwd

Figure 73c. PSUM for Student Pay



  EPOPSUM 1 TEST              Payroll SUMmary - PSUM              07/19/99 15:18
  Command:      Action: V Emp ID: 114116      Comp Type: SN Date: 01/31/1999
  Adj Type:     Payroll Type: M  CY: 1999 Adj Seq No:
 -------------------------------------------------------------------------------
   Action: V Employee: 114116 Sloan, James C.                      Screen 1 of 4
             CY: 1999 Paid: 01/31/99 Type: M  Adj Seq No:
 Pay Cat: I      855.56
                                 Wage Base    EE Taxes    ER Taxes ____Hours____
   EE Gross      855.56 Fed IT      870.56       28.71             Reg:
 - EE Taxes       44.60 Ark IT      870.56       15.89             OT:
 - EE Deds              OASDI
 + EIC                  Medica                                     Student: Y
            =========== Ark WC      870.56                    1.13 Federal:
 = EE Net        810.96 ArkSUI                                     Alien:
 YTD Gross       855.56                                ===========
                                     ER Benefits-Taxes        1.13
 Attr:                                           Other
 
 
 Notes:
 
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit  DCode                   NextS

Figure 73d. Screen 2 Student Pay for PSUM



  EPOPSUM 1 TEST              Payroll SUMmary - PSUM              07/19/99 15:19
  Command:      Action: V Emp ID: 114116      Comp Type: SN Date: 01/31/1999
  Adj Type:     Payroll Type: M  CY: 1999 Adj Seq No:
 -------------------------------------------------------------------------------
   Action: V Employee: 114116 Sloan, James C.                      Screen 2 of 4
             CY: 1999 Paid: 01/31/99 Type: M  Adj Seq No:
                                                                       Deduction
  Type       Code Description          Short Comment  Src     Amount   Not Taken
  EE Tax     EFIT Emp Federal Inc Tax  0 S  2    0.00  T       28.71        0.00
             ARSI Ark State Income Tax 0   0    0.00   T       15.89        0.00
  ER Tax     ARWC Ark Worker's Comp                    T        1.13        0.00
  Other Earn 06   Other Earnings                       S       15.00        0.00
  ExemptWage EWME Medicare Exempt Wges                 T      870.56        0.00
             EWOA OASDI Exempt Wages                   T      870.56        0.00
             EWSU State Unemp ExmptWgs                 T      870.56        0.00
 
 
 
 
                          BDOEs 1  thru 7  of 7
 
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit              YTD   PrevS NextS

Figure 73e. PSUM Check Information



   Payment and check distribution information decoded        PSUM 07/19/99 15:22
  Command:      Action: V Emp ID: 101499      Comp Type: SN Date: 01/31/1999
  Adj Type:     Payroll Type: M  CY: 1999 Adj Seq No:
 -------------------------------------------------------------------------------
   Action: V Employee: 101499 Abel, Christopher M                  Screen 3 of 4
             CY: 1999 Paid: 01/31/99 Type: M  Adj Seq No:
 
  _____________________________Payment Information______________________________
  Bank                                      Acct          ---Payment--  Check
  Code Name              Account No         Type  Amount     ID     St  Number
                                                 1,539.82 99998607  I   10000800
 
 
 
 
 
 Check Distribution Override Code:                                ___Voucher___
 Check Distribution BU: 1067 COMP COMPUTING SERVICES              R    2,537.75
 
 
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit  DCode             PrevS NextS

Figure 73f. PSUM Direct Deposit Information



   Payment and check distribution information decoded        PSUM 07/19/99 15:21
  Command:      Action: V Emp ID: 900187      Comp Type: SN Date: 01/31/1999
  Adj Type:     Payroll Type: M  CY: 1999 Adj Seq No:
 -------------------------------------------------------------------------------
   Action: V Employee: 900187 Adams, Charles M                     Screen 3 of 4
             CY: 1999 Paid: 01/31/99 Type: M  Adj Seq No:
 
  _____________________________Payment Information______________________________
  Bank                                      Acct          ---Payment--  Check
  Code Name              Account No         Type  Amount     ID     St  Number
  95   UARK FEDERAL CRED 1206443294           S  1,325.79 99998263
 
 
 
 
 
 Check Distribution Override Code:                                ___Voucher___
 Check Distribution BU: 1027 ARSC ARTS & SCIENCES              R    1,698.33
 
 
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit  DCode             PrevS NextS

Figure 73g. Screen 4 of PSUM



  EPOPSUM 2 TEST              Payroll SUMmary - PSUM              07/19/99 15:25
  Command:      Action: V Emp ID: 102528      Comp Type: SN Date: 01/31/1999
  Adj Type:     Payroll Type: M  CY: 1999 Adj Seq No:
 -------------------------------------------------------------------------------
   Action: V Employee: 102528 Schwab, William A                    Screen 4 of 4
             CY: 1999 Paid: 01/31/99 Type: M  Adj Seq No:
 
     Gross Pay
   _by Category_  _______Benefits_______  Employee Pay Frequency:
   I    5,771.75  Annual Salary:  75,500
                  Appointment %:     100
                  Age:               49
                  12 over 9:
 
 
   ___________________________Audit Log Information__________________________
   Created       07/19/1999 15:18  EPNBPLPS
   PSUM update
   ACH process
   Check Writer
 
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit  DCode             PrevS Q/Nxt
 Please enter new key fields

The following sections describe the PSUM function:

"Purpose"
"Access and Security"
"Key Fields Required in the Banner"
"Valid Actions"
"Approval Routing"
"Validations"
"Special Report Rules for Adjustments"
"Processing"

Purpose

The PSUM provides an compressive summary of each payment made to an employee. Gross pay, Calculated Wages, Taxes and BDOEs are displayed for each record. The Pay categories which made up the pay are displayed, as well as the payroll voucher type. PSUM is "generated" through the load process as are PANN, LABOR, DART and the accounting detail. Reports are provided to verify salary, wage and BDOE amounts coming out of the payroll. PSUM is the "backbone" of our payroll system for generating reports including 941's and W-2s. PSUM also contains data pertaining to the distribution of the employee's money for each payday. The third screen shows the check number and the check status or the amount that went via ACH to each of the employee's bank accounts.

Access and Security

PSUM is available for use only by the Human Resources Office.

Key Fields Required in the Banner

Valid Actions

Approval Routing

There is no routing of PSUM as it is a historical record of payments to the employee.

Validations

Processing

The PANN file is a copy of the PSUM file for the first payroll of the calendar year. After that, each additional payroll creates a new PSUM which is added to the values on the PANN file creating a year-to-date summary. The pay date of the last payroll added to the PANN file will be displayed below the banner with the calendar year.

If at any time the Federal Status is set to a value, that value will be carried over to the PANN record. However, a blank value in the Federal status will not over-write a previously set status.

Update will only allow a comment to be created for the record, add or remove an attribute. One use of the comment might be to note that correct W-2 has been processed for an individual. Selected individuals in the payroll office will have update access to PSUM.

Special Report Rules for Adjustments.

There are special rules for the reports that come out of PSUM as they relate to the adjustments. Since we are able to create PADJ records for any year, strict attention must be paid to the Calendar Year which is a banner key field. If the Calendar Year is not equal to the current (or system date) calendar year, the adjustment figures will not be included in the Pay Summary for the current year.

Processing

In the same process, we load payroll information to LABOR and accounting. We also load the PSUM file. A UA Payment ID is assigned to each check or bank deposit that an employee receives. Initially the UA PAYMENT ID will have a status of P indicating that the issuance of the check is pending (ACH will have a blank status). By the user pressing the PF4 decode, the check number or bank information will be displayed. The check distribution BU will decode to it alpha characters and name. This is displayed on the third screen of PSUM. Check numbers assigned during the printing of the paychecks will be loaded to PSUM along with the status of I indicating a status of Issued. As the checks are cashed and reconciled on the UA payment file, the status will be changed again to reflect the appropriate

LPCD - List Payroll Summary for CY, Date, Type from name

Figure 74. LPCD (List Paysummary for CY, Date and Type from name0


  EPOLPCD 1 TEST  List Paysum for CY, Date, Type from name - LPCD 07/13/99 16:01
  Command:      Action: V Emp ID: 999001      Comp Type:    Date: 01/31/1999
  Payroll Type: M  Calendar Yr: 1999 Name:  BOUWMAN
 -------------------------------------------------------------------------------
 Pay Summary for CY: 99 Date: 01/31/1999 Type: M  starting from BOUWMAN
 
                                    PA
    Name                        ID  Sq  BU        Gross         Net S Alien Attr
  _ Bouwman, Mark J.          999202   1001       -0.93       -0.93         NEGG
  _ Bowlin, Sam               999357   1103    3,294.42    2,046.68         BENE
  _ Bowling, Diane S.         999484   1103    1,677.25    1,163.33         BENE
  _ Bowman, Martha            999922   1312    1,780.58    1,195.07         BENE
  _ Bowman, Thomas            999611   1094    2,903.42    2,103.38         BENE
  _ Boyle, Mark S             999620   1089    1,666.67    1,314.79         BENE
  _ Brecht, Sara L.           999309   1116    2,111.00    1,517.62         BENE
  _ Breedlove, K. Sandra      999294   1222    1,500.00    1,231.92         BENE
  _ Briggs, George  R.        999763   1155    1,772.83    1,357.57         BENE
  _ Britt, Juan               999311   1211    1,102.42      998.89         BENE
 Suspend to Cmd: PSUM
                 Employees     1 thru    10 of   290 are displayed
 
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit  DCode RStrt             Forwd
 Select an entry, PF8 to page forward, or enter new keys

Purpose

LPCD allows the user to view pay summary records for a pay date, payroll type and calendar year starting from a particular name. The list will contain employee ID, BU, gross pay, net pay, student status, alien status and payroll summary attribute. By pressing the PF4 key, the BU will decode to it's alpha equivalent. If more detail is required, the default suspend command will be PSUM.

Key Fields Required in the Banner


LPSD - List Payroll Summary Dates for an Attribute

Figure 75. LPSD (List Payroll Summary Dates of an Attr)


  EPOLPSD 1 TEST   List Payroll Summary Dates for an Attr - LPSD  11/22/99 14:39
  Command:      Action: V Emp ID:             Comp Type:    Date: 04/30/1999
  Attr: BENE
 -------------------------------------------------------------------------------
  Payroll Summary Dates for Attribute: BENE Benefits Eligible but Not Enrolled
                         on or before: 04/30/1999
 
     Cmd   Payroll Date  People Count
     ----  ------------  ------------
  _  LPSA   04/30/1999          121
  _  LPSA   03/31/1999          117
  _  LPSA   02/28/1999          116
  _  LPSA   02/25/1999            2
  _  LPSA   02/15/1999           10
  _  LPSA   02/10/1999            7
  _  LPSA   01/31/1999          114
 
 
 
 
                           Dates     1 thru     7
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit        RStrt
 Select an entry, or enter new keys

Purpose

LPSD allows the user to view attributes effective on or before a date. The list will contain command, payroll date and number of employees having a particular attribute of a payroll. By changing the date in the banner, the user can increase or decrease the number of payroll dates listed for an attribute. If more detail is required, the default suspend command will be LPSA.

Key Fields Required in the Banner


LPSA - List Payroll Summary for an Attr & Date

Figure 76. LPSA (List Payroll Summary for an Attr & Date)


   Suspended from LPSD                                       LPSA 12/21/99 11:41
  Command:      Action: V Emp ID:             Comp Type:    Date: 04/30/1999
  Attr: BENE Name:                  Payroll Type:    CY: 1999 Adj Seq No:
 -------------------------------------------------------------------------------
 Payroll Summary with Attribute: BENE Benefits Eligible but Not Enrolled
               for Payroll Date: 04/30/1999 starting with Name:
                                                 CkDist _Payroll_ Adj
    Emp ID Employee Name                   Gross   BU   Year Type Seq  Stu Alien
  _ 999499 Abel, Mark  C                2,537.75  1067  1999  M
  _ 999789 Aikman, Eldon J.             5,411.67  1064  1999  M
  _ 999807 Albright, Amy P.             2,557.89  1200  1999  M
  _ 999732 Aldrich, Roger E.            4,444.44  1066  1999  M
  _ 999919 Andersen, Raymond C.         4,601.33  1064  1999  M
  _ 999139 Anderson, Harriett           2,876.75  1064  1999  M
  _ 999122 Andrews, Peter C.            2,894.75  1064  1999  M
  _ 999710 Annis, William               2,528.00  1064  1999  M
  _ 999544 Archer, Nancy P.             2,859.67  1064  1999  M
  _ 999045 Archer, Wilma T.             3,123.17  1064  1999  M
  Suspend to command: PSUM
 
           Pay Summary records     1 thru    10 displayed of   121
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--
       Help  Suspd Quit  DCode RStrt             Forwd
 Select an entry, PF8 to page forward, or enter new keys

Purpose

LPSA allows the user to view employees having a particular attribute for a specific payroll. The list will contain Employee Id, Employee Name, Gross, Check description BU, Year, Type, Adjustment Sequence number, Student and Alien status. If more detail is required, the default suspend command will be PSUM.

Key Fields Required in the Banner


PANN - Payroll ANNual

Figure 77. Payroll ANNual - PANN


 EPOPANN 1 TEST               Payroll ANNual - PANN              07/19/99 13:32
 Command:      Action: V Emp ID: 999208      Comp Type: SN Date: 01/31/1999
  CY: 1999
-------------------------------------------------------------------------------
  Action: V Employee: 999208 Tree, Doris M                        Screen 1 of 2
            CY: 1999
 
 Gross                                  EE Taxes       ER Taxes      Wage Base
 Earnings:     81,666.67  Fed IT       27,046.11                     73,500.00
- EE Taxes     37,805.65  Ark IT        5,074.17                     73,500.00
- EE Deds       8,166.67  OASDI         4,501.20       4,501.20      72,600.00
+ EIC                     Medicare      1,184.17       1,184.17      81,666.67
           =============  Ark WC                         106.17      81,666.67
= EE Net       35,694.35  Ark SUI                        114.33      81,666.67
                                                  =============
                                ER Benefits-Taxes      5,905.87          Hours
 Attr:                                       Other      8,179.38    Reg
                                                                    OT
                                                              Federal Emp Code
 Notes:
 
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit  DCode                   NextS
 Emp:123208 CY:1999 displayed; press PF8 for next screen or enter new keys

Figure 77. Screen 1 of PANN


  EPOPANN 1 TEST               Payroll ANNual - PANN              
  Command:      Action: V Emp ID: 999208      Comp Type:    Date: 08/01/2000    
   CY: 1999                                                                     
 -------------------------------------------------------------------------------
   Action: V Employee: 999208 Tree, Doris M                        Screen 2 of 2
             CY: 1999                                                           
                                                                                
  Type           Code  Description              Amount                          
  EE Tax         EOAS  Employee OASDI             4,501.20                      
                 EMED  Employee Medicare          1,184.17                      
                 EFIT  Federal Income            27,046.11                      
                 ARSI  Arkansas Income            5,074.17                     
  ER Tax         ROAS  Employer OASDI             4,501.20                      
                 RMED  Employer Medicare          1,184.17                    
                 ARSU  Ark Unemployment             621.86                      
                 ARWC  Ark Worker's Comp            564.61                      
  Exempt Wage    EWOA  OASDI Exempt Wages       	9,066.67                    
                                                                                
                                                                                
                          BDOEs 1  thru 9  of 9                                 
                                                                                
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit                    PrevS NextR                          
 

Figure 77. Screen 2 Year-to-Date BDOE amounts and exempt wages on PANN



  EPOPANN 1 TEST               Payroll ANNual - PANN              07/19/99 13:41
  Command:      Action: V Emp ID: 107454      Comp Type: SN Date: 01/31/1999
   CY: 1999
 -------------------------------------------------------------------------------
   Action: V Employee: 999454 Treelow, Robert E                    Screen 1 of 2
             CY: 1999
 
  Gross                                  EE Taxes       ER Taxes      Wage Base
  Earnings:        791.67  Fed IT                                        696.67
 - EE Taxes                Ark IT                                        696.67
 - EE Deds          97.62  OASDI
 + EIC                     Medicare
            =============  Ark WC                           1.03         791.67
 = EE Net          694.05  Ark SUI
                                                   =============
                                 ER Benefits-Taxes          1.03          Hours
 Attr:                                       Other         81.87    Reg
                                                                    OT
                                                              Federal Emp Code
 Notes:
 
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit  DCode                   NextS
 Emp:107454 CY:1999 displayed; press PF8 for next screen or enter new keys

Figure 78d. Student Employee - PANN

The following sections describe the PANN function:

"Purpose"
"Access and Security"
"Key Fields Required in the Banner"
"Valid Actions"
"Approval Routing"
"Validations"
"Processing"

Purpose

The PANN provides a Calendar year summary of all payments made to an employee. Gross pay, Calculated Wages, Taxes and BDOEs are displayed for each record. PANN is generated through the "load" process as are PSUM, LABOR, DART, PSUM and the accounting detail. Reports are provided to verify salary, wage and BDOE amounts coming out of the payroll. PANN will be accessed during an adjustment so that year-to-date totals are used to calculate OASDI and Medicare tax. The PANN file will be used for creation of W2's and the W2 audit report.

Access and Security

This Command is available for use only by the Human Resources Office as it contains protected information.

Key Fields Required in the Banner

Valid Actions

Approval Routing

There is no routing of PANN as it is a historical record of payments made to the employee during a calendar year.

Validations

Processing


LAAY - List payroll Annual for Attribute and Year

Figure 79 is an example of the screen presented during processing of the LAAY function.

Figure 79. LAAY (List payroll Annual for Attribute and Year)


 EPOLAAY 1 PROD   List Payroll Annual for Attribute & Yr - LAAY 
 Command:      Action: V Emp ID: 131864      Comp Type:    Date: 09/08/1999
 Payroll Type:    Attr: >13H  Calendar Yr: 1999  Name:
-------------------------------------------------------------------------------
 Pay Annual for Yr: 1999  Attr: >13H  Greater than 1300 hours in the year
 starting from
                                                     Total
   Name                    ID             Gross      Hours Attr1 Attr2 Attr3
 _ Anderson, Opal        999555        8,982.65   1,355.00  >13H
 _ Blankenship, Jeffrey  999799        7,708.87   1,341.00  >13H
 _ Glisson, Jackie L     999079       12,099.38   1,321.75  >13H
 _ Guillory, April       999805        8,136.00   1,356.00  >13H
 _ Williams, Jennifer T. 999040        8,547.50   1,314.00  >13H
 _ Peppers, Yellow       999279        8,141.46   1,385.75  >13H
 _ Quinney, Melissa E.   999835       17,628.00   1,379.00  >13H
 _ Randall, Chase W.     999867        8,712.95   1,334.75  >13H
 _ Smith, Larry P.       999715        7,894.23   1,346.50  >13H
 _ Zawislak, Edward D.   999366       10,749.63   1,389.25  >13H
Suspend to Cmd: PANN
                Employees     1 thru    10 of    10 are displayed
 
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Suspd Quit        RStrt
Select an entry, or enter new keys

Purpose

LAAY allows the user to view payroll annual records having an attribute for a calendar year starting from a particular name. The list will contain employee name, ID, gross pay, total hours and up to three attributes for an employee. The Payroll Office will use this list to track and identify those employees having 1300 to 1500 hours. The State of Arkansas law allows an hourly extra help to work only 1500 hours at ANY state agency for a calendar year. If more detail is required, the default suspend command will be PANN. The user can selectively expand or restrict the list by leaving the name field blank or by inputting a name or letter in this field.

Key Fields Required in the Banner


LPAE - List Payroll Annual for an Employee

Figure 80. LPAE (List Payroll Annual for an Employee)


 EPOLPAE 1 PROD    List Payroll Annual for an Employee - LPAE    09/08/99 13:32
 Command:      Action: V Emp ID: 999202      Comp Type:    Date: 09/08/1999
 Payroll Type:      Calendar Yr: 1998
-------------------------------------------------------------------------------
 List Pay Annual for: 999202  Tree, Gene            on or after Year: 1998
 
                                           Total
     Cmd      Year            Gross        Hours     Attr1   Attr2   Attr3
 _  PANN      1998       111,054.50
 _  PANN      1999        68,823.34
 
 
 
 
 
 
 
 
                     Years     1 thru     2 of     2 are displayed
 
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit        RStrt
 Select an entry, or enter new keys

Purpose

LPAE allows the user to view all payroll annual records having for an employee starting from a calendar year. The list will contain employee ID, gross pay, total hours, and up to three attributes for an employee. The user can selectively expand or restrict the list by changing the Calendar Year. If more detail is required, the default suspend command will be PANN.

Key Fields Required in the Banner


LPAY - List Payroll Annual for a Year from name

Figure 81. LPAY (List Payroll Annual for a Year from name)


 EPOLPAY 1 TEST  List Payroll Annual for a Year from name - LPAY 06/05/00 17:12
 Command:      Action: V Emp ID: 900067      Comp Type:    Date: 06/01/1999
  Calendar Yr: 1999  Name:                  Payroll Type:
-------------------------------------------------------------------------------
 Pay Annual for Yr: 1999 starting from
 
                                                     Total
   Name                    ID             Gross      Hours Attr1 Attr2 Attr3
 _ Abalos, Eliza Kanani  999514        2,350.00     160.00
 _ Abel, Marvin          999499       10,151.00
 _ Adams, Charles M      999187        5,062.49      33.50
 _ Adams, Glynn P.       999402       16,185.33
 _ Young, Samantha Ann   999224       12,750.00
 _ Adkins, Susan J       999535       39,593.76       8.00
 _ Aga, Ali B            999162        7,375.67     182.00
 _ Again II, Ava Test    999038        4,375.00
 _ Ahlers Sr., Glen-Pet  999715       36,305.00
 _ Ahrendsen  Jr., Bruc  999387       13,665.99
 Suspend to Cmd: PANN
                 Employees     1 thru    10 of   420 are displayed
 
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit        RStrt             Forwd
 Select an entry, PF8 to page forward, or enter new keys

Purpose

LPAY allows the user to view payroll annual records for a calendar year starting from a particular name. The list will contain employee name, ID, gross pay, total hours, and up to three attributes for an employee. The user can selectively expand or restrict the list by changing the Name. If more detail is required, the default suspend command will be PANN.

Key Fields Required in the Banner


EBKI-Employee BanK Information

Figure 82. EBKI


   Decoding has been performed                               
  Command:      Action: V Emp ID: 999202      Comp Type:    Date: 09/08/2001    
                                                                                
 -------------------------------------------------------------------------------
   Action: V Employee: 999202 Treeman, Mark J.                               
                                                                                
  Bank                                Acct  Account              Dollar         
  Code Name                           Type  Number               Amount    Pct  
  ==== ============================== ====  =================   ========  ======
  70   MCILROY BANK AND TRUST           C   3208611015                    100.00
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
 Note:                                                                          
                                                                                
                                                                                
 Check Distribution BU: ACCT Test                     Payroll Override Code:    
 Updated:  10/28/1998 08:15 by: EPBLEBI                                         
                                                                                
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit  DCode                   NextR                          
 

The following sections describe the EBKI function:

"Purpose"
"Key Fields Required in the Banner"
"Valid Actions"
"Validations"
"Processing"

Purpose

The Payroll office will establish bank information on an employee in order for their net pay to be distributed to the bank account(s) of their choice through the direct deposit process. The bank information will be stored on the employee file, then passed to PSUM for each applicable payroll to keep a history of this information.

Key Fields Required in the Banner

Valid Actions

Processing

Validations


BANK - BANK information and setup

Figure 83. BANK



  EPOBANK 1 DEMO   BANK information, setup, & maintenance - BANK  
  Command:      Action: V Emp ID: 101202      Comp Type:    Date: 09/08/2001    
  Bank Code:                                                                    
 -------------------------------------------------------------------------------
 Action: V   Bank Code:                                                         
                                                                                
  Bank  Bank                                                      Bank          
  Code  Name                           City           State  Zip  Routing No.   
                                                                                
                                                                                
  AA    AMERICAN STATE BANK            KEISER           AR  72351  084104621    
  AAA   WASHINGTON MUTUAL BANK         SONOMA           CA  95476  322271627    
  AAB   BANK OF MISSISSIPPI            HATTIESBURG      MS  39401  084201278    
  AAC   VWSE FEDERAL CREDIT UNION      VICKSBURG        MS  39182  065300279    
  AB    66 FEDERAL CREDIT UNION        BARTLESVILLE     OK  74005  303184652    
  AB1   APPLE BANK                     BROOKLYN         NY  11231  226070584    
  AC    ENT FEDERAL CREDIT UNION       COLORADO SPRRNG  CO  80903  307070005    
  ACU   ARKANSAS CENTRAL FED CRED UN   LITTLE ROCK      AR  72201  282075057    
  AD    CALIFORNIA ST EMPLOYEES' CRUN  BERKLEY          CA  94704  321171595    
  AE    MERCANTILE BANK OF CRAWFORD    VAN BUREN        AR  72956  082901004    
                                                                                
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit  DCode                   Forwd                          
 Press PF8 to view more records or enter new keys                              
 

The following sections describe the BANK function:

"Purpose"
"Access and Security"
"Key Fields Required in the Banner"
"Valid Actions"
"Validations"
"Processing"

Purpose

The Payroll office will use this function to add new banks and to update existing banks in the system.

Access and Security

BANK will only be available for the Payroll Office.

Key Fields Required in the Banner

Valid Actions

Processing

Validations


LBRN - List Bank by Routing Number

Figure 84. List Bank by Routing Number-LBRN


  EPOLBRN 1 DEMO        List Banks by Routing Number - LBRN       
  Command:      Action: V Emp ID: 101202      Comp Type:    Date: 09/08/2001    
  Bank Routing: 002200868                                                       
 -------------------------------------------------------------------------------
       List Banks by Routing Number starting from number: 002200868             
                                                                                
      Bank       Bank                            Bank                           
      Routing    Name                            Code   City           State    
  _  022000868   CITIBANK                        CK     BUFFALO          NY     
  _  022300173   CHASE MANHATTAN BANK            2P     ROCHESTER        NY     
  _  028000082   CITIBANK NA                     B0     PORT WASHINGTON  NY     
  _  031000011   THE VANGUARD GROUP              23     VALLEY FORGE     PA     
  _  031000053   CHARLES SCHWAB PNC BANK         CQ     LITTLE ROCK      AR     
  _  031001175   CONTINENTAL BANK                6C     PHILADELPHIA     PA     
  _  031100144   CHASE MANHATTAN BANK            B1     WILMINGTON       DE     
  _  031100157   PNC BANK                        PJ     PHILADELPHIA     PA     
  _  031100157   PNC BANK                        PN     WILMINGTON       DE     
  _  031100649   GREENWOOD TRUST COMPANY         GT     GREENWOOD        DE     
                                                                                
                                                                                
            Bank records    10 through    19 of   587 displayed                 
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit  DCode RStrt       Back  Forwd                          
 Select an entry, PF7 to page back, PF8 to page forward, or enter new keys     
 

The following sections describe the LBRN function:

"Purpose"
"Access And Security"
"Key Fields Required in the Banner"
"Processing".

Purpose

This command will allow users to view and search for banks by routing number. The List will contain bank routing number, bank name, bank code, city and state.

Access And Security

LBRN is only available to the Payroll Office.

Key Fields Required in the Banner

Processing


LBBN - List Bank by Bank Name

Figure 85. List Bank By Name- LBBN


  EPOLBBN 1 DEMO          List Banks by Bank Name - LBBN          06/22/04 13:45
  Command:      Action: V Emp ID: 101202      Comp Type:    Date: 09/08/2001    
  Bank Name: CHASE                                                              
 -------------------------------------------------------------------------------
      List Banks by Bank Name starting with: CHASE                              
                                                                                
      Bank                            Bank                           Bank       
      Name                            Code   City            State   Routing    
  _  CHASE MANHATTAN BANK             B1     WILMINGTON        DE   031100144   
  _  CHASE MANHATTAN BANK             CV     NEW YORK          NY   021000021   
  _  CHASE MANHATTAN BANK             2P     ROCHESTER         NY   022300173   
  _  CITIBANK                         CK     BUFFALO           NY   022000868   
  _  CITIBANK                         CI     PARK RIDGE        IL   271070801   
  _  CITIBANK NA                      B0     PORT WASHINGTON   NY   028000082   
  _  CITIZEN'S BANK                   B3     BATESVILLE        AR   082907736   
  _  CITIZEN'S BANK                   B8     ANDERSON          IN   074900709   
  _  CITIZEN'S BANK OF LAVACA         B2     LAVACA            AR   082903785   
  _  CITIZEN'S FIRST BANK             A6     LITTLE ROCK       AR   082001784   
                                                                                
                                                                                
            Bank records     1 through    10 of   479 displayed                 
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit  DCode RStrt             Forwd                          
 Select an entry, PF8 to page forward, or enter new keys                       
  

The following sections describe the LBBN function:

"Purpose"
"Access And Security"
"Key Fields Required in the Banner"
"Processing"

Purpose

This command will allow users to view and search for banks in alpha order by the name. The List will contain bank name, bank code, city, state, and bank routing number.

Access And Security

LBBN is only available to the Payroll Office.

Key Fields Required in the Banner

Processing



GTNS- Gross To Net Simulation

Figure 88. Gross To Net Simulation-GTNS


  EPOGTNS 1 TEST          Gross To Net Simulation - GTNS          07/16/99 14:11
  Command:      Action: V Emp ID: 101202      Comp Type:    Date: 01/31/1999
  Payroll Type: M  True Supplemental: N Student: N
  Gross Pay by Category I: 8969    N:         R:         E:         T:
 -------------------------------------------------------------------------------
   Action: V Employee: 101202 Bouwman, Marinus J                   Screen 1 of 2
  Payroll: 01/31/99 M  Supplemental:N Student: N
  Pay Category I: 8969    N:        R:         E:         T:
 
 _______GTN Summary______   _________Taxable Wages____________   ____Misc.____
                                       Current        Ytd
   Gross         8,969.00                             8,968.07   Pay Freq
 - EE Taxes      2,279.28   Fed IT     7,025.60      7,024.67   Alien
 - EE Deducts    2,325.72   Ark IT     7,025.60      7,024.67   Federal
 + EIC                      OASDI      7,175.60      7,174.67   Age      43
              ===========   Medicare   7,175.60      7,174.67   Salary   81536
 = Net           4,364.00   Ark WC     7,175.60      7,174.67   Position 23
                            Ark SUI    7,175.60      7,174.67   Ben Attr
 ER Taxes         568.24   Comp Period: 01/01/19- 01/31/1999    12over9
 Other Benes    1,359.15
                     Go to screen 2 for BDOE information
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Suspd Quit                        NextS
Press PF8 to view next screen or enter new keys

Figure 89. Screen 2 of GTNS


 EPOGTNS 1 TEST          Gross To Net Simulation - GTNS          07/16/99 14:19
 Command:      Action: V Emp ID: 101202      Comp Type:    Date: 01/31/1999
 Payroll Type: M  True Supplemental: N Student: N
 Gross Pay by Category I: 8969    N:         R:         E:         T:
-------------------------------------------------------------------------------
  Action: V Employee: 101202 Bouwman, Marinus J                   Screen 2 of 2
 Payroll: 01/31/99 M  Supplemental: N Student: N
 Pay Category I: 8969    N:         R:         E:         T:
 
 Type       BDOE BDOE Description     Short Comment  Src   Amount       DNT
 EE Tax     EOAS Emplyee OASDI Tax                    T      444.83        0.00
            EMED Emplye Medicare Tax                  T      104.03        0.00
            EFIT Emp Federal Inc Tax  0 M  1    0.00  T    1,307.79        0.00
            ARSI Ark State Income Tax 0   1    0.00   T      422.63        0.00
 Deduction  C1   Child Support Garn                   S      367.93        0.00
            28   Garnishment          Testing         S       24.95        0.00
            31   TIAA-CREF Reduction  Testing         O      150.00        0.00
            ADD Accidental Death&Dis Fam 100K     B        4.00        0.00
            4E   Medical Coverage 125 Fam POS         B      293.40        0.00
            4F   Optional LTD         Over 20K        B       30.77        0.00
                           BDOEs 1  thru 10 of 20
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit              RNet  PrevS Forwd
 Please enter new key fields
is a generic a continuation of the second screen on GTNS.

Figure 89. Gross to Net Simulation-GTNS


 EPOGTNS 1 TEST          Gross To Net Simulation - GTNS          07/16/99 14:20
 Command:      Action: V Emp ID: 101202      Comp Type:    Date: 01/31/1999
 Payroll Type: M  True Supplemental: N Student: N
 Gross Pay by Category I: 8969    N:         R:         E:         T:
-------------------------------------------------------------------------------
  Action: V Employee: 101202 Bouwman, Marinus J                   Screen 2 of 2
 Payroll: 01/31/99 M  Supplemental: N Student: N
 Pay Category I: 8969    N:         R:         E:         T:
 
 Type       BDOE BDOE Description     Short Comment  Src   Amount       DNT
 Deduction  88   9/12 Contributions                   S    1,454.67        0.00
 ER Tax     ROAS Employr OASDI Tax                    T      444.83        0.00
            RMED Employr Medicare Tax                 T      104.03        0.00
            ARSU Ark State Unemp Tax                  T       10.05        0.00
            ARWC Ark Worker's Comp                    T        9.32        0.00
 Other Bene 59   Employer TIAA/CREF                   S      896.90        0.00
            66   Employer BASIC Life                  S       17.50        0.00
            68   Employer Medical                     B      440.09        0.00
            70   Employer LTD                         S        4.66        0.00
 Other Earn 05   Comp Car             Big Car         O   -1,500.00        0.00
                           BDOEs 11 thru 20 of 20
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Suspd Quit              RNet  Back  NextR
 Please enter new key fields

The following sections describe the GTNS function:

"Purpose"
"Access and Security"
"Key Fields Required in the Banner"
"First Screen"
"Second Screen"
.

Purpose

GTNS is an online pay calculation program providing an comprehensive summary of each possible payment to be made to an employee. Gross pay, calculated Wages, taxes, deductions and benefits are displayed for each record. GTNS also displays other pertinent employee information; student status, NRA, Federal employee status, age, salary, position number and benefit attributes.

Access and Security

This Command is available for use only by the Human Resources Office.

Key Fields Required in the Banner

First Screen

Second Screen


Back to Top











Sorry, but your search for documentation yielded No Results.

There is not currently a document devoted specifically to the function for which you requested information.

Use your browser's BACK button (or Click Here) to return to the previous screen.