 |
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
BN400 HR105 HR170 HR70.1 PA105 PA213
PA391 HCOP.1 HCOP.2 HR206 HR207 HRHI.1
HS11.1 PA231 PA311 PA340 PA390 PA393
PA66.3 PA66.1 PA66.2 PA66.4 PR282 PR290
PR291 PR292 PR297 PR298 HR521 PA149
PA341 PA355 PA370 HR04.4 HR04.5 HR04.6
UPDATED BY
HR07.1 HR125 HR15.1 HR15.2 HR511 HR515
HR54.1 HR650 HR701 HRLO.1 HRS1.1 HRSC.1
PA113 PA120 PA125 PA302 PA502 PA513
PA54.1 PA55.1 PR13.1 PR13.5 PR13.6 PR13.8
PR13.2 PR280 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
PR128 PR131 PR132 PR134 PR136 PR14.1
PR15.1 PR15.2 PR197 PR205 PR26.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 PR47.1 PR514 PR530 PR82.1 UK102
UK120
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HRH-COMPANY Numeric 4 HR15.1 HR170
Company The company number represents an HR511 HR515
established company and is entered on HR54.1 HR650
all function codes. HR70.1 HRLO.1
HRS1.1 HRSC.1
PA113 PA502
PA513 PA54.1
PR13.1 PR13.5
PR13.6 PR13.8
HRH-EMPLOYEE Numeric 9 HR170 HR54.1
Employee Contains the employee number. Each HR70.1 HRLO.1
person employed by the company is PA502 PA54.1
assigned a unique number. The system
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 PA502 PA54.1
record, job code, or supervisor this
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. 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. PA502 PA54.1
HRH-SEQ-NBR Numeric 4 HR15.1 HR170
Sequence Number If multiple records are created for the HR511 HR515
same effective date (BEG-DATE) this HR54.1 HR650
field will be incremented for each HR70.1 HRLO.1
record for the date. HRS1.1 HRSC.1
PA113 PA502
PA513 PA54.1
PR13.1 PR13.5
PR13.6 PR13.8
HRH-N-VALUE Signed 13.4 HR15.1 HR170
N Value If the data item is a numeric field, HR511 HR515
the value is stored in this field. HR54.1 HR650
HR70.1 HR701
HRLO.1 HRS1.1
HRSC.1 PA113
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HRH-A-VALUE Alpha 30 (Lower Case) HR170 HR54.1
A Value If the data item is alpha-numeric, the HR70.1 HR701
value is stored in this field. HRLO.1 PA502
PA54.1
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. 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 PA113 PA125
action (PERSACTHST) is stored here. PA502 PA54.1
PA55.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. 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. 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. 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. PA502 PA54.1
E = Employee
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 HRLO.1
Currency Code This field contains the company base PA502 PA54.1
currency code established in Company
(GL10.1 ).
HRH-CURR-ND Numeric 1 HR54.1 HRLO.1
Currency Number of Represents the number of decimals PA502 PA54.1
Decimals defined for the currency of the object.
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
BN400 BN430
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR00.1
HR01.1 HR07.1
...
HRHSET2 COMPANY KeyChange AC541 AC542
EMPLOYEE BN150 HCOP.1
OBJ-ID HCOP.2 HR105
FLD-NBR HR125 HR15.1
POS-LEVEL HR170 HR206
BEG-DATE* HR207 HR511
SEQ-NBR* HR515 HR54.1
HR650 HR70.1
HRHI.1 HRS1.1
HRSC.1 HS11.1
PA105 PA113
PA125 PA213
PA231 PA311
PA340 PA390
PA391 PA393
...
HRHSET3 COMPANY KeyChange HR125 HR15.1
EMPLOYEE HR15.2 HR511
OBJ-ID HR515 HR54.1
POS-LEVEL HR650 HRS1.1
BEG-DATE HRSC.1 PA113
FLD-NBR PA302 PA311
SEQ-NBR PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8 PR280
HRHSET4 COMPANY KeyChange, Subset HCOP.2 HR15.1
ACT-OBJ-ID Where (ACT-OBJ-ID != Zeroes ) HR511 HR515
FLD-NBR HR521 HR54.1
EMPLOYEE HR650 HR701
OBJ-ID HRS1.1 HRSC.1
BEG-DATE PA113 PA125
SEQ-NBR PA149 PA213
PA311 PA340
PA341 PA355
PA370 PA502
PA513 PA54.1
PA55.1 PA66.1
PA66.2 PA66.3
PA66.4 PR13.1
PR13.5 PR13.6
...
HRHSET5 COMPANY KeyChange HR04.4 HR04.5
FLD-NBR HR04.6 HR701
DATE-STAMP
EMPLOYEE
OBJ-ID
BEG-DATE
SEQ-NBR
HRHSET6 COMPANY HR650
EMPLOYEE
FLD-NBR
BEG-DATE*
OBJ-ID
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
|