 |
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 PA594
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
HR11.1 HR11.2 HR15.1 HR511 HR515 HR521
HR54.1 HR650 HR701 HRS1.1 HRSC.1 PA02.1
PA100 PA102 PA113 PA125 PA13.1 PA13.2
PA502 PA513 PA52.1 PA52.3 PA52.4 PA52.5
PA54.1 PR110 PR113 PR120 PR13.1 PR13.5
PR13.6 PR13.8 PRSC.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAH-COMPANY Numeric 4 HR511 HR521
Company The company number represents an PA02.1 PA100
established company and is entered on PA102 PA13.1
all function codes. PA13.2 PA502
PA513 PA52.1
PA52.4 PA52.5
PA54.1 PR110
PAH-ACTION-CODE Alpha 10 HR511 HR521
Action Code This field contains the personnel PA02.1 PA100
action code. PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.4 PA52.5
PA54.1 PR110
PAH-EFFECT-DATE Numeric 8 (yyyymmdd) HR511 HR521
Effective Date Contains the date the action takes PA02.1 PA100
effect. PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.4 PA52.5
PA54.1 PR110
PAH-ACTION-NBR Numeric 4 HR511 HR521
Action Number Contains the last action number used PA02.1 PA100
for personnel actions. Taken from the PA102 PA13.1
Personnel Action Code file. PA13.2 PA502
PA513 PA52.1
PA52.4 PA52.5
PA54.1 PR110
PAH-EMPLOYEE Numeric 9 HR511 HR521
Employee Contains the employee number. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.4 PA52.5
PA54.1 PR110
PAH-ANT-END-DATE Numeric 8 (yyyymmdd) HR511 HR521
Anticipated Ending Contains the anticipated ending date PA02.1 PA100
Date for the action. PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.4 PA52.5
PA54.1 PR110
PAH-REASON Alpha 10 Occurs 2 Times HR511 HR521
Reason Contains the reason for the action. PA02.1 PA100
PA102 PA13.1
PA13.2 PA340
PA502 PA513
PA52.1 PA52.4
PA52.5 PA54.1
PR110
PAH-USER-ID Alpha 10 (Lower Case) HR511 HR521
User ID Name Contains the User Id for the individual PA02.1 PA100
making the change. PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.4 PA52.5
PA54.1 PR110
PAH-DATE-STAMP Numeric 8 (yyyymmdd) HR511 HR521
Date Stamp Contains the system date for the action. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.4 PA52.5
PA54.1 PR110
PAH-ACTION-TYPE Alpha 1 HR511 HR521
Action Type This field contains the action type. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.4 PA52.5
PA54.1 PR110
PAH-OBJ-ID Numeric 12 HR511 HR521
Object Contains a system-assigned identifier PA02.1 PA100
Identification that provides access to data in related PA102 PA13.1
files. PA13.2 PA502
PA513 PA52.1
PA52.4 PA52.5
PA54.1 PR110
PAH-REASON1 Derived
Reason1
PAH-REASON2 Derived
Reason2
PAH-ERROR-FLAG Alpha 1 HR11.1 HR11.2
Error Flag Indicates if History Errors exist for HR15.1 HR511
this Action History record. HR515 HR54.1
0 = No HER records HR650 HR701
1 = Some HER records HRS1.1 HRSC.1
2 = Only HER records PA02.1 PA100
PA102 PA113
PA125 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
PERSACTHST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAHSET1 COMPANY HCOP.2 HR11.1
EMPLOYEE PA100 PA115
EFFECT-DATE PA125 PA213
ACTION-CODE PA311 PA340
ACTION-NBR PA370 PA52.1
PA52.5 PA54.1
PA594 PA66.3
PAHSET2 OBJ-ID BN100 BN35.1
HR11.1 HR11.2
HR15.1 HR170
HR511 HR515
HR54.1 HR650
HR70.1 HR701
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA105
PA113 PA125
PA13.1 PA13.2
PA370 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
...
PAHSET4 COMPANY HR511 HR521
EMPLOYEE PA02.1 PA100
ACTION-CODE PA102 PA13.1
EFFECT-DATE* PA13.2 PA502
ACTION-NBR* PA513 PA52.1
PA52.2 PA52.3
PA52.5 PA54.1
PA66.1 PA66.4
PR110 PR282
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
|