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 PA105
PA213 PA391 PA490 BN230 HCEM.1 HCHP.1
HR206 HR207 HRHI.1 HS11.1 PA231 PA311
PA340 PA390 PA393 PA495 PA496 PA534
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 PA223
UPDATED BY
HAP3.1 HEP4.1 HPOS.1 HPQC.1 HPRS.1 HR07.1
HR11.1 HR11.2 HR125 HR15.1 HR15.2 HR507
HR511 HR515 HR54.1 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 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
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 PR35.9 PR36.1 PR39.1
PR39.2 PR45.1 PR47.1 PR529 PR530 PR560
PR82.1 UK102 UK47.1 TA147 TP135
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HRH-COMPANY Numeric 4 HAP3.1 HEP4.1
Element: Company Hr Identifies the AP company if the HPOS.1 HPQC.1
resource type = V. Identifies the HR HPRS.1 HR11.1
company if the resource type = E. It is HR11.2 HR15.1
blank for type A, P or Q resources. HR170 HR511
HR515 HR54.1
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 HAP3.1 HEP4.1
Element: Employee Contains the employee number. Each HPOS.1 HPQC.1
person employed by the company is HPRS.1 HR11.1
assigned a unique number. The system HR11.2 HR15.1
uses the employee number to correlate HR170 HR511
all of the information related to that HR515 HR54.1
person. 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-OBJ-ID Numeric 12 HAP3.1 HEP4.1
Object If the item being logged is from an HPOS.1 HPQC.1
Identification employee deduction, standard time HPRS.1 HR11.1
record, job code, or supervisor this HR11.2 HR15.1
field will contain the object ID of that HR170 HR511
record. HR515 HR54.1
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-FLD-NBR Numeric 4 HAP3.1 HEP4.1
Dictionary Field Dictionary number of the data item HPOS.1 HPQC.1
Number being logged. 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
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) HAP3.1 HEP4.1
Element: Beginning DateDate for which the recorded data item HPOS.1 HPQC.1
value became effective. 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
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 HAP3.1 HEP4.1
Element: Sequence NumbeIf multiple records are created for the HPOS.1 HPQC.1
same effective date (BEG-DATE) this HPRS.1 HR11.1
field will be incremented for each HR11.2 HR15.1
record for the date. HR170 HR511
HR515 HR54.1
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 15.6 HAP3.1 HEP4.1
Element: N Value If the data item is a numeric field, HPOS.1 HPQC.1
the value is stored in this field. 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
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) HAP3.1 HEP4.1
Element: A Value If the data item is alpha-numeric, the HPOS.1 HPQC.1
value is stored in this field. 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
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) HAP3.1 HEP4.1
Element: D Value If the data item is a date, the value HPOS.1 HPQC.1
is stored in this field. 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
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 HAP3.1 HEP4.1
Object If the change was done via a personnel HPOS.1 HPQC.1
Identification action, the record identifier of that HPRS.1 HR11.1
action (PERSACTHST) is stored here. HR11.2 HR15.1
HR170 HR511
HR515 HR54.1
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) HAP3.1 HEP4.1
Element: User Contains the User Id of the person HPOS.1 HPQC.1
making the change. 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
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) HAP3.1 HEP4.1
Element: Date Stamp Contains the system date on which the HPOS.1 HPQC.1
history update is made. 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
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) HAP3.1 HEP4.1
Element: Time Stamp Contains the system time for which the HPOS.1 HPQC.1
history update is made. 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
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 HAP3.1 HEP4.1
Element: Data Type Indicator of the type of data record HPOS.1 HPQC.1
for which changes are logged. HPRS.1 HR11.1
E = Employee HR11.2 HR15.1
A = Applicant HR170 HR511
D = Deduction HR515 HR54.1
J = Job Code HR70.1 HRLO.1
P = Position HRS1.1 HRSC.1
S = Supervisor PA02.1 PA100
T = Standard Time Record PA102 PA113
L = Leave Plan Master 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-POS-LEVEL Numeric 2 HAP3.1 HEP4.1
Element: Pos Level 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
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
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 HAP3.1 HEP4.1
Element: Currency Code This field contains the company base HPOS.1 HPQC.1
currency code established in Company HPRS.1 HR11.1
(GL10.1 ). HR11.2 HR15.1
HR511 HR515
HR54.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-CURR-ND Numeric 1 HAP3.1 HEP4.1
Account Currency Represents the number of decimals HPOS.1 HPQC.1
Code defined for the currency of the object. HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.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
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 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
HAP3.1 HEP4.1
HPOS.1 HPQC.1
...
HRHSET2 COMPANY KeyChange BN150 BN230
EMPLOYEE BN320 HCEM.1
OBJ-ID HCHP.1 HAP3.1
FLD-NBR HEP4.1 HPOS.1
POS-LEVEL HPQC.1 HPRS.1
BEG-DATE* HR105 HR11.1
SEQ-NBR* HR11.2 HR125
HR15.1 HR170
HR206 HR207
HR511 HR515
HR54.1 HR70.1
HRHI.1 HRS1.1
HRSC.1 HS11.1
PA02.1 PA100
PA102 PA105
...
HRHSET3 COMPANY KeyChange HAP3.1 HEP4.1
EMPLOYEE HPOS.1 HPQC.1
OBJ-ID HPRS.1 HR11.1
POS-LEVEL HR11.2 HR125
BEG-DATE HR15.1 HR15.2
FLD-NBR HR511 HR515
SEQ-NBR HR54.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA302 PA311
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
...
HRHSET4 COMPANY KeyChange, Subset HCHP.1 HAP3.1
ACT-OBJ-ID Where (ACT-OBJ-ID != Zeroes ) HEP4.1 HPOS.1
FLD-NBR HPQC.1 HPRS.1
EMPLOYEE HR11.1 HR11.2
OBJ-ID HR15.1 HR511
BEG-DATE HR515 HR521
SEQ-NBR HR54.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA125 PA13.1
PA13.2 PA149
PA213 PA311
PA340 PA341
PA355 PA370
...
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
|