Lawson Insight Technical Documentation |
|
PRRATEHIST
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 AC541 AC542
BN150 BN242 HRHI.1 PA340 PA360 PA370
PA391 PA66.3 PA66.1 PA66.2 PA66.4 PA67.1
PR128 PR130 PR131 PR132 PR134 PR136
PR189 PR282 PR29.1 PR32.2 PR33.2 PR33.3
PR35.1 PR35.2 PR35.3 PR35.4 PR35.5 PR35.6
PR35.8 PR36.1 PR45.1 PR529 PR530 PR560
PR80.1 PR82.1 UK102 UK560 TA147 UK120
HR521 HR701 PA149 PA341 PA355
UPDATED BY
HGLM.1 HPOS.1 HPQC.1 HPRS.1 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 HGLM.1 HPOS.1
Element: Company The company number represents an HPQC.1 HPRS.1
established company and is entered on HR11.1 HR11.2
all function codes. 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-EMPLOYEE Numeric 9 HGLM.1 HPOS.1
Element: Employee Contains the employee number. Each HPQC.1 HPRS.1
person employed by the company is HR11.1 HR11.2
assigned a unique number. The system HR15.1 HR170
uses the employee number to correlate HR511 HR515
all of the information related to that HR54.1 HR650
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
PRH-BEG-DATE Numeric 8 (yyyymmdd) HGLM.1 HPOS.1
Element: Date Contains the date the rate became HPQC.1 HPRS.1
effective. HR11.1 HR11.2
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-SEQ-NBR Numeric 4 HGLM.1 HPOS.1
Element: Sequence NumbeIf multiple records are created for the HPQC.1 HPRS.1
same effective date (BEG-DATE) this HR11.1 HR11.2
field will be incremented for each HR15.1 HR170
record for the date. 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-PAY-RATE Signed 13.4 HGLM.1 HPOS.1
Element: Rate of Pay Contains the employee's new pay rate. HPQC.1 HPRS.1
HR11.1 HR11.2
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 HGLM.1 HPOS.1
Element: Annual Salary Contains the employee's new annual HPQC.1 HPRS.1
salary. If the employee's salary class HR11.1 HR11.2
is "S", this value will match the Pay HR15.1 HR170
Rate. If the employee's salary class is HR511 HR515
"H", this value is computed as Pay Rate HR54.1 HR650
X Annual Hours (from the job code HR70.1 HRLO.1
record) X the employee's FTE. 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-ACT-OBJ-ID Numeric 12 HGLM.1 HPOS.1
Object If the change was done via a personnel HPQC.1 HPRS.1
Identification action, the record identifier of that HR11.1 HR11.2
action (PERSACTHST) is stored here. HR15.1 HR170
HR511 HR515
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) HGLM.1 HPOS.1
Element: User Contains the User Id of the individual HPQC.1 HPRS.1
making the change. HR11.1 HR11.2
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-DATE-STAMP Numeric 8 (yyyymmdd) HGLM.1 HPOS.1
Element: Date Stamp Contains the system date when the HPQC.1 HPRS.1
change was entered. HR11.1 HR11.2
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-TIME-STAMP Numeric 6 (hhmmss) HGLM.1 HPOS.1
Element: Time Stamp Contains the system time when the HPQC.1 HPRS.1
change was entered. HR11.1 HR11.2
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-SALARY-CLASS Alpha 1 HGLM.1 HPOS.1
Element: Salary Class Contains the pay rate's salary class. HPQC.1 HPRS.1
H = Hourly HR11.1 HR11.2
S = Salaried 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-POS-LEVEL Numeric 2 HGLM.1 HPOS.1
Element: Pos Level Contains the position level. HPQC.1 HPRS.1
HR11.1 HR11.2
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 HGLM.1 HPOS.1
Element: Currency Code Contains the currency in which the pay HPQC.1 HPRS.1
is recorded. HR11.1 HR11.2
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-CURR-ND Numeric 1 HGLM.1 HPOS.1
Account Currency HPQC.1 HPRS.1
Code HR11.1 HR11.2
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-CURRENCY Alpha 5 HGLM.1 HPOS.1
To Company Base Contains the company's base currency. HPQC.1 HPRS.1
Currency HR11.1 HR11.2
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 HGLM.1 HPOS.1
Account Currency HPQC.1 HPRS.1
Code HR11.1 HR11.2
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-PAY-RATE Signed 13.4 HGLM.1 HPOS.1
Element: Base Pay Rate Contains the pay in the company's base HPQC.1 HPRS.1
currency. HR11.1 HR11.2
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-HOURS Numeric 4 HGLM.1 HPOS.1
Element: Annual Hours Contains the employee's annual hours at HPQC.1 HPRS.1
the time of this pay rate history HR11.1 HR11.2
record. 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-NBR-FTE Signed 4.3 HGLM.1 HPOS.1
Full Time Contains the employee's FTE at the time HPQC.1 HPRS.1
Equivalent Number of this pay rate history record. HR11.1 HR11.2
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
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
HGLM.1 HPOS.1
HPQC.1 HPRS.1
HR105 HR11.1
HR11.2 HR125
...
PRHSET2 COMPANY KeyChange AC541 AC542
EMPLOYEE BN150 BN242
POS-LEVEL HGLM.1 HPOS.1
BEG-DATE* HPQC.1 HPRS.1
SEQ-NBR* HR105 HR11.1
HR11.2 HR125
HR15.1 HR170
HR511 HR515
HR54.1 HR650
HR70.1 HRHI.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA105
PA113 PA115
PA125 PA13.1
...
PRHSET3 COMPANY KeyChange
DATE-STAMP
EMPLOYEE
BEG-DATE
SEQ-NBR
PRHSET4 COMPANY KeyChange, Subset HGLM.1 HPOS.1
ACT-OBJ-ID Where (ACT-OBJ-ID != Zeroes ) HPQC.1 HPRS.1
EMPLOYEE HR11.1 HR11.2
BEG-DATE HR15.1 HR511
SEQ-NBR HR515 HR521
HR54.1 HR650
HR701 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA125 PA13.1
PA13.2 PA149
PA213 PA311
PA340 PA341
PA355 PA370
...
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
|