Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            PRRATEHIST FILE

                         Employee Rate History

Contains pay rate history.  Whenever an employee's pay rate is changed, a
record is created in this file reflecting the new value and the date when it
became effective.  It also includes the actual (system) date and time the
change was made and the id of the user who made the change.

REFERENCED BY

BN100     BN101     BN102     BN103     BN105     BN145
BN245     BN31.1    BN31.2    BN32.1    BN32.2    BN32.3
BN45.1    BN531     BN65.1    BN71.1    BN72.1    BS13.1
BS14.1    BS15.1    BS32.1    HR105     HR170     HR70.1
PA105     PA213     PA311     HRHI.1    PA340     PA360
PA370     PA66.3    PA66.1    PA66.2    PA66.4    PA67.1
PR282     HR521     HR701     PA149     PA341     PA355

UPDATED BY

HR125     HR15.1    HR511     HR515     HR54.1    HR650
HRLO.1    HRS1.1    HRSC.1    PA113     PA125     PA502
PA513     PA54.1    PA55.1    PR13.1    PR13.5    PR13.6
PR13.8

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PRH-COMPANY          Numeric 4                                   HR170   HR54.1
Company              The company number represents an            HR70.1  HRLO.1
                     established company and is entered on       PA54.1
                     all function codes.

PRH-EMPLOYEE         Numeric 9                                   HR170   HR54.1
Employee             Contains the employee number. Each          HR70.1  HRLO.1
                     person employed by the company is           PA54.1
                     assigned a unique number. The system
                     uses the employee number to correlate
                     all of the information related to that
                     person.

PRH-BEG-DATE         Numeric 8  (yyyymmdd)                       HR170   HR54.1
Beginning Date       Contains the date the rate became           HR70.1  HRLO.1
                     effective.                                  PA54.1

PRH-SEQ-NBR          Numeric 4                                   HR15.1  HR170
Sequence Number      If multiple records are created for the     HR511   HR515
                     same effective date (BEG-DATE) this         HR54.1  HR650
                     field will be incremented for each          HR70.1  HRLO.1
                     record for the date.                        HRS1.1  HRSC.1
                                                                 PA113   PA502
                                                                 PA513   PA54.1
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PRH-PAY-RATE         Signed 13.4                                 HR15.1  HR170
Rate of Pay          Contains the employee's new pay rate.       HR511   HR515
                                                                 HR54.1  HR650
                                                                 HR70.1  HRLO.1
                                                                 HRS1.1  HRSC.1
                                                                 PA113   PA502
                                                                 PA513   PA54.1
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PRH-ANNUAL-SALARY    Signed 13.4                                 HR15.1  HR170
Annual Salary        Contains the employee's new annual          HR511   HR515
                     salary.  If the employee's salary class     HR54.1  HR650
                     is "S", this value will match the Pay       HR70.1  HRLO.1
                     Rate.  If the employee's salary class is    HRS1.1  HRSC.1
                     "H", this value is computed as Pay Rate     PA113   PA502
                     X Annual Hours (from the job code           PA513   PA54.1
                     record) X the employee's FTE.               PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PRH-ACT-OBJ-ID       Numeric 12                                  HR170   HR54.1
Subsystem Activity   If the change was done via a personnel      HR70.1  HRLO.1
InterfaceID          action, the record identifier of that       PA113   PA125
                     action (PERSACTHST) is stored here.         PA54.1  PA55.1

PRH-USER-ID          Alpha 10  (Lower Case)                      HR170   HR54.1
User ID Name         Contains the User Id of the individual      HR70.1  HRLO.1
                     making the change.                          PA54.1

PRH-DATE-STAMP       Numeric 8  (yyyymmdd)                       HR170   HR54.1
Date Stamp           Contains the system date when the           HR70.1  HRLO.1
                     change was entered.                         PA54.1

PRH-TIME-STAMP       Numeric 6  (hhmmss)                         HR170   HR54.1
Time Stamp           Contains the system time when the           HR70.1  HRLO.1
                     change was entered.                         PA54.1

PRH-SALARY-CLASS     Alpha 1                                     HR15.1  HR170
Salary Class         Contains the pay rate's salary class.       HR511   HR515
                     H = Hourly                                  HR54.1  HR650
                     S = Salaried                                HR70.1  HRLO.1
                                                                 HRS1.1  HRSC.1
                                                                 PA113   PA502
                                                                 PA513   PA54.1
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PRH-POS-LEVEL        Numeric 2                                   HR170   HR54.1
Pos Level            Contains the position level.                HR70.1  HRLO.1
                                                                 PA54.1

PRH-CURRENCY-CODE    Alpha 5                                     HR54.1  HRLO.1
Currency Code        Contains the currency in which the pay      PA54.1
                     is recorded.

PRH-CURR-ND          Numeric 1                                   HR54.1  HRLO.1
Currency Number of   Represents the number of decimals           PA54.1
Decimals             defined for the currency of the object.

PRH-BASE-CURRENCY    Alpha 5                                     HR54.1  HRLO.1
Base Currency        Contains the company's base currency.       PA54.1

PRH-BASE-ND          Numeric 1                                   HR54.1  HRLO.1
Base Number Of       The number of decimal positions defined     PA54.1
Decimals             for the company base currency.

PRH-BASE-PAY-RATE    Signed 13.4                                 HR15.1  HR511
Base Pay Rate        Contains the pay in the company's base      HR515   HR54.1
                     currency.                                   HR650   HRLO.1
                                                                 HRS1.1  HRSC.1
                                                                 PA113   PA502
                                                                 PA513   PA54.1
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PRH-ANNUAL-HOURS     Numeric 4                                   HR15.1  HR170
Annual Hours         Contains the employee's annual hours at     HR511   HR515
                     the time of this pay rate history           HR54.1  HR650
                     record.                                     HR70.1  HRLO.1
                                                                 HRS1.1  HRSC.1
                                                                 PA113   PA502
                                                                 PA513   PA54.1
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PRH-NBR-FTE          Signed 4.3                                  HR15.1  HR170
Full Time            Contains the employee's FTE at the time     HR511   HR515
Equivalent Number    of this pay rate history record.            HR54.1  HR650
                                                                 HR70.1  HRLO.1
                                                                 HRS1.1  HRSC.1
                                                                 PA113   PA370
                                                                 PA502   PA513
                                                                 PA54.1  PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

                         PRRATEHIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PRHSET1   COMPANY                                                BN100   BN101
          EMPLOYEE                                               BN102   BN103
          BEG-DATE                                               BN105   BN145
          SEQ-NBR                                                BN245   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN45.1  BN531
                                                                 BN65.1  BN71.1
                                                                 BN72.1  BS13.1
                                                                 BS14.1  BS15.1
                                                                 BS32.1  HR105
                                                                 HR125   HR15.1
                                                                 HR170   HR511
                                                                 HR515   HR54.1
                                                                 HR650   HR70.1
                                                                 ...

PRHSET2   COMPANY       KeyChange                                HR105   HR125
          EMPLOYEE                                               HR15.1  HR170
          POS-LEVEL                                              HR511   HR515
          BEG-DATE*                                              HR54.1  HR650
          SEQ-NBR*                                               HR70.1  HRHI.1
                                                                 HRS1.1  HRSC.1
                                                                 PA105   PA113
                                                                 PA125   PA213
                                                                 PA311   PA340
                                                                 PA360   PA370
                                                                 PA502   PA513
                                                                 PA54.1  PA55.1
                                                                 PA66.3  PA67.1
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 ...

PRHSET3   COMPANY       KeyChange
          DATE-STAMP
          EMPLOYEE
          BEG-DATE
          SEQ-NBR

PRHSET4   COMPANY       KeyChange, Subset                        HR15.1  HR511
          ACT-OBJ-ID    Where (ACT-OBJ-ID != Zeroes )            HR515   HR521
          EMPLOYEE                                               HR54.1  HR650
          BEG-DATE                                               HR701   HRS1.1
          SEQ-NBR                                                HRSC.1  PA113
                                                                 PA125   PA149
                                                                 PA213   PA311
                                                                 PA340   PA341
                                                                 PA355   PA370
                                                                 PA502   PA513
                                                                 PA54.1  PA55.1
                                                                 PA66.1  PA66.2
                                                                 PA66.3  PA66.4
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

                         PRRATEHIST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

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

                            PRH-BASE-CURRENCY    -> CUC-CURRENCY-CODE

Company        PRSYSTEM     Required

                            PRH-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

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

                            PRH-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Employee       EMPLOYEE     Required

                            PRH-COMPANY          -> EMP-COMPANY
                            PRH-EMPLOYEE         -> EMP-EMPLOYEE

Persacthst     PERSACTHST   Required
                            When PRH-ACT-OBJ-ID != Zeroes

                            PRH-ACT-OBJ-ID       -> PAH-OBJ-ID