 |
Lawson Insight Technical Documentation |
|
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 PA490 BN230 HCOP.1 HCOP.2
HR206 HR207 HRHI.1 HS11.1 PA231 PA311
PA340 PA390 PA393 PA496 PA594 PA66.3
PA66.1 PA66.2 PA66.4 PR240 PR241 PR242
PR243 PR244 PR245 PR252 PR282 PR290
PR291 PR292 PR297 PR298 PR299 HR521
PA149 PA341 PA355 PA370 HR04.4 HR04.5
HR04.6
UPDATED BY
HR07.1 HR11.1 HR11.2 HR125 HR15.1 HR15.2
HR511 HR515 HR54.1 HR650 HR701 HRLO.1
HRS1.1 HRSC.1 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 PRSC.1
AC541 AC542 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 HR00.1 HR01.1 HR06.1 HR506
PBIP.1 PR128 PR130 PR131 PR132 PR134
PR136 PR14.1 PR15.1 PR15.2 PR189 PR197
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 PR36.1 PR39.1 PR39.2 PR45.1
PR47.1 PR514 PR529 PR530 PR560 PR80.1
PR80.3 PR82.1 UK102 TA147 UK120
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HRH-COMPANY Numeric 4 HR11.1 HR11.2
Company The company number represents an HR15.1 HR170
established company and is entered on HR511 HR515
all function codes. HR54.1 HR650
HR70.1 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
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
PRSC.1
HRH-EMPLOYEE Numeric 9 HR11.1 HR11.2
Employee Contains the employee number. Each HR15.1 HR170
person employed by the company is HR511 HR515
assigned a unique number. The system HR54.1 HR650
uses the employee number to correlate HR70.1 HRLO.1
all of the information related to that HRS1.1 HRSC.1
person. PA02.1 PA100
PA102 PA113
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
PRSC.1
HRH-OBJ-ID Numeric 12 HR11.1 HR11.2
Object If the item being logged is from an HR15.1 HR170
Identification employee deduction, standard time HR511 HR515
record, job code, or supervisor this HR54.1 HR650
field will contain the object ID of that HR70.1 HRLO.1
record. HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
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
PRSC.1
HRH-FLD-NBR Numeric 4 HR11.1 HR11.2
Dictionary Field Dictionary number of the data item HR15.1 HR170
Number being logged. HR511 HR515
HR54.1 HR650
HR70.1 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
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
PRSC.1
HRH-BEG-DATE Numeric 8 (yyyymmdd) HR11.1 HR11.2
Beginning Date Date for which the recorded data item HR15.1 HR170
value became effective. HR511 HR515
HR54.1 HR650
HR70.1 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
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
PRSC.1
HRH-SEQ-NBR Numeric 4 HR11.1 HR11.2
Sequence Number If multiple records are created for the HR15.1 HR170
same effective date (BEG-DATE) this HR511 HR515
field will be incremented for each HR54.1 HR650
record for the date. HR70.1 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
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
PRSC.1
HRH-N-VALUE Signed 13.4 HR11.1 HR11.2
N Value If the data item is a numeric field, HR15.1 HR170
the value is stored in this field. HR511 HR515
HR54.1 HR650
HR70.1 HR701
HRLO.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 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 PRSC.1
HRH-A-VALUE Alpha 30 (Lower Case) HR11.1 HR11.2
A Value If the data item is alpha-numeric, the HR15.1 HR170
value is stored in this field. HR511 HR515
HR54.1 HR650
HR70.1 HR701
HRLO.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 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 PRSC.1
HRH-D-VALUE Numeric 8 (yyyymmdd) HR11.1 HR11.2
D Value If the data item is a date, the value HR15.1 HR170
is stored in this field. HR511 HR515
HR54.1 HR650
HR70.1 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
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
PRSC.1
HRH-ACT-OBJ-ID Numeric 12 HR11.1 HR11.2
Subsystem Activity If the change was done via a personnel HR15.1 HR170
InterfaceID action, the record identifier of that HR511 HR515
action (PERSACTHST) is stored here. HR54.1 HR650
HR70.1 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
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
PRSC.1
HRH-USER-ID Alpha 10 (Lower Case) HR11.1 HR11.2
User ID Name Contains the User Id of the person HR15.1 HR170
making the change. HR511 HR515
HR54.1 HR650
HR70.1 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
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
PRSC.1
HRH-DATE-STAMP Numeric 8 (yyyymmdd) HR11.1 HR11.2
Date Stamp Contains the system date on which the HR15.1 HR170
history update is made. HR511 HR515
HR54.1 HR650
HR70.1 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
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
PRSC.1
HRH-TIME-STAMP Numeric 6 (hhmmss) HR11.1 HR11.2
Time Stamp Contains the system time for which the HR15.1 HR170
history update is made. HR511 HR515
HR54.1 HR650
HR70.1 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
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
PRSC.1
HRH-DATA-TYPE Alpha 1 HR11.1 HR11.2
Data Type Indicator of the type of data record HR15.1 HR170
for which changes are logged. HR511 HR515
E = Employee HR54.1 HR650
A = Applicant HR70.1 HRLO.1
D = Deduction HRS1.1 HRSC.1
J = Job Code PA02.1 PA100
P = Position PA102 PA113
S = Supervisor PA13.1 PA13.2
T = Standard Time Record PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PRSC.1
HRH-POS-LEVEL Numeric 2 HR11.1 HR11.2
Pos Level HR15.1 HR170
HR511 HR515
HR54.1 HR650
HR70.1 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
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
PRSC.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 HR11.1 HR11.2
Currency Code This field contains the company base HR15.1 HR511
currency code established in Company HR515 HR54.1
(GL10.1 ). HR650 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
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
PRSC.1
HRH-CURR-ND Numeric 1 HR11.1 HR11.2
Currency Number of Represents the number of decimals HR15.1 HR511
Decimals defined for the currency of the object. HR515 HR54.1
HR650 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
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
PRSC.1
HRHISTORY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HRHSET1 COMPANY AC541 AC542
EMPLOYEE BN100 BN101
OBJ-ID BN102 BN103
FLD-NBR BN104 BN105
BEG-DATE BN145 BN150
SEQ-NBR BN245 BN31.1
BN31.2 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
...
HRHSET2 COMPANY KeyChange AC541 AC542
EMPLOYEE BN150 BN230
OBJ-ID BN320 HCOP.1
FLD-NBR HCOP.2 HR105
POS-LEVEL HR11.1 HR11.2
BEG-DATE* HR125 HR15.1
SEQ-NBR* HR170 HR206
HR207 HR511
HR515 HR54.1
HR650 HR70.1
HRHI.1 HRS1.1
HRSC.1 HS11.1
PA02.1 PA100
PA102 PA105
PA113 PA115
...
HRHSET3 COMPANY KeyChange HR11.1 HR11.2
EMPLOYEE HR125 HR15.1
OBJ-ID HR15.2 HR511
POS-LEVEL HR515 HR54.1
BEG-DATE HR650 HRS1.1
FLD-NBR HRSC.1 PA02.1
SEQ-NBR PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA302 PA311
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
...
HRHSET4 COMPANY KeyChange, Subset HCOP.2 HR11.1
ACT-OBJ-ID Where (ACT-OBJ-ID != Zeroes ) HR11.2 HR15.1
FLD-NBR HR511 HR515
EMPLOYEE HR521 HR54.1
OBJ-ID HR650 HR701
BEG-DATE HRS1.1 HRSC.1
SEQ-NBR PA02.1 PA100
PA102 PA113
PA115 PA125
PA13.1 PA13.2
PA149 PA213
PA311 PA340
PA341 PA355
PA370 PA502
PA513 PA52.1
...
HRHSET5 COMPANY KeyChange HR04.4 HR04.5
FLD-NBR HR04.6 HR701
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
|