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

UPDATED BY

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
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                                 HAP3.1  HEP4.1
Element: Company Hr    Identifies the AP company if the          HPOS.1  HPQC.1
                       resource type = V.  Identifies the HR     HPRS.1  HR11.1
                       company if the resource type = E.  It is  HR11.2  HR15.1
                       blank for type A, P or Q resources.       HR511   HR515
                                                                 HR54.1  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                                 HAP3.1  HEP4.1
Element: Employee      Contains the employee number. Each        HPOS.1  HPQC.1
                       person employed by the company is         HPRS.1  HR11.1
                       assigned a unique number. The system      HR11.2  HR15.1
                       uses the employee number to correlate     HR511   HR515
                       all of the information related to that    HR54.1  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                                HAP3.1  HEP4.1
Object                 Contains a system-assigned identifier     HPOS.1  HPQC.1
Identification         that provides access to data in related   HPRS.1  HR11.1
                       files.                                    HR11.2  HR15.1
                                                                 HR511   HR515
                                                                 HR54.1  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)                     HAP3.1  HEP4.1
Element: Effective DateContains the date the item was            HPOS.1  HPQC.1
                       originally logged to history.             HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR511   HR515
                                                                 HR54.1  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                                  HAP3.1  HEP4.1
Element: Action Code   This field contains the personnel         HPOS.1  HPQC.1
                       action code.                              HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR511   HR515
                                                                 HR54.1  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                                 HAP3.1  HEP4.1
Element: Action Number Contains the personnel action number.     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   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                                 HAP3.1  HEP4.1
Dictionary Field       Contains the PA dictionary field number.  HPOS.1  HPQC.1
Number                                                           HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR511   HR515
                                                                 HR54.1  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                                 HAP3.1  HEP4.1
Element: Sequence NumbeAn automatically assigned sequence        HPOS.1  HPQC.1
                       number.                                   HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR511   HR515
                                                                 HR54.1  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                   HAP3.1  HEP4.1
Element: Reason        Contains the personnel action reason.     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   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                                 HAP3.1  HEP4.1
Element: Pos Level     Contains the position level.              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   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                                HAP3.1  HEP4.1
Object                 If the change was done via a personnel    HPOS.1  HPQC.1
Identification         action, this field contains the record    HPRS.1  HR11.1
                       identifier of that action.                HR11.2  HR15.1
                                                                 HR511   HR515
                                                                 HR54.1  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)                    HAP3.1  HEP4.1
Element: A Value       Contains alpha data items.                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   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 15.6                               HAP3.1  HEP4.1
Element: N Value       Contains numeric data items.              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   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)                     HAP3.1  HEP4.1
Element: D Value       Contains date value data items.           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   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                                  HAP3.1  HEP4.1
Field Value After      Contains the field value after the        HPOS.1  HPQC.1
Change                 personnel action change.                  HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR511   HR515
                                                                 HR54.1  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                                   HAP3.1  HEP4.1
Element: Action Type   This field contains the action type.      HPOS.1  HPQC.1
                       A = Hire an Applicant                     HPRS.1  HR11.1
                       E = Individual Employee                   HR11.2  HR15.1
                       M = Mass Change                           HR511   HR515
                       P = Mass Pay Change                       HR54.1  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                                   HAP3.1  HEP4.1
Element: Data Type     Determines the type of data being         HPOS.1  HPQC.1
                       entered and how to edit it.  Values are   HPRS.1  HR11.1
                       Date, Alpha, or Numeric.                  HR11.2  HR15.1
                       E = Emp                                   HR511   HR515
                       A = App                                   HR54.1  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)                     HAP3.1  HEP4.1
Anticipated Ending     Contains the personnel action             HPOS.1  HPQC.1
Date                   anticipated end date.                     HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR511   HR515
                                                                 HR54.1  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                                   HAP3.1  HEP4.1
Element: Salary Class  Contains the salary class.                HPOS.1  HPQC.1
                       H = Hourly                                HPRS.1  HR11.1
                       S = Salary                                HR11.2  HR15.1
                                                                 HR511   HR515
                                                                 HR54.1  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                               HAP3.1  HEP4.1
Element: Rate of Pay   Contains the annual salary.               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   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)                     HAP3.1  HEP4.1
Element: Date Stamp    This field contains the server date       HPOS.1  HPQC.1
                       (month, date, and year) of the last       HPRS.1  HR11.1
                       change to this record.                    HR11.2  HR15.1
                                                                 HR511   HR515
                                                                 HR54.1  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)                       HAP3.1  HEP4.1
Element: Time Stamp    Contains the server time (hour, minute,   HPOS.1  HPQC.1
                       and second) when the record was last      HPRS.1  HR11.1
                       changed.                                  HR11.2  HR15.1
                                                                 HR511   HR515
                                                                 HR54.1  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)                    HAP3.1  HEP4.1
Element: User          Contains the user ID of the person who    HPOS.1  HPQC.1
                       last changed this record.                 HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR511   HR515
                                                                 HR54.1  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)                     HAP3.1  HEP4.1
Element: Date Stamp2   Contains the date this record was moved   HPOS.1  HPQC.1
                       to the history error file.                HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR511   HR515
                                                                 HR54.1  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)                       HAP3.1  HEP4.1
Element: Time Stamp2   Contains the time this record was moved   HPOS.1  HPQC.1
                       to the history error file.                HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR511   HR515
                                                                 HR54.1  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)                    HAP3.1  HEP4.1
Element: User Id2      Contains the User ID of the person who    HPOS.1  HPQC.1
                       moved the record to the history error     HPRS.1  HR11.1
                       file.                                     HR11.2  HR15.1
                                                                 HR511   HR515
                                                                 HR54.1  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                                   HAP3.1  HEP4.1
Element: Currency Code Contains the currency in which the pay    HPOS.1  HPQC.1
                       is recorded.                              HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR511   HR515
                                                                 HR54.1  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                                 HAP3.1  HEP4.1
Account Currency       Represents the number of decimals         HPOS.1  HPQC.1
Code                   defined for the currency of the object.   HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR511   HR515
                                                                 HR54.1  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                                   HAP3.1  HEP4.1
Element: Base Currency Contains the base currency in which the   HPOS.1  HPQC.1
                       pay is recorded.                          HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR511   HR515
                                                                 HR54.1  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                                 HAP3.1  HEP4.1
Base Number Of         The number of decimal positions defined   HPOS.1  HPQC.1
Decimals               for the company base currency.            HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR511   HR515
                                                                 HR54.1  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                               HAP3.1  HEP4.1
Element: Rate of Pay   Contains the pay in the employee's        HPOS.1  HPQC.1
                       base  currency.                           HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR511   HR515
                                                                 HR54.1  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                                 HAP3.1  HEP4.1
Element: Annual Hours  Contains the employee's annual hours at   HPOS.1  HPQC.1
                       the time of this pay rate history         HPRS.1  HR11.1
                       record.                                   HR11.2  HR15.1
                                                                 HR511   HR515
                                                                 HR54.1  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 7.6                                HAP3.1  HEP4.1
Full Time              Contains the employee's FTE at the time   HPOS.1  HPQC.1
Equivalent Number      of this pay rate history.                 HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR511   HR515
                                                                 HR54.1  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                                                HAP3.1  HEP4.1
          EMPLOYEE                                               HPOS.1  HPQC.1
          OBJ-ID                                                 HPRS.1  HR11.1
          FLD-NBR                                                HR11.2  HR15.1
          EFFECT-DATE*                                           HR511   HR515
          SEQ-NBR*                                               HR54.1  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
                                                                 ...

HERSET5   ACT-OBJ-ID    Subset                                   HAP3.1  HEP4.1
          FLD-NBR       Where (ACT-OBJ-ID != Zeroes )            HPOS.1  HPQC.1
          SEQ-NBR                                                HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR511   HR515
                                                                 HR54.1  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  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