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
BN232 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 BN150
BN242 ET530 ETI2.1 HRHI.1 LP130 PA340
PA360 PA370 PA391 PA66.3 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
PR35.9 PR36.1 PR45.1 PR529 PR530 PR560
PR80.1 PR82.1 UK102 UK560 TA147 HR521
PA149 PA341 PA355
UPDATED BY
BN305 HAP3.1 HEP4.1 HPOS.1 HPQC.1 HPRS.1
HR11.1 HR11.2 HR125 HR15.1 HR511 HR515
HR54.1 HRLO.1 HRS1.1 HRSC.1 PA02.1 PA100
PA102 PA113 PA115 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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRH-COMPANY Numeric 4 BN305 HAP3.1
Element: Company Hr HEP4.1 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 PA115
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
PRH-EMPLOYEE Numeric 9 BN305 HAP3.1
Element: Employee Contains the employee number. Each HEP4.1 HPOS.1
person employed by the company is HPQC.1 HPRS.1
assigned a unique number. The system HR11.1 HR11.2
uses the employee number to correlate HR15.1 HR170
all of the information related to that HR511 HR515
person. HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
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
PRH-BEG-DATE Numeric 8 (yyyymmdd) BN305 HAP3.1
Element: Beg Date Contains the date the rate became HEP4.1 HPOS.1
effective. 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 PA115
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
PRH-SEQ-NBR Numeric 4 BN305 HAP3.1
Element: Seq Nbr If multiple records are created for the HEP4.1 HPOS.1
same effective date (BEG-DATE) this HPQC.1 HPRS.1
field will be incremented for each HR11.1 HR11.2
record for the date. HR15.1 HR170
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
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
PRH-PAY-RATE Signed 13.4 BN305 HAP3.1
Element: Pay Rate Contains the employee's new pay rate. HEP4.1 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 PA115
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
PRH-ANNUAL-SALARY Signed 13.4 BN305 HAP3.1
Element: Pay Rate Contains the employee's new annual HEP4.1 HPOS.1
salary. If the employee's salary class HPQC.1 HPRS.1
is "S", this value will match the Pay HR11.1 HR11.2
Rate. If the employee's salary class is HR15.1 HR170
"H", this value is computed as Pay Rate HR511 HR515
X Annual Hours (from the job code HR54.1 HR70.1
record) X the employee's FTE. HRLO.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
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
PRH-ACT-OBJ-ID Numeric 12 BN305 HAP3.1
Element: Obj Id If the change was done via a personnel HEP4.1 HPOS.1
action, the record identifier of that HPQC.1 HPRS.1
action (PERSACTHST) is stored here. HR11.1 HR11.2
HR15.1 HR170
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
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
PRH-USER-ID Alpha 10 (Lower Case) BN305 HAP3.1
Element: User Contains the User Id of the individual HEP4.1 HPOS.1
making the change. 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 PA115
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
PRH-DATE-STAMP Numeric 8 (yyyymmdd) BN305 HAP3.1
Element: Date Stamp Contains the system date when the HEP4.1 HPOS.1
change was entered. 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 PA115
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
PRH-TIME-STAMP Numeric 6 (hhmmss) BN305 HAP3.1
Element: Time Stamp Contains the system time when the HEP4.1 HPOS.1
change was entered. 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 PA115
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
PRH-SALARY-CLASS Alpha 1 BN305 HAP3.1
Element: Salary Class Contains the pay rate's salary class. HEP4.1 HPOS.1
H = Hourly HPQC.1 HPRS.1
S = Salaried HR11.1 HR11.2
HR15.1 HR170
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
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
PRH-POS-LEVEL Numeric 2 BN305 HAP3.1
Element: Pos Level Contains the position level. HEP4.1 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 PA115
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
PRH-CURRENCY-CODE Alpha 5 BN305 HAP3.1
Element: Currency Code Contains the currency in which the pay HEP4.1 HPOS.1
is recorded. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRLO.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
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
PRH-CURR-ND Numeric 1 BN305 HAP3.1
Element: Acct Nd The number of decimals assigned to a HEP4.1 HPOS.1
particular account as determined by the HPQC.1 HPRS.1
account currency. HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRLO.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
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
PRH-BASE-CURRENCY Alpha 5 BN305 HAP3.1
Element: Base Currency Contains the company's base currency. HEP4.1 HPOS.1
HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRLO.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
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
PRH-BASE-ND Numeric 1 BN305 HAP3.1
Element: Base Nd The number of decimal positions defined HEP4.1 HPOS.1
for the company base currency. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRLO.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
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
PRH-BASE-PAY-RATE Signed 13.4 BN305 HAP3.1
Element: Pay Rate Contains the pay in the company's base HEP4.1 HPOS.1
currency. 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 PA115
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
PRH-ANNUAL-HOURS Numeric 4 BN305 HAP3.1
Element: Annual Hours Contains the employee's annual hours at HEP4.1 HPOS.1
the time of this pay rate history HPQC.1 HPRS.1
record. HR11.1 HR11.2
HR15.1 HR170
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
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
PRH-NBR-FTE Signed 7.6 BN305 HAP3.1
Element: Nbr Fte Contains the employee's FTE at the time HEP4.1 HPOS.1
of this pay rate history record. 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 PA115
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
PRRATEHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRHSET1 COMPANY BN100 BN101
EMPLOYEE BN102 BN103
BEG-DATE BN105 BN145
SEQ-NBR BN232 BN245
BN305 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
HAP3.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR105
...
PRHSET2 COMPANY KeyChange BN150 BN242
EMPLOYEE BN305 ET530
POS-LEVEL ETI2.1 HAP3.1
BEG-DATE* HEP4.1 HPOS.1
SEQ-NBR* HPQC.1 HPRS.1
HR105 HR11.1
HR11.2 HR125
HR15.1 HR170
HR511 HR515
HR54.1 HR70.1
HRHI.1 HRS1.1
HRSC.1 LP130
PA02.1 PA100
PA102 PA105
PA113 PA115
...
PRHSET4 COMPANY KeyChange, Subset BN305 HAP3.1
ACT-OBJ-ID Where (ACT-OBJ-ID != Zeroes ) HEP4.1 HPOS.1
EMPLOYEE HPQC.1 HPRS.1
BEG-DATE HR11.1 HR11.2
SEQ-NBR HR15.1 HR511
HR515 HR521
HR54.1 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
Paemployee PAEMPLOYEE Required
PRH-COMPANY -> PEM-COMPANY
PRH-EMPLOYEE -> PEM-EMPLOYEE
Persacthst PERSACTHST Required
When PRH-ACT-OBJ-ID != Zeroes
PRH-ACT-OBJ-ID -> PAH-OBJ-ID
|