 |
Lawson Insight Technical Documentation |
|
PRRATEHIST FILE
Employee Rate History
Contains pay rate history. Whenever an employee's pay rate is changed, a
record is created in this file reflecting the new value and the date when it
became effective. It also includes the actual (system) date and time the
change was made and the id of the user who made the change.
REFERENCED BY
BN100 BN101 BN102 BN103 BN105 BN145
BN245 BN31.1 BN31.2 BN32.1 BN32.2 BN32.3
BN320 BN45.1 BN531 BN65.1 BN71.1 BN72.1
BS13.1 BS14.1 BS15.1 BS32.1 HR105 HR170
HR70.1 PA105 PA213 PA311 BN242 HRHI.1
PA340 PA360 PA370 PA66.3 PA66.1 PA66.2
PA66.4 PA67.1 PR282 HR521 HR701 PA149
PA341 PA355
UPDATED BY
HR11.1 HR11.2 HR125 HR15.1 HR511 HR515
HR54.1 HR650 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 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRH-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
PRH-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
PRH-BEG-DATE Numeric 8 (yyyymmdd) HR11.1 HR11.2
Beginning Date Contains the date the rate became HR15.1 HR170
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
PRH-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
PRH-PAY-RATE Signed 13.4 HR11.1 HR11.2
Rate of Pay Contains the employee's new pay rate. 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
PRH-ANNUAL-SALARY Signed 13.4 HR11.1 HR11.2
Annual Salary Contains the employee's new annual HR15.1 HR170
salary. If the employee's salary class HR511 HR515
is "S", this value will match the Pay HR54.1 HR650
Rate. If the employee's salary class is HR70.1 HRLO.1
"H", this value is computed as Pay Rate HRS1.1 HRSC.1
X Annual Hours (from the job code PA02.1 PA100
record) X the employee's FTE. 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
PRH-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
PRH-USER-ID Alpha 10 (Lower Case) HR11.1 HR11.2
User ID Name Contains the User Id of the individual 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
PRH-DATE-STAMP Numeric 8 (yyyymmdd) HR11.1 HR11.2
Date Stamp Contains the system date when the HR15.1 HR170
change was entered. 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
PRH-TIME-STAMP Numeric 6 (hhmmss) HR11.1 HR11.2
Time Stamp Contains the system time when the HR15.1 HR170
change was entered. 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
PRH-SALARY-CLASS Alpha 1 HR11.1 HR11.2
Salary Class Contains the pay rate's salary class. HR15.1 HR170
H = Hourly HR511 HR515
S = Salaried 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
PRH-POS-LEVEL Numeric 2 HR11.1 HR11.2
Pos Level Contains the position 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
PRH-CURRENCY-CODE Alpha 5 HR11.1 HR11.2
Currency Code Contains the currency in which the pay HR15.1 HR511
is recorded. 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
PRH-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
PRH-BASE-CURRENCY Alpha 5 HR11.1 HR11.2
Base Currency Contains the company's base currency. HR15.1 HR511
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
PRH-BASE-ND Numeric 1 HR11.1 HR11.2
Base Number Of The number of decimal positions defined HR15.1 HR511
Decimals for the company base currency. 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
PRH-BASE-PAY-RATE Signed 13.4 HR11.1 HR11.2
Base Pay Rate Contains the pay in the company's base HR15.1 HR170
currency. 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
PRH-ANNUAL-HOURS Numeric 4 HR11.1 HR11.2
Annual Hours Contains the employee's annual hours at HR15.1 HR170
the time of this pay rate history HR511 HR515
record. 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
PRH-NBR-FTE Signed 4.3 HR11.1 HR11.2
Full Time Contains the employee's FTE at the time HR15.1 HR170
Equivalent Number of this pay rate history record. HR511 HR515
HR54.1 HR650
HR70.1 HRLO.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA13.1 PA13.2
PA370 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
PRRATEHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRHSET1 COMPANY BN100 BN101
EMPLOYEE BN102 BN103
BEG-DATE BN105 BN145
SEQ-NBR BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN320 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR105 HR11.1
HR11.2 HR125
HR15.1 HR170
HR511 HR515
...
PRHSET2 COMPANY KeyChange BN242 HR105
EMPLOYEE HR11.1 HR11.2
POS-LEVEL HR125 HR15.1
BEG-DATE* HR170 HR511
SEQ-NBR* HR515 HR54.1
HR650 HR70.1
HRHI.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA105 PA113
PA115 PA125
PA13.1 PA13.2
PA213 PA311
PA340 PA360
PA370 PA502
...
PRHSET3 COMPANY KeyChange
DATE-STAMP
EMPLOYEE
BEG-DATE
SEQ-NBR
PRHSET4 COMPANY KeyChange, Subset HR11.1 HR11.2
ACT-OBJ-ID Where (ACT-OBJ-ID != Zeroes ) HR15.1 HR511
EMPLOYEE HR515 HR521
BEG-DATE HR54.1 HR650
SEQ-NBR HR701 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA125 PA13.1
PA13.2 PA149
PA213 PA311
PA340 PA341
PA355 PA370
PA502 PA513
PA52.1 PA52.3
...
PRRATEHIST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Base Currency CUCODES Required
When (PRH-CURRENCY-CODE != Spaces )
PRH-BASE-CURRENCY -> CUC-CURRENCY-CODE
Company PRSYSTEM Required
PRH-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Currency CUCODES Required
When (PRH-CURRENCY-CODE != Spaces )
PRH-CURRENCY-CODE -> CUC-CURRENCY-CODE
Employee EMPLOYEE Required
PRH-COMPANY -> EMP-COMPANY
PRH-EMPLOYEE -> EMP-EMPLOYEE
Persacthst PERSACTHST Required
When PRH-ACT-OBJ-ID != Zeroes
PRH-ACT-OBJ-ID -> PAH-OBJ-ID
|