PERSACTHST – Personnel Action History

System: Personnel (PA)
Prefix: PAH
Primary key: COMPANY, EMPLOYEE, EFFECT-DATE, ACTION-CODE, ACTION-NBR
Fields: 26
Updated by: 50 programs
Referenced by: 26 programs

PERSACTHST is the Personnel Action History table in Lawson Personnel (prefix PAH). It is indexed by COMPANY, EMPLOYEE, EFFECT-DATE, ACTION-CODE, ACTION-NBR (PAHSET1); alternate indexes: PAHSET2, PAHSET4, PAHSET5, PAHSET6 and PAHSET7. It is related 1:1 to PERSACTYPE, PRSYSTEM, EMPLOYEE and PAEMPLOYEE and 1:M to PACOMMENTS, HISTERR, HRHISTORY, PRRATEHIST and PAACTREAS. It is updated by BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 and 42 more and referenced by BN100, BN35.1, HCHP.1, HR170, HR70.1, PA105, PA149, PA213 and 18 more. The table has 26 fields, 6 indexes and 9 documented relations.

About PERSACTHST

Contains a history log of personnel action changes.

Fields (26)

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

Field / column	Type	Description & values	Updated by
`PAH-COMPANY` PK COMPANY	Numeric 4	—	HR11.2, HR511, HR521, LT101, LT111, PA02.1, PA100, PA102 +9 more
`PAH-ACTION-CODE` PK ACTION_CODE	Alpha 10	This field contains the personnel action code.	HR11.2, HR511, HR521, LT101, LT111, PA02.1, PA100, PA102 +9 more
`PAH-EFFECT-DATE` PK EFFECT_DATE	Numeric 8 (yyyymmdd)	Contains the date the action takes effect.	HR11.2, HR511, HR521, LT101, LT111, PA02.1, PA100, PA102 +9 more
`PAH-ACTION-NBR` PK ACTION_NBR	Numeric 4	Contains the last action number used for personnel actions. Taken from the Personnel Action Code file.	HR11.2, HR511, HR521, LT101, LT111, PA02.1, PA100, PA102 +9 more
`PAH-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains the employee number.	HR11.2, HR511, HR521, LT101, LT111, PA02.1, PA100, PA102 +9 more
`PAH-ANT-END-DATE` ANT_END_DATE	Numeric 8 (yyyymmdd)	Contains the anticipated ending date for the action.	HR11.2, HR511, HR521, LT101, LT111, PA02.1, PA100, PA102 +9 more
`PAH-REASON` REASON	Alpha 10 Occurs 2 Times ×2	Contains the reason for the action.	HR11.2, HR511, HR521, LT101, LT111, PA02.1, PA100, PA102 +10 more
`PAH-USER-ID` USER_ID	Alpha 10 (Lower Case)	Contains the User Id for the individual making the change.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +41 more
`PAH-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	Contains the system date for the action.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +41 more
`PAH-ACTION-TYPE` ACTION_TYPE	Alpha 1	This field contains the action type.	HR11.2, HR511, HR521, LT101, LT111, PA02.1, PA100, PA102 +9 more
`PAH-OBJ-ID` OBJ_ID	Numeric 12	Contains a system-assigned identifier that provides access to data in related files.	HR11.2, HR511, HR521, LT101, LT111, PA02.1, PA100, PA102 +9 more
`PAH-REASON1` REASON1	Derived	—	—
`PAH-REASON2` REASON2	Derived	—	—
`PAH-ERROR-FLAG` ERROR_FLAG	Alpha 1	Indicates if History Errors exist for this Action History record. `0` No HER records `1` Some HER records `2` Only HER records	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +40 more
`PAH-POS-LEVEL` POS_LEVEL	Numeric 2	—	HR11.2, HR511, HR521, LT101, LT111, PA02.1, PA100, PA102 +9 more
`PAH-UPDATE-BENEFIT` UPDATE_BENEFIT	Alpha 1	This contains the update benefit flag that was on the action when it was processed. `N` No `Y` Yes	HR11.2, HR511, LT101, LT111, PA02.1, PA100, PA102, PA13.1 +8 more
`PAH-UPDATE-REQ-DED` UPDATE_REQ_DED	Alpha 1	This field is the update required deduction flag that was on the action when it was processed. `N` No `Y` Yes	HR11.2, HR511, LT101, LT111, PA02.1, PA100, PA102, PA13.1 +8 more
`PAH-EDM-EFFECT-DT` EDM_EFFECT_DT	Numeric 8 (yyyymmdd)	This field contains the EDM effect date that was used when the action was processed.	HR11.2, HR511, LT101, LT111, PA02.1, PA100, PA102, PA13.1 +8 more
`PAH-EDM-END-DATE` EDM_END_DATE	Numeric 8 (yyyymmdd)	This date indicates the EDM end date that was used when the action was processed.	HR11.2, HR511, LT101, LT111, PA02.1, PA100, PA102, PA13.1 +8 more
`PAH-UPD-ABS-MGMT` UPD_ABS_MGMT	Alpha 1	This field indicates the absense managment flag that was used with the action was processed. `N` No `Y` Yes	HR11.2, HR511, LT101, LT111, PA02.1, PA100, PA102, PA13.1 +8 more
`PAH-HIST-CORR-FLAG` HIST_CORR_FLAG	Alpha 2	This field indicates the history correction flag that was used when the action was processed. `1` Create Pending Update `2` Delete `3` Move to Hist Error	HR11.2, HR511, LT101, LT111, PA02.1, PA100, PA102, PA13.1 +7 more
`PAH-ACTION-UPD` ACTION_UPD	Alpha 1	This field indicates the method by which the action was updated. PA52.1, PA52.4, and PA52.5 immediate would have a value of 1. PA100 would have a value of 2. PA52.2 and PA52.3 (mass actions) would have a value of 3. Actions from PA02 and PA102 would have a value of 4. PA54 actions would have a value of 5. PA13 actions would have a value of 6. `1` Immediate `2` Pending `3` Mass `4` Position `5` Manual `6` Emp Pos	HR11.2, HR511, LT101, LT111, PA02.1, PA100, PA102, PA13.1 +8 more
`PAH-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	—	HR11.2, HR511, HR521, LT101, LT111, PA02.1, PA100, PA102 +9 more
`PAH-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	—	HR11.2, HR511, HR521, LT101, LT111, PA02.1, PA100, PA102 +9 more
`PAH-CREATE-USER` CREATE_USER	Alpha 10 (Lower Case)	—	HR11.2, HR511, HR521, LT101, LT111, PA02.1, PA100, PA102 +9 more
`PAH-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	—	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +41 more

Indexes (6)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Used in
`PAHSET1`	`COMPANY`, `EMPLOYEE`, `EFFECT-DATE`, `ACTION-CODE`, `ACTION-NBR`	Primary	HCHP.1, HR11.1, PA100, PA115, PA125, PA213, PA311, PA340 +8 more
`PAHSET2`	`OBJ-ID`		BN100, BN305, BN35.1, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1 +22 more (list truncated in source)
`PAHSET4`	`COMPANY`, `EMPLOYEE`, `ACTION-CODE`, `EFFECT-DATE`, `ACTION-NBR`		HR11.2, HR511, HR521, LT101, LT111, ZH230, ZH500, PA02.1 +16 more
`PAHSET5`	`COMPANY`, `ACTION-CODE`, `EMPLOYEE`, `EFFECT-DATE`, `ACTION-NBR`		PA125, PA340, PA341, PA355, PA66.2
`PAHSET6`	`COMPANY`, `DATE-STAMP`, `OBJ-ID`	KeyChange	PA149
`PAHSET7`	`COMPANY`, `EMPLOYEE`, `EFFECT-DATE*`, `ACTION-CODE`, `ACTION-NBR`		—

Relations

One to one (4) — lookups and parents

Relation	Table	Rules	Field map
Action Code	PERSACTYPE	Required	`PAH-COMPANY` → `PAT-COMPANY (PATSET1)`, `PAH-ACTION-CODE` → `PAT-ACTION-CODE`
Company	PRSYSTEM	Required	`PAH-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Employee	EMPLOYEE	Required	`PAH-COMPANY` → `EMP-COMPANY`, `PAH-EMPLOYEE` → `EMP-EMPLOYEE`
Paemployee	PAEMPLOYEE	Required	`PAH-COMPANY` → `PEM-COMPANY`, `PAH-EMPLOYEE` → `PEM-EMPLOYEE`

One to many (5) — child tables

Relation	Table	Rules	Condition	Field map
Comments	PACOMMENTS			`PAH-COMPANY` → `PAC-COMPANY`, `Zeroes` → `PAC-EMP-APP`, `"PA"` → `PAC-CMT-TYPE`, `PAH-ACTION-CODE` → `PAC-ACTION-CODE`, `PAH-EFFECT-DATE` → `PAC-DATE`, `PAH-EMPLOYEE` → `PAC-EMPLOYEE`, `Spaces` → `PAC-JOB-CODE`, `PAH-ACTION-NBR` → `PAC-LN-NBR`, → `PAC-SEQ-NBR`
Hist Err	HISTERR	Delete Cascades		`PAH-OBJ-ID` → `HER-ACT-OBJ-ID`, → `HER-FLD-NBR`, → `HER-SEQ-NBR`
Hr History	HRHISTORY			`PAH-COMPANY` → `HRH-COMPANY`, `PAH-OBJ-ID` → `HRH-ACT-OBJ-ID`, → `HRH-FLD-NBR`, → `HRH-EMPLOYEE`, → `HRH-OBJ-ID`, → `HRH-BEG-DATE`, → `HRH-SEQ-NBR`
Pay Rate Hist	PRRATEHIST			`PAH-COMPANY` → `PRH-COMPANY`, `PAH-OBJ-ID` → `PRH-ACT-OBJ-ID`, → `PRH-EMPLOYEE`, → `PRH-BEG-DATE`, → `PRH-SEQ-NBR`
Reason	PAACTREAS	Required	When PAH-REASON != Spaces	`PAH-COMPANY` → `CRE-COMPANY`, `PAH-REASON` → `CRE-ACT-REASON-CD`, → `CRE-ACTION-CODE`

Programs

Updated by (50)

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
HR15.1 User Fields
HR28.1 Employee Ethnicity
HR511 Employee Conversion
HR515 User Field Conversion
HR521 Employee History 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
PA57.1 Personnel Action Reason Codes
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 (26)

BN100 Employee Change Benefit Update
BN35.1 Benefit Change Audit
HCHP.1 Olap Data Load
HR170 Human Resource Writer Report Request
HR70.1 Human Resource Writer Inquiry
PA105 Employee Audit Report
PA149 Update Scheduled Tests
PA213 Position and Job Listing
PA223 Starters and Leavers Report
PA311 Employee Profile
PA340 Action History Listing
PA341 Hire and Term Listing
PA355 Active Actions Report
PA370 Employee Review Document
PA55.1 Retroactive History Audit
PA56.1 Personnel Action Comments
PA594 EECRS CSV Interface
PA66.1 Employee Action Summary
PA66.2 Action Inquiry
PA66.3 Employee Action Detail
PA66.4 Employee Action Comments
PA67.1 Pay Rate History
PR282 Canada Record of Employment
UK110 Pay Rate Table Update
ZH230 PPH Big Bad Edit
ZH500 Employee Data Extract