Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

HISTERR


                              HISTERR FILE

Contains history errors moved using HR54.1 (Employee History  Correction) and
PA54.1 (Personnel Action History Correction).

REFERENCED BY

HR105     PA105     PA340     HRLO.1    PA67.1    HR701
PA66.1    PA66.2    PA66.3

UPDATED BY

HGLM.1    HPOS.1    HPQC.1    HPRS.1    HR11.1    HR11.2
HR125     HR15.1    HR511     HR515     HR54.1    HR650
HRS1.1    HRSC.1    PA02.1    PA100     PA102     PA113
PA125     PA13.1    PA13.2    PA502     PA513     PA52.1
PA52.3    PA52.4    PA52.5    PA54.1    PR110     PR113
PR120     PR13.1    PR13.5    PR13.6    PR13.8    PRSC.1
PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

HER-COMPANY            Numeric 4                                 HGLM.1  HPOS.1
Element: Company       The company number represents an          HPQC.1  HPRS.1
                       established company and is entered on     HR11.1  HR11.2
                       all function codes.                       HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-EMPLOYEE           Numeric 9                                 HGLM.1  HPOS.1
Element: Employee      Contains the employee number. Each        HPQC.1  HPRS.1
                       person employed by the company is         HR11.1  HR11.2
                       assigned a unique number. The system      HR15.1  HR511
                       uses the employee number to correlate     HR515   HR54.1
                       all of the information related to that    HR650   HRS1.1
                       person.                                   HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-OBJ-ID             Numeric 12                                HGLM.1  HPOS.1
Object                 Contains a system-assigned identifier     HPQC.1  HPRS.1
Identification         that provides access to data in related   HR11.1  HR11.2
                       files.                                    HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-EFFECT-DATE        Numeric 8  (yyyymmdd)                     HGLM.1  HPOS.1
Element: Date          Contains the date the item was            HPQC.1  HPRS.1
                       originally logged to history.             HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-ACTION-CODE        Alpha 10                                  HGLM.1  HPOS.1
Element: Action Code   This field contains the personnel         HPQC.1  HPRS.1
                       action code.                              HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-ACTION-NBR         Numeric 4                                 HGLM.1  HPOS.1
Element: Action Number Contains the personnel action number.     HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-FLD-NBR            Numeric 4                                 HGLM.1  HPOS.1
Dictionary Field       Contains the PA dictionary field number.  HPQC.1  HPRS.1
Number                                                           HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-SEQ-NBR            Numeric 4                                 HGLM.1  HPOS.1
Element: Sequence NumbeAn automatically assigned sequence        HPQC.1  HPRS.1
                       number.                                   HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-REASON             Alpha 10 Occurs 2 Times                   HGLM.1  HPOS.1
Element: Reason        Contains the personnel action reason.     HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA340
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA54.1  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 PRSC.1

HER-POS-LEVEL          Numeric 2                                 HGLM.1  HPOS.1
Element: Pos Level     Contains the position level.              HPQC.1  HPRS.1
                       01 = Level 1                              HR11.1  HR11.2
                       02 = Level 2                              HR15.1  HR511
                       03 = Level 3                              HR515   HR54.1
                       04 = Level 4                              HR650   HRS1.1
                       05 = Level 5                              HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-ACT-OBJ-ID         Numeric 12                                HGLM.1  HPOS.1
Object                 If the change was done via a personnel    HPQC.1  HPRS.1
Identification         action, this field contains the record    HR11.1  HR11.2
                       identifier of that action.                HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-A-VALUE            Alpha 30  (Lower Case)                    HGLM.1  HPOS.1
Element: A Value       Contains alpha data items.                HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-N-VALUE            Signed 13.4                               HGLM.1  HPOS.1
Element: N Value       Contains numeric data items.              HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-D-VALUE            Numeric 8  (yyyymmdd)                     HGLM.1  HPOS.1
Element: D Value       Contains date value data items.           HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-NEW-VALUE          Alpha 30                                  HGLM.1  HPOS.1
Field Value After      Contains the field value after the        HPQC.1  HPRS.1
Change                 personnel action change.                  HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-ACTION-TYPE        Alpha 1                                   HGLM.1  HPOS.1
Element: Action Type   This field contains the action type.      HPQC.1  HPRS.1
                       A = Hire an Applicant                     HR11.1  HR11.2
                       E = Individual Employee                   HR15.1  HR511
                       M = Mass Change                           HR515   HR54.1
                       P = Mass Pay Change                       HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-DATA-TYPE          Alpha 1                                   HGLM.1  HPOS.1
Element: Data Type     Determines the type of data being         HPQC.1  HPRS.1
                       entered and how to edit it.  Values are   HR11.1  HR11.2
                       Date, Alpha, or Numeric.                  HR15.1  HR511
                       E = Emp                                   HR515   HR54.1
                       A = App                                   HR650   HRS1.1
                       D = Ded                                   HRSC.1  PA02.1
                       J = Job                                   PA100   PA102
                       P = Pos                                   PA113   PA13.1
                       S = Sup                                   PA13.2  PA502
                       T = Time                                  PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-ANT-END-DATE       Numeric 8  (yyyymmdd)                     HGLM.1  HPOS.1
Anticipated Ending     Contains the personnel action             HPQC.1  HPRS.1
Date                   anticipated end date.                     HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-SALARY-CLASS       Alpha 1                                   HGLM.1  HPOS.1
Element: Salary Class  Contains the salary class.                HPQC.1  HPRS.1
                       H = Hourly                                HR11.1  HR11.2
                       S = Salary                                HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-ANNUAL-SALARY      Signed 13.4                               HGLM.1  HPOS.1
Element: Annual Salary Contains the annual salary.               HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-DATE-STAMP         Numeric 8  (yyyymmdd)                     HGLM.1  HPOS.1
Element: Date Stamp    This field contains the server date       HPQC.1  HPRS.1
                       (month, date, and year) of the last       HR11.1  HR11.2
                       change to this record.                    HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-TIME-STAMP         Numeric 6  (hhmmss)                       HGLM.1  HPOS.1
Element: Time Stamp    Contains the server time (hour, minute,   HPQC.1  HPRS.1
                       and second) when the record was last      HR11.1  HR11.2
                       changed.                                  HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-USER-ID            Alpha 10  (Lower Case)                    HGLM.1  HPOS.1
Element: User                                                    HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-DATE-STAMP2        Numeric 8  (yyyymmdd)                     HGLM.1  HPOS.1
Element: Date Stamp2   Contains the date this record was moved   HPQC.1  HPRS.1
                       to the history error file.                HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-TIME-STAMP2        Numeric 6  (hhmmss)                       HGLM.1  HPOS.1
Element: Time Stamp2   Contains the time this record was moved   HPQC.1  HPRS.1
                       to the history error file.                HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-USER-ID2           Alpha 10  (Lower Case)                    HGLM.1  HPOS.1
Element: User Id2      Contains the User ID of the person who    HPQC.1  HPRS.1
                       moved the record to the history error     HR11.1  HR11.2
                       file.                                     HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-CURRENCY-CODE      Alpha 5                                   HGLM.1  HPOS.1
Element: Currency Code Contains the currency in which the pay    HPQC.1  HPRS.1
                       is recorded.                              HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-CURR-ND            Numeric 1                                 HGLM.1  HPOS.1
Account Currency                                                 HPQC.1  HPRS.1
Code                                                             HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-BASE-CURRENCY      Alpha 5                                   HGLM.1  HPOS.1
To Company Base        Contains the base currency in which the   HPQC.1  HPRS.1
Currency               pay is recorded.                          HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-BASE-ND            Numeric 1                                 HGLM.1  HPOS.1
Account Currency                                                 HPQC.1  HPRS.1
Code                                                             HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-BASE-PAY-RATE      Signed 13.4                               HGLM.1  HPOS.1
Element: Base Pay Rate Contains the pay in the employee's        HPQC.1  HPRS.1
                       base  currency.                           HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-ANNUAL-HOURS       Numeric 4                                 HGLM.1  HPOS.1
Element: Annual Hours  Contains the employee's annual hours at   HPQC.1  HPRS.1
                       the time of this pay rate history         HR11.1  HR11.2
                       record.                                   HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

HER-NBR-FTE            Signed 4.3                                HGLM.1  HPOS.1
Full Time              Contains the employee's FTE at the time   HPQC.1  HPRS.1
Equivalent Number      of this pay rate history.                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1

                         HISTERR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HERSET1   COMPANY                                                HR105   HR11.1
          EMPLOYEE                                               HR125   HR54.1
          OBJ-ID                                                 PA105   PA115
          EFFECT-DATE                                            PA125   PA340
          ACTION-CODE                                            PA54.1
          ACTION-NBR
          FLD-NBR
          SEQ-NBR

HERSET2   COMPANY                                                PA125   PA340
          ACTION-CODE
          EMPLOYEE
          OBJ-ID
          EFFECT-DATE*
          ACTION-NBR*
          FLD-NBR
          SEQ-NBR

HERSET3   COMPANY                                                HGLM.1  HPOS.1
          EMPLOYEE                                               HPQC.1  HPRS.1
          OBJ-ID                                                 HR11.1  HR11.2
          FLD-NBR                                                HR15.1  HR511
          EFFECT-DATE*                                           HR515   HR54.1
          SEQ-NBR*                                               HR650   HRLO.1
          ACTION-CODE                                            HRS1.1  HRSC.1
          ACTION-NBR                                             PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA54.1  PA67.1
                                                                 PR110   PR113
                                                                 ...

HERSET4   COMPANY
          EMPLOYEE
          OBJ-ID
          ACTION-CODE
          EFFECT-DATE*
          ACTION-NBR*
          FLD-NBR
          SEQ-NBR

HERSET5   ACT-OBJ-ID    Subset                                   HGLM.1  HPOS.1
          FLD-NBR       Where (ACT-OBJ-ID != Zeroes )            HPQC.1  HPRS.1
          SEQ-NBR                                                HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HR650   HR701
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA125   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PA66.1  PA66.2
                                                                 ...

                         HISTERR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Action Code    PERSACTYPE   Required
                            When (HER-ACT-OBJ-ID != Zeroes )

                            HER-COMPANY          -> PAT-COMPANY
                            HER-ACTION-CODE      -> PAT-ACTION-CODE

Applicant      APPLICANT    Required
                            When (HER-DATA-TYPE = "A" )

                            HER-COMPANY          -> APL-COMPANY
                            HER-EMPLOYEE         -> APL-APPLICANT

Base Currency  CUCODES      Required
                            When (HER-CURRENCY-CODE != Spaces )

                            HER-BASE-CURRENCY    -> CUC-CURRENCY-CODE

Company        PRSYSTEM     Required

                            HER-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Currency       CUCODES      Required
                            When (HER-CURRENCY-CODE != Spaces )

                            HER-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Deduction      EMDEDMASTR   Required
                            When (HER-DATA-TYPE = "D" )

                            HER-OBJ-ID           -> EDM-OBJ-ID

Employee       EMPLOYEE     Required
                            When (HER-DATA-TYPE = "E" )

                            HER-COMPANY          -> EMP-COMPANY
                            HER-EMPLOYEE         -> EMP-EMPLOYEE

Fld Nbr        PADICT       Required

                            HER-FLD-NBR          -> PAD-FLD-NBR

Job Code       JOBCODE      Required
                            When (HER-DATA-TYPE = "J" )

                            HER-OBJ-ID           -> JBC-OBJ-ID

Paemployee     PAEMPLOYEE   Required
                            When (HER-DATA-TYPE = "E" )

                            HER-COMPANY          -> PEM-COMPANY
                            HER-EMPLOYEE         -> PEM-EMPLOYEE

Pers Act Hst   PERSACTHST   Required
                            When (HER-ACT-OBJ-ID != Zeroes )

                            HER-ACT-OBJ-ID       -> PAH-OBJ-ID

Position       PAPOSITION   Required
                            When (HER-DATA-TYPE = "P" )

                            HER-COMPANY          -> POS-COMPANY
                            HER-OBJ-ID           -> POS-OBJ-ID
                            HER-EFFECT-DATE      -> POS-EFFECT-DATE

Reason         PCODES       Required
                            When (HER-REASON != Spaces )

                            "RA"                 -> PCO-TYPE
                            HER-REASON           -> PCO-CODE

Standard Time  STANDTIME    Required
                            When (HER-DATA-TYPE = "T" )

                            HER-OBJ-ID           -> STM-OBJ-ID

Supervisor     HRSUPER      Required
                            When (HER-DATA-TYPE = "S" )

                            HER-OBJ-ID           -> HSU-OBJ-ID

                         HISTERR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Comments       PACOMMENTS
                            Valid When (HER-ACT-OBJ-ID != Zeroes )

                            HER-COMPANY          -> PAC-COMPANY
                            Zeroes               -> PAC-EMP-APP
                            "PA"                 -> PAC-CMT-TYPE
                            HER-EMPLOYEE         -> PAC-EMPLOYEE
                            Spaces               -> PAC-JOB-CODE
                            HER-ACTION-CODE      -> PAC-ACTION-CODE
                            HER-ACTION-NBR       -> PAC-LN-NBR
                                                    PAC-SEQ-NBR