PERSACTDTL FILE
Personnel Action Detail
Contains field and value changes for personnel action history.
REFERENCED BY
PA149 PA213 PA311 PA340 PA66.1 PA66.2
PA66.3 PA66.4
UPDATED BY
HR511 HR521 HRLO.1 PA02.1 PA100 PA102
PA115 PA125 PA13.1 PA13.2 PA502 PA513
PA52.1 PA52.4 PA52.5 PA54.1 HR11.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PDA-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
PDA-FLD-NBR Numeric 4 HR511 HR521
Dictionary Field This field contains the PO dictionary PA02.1 PA100
Number field number. PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.4 PA52.5
PA54.1
PDA-NEW-VALUE Alpha 30 HR511 HR521
Field Value After Contains the new value to be updated. PA02.1 PA100
Change PA102 PA115
PA125 PA13.1
PA13.2 PA311
PA340 PA502
PA513 PA52.1
PA52.4 PA52.5
PA54.1 PA66.3
PDA-SEQ-NBR Numeric 4 HRLO.1 PA54.1
Sequence Number Containts a sequence number from
HRHISTORY or PRRATEHIST representing the
history record reflected in the
personnel action.
PDA-POS-LEVEL Numeric 2 HR511 HR521
Pos Level Contains the position level. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.4 PA52.5
PA54.1
PERSACTDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PDASET1 OBJ-ID HR11.1 HR521
FLD-NBR HRLO.1 PA115
PA125 PA149
PA213 PA311
PA340 PA54.1
PA66.1 PA66.2
PA66.3 PA66.4
PERSACTDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Fld Nbr PADICT Required
PDA-FLD-NBR -> PAD-FLD-NBR
Persacthst PERSACTHST Required
PDA-OBJ-ID -> PAH-OBJ-ID
PERSACTDTL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Hrhistory HRHISTORY
PAH-COMPANY -> HRH-COMPANY
PAH-EMPLOYEE -> HRH-EMPLOYEE
Zeroes -> HRH-OBJ-ID
PDA-FLD-NBR -> HRH-FLD-NBR
HRH-BEG-DATE
HRH-SEQ-NBR
|