Lawson Insight Technical Documentation |
|
PERSACTHST
PERSACTHST FILE
Personnel Action History
Contains a history log of personnel action changes.
REFERENCED BY
HCHP.1 PA213 PA311 PA340 PA370 PA56.1
PA594 PA66.3 PA66.1 PA66.4 PA66.2 BN100
BN35.1 HR170 HR70.1 PA105 PA223 PA55.1
PA67.1 PR282 UK110 PA341 PA355 PA149
UPDATED BY
BN305 HAP3.1 HEP4.1 HPOS.1 HPQC.1 HPRS.1
HR11.1 HR11.2 HR15.1 HR511 HR515 HR521
HR54.1 HRS1.1 HRSC.1 PA02.1 PA100 PA102
PA113 PA115 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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAH-COMPANY Numeric 4 HR11.2 HR511
Element: Company Hr HR521 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.4
PA52.5 PA54.1
PR110
PAH-ACTION-CODE Alpha 10 HR11.2 HR511
Element: Action Code This field contains the personnel HR521 PA02.1
action code. PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.4
PA52.5 PA54.1
PR110
PAH-EFFECT-DATE Numeric 8 (yyyymmdd) HR11.2 HR511
Element: Effect Date Contains the date the action takes HR521 PA02.1
effect. PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.4
PA52.5 PA54.1
PR110
PAH-ACTION-NBR Numeric 4 HR11.2 HR511
Element: Action Nbr Contains the last action number used HR521 PA02.1
for personnel actions. Taken from the PA100 PA102
Personnel Action Code file. PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.4
PA52.5 PA54.1
PR110
PAH-EMPLOYEE Numeric 9 HR11.2 HR511
Element: Employee Contains the employee number. HR521 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) HR11.2 HR511
Element: Ant End Date Contains the anticipated ending date HR521 PA02.1
for the action. PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.4
PA52.5 PA54.1
PR110
PAH-REASON Alpha 10 Occurs 2 Times HR11.2 HR511
Element: Reason Contains the reason for the action. HR521 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) HR11.2 HR511
Element: User Contains the User Id for the individual HR521 PA02.1
making the change. PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.4
PA52.5 PA54.1
PR110
PAH-DATE-STAMP Numeric 8 (yyyymmdd) HR11.2 HR511
Element: Date Stamp Contains the system date for the action. HR521 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.4
PA52.5 PA54.1
PR110
PAH-ACTION-TYPE Alpha 1 HR11.2 HR511
Element: Action Type This field contains the action type. HR521 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.4
PA52.5 PA54.1
PR110
PAH-OBJ-ID Numeric 12 HR11.2 HR511
Element: Obj Id Contains a system-assigned identifier HR521 PA02.1
that provides access to data in related PA100 PA102
files. PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.4
PA52.5 PA54.1
PR110
PAH-REASON1 Derived
Element: Reason1
PAH-REASON2 Derived
Element: Reason2
PAH-ERROR-FLAG Alpha 1 BN305 HAP3.1
Element: Error Flag Indicates if History Errors exist for HEP4.1 HPOS.1
this Action History record. HPQC.1 HPRS.1
0 = No HER records HR11.1 HR11.2
1 = Some HER records HR15.1 HR511
2 = Only HER records HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 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
PAH-POS-LEVEL Numeric 2 HR11.2 HR511
Element: Pos Level HR521 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.4
PA52.5 PA54.1
PR110
PERSACTHST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAHSET1 COMPANY HCHP.1 HR11.1
EMPLOYEE PA100 PA115
EFFECT-DATE PA125 PA213
ACTION-CODE PA311 PA340
ACTION-NBR PA370 PA52.1
PA52.5 PA54.1
PA56.1 PA594
PA66.3
PAHSET2 OBJ-ID BN100 BN305
BN35.1 HAP3.1
HEP4.1 HPOS.1
HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR170
HR511 HR515
HR54.1 HR70.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA105
PA113 PA115
PA125 PA13.1
PA13.2 PA223
PA370 PA502
...
PAHSET4 COMPANY HR11.2 HR511
EMPLOYEE HR521 PA02.1
ACTION-CODE PA100 PA102
EFFECT-DATE* PA13.1 PA13.2
ACTION-NBR* PA502 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 Required
When PAH-REASON != Spaces
"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
|