Lawson Insight Technical Documentation |
|
HRHISTORY
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
BN232 BN320 HR105 HR170 HR70.1 LP100
LP220 PA105 PA213 PA490 BN230 HCEM.1
HCHP.1 HR206 HR207 HRHI.1 LP140 LP145
LP198 HS11.1 HS11.2 PA231 PA311 PA340
PA390 PA391 PA393 PA495 PA496 PA594
PA66.3 PR11.1 PR11.2 PR127 PR227 PR240
PR241 PR242 PR243 PR244 PR245 PR248
PR250 PR251 PR252 PR253 PR27.1 PR27.2
PR282 PR287 PR290 PR291 PR292 PR297
PR299 PRSC.1 HR521 PA149 PA341 PA355
PA370 HR04.4 HR04.5 HR04.6 PA223
UPDATED BY
BN305 HAP3.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.2 PR280 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 BN71.1 BN72.1
BS13.1 BS14.1 BS15.1 BS32.1 ET530 ETI1.1
ETI2.1 HR00.1 HR01.1 HR06.1 HR506 LP101
LP130 LP180 LP197 LP31.1 LP80.1 PR128
PR130 PR131 PR132 PR134 PR136 PR14.1
PR14.2 PR15.1 PR15.2 PR189 PR205 PR26.1
PR29.1 PR30.1 PR32.2 PR33.2 PR33.3 PR35.1
PR35.2 PR35.3 PR35.4 PR35.5 PR35.6 PR35.8
PR35.9 PR36.1 PR39.1 PR39.2 PR45.1 PR47.1
PR514 PR529 PR530 PR539 PR560 PR80.1
PR80.3 PR82.1 UK102 UK47.1 UK560 TA147
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HRH-COMPANY Numeric 4 BN305 HAP3.1
Element: Company Hr 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
HRH-EMPLOYEE Numeric 9 BN305 HAP3.1
Element: Employee Contains the employee number. Each HEP4.1 HPOS.1
person employed by the company is HPQC.1 HPRS.1
assigned a unique number. The system HR11.1 HR11.2
uses the employee number to correlate HR15.1 HR170
all of the information related to that HR511 HR515
person. 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
HRH-OBJ-ID Numeric 12 BN305 HAP3.1
Element: Obj Id If the item being logged is from an HEP4.1 HPOS.1
employee deduction, standard time HPQC.1 HPRS.1
record, job code, or supervisor this HR11.1 HR11.2
field will contain the object ID of that HR15.1 HR170
record. 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
HRH-FLD-NBR Numeric 4 BN305 HAP3.1
Element: Fld Nbr Dictionary number of the data item HEP4.1 HPOS.1
being logged. 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
HRH-BEG-DATE Numeric 8 (yyyymmdd) BN305 HAP3.1
Element: Beg Date Date for which the recorded data item HEP4.1 HPOS.1
value became effective. 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
HRH-SEQ-NBR Numeric 4 BN305 HAP3.1
Element: Seq Nbr If multiple records are created for the HEP4.1 HPOS.1
same effective date (BEG-DATE) this HPQC.1 HPRS.1
field will be incremented for each HR11.1 HR11.2
record for the date. 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
HRH-N-VALUE Signed 15.6 BN305 HAP3.1
Element: N Value If the data item is a numeric field, HEP4.1 HPOS.1
the value is stored in this field. 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
HRH-A-VALUE Alpha 30 (Lower Case) BN305 HAP3.1
Element: A Value If the data item is alpha-numeric, the HEP4.1 HPOS.1
value is stored in this field. 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
HRH-D-VALUE Numeric 8 (yyyymmdd) BN305 HAP3.1
Element: D Value If the data item is a date, the value HEP4.1 HPOS.1
is stored in this field. 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
HRH-ACT-OBJ-ID Numeric 12 BN305 HAP3.1
Element: Obj Id If the change was done via a personnel HEP4.1 HPOS.1
action, the record identifier of that HPQC.1 HPRS.1
action (PERSACTHST) is stored here. 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
HRH-USER-ID Alpha 10 (Lower Case) BN305 HAP3.1
Element: User Contains the User Id of the person HEP4.1 HPOS.1
making the change. 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
HRH-DATE-STAMP Numeric 8 (yyyymmdd) BN305 HAP3.1
Element: Date Stamp Contains the system date on which the HEP4.1 HPOS.1
history update is made. 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
HRH-TIME-STAMP Numeric 6 (hhmmss) BN305 HAP3.1
Element: Time Stamp Contains the system time for which the HEP4.1 HPOS.1
history update is made. 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
HRH-DATA-TYPE Alpha 1 BN305 HAP3.1
Element: Data Type Indicator of the type of data record HEP4.1 HPOS.1
for which changes are logged. HPQC.1 HPRS.1
E = Employee HR11.1 HR11.2
A = Applicant HR15.1 HR170
D = Deduction HR511 HR515
J = Job Code HR54.1 HR70.1
P = Position HRLO.1 HRS1.1
S = Supervisor HRSC.1 PA02.1
T = Standard Time Record PA100 PA102
L = Leave Plan Master 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
HRH-POS-LEVEL Numeric 2 BN305 HAP3.1
Element: Pos Level 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
HRH-N-VALUE-0 Derived
Element: N Value 0
HRH-N-VALUE-1 Derived
Element: N Value 1
HRH-N-VALUE-2 Derived
Element: N Value 2
HRH-N-VALUE-3 Derived
Element: N Value 3
HRH-CURRENCY-CODE Alpha 5 BN305 HAP3.1
Element: Currency Code This field contains the company base HEP4.1 HPOS.1
currency code established in Company HPQC.1 HPRS.1
(GL10.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
HRH-CURR-ND Numeric 1 BN305 HAP3.1
Element: Acct Nd The number of decimals assigned to a HEP4.1 HPOS.1
particular account as determined by the HPQC.1 HPRS.1
account currency. 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
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 BN150
BEG-DATE BN232 BN245
SEQ-NBR 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 ET530
ETI1.1 ETI2.1
...
HRHSET2 COMPANY KeyChange BN150 BN230
EMPLOYEE BN305 BN320
OBJ-ID ET530 ETI2.1
FLD-NBR HCEM.1 HCHP.1
POS-LEVEL HAP3.1 HEP4.1
BEG-DATE* HPOS.1 HPQC.1
SEQ-NBR* HPRS.1 HR105
HR11.1 HR11.2
HR125 HR15.1
HR170 HR206
HR207 HR511
HR515 HR54.1
HR70.1 HRHI.1
HRS1.1 HRSC.1
LP130 LP140
...
HRHSET3 COMPANY KeyChange BN305 HAP3.1
EMPLOYEE HEP4.1 HPOS.1
OBJ-ID HPQC.1 HPRS.1
POS-LEVEL HR11.1 HR11.2
BEG-DATE HR125 HR15.1
FLD-NBR HR511 HR515
SEQ-NBR 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 PA52.4
...
HRHSET4 COMPANY KeyChange, Subset BN305 HCHP.1
ACT-OBJ-ID Where (ACT-OBJ-ID != Zeroes ) HAP3.1 HEP4.1
FLD-NBR HPOS.1 HPQC.1
EMPLOYEE HPRS.1 HR11.1
OBJ-ID HR11.2 HR15.1
BEG-DATE HR511 HR515
SEQ-NBR HR521 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA125
PA13.1 PA13.2
PA149 PA213
PA311 PA340
PA341 PA355
...
HRHSET5 COMPANY KeyChange HR04.4 HR04.5
FLD-NBR HR04.6 PA223
DATE-STAMP
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
PEA-FLD-NBR
PEA-ACT-OBJ-ID
|