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.
| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
PRH-COMPANY
Element: Company Hr | Numeric 4
|
|
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.
|
|
PRH-BEG-DATE
Element: Beg Date | Numeric 8 (yyyymmdd)
Contains the date the rate became
effective.
|
|
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.
|
|
PRH-PAY-RATE
Element: Pay Rate | Signed 13.4
Contains the employee's new pay rate.
|
|
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.
|
|
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.
|
|
PRH-USER-ID
Element: User | Alpha 10 (Lower Case)
Contains the User Id of the individual
making the change.
|
|
PRH-DATE-STAMP
Element: Date Stamp | Numeric 8 (yyyymmdd)
Contains the system date when the
change was entered.
|
|
PRH-TIME-STAMP
Element: Time Stamp | Numeric 6 (hhmmss)
Contains the system time when the
change was entered.
|
|
PRH-SALARY-CLASS
Element: Salary Class | Alpha 1
Contains the pay rate's salary class.
H = Hourly
S = Salaried |
|
PRH-POS-LEVEL
Element: Pos Level | Numeric 2
Contains the position level.
|
|
PRH-CURRENCY-CODE
Element: Currency Code | Alpha 5
Contains the currency in which the pay
is recorded.
|
|
PRH-CURR-ND
Element: Acct Nd | Numeric 1
The number of decimals assigned to a
particular account as determined by the
account currency.
|
|
PRH-BASE-CURRENCY
Element: Base Currency | Alpha 5
Contains the company's base currency.
|
|
PRH-BASE-ND
Element: Base Nd | Numeric 1
The number of decimal positions defined
for the company base currency.
|
|
PRH-BASE-PAY-RATE
Element: Pay Rate | Signed 13.4
Contains the pay in the company's base
currency.
|
|
PRH-ANNUAL-HOURS
Element: Annual Hours | Signed 8.4
Contains the employee's annual hours at
the time of this pay rate history
record.
|
|
PRH-NBR-FTE
Element: Nbr Fte | Signed 7.6
Contains the employee's FTE at the time
of this pay rate history record.
|
|
PRH-UPDATED-BY-LTM
Element: Updated By Ltm | Alpha 1
Y = Yes
N = No |
|
