HISTERR – Contains history errors moved using HR54.1 (Employee History Correction) and PA54.1 (Personnel Action History…

System: Human Resources (HR)
Prefix: HER
Primary key: COMPANY, EMPLOYEE, OBJ-ID, EFFECT-DATE, ACTION-CODE, ACTION-NBR, FLD-NBR, SEQ-NBR
Fields: 33
Updated by: 49 programs
Referenced by: 6 programs

HISTERR is the Contains history errors moved using HR54.1 (Employee History Correction) and PA54.1 (Personnel Action History… table in Lawson Human Resources (prefix HER). It is indexed by COMPANY, EMPLOYEE, OBJ-ID, EFFECT-DATE, ACTION-CODE, ACTION-NBR, FLD-NBR, SEQ-NBR (HERSET1); alternate indexes: HERSET2, HERSET3 and HERSET5. It is related 1:1 to PERSACTYPE, APPLICANT, CUCODES, PRSYSTEM, EMDEDMASTR, EMPLOYEE, PADICT, JOBCODE and 5 more and 1:M to PACOMMENTS and PAACTREAS. It is updated by BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 and 41 more and referenced by HR105, HRLO.1, PA105, PA340, PA66.3 and PA67.1. The table has 33 fields, 4 indexes and 16 documented relations.

About HISTERR

Contains history errors moved using HR54.1 (Employee History Correction) and PA54.1 (Personnel Action History Correction).

Fields (33)

Column = COBOL field name without the HER- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`HER-COMPANY` PK COMPANY	Numeric 4	—	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
`HER-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 +39 more
`HER-OBJ-ID` PK OBJ_ID	Numeric 12	Contains a system-assigned identifier that provides access to data in related files.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
`HER-EFFECT-DATE` PK EFFECT_DATE	Numeric 8 (yyyymmdd)	Contains the date the item was originally logged to history.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
`HER-ACTION-CODE` PK ACTION_CODE	Alpha 10	This field contains the personnel action code.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
`HER-ACTION-NBR` PK ACTION_NBR	Numeric 4	Contains the personnel action number.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
`HER-FLD-NBR` PK FLD_NBR	Numeric 4	Contains the PA dictionary field number.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
`HER-SEQ-NBR` PK SEQ_NBR	Numeric 4	An automatically assigned sequence number.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
`HER-REASON` REASON	Alpha 10 Occurs 2 Times ×2	Contains the personnel action reason.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +40 more
`HER-POS-LEVEL` POS_LEVEL	Numeric 2	Contains the position level.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
`HER-ACT-OBJ-ID` ACT_OBJ_ID	Numeric 12	If the change was done via a personnel action, this field contains the record identifier of that action.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
`HER-A-VALUE` A_VALUE	Alpha 60 (Lower Case)	Contains alpha data items.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
`HER-N-VALUE` N_VALUE	Signed 15.6	Contains numeric data items.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
`HER-D-VALUE` D_VALUE	Numeric 8 (yyyymmdd)	Contains date value data items.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
`HER-NEW-VALUE` NEW_VALUE	Alpha 60 (Lower Case)	Contains the field value after the personnel action change.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
`HER-ACTION-TYPE` ACTION_TYPE	Alpha 1	This field contains the action type. `A` Hire an Applicant `E` Individual Employee `M` Mass Change `P` Mass Pay Change	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
`HER-DATA-TYPE` DATA_TYPE	Alpha 1	Determines the type of data being entered and how to edit it. Values are Date, Alpha, or Numeric. `E` Emp `A` App `D` Ded `J` Job `P` Pos `S` Sup `T` Time	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
`HER-ANT-END-DATE` ANT_END_DATE	Numeric 8 (yyyymmdd)	Contains the personnel action anticipated end date.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
`HER-SALARY-CLASS` SALARY_CLASS	Alpha 1	Contains the salary class. `H` Hourly `S` Salary	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
`HER-ANNUAL-SALARY` ANNUAL_SALARY	Signed 13.4	Contains the annual salary.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
`HER-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
`HER-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
`HER-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
`HER-DATE-STAMP2` DATE_STAMP2	Numeric 8 (yyyymmdd)	Contains the date this record was moved to the history error file.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
`HER-TIME-STAMP2` TIME_STAMP2	Numeric 6 (hhmmss)	Contains the time this record was moved to the history error file.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
`HER-USER-ID2` USER_ID2	Alpha 10 (Lower Case)	Contains the User ID of the person who moved the record to the history error file.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
`HER-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	Contains the currency in which the pay is recorded.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
`HER-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 +39 more
`HER-BASE-CURRENCY` BASE_CURRENCY	Alpha 5	Contains the base currency in which the pay is recorded.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
`HER-BASE-ND` BASE_ND	Numeric 1	The number of decimal positions defined for the company base currency.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
`HER-BASE-PAY-RATE` BASE_PAY_RATE	Signed 13.4	Contains the pay in the employee's base currency.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
`HER-ANNUAL-HOURS` ANNUAL_HOURS	Signed 8.4	Contains the employee's annual hours at the time of this pay rate history record.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more
`HER-NBR-FTE` NBR_FTE	Signed 7.6	Contains the employee's FTE at the time of this pay rate history.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +39 more

Indexes (4)

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
`HERSET1`	`COMPANY`, `EMPLOYEE`, `OBJ-ID`, `EFFECT-DATE`, `ACTION-CODE`, `ACTION-NBR`, `FLD-NBR`, `SEQ-NBR`	Primary		HR105, HR11.1, HR125, HR54.1, PA105, PA115, PA125, PA340 +1 more
`HERSET2`	`COMPANY`, `ACTION-CODE`, `EMPLOYEE`, `OBJ-ID`, `EFFECT-DATE`, `ACTION-NBR`, `FLD-NBR`, `SEQ-NBR`			PA125, PA340
`HERSET3`	`COMPANY`, `EMPLOYEE`, `OBJ-ID`, `FLD-NBR`, `EFFECT-DATE`, `SEQ-NBR`, `ACTION-CODE`, `ACTION-NBR`			BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)
`HERSET5`	`ACT-OBJ-ID`, `FLD-NBR`, `SEQ-NBR`	Subset	Where (ACT-OBJ-ID != Zeroes)	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)

Relations

One to one (14) — lookups and parents

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

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
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`, → `PAC-DATE`
Reason	PAACTREAS	Required	When (HER-REASON != Spaces)	`HER-COMPANY` → `CRE-COMPANY`, `HER-REASON` → `CRE-ACT-REASON-CD`, → `CRE-ACTION-CODE`

Programs

Updated by (49)

BN305 Highly Compensated Employees
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
HR11.1 Employee
HR11.2 Compensation Analysis
HR11.4 Employee Assignment Inquiry
HR125 Employee Audit Purge
HR15.1 User Fields
HR28.1 Employee Ethnicity
HR511 Employee Conversion
HR515 User Field Conversion
HR54.1 Employee History Correction
HRS1.1 Select Control
HRSC.1 Select Control
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
PA125 Employee History Purge
PA13.1 Multiple Positions and Jobs
PA13.2 Multiple Position and Job History
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
PR110 Step And Grade Audit
PR113 United States Tax Deduction Update
PR12.6 Employee Automatic Deposit
PR120 Mass Pay Update
PR13.1 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
PR30.2 Employee Automatic Time Record
PR512 Employee ACH Distribution Interface
ZH510 Update PCP from ZPENDPCP

Referenced by (6)

HR105 Employee Audit Report
HRLO.1 History Logging Routine
PA105 Employee Audit Report
PA340 Action History Listing
PA66.3 Employee Action Detail
PA67.1 Pay Rate History