PRRATEHIST – Employee Rate History

System
Human Resources (HR)
Prefix
PRH
Primary key
COMPANY, EMPLOYEE, BEG-DATE, SEQ-NBR
Fields
20
Updated by
91 programs
Referenced by
52 programs

PRRATEHIST is the Employee Rate History table in Lawson Human Resources (prefix PRH). It is indexed by COMPANY, EMPLOYEE, BEG-DATE, SEQ-NBR (PRHSET1); alternate indexes: PRHSET2, PRHSET4 and PRHSET5. It is related 1:1 to CUCODES, PRSYSTEM, EMPLOYEE, PAEMPLOYEE and PERSACTHST. It is updated by BN150, BN305, EXI2.1, EXI4.1, HAP3.1, HCRE.1, HEP4.1, HPOS.1 and 83 more and referenced by BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN242 and 44 more. The table has 20 fields, 4 indexes and 6 documented relations.

About PRRATEHIST

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.

Fields (20)

Column = COBOL field name without the PRH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PRH-COMPANY PK
COMPANY		Numeric 4—BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +42 more
#PRH-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains 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 +42 more
#PRH-BEG-DATE PK
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 +42 more
#PRH-SEQ-NBR PK
SEQ_NBR		Numeric 4If 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 +42 more
#PRH-PAY-RATE
PAY_RATE		Signed 13.4Contains the employee's new pay rate.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +42 more
#PRH-ANNUAL-SALARY
ANNUAL_SALARY		Signed 13.4Contains 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 +42 more
#PRH-ACT-OBJ-ID SET4
ACT_OBJ_ID		Numeric 12If 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 +44 more
#PRH-USER-ID
USER_ID		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 +42 more
#PRH-DATE-STAMP SET5
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 +42 more
#PRH-TIME-STAMP
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 +42 more
#PRH-SALARY-CLASS
SALARY_CLASS		Alpha 1Contains 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 +42 more
#PRH-POS-LEVEL SET2
POS_LEVEL		Numeric 2Contains the position level.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +42 more
#PRH-CURRENCY-CODE
CURRENCY_CODE		Alpha 5Contains the currency in which the pay is recorded.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +40 more
#PRH-CURR-ND
CURR_ND		Numeric 1The 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 +40 more
#PRH-BASE-CURRENCY
BASE_CURRENCY		Alpha 5Contains the company's base currency.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +40 more
#PRH-BASE-ND
BASE_ND		Numeric 1The 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 +40 more
#PRH-BASE-PAY-RATE
BASE_PAY_RATE		Signed 13.4Contains the pay in the company's base currency.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +42 more
#PRH-ANNUAL-HOURS
ANNUAL_HOURS		Signed 8.4Contains 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 +42 more
#PRH-NBR-FTE
NBR_FTE		Signed 7.6Contains 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 +43 more
#PRH-UPDATED-BY-LTM
UPDATED_BY_LTM		Alpha 1—
  • Y Yes
  • N No
—

Indexes (4)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PRHSET1
  1. COMPANY
  2. EMPLOYEE
  3. BEG-DATE
  4. SEQ-NBR
PrimaryBN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +22 more (list truncated in source)
PRHSET2
  1. COMPANY
  2. EMPLOYEE
  3. POS-LEVEL
  4. BEG-DATE ↓
  5. SEQ-NBR ↓
KeyChangeBN150, BN242, BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1 +22 more (list truncated in source)
PRHSET4
  1. COMPANY
  2. ACT-OBJ-ID
  3. EMPLOYEE
  4. BEG-DATE
  5. SEQ-NBR
KeyChange, SubsetWhere (ACT-OBJ-ID != Zeroes)BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)
PRHSET5
  1. COMPANY
  2. DATE-STAMP ↓
  3. EMPLOYEE
  4. BEG-DATE
  5. SEQ-NBR
KeyChange—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
CUCODESPRSYSTEMEMPLOYEEPAEMPLOYEEPERSACTHSTPRRATEHIST

One to one (6) — lookups and parents

RelationTableRulesConditionField map
Base CurrencyCUCODESRequiredWhen (PRH-CURRENCY-CODE != Spaces)
PRH-BASE-CURRENCY→CUC-CURRENCY-CODE
CompanyPRSYSTEMRequired
PRH-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
CurrencyCUCODESRequiredWhen (PRH-CURRENCY-CODE != Spaces)
PRH-CURRENCY-CODE→CUC-CURRENCY-CODE
EmployeeEMPLOYEERequired
PRH-COMPANY→EMP-COMPANY
PRH-EMPLOYEE→EMP-EMPLOYEE
PaemployeePAEMPLOYEERequired
PRH-COMPANY→PEM-COMPANY
PRH-EMPLOYEE→PEM-EMPLOYEE
PersacthstPERSACTHSTRequiredWhen PRH-ACT-OBJ-ID != Zeroes
PRH-ACT-OBJ-ID→PAH-OBJ-ID

Programs

Updated by (91)

Referenced by (52)