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
LP140 LP145 LP198 HCHP.1 HRHI.1


UPDATED BY
BN100 BN101 BN102 BN103 BN104 BN105
BN145 BN150 BN230 BN232 BN245 BN305
BN31.1 BN31.2 BN32.1 BN32.2 BN32.3 BN320
BN430 BN45.1 BN48.1 BN531 BN65.1 BN70.1
BN71.1 BN72.1 BS13.1 BS14.1 BS15.1 BS32.1
ZB10.1 ZB31.1 ZB31.2 ZB32.1 ZB32.2 ZB32.3
HCEM.1 HAP3.1 HCRE.1 HEP4.1 HPOS.1 HPQC.1
HPRS.1 HR00.1 HR01.1 HR04.4 HR04.5 HR04.6
HR06.1 HR07.1 HR105 HR11.1 HR11.2 HR125
HR13.1 HR15.1 HR170 HR206 HR207 HR28.1
HR506 HR507 HR511 HR513 HR515 HR521
HR54.1 HR70.1 HR93.1 HR93.3 HR93.4 HR93.5
HR93.6 HR93.7 HR93.8 HR93.9 HRLO.1 HRS1.1
HRSC.1 LT101 LT11.5 PR521 ZH510 EXI2.1
EXI4.1 LP100 LP101 LP102 LP103 LP130
LP131 LP180 LP197 LP220 LP31.1 LP331
LP51.1 LP80.1 HS11.1 HS11.2 PA02.1 PA100
PA102 PA105 PA113 PA115 PA120 PA125
PA13.1 PA13.2 PA149 PA213 PA218 PA223
PA231 PA28.1 PA302 PA31.1 PA311 PA340
PA341 PA355 PA370 PA390 PA391 PA392
PA393 PA490 PA495 PA496 PA502 PA513
PA52.1 PA52.3 PA52.4 PA52.5 PA531 PA54.1
PA55.1 PA594 PA66.3 ZE531 MR551 PR11.1
PR11.2 PR11.3 PR11.4 PR11.5 PR110 PR113
PR12.6 PR120 PR127 PR128 PR129 PR13.1
PR13.2 PR13.5 PR13.6 PR13.8 PR13.9 PR130
PR131 PR132 PR134 PR135 PR136 PR137
PR14.1 PR14.2 PR15.1 PR15.2 PR189 PR205
PR227 PR240 PR241 PR242 PR243 PR244
PR245 PR248 PR249 PR250 PR251 PR252
PR253 PR26.1 PR27.1 PR27.2 PR280 PR282
PR286 PR287 PR29.1 PR290 PR291 PR292
PR293 PR297 PR298 PR299 PR30.1 PR30.2
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 PR37.1 PR39.1 PR39.2 PR45.1
PR47.1 PR514 PR529 PR530 PR539 PR560
PR582 PR80.1 PR80.3 PR80.4 PR82.1 PRSC.1
UK102 UK201 UK47.1 UK560 ZP530 ZP551
ZP560 TA147 WAOP.1

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 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.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 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 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.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 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 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.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 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 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.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 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 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.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 WAOP.1
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 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.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 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 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.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 ZH510
HRH-A-VALUE
Element: A Value		Alpha 30 (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 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.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 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 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.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 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 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.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
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 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.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 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 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.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 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 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.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 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
S = Supervisor
T = Standard Time Record
L = Leave Plan Master
V = Leave of Absence
BN305 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
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.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 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 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.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 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 HR15.1
HR28.1 HR511
HR515 HR54.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.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 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 HR15.1
HR28.1 HR511
HR515 HR54.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.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 ZH510


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 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 ZB10.1
ZB31.1 ZB31.2
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 HR125
HR13.1 HR15.1
HR170 HR206
HR207 HR28.1
HR511 HR513
HR515 HR54.1
HR70.1 HR93.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 HR125
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT11.5 ZH510
LP100 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA302 PA311
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
HR15.1 HR28.1
HR511 HR515
HR521 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
ZH510 PA02.1
PA100 PA102
PA113 PA115
PA125 PA13.1
PA13.2 PA149
HRHSET5 COMPANY
FLD-NBR
DATE-STAMP
EMPLOYEE
OBJ-ID
BEG-DATE
SEQ-NBR
KeyChange
HR04.4 HR04.5
HR04.6 PA223
WAOP.1


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
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 11:14:56 2016

Home
Contact Us



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