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

B1.0 OVERVIEW OF THE HISTORY DATA BASE (HDB)


The Personnel History Reporting System was designed as a collaborative effort by the personnel offices at all the UC campuses. It is intended to provide departmental administrators with various views of the data which have been collected and retained historically in the History Data Base (HDB) of the Personnel/Payroll System since 1992.

At UCLA, the HDB is updated nightly with selected data entered into the Employee Data Base (EDB) during the day by department preparers or by system batch transactions.

There are three ways to view the data in the HDB:

  1. IHIS - Personnel History
  2. IHDB - Record Inquiry/Update
  3. IHHR - History Documents

B1.1 Personnel History Reporting System (IHIS)

The Personnel History Reporting System is intended to be the method by which users can see a consolidated picture of the important events in an individual’s employment history. It is an on-line personnel history report. The system is not intended to be an audit trail of all EDB Entry/Update activity. It displays only the activity that was considered to be of greatest significance to department personnel administrators.

In order to access the Personnel History Reporting Screens, the user may access the main menu screen and select the appropriate screen. The menu appears below:

UCFM140-M0967                 History Reporting               06/04/YY 11:16:56
                            Personnel History Menu             Userid:  ABCDE   
                                                                                
   HSUM Appointment Summary History      IHTX W-4/DE4 Selection Menu            
   HLOA Leave of Absence History                                                
   HADC Appt./Dist. History - Compact                                           
   HPER Personal Data History                                                   
   HSEP Separation History Data                                                 
   HWHO History Browse                                                          
   HLIC License & Certification Data                                            
   HHNR Academic Honors History                                                 
   HBKG Background Check History                                                
   HAWD Award Data History                                                      
   HSLA Sabbatical Accrual History                                              
   HSLV Sabbatical Leave History                                                
   HLOF Layoff Data History                                                     
   HADF APPT./DIST. HISTORY - FULL                                              
                                                                                
Next Func: hsum ID: 400207451 Name:                            SSN:            
As Of Date:        Past To Present:    View Incorrect Records:                 
                                                                                
===>                                                                           
F:  1-Help                  3-PrevMenu                                        
F:                          9-MainMenu                         12-Exit


On April 30, 1992, the History Data Base at UCLA was populated with all the data present in the Employee Data Base as of that date, and thereafter the HDB began to record change activity. However, many of the data elements identified for display on the Personnel History Reporting screens were not available in the EDB until after the on-line entry/update system was implemented in 1994/95. Therefore, only the following screens include information back to 1992:

The remaining screens reflect data entered into the EDB beginning in November 1995 except for the Layoff History Data Screen.  The Layoff Data History screen was put into use at a later date after a procedure was implemented for entry of layoff information into the EDB. 

A brief description of each screen is included in the chart below.

Function/
Screen Name
Brief
Description
Screens
HSUM -
Appointment Summary History
Presents a condensed version of appointment data that has been recorded in the HDB.
PPHSUM0-I1304                History Reporting               07/05/YY 16:10:05
Last Update: 07/03/YY    Appointment Summary History          Userid:  ABCDE   
ID: 400285596 Name: GRANT,KERRY                                    PG 01 OF 02
Hm Dept: 356500 ACCOUNTING SERVICES         Status: Active            ITR: 001 
Most Recent Hire Date: 06/17/94          Separation Date:                      
Appt                                    Step  Annual/        Begin    End      
 No  Title Title Name                   Grade Hourly Rt  %   Date     Date     
     Last Action      Pers Prog/Appt Type/FLSA    Appt Dept            SubL    
  1* 7242  ANALYST, ADMINISTRATIVE, SR    4     50104.00 100 07/01/07 99/99/99 
                      Prof/Staf/Career  /Exempt    ACCOUNTING SERV             
                                                                                
  2  7243  ANALYST, ADMINISTRATIVE        2     47400.00 100 05/17/06 99/99/99 
                      Prof/Staf/Career  /NonExempt ACCOUNTING SERV             
                                                                                
  3  7243  ANALYST, ADMINISTRATIVE        2     44460.00 100 07/01/05 99/99/99 
                      Prof/Staf/Career             HUMAN RESOU                  
                                                                                
                                                                                
Next Func:      ID:           Name:                            SSN:            
As Of Date:        Past To Present:    View Incorrect Records:                 
                                                                               
===>                                                                           
 F:  1-Help      2-Browse    3-PrevMenu                                        
 F:              8-Forward   9-MainMenu                         12-Exit
HLOA -
Leave of Absence History
Displays all leave data which has been recorded for an employee in History.
PPHLOA0-I1105                History Reporting               07/05/YY 16:50:40
Last Update: 07/03/YY      Leave of Absence History           Userid:  ABCDE   
ID: 200557380 Name: ALCOTT,LOUISA M                            
Hm Dept: 356500 ACCOUNTING SERVICES         Status: Active            ITR: 002 
                                                                               
Leave    Leave   Leave Leave      TUC/  Primary                  Home          
Begin    Return   Type Reason     EREP    Title                  Department    
05/02/05 08/01/05                                                              
             Change in Leave Return Date                                       
05/02/05 08/28/05 LWOP Childbearing                             ACCOUNTING SER
                                  CX/C     4724  _____ASSISTANT I              
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
Next Func:      ID:           Name:                            SSN:            
As Of Date:        Past To Present:    View Incorrect Records:                 
                                                                               
===>                                                                           
 F:  1-Help      2-Browse    3-PrevMenu                                        
 F:                          9-MainMenu                         12-Exit
HADC -
Appt./Dist History - Compact
Displays historical information summarizing appointment and distribution information for an employee in a compact manner with less data at the distribution level.
PPHADC0-I1287                History Reporting               07/05/YY 15:30:16
Last Update: 07/03/YY   Appt./Dist. History - Compact         Userid:  ABCDE   
ID: 400292154 Name: EINSTEIN,AL                                    PG 01 OF 08
Hm Dept: 100000 PHYSICS & ASTRONOMY         Status: Active            ITR: 001 
Most Recent Hire Dt: 01/01/71  Separation Dt:           EREP/EUC: C FX         
Appt   1* Title: 3200 RESEARCH _____ - 11-MONTHS    Academic /Acad/FX  Grd:    
       Begin Dt: 07/01/07  Ann/Hr Rt:   73000.00 Rt: A  %: 1.0000 Variable    
       End Dt  : 06/30/08 Sched: MO LV: D Tuc/Sh/Rep: FX/ /C Bas/Pd Ovr: 11/12
       Dur:                           Dept: 100000  PHYS/ASTRO                
Sub-location                                              Tot Dis/Rem: 44/37   
Dis  Fte  Dis %   Pay Beg  Pay End   Rate/Amt  Dos Step OA Prq D  W Action       
 1*  0.00 0.2500  06/01/08 06/30/08    6508.33 REG    1  F                       
 2*  0.00 0.2500  06/01/08 06/30/08    6508.33 REG    1  F                       
 3*  0.00 0.2500  06/01/08 06/30/08    6508.33 REG    1  F                       
 4*  0.00 0.2500  06/01/08 06/30/08    6508.33 REG    1  F                       
 5   0.00 0.2500  04/01/01 05/31/08    6508.33 REG    1  F          33           
 6   0.00 0.2500  04/01/01 05/31/08    6508.33 REG    1  F          33           
 7   0.00 0.2500  03/01/01 06/30/08    6508.33 REG    1  F          33           
Next Func:      ID:           Name:                            SSN:            
As Of Date:        Past To Present:    View Incorrect Records:                 
                                                                                
===>                                                                           
 F:  1-Help      2-Browse    3-PrevMenu                                        
 F:              8-Forward   9-MainMenu                         12-Exit
HPER -
Personal Data History
Designed to display an assortment of general historical data for an employee such as Original Hire Date, most recent hire date, and citizenship code.
PPHPER0-I1450                 History Reporting               02/12/YY 19:34:26
Last Update: 01/28/YY       Personal Data History             Userid:  ABCDE   
ID: 601872159 Name: KLINE,PATSI K                                  PG 00 OF 01
Hm Dept: 119000 POLITICAL SCIENCE           Status: Active            ITR: 002 
Most Recent Hire : 01/01/06    Prob Per End Dt:           Sep Dt  :            
Original Hire    : 08/23/04    Emp Ser Credit :           Last Day:            
Oath Signature Dt: 08/23/04              From :           Sep Rea :            
I-9 Date         : 08/23/04    Prior UC/ST Service:       EREP/ESH/EDUC: C/ /  
Citizen: C  Visa :             BELI: 5 01/01/06           EREL/EUC: H/BX       
Student Status   : 4           Ret/FICA       : N/N                            
Sex: F   Ethnic  : F           Ret FICA Derive: Y         Educ Level    : B    
Veteran Status   : N/ /N       Date Of Birth : 01/17/75   Educ Level Yr : 96   
Disabled Status  : N
Primary Title: 2310 TEACHING ASSISTANT - GSHIP                                 
Job Group ID :  426                                                            
Perm Addr: 37 NASHVILLE ST                                                     
                                                                                
            VENICE                CA 90291                                      
Next Func:      ID:           Name:                            SSN:            
As Of Date:        Past To Present:    View Incorrect Records:                 
                                                                                
===>                                                                           
 F:  1-Help      2-Browse    3-PrevMenu                                        
 F:              8-Forward   9-MainMenu                         12-Exit
HSEP -
Separation History
Presents historical separation information recorded for an employee.
PPHSEP0-I1105                 History Reporting               07/09/YY 19:37:4
Last Update: 06/08/YY      Separation History Data            Userid:  ABCDE  
ID: 5002348723 Name: FERRERA,JOE M                                           
Hm Dept: 317000 ON CAMPUS HOUSING           Status: Active            ITR: 001
                                                                              
Separation Date:       01/01/04   Reason: I4 Inactive 4 Months                
Last Day On Pay:       01/01/04   Primary TC: 5117 CUSTODIAN                  
Most Recent Hire Dt:   06/25/03   Home Dept:  317000 ON CAMPUS HSG            
Term Vac Paid:                                                                
Term Sick Bal:                                                                
Term Comp Paid:                   Future Inst:                                
                                                                               
Separation Date:       09/17/03   Reason: CB Term. of Casual Empl             
Last Day On Pay:       08/06/03   Primary TC: 5117 CUSTODIAN                  
Most Recent Hire Dt:   06/25/03   Home Dept:  317000 ON CAMPUS HSG            
Term Vac Paid:                                                                
Term sick Bal:                                                                
Term Comp Paid:                   Future Inst:                                
Next Func:      ID:           Name:                            SSN:           
As Of Date:        Past To Present:    View Incorrect Records:                
                                                                               
===>                                                                          
 F:  1-Help      2-Browse    3-PrevMenu                                       
 F:                          9-MainMenu                         12-Exit
HWHO -
History Browse
Displays a complete list of employees and their record keys to assist the user in locating a specific employee record. A single employee may have multiple records in history.
PPHWHO0-I1105                 History Reporting              07/09/YY 15:22:42
                                 History Browse                Userid:  ABCDE   
Entered: ID:           Name: JONES,SAM                                     
   ID        ITR# NAME                    STAT Department    Arch Dt
   900517500 001  JONES,SAM                    <      >               
 __900517500 002  JONES,SAM                 A  STUDENT HEALTH         
   000754124 001  JONES,SAMANTHA M          S  OFC STU DISABIL        
   100890385 001  JONES,SAMUEL DAVID           <      >               
   100890385 002  JONES,SAMUEL DAVID        I  CHEM & BIOCHEM         
   901102312 001  JONES,SAUL V              A  <165500>               
   201102332 001  JONES,SCOTT                  <      >               
   201102332 002  JONES,SCOTT               S  PHARMACOLOGY           
   900773909 001  JONES,SHANETTA T          S  LAW                    
   701102362 001  JONES,SHARI A             A  MC-ENVIRON-MP          
   902619395 001  JONES,SHARLENE            A  INTERCOLL ATHL         
   500869648 001  JONES,SHARON                 <      >               
   500869648 002  JONES,SHARON              I  OFC INSTRUC DEV        
   501102393 001  JONES,SHARON T            A  NURSING                
Next Func:  HWHO ID:           Name:                            SSN:            
As Of Date:        Past To Present:    View Incorrect Records:                 
                                                                                
===>                                                                           
 F:  1-Help      2-Jump      3-PrevMenu                                        
 F:  7-Backward  8-Forward   9-MainMenu                         12-Exit
HLIC -
License & Certification Data
Displays historical information on licenses and certifications held by an employee and their renewal dates.
PPHLIC0-I1063                 History Reporting              07/09/YY 11:04:30
Last Update: 07/03/YY    License & Certification Data         Userid:  ABCDE   
ID: 000216547 Name: SMITH,MISTER                                
Hm Dept: 165500                             Status: Active            ITR: 001 
Lic/Cert  Number        Description                        Renewal Date        
  CDL     C0444333      CA DRIVERS LICENSE                  03/20/09           
  CSW     19991         CLINICAL SOCIAL WORKER LICEN        07/31/08           
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
Next Func:      ID:           Name:                            SSN:            
As Of Date:        Past To Present:    View Incorrect Records:                 
                                                                                
===>                                                                           
 F:  1-Help      2-Browse    3-PrevMenu                                        
 F:                          9-MainMenu                         12-Exit
HHNR -
Academic Honors History
Displays historical information on honors that have been received by academic staff members.
PPHHNR0-I1105                History Reporting               07/10/YY 10:44:54
Last Update: 07/03/YY      Academic Honors History           Userid:  ABCDE   
ID: 201627020 Name: MOORE,RANDALL R                            
Hm Dept: 011500 DEAN, SEAS                   Status: Active            ITR: 001 
Highest Degree: D 1956 Institution: NAU U OF CALIFORNIA LOS ANGELES            
Degree Specialty:   0900 ENGINEERING                                           
Current Specialty:  0906 CHEMICAL ENGINEERING                                  
                                                                                
                                                                                
        Honor                                      Honor Date                  
        NAE    NATL ACADEMY OF ENGINEERING          07/85                      
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
Next Func:      ID:           Name:                            SSN:            
As Of Date:        Past To Present:    View Incorrect Records:                 
                                                                                
===>                                                                           
 F:  1-Help      2-Browse    3-PrevMenu                                        
 F:                          9-MainMenu                         12-Exit
HBKG -
Background Check History
Displays historical information related to background checks which have been conducted on an employee.
PPHBKG0-I0961                History Reporting                02/14/YY 11:41:26
Last Update: 01/11/YY      Background Check History           Userid:  ABCDE   
ID: 202698065 Name: DARLING,WENDY J                             
Hm Dept: 287100                             Status: Active            ITR: 001 
Background                                     Background                      
Check Code     Description                     Check Date                      
    01         PREVIOUS EMPLOYERS REFERENCE     12/01/05                       
    02         CRIMINAL CONVICTION RECORD CK    12/01/05                       
    06         PROF LICENSE/CERTIFICATE VERIF   12/01/05                       
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
Next Func:      ID:           Name:                            SSN:            
As Of Date:        Past To Present:    View Incorrect Records:                 
                                                                                
===>                                                                           
 F:  1-Help      2-Browse    3-PrevMenu                                        
 F:                          9-MainMenu                         12-Exit
HAWD -
Award Data History
Displays the incentive awards that have been given to a staff employee.
PPHAWD0-I1200                History Reporting               07/10/YY 11:27:29
Last Update: 07/03/YY        Award Data History              Userid:  ABCDE   
ID: 400535012 Name: TWAIN,SAMUEL C                              
Hm Dept: 056500 ENGLISH                     Status: Active            ITR: 001 
Award  Date    Amount       Source                          Home Department  
 PDA  06/05     1500.00     66125                           ENGLISH             
 PDA  02/05      250.00     66124                           ENGLISH             
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
Next Func:      ID:           Name:                            SSN:            
As Of Date:        Past To Present:    View Incorrect Records:                 
                                                                                
===>                                                                           
 F:  1-Help      2-Browse    3-PrevMenu                                        
 F:                          9-MainMenu                         12-Exit
HSLA -
Sabbatical Accrual History
Reflects academic sabbatical accrual and usage based on data entered by departments on the ELVE screen in EDB Entry/Update.
PPHSLA0-I0961                History Reporting               07/10/YY 12:15:41
Last Update: 07/03/YY     Sabbatical Accrual History         Userid:  ABCDE   
ID: 301429378     Name: COOPER, GERRY                        
Hm Dept: 030000 GRADUATE SCHOOL OF MANAGEME Status: Active            ITR: 001 
                                                                                
Last Sab Sab Credit  Accrued  Sab Credit   Used   Sabbatical                   
Balance   Accrued    Thru DT     Used      Date   Credit Bal                   

   0        0         07/08       0                   3
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
Next Func:      ID:           Name:                            SSN:            
As Of Date:        Past To Present:    View Incorrect Records:                 

===>                                                                           
 F:  1-Help      2-Browse    3-PrevMenu                                        
 F:                          9-MainMenu                         12-Exit
HSLV -
Sabbatical Leave History
Displays historical distribution information related to academic sabbatical leaves of absence.
PPHSLV0-I1138                History Reporting               07/10/YY 12:03:39
Last Update: 07/03/YY      Sabbatical Leave History          Userid:  ABCDE   
ID: 401929978   Name: HEMMINGWAY,ERNIE                     
Hm Dept: 030000 GRADUATE SCHOOL OF MANAGEME Status: Active           ITR: 001 
                        Sabbatical Leave Distributions                         
                      Begin Dt    End Dt     DOS  % Time                       
                      10/01/05    02/29/06   SLS     33                        
                      10/01/05    02/29/06   SLS     33                        
                      07/01/05    09/30/05   SLS     33                        
                      07/01/05    02/29/06   SLS     33                        
                      07/01/05    02/29/06   SLS     33                        
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
Next Func:      ID:           Name:                            SSN:            
As Of Date:        Past To Present:    View Incorrect Records:                 
                                                                               
===>                                                                           
 F:  1-Help      2-Browse    3-PrevMenu                                        
 F:                          9-MainMenu                         12-Exit
HLOF -
Layoff Data History
Displays historical information related to layoff, recall, and preferential rehire for each appointment held by an employee.
PPHLOF0-I0961                History Reporting               03/08/YY 08:00:11
Last Update: 03/04/YY        Layoff Data History              Userid:  ABCDE   
ID: 219000219 Name: LAYOFF,LAURA                               
Hm Dept: 356500 ACCOUNTING SERVICES Status: Active            ITR: 001 
                                                           Sex: F Ethnic: F     
Layoff Notice Date: 05/30/08  Layoff %: 0.00   Layoff Salary:
Title: 7242 ANALYST, ADMINISTRATIVE,    TUC/EREP: 99 E  Salary Max:
Dept:  040000 DEAN SCH AR              Layoff Unit:        DESC N/F
Severance Paid / Days :   5977.00 30  Sev Payback Ind / Amt : Y       .00
Recall Beg Dt:          Recall End Dt:
   Recall Sus Begin:           Recall Sus End/Term:
          Reason:
Rehire Beg Dt:          Rehire End Dt:
   Rehire Sus Begin:           Rehire Sus End/Term:
          Reason:
Separation Dt: 05/30/08 Last Day On Pay: 05/30/08
          Reason: CG Layoff: severance
Term Sick Leave Bal:      .00  Accrued Through Dt:
Next Func:      ID:           Name:                            SSN:
As Of Date:        Past To Present:    View Incorrect Records:
                                             
===>                                                                           
 F:  1-Help      2-Browse    3-PrevMenu                                        
 F:                          9-MainMenu                         12-Exit
HADF -
Appt./Dist. History - Full
Displays historical information summarizing appointment and distribution data for an employee.
PPHADF0-I1304                History Reporting               07/09/YY 19:30:26
Last Update: 07/03/YY     APPT./DIST. HISTORY - FULL         Userid:  ABCDE   
ID: 501769015 Name: WAINE,DUKE JON                              PG 01 OF 05
Hm Dept: 356500 ACCOUNTING SERVICES         Status: Active            ITR: 001 
Most Recent Hire Dt: 01/09/89  Separation Dt:           EREP/EUC: S 99         
Appt   1* Title: 7242 ANALYST, ADMINISTRATIVE, SR   Prof/Staf/Care/EX  Grd: 4  
       Begin Dt: 10/01/00  Ann/Hr Rt:   50174.00 Rt: A  %: 1.0000 Fixed       
       End Dt  : 99/99/99 Sched: MO LV: K Tuc/Sh/Rep: 99/ /S Bas/Pd Ovr: 00/00
       Dur: Indefinite                Dept: 356500 ACCOUNTING SERV            
Sub-location                                              Tot Dis/Rem: 15/12   
Dis  Fte  Dis %   Pay Beg  Pay End   Rate/Amt  Dos Step OA Prq D  W Action       
      Loc-Account-Cost Ctr-Fund-Proj Cd-Sub                                    
 1*  0.00 1.0000  10/01/00 09/30/01    4181.18 RES                27           
       4  660525           19900         1  ACCOUNTING SERVICES        
 2*  0.00 0.6000  10/01/00 09/30/01    4181.18 REG                27           
       4  660525           19900         1  ACCOUNTING SERVICES        
 3   0.00 1.0000  07/01/00 09/30/00    4148.00 RES                             
       4  660525           19900         1  ACCOUNTING SERVICES        
Next Func:      ID:           Name:                            SSN:            
As Of Date:        Past To Present:    View Incorrect Records:                 
                                                                               
===>                                                                           
 F:  1-Help      2-Browse    3-PrevMenu                                        
 F:              8-Forward   9-MainMenu                         12-Exit
IHTX -
W-4/DE4 Selection Menu
Display historical W-4 information for an employee.
PPIHTX0-I1334               History Reporting               09/12/08,12:27:52
Last Update: 09/02/08    W-4/DE4 Selection Menu             Userid: ABCDE
ID: 801801808 Name: TAX,TOOMUCH                             Page    1 of    1
Hm Dept: 352500 PAYROLL                     Status: Active            ITR: 001 
       W4/DE4      Mar 
       Process Dt  Stat   #Allowances    Addl Tax     Tax Processor ID 
                                                                               
 FED:               S     001                 .00 
 CA:                S     997 /000            .00 
 FED:         
 CA:          
 FED:         
 CA:          
 FED:         
 CA:          
 FED:         
 CA:         
Email Address:                                                  
Next Func:     ID:          Name:                           SSN:         

===>,                                                                        
 F: 1-Help     2-Jump     3-PrevMenu                                  
 F:                       9-GenDoc                       12-Exit    


B1.2 History Data Base Inquiry and Update (IHDB & UHDB)

IHDB provides a way for a user to view each individual table and its rows of data in the HDB (e.g. personnel action codes data are in one table, appointment data are in another table and distribution data are in a third table). There is no method in IHDB by which a user can view a consolidated set of data (e.g. a distribution, its related appointment and personnel action code).

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.

These functions are only useful when it is necessary to view actual rows of data in history and to mark rows as incorrect. IHDB access should be given to employees who either have access to the Personnel History Reporting screens or to PPQDB. IHDB is useful in interpreting and understanding the data selected and presented on the History Reporting screens. It is also useful in "debugging" QDB queries.

The menu for IHDB is shown below. The UHDB menu is identical except that the function codes begin with U instead of I (for example, IATN Action Code Data would be listed as 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.

UCFM140-M0967                  History Inquiry                07/10/YY 07:49:34
                          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:      ID:           Name:                            SSN:            
      Date:        View incorrect records?                                      
                                                                                
 ===>                                                                           
  F:  1-Help                  3-PrevMenu                                        
  F:                                                             12-Exit


The rows of data in the HDB do not show appointments with distributions or related action codes. The HADF screen for Duke Jon Waine displays appointment 10 with its related distributions (the last screen displayed in the table above). To see the same information using IHDB, the user would have to access several screens. One of these screens is shown below. The IDST screen displays information for only distribution 14 which is shown as 1* on the above HADF screen. The data is more difficult to interpret without the related appointment and the other distributions.

PPIDST0-I1138                  History Inquiry                05/21/YY 07:55:10
 11/08/YY 23:50:21      Appointment Distribution Data          Userid:  ABCDE   
 ID: 501769015 Name: WAINE,DUKE JON                           
 Incorrect Flag:   Appt No. 10 Dist No. 14                                      
                                                                               
 Charge Start Date: 10/01/2000                     Dist Pay Rate  :   4030.0000 
 Charge Stop Date : 09/30/2001                     Salary Step    :             
 Location         : 4                              Off/Above Scale:             
 Account          : 660525                         Full Time Equiv:             
 Cost Center      :                                Perquisite Type:             
 Fund             : 19900                          Work Study Prog:             
 Project Code     :                                                             
 Subaccount       : 1                                                           
 Descrip of Serv  : RES                                                         
 Department Code  : 356500                                                      
 Distribution Unit:                                                             
 Range Adjust Unit:                                                             
 Distribution Time: 1.0000                                                      
 Next Func:      ID:           Name:                            SSN:            
      Date:        View incorrect records?                                      
                                                                              
 ===>                                                                           
  F:  1-Help      2-Browse    3-PrevMenu                                        
  F:                                     10-PrevRec  11-NextRec  12-Exit


B1.3 History Documents (IHHR)

Departments can print a variety of history reports for departmental use or to give to an employee. In order to print a history document, the document preparer would need to select a printer, access the History Document Selection menu (shown below), and select the appropriate document.

PPIHHR0-I1084                 History Reporting               07/10/YY 08:06:06
 Last Update: 07/03/YY       Report Selection Menu             Userid:  ABCDE   
 ID: 801863965 Name: HISTORY,HELGA                                  PG 01 OF 01
 Hm Dept: 356500 ACCOUNTING SERVICES         Status: Active            ITR: 001 

    Staff Salary History Card                                                   
    Academic Salary History Card                                                
                                                                                
    -- Salary History Card Selection (select one)                               
    Full Salary History w/Full Appt/Dist History                                
    Full Salary History w/Title Step Synopsis                                   
    Full Salary History w/Title Synopsis Only                                   
    Title Step Synopsis and Leave History                                       
    Personal Data History                                                       
    Appointment History w/Full Appt/Dist History                                
    Appointment History w/Title Step Synopsis                                   
    Appointment History w/Title Synopsis Only                                   
    Leave History                                                               
    Awards History
    -- Distribution Selection (select one)                                   
    Regular Distributions and Equivalents                                    
    Regular Distributions, Shift Differentials, and Equivalents              
    Regular Distributions, Stipends, and Equivalents                         
    All Distributions                                                        
    Specified DOS Codes                                                      
                                                                            
 Next Func:      ID:           Name:                            SSN:            
                                                                                
===>                                                                           
  F:  1-Help      2-Jump      3-PrevMenu              5-Cancel    6-Pick DOS    
  F:              8-Forward   9-GenDoc                           12-Exit


A sample of a Non-Academic Salary History Report which displays the Full Appointment Distribution History for an employee is shown below.  The actual report will print on two or more landscape pages.

FUNC IHHR                         UNIVERSITY OF CALIFORNIA-LOS ANGELES                 Print Date: 03/07/YY
0829XX                                  PAYROLL/PERSONNEL SYSTEM                                Page 1 of 1
                                        History Data Base Report
NON-ACADEMIC SALARY HISTORY REPORT-FULL APPOINTMENT DISTRIBUTION HISTORY
HISTORY,HELGA   STATUS: Active   MOST RECENT HIRE: 10/03/88        PROB.PERIOD END DT:
777166333                        ORIGINAL HIRE: 10/03/88           NEXT SALARY REVIEW: 07/08 Merit Increase
356500 ACCOUNTING SERV           EMP.REL.CODE.: E-Not Confidential EMP.UNIT CODE: CX AFSCME Clerical
*****************************************APPOINTMENT HISTORY***********************************************
DOS Selection = All Distributions
APPOINTMENT/DISTRIBUTION DATA
Prof/Staf / Regular/Career	07/01/96 to 99/99/99	DUR: Indefinite	  356500 ACCOUNTING SERV
4722 _____ASSISTANT III	% FULL TIME: 1.00 FIXED	   33480.00  Annually     GRADE:   TUC:   REP:   LEAVE: A
Staff     / Regular/Career	05/22/95 to 06/30/96	DUR: Indefinite	  356500 ACCOUNTING SERV
4722 _____ASSISTANT III	% FULL TIME: 1.00 FIXED	   31332.00  Annually     GRADE:   TUC:   REP:   LEAVE: A
27 MERIT MARK-UP	           01/01/97
   01/01/97 to 99/99/99 Step: 3.0	                2790.00	REG-REGULAR	     %: 1.0000
         4-660525- -19900- -1 ACCOUNTING SERVICES-PAYROLL
28 RANGE ADJUSTMENT	           10/01/96
   10/01/96 to 99/99/99 Step: 2.0	                2663.00	REG-REGULAR	     %: 1.0000
         4-660525- -19900- -1 ACCOUNTING SERVICES-PAYROLL
28 RANGE ADJUSTMENT	           10/01/96
   10/01/95 to 99/99/99 Step: 2.0	                2611.00	REG-REGULAR	     %: 1.0000
         4-660525- -19900- -1 ACCOUNTING SERVICES-PAYROLL
18 CHANGE IN FUND SOURCE	   07/01/95
   07/01/95 to 09/30/95 Step: 2.0	                2572.00 REG-REGULAR	     %: 1.0000
         4-660525- -19900- -1 ACCOUNTING SERVICES-PAYROLL
   05/22/95 to 06/30/95 Step: 2.0	                2572.00	REG-REGULAR	     %: 1.0000
         4-660500- -19900- -1 ACCOUNTING SERVICES
10 PROMOTION	                   10/15/91
Staff     / Regular/Career	10/15/91 to 05/21/95    DUR:             356500 ACCOUNTING SERV
4722 _____ASSISTANT II	% FULL TIME: 1.00 FIXED	    29640.00   Annually  GRADE:   TUC: CX REP: C LEAVE: A
27 MERIT MARK-UP	           01/01/94
   01/01/94 to 99/99/99 Step: 3.0	                2265.00	REG-REGULAR	     %: 1.0000
         4-660500- -19900- -1 ACCOUNTING SERVICES
   10/29/93 to 99/99/99 Step: 2.0	                2173.00	REG-REGULAR	     %: 1.0000
4-660500- -19900- -1 ACCOUNTING SERVICES
   07/01/93 to 10/28/93 Step: 2.0 Temp 93/94 Red	2173.00	REG-REGULAR	     %: .9500
4-660500- -19900- -1 ACCOUNTING SERVICES
27 MERIT MARK-UP	07/01/92
07/01/92 to 99/99/99 Step: 2.0	2173.00	REG-REGULAR	%: 1.0000
4-660500- -19900- -1 ACCOUNTING SERVICES
***********************************************************************************************************
LEAVE OF ABSENCE INFORMATION
Leave Begin Date        Leave Return Date        Leave Type
>>>> No data available. <<<<
***********************************************************************************************************
SEPARATION INFORMATION
Separation Date     Last Day on Pay Status      Separation Reason
>>>> No data available. <<<<
***********************************************************************************************************
AWARD INFORMATION
                      Award Date                   Award Amount        Award Type
                       05/01/95                       500.00           SPECIAL PERFORMANCE AWARD

 

 

to top


Previous Next