PRRATEHIST

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
HRHI.1


UPDATED BY
BN100 BN101 BN102 BN103 BN105 BN145
BN150 BN232 BN242 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 ZB10.1 ZB31.1 ZB31.2 ZB32.1
ZB32.2 ZB32.3 HAP3.1 HCRE.1 HEP4.1 HPOS.1
HPQC.1 HPRS.1 HR105 HR11.1 HR11.2 HR125
HR15.1 HR170 HR28.1 HR511 HR515 HR521
HR54.1 HR70.1 HR93.2 HRLO.1 HRS1.1 HRSC.1
LT101 LT11.5 PR521 ZH510 EXI2.1 EXI4.1
LP130 PA02.1 PA100 PA102 PA105 PA113
PA115 PA125 PA13.1 PA13.2 PA149 PA213
PA311 PA340 PA341 PA355 PA360 PA370
PA391 PA502 PA513 PA52.1 PA52.3 PA52.4
PA52.5 PA54.1 PA55.1 PA66.3 PA67.1 PR110
PR113 PR12.6 PR120 PR128 PR13.1 PR13.5
PR13.6 PR13.8 PR13.9 PR130 PR131 PR132
PR134 PR135 PR136 PR137 PR189 PR282
PR29.1 PR30.2 PR32.1 PR32.2 PR33.1 PR33.2
PR33.3 PR35.1 PR35.2 PR35.3 PR35.4 PR35.5
PR35.6 PR35.8 PR35.9 PR36.1 PR37.1 PR45.1
PR529 PR530 PR560 PR582 PR80.1 PR80.4
PR82.1 UK102 UK560 ZP530 TA147

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRH-COMPANY
Element: Company Hr
Numeric 4
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
PRH-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
PRH-BEG-DATE
Element: Beg Date
Numeric 8 (yyyymmdd)
Contains the date the rate became effective.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
PRH-SEQ-NBR
Element: Seq Nbr
Numeric 4
If multiple records are created for the same effective date (BEG-DATE) this field will be incremented for each record for the date.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
PRH-PAY-RATE
Element: Pay Rate
Signed 13.4
Contains the employee's new pay rate.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
PRH-ANNUAL-SALARY
Element: Pay Rate
Signed 13.4
Contains the employee's new annual salary. If the employee's salary class is "S", this value will match the Pay Rate. If the employee's salary class is "H", this value is computed as Pay Rate X Annual Hours (from the job code record) X the employee's FTE.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
PRH-ACT-OBJ-ID
Element: Obj Id
Numeric 12
If the change was done via a personnel action, the record identifier of that action (PERSACTHST) is stored here.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.5 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 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
PRH-USER-ID
Element: User
Alpha 10 (Lower Case)
Contains the User Id of the individual making the change.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
PRH-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
Contains the system date when the change was entered.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
PRH-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the system time when the change was entered.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
PRH-SALARY-CLASS
Element: Salary Class
Alpha 1
Contains the pay rate's salary class.
H = Hourly
S = Salaried
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
PRH-POS-LEVEL
Element: Pos Level
Numeric 2
Contains the position level.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
PRH-CURRENCY-CODE
Element: Currency Code
Alpha 5
Contains the currency in which the pay is recorded.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
PRH-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
PRH-BASE-CURRENCY
Element: Base Currency
Alpha 5
Contains the company's base currency.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
PRH-BASE-ND
Element: Base Nd
Numeric 1
The number of decimal positions defined for the company base currency.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
PRH-BASE-PAY-RATE
Element: Pay Rate
Signed 13.4
Contains the pay in the company's base currency.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
PRH-ANNUAL-HOURS
Element: Annual Hours
Numeric 4
Contains the employee's annual hours at the time of this pay rate history record.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
PRH-NBR-FTE
Element: Nbr Fte
Signed 7.6
Contains the employee's FTE at the time of this pay rate history record.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HRLO.1 HRS1.1
HRSC.1 LT101
LT11.5 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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510


PRRATEHIST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRHSET1 COMPANY
EMPLOYEE
BEG-DATE
SEQ-NBR
...
BN100 BN101
BN102 BN103
BN105 BN145
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
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
PRHSET2 COMPANY
EMPLOYEE
POS-LEVEL
BEG-DATE*
SEQ-NBR*
KeyChange
...
BN150 BN242
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR105
HR11.1 HR11.2
HR125 HR15.1
HR170 HR28.1
HR511 HR515
HR54.1 HR70.1
HR93.2 HRHI.1
HRS1.1 HRSC.1
LT101 LT11.5
PR521 ZH510
EXI2.1 EXI4.1
PRHSET4 COMPANY
ACT-OBJ-ID
EMPLOYEE
BEG-DATE
SEQ-NBR
KeyChange, Subset
Where(ACT-OBJ-ID !=Zeroes)
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR28.1 HR511
HR515 HR521
HR54.1 HRS1.1
HRSC.1 LT101
LT11.5 ZH510
PA02.1 PA100
PA102 PA113
PA115 PA125
PA13.1 PA13.2
PA149 PA213


PRRATEHIST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:15:30 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.