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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated 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 10This 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 4Contains 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 9Contains 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 ×2Contains 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 SET6
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 1This field contains the action type.HR11.2, HR511, HR521, LT101, LT111, PA02.1, PA100, PA102 +9 more
#PAH-OBJ-ID SET2 SET6
OBJ_ID		Numeric 12Contains 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 1Indicates 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 1This 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 1This 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 1This 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 2This 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 1This 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 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
PAHSET1
  1. COMPANY
  2. EMPLOYEE
  3. EFFECT-DATE
  4. ACTION-CODE
  5. ACTION-NBR
PrimaryHCHP.1, HR11.1, PA100, PA115, PA125, PA213, PA311, PA340 +8 more
PAHSET2
  1. OBJ-ID
BN100, BN305, BN35.1, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1 +22 more (list truncated in source)
PAHSET4
  1. COMPANY
  2. EMPLOYEE
  3. ACTION-CODE
  4. EFFECT-DATE ↓
  5. ACTION-NBR ↓
HR11.2, HR511, HR521, LT101, LT111, ZH230, ZH500, PA02.1 +16 more
PAHSET5
  1. COMPANY
  2. ACTION-CODE
  3. EMPLOYEE
  4. EFFECT-DATE ↓
  5. ACTION-NBR ↓
PA125, PA340, PA341, PA355, PA66.2
PAHSET6
  1. COMPANY
  2. DATE-STAMP
  3. OBJ-ID
KeyChangePA149
PAHSET7
  1. COMPANY
  2. EMPLOYEE
  3. EFFECT-DATE ↓
  4. ACTION-CODE
  5. ACTION-NBR
—

Relations

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

One to one (4) — lookups and parents

RelationTableRulesConditionField map
Action CodePERSACTYPERequired
PAH-COMPANY→PAT-COMPANY (PATSET1)
PAH-ACTION-CODE→PAT-ACTION-CODE
CompanyPRSYSTEMRequired
PAH-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequired
PAH-COMPANY→EMP-COMPANY
PAH-EMPLOYEE→EMP-EMPLOYEE
PaemployeePAEMPLOYEERequired
PAH-COMPANY→PEM-COMPANY
PAH-EMPLOYEE→PEM-EMPLOYEE

One to many (5) — child tables

RelationTableRulesConditionField map
CommentsPACOMMENTS
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 ErrHISTERRDelete Cascades
PAH-OBJ-ID→HER-ACT-OBJ-ID
—→HER-FLD-NBR
—→HER-SEQ-NBR
Hr HistoryHRHISTORY
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 HistPRRATEHIST
PAH-COMPANY→PRH-COMPANY
PAH-OBJ-ID→PRH-ACT-OBJ-ID
—→PRH-EMPLOYEE
—→PRH-BEG-DATE
—→PRH-SEQ-NBR
ReasonPAACTREASRequiredWhen PAH-REASON != Spaces
PAH-COMPANY→CRE-COMPANY
PAH-REASON→CRE-ACT-REASON-CD
—→CRE-ACTION-CODE

Programs

Updated by (50)

Referenced by (26)