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 PA56.1 PA67.1 UK110 PA341
PA355 PA149
UPDATED BY
HR11.1 HR511 HR521 PA02.1 PA100 PA102
PA115 PA125 PA13.1 PA13.2 PA502 PA513
PA52.1 PA52.4 PA52.5 PA54.1
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
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
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
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
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
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
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
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
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
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
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
PAH-REASON1 Derived
Reason1
PAH-REASON2 Derived
Reason2
PERSACTHST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAHSET1 COMPANY HCOP.2 HR11.1
EMPLOYEE PA115 PA125
EFFECT-DATE PA213 PA311
ACTION-CODE PA340 PA370
ACTION-NBR PA54.1 PA66.3
PAHSET2 OBJ-ID BN100 BN35.1
HR170 HR70.1
PA105 PA370
PA56.1 PA67.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
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-EMPLOYEE -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
PAH-ACTION-CODE -> PAC-ACTION-CODE
PAC-LN-NBR
PAC-SEQ-NBR
Hist Err HISTERR Delete Cascades
PAH-COMPANY -> HER-COMPANY
PAH-EMPLOYEE -> HER-EMPLOYEE
PAH-OBJ-ID -> HER-OBJ-ID
PAH-EFFECT-DATE -> HER-EFFECT-DATE
PAH-ACTION-CODE -> HER-ACTION-CODE
PAH-ACTION-NBR -> HER-ACTION-NBR
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
Persactdtl PERSACTDTL Delete Cascades
PAH-OBJ-ID -> PDA-OBJ-ID
PDA-FLD-NBR
|