HRHISTORY – HR History

System
Human Resources (HR)
Prefix
HRH
Primary key
COMPANY, EMPLOYEE, OBJ-ID, FLD-NBR, BEG-DATE, SEQ-NBR
Fields
22
Updated by
174 programs
Referenced by
85 programs

HRHISTORY is the HR History table in Lawson Human Resources (prefix HRH). It is indexed by COMPANY, EMPLOYEE, OBJ-ID, FLD-NBR, BEG-DATE, SEQ-NBR (HRHSET1); alternate indexes: HRHSET2, HRHSET3, HRHSET4 and HRHSET5. It is related 1:1 to APPLICANT, PRSYSTEM, CUCODES, EMDEDMASTR, EMACHDEPST, EMPLOYEE, PADICT, JOBCODE and 3 more and 1:M to PAPEPAUDIT. It is updated by BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 and 166 more and referenced by BN230, BN232, BN320, BN48.1, BN70.1, HCEM.1, HCHP.1, HR04.4 and 77 more. The table has 22 fields, 5 indexes and 13 documented relations.

About HRHISTORY

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.

Fields (22)

Column = COBOL field name without the HRH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#HRH-COMPANY PK
COMPANY		Numeric 4—BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +42 more
#HRH-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +42 more
#HRH-OBJ-ID PK
OBJ_ID		Numeric 12If the item being logged is from an employee deduction, standard time record, job code, or supervisor this field will contain the object ID of that record.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +42 more
#HRH-FLD-NBR PK
FLD_NBR		Numeric 4Dictionary number of the data item being logged.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +42 more
#HRH-BEG-DATE PK
BEG_DATE		Numeric 8 (yyyymmdd)Date for which the recorded data item value became effective.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +42 more
#HRH-SEQ-NBR PK
SEQ_NBR		Numeric 4If multiple records are created for the same effective date (BEG-DATE) this field will be incremented for each record for the date.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +42 more
#HRH-N-VALUE
N_VALUE		Signed 15.6If the data item is a numeric field, the value is stored in this field.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +42 more
#HRH-A-VALUE
A_VALUE		Alpha 60 (Lower Case)If the data item is alpha-numeric, the value is stored in this field.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +42 more
#HRH-D-VALUE
D_VALUE		Numeric 8 (yyyymmdd)If the data item is a date, the value is stored in this field.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +42 more
#HRH-ACT-OBJ-ID SET4
ACT_OBJ_ID		Numeric 12If the change was done via a personnel action, the record identifier of that action (PERSACTHST) is stored here.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +43 more
#HRH-USER-ID
USER_ID		Alpha 10 (Lower Case)Contains the User Id of the person making the change.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +42 more
#HRH-DATE-STAMP SET5
DATE_STAMP		Numeric 8 (yyyymmdd)Contains the system date on which the history update is made.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +42 more
#HRH-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the system time for which the history update is made.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +42 more
#HRH-DATA-TYPE
DATA_TYPE		Alpha 1Indicator of the type of data record for which changes are logged.
  • E Employee
  • A Applicant
  • D Deduction
  • J Job Code
  • P Position
  • R Direct Deposit
  • S Supervisor
  • T Standard Time Record
  • L Leave Plan Master
  • V Leave of Absence
  • F Dependent
BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +42 more
#HRH-POS-LEVEL SET2 SET3
POS_LEVEL		Numeric 2—BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +42 more
#HRH-N-VALUE-0
N_VALUE_0		Derived——
#HRH-N-VALUE-1
N_VALUE_1		Derived——
#HRH-N-VALUE-2
N_VALUE_2		Derived——
#HRH-N-VALUE-3
N_VALUE_3		Derived——
#HRH-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +40 more
#HRH-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +40 more
#HRH-UPDATED-BY-LTM
UPDATED_BY_LTM		Alpha 1—
  • Y Yes
  • N No
—

Indexes (5)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
HRHSET1
  1. COMPANY
  2. EMPLOYEE
  3. OBJ-ID
  4. FLD-NBR
  5. BEG-DATE
  6. SEQ-NBR
PrimaryBN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +22 more (list truncated in source)
HRHSET2
  1. COMPANY
  2. EMPLOYEE
  3. OBJ-ID
  4. FLD-NBR
  5. POS-LEVEL
  6. BEG-DATE ↓
  7. SEQ-NBR ↓
KeyChangeBN150, BN230, BN305, BN320, BN48.1, BN70.1, HCEM.1, HCHP.1 +22 more (list truncated in source)
HRHSET3
  1. COMPANY
  2. EMPLOYEE
  3. OBJ-ID
  4. POS-LEVEL
  5. BEG-DATE
  6. FLD-NBR
  7. SEQ-NBR
KeyChangeBN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)
HRHSET4
  1. COMPANY
  2. ACT-OBJ-ID
  3. FLD-NBR
  4. EMPLOYEE
  5. OBJ-ID
  6. BEG-DATE
  7. SEQ-NBR
KeyChange, SubsetWhere (ACT-OBJ-ID != Zeroes)BN305, HCHP.1, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1 +22 more (list truncated in source)
HRHSET5
  1. COMPANY
  2. FLD-NBR
  3. DATE-STAMP
  4. EMPLOYEE
  5. OBJ-ID
  6. BEG-DATE
  7. SEQ-NBR
KeyChangeHR04.4, HR04.5, HR04.6, PA223, PR280

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
APPLICANTPRSYSTEMCUCODESEMDEDMASTREMACHDEPSTEMPLOYEEPADICTJOBCODEPAEMPLOYEEPERSACTHSTSTANDTIMEPAPEPAUDITHRHISTORY

One to one (12) — lookups and parents

RelationTableRulesConditionField map
ApplicantAPPLICANTRequiredWhen HRH-DATA-TYPE = "A"
HRH-COMPANY→APL-COMPANY
HRH-EMPLOYEE→APL-APPLICANT
CompanyPRSYSTEMRequired
HRH-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
CurrencyCUCODESRequiredWhen (HRH-CURRENCY-CODE != Spaces)
HRH-CURRENCY-CODE→CUC-CURRENCY-CODE
DeductionEMDEDMASTRRequiredWhen HRH-DATA-TYPE = "D"
HRH-OBJ-ID→EDM-OBJ-ID
EmachdepstEMACHDEPSTRequiredWhen (HRH-DATA-TYPE = "R")
HRH-OBJ-ID→EAD-OBJ-ID
EmployeeEMPLOYEERequiredWhen HRH-DATA-TYPE = "E"
HRH-COMPANY→EMP-COMPANY
HRH-EMPLOYEE→EMP-EMPLOYEE
Fld NbrPADICTRequired
HRH-FLD-NBR→PAD-FLD-NBR
Job CodeJOBCODERequiredWhen HRH-DATA-TYPE = "J"
HRH-OBJ-ID→JBC-OBJ-ID
PaemployeePAEMPLOYEERequiredWhen HRH-DATA-TYPE = "E"
HRH-COMPANY→PEM-COMPANY
HRH-EMPLOYEE→PEM-EMPLOYEE
PersacthstPERSACTHSTRequiredWhen HRH-ACT-OBJ-ID != Zeroes
HRH-ACT-OBJ-ID→PAH-OBJ-ID
StandtimeSTANDTIMERequiredWhen HRH-DATA-TYPE = "T"
HRH-OBJ-ID→STM-OBJ-ID
Sup EmployeeEMPLOYEERequiredWhen HRH-FLD-NBR = 721
HRH-COMPANY→EMP-COMPANY
HRH-N-VALUE→EMP-EMPLOYEE

One to many (1) — child tables

RelationTableRulesConditionField map
Pep AuditPAPEPAUDITDelete CascadesValid 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

Programs

Updated by (174)

Referenced by (85)