Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             HRHISTORY FILE

                               HR History

Contains records consisting of the new value and a date stamp for each field
in  the Employee, Personnel Employee, Employee Deduction, Standard Time
Record, Applicant, Job Code, and Supervisor files that are designated to be
logged in HR10.1 (Data Item Attributes). The system logs any field changed by
a personnel action regardless of the flags in HR10.1 (Data  Item Attributes).

Does not contain pay rate or salary changes, which are located in Employee
Rate History file.

REFERENCED BY

BN400     HR105     HR170     HR70.1    PA105     PA213
PA391     HCOP.1    HCOP.2    HR206     HR207     HRHI.1
HS11.1    PA231     PA311     PA340     PA390     PA393
PA66.3    PA66.1    PA66.2    PA66.4    PR282     PR290
PR291     PR292     PR297     PR298     HR521     PA149
PA341     PA355     PA370     HR04.4    HR04.5    HR04.6

UPDATED BY

HR07.1    HR125     HR15.1    HR15.2    HR511     HR515
HR54.1    HR650     HR701     HRLO.1    HRS1.1    HRSC.1
PA113     PA120     PA125     PA302     PA502     PA513
PA54.1    PA55.1    PR13.1    PR13.5    PR13.6    PR13.8
PR13.2    PR280     AC541     AC542     BN100     BN101
BN102     BN103     BN104     BN105     BN145     BN150
BN245     BN31.1    BN31.2    BN32.1    BN32.2    BN32.3
BN430     BN45.1    BN531     BN65.1    BN71.1    BN72.1
BS13.1    BS14.1    BS15.1    BS32.1    HR00.1    HR01.1
PR128     PR131     PR132     PR134     PR136     PR14.1
PR15.1    PR15.2    PR197     PR205     PR26.1    PR30.1
PR32.2    PR33.2    PR33.3    PR35.1    PR35.2    PR35.3
PR35.4    PR35.5    PR35.6    PR35.8    PR36.1    PR39.1
PR39.2    PR47.1    PR514     PR530     PR82.1    UK102
UK120

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

HRH-COMPANY          Numeric 4                                   HR15.1  HR170
Company              The company number represents an            HR511   HR515
                     established company and is entered on       HR54.1  HR650
                     all function codes.                         HR70.1  HRLO.1
                                                                 HRS1.1  HRSC.1
                                                                 PA113   PA502
                                                                 PA513   PA54.1
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

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

HRH-OBJ-ID           Numeric 12                                  HR170   HR54.1
Object               If the item being logged is from an         HR70.1  HRLO.1
Identification       employee deduction, standard time           PA502   PA54.1
                     record, job code, or supervisor this
                     field will contain the object ID of that
                     record.

HRH-FLD-NBR          Numeric 4                                   HR170   HR54.1
Dictionary Field     Dictionary number of the data item          HR70.1  HRLO.1
Number               being logged.                               PA502   PA54.1

HRH-BEG-DATE         Numeric 8  (yyyymmdd)                       HR170   HR54.1
Beginning Date       Date for which the recorded data item       HR70.1  HRLO.1
                     value became effective.                     PA502   PA54.1

HRH-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

HRH-N-VALUE          Signed 13.4                                 HR15.1  HR170
N Value              If the data item is a numeric field,        HR511   HR515
                     the value is stored in this field.          HR54.1  HR650
                                                                 HR70.1  HR701
                                                                 HRLO.1  HRS1.1
                                                                 HRSC.1  PA113
                                                                 PA502   PA513
                                                                 PA54.1  PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

HRH-A-VALUE          Alpha 30  (Lower Case)                      HR170   HR54.1
A Value              If the data item is alpha-numeric, the      HR70.1  HR701
                     value is stored in this field.              HRLO.1  PA502
                                                                 PA54.1

HRH-D-VALUE          Numeric 8  (yyyymmdd)                       HR170   HR54.1
D Value              If the data item is a date, the value       HR70.1  HRLO.1
                     is stored in this field.                    PA502   PA54.1

HRH-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.         PA502   PA54.1
                                                                 PA55.1

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

HRH-DATE-STAMP       Numeric 8  (yyyymmdd)                       HR170   HR54.1
Date Stamp           Contains the system date on which the       HR70.1  HRLO.1
                     history update is made.                     PA502   PA54.1

HRH-TIME-STAMP       Numeric 6  (hhmmss)                         HR170   HR54.1
Time Stamp           Contains the system time for which the      HR70.1  HRLO.1
                     history update is made.                     PA502   PA54.1

HRH-DATA-TYPE        Alpha 1                                     HR170   HR54.1
Data Type            Indicator of the type of data record        HR70.1  HRLO.1
                     for which changes are logged.               PA502   PA54.1
                     E = Employee
                     A = Applicant
                     D = Deduction
                     J = Job Code
                     P = Position
                     S = Supervisor
                     T = Standard Time Record

HRH-POS-LEVEL        Numeric 2                                   HR170   HR54.1
Pos Level                                                        HR70.1  HRLO.1
                                                                 PA54.1

HRH-N-VALUE-0        Derived
N Value 0

HRH-N-VALUE-1        Derived
N Value 1

HRH-N-VALUE-2        Derived
N Value 2

HRH-N-VALUE-3        Derived
N Value 3

HRH-CURRENCY-CODE    Alpha 5                                     HR54.1  HRLO.1
Currency Code        This field contains the company base        PA502   PA54.1
                     currency code established in Company
                     (GL10.1 ).

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

                         HRHISTORY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HRHSET1   COMPANY                                                AC541   AC542
          EMPLOYEE                                               BN100   BN101
          OBJ-ID                                                 BN102   BN103
          FLD-NBR                                                BN104   BN105
          BEG-DATE                                               BN145   BN150
          SEQ-NBR                                                BN245   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN400   BN430
                                                                 BN45.1  BN531
                                                                 BN65.1  BN71.1
                                                                 BN72.1  BS13.1
                                                                 BS14.1  BS15.1
                                                                 BS32.1  HR00.1
                                                                 HR01.1  HR07.1
                                                                 ...

HRHSET2   COMPANY       KeyChange                                AC541   AC542
          EMPLOYEE                                               BN150   HCOP.1
          OBJ-ID                                                 HCOP.2  HR105
          FLD-NBR                                                HR125   HR15.1
          POS-LEVEL                                              HR170   HR206
          BEG-DATE*                                              HR207   HR511
          SEQ-NBR*                                               HR515   HR54.1
                                                                 HR650   HR70.1
                                                                 HRHI.1  HRS1.1
                                                                 HRSC.1  HS11.1
                                                                 PA105   PA113
                                                                 PA125   PA213
                                                                 PA231   PA311
                                                                 PA340   PA390
                                                                 PA391   PA393
                                                                 ...

HRHSET3   COMPANY       KeyChange                                HR125   HR15.1
          EMPLOYEE                                               HR15.2  HR511
          OBJ-ID                                                 HR515   HR54.1
          POS-LEVEL                                              HR650   HRS1.1
          BEG-DATE                                               HRSC.1  PA113
          FLD-NBR                                                PA302   PA311
          SEQ-NBR                                                PA502   PA513
                                                                 PA54.1  PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PR280

HRHSET4   COMPANY       KeyChange, Subset                        HCOP.2  HR15.1
          ACT-OBJ-ID    Where (ACT-OBJ-ID != Zeroes )            HR511   HR515
          FLD-NBR                                                HR521   HR54.1
          EMPLOYEE                                               HR650   HR701
          OBJ-ID                                                 HRS1.1  HRSC.1
          BEG-DATE                                               PA113   PA125
          SEQ-NBR                                                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
                                                                 ...

HRHSET5   COMPANY       KeyChange                                HR04.4  HR04.5
          FLD-NBR                                                HR04.6  HR701
          DATE-STAMP
          EMPLOYEE
          OBJ-ID
          BEG-DATE
          SEQ-NBR

HRHSET6   COMPANY                                                HR650
          EMPLOYEE
          FLD-NBR
          BEG-DATE*
          OBJ-ID
          SEQ-NBR

                         HRHISTORY FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Applicant      APPLICANT    Required
                            When HRH-DATA-TYPE = "A"

                            HRH-COMPANY          -> APL-COMPANY
                            HRH-EMPLOYEE         -> APL-APPLICANT

Company        PRSYSTEM     Required

                            HRH-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

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

                            HRH-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Deduction      EMDEDMASTR   Required
                            When HRH-DATA-TYPE = "D"

                            HRH-OBJ-ID           -> EDM-OBJ-ID

Employee       EMPLOYEE     Required
                            When HRH-DATA-TYPE = "E"

                            HRH-COMPANY          -> EMP-COMPANY
                            HRH-EMPLOYEE         -> EMP-EMPLOYEE

Fld Nbr        PADICT       Required

                            HRH-FLD-NBR          -> PAD-FLD-NBR

Job Code       JOBCODE      Required
                            When HRH-DATA-TYPE = "J"

                            HRH-OBJ-ID           -> JBC-OBJ-ID

Paemployee     PAEMPLOYEE   Required
                            When HRH-DATA-TYPE = "E"

                            HRH-COMPANY          -> PEM-COMPANY
                            HRH-EMPLOYEE         -> PEM-EMPLOYEE

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

                            HRH-ACT-OBJ-ID       -> PAH-OBJ-ID

Standtime      STANDTIME    Required
                            When HRH-DATA-TYPE = "T"

                            HRH-OBJ-ID           -> STM-OBJ-ID

Sup Employee   EMPLOYEE     Required
                            When HRH-FLD-NBR = 721

                            HRH-COMPANY          -> EMP-COMPANY
                            HRH-N-VALUE          -> EMP-EMPLOYEE

                         HRHISTORY FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Pep Audit      PAPEPAUDIT   Delete Cascades
                            Valid When HRH-DATA-TYPE = "E"

                            HRH-COMPANY          -> PEA-COMPANY
                            HRH-EMPLOYEE         -> PEA-EMPLOYEE
                            HRH-POS-LEVEL        -> PEA-POS-LEVEL
                            HRH-BEG-DATE         -> PEA-EFFECT-DATE
                                                    PEA-UPDATE-DATE
                                                    PEA-FLD-NBR
                                                    PEA-ACT-OBJ-ID