PERSACTHST

Personnel Action History

Contains a history log of personnel action changes.

REFERENCED BY
BN100 BN35.1 HR170 HR70.1 PA105 PA149
PA213 PA223 PA55.1 PA594 PA67.1 UK110
WAOP.1 HCHP.1 PA56.1 PA57.1


UPDATED BY
BN305 HAP3.1 HCRE.1 HEP4.1 HPOS.1 HPQC.1
HPRS.1 HR11.1 HR11.2 HR15.1 HR28.1 HR511
HR515 HR521 HR54.1 HRS1.1 HRSC.1 LT101
LT11.5 ZH230 ZH500 ZH510 PA02.1 PA100
PA102 PA113 PA115 PA125 PA13.1 PA13.2
PA311 PA340 PA341 PA355 PA370 PA502
PA513 PA52.1 PA52.3 PA52.4 PA52.5 PA54.1
PA66.1 PA66.2 PA66.3 ZE531 PR110 PR113
PR12.6 PR120 PR13.1 PR13.5 PR13.6 PR13.8
PR13.9 PR282 PR30.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAH-COMPANY
Element: Company Hr
Numeric 4
HR11.2 HR511
HR521 LT101
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
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
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
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
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
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
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 HR15.1
HR28.1 HR511
HR515 HR521
HR54.1 HRS1.1
HRSC.1 LT101
LT11.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
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 HR15.1
HR28.1 HR511
HR515 HR521
HR54.1 HRS1.1
HRSC.1 LT101
LT11.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
ZH510
PAH-ACTION-TYPE
Element: Action Type
Alpha 1
This field contains the action type.
HR11.2 HR511
HR521 LT101
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
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 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.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 ZH510
PAH-POS-LEVEL
Element: Pos Level
Numeric 2
HR11.2 HR511
HR521 LT101
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 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 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 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 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 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 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 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
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
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
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
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 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRS1.1 HRSC.1
LT101 LT11.5
ZH510 PA02.1
PA100 PA102
PA105 PA113
PA115 PA125
PAHSET4 COMPANY
EMPLOYEE
ACTION-CODE
EFFECT-DATE*
ACTION-NBR*
HR11.2 HR511
HR521 LT101
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
ZE531 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 WAOP.1
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 11:22:25 2016

Home
Contact Us



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