|
|
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 BN150 HR511
HRHI.1 PA02.1 PA100 PA102 PA113 PA13.1
PA13.2 PA340 PA360 PA370 PA502 PA513
PA52.1 PA52.3 PA52.4 PA52.5 PA66.3 PA67.1
PR110 PR128 PR13.1 PR131 PR132 PR134
PR136 PR137 PR140 PR150 PR195 PR199
PR32.1 PR32.2 PR33.1 PR33.2 PR33.3 PR35.1
PR35.2 PR35.3 PR35.4 PR35.5 PR35.6 PR35.8
PR36.1 PR37.1 PR45.1 PR530 PR80.1 PR82.1
PR85.1 UK102 UK330 UK120
UPDATED BY
HR125 HR54.1 HR700 HRLO.1 PA115 PA125
PA54.1 HR11.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRH-COMPANY Numeric 4 HR170 HR54.1
Company The company number represents an HR70.1 HRLO.1
established company and is entered on PA54.1
all function codes.
PRH-EMPLOYEE Numeric 9 HR170 HR54.1
Employee Contains the employee number. Each HR70.1 HRLO.1
person employed by the company is PA54.1
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
PRH-BEG-DATE Numeric 8 (yyyymmdd) HR170 HR54.1
Beginning Date Contains the date the rate became HR70.1 HRLO.1
effective. PA54.1
PRH-SEQ-NBR Numeric 4 HR170 HR54.1
Sequence Number If multiple records are created for the HR70.1 HRLO.1
same effective date (BEG-DATE) this PA54.1
field will be incremented for each
record for the date.
PRH-PAY-RATE Signed 13.4 HR170 HR54.1
Rate of Pay Contains the employee's new pay rate. HR70.1 HRLO.1
PA54.1
PRH-ANNUAL-SALARY Signed 13.4 HR170 HR54.1
Annual Salary Contains the employee's new annual HR70.1 HRLO.1
salary. If the employee's salary class PA54.1
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.
PRH-ACT-OBJ-ID Numeric 12 HR170 HR54.1
Subsystem Activity If the change was done via a personnel HR70.1 HRLO.1
InterfaceID action, the record identifier of that PA125 PA54.1
action (PERSACTHST) is stored here.
PRH-USER-ID Alpha 10 (Lower Case) HR170 HR54.1
User ID Name Contains the User Id of the individual HR70.1 HRLO.1
making the change. PA54.1
PRH-DATE-STAMP Numeric 8 (yyyymmdd) HR170 HR54.1
Date Stamp Contains the system date when the HR70.1 HRLO.1
change was entered. PA54.1
PRH-TIME-STAMP Numeric 6 (hhmmss) HR170 HR54.1
Time Stamp Contains the system time when the HR70.1 HRLO.1
change was entered. PA54.1
PRH-SALARY-CLASS Alpha 1 HR170 HR54.1
Salary Class Contains the pay rate's salary class. HR70.1 HRLO.1
H = Hourly PA54.1
S = Salaried
PRH-POS-LEVEL Numeric 2 HR170 HR54.1
Pos Level Contains the position level. HR70.1 HRLO.1
PA54.1
PRH-CURRENCY-CODE Alpha 5 HR54.1 HR700
Currency Code Contains the currency in which the pay HRLO.1 PA54.1
is recorded.
PRH-CURR-ND Numeric 1 HR54.1 HR700
Currency Number of Represents the number of decimals HRLO.1 PA54.1
Decimals defined for the currency of the object.
PRH-BASE-CURRENCY Alpha 5 HR54.1 HR700
Base Currency Contains the company's base currency. HRLO.1 PA54.1
PRH-BASE-ND Numeric 1 HR54.1 HR700
Base Number Of The number of decimal positions defined HRLO.1 PA54.1
Decimals for the company base currency.
PRH-BASE-PAY-RATE Signed 13.4 HR54.1 HR700
Base Pay Rate Contains the pay in the company's base HRLO.1 PA54.1
currency.
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
HR125 HR170
HR54.1 HR70.1
HR700 HRLO.1
...
PRHSET2 COMPANY KeyChange BN150 HR105
EMPLOYEE HR11.1 HR125
POS-LEVEL HR170 HR511
BEG-DATE* HR54.1 HR70.1
SEQ-NBR* HRHI.1 PA02.1
PA100 PA102
PA105 PA113
PA115 PA125
PA13.1 PA13.2
PA213 PA311
PA340 PA360
PA370 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
...
PRHSET3 COMPANY KeyChange
DATE-STAMP
EMPLOYEE
BEG-DATE
SEQ-NBR
PRHSET4 COMPANY Subset PA125 PA54.1
ACT-OBJ-ID Where (ACT-OBJ-ID != Zeroes )
EMPLOYEE
BEG-DATE
SEQ-NBR
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
|