PERSACTHST

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 ZH230 ZH500 PR282 UK110 PA341
PA355 PA149


UPDATED BY
BN305 HAP3.1 HCRE.1 HEP4.1 HPOS.1 HPQC.1
HPRS.1 HR11.1 HR11.2 HR11.4 HR15.1 HR28.1
HR511 HR515 HR521 HR54.1 HRS1.1 HRSC.1
LT101 LT11.5 LT111 LT13.5 ZH510 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 PR12.6 PR120
PR13.1 PR13.5 PR13.6 PR13.8 PR13.9 PR30.2
PR512 PA57.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAH-COMPANY
Element: Company Hr
Numeric 4
HR11.2 HR511
HR521 LT101
LT111 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.4
PA52.5 PA54.1
PR110
PAH-ACTION-CODE
Element: Action Code
Alpha 10
This field contains the personnel action code.
HR11.2 HR511
HR521 LT101
LT111 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.4
PA52.5 PA54.1
PR110
PAH-EFFECT-DATE
Element: Effect Date
Numeric 8 (yyyymmdd)
Contains the date the action takes effect.
HR11.2 HR511
HR521 LT101
LT111 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.4
PA52.5 PA54.1
PR110
PAH-ACTION-NBR
Element: Action Nbr
Numeric 4
Contains the last action number used for personnel actions. Taken from the Personnel Action Code file.
HR11.2 HR511
HR521 LT101
LT111 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.4
PA52.5 PA54.1
PR110
PAH-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee number.
HR11.2 HR511
HR521 LT101
LT111 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.4
PA52.5 PA54.1
PR110
PAH-ANT-END-DATE
Element: Ant End Date
Numeric 8 (yyyymmdd)
Contains the anticipated ending date for the action.
HR11.2 HR511
HR521 LT101
LT111 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.4
PA52.5 PA54.1
PR110
PAH-REASON
Element: Reason
Alpha 10 Occurs 2 Times
Contains the reason for the action.
HR11.2 HR511
HR521 LT101
LT111 PA02.1
PA100 PA102
PA13.1 PA13.2
PA340 PA502
PA513 PA52.1
PA52.4 PA52.5
PA54.1 PR110
PAH-USER-ID
Element: User
Alpha 10 (Lower Case)
Contains the User Id for the individual making the change.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR521 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
LT111 LT13.5
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 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
PAH-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
Contains the system date for the action.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR521 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
LT111 LT13.5
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 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
PAH-ACTION-TYPE
Element: Action Type
Alpha 1
This field contains the action type.
HR11.2 HR511
HR521 LT101
LT111 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.4
PA52.5 PA54.1
PR110
PAH-OBJ-ID
Element: Obj Id
Numeric 12
Contains a system-assigned identifier that provides access to data in related files.
HR11.2 HR511
HR521 LT101
LT111 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.4
PA52.5 PA54.1
PR110
PAH-REASON1
Element: Reason1
Derived
PAH-REASON2
Element: Reason2
Derived
PAH-ERROR-FLAG
Element: Error Flag
Alpha 1
Indicates if History Errors exist for this Action History record.
0 = No HER records
1 = Some HER records
2 = Only HER records
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT11.5 LT111
LT13.5 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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
PAH-POS-LEVEL
Element: Pos Level
Numeric 2
HR11.2 HR511
HR521 LT101
LT111 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.4
PA52.5 PA54.1
PR110
PAH-UPDATE-BENEFIT
Element: Update Benefit
Alpha 1
This contains the update benefit flag that was on the action when it was processed.
N = No
Y = Yes
HR11.2 HR511
LT101 LT111
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.4 PA52.5
PA54.1 PR110
PAH-UPDATE-REQ-DED
Element: Update Req Ded
Alpha 1
This field is the update required deduction flag that was on the action when it was processed.
N = No
Y = Yes
HR11.2 HR511
LT101 LT111
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.4 PA52.5
PA54.1 PR110
PAH-EDM-EFFECT-DT
Element: Edm Effect Dt
Numeric 8 (yyyymmdd)
This field contains the EDM effect date that was used when the action was processed.
HR11.2 HR511
LT101 LT111
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.4 PA52.5
PA54.1 PR110
PAH-EDM-END-DATE
Element: Edm End Date
Numeric 8 (yyyymmdd)
This date indicates the EDM end date that was used when the action was processed.
HR11.2 HR511
LT101 LT111
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.4 PA52.5
PA54.1 PR110
PAH-UPD-ABS-MGMT
Element: Upd Abs Mgmt
Alpha 1
This field indicates the absense managment flag that was used with the action was processed.
N = No
Y = Yes
HR11.2 HR511
LT101 LT111
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.4 PA52.5
PA54.1 PR110
PAH-HIST-CORR-FLAG
Element: Hist Corr Flag
Alpha 2
This field indicates the history correction flag that was used when the action was processed.
1 = Create Pending Update
2 = Delete
3 = Move to Hist Error
HR11.2 HR511
LT101 LT111
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.5 PA54.1
PR110
PAH-ACTION-UPD
Element: Action Upd
Alpha 1
This field indicates the method by which the action was updated. PA52.1, PA52.4, and PA52.5 immediate would have a value of 1. PA100 would have a value of 2. PA52.2 and PA52.3 (mass actions) would have a value of 3. Actions from PA02 and PA102 would have a value of 4. PA54 actions would have a value of 5. PA13 actions would have a value of 6.
1 = Immediate
2 = Pending
3 = Mass
4 = Position
5 = Manual
6 = Emp Pos
HR11.2 HR511
LT101 LT111
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.4 PA52.5
PA54.1 PR110
PAH-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
HR11.2 HR511
HR521 LT101
LT111 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.4
PA52.5 PA54.1
PR110
PAH-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
HR11.2 HR511
HR521 LT101
LT111 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.4
PA52.5 PA54.1
PR110
PAH-CREATE-USER
Element: User
Alpha 10 (Lower Case)
HR11.2 HR511
HR521 LT101
LT111 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.4
PA52.5 PA54.1
PR110
PAH-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR521 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
LT111 LT13.5
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 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510


PERSACTHST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAHSET1 COMPANY
EMPLOYEE
EFFECT-DATE
ACTION-CODE
ACTION-NBR
HCHP.1 HR11.1
PA100 PA115
PA125 PA213
PA311 PA340
PA370 PA52.1
PA52.5 PA54.1
PA56.1 PA57.1
PA594 PA66.3
PAHSET2 OBJ-ID
...
BN100 BN305
BN35.1 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR170
HR28.1 HR511
HR515 HR54.1
HR70.1 HRS1.1
HRSC.1 LT101
LT11.5 LT111
LT13.5 ZH510
PA02.1 PA100
PA102 PA105
PAHSET4 COMPANY
EMPLOYEE
ACTION-CODE
EFFECT-DATE*
ACTION-NBR*
HR11.2 HR511
HR521 LT101
LT111 ZH230
ZH500 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.2
PA52.3 PA52.5
PA54.1 PA66.1
PA66.4 PR110
PR282 UK110
PAHSET5 COMPANY
ACTION-CODE
EMPLOYEE
EFFECT-DATE*
ACTION-NBR*
PA125 PA340
PA341 PA355
PA66.2
PAHSET6 COMPANY
DATE-STAMP
OBJ-ID
KeyChange
PA149
PAHSET7 COMPANY
EMPLOYEE
EFFECT-DATE*
ACTION-CODE
ACTION-NBR


PERSACTHST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Action Code PERSACTYPE Required
PAH-COMPANY->PAT-COMPANY (PATSET1)
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


PERSACTHST FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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
Reason PAACTREAS Required
When PAH-REASON !=Spaces
PAH-COMPANY->CRE-COMPANY
PAH-REASON->CRE-ACT-REASON-CD
  CRE-ACTION-CODE


File created: Thu Jun 09 02:25:10 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.