PPS MANUAL

UCLA Payroll Services

A guide on the various databases, tables, reports and security features within the Personnel Payroll System (PPS).
PPS MANUAL, SECTION B - HISTORY DATA BASE

B2.0 USING IHDB AND UHDB


The History Data Base (HDB) is the system that captures for historical purposes the personnel-related data that has been entered and updated in the Employee Data Base (EDB). Not all EDB data is captured in the HDB. The designers intended the database to include only the information that was most useful for personnel administration purposes.

Data in the HDB is organized into tables. Some of the tables are:

Within each table are all the rows of data that have been captured from the EDB in the HDB update process.

The IHDB inquiry system provides a way for a user to view each individual table and its rows of data. The rows of data contained in each HDB table for an employee can be viewed by accessing the table screen and scrolling through the various rows. Each screen in IHDB contains only one row of data. There is no method in the HDB by which a user can view a consolidated set of data like you can in the IHIS Personnel Reporting System.

For example, you cannot see several appointments on one screen, nor can you see an appointment and its related distributions, as you can in IHIS. In fact, the IHIS system relies on programmed logic to scan all the rows of data that are available in the HDB and decide which ones to display in the IHIS screens.

B2.1 Access

Access to the History Data Base Inquiry System is approved by the Chief Administrative/Financial Officer of a department. It is given to an approved individual by the Departmental Security Administrator (DSA). The individual must receive a logon ID from Administrative Information Systems (AIS) before access to any AIS system is given by the DSA.

Access to employee records is based on the campus Organizational Hierarchy. Access is granted according to Department, Subdivision, Division or Organization code. If an employee’s historical record contains any appointment and distribution from a department to which a user has access, the user can view the employee’s entire historical record.

The primary purpose of the IHDB view of history for department users is to view the "raw" history data in order to answer questions about the manner in which data appears in IHIS or the PP QDB.

 UCMMNU0-M1325                Online Applications                  05/21/YY 19:58:01 
                                  Main Menu                        Userid:  ABCDE      
                                                                                
  ---- Employee Data Base ----             ------ PAN Subsystem -------         
   IEDB  Central Inquiry                    PSRV  PAN Services Menu             
   IDDB  Departmental Inquiry              -- Payroll Time Reporting --         
   EEDB  EDB Entry/Update                   ETHF  THF Entry/Update              
   IDOC  Employee Documents                 IDTC  Dept Time Collect             
  --- Payroll Audit Record ---              EDAT  Dept Adj Trans                
   IPAR  Inquiry                           ---- Abeyance Data Base ----         
   IPAY  Departmental Inquiry               SPCL  Special Processes             
  ---- History Data Base -----             ------ CSER Subsystem ------         
   IHDB  Record Inquiry/Update              EFCR Encumbrance Entries            
   IHIS  Personnel History                 --- ID Number Subsystem ----         
   IHHR  History Documents                  EDEM  ID Numbers Main Menu          
                                           --- System Administration --         
                                            UCSA  Entry/Update                  
  -- Employment Verification -                                                  
   IVER  Verification                                                           
 Next Func: IHDB ID:           Name:                            SSN:

 ===>
  F:  1-Help      2-Jump
  F:                                                             12-Exit


Navigation

To access the Inquiry Function Code Menu for the HDB, type IHDB in the Next Function Code of any Personnel/Payroll Screen, as shown in the example above, and press Enter.

To select a screen from the IHDB menu, enter the function code of the desired screen in the Next Function field, and enter either the employee number or the social security number for the desired employee record.

NOTE: 
Because there are so many records in the HDB, DO NOT ACCESS THE HDB USING AN EMPLOYEE'S NAME.  If you do not know the employee's social security number or employee number, first find the employee's record in EDB Inquiry by using the name and then enter the HDB screen function code from the employee's EDB inquiry screen.

UCFM140-M0967                  History Inquiry                  03/31/YY 09:12:47
                          Inquiry Function Code Menu             Userid:  ABCDE

   IATN Action Code Data                  ILIC License Data
   IAPN Appointment Data                  IMBR Membership Data
   IAWD Award Data                        IMTH Monthly Accumulators
   IBA1 Basic Employment Data 1           IOFF Layoff Data
   IBA2 Basic Employment Data 2           IQTR Quarterly Accumulators
   IBKG Background Check Data             ISAB Sabbatical Credit
   IBN1 Benefits Data 1                   ISVC Service Credit Data
   IBN2 Benefits Data 2                   IYRL Yearly Accumulators
   ICBG Collective Bargaining Date        IHW4 Tax Data
   IDST Appointment Distribution Data     ILOK Selection
   IFSC Fiscal Accumulators
   IHNR Honors Data
   ILCR Layoff Seniority Credit Data
   ILEV Leave of Absence Data             UHDB Update Function Code Menu

 Next Func: IAPN ID: 000207468 Name:DO NOT USE TO ACCESS HDB SCREENS SSN:            
      Date:        View incorrect records?

 ===>
  F:  1-Help                  3-PrevMenu
  F:                                                             12-Exit


In addition to the desired function code and employee record key, the user may also specify a "Date" and/or "View Incorrect Records" as an option before pressing the "Enter" key. See the section on Footers below for a definition of these two options.

B2.2 Screen Layout

Header Section

 PPIAPN0-I0944                  History Inquiry                  03/31/YY 09:46:14  
 11/08/YY 00:31:08             Appointment Data                   Userid:  ABCDE
 ID: 000207468 Name: ROGERS,ROY A           
  1. PPIAPN0-I0944 - The screen identifier:
  2. History Inquiry - The system title.
  3. 03/31/97 09:46:14 - The current system date and time.
  4. 11/08/96 00:31:08 - The date and time of the last update of the data on the displayed screen in the Employee Data Base.
  5. Appointment Data - The screen title.
  6. Userid - The logon ID of the user who accessed the system.
  7. ID - The employee ID number of the employee whose record is displayed.
  8. Name - The employee’s name.

Footer Section

Next Func:      ID:           Name: DO NOT USE TO ACCESS HDB SCREENS SSN:          
	Date:        View Incorrect Records?
===>                                      
 F: 1-Help      2-Browse    3-PrevMenu 
 F: 					10-PrevRec  11-NextRec	12-Exit
  1. Next Func - The Next Function field. The user may enter a 4 character function code in this field to select a screen.
  2. Employee Record Key - The user may enter a value in any one of these fields to select an employee record:
  3. Date - The user may enter any valid date (entered as 010105 for January 1,2005) and the system will locate the history row closest to but not later than that date. If this field is left blank, the system will display records for the selected employee in chronological order of the last update from most recent to oldest.
  4. View Incorrect Records - There is a process by which a user can flag a record as incorrect in the HDB. (Refer to Section B2.4 for a description of how to set an incorrect flag.) Records which have been flagged as "incorrect" in the HDB are normally excluded from being displayed on the History Inquiry screens.

    If the user wishes to view all records for an employee, including those which have been flagged as being incorrect, a "Y" must be entered in this field. When scrolling to an earlier or later screen within a multiple screen set, the "view incorrect records" flag remains set and will be retained for each subsequent history search until the field value is changed or deleted.
  5. ===> - The command line may be used to enter Function Key numbers if a keyboard does not have function keys. This area may also be used to enter a Function Code.
  6. F: (Function keys) - This section of the footer displays the function keys that are active for a particular screen. The function keys available in IHIS are:
    F1 - Help F1 invokes either screen level help or field level help depending on the position of the cursor on the screen. Field level help is provided for header and footer fields and for fields in the detail portions of the screens.
    F2 - Browse F2 invokes the ILOK Browse screen from the employee record detail screens. The Browse screen lists all employee records contained in the system.
    F2 - Jump F2 invokes the jump command on Menu screens and the Browse screen. It is used to move the cursor from its position on the body of the screen to the Next Function field. It will also move the cursor from any field in the footer to the last position it occupied in the body of the screen or to the first record in the body of the screen.
    F3 - PrevMenu F3 is used to return to the last menu that was displayed.
    F7 - Backward F7 is used to scroll back to display the previous "page" of data when there are multiple pages of related data.
    F8 - Forward F8 is used to scroll ahead to display the next "page" of data when there are multiple pages of related data.
    F10 - PrevRec F10 is used to display an earlier record based on the last update date.
    F11 - NextRec F11 is used to display a later record based on the last update date.
    F12 - Exit F12 is used to exit the Personnel History Reporting System and return to the OASIS Menu.

B2.3 History Inquiry Detail Screens

Each Inquiry screen displays only one row of data that was updated in the HDB. Any data field that is highlighted represents data that was changed from the data in the previous row. In other words, when a new appointment or distribution is first established, all the data fields in IHDB should be shaded. Then, when a change is made to an element of that appointment, e.g., the Leave Accrual code is changed, all the data for the appointment row is displayed on the next screen and the Leave Accrual code is shaded.

The following describes all the detail screens in the History Inquiry System.

IATN - Action Code Data

PPIATN0-I0944                  History Inquiry             03/31/YY 11:08:30
11/08/YY 00:31:08             Action Code Data               Userid:  ABCDE
ID: 444207382 Name: DESMOND,NORMAN             
Incorrect Flag:

Appt Number   : 10
Dist Number   : 12
Action Code   : 50
Effective Date: 10/01/2006









Next Func:      ID:           Name:                            SSN:
     Date:        View incorrect records?

===>
 F:  1-Help      2-Browse    3-PrevMenu
 F:                                     10-PrevRec              12-Exit


The Action Code and the associated Action Effective Date are displayed on this screen. If the Action Code is associated with an appointment or distribution, the related appointment/distribution number(s) will also be displayed. If the Action Code is at the employee level and not associated with an appointment or distribution, as in the case of a Hire or a Separation, a 01 will display in the Appt Number field.

IAPN - Appointment Data

PPIAPN0-I1287                  History Inquiry                05/21/YY 11:48:23
 05/12/YY 15:09:41             Appointment Data                Userid:  ABCDE
 ID: 701022843 Name: APPLESEED,JON D             
 Incorrect Flag:   Appt No. 30

 Appt Begin Date: 07/01/2000                          Time Rpt Code : Z
 Appt End Date  : 08/31/2000                          Fixed/Variable: V
 Appt Duration  :                                     Personnel Prog: A
 Title Code     : 3205                                Paid Over Code: 09
 Title Unit     : FX                                  Leave Accrual : N
 Title Spec Hdlg: 
 FLSA           : 1                                   Appt Pay Sched: MO
 Department Code: 129500                              Appt Rate Code: A
 Sub-location   :                                     Annual/Hourly
 Appt Rep Code  : C                                        Rate     : 115000.00
 Appt Basis Code: 09                                  Salary Grade  :
 Appt Type Code : 5                                   Acad. Rank Dt :
 Appt Time      : 1.00
 Next Func:      ID:           Name:                            SSN:
      Date:        View incorrect records?

 ===>
  F:  1-Help      2-Browse    3-PrevMenu
  F:                                     10-PrevRec              12-Exit


All appointment data is displayed on the Appointment Data screen. If the data in even one field changes, a new appointment row is written to the HDB and displayed as the next record.

IAWD - Awards Data

PPIAWD0-I0944                  History Inquiry                03/31/YY 11:59:54
                                  Award Data                   Userid:  ABCDE
 
ID: 4442077892 Name: GUMP,NORMA A            

Entry Date: 12/18/2007                 Entry Date: 02/05/1996 
Entry Time: 14.21.10                   Entry Time: 01.01.01 
Incorrect                              Incorrect   
     Flag :                               Flag :   
Award -                                Award - 
Number: 03                             Number: 02  
Type  : LEA                            Type  : PDA 
Date  : 06/07                          Date  :05/95,
Amount:   1000.00                      Amount:    500.00 
Source: 4 660525 19900 2               Source: 19900       


 Next Func:      ID:           Name:                            SSN:
      Date:        View incorrect records?
 P0053  No data for requested date or prior dates
 ===>
  F:  1-Help      2-Browse    3-PrevMenu
  F:                                        10-PrevRec              12-Exit


Awards data for up to two awards displays on each screen.

IBA1 - Basic Employment Data 1

PPIBA10-I1482                  History Inquiry                05/19/YY 12:12:50
 11/01/YY 18:05:26         Basic Employment Data 1             Userid:  ABCDE
 ID: 800674352 Name: JAMES, JESSIE                 
 Incorrect Flag:
 Name: JAMES,JESSIE                         Separation Date        : 08/02/2006
 SSN : 563890802                            Separation Reason      : AF
 Home Department     : 540000               Separation Destination :
 Original Hire Date  :
 Oath Signature Date :                      Probation End Date     :
                                            Next Review Type       : 2
 Employment Status   : S                    Next Review Date       : 01/05
 Most Recent Hire Dt : 09/26/2004           Ret FICA Derive        : 
 Prior Service Code  :                      FICA Eligibility Cd    : E
 Prior Service Inst  :                      Retirement System Code : U
 START Percent       :                      Last Day on Pay Status : 08/02/2006
 START Begin Date    :                      Primary Title Code     : 4723
 START End Date      :                      Job Group Identifier   : 520

 Next Func:      ID:           Name:                            SSN:
      Date:        View incorrect records?

 ===>
  F:  1-Help      2-Browse    3-PrevMenu
  F:                                     10-PrevRec              12-Exit


Employee level information is displayed on this screen. If the data in one of the fields changes, a new row is written to the HDB and displayed as the next record.

IBA2 - Basic Employment Data 2

PPIBA20-I1450                  History Inquiry                02/12/YY 12:20:36
 11/01/YY 18:05:26         Basic Employment Data 2             Userid:  ABCDE
 ID: 904888907 Name: TIN, RINNIE T              
 Incorrect Flag :
 Birth Date     : 09/15/1970                     Recent Sep Vet Dt : 01/01
 Sex            : F                              Veteran Status Cds: N/ /N
 Ethnic Origin  : 2                              Disabled Status   : N
 Citizen Status : C                              Visa Type         :
 Education Level: H                              Work Perm End Date:
 Education Year : 00                             U.S. Date of Entry:
 Highest Degree :      Date:                     UC Student Status : 1
 Degree Field   :      Inst:                     Curr. Specialty-1 :
 Foreign Address:                                               -2 :
 Permanent Addr : 123 SERENO DRIVE                              -3 :
                                                 Future Institution:
 Permanent City : TEMPLE CITY                    Trip Begin Date   :
 Permanent State: CA Zip: 91780                  Trip Duration     :
 Foreign Country:    Province:                   Trip %            :
 Next Func:      ID:           Name:                            SSN:
      Date:        View incorrect records?

 ===>
  F:  1-Help      2-Browse    3-PrevMenu
  F:                                     10-PrevRec              12-Exit


Personal information is displayed on this screen. If the data in one of the fields changes, a new row is written to the HDB and displayed as the next record.

IBKG - Background Check Data

PPIBKG0-I0944                  History Inquiry                03/31/YY 12:25:44
                            Background Check Data              Userid:  ABCDE
 ID: 444447452 Name: MASON,PERRY A             

 Entry Date  :              Entry Date  :              Entry Date  :
 Entry Time  :              Entry Time  :              Entry Time  :
 Incorr. Flag:              Incorr. Flag:              Incorr. Flag:
 Bkgrnd Code :              Bkgrnd Code :              Bkgrnd Code :
 Bkgrnd Date :              Bkgrnd Date :              Bkgrnd Date :



 Next Func:      ID:           Name:                            SSN:
      Date:        View incorrect records?
 P0053  No data for requested date or prior dates
 ===>
  F:  1-Help      2-Browse    3-PrevMenu
  F:                                                             12-Exit


Background Check Data has not been loaded into the HDB as of this writing. All background check data can be entered and viewed on the EBCC screen in EDB Entry/Update.

IBN1 - Benefits Data 1

PPIBN10-I0944                  History Inquiry                03/31/YY 12:30:01
 01/16/YY 16:21:26             Benefits Data 1                 Userid:  ABCDE
 ID: 876207932 Name: GREELEY,ANDY           
 Incorrect Flag:

 BELI-Assigned    : 1                    ADD Coverage              :
 BELI-Derived     : 1                    ADD Eff Date              : 02/16/1993
 BELI Eff Date    : 01/01/1989           ADD Principal             :
 BELI Change Date : 01/01
 BELI Conflict Dt :                      EPD Sal Base              : 05803
                                         EPD Eff Date              : 01/16/1997
 Core Ben Cover   :                      EPD Wait Per              : 090
 Ins Reduction    :
 Auto/Home Deduct :                      Life Insurance-    UC Paid: 050
 UCTD Code        : A                    Life Ins Eff Date- UC Paid: 01/01/1989
 UCTD Eff Date    : 02/16/1993


 Next Func:      ID:           Name:                            SSN:
      Date:        View incorrect records?

 ===>
  F:  1-Help      2-Browse    3-PrevMenu
  F:                                     10-PrevRec              12-Exit


IBN2 - Benefits Data 2

PPIBN20-I1440                  History Inquiry                12/18/YY 12:32:56
 12/13/YY 16:21:26             Benefits Data 2                 Userid:  ABCDE
 ID: 876207932 Name: GREELEY,ANDY           
 Incorrect Flag:
 Medical Plan     : UC Cov: UAC           Legal Plan     : J1 Cov: UAC
 Medical ECED/PCED: 02/16/1993 02/16/1993 Legal ECED/PCED: 01/01/1997 01/01/1997
 Medical End Date :                       Legal End Date : 
 Medical Opt Out  :
                                          Suppl Life Plan: 1
 Dental Plan      : D1 Cov: UAC             Life Sal Base: 070
 Dental ECED/PCED : 02/16/1993 02/16/1993   Life Eff Date: 02/16/1993
 Dental End Date  :
 Dental Opt Out   :                       Exec Life Plan :
                                          Exec Sal Base  :
 Vision Plan      : VI Cov: UAC           Exec Chg Date  :
 Vision ECED/PCED : 02/16/1993 02/16/1993 Exec Eff Date  :
 Vision End Date  :                       Dep Life Plan  : B
 Vision Opt Out   :                       Dep Eff Date   : 02/16/1993
 Next Func:      ID:           Name:                            SSN:
      Date:        View incorrect records?

 ===>
  F:  1-Help      2-Browse    3-PrevMenu
  F:                                     10-PrevRec              12-Exit


Benefits data is displayed on these two screens. If the data in one of the fields changes, a new row is written to the HDB and displayed as the next record.

ICBG - Collective Bargaining Data

PPICBG0-I0944                  History Inquiry                03/31/YY 13:41:28
 07/06/YY 15:46:06        Collective Bargaining Date           Userid:  ABCDE
 ID: 200347494 Name: GLOBETROTTER,HARLAND           
 Incorrect Flag:

 Employee Relations Code        : E
 Employee Unit Code             : CX
 Employee Special Handling Code :
 Employee Distribution Unit Code:
 Employee Representation Code   : C








 Next Func:      ID:           Name:                            SSN:
      Date:        View incorrect records?

 ===>
  F:  1-Help      2-Browse    3-PrevMenu
  F:                                     10-PrevRec              12-Exit


The history of collective bargaining unit codes at the employee level are displayed on this screen. Appointment level collective bargaining unit codes are displayed on the IAPN screen. If the data in one of the fields changes, a new row is written to the HDB and displayed as the next record.

IDST - Appointment Distribution Data

PPIDST0-I1138                  History Inquiry                05/21/YY 14:01:34
 12/07/YY 12:34:00      Appointment Distribution Data          Userid:  ABCDE
 ID: 002467695 Name: KANE,CITIZEN     		 
 Incorrect Flag:   Appt No. 10 Dist No. 12

 Charge Start Date: 09/30/1996                     Dist Pay Rate  :      9.4200
 Charge Stop Date : 10/05/1996                     Salary Step    : 1.0
 Location         : 4                              Off/Above Scale:
 Account          : 660530                         Full Time Equiv:
 Cost Center      :                                Perquisite Type:
 Fund             : 19900                          Work Study Prog: F
 Project Code     :
 Subaccount       : 2
 Descrip of Serv  : REG
 Department Code  : 356500
 Distribution Unit:
 Range Adjust Unit:
 Distribution Time:  .4900
 Next Func:      ID:           Name:                            SSN:
      Date:        View incorrect records?

 ===>
  F:  1-Help      2-Browse    3-PrevMenu
  F:                                     10-PrevRec              12-Exit


Distribution data is displayed on the Appointment Distribution Data screen. If the data in even one field changes, a new distribution row is written to the HDB and displayed as the next record.

IFSC - Fiscal Accumulators

This screen is not in use at UCLA at this time.

IHNR - Honors Data

PPIHNR0-I0944                  History Inquiry                03/31/YY 14:33:06
                                 Honors Data                   Userid:  ABCDE
 ID: 871516496 Name: ROCKFORD,JOHN D            

 Inc. Flag :                Inc. Flag :                Inc. Flag :
 Entry Date:                Entry Date:                Entry Date:
 Entry Time:                Entry Time:                Entry Time:
 Honor Type:                Honor Type:                Honor Type:
 Honor Date:                Honor Date:                Honor Date:

 Inc. Flag :                Inc. Flag :                Inc. Flag :
 Entry Date:                Entry Date:                Entry Date:
 Entry Time:                Entry Time:                Entry Time:
 Honor Type:                Honor Type:                Honor Type:
 Honor Date:                Honor Date:                Honor Date:

Next Func:      ID:           Name:                            SSN:
      Date:        View incorrect records?
 P0053  No data for requested date or prior dates
 ===>
  F:  1-Help      2-Browse    3-PrevMenu
  F:                                                             12-Exit


Honors data for academic employees has not been loaded into the HDB as of this writing. All honors data can be entered and viewed on the EHON screen in EDB Entry/Update.

IHW4 - Tax Data

PPIHW40-I1325                  History Inquiry                05/22/YY 18:02:50
12/31/YY 15:56:43                Tax Data                       Userid:  ABCDE
ID: 610610610 Name: INQUIRY,TAX               

Incorrect Flag:
Federal                           Tax Processor ID : PPS06/11/01SETP4
  Marital Status         : M      W-4 Process Date : 06/11/01
  Personal Allowances    : 002    DE4 Process Date : 06/11/01
  Maximum Withholding    : 999
California
  Marital Status         : M       
  Personal Allowances    : 000
  Itemized Deductions    : 000
  Maximum Withholding    : 999         
Addl Fed Nonres Alien Tax:
Addl Fed Tax Withholding :             
Addl CA Tax Withholding  :             

Next Func:      ID:           Name:                            SSN:
     Date:        View incorrect records?

===>
 F:  1-Help      2-Browse    3-PrevMenu
 F:                                     10-PrevRec              12-Exit


Data from the W-4 form is displayed on this screen.

ILCR - Layoff Seniority Credit Data

PPILCR0-I1104                  History Inquiry                05/21/YY 14:44:59
 03/28/YY 04:51:57       Layoff Seniority Credit Data          Userid:  ABCDE
 ID: 402669212 Name: UNGER,FELIX                
 Incorrect Flag:

 Layoff Seniority Credit Title Code: 4723   TUC: CX  Appt Rep: C

 Regular Hours:   2101.01    Last Update: 03/31/97

 Prior Balance Hours:             as of 01/01/01







 Next Func:      ID:           Name:                            SSN:
      Date:        View incorrect records?

 ===>
  F:  1-Help      2-Browse    3-PrevMenu
  F:                                     10-PrevRec              12-Exit


The history of the number of hours of layoff seniority credit is displayed on this screen. The previous records display the hours of credit by title unit code each month the employee received pay for qualifying time since May 1995, when the program to calculate layoff seniority credit was installed.

ILEV - Leave of Absence Data

PPILEV0-I0944                  History Inquiry                03/31/YY 14:54:13
 10/30/YY 02:21:35          Leave of Absence Data              Userid:  ABCDE
 ID: 000234183 Name: PETRIE,LAURA                
 Incorrect Flag:

 Leave of Absence Begin Date: 06/28/1996
 Leave of Absence Return Dt : 10/01/1996

 Leave Status Code          : N
 Leave of Absence Type Code : 04






 Next Func:      ID:           Name:                            SSN:
      Date:        View incorrect records?

 ===>
  F:  1-Help      2-Browse    3-PrevMenu
  F:                                     10-PrevRec              12-Exit


Leave of absence data is displayed on this screen. If the data in any field changes, a new row is written to the HDB and displayed as the next record.

ILIC - License Data

PPILIC0-I1063                  History Inquiry                03/31/YY 17:14:35
                                 License Data                  Userid:  ABCDE
 ID: 145789929 Name: PERRY,ANTOINETTE M          

 Incorrect Flag      :                     Incorrect Flag      :
 Entry Date          :                     Entry Date          :
 Entry Time          :                     Entry Time          :
 License Certificate :                     License Certificate :
 License Renewal Date:                     License Renewal Date:
 License Number      :                     License Number      :

 Incorrect Flag      :                     Incorrect Flag      :
 Entry Date          :                     Entry Date          :
 Entry Time          :                     Entry Time          :
 License Certificate :                     License Certificate :
 License Renewal Date:                     License Renewal Date:
 License Number      :                     License Number      :

 Next Func:      ID:           Name:                            SSN:
      Date:        View incorrect records?
 P0053  No data for requested date or prior dates
 ===>
  F:  1-Help      2-Browse    3-PrevMenu
  F:                                                             12-Exit


Up to four instances of license and certification data are displayed on this screen. Additional instances are displayed as the next record.

IMBR - Membership Data

PPIMBR0-I1281                  History Inquiry                05/21/YY 17:17:04
 12/13/YY 04:49:11             Membership Data                 Userid:  ABCDE
 ID: 279273273 Name: CLEAVER,JUNE A           

 Entry Date: 12/13/1996 Entry Time: 04.49.11 Incorrect Flag:   Delete:
 Dep#: 53 Name: CLEAVER,THEODORE                      SSN: 623030167
 Rel to Emp: C                    Medical DCED: 08/31/1993  End Date:
 Dep Birth Date: 12/29/1978       Dental  DCED: 08/31/1993  End Date:
 Sex: M                           Vision  DCED: 08/31/1993  End Date:
 Disabled Code:                   Legal   DCED: 01/01/1997  End Date:

 Entry Date: 12/13/1996 Entry Time: 04.49.11 Incorrect Flag:   Delete: Y
 Dep#: 52 Name: CLEAVER,WALLACE                      SSN: 624033182
 Rel to Emp: C                    Medical DCED: 08/31/1993  End Date:
 Dep Birth Date: 04/12/1974       Dental  DCED: 08/31/1993  End Date:
 Sex: F                           Vision  DCED: 08/31/1993  End Date:
 Disabled Code:                   Legal   DCED: 01/01/1997  End Date:

 Next Func:      ID:           Name:                            SSN:
      Date:        View incorrect records?

 ===>
  F:  1-Help      2-Browse    3-PrevMenu
  F:                                     10-PrevRec              12-Exit


Dependent history is displayed on this screen in order of system entry date and time of EDB update.

IMTH - Monthly Accumulators

PPIMTH0-I1330                  History Inquiry                05/21/YY 17:27:39
 05/08/YY 01:01:10           Monthly Accumulators              Userid:  ABCDE
 ID: 279273273 Name: CLEAVER,JUNE A           
 Incorrect Flag:

 Retirement Gross    :   5580.00
 Retirement Reduction:    633.33

 Hours Toward Benefits Eligibility:     .00
 Hours Toward Career Eligibility  :     .00






 Next Func:      ID:           Name:                            SSN:
      Date:        View incorrect records?

 ===>
  F:  1-Help      2-Browse    3-PrevMenu
  F:                                     10-PrevRec  11-NextRec  12-Exit


Displayed on this screen are the monthly gross earnings which are subject to employee contributions under one of the University retirement plans and the portion of the month's retirement gross which was exempted from employee retirement contributions by the retirement rebate.

IOFF - Layoff Data

 PPIOFF0-I1553                  History Inquiry                09/15/YY 10:03:17
 06/09/YY 09:14:44               Layoff Data                   Userid:  ABCDE
 ID: 219000219 Name: LAYOFF,LAURA
 Incorrect Flag:
 Layoff:                    Rehire:                   Recall:
  Title Code  : 7242         Begin Date   : 0001-01-01 Begin Date   : 0001-01-01
  Dept Code   : 040000       End Date     : 0001-01-01 End Date     : 0001-01-01
  Unit Code   :              Term/Susp Beg: 0001-01-01 Term/Susp Beg: 0001-01-01
  Notice Date : 2008-05-30   Suspense End : 0001-01-01 Suspense End : 0001-01-01
  Pay Rate    :              Term/Susp Rsn:            Term/Susp Rsn:
  Rate Code   :
  Percent Time:
  Sev Paid    :   5977.00
  Sev Days    : 30
  Sev Payback : Y          Sev Payback Amt:
 Next Func:      ID:           Name:                            SSN:
      Date:        View incorrect records?
 ===>
  F:  1-Help      2-Browse    3-PrevMenu
  F:                                                             12-Exit
 


Layoff Data is displayed on this screen.

IQTR - Quarterly Accumulators

This screen is not in use at this time.

ISAB - Sabbatical Credit

PPISAB0-I0944                  History Inquiry                03/31/YY 17:42:09
                              Sabbatical Credit                Userid:  ABCDE
 ID: 400473497 Name: CONTRARY,MARY                
 Incorrect Flag:

 Last Sabbatical Credit Balance : 32
 Last Sabbatical Credit Accrued : 39
 Sabbatical Credit Date         : 07/01/2008
 Sabbatical Credit Used         :  9
 Total Sabbatical Credit Balance: 32






 Next Func:      ID:           Name:                            SSN:
      Date:        View incorrect records?
 P0053  No data for requested date or prior dates
 ===>
  F:  1-Help      2-Browse    3-PrevMenu
  F:                                                             12-Exit


ISAB displays historical sabbatical data for an employee, one historical sabbatical credit entry per screen. The user can scroll through any other sabbatical data entries for the employee by using the F10 and F11 keys. The user may view historical records for a specific entry date by entering that date in the field labeled 'Date:' in the footer. If the user leaves the 'Date:' field blank, the record with the most recent date will be displayed first.

ISVC - Service Credit Data

PPISVC0-I1144                  History Inquiry                05/21/YY 17:53:18
                             Service Credit Data               Userid:  ABCDE
 ID: 903569730 Name: LAUREL,STANLEY 			 
 Incorrect Flag:

 Terminal Comp Time Paid    :            Q/S Teaching Assistant   :
 Terminal Sick Leave Balance:            Q/S Teach Asst/Accum Type:
 Terminal Vacation Paid     :
 Accrued Through Date       :
                                         Q/S in Unit 18 Titles    :
 Employment Service Credit  :            Q/S Unit 18/Accum Type   :
 Empl Service Credit Date   :
                                         Q/S/M in 8-Year Rule     :
 Extension to 8-Year Rule   :            Q/S/M 8-Year/Accum Type  :
 Ext 8-Year/Accum Type      :
                                         Q/S/M on 19900 Funds     :
                                         Q/S/M 19900/Accum Type   :

 Next Func:      ID:           Name:                            SSN:
      Date:        View incorrect records?
 P0053  No data for requested date or prior dates
 ===>
  F:  1-Help      2-Browse    3-PrevMenu
  F:                                                             12-Exit


Only Employment Service Credit data has been loaded into the HDB as of this writing. All other service credit data is entered and viewed on the EACD and EPD2 screens in EDB Entry/Update.

IYRL - Yearly Accumulators

PPIYRL0-I1155                  History Inquiry                05/22/YY 18:02:50
12/31/YY 15:56:43           Yearly Accumulators               Userid:  ABCDE
ID: 610204559 Name: STEWART,JIMMIE               
Incorrect Flag:

YTD Total Gross      :   41580.89
YTD Regular Pay      :   40321.00
YTD Addnl Comp-Summer:









Next Func:      ID:           Name:                            SSN:
     Date:        View incorrect records?

===>
 F:  1-Help      2-Browse    3-PrevMenu
 F:                                     10-PrevRec              12-Exit


The Total Gross for a calendar year is displayed on this screen.

B2.4 UHDB - Update Function Code Menu

UHDB provides the user with a mechanism to flag incorrect records by marking a row as incorrect. This is necessary because the EDB is sometimes updated with incorrect information by mistake. In order to flag the record as incorrect, the user must have access to IHDB. Anyone with access to IHDB also has access to UHDB.

The UHDB menu is identical to the IHDB menu except that the function codes begin with ‘U’ instead of ‘I’ (for example, IATN Action Code Data would be listed at UATN Action Code Data on the UHDB menu). The screens are identical in IHDB and UHDB except that with UHDB the user can flag a row of data as incorrect. This is the only update screen where a user can actually update his or her own record.

To flag an appointment row as incorrect, for example, enter UAPN and an employee ID, name or SSN number.

PPIAPN0-I1287                  History Inquiry                05/22/YY 15:19:13
 05/08/YY 00:31:08             Appointment Data                Userid:  ABCDE
 ID: 000207468 Name: ROGERS,ROY A           

 Incorrect Flag: X Appt No. 10

 Appt Begin Date: 07/01/2008                          Time Rpt Code : R
 Appt End Date  : 99/99/99                            Fixed/Variable: F
 Appt Duration  : I                                   Personnel Prog: 2
 Title Code     : 0280                                Paid Over Code: 00
 Title Unit     : 99                                  Leave Accrual : D
 Title Spec Hdlg:
 FLSA           : 1                                   Appt Pay Sched: MO
 Department Code: 356500                              Appt Rate Code: A
 Sub-location   :                                     Annual/Hourly
 Appt Rep Code  : S                                        Rate     :  69636.00
 Appt Basis Code: 00                                  Salary Grade  : 1
 Appt Type Code : 2                                   Acad. Rank Dt :
 Appt Time      : 1.00
 Next Func:      ID:           Name:                            SSN:
      Date:        View incorrect records?
 P0052  Record has been updated successfully
 ===>
  F:  1-Help                  3-PrevMenu
  F:                          9-UPDATE   10-PrevRec              12-Exit


Press the Home key and the cursor will jump to the Incorrect Flag field. Type an "X" in the Incorrect Flag field and press F9. When a message is displayed in the message line that the record has been updated successfully, the row has been flagged.

The row will remain flagged as incorrect until the flag is deleted. To delete the flag, position the cursor on the "X", press the delete key to remove the code, and press F9 to update. The message "Record has been updated successfully" will be displayed, and the Incorrect Flag field will be empty.

B2.5 Help

On-line help can be accessed on each HDB Screen by pressing F1.   Information on the individual fields on the screens is accessed by moving the cursor to the field (by using a mouse or the arrow keys on the keyboard) and then pressing F1.   Detailed information on using Help can be found in the EDB Manual, Section A5.  Information on the data can also be found in the HDB Field/Screen Cross Reference Chart.

to top


Previous Next