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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
PRH-COMPANY PKCOMPANY | Numeric 4 | — | BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +42 more |
PRH-EMPLOYEE PKEMPLOYEE | 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 +42 more |
PRH-BEG-DATE PKBEG_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 PKSEQ_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 +42 more |
PRH-PAY-RATEPAY_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 +42 more |
PRH-ANNUAL-SALARYANNUAL_SALARY | 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 +42 more |
PRH-ACT-OBJ-IDACT_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 +44 more |
PRH-USER-IDUSER_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-STAMPDATE_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-STAMPTIME_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-CLASSSALARY_CLASS | Alpha 1 | Contains the pay rate's salary class.
| BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +42 more |
PRH-POS-LEVELPOS_LEVEL | Numeric 2 | Contains the position level. | BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +42 more |
PRH-CURRENCY-CODECURRENCY_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 +40 more |
PRH-CURR-NDCURR_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 +40 more |
PRH-BASE-CURRENCYBASE_CURRENCY | Alpha 5 | Contains the company's base currency. | BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +40 more |
PRH-BASE-NDBASE_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 +40 more |
PRH-BASE-PAY-RATEBASE_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 +42 more |
PRH-ANNUAL-HOURSANNUAL_HOURS | Signed 8.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 +42 more |
PRH-NBR-FTENBR_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 +43 more |
PRH-UPDATED-BY-LTMUPDATED_BY_LTM | Alpha 1 | —
| — |
Indexes (4)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PRHSET1 | COMPANY, EMPLOYEE, BEG-DATE, SEQ-NBR | Primary | BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +22 more (list truncated in source) | |
PRHSET2 | COMPANY, EMPLOYEE, POS-LEVEL, BEG-DATE*, SEQ-NBR* | KeyChange | BN150, BN242, BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1 +22 more (list truncated in source) | |
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 +22 more (list truncated in source) |
PRHSET5 | COMPANY, DATE-STAMP*, EMPLOYEE, BEG-DATE, SEQ-NBR | KeyChange | — |
Relations
One to one (6) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 |
Programs
Updated by (91)
- BN150 Life Insurance Reportable Income
- BN305 Highly Compensated Employees
- EXI2.1 Invoke for PRTRDPD
- EXI4.1 Invoke for PRPRBPD
- HAP3.1 Applicant Option 4 Selection Invoke
- HCRE.1 Action Reason Code Selects
- HEP4.1 Employee Option 4 Selection Invoke
- HPOS.1 Position Selection Invoke
- HPQC.1 Prqcentgrp Select Invoke
- HPRS.1 Process Level Select Invoke
- HR11.1 Employee
- HR11.2 Compensation Analysis
- HR11.4 Employee Assignment Inquiry
- HR125 Employee Audit Purge
- HR15.1 User Fields
- HR28.1 Employee Ethnicity
- HR511 Employee Conversion
- HR515 User Field Conversion
- HR54.1 Employee History Correction
- HRLO.1 History Logging Routine
- HRS1.1 Select Control
- HRSC.1 Select Control
- LP130 Absence Plan Payout
- LT101 HRM Receiver Update
- LT11.5 HRM User Field Interface
- LT111 HRM Receiver Update
- LT13.5 HRM User Field Interface History
- PA02.1 Position
- PA100 Action Update
- PA102 Position Update
- PA113 Retroactive History Update
- PA115 Employee Purge
- PA125 Employee History Purge
- PA13.1 Multiple Positions and Jobs
- PA13.2 Multiple Position and Job History
- PA502 Position Conversion
- PA513 Position and Job Conversion
- PA52.1 Individual Action
- PA52.3 Mass Action
- PA52.4 Hire an Applicant
- PA52.5 Position and Job Action
- PA54.1 Personnel Action History Correction
- PA55.1 Retroactive History Audit
- PR110 Step And Grade Audit
- PR113 United States Tax Deduction Update
- PR12.6 Employee Automatic Deposit
- PR120 Mass Pay Update
- PR128 Offset Time Record Creation
- PR13.1 Employee United States Taxes
- PR13.5 Employee Canada Taxes
- PR13.6 Employee Canada Taxes
- PR13.8 U.S. Tax Deduction Errors
- PR13.9 Employee Additional Tax Details
- PR131 Retroactive Pay Calculation
- PR132 FLSA Overtime Calculation
- PR134 Automatic Time Records
- PR135 Time Record Edit
- PR136 Missing Time Records
- PR137 Batch Time Record Update
- PR189 Gross Up Calculation
- PR29.1 Pension Payment Maintenance
- PR30.2 Employee Automatic Time Record
- PR32.1 Employee Daily Time Entry
- PR32.2 Employee Daily Time Entry
- PR33.1 Speed Entry Setup
- PR33.2 Speed Entry by Number
- PR33.3 Speed Entry by Name
- PR35.1 Time Entry
- PR35.2 Detail Time Entry
- PR35.3 Speed Time Entry
- PR35.4 Step and Grade, Grade Range Time Entry
- PR35.5 Attendance Time Entry
- PR35.6 Activity Time Entry
- PR35.8 Position Time Entry
- PR35.9 Reason Code Time Entry
- PR36.1 Time Record Entry
- PR36.4 Manual Time Record Maintenance
- PR37.1 Batch Time Control
- PR45.1 Error Processing
- PR512 Employee ACH Distribution Interface
- PR521 Nonstandard Pay and Work Period CSV Load
- PR529 Pension Payroll Conversion
- PR530 Time Record Interface CSV
- PR560 Payroll History Load CSV
- PR582 Mass Adjustment Load
- PR80.1 Manual Check
- PR80.4 Manual Payment
- PR82.1 Adjustment
- TA147 Canada Vacation Audit
- UK102 Bonus Pay Update
- ZH510 Update PCP from ZPENDPCP
Referenced by (52)
- BN100 Employee Change Benefit Update
- BN101 Mass Benefit Add
- BN102 Plan Employee Update
- BN103 Mass Benefit Termination
- BN105 Plan Update
- BN145 Flex Dollars Calculation
- BN232 Benefits Statement
- BN242 One Page Benefits Statement
- BN245 Benefit Election Form
- BN31.1 Speed Benefit Entry
- BN31.2 Employee Benefit Entry
- BN32.1 Employee Benefit Changes
- BN32.2 Employee Benefit Detail Changes
- BN32.3 Benefit Add
- BN320 Premium Report
- BN45.1 Employee Flex Credits
- BN531 Batch Benefit Enrollment
- BN65.1 Election Simulation
- BN71.1 COBRA Benefit Entry
- BN72.1 Retiree Benefit Entry
- BS10.1 Web Enrollment Current Benefit Inquiry
- BS12.1 Web Enrollment Eligible New Plans
- BS13.1 Web Enrollment Coverage Options
- BS14.1 Web Enrollment Coverage Amounts
- BS15.1 Web Enrollment Contribution Limits
- BS32.1 Web Enrollment Stop Benefits Update
- HR105 Employee Audit Report
- HR170 Human Resource Writer Report Request
- HR521 Employee History Conversion
- HR70.1 Human Resource Writer Inquiry
- HR93.2 Pay Rate Audit Inquiry
- HRHI.1 History Retrieval Routine
- LP198 General Ledger Liability Update
- PA105 Employee Audit Report
- PA149 Update Scheduled Tests
- PA213 Position and Job Listing
- PA311 Employee Profile
- PA340 Action History Listing
- PA341 Hire and Term Listing
- PA355 Active Actions Report
- PA360 Wage Analysis Report
- PA370 Employee Review Document
- PA391 EEO-4 Report
- PA66.3 Employee Action Detail
- PA67.1 Pay Rate History
- PR282 Canada Record of Employment
- ZB10.1 Coverage Options Calculator
- ZB31.1 Speed Benefit Entry
- ZB31.2 Employee Benefit Entry
- ZB32.1 Employee Benefit Changes
- ZB32.2 Employee Benefit Detail Changes
- ZB32.3 Benefit Add