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    PA66.3


UPDATED BY

BN305     HAP3.1    HEP4.1    HPOS.1    HPQC.1    HPRS.1
HR11.1    HR11.2    HR125     HR15.1    HR511     HR515
HR54.1    HRS1.1    HRSC.1    PA02.1    PA100     PA102
PA113     PA115     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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

HER-COMPANY            Numeric 4                                 BN305   HAP3.1
Element: Company Hr                                              HEP4.1  HPOS.1
                                                                 HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-EMPLOYEE           Numeric 9                                 BN305   HAP3.1
Element: Employee      Contains the employee number. Each        HEP4.1  HPOS.1
                       person employed by the company is         HPQC.1  HPRS.1
                       assigned a unique number. The system      HR11.1  HR11.2
                       uses the employee number to correlate     HR15.1  HR511
                       all of the information related to that    HR515   HR54.1
                       person.                                   HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-OBJ-ID             Numeric 12                                BN305   HAP3.1
Element: Obj Id        Contains a system-assigned identifier     HEP4.1  HPOS.1
                       that provides access to data in related   HPQC.1  HPRS.1
                       files.                                    HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-EFFECT-DATE        Numeric 8  (yyyymmdd)                     BN305   HAP3.1
Element: Effect Date   Contains the date the item was            HEP4.1  HPOS.1
                       originally logged to history.             HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-ACTION-CODE        Alpha 10                                  BN305   HAP3.1
Element: Action Code   This field contains the personnel         HEP4.1  HPOS.1
                       action code.                              HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-ACTION-NBR         Numeric 4                                 BN305   HAP3.1
Element: Action Nbr    Contains the personnel action number.     HEP4.1  HPOS.1
                                                                 HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-FLD-NBR            Numeric 4                                 BN305   HAP3.1
Element: Fld Nbr       Contains the PA dictionary field number.  HEP4.1  HPOS.1
                                                                 HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-SEQ-NBR            Numeric 4                                 BN305   HAP3.1
Element: Seq Nbr       An automatically assigned sequence        HEP4.1  HPOS.1
                       number.                                   HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-REASON             Alpha 10 Occurs 2 Times                   BN305   HAP3.1
Element: Reason        Contains the personnel action reason.     HEP4.1  HPOS.1
                                                                 HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-POS-LEVEL          Numeric 2                                 BN305   HAP3.1
Element: Pos Level     Contains the position level.              HEP4.1  HPOS.1
                                                                 HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-ACT-OBJ-ID         Numeric 12                                BN305   HAP3.1
Element: Obj Id        If the change was done via a personnel    HEP4.1  HPOS.1
                       action, this field contains the record    HPQC.1  HPRS.1
                       identifier of that action.                HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-A-VALUE            Alpha 30  (Lower Case)                    BN305   HAP3.1
Element: A Value       Contains alpha data items.                HEP4.1  HPOS.1
                                                                 HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-N-VALUE            Signed 15.6                               BN305   HAP3.1
Element: N Value       Contains numeric data items.              HEP4.1  HPOS.1
                                                                 HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-D-VALUE            Numeric 8  (yyyymmdd)                     BN305   HAP3.1
Element: D Value       Contains date value data items.           HEP4.1  HPOS.1
                                                                 HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-NEW-VALUE          Alpha 30                                  BN305   HAP3.1
Element: New Value     Contains the field value after the        HEP4.1  HPOS.1
                       personnel action change.                  HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-ACTION-TYPE        Alpha 1                                   BN305   HAP3.1
Element: Action Type   This field contains the action type.      HEP4.1  HPOS.1
                       A = Hire an Applicant                     HPQC.1  HPRS.1
                       E = Individual Employee                   HR11.1  HR11.2
                       M = Mass Change                           HR15.1  HR511
                       P = Mass Pay Change                       HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-DATA-TYPE          Alpha 1                                   BN305   HAP3.1
Element: Data Type     Determines the type of data being         HEP4.1  HPOS.1
                       entered and how to edit it.  Values are   HPQC.1  HPRS.1
                       Date, Alpha, or Numeric.                  HR11.1  HR11.2
                       E = Emp                                   HR15.1  HR511
                       A = App                                   HR515   HR54.1
                       D = Ded                                   HRS1.1  HRSC.1
                       J = Job                                   PA02.1  PA100
                       P = Pos                                   PA102   PA113
                       S = Sup                                   PA115   PA13.1
                       T = Time                                  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

HER-ANT-END-DATE       Numeric 8  (yyyymmdd)                     BN305   HAP3.1
Element: Ant End Date  Contains the personnel action             HEP4.1  HPOS.1
                       anticipated end date.                     HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-SALARY-CLASS       Alpha 1                                   BN305   HAP3.1
Element: Salary Class  Contains the salary class.                HEP4.1  HPOS.1
                       H = Hourly                                HPQC.1  HPRS.1
                       S = Salary                                HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-ANNUAL-SALARY      Signed 13.4                               BN305   HAP3.1
Element: Pay Rate      Contains the annual salary.               HEP4.1  HPOS.1
                                                                 HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-DATE-STAMP         Numeric 8  (yyyymmdd)                     BN305   HAP3.1
Element: Date Stamp    This field contains the server date       HEP4.1  HPOS.1
                       (month, date, and year) of the last       HPQC.1  HPRS.1
                       change to this record.                    HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-TIME-STAMP         Numeric 6  (hhmmss)                       BN305   HAP3.1
Element: Time Stamp    Contains the server time (hour, minute,   HEP4.1  HPOS.1
                       and second) when the record was last      HPQC.1  HPRS.1
                       changed.                                  HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-USER-ID            Alpha 10  (Lower Case)                    BN305   HAP3.1
Element: User                                                    HEP4.1  HPOS.1
                                                                 HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-DATE-STAMP2        Numeric 8  (yyyymmdd)                     BN305   HAP3.1
Element: Date Stamp2   Contains the date this record was moved   HEP4.1  HPOS.1
                       to the history error file.                HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-TIME-STAMP2        Numeric 6  (hhmmss)                       BN305   HAP3.1
Element: Time Stamp2   Contains the time this record was moved   HEP4.1  HPOS.1
                       to the history error file.                HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-USER-ID2           Alpha 10  (Lower Case)                    BN305   HAP3.1
Element: User Id2      Contains the User ID of the person who    HEP4.1  HPOS.1
                       moved the record to the history error     HPQC.1  HPRS.1
                       file.                                     HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-CURRENCY-CODE      Alpha 5                                   BN305   HAP3.1
Element: Currency Code Contains the currency in which the pay    HEP4.1  HPOS.1
                       is recorded.                              HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-CURR-ND            Numeric 1                                 BN305   HAP3.1
Element: Acct Nd       The number of decimals assigned to a      HEP4.1  HPOS.1
                       particular account as determined by the   HPQC.1  HPRS.1
                       account currency.                         HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-BASE-CURRENCY      Alpha 5                                   BN305   HAP3.1
Element: Base Currency Contains the base currency in which the   HEP4.1  HPOS.1
                       pay is recorded.                          HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-BASE-ND            Numeric 1                                 BN305   HAP3.1
Element: Base Nd       The number of decimal positions defined   HEP4.1  HPOS.1
                       for the company base currency.            HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-BASE-PAY-RATE      Signed 13.4                               BN305   HAP3.1
Element: Pay Rate      Contains the pay in the employee's        HEP4.1  HPOS.1
                       base  currency.                           HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-ANNUAL-HOURS       Numeric 4                                 BN305   HAP3.1
Element: Annual Hours  Contains the employee's annual hours at   HEP4.1  HPOS.1
                       the time of this pay rate history         HPQC.1  HPRS.1
                       record.                                   HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

HER-NBR-FTE            Signed 7.6                                BN305   HAP3.1
Element: Nbr Fte       Contains the employee's FTE at the time   HEP4.1  HPOS.1
                       of this pay rate history.                 HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   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

                         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                                                BN305   HAP3.1
          EMPLOYEE                                               HEP4.1  HPOS.1
          OBJ-ID                                                 HPQC.1  HPRS.1
          FLD-NBR                                                HR11.1  HR11.2
          EFFECT-DATE*                                           HR15.1  HR511
          SEQ-NBR*                                               HR515   HR54.1
          ACTION-CODE                                            HRLO.1  HRS1.1
          ACTION-NBR                                             HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA115
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA54.1  PA67.1
                                                                 ...

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

                         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