 |
Lawson Insight Technical Documentation |
|
PERSACTHST FILE
Personnel Action History
Contains a history log of personnel action changes.
REFERENCED BY
HCOP.2 PA213 PA311 PA340 PA370 PA66.3
PA66.1 PA66.4 PA66.2 BN100 BN35.1 HR170
HR70.1 PA105 PA55.1 PA56.1 PA67.1 PR282
UK110 PA341 PA355 PA149
UPDATED BY
HR15.1 HR511 HR515 HR521 HR54.1 HR650
HR701 HRS1.1 HRSC.1 PA113 PA125 PA502
PA513 PA54.1 PR13.1 PR13.5 PR13.6 PR13.8
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAH-COMPANY Numeric 4 HR511 HR521
Company The company number represents an PA502 PA513
established company and is entered on PA54.1
all function codes.
PAH-ACTION-CODE Alpha 10 HR511 HR521
Action Code This field contains the personnel PA502 PA513
action code. PA54.1
PAH-EFFECT-DATE Numeric 8 (yyyymmdd) HR511 HR521
Effective Date Contains the date the action takes PA502 PA513
effect. PA54.1
PAH-ACTION-NBR Numeric 4 HR511 HR521
Action Number Contains the last action number used PA502 PA513
for personnel actions. Taken from the PA54.1
Personnel Action Code file.
PAH-EMPLOYEE Numeric 9 HR511 HR521
Employee Contains the employee number. PA502 PA513
PA54.1
PAH-ANT-END-DATE Numeric 8 (yyyymmdd) HR511 HR521
Anticipated Ending Contains the anticipated ending date PA502 PA513
Date for the action. PA54.1
PAH-REASON Alpha 10 Occurs 2 Times HR511 HR521
Reason Contains the reason for the action. PA340 PA502
PA513 PA54.1
PAH-USER-ID Alpha 10 (Lower Case) HR511 HR521
User ID Name Contains the User Id for the individual PA502 PA513
making the change. PA54.1
PAH-DATE-STAMP Numeric 8 (yyyymmdd) HR511 HR521
Date Stamp Contains the system date for the action. PA502 PA513
PA54.1
PAH-ACTION-TYPE Alpha 1 HR511 HR521
Action Type This field contains the action type. PA502 PA513
PA54.1
PAH-OBJ-ID Numeric 12 HR511 HR521
Object Contains a system-assigned identifier PA502 PA513
Identification that provides access to data in related PA54.1
files.
PAH-REASON1 Derived
Reason1
PAH-REASON2 Derived
Reason2
PAH-ERROR-FLAG Alpha 1 HR15.1 HR511
Error Flag Indicates if History Errors exist for HR515 HR54.1
this Action History record. HR650 HR701
0 = No HER records HRS1.1 HRSC.1
1 = Some HER records PA113 PA125
2 = Only HER records PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
PERSACTHST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAHSET1 COMPANY HCOP.2 PA125
EMPLOYEE PA213 PA311
EFFECT-DATE PA340 PA370
ACTION-CODE PA54.1 PA66.3
ACTION-NBR
PAHSET2 OBJ-ID BN100 BN35.1
HR15.1 HR170
HR511 HR515
HR54.1 HR650
HR70.1 HR701
HRS1.1 HRSC.1
PA105 PA113
PA125 PA370
PA502 PA513
PA54.1 PA55.1
PA56.1 PA67.1
PR13.1 PR13.5
PR13.6 PR13.8
PAHSET4 COMPANY HR511 HR521
EMPLOYEE PA502 PA513
ACTION-CODE PA54.1 PA66.1
EFFECT-DATE* PA66.4 PR282
ACTION-NBR* UK110
PAHSET5 COMPANY PA125 PA340
ACTION-CODE PA341 PA355
EMPLOYEE PA66.2
EFFECT-DATE*
ACTION-NBR*
PAHSET6 COMPANY KeyChange PA149
DATE-STAMP
OBJ-ID
PERSACTHST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Action Code PERSACTYPE Required
PAH-COMPANY -> PAT-COMPANY
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
Reason PCODES Not Required
"RA" -> PCO-TYPE
PAH-REASON -> PCO-CODE
PERSACTHST FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
|