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.

Field / column	Type	Description & values	Updated 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 9	Contains 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 12	If 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 4	Dictionary 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 4	If 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.6	If 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` ACT_OBJ_ID	Numeric 12	If 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` 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 1	Indicator 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` 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 5	This 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 1	The 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`HRHSET1`	`COMPANY`, `EMPLOYEE`, `OBJ-ID`, `FLD-NBR`, `BEG-DATE`, `SEQ-NBR`	Primary		BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +22 more (list truncated in source)
`HRHSET2`	`COMPANY`, `EMPLOYEE`, `OBJ-ID`, `FLD-NBR`, `POS-LEVEL`, `BEG-DATE`, `SEQ-NBR`	KeyChange		BN150, BN230, BN305, BN320, BN48.1, BN70.1, HCEM.1, HCHP.1 +22 more (list truncated in source)
`HRHSET3`	`COMPANY`, `EMPLOYEE`, `OBJ-ID`, `POS-LEVEL`, `BEG-DATE`, `FLD-NBR`, `SEQ-NBR`	KeyChange		BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)
`HRHSET4`	`COMPANY`, `ACT-OBJ-ID`, `FLD-NBR`, `EMPLOYEE`, `OBJ-ID`, `BEG-DATE`, `SEQ-NBR`	KeyChange, Subset	Where (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`	`COMPANY`, `FLD-NBR`, `DATE-STAMP`, `EMPLOYEE`, `OBJ-ID`, `BEG-DATE`, `SEQ-NBR`	KeyChange		HR04.4, HR04.5, HR04.6, PA223, PR280

Relations

One to one (12) — lookups and parents

Relation	Table	Rules	Condition	Field map
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`
Emachdepst	EMACHDEPST	Required	When (HRH-DATA-TYPE = "R")	`HRH-OBJ-ID` → `EAD-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`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
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`

Programs

Updated by (174)

BN100 Employee Change Benefit Update
BN101 Mass Benefit Add
BN102 Plan Employee Update
BN103 Mass Benefit Termination
BN104 Frequency Table Update
BN105 Plan Update
BN145 Flex Dollars Calculation
BN150 Life Insurance Reportable Income
BN245 Benefit Election Form
BN305 Highly Compensated Employees
BN31.1 Speed Benefit Entry
BN31.2 Employee Benefit Entry
BN32.1 Employee Benefit Changes
BN32.2 Employee Benefit Detail Changes
BN32.3 Benefit Add
BN430 Benefit Purge
BN45.1 Employee Flex Credits
BN531 Batch Benefit Enrollment
BN65.1 Election Simulation
BN66.1 Estimated Pay Calculation
BN71.1 COBRA Benefit Entry
BN72.1 Retiree Benefit Entry
BS10.1 Web Enrollment Current Benefit Inquiry
BS12.1 Web Enrollment Eligible New Plans
BS13.1 Web Enrollment Coverage Options
BS14.1 Web Enrollment Coverage Amounts
BS15.1 Web Enrollment Contribution Limits
BS32.1 Web Enrollment Stop Benefits Update
EXI2.1 Invoke for PRTRDPD
EXI4.1 Invoke for PRPRBPD
HAP3.1 Applicant Option 4 Selection Invoke
HCRE.1 Action Reason Code Selects
HEP4.1 Employee Option 4 Selection Invoke
HPOS.1 Position Selection Invoke
HPQC.1 Prqcentgrp Select Invoke
HPRS.1 Process Level Select Invoke
HR00.1 Company
HR01.1 Process Level
HR06.1 Job Code
HR07.1 Supervisor
HR11.1 Employee
HR11.2 Compensation Analysis
HR11.4 Employee Assignment Inquiry
HR125 Employee Audit Purge
HR13.1 Dependent
HR15.1 User Fields
HR213 Dependent Listing
HR28.1 Employee Ethnicity
HR506 Job Code Conversion
HR507 Supervisor Conversion
HR511 Employee Conversion
HR513 Dependent Conversion
HR515 User Field Conversion
HR54.1 Employee History Correction
HRLO.1 History Logging Routine
HRS1.1 Select Control
HRSC.1 Select Control
LP100 Employee Absence Plan Update
LP101 Mass Absence Plan Add
LP102 Employee Master Update
LP103 Mass Absence Plan Termination
LP130 Absence Plan Payout
LP131 Zero Balance Update
LP140 Employee Absence Plan Calculation
LP145 Allotment Adjustment Calculation
LP151 FMLA Rolling 12 Month Update
LP180 Mass Absence Plan Transfer
LP197 Absence Plan Close
LP198 General Ledger Liability Update
LP220 Employee Absence Plan or Leave History Report
LP31.1 Employee Absence Plan Master
LP331 Employee Absence Plan Purge
LP51.1 Employee Leave of Absence
LP80.1 Employee Absence Plan Transfer
LT101 HRM Receiver Update
LT11.5 HRM User Field Interface
LT111 HRM Receiver Update
LT13.5 HRM User Field Interface History
PA02.1 Position
PA100 Action Update
PA102 Position Update
PA113 Retroactive History Update
PA115 Employee Purge
PA120 Applicant Purge
PA125 Employee History Purge
PA13.1 Multiple Positions and Jobs
PA13.2 Multiple Position and Job History
PA213 Position and Job Listing
PA218 Travel Listing
PA302 Position Purge
PA502 Position Conversion
PA513 Position and Job Conversion
PA52.1 Individual Action
PA52.3 Mass Action
PA52.4 Hire an Applicant
PA52.5 Position and Job Action
PA54.1 Personnel Action History Correction
PA55.1 Retroactive History Audit
PR110 Step And Grade Audit
PR113 United States Tax Deduction Update
PR12.1 Direct Deposit Distribution
PR12.3 Automatic Deposit Maintenance
PR12.6 Employee Automatic Deposit
PR120 Mass Pay Update
PR128 Offset Time Record Creation
PR13.1 Employee United States Taxes
PR13.2 Employee United States Taxes
PR13.5 Employee Canada Taxes
PR13.6 Employee Canada Taxes
PR13.8 U.S. Tax Deduction Errors
PR13.9 Employee Additional Tax Details
PR131 Retroactive Pay Calculation
PR132 FLSA Overtime Calculation
PR134 Automatic Time Records
PR135 Time Record Edit
PR136 Missing Time Records
PR137 Batch Time Record Update
PR14.1 Employee Deduction
PR14.2 Tax Withholding Lock-In
PR140 Earnings and Deductions Calculation
PR15.1 Deduction Speed Entry
PR15.2 Employee Deduction Speed Entry
PR160 Payment Print
PR189 Gross Up Calculation
PR195 Accrual Program
PR205 Deduction Listing
PR26.1 United States Employee Garnishment
PR280 Deduction Audit Report
PR29.1 Pension Payment Maintenance
PR30.1 Standard Time Record
PR30.2 Employee Automatic Time Record
PR32.1 Employee Daily Time Entry
PR32.2 Employee Daily Time Entry
PR33.1 Speed Entry Setup
PR33.2 Speed Entry by Number
PR33.3 Speed Entry by Name
PR35.1 Time Entry
PR35.2 Detail Time Entry
PR35.3 Speed Time Entry
PR35.4 Step and Grade, Grade Range Time Entry
PR35.5 Attendance Time Entry
PR35.6 Activity Time Entry
PR35.8 Position Time Entry
PR35.9 Reason Code Time Entry
PR36.1 Time Record Entry
PR36.4 Manual Time Record Maintenance
PR37.1 Batch Time Control
PR39.1 One Time Deduction
PR39.2 One Time Deduction Speed
PR45.1 Error Processing
PR47.1 Canada Employee Garnishment
PR512 Employee ACH Distribution Interface
PR514 Employee Deduction Master Load
PR521 Nonstandard Pay and Work Period CSV Load
PR529 Pension Payroll Conversion
PR530 Time Record Interface CSV
PR539 One Time Deduction Load
PR560 Payroll History Load CSV
PR582 Mass Adjustment Load
PR80.1 Manual Check
PR80.3 Manual Payment One Time Deduction
PR80.4 Manual Payment
PR82.1 Adjustment
PR89.1 Payment Modeling
PRAT.1 Alltax connection test
TA147 Canada Vacation Audit
UK102 Bonus Pay Update
ZB10.1 Coverage Options Calculator
ZB31.1 Speed Benefit Entry
ZB31.2 Employee Benefit Entry
ZB32.1 Employee Benefit Changes
ZB32.2 Employee Benefit Detail Changes
ZB32.3 Benefit Add
ZH510 Update PCP from ZPENDPCP

Referenced by (85)

BN230 Plan Participant Report
BN232 Benefits Statement
BN320 Premium Report
BN48.1 Savings Bond Beneficiaries
BN70.1 COBRA Participant
HCEM.1 Olap Dimension Retrieval Format
HCHP.1 Olap Data Load
HR04.4 Alphanumeric User Fields
HR04.5 Numeric User Fields
HR04.6 Date User Fields
HR105 Employee Audit Report
HR170 Human Resource Writer Report Request
HR206 Job Code Listing
HR207 Supervisor Listing
HR521 Employee History Conversion
HR70.1 Human Resource Writer Inquiry
HR93.1 Employee Audit Inquiry
HR93.3 Applicant Audit Inquiry
HR93.4 Supervisor Audit Inquiry
HR93.5 Employee Deduction Audit Inquiry
HR93.6 Job Code Audit Inquiry
HR93.7 Position Audit Inquiry
HR93.8 Employee Leave Plan Audit Inquiry
HR93.9 Employee Leave of Absence Audit Inquiry
HR94.1 Employee Direct Deposit Audit Inquiry
HRHI.1 History Retrieval Routine
HS11.1 Web Competency Profile
HS11.2 Web Competency Profile
PA105 Employee Audit Report
PA149 Update Scheduled Tests
PA223 Starters and Leavers Report
PA231 Applicant Profile
PA28.1 Applicant Ethnicity
PA31.1 Applicant
PA311 Employee Profile
PA340 Action History Listing
PA341 Hire and Term Listing
PA355 Active Actions Report
PA370 Employee Review Document
PA390 EEO-1 Report
PA391 EEO-4 Report
PA392 EEO-5 Report
PA393 Veterans Employment Report
PA490 OSHA Log, Summary Report
PA495 IPEDS Report
PA496 Official Languages Report
PA531 Applicant Conversion
PA594 EECRS CSV Interface
PA66.3 Employee Action Detail
PR11.1 Employee Year-End Parameters
PR11.2 USERRA Year-End Parameters
PR11.3 Employee HIRE Act Tax Reporting Info
PR11.4 Canadian Employee Year-End Parameters
PR11.5 Employee Year-End PA TCD Override
PR127 Year-End Parameters Copy/Delete
PR129 Roth Plan Start Dates
PR212 Direct Deposit Account Listing
PR227 Year-End Parameter Report
PR240 T4-T4A Slips
PR241 T4-T4A XML
PR242 T4-T4A Reports
PR243 Releve Slips
PR244 Releve Magnetic Media
PR245 Releve Reports
PR248 Canada Annual Reports
PR249 PIER Audit Report
PR250 1099-R Form Reporting
PR251 1099-R File Creation
PR252 United States Territory W-2 Form Printing
PR253 1099-R Reporting
PR27.1 Year-End Parameters
PR27.2 Tax Authority Year-End Parameters
PR282 Canada Record of Employment
PR286 Report on Hirings
PR287 Quarterly Federal Tax Return
PR290 Quarterly Report
PR291 Unemployment Continuation Form
PR292 Quarterly Unemployment Ins
PR293 Enumeration Verification
PR297 W-2 Forms
PR298 W2c EFW2c
PR299 EFW2 File Creation
PRSC.1 Select Control
ZP551 Triad FSA Export Interface
ZP560 PPH Medical-Dental Interfaces