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 PA594
PA66.3 PA66.1 PA66.4 PA66.2 BN100 BN35.1
HR170 HR70.1 PA105 PA223 PA534 PA55.1
PA56.1 PA67.1 PR282 UK110 PA341 PA355
PA149
UPDATED BY
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
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 HR11.2 HR511
Element: Company Hr Identifies the AP company if the HR521 PA02.1
resource type = V. Identifies the HR PA100 PA102
company if the resource type = E. It is PA13.1 PA13.2
blank for type A, P or Q resources. 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: Effective DateContains 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 Number 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
Anticipated Ending Contains the anticipated ending date HR521 PA02.1
Date 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
Object Contains a system-assigned identifier HR521 PA02.1
Identification 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 HAP3.1 HEP4.1
Element: Error Flag Indicates if History Errors exist for HPOS.1 HPQC.1
this Action History record. HPRS.1 HR11.1
0 = No HER records HR11.2 HR15.1
1 = Some HER records HR511 HR515
2 = Only HER records HR54.1 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
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
PA594 PA66.3
PAHSET2 OBJ-ID BN100 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
PA125 PA13.1
PA13.2 PA223
PA370 PA502
PA513 PA52.1
...
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
|