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
HRHI.1


UPDATED BY
BN305 HAP3.1 HCRE.1 HEP4.1 HPOS.1 HPQC.1
HPRS.1 HR07.1 HR11.1 HR11.2 HR125 HR15.1
HR507 HR511 HR515 HR54.1 HRLO.1 HRS1.1
HRSC.1 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 PR120 PR13.1
PR13.5 PR13.6 PR13.8 PR13.9 PR13.2 PR280
BN100 BN101 BN102 BN103 BN104 BN105
BN145 BN150 BN232 BN245 BN31.1 BN31.2
BN32.1 BN32.2 BN32.3 BN320 BN430 BN45.1
BN531 BN65.1 BN71.1 BN72.1 BN729 BN991
BS13.1 BS14.1 BS15.1 BS32.1 XB910 HR00.1
HR01.1 HR06.1 HR105 HR170 HR506 HR70.1
PR521 XH700 XH777 EXI2.1 EXI4.1 LP100
LP101 LP102 LP103 LP130 LP131 LP140
LP180 LP197 LP220 LP31.1 LP51.1 LP80.1
PA105 PA213 PA490 PR128 PR130 PR131
PR132 PR134 PR135 PR136 PR137 PR14.1
PR14.2 PR15.1 PR15.2 PR189 PR205 PR26.1
PR29.1 PR30.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 PR37.1 PR39.1
PR39.2 PR45.1 PR47.1 PR514 PR529 PR530
PR539 PR560 PR582 PR80.1 PR80.3 PR80.4
PR82.1 UK102 UK47.1 UK560 TA147 BN230
BN27.1 BN27.2 BN297 BN299 BN48.1 BN527
BN597 BN70.1 BN95.1 BN95.2 BN96.1 BN990
BNSC.1 HCEM.1 HCHP.1 HR13.1 HR206 HR207
HR513 HR93.1 HR93.3 HR93.4 HR93.5 HR93.6
HR93.7 HR93.8 HR93.9 HS11.1 HS11.2 PA218
PA231 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 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 UK201 HR521
PA149 PA341 PA355 PA370 HR04.4 HR04.5
HR04.6 PA223

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 HR511
HR515 HR54.1
HR70.1 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
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 HR511
HR515 HR54.1
HR70.1 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
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 HR511
HR515 HR54.1
HR70.1 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
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 HR511
HR515 HR54.1
HR70.1 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
XH700 XH777
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 HR511
HR515 HR54.1
HR70.1 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
XH700 XH777
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 HR511
HR515 HR54.1
HR70.1 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
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 HR511
HR515 HR54.1
HR70.1 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
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 HR511
HR515 HR54.1
HR70.1 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
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 HR511
HR515 HR54.1
HR70.1 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
XH700 XH777
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 HR511
HR515 HR54.1
HR70.1 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA125
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PA55.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
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 HR511
HR515 HR54.1
HR70.1 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
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 HR511
HR515 HR54.1
HR70.1 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
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 HR511
HR515 HR54.1
HR70.1 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
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 HR511
HR515 HR54.1
HR70.1 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
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 HR511
HR515 HR54.1
HR70.1 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
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
HR511 HR515
HR54.1 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
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
HR511 HR515
HR54.1 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9


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 BN729
BN991 BS13.1
BS14.1 BS15.1
BS32.1 XB910
HRHSET2 COMPANY
EMPLOYEE
OBJ-ID
FLD-NBR
POS-LEVEL
BEG-DATE*
SEQ-NBR*
KeyChange
...
BN150 BN230
BN27.1 BN27.2
BN297 BN299
BN305 BN320
BN48.1 BN527
BN597 BN70.1
BN95.1 BN95.2
BN96.1 BN990
BNSC.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
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 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LP100 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA302 PA311
PA502 PA513
PA52.1 PA52.3
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 HR511
HR515 HR521
HR54.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA125 PA13.1
PA13.2 PA149
PA213 PA311
PA340 PA341
HRHSET5 COMPANY
FLD-NBR
DATE-STAMP
EMPLOYEE
OBJ-ID
BEG-DATE
SEQ-NBR
KeyChange
HR04.4 HR04.5
HR04.6 PA223


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: Wed Jun 08 20:49:08 2016

Home
Contact Us



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