HRHISTORY

HR History

Contains records consisting of the new value and a date stamp for each field in the Employee, Personnel Employee, Employee Deduction, Standard Time Record, Applicant, Job Code, and Supervisor files that are designated to be logged in HR10.1 (Data Item Attributes). The system logs any field changed by a personnel action regardless of the flags in HR10.1 (Data Item Attributes). Does not contain pay rate or salary changes, which are located in Employee Rate History file.

REFERENCED BY
BN232 BN320 HR105 HR170 HR70.1 PA105
PA490 BN230 BN48.1 BN70.1 HCEM.1 HCHP.1
HR206 HR207 HR93.1 HR93.3 HR93.4 HR93.5
HR93.6 HR93.7 HR93.8 HR93.9 HR94.1 HRHI.1
HS11.1 HS11.2 PA231 PA28.1 PA31.1 PA311
PA340 PA390 PA391 PA392 PA393 PA495
PA496 PA531 PA594 PA66.3 PR11.1 PR11.2
PR11.3 PR11.4 PR11.5 PR127 PR129 PR212
PR227 PR240 PR241 PR242 PR243 PR244
PR245 PR248 PR249 PR250 PR251 PR252
PR253 PR27.1 PR27.2 PR282 PR286 PR287
PR290 PR291 PR292 PR293 PR297 PR298
PR299 PRSC.1 ZP551 ZP560 HR521 PA149
PA341 PA355 PA370 HR04.4 HR04.5 HR04.6
PA223


UPDATED BY
BN305 HAP3.1 HCRE.1 HEP4.1 HPOS.1 HPQC.1
HPRS.1 HR07.1 HR11.1 HR11.2 HR11.4 HR125
HR15.1 HR28.1 HR507 HR511 HR515 HR54.1
HRLO.1 HRS1.1 HRSC.1 LT101 LT11.5 LT111
LT13.5 ZH510 LP331 PA02.1 PA100 PA102
PA113 PA115 PA120 PA125 PA13.1 PA13.2
PA302 PA502 PA513 PA52.1 PA52.3 PA52.4
PA52.5 PA54.1 PA55.1 PR110 PR113 PR12.6
PR12.1 PR12.3 PR120 PR13.1 PR13.5 PR13.6
PR13.8 PR13.9 PR13.2 PR280 PR30.2 PR30.1
PR512 BN100 BN101 BN102 BN103 BN104
BN105 BN145 BN150 BN245 BN31.1 BN31.2
BN32.1 BN32.2 BN32.3 BN430 BN45.1 BN531
BN65.1 BN66.1 BN71.1 BN72.1 BS10.1 BS12.1
BS13.1 BS14.1 BS15.1 BS32.1 ZB10.1 ZB31.1
ZB31.2 ZB32.1 ZB32.2 ZB32.3 HR00.1 HR01.1
HR06.1 HR13.1 HR213 HR506 HR513 PR521
EXI2.1 EXI4.1 LP100 LP101 LP102 LP103
LP130 LP131 LP151 LP180 LP197 LP220
LP31.1 LP51.1 LP80.1 PA213 PA218 PR128
PR131 PR132 PR134 PR135 PR136 PR137
PR14.1 PR14.2 PR140 PR15.1 PR15.2 PR160
PR189 PR195 PR205 PR26.1 PR29.1 PR32.1
PR32.2 PR33.1 PR33.2 PR33.3 PR35.1 PR35.2
PR35.3 PR35.4 PR35.5 PR35.6 PR35.8 PR35.9
PR36.1 PR36.4 PR37.1 PR39.1 PR39.2 PR45.1
PR47.1 PR514 PR529 PR530 PR539 PR560
PR582 PR80.1 PR80.3 PR80.4 PR82.1 PR89.1
PRAT.1 UK102 TA147 LP140 LP145 LP198

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HRH-COMPANY
Element: Company Hr
Numeric 4
BN305 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 HRLO.1
HRS1.1 HRSC.1
LT101 LT11.5
LT111 LT13.5
PA02.1 PA100
PA102 PA113
PA115 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
HRH-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.
BN305 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 HRLO.1
HRS1.1 HRSC.1
LT101 LT11.5
LT111 LT13.5
PA02.1 PA100
PA102 PA113
PA115 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
HRH-OBJ-ID
Element: Obj Id
Numeric 12
If the item being logged is from an employee deduction, standard time record, job code, or supervisor this field will contain the object ID of that record.
BN305 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 HRLO.1
HRS1.1 HRSC.1
LT101 LT11.5
LT111 LT13.5
PA02.1 PA100
PA102 PA113
PA115 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
HRH-FLD-NBR
Element: Fld Nbr
Numeric 4
Dictionary number of the data item being logged.
BN305 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 HRLO.1
HRS1.1 HRSC.1
LT101 LT11.5
LT111 LT13.5
PA02.1 PA100
PA102 PA113
PA115 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
HRH-BEG-DATE
Element: Beg Date
Numeric 8 (yyyymmdd)
Date for which the recorded data item value became effective.
BN305 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 HRLO.1
HRS1.1 HRSC.1
LT101 LT11.5
LT111 LT13.5
PA02.1 PA100
PA102 PA113
PA115 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
HRH-SEQ-NBR
Element: Seq Nbr
Numeric 4
If multiple records are created for the same effective date (BEG-DATE) this field will be incremented for each record for the date.
BN305 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 HRLO.1
HRS1.1 HRSC.1
LT101 LT11.5
LT111 LT13.5
PA02.1 PA100
PA102 PA113
PA115 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
HRH-N-VALUE
Element: N Value
Signed 15.6
If the data item is a numeric field, the value is stored in this field.
BN305 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 HRLO.1
HRS1.1 HRSC.1
LT101 LT11.5
LT111 LT13.5
PA02.1 PA100
PA102 PA113
PA115 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
HRH-A-VALUE
Element: Description 60
Alpha 60 (Lower Case)
If the data item is alpha-numeric, the value is stored in this field.
BN305 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 HRLO.1
HRS1.1 HRSC.1
LT101 LT11.5
LT111 LT13.5
PA02.1 PA100
PA102 PA113
PA115 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
HRH-D-VALUE
Element: D Value
Numeric 8 (yyyymmdd)
If the data item is a date, the value is stored in this field.
BN305 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 HRLO.1
HRS1.1 HRSC.1
LT101 LT11.5
LT111 LT13.5
PA02.1 PA100
PA102 PA113
PA115 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
HRH-ACT-OBJ-ID
Element: Obj Id
Numeric 12
If the change was done via a personnel action, the record identifier of that action (PERSACTHST) is stored here.
BN305 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 HRLO.1
HRS1.1 HRSC.1
LT101 LT11.5
LT111 LT13.5
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PA55.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
HRH-USER-ID
Element: User
Alpha 10 (Lower Case)
Contains the User Id of the person making the change.
BN305 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 HRLO.1
HRS1.1 HRSC.1
LT101 LT11.5
LT111 LT13.5
PA02.1 PA100
PA102 PA113
PA115 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
HRH-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
Contains the system date on which the history update is made.
BN305 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 HRLO.1
HRS1.1 HRSC.1
LT101 LT11.5
LT111 LT13.5
PA02.1 PA100
PA102 PA113
PA115 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
HRH-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the system time for which the history update is made.
BN305 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 HRLO.1
HRS1.1 HRSC.1
LT101 LT11.5
LT111 LT13.5
PA02.1 PA100
PA102 PA113
PA115 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
HRH-DATA-TYPE
Element: Data Type
Alpha 1
Indicator of the type of data record for which changes are logged.
E = Employee
A = Applicant
D = Deduction
J = Job Code
P = Position
R = Direct Deposit
S = Supervisor
T = Standard Time Record
L = Leave Plan Master
V = Leave of Absence
F = Dependent
BN305 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 HRLO.1
HRS1.1 HRSC.1
LT101 LT11.5
LT111 LT13.5
PA02.1 PA100
PA102 PA113
PA115 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
HRH-POS-LEVEL
Element: Pos Level
Numeric 2
BN305 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 HRLO.1
HRS1.1 HRSC.1
LT101 LT11.5
LT111 LT13.5
PA02.1 PA100
PA102 PA113
PA115 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
HRH-N-VALUE-0
Element: N Value 0
Derived
HRH-N-VALUE-1
Element: N Value 1
Derived
HRH-N-VALUE-2
Element: N Value 2
Derived
HRH-N-VALUE-3
Element: N Value 3
Derived
HRH-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
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 HRLO.1
HRS1.1 HRSC.1
LT101 LT11.5
LT111 LT13.5
PA02.1 PA100
PA102 PA113
PA115 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
HRH-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
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 HRLO.1
HRS1.1 HRSC.1
LT101 LT11.5
LT111 LT13.5
PA02.1 PA100
PA102 PA113
PA115 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
HRH-UPDATED-BY-LTM
Element: Updated By Ltm
Alpha 1

Y = Yes
N = No


HRHISTORY FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HRHSET1 COMPANY
EMPLOYEE
OBJ-ID
FLD-NBR
BEG-DATE
SEQ-NBR
...
BN100 BN101
BN102 BN103
BN104 BN105
BN145 BN150
BN232 BN245
BN305 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN320 BN430
BN45.1 BN531
BN65.1 BN66.1
BN71.1 BN72.1
BS10.1 BS12.1
BS13.1 BS14.1
BS15.1 BS32.1
HRHSET2 COMPANY
EMPLOYEE
OBJ-ID
FLD-NBR
POS-LEVEL
BEG-DATE*
SEQ-NBR*
KeyChange
...
BN150 BN230
BN305 BN320
BN48.1 BN70.1
HCEM.1 HCHP.1
HAP3.1 HCRE.1
HEP4.1 HPOS.1
HPQC.1 HPRS.1
HR105 HR11.1
HR11.2 HR11.4
HR125 HR13.1
HR15.1 HR170
HR206 HR207
HR213 HR28.1
HR511 HR513
HR515 HR54.1
HRHSET3 COMPANY
EMPLOYEE
OBJ-ID
POS-LEVEL
BEG-DATE
FLD-NBR
SEQ-NBR
KeyChange
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR125 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
LT111 LT13.5
ZH510 LP100
PA02.1 PA100
PA102 PA113
PA115 PA13.1
HRHSET4 COMPANY
ACT-OBJ-ID
FLD-NBR
EMPLOYEE
OBJ-ID
BEG-DATE
SEQ-NBR
KeyChange, Subset
Where(ACT-OBJ-ID !=Zeroes)
...
BN305 HCHP.1
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
HRHSET5 COMPANY
FLD-NBR
DATE-STAMP
EMPLOYEE
OBJ-ID
BEG-DATE
SEQ-NBR
KeyChange
HR04.4 HR04.5
HR04.6 PA223
PR280


HRHISTORY FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Applicant APPLICANT Required
When HRH-DATA-TYPE ="A"
HRH-COMPANY->APL-COMPANY
HRH-EMPLOYEE->APL-APPLICANT
Company PRSYSTEM Required
HRH-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Currency CUCODES Required
When (HRH-CURRENCY-CODE !=Spaces )
HRH-CURRENCY-CODE->CUC-CURRENCY-CODE
Deduction EMDEDMASTR Required
When HRH-DATA-TYPE ="D"
HRH-OBJ-ID->EDM-OBJ-ID
Emachdepst EMACHDEPST Required
When (HRH-DATA-TYPE ="R" )
HRH-OBJ-ID->EAD-OBJ-ID
Employee EMPLOYEE Required
When HRH-DATA-TYPE ="E"
HRH-COMPANY->EMP-COMPANY
HRH-EMPLOYEE->EMP-EMPLOYEE
Fld Nbr PADICT Required
HRH-FLD-NBR->PAD-FLD-NBR
Job Code JOBCODE Required
When HRH-DATA-TYPE ="J"
HRH-OBJ-ID->JBC-OBJ-ID
Paemployee PAEMPLOYEE Required
When HRH-DATA-TYPE ="E"
HRH-COMPANY->PEM-COMPANY
HRH-EMPLOYEE->PEM-EMPLOYEE
Persacthst PERSACTHST Required
When HRH-ACT-OBJ-ID !=Zeroes
HRH-ACT-OBJ-ID->PAH-OBJ-ID
Standtime STANDTIME Required
When HRH-DATA-TYPE ="T"
HRH-OBJ-ID->STM-OBJ-ID
Sup Employee EMPLOYEE Required
When HRH-FLD-NBR =721
HRH-COMPANY->EMP-COMPANY
HRH-N-VALUE->EMP-EMPLOYEE


HRHISTORY FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Pep Audit PAPEPAUDIT Delete Cascades
Valid When HRH-DATA-TYPE ="E"
HRH-COMPANY->PEA-COMPANY
HRH-EMPLOYEE->PEA-EMPLOYEE
HRH-POS-LEVEL->PEA-POS-LEVEL
HRH-BEG-DATE->PEA-EFFECT-DATE
  PEA-UPDATE-DATE
  PEA-FLD-NBR
  PEA-ACT-OBJ-ID


File created: Thu Jun 09 02:16:16 2016

Home
Contact Us



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