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 BN242
HRHI.1 PA340 PA360 PA370 PA66.3 PA66.1
PA66.2 PA66.4 PA67.1 PR282 HR521 PA149
PA341 PA355
UPDATED BY
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 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 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
PRH-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
PRH-BEG-DATE Numeric 8 (yyyymmdd) HAP3.1 HEP4.1
Element: Beginning DateContains the date the rate became HPOS.1 HPQC.1
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
PRH-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
PRH-PAY-RATE Signed 13.4 HAP3.1 HEP4.1
Element: Rate of Pay Contains the employee's new pay rate. 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
PRH-ANNUAL-SALARY Signed 13.4 HAP3.1 HEP4.1
Element: Rate of Pay Contains the employee's new annual HPOS.1 HPQC.1
salary. If the employee's salary class HPRS.1 HR11.1
is "S", this value will match the Pay HR11.2 HR15.1
Rate. If the employee's salary class is HR170 HR511
"H", this value is computed as Pay Rate HR515 HR54.1
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 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
PRH-USER-ID Alpha 10 (Lower Case) HAP3.1 HEP4.1
Element: User Contains the User Id of the individual 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
PRH-DATE-STAMP Numeric 8 (yyyymmdd) HAP3.1 HEP4.1
Element: Date Stamp Contains the system date when the HPOS.1 HPQC.1
change was entered. 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
PRH-TIME-STAMP Numeric 6 (hhmmss) HAP3.1 HEP4.1
Element: Time Stamp Contains the system time when the HPOS.1 HPQC.1
change was entered. 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
PRH-SALARY-CLASS Alpha 1 HAP3.1 HEP4.1
Element: Salary Class Contains the pay rate's salary class. HPOS.1 HPQC.1
H = Hourly HPRS.1 HR11.1
S = Salaried 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
PRH-POS-LEVEL Numeric 2 HAP3.1 HEP4.1
Element: Pos Level Contains the position 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
PRH-CURRENCY-CODE Alpha 5 HAP3.1 HEP4.1
Element: Currency Code Contains the currency in which the pay HPOS.1 HPQC.1
is recorded. 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
PRH-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
PRH-BASE-CURRENCY Alpha 5 HAP3.1 HEP4.1
Element: Base Currency Contains the company's base currency. 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
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 HAP3.1 HEP4.1
Base Number Of The number of decimal positions defined HPOS.1 HPQC.1
Decimals for the company base currency. 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
PRH-BASE-PAY-RATE Signed 13.4 HAP3.1 HEP4.1
Element: Rate of Pay Contains the pay in the company's base HPOS.1 HPQC.1
currency. 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
PRH-ANNUAL-HOURS Numeric 4 HAP3.1 HEP4.1
Element: Annual Hours Contains the employee's annual hours at HPOS.1 HPQC.1
the time of this pay rate history HPRS.1 HR11.1
record. 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
PRH-NBR-FTE Signed 7.6 HAP3.1 HEP4.1
Full Time Contains the employee's FTE at the time HPOS.1 HPQC.1
Equivalent Number of this pay rate history record. 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
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 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 HAP3.1
HEP4.1 HPOS.1
HPQC.1 HPRS.1
HR105 HR11.1
...
PRHSET2 COMPANY KeyChange BN242 HAP3.1
EMPLOYEE HEP4.1 HPOS.1
POS-LEVEL HPQC.1 HPRS.1
BEG-DATE* HR105 HR11.1
SEQ-NBR* HR11.2 HR125
HR15.1 HR170
HR511 HR515
HR54.1 HR70.1
HRHI.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA105 PA113
PA115 PA125
PA13.1 PA13.2
PA213 PA311
...
PRHSET3 COMPANY KeyChange
DATE-STAMP
EMPLOYEE
BEG-DATE
SEQ-NBR
PRHSET4 COMPANY KeyChange, Subset HAP3.1 HEP4.1
ACT-OBJ-ID Where (ACT-OBJ-ID != Zeroes ) HPOS.1 HPQC.1
EMPLOYEE HPRS.1 HR11.1
BEG-DATE HR11.2 HR15.1
SEQ-NBR 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 PA502
...
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
|