HRHISTORY FILE
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
BN320 BN400 HR105 HR170 HR70.1 PA105
PA213 PA391 PA66.3 HCOP.1 HCOP.2 HR206
HR207 HRHI.1 HS11.1 PA113 PA231 PA311
PA340 PA390 PA393 PR290 PR291 PR292
PR297 PR298 HR04.4 HR04.5 HR04.6 HR704
UPDATED BY
HR07.1 HR11.1 HR125 HR54.1 HR700 HRLO.1
PA02.1 PA115 PA120 PA125 PA302 PA502
PA54.1 PA731 PR280 BN100 BN101 BN102
BN103 BN104 BN105 BN145 BN245 BN31.1
BN31.2 BN32.1 BN32.2 BN32.3 BN430 BN45.1
BN531 BN65.1 BN71.1 BN72.1 BS13.1 BS14.1
BS15.1 BS32.1 HR00.1 HR01.1 HR06.1 HR15.2
HR511 PA100 PA52.1 PA52.4 PA52.5 PBIP.1
PR13.1 PR13.2 PR14.1 PR15.1 PR15.2 PR205
PR26.1 PR30.1 PR39.1 PR39.2 PR514
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HRH-COMPANY Numeric 4 HR170 HR54.1
Company The company number represents an HR70.1 HRLO.1
established company and is entered on PA02.1 PA502
all function codes. PA54.1
HRH-EMPLOYEE Numeric 9 HR170 HR54.1
Employee Contains the employee number. Each HR70.1 HRLO.1
person employed by the company is PA02.1 PA502
assigned a unique number. The system PA54.1
uses the employee number to correlate
all of the information related to that
person.
HRH-OBJ-ID Numeric 12 HR170 HR54.1
Object If the item being logged is from an HR70.1 HRLO.1
Identification employee deduction, standard time PA02.1 PA502
record, job code, or supervisor this PA54.1
field will contain the object ID of that
record.
HRH-FLD-NBR Numeric 4 HR170 HR54.1
Dictionary Field Dictionary number of the data item HR70.1 HRLO.1
Number being logged. PA02.1 PA502
PA54.1
HRH-BEG-DATE Numeric 8 (yyyymmdd) HR170 HR54.1
Beginning Date Date for which the recorded data item HR70.1 HRLO.1
value became effective. PA02.1 PA502
PA54.1
HRH-SEQ-NBR Numeric 4 HR170 HR54.1
Sequence Number If multiple records are created for the HR70.1 HRLO.1
same effective date (BEG-DATE) this PA02.1 PA502
field will be incremented for each PA54.1
record for the date.
HRH-N-VALUE Signed 13.4 HR170 HR54.1
N Value If the data item is a numeric field, HR70.1 HRLO.1
the value is stored in this field. PA02.1 PA502
PA54.1 PA731
HRH-A-VALUE Alpha 30 (Lower Case) HR170 HR54.1
A Value If the data item is alpha-numeric, the HR70.1 HRLO.1
value is stored in this field. PA02.1 PA502
PA54.1 PA731
HRH-D-VALUE Numeric 8 (yyyymmdd) HR170 HR54.1
D Value If the data item is a date, the value HR70.1 HRLO.1
is stored in this field. PA02.1 PA502
PA54.1
HRH-ACT-OBJ-ID Numeric 12 HR170 HR54.1
Subsystem Activity If the change was done via a personnel HR70.1 HRLO.1
InterfaceID action, the record identifier of that PA02.1 PA125
action (PERSACTHST) is stored here. PA502 PA54.1
HRH-USER-ID Alpha 10 (Lower Case) HR170 HR54.1
User ID Name Contains the User Id of the person HR70.1 HRLO.1
making the change. PA02.1 PA502
PA54.1
HRH-DATE-STAMP Numeric 8 (yyyymmdd) HR170 HR54.1
Date Stamp Contains the system date on which the HR70.1 HRLO.1
history update is made. PA02.1 PA502
PA54.1
HRH-TIME-STAMP Numeric 6 (hhmmss) HR170 HR54.1
Time Stamp Contains the system time for which the HR70.1 HRLO.1
history update is made. PA02.1 PA502
PA54.1
HRH-DATA-TYPE Alpha 1 HR170 HR54.1
Data Type Indicator of the type of data record HR70.1 HRLO.1
for which changes are logged. PA02.1 PA502
E = Employee PA54.1
A = Applicant
D = Deduction
J = Job Code
P = Position
S = Supervisor
T = Standard Time Record
HRH-POS-LEVEL Numeric 2 HR170 HR54.1
Pos Level HR70.1 HRLO.1
PA54.1
HRH-N-VALUE-0 Derived
N Value 0
HRH-N-VALUE-1 Derived
N Value 1
HRH-N-VALUE-2 Derived
N Value 2
HRH-N-VALUE-3 Derived
N Value 3
HRH-CURRENCY-CODE Alpha 5 HR54.1 HR700
Currency Code This field contains the company base HRLO.1 PA02.1
currency code established in GL10.1 PA502 PA54.1
(Company).
HRH-CURR-ND Numeric 1 HR54.1 HR700
Currency Number of Represents the number of decimals HRLO.1 PA02.1
Decimals defined for the currency of the object. PA502 PA54.1
HRHISTORY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HRHSET1 COMPANY BN100 BN101
EMPLOYEE BN102 BN103
OBJ-ID BN104 BN105
FLD-NBR BN145 BN245
BEG-DATE BN31.1 BN31.2
SEQ-NBR BN32.1 BN32.2
BN32.3 BN320
BN400 BN430
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR00.1
HR01.1 HR06.1
HR07.1 HR105
...
HRHSET2 COMPANY KeyChange HCOP.1 HCOP.2
EMPLOYEE HR105 HR125
OBJ-ID HR170 HR206
FLD-NBR HR207 HR54.1
POS-LEVEL HR70.1 HRHI.1
BEG-DATE* HS11.1 PA105
SEQ-NBR* PA113 PA115
PA125 PA213
PA231 PA311
PA340 PA390
PA391 PA393
PA54.1 PA66.3
PR280 PR290
PR291 PR292
PR297 PR298
HRHSET3 COMPANY KeyChange, Subset HR125 HR15.2
EMPLOYEE Where ACT-OBJ-ID = Zeroes PA02.1 PA115
OBJ-ID PA302 PA311
BEG-DATE PR280
FLD-NBR
SEQ-NBR
HRHSET4 COMPANY Subset HCOP.2 PA125
ACT-OBJ-ID Where (ACT-OBJ-ID != Zeroes ) PA54.1
FLD-NBR
EMPLOYEE
OBJ-ID
BEG-DATE
SEQ-NBR
HRHSET5 COMPANY KeyChange HR04.4 HR04.5
FLD-NBR HR04.6 HR700
DATE-STAMP HR704 PA731
EMPLOYEE
OBJ-ID
BEG-DATE
SEQ-NBR
HRHISTORY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|