PRRATES – Alternate Pay Rates

System: Payroll (PR)
Prefix: PRR
Primary key: COMPANY, EMPLOYEE, SEQ-NBR
Fields: 19
Updated by: 4 programs
Referenced by: 72 programs

PRRATES is the Alternate Pay Rates table in Lawson Payroll (prefix PRR). It is indexed by COMPANY, EMPLOYEE, SEQ-NBR (PRRSET1); alternate indexes: PRRSET2. It is related 1:1 to PRSYSTEM, DEPTCODE, EMPLOYEE, JOBCODE and PRPAYCODE and 1:M to PAPOSITION. It is updated by HR11.1, HR14.1, HR514 and PA115 and referenced by BN150, BN305, EXI2.1, EXI4.1, HR170, HR211, HR28.1, HR511 and 64 more. The table has 19 fields, 2 indexes and 7 documented relations.

About PRRATES

The Alternate Pay Rates file contains alternate pay rates for an employee. These can be defined by job code or pay code for an effective date range. When you enter time records for an hourly employee and you leave the rate field blank, the system takes the rate from this file if possible; otherwise, it defaults to the employee rate. At time record entry you can use the Select key to select rates in this file.

Fields (19)

Column = COBOL field name without the PRR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`PRR-COMPANY` PK COMPANY	Numeric 4	—	HR14.1, HR514
`PRR-EMPLOYEE` PK EMPLOYEE	Numeric 9	Employee number is assigned to each person employed by the firm. It is used to correlate all of the information related to that person.	HR14.1, HR514
`PRR-SEQ-NBR` PK SEQ_NBR	Numeric 4	An automatically assigned sequence number.	HR14.1, HR514
`PRR-JOB-CODE` JOB_CODE	Alpha 9	Contains the user-defined job code.	HR14.1, HR514
`PRR-PAY-CODE` PAY_CODE	Alpha 4	Contains the pay code. A pay code is a user-defined code that identifies a kind of pay.	HR14.1, HR514
`PRR-PAY-RATE` PAY_RATE	Signed 13.4	Contains an alternate rate of pay for the employee.	HR14.1, HR514
`PRR-EFFECT-DATE` EFFECT_DATE	Numeric 8 (yyyymmdd)	Contains the effective date of the alternate pay rate. The effective date is compared to the time record date when defaulting the alternate rate.	HR14.1, HR514
`PRR-END-DATE` END_DATE	Numeric 8 (yyyymmdd)	Contains the last date the alternate rate is effective. The ending date is compared to the time record date when defaulting the alternate rate.	HR14.1, HR514
`PRR-POSITION` POSITION	Alpha 12	Contains the user-defined code that represents a position in the company.	HR14.1, HR514
`PRR-PROCESS-LEVEL` PROCESS_LEVEL	Alpha 5	—	HR14.1, HR514
`PRR-DEPARTMENT` DEPARTMENT	Alpha 5	Contains the department.	HR14.1, HR514
`PRR-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the company base currency code established in Company (GL10.1 ).	HR14.1, HR514
`PRR-CURR-ND` CURR_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	HR14.1, HR514
`PRR-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	—	HR14.1, HR514
`PRR-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	Time of Creation	HR14.1, HR514
`PRR-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	User Id of record creator.	HR14.1, HR514
`PRR-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	—	HR14.1, HR514
`PRR-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	—	HR14.1, HR514
`PRR-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	HR14.1, HR514

Indexes (2)

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
`PRRSET1`	`COMPANY`, `EMPLOYEE`, `SEQ-NBR`	Primary		BN305, HR11.1, HR11.2, HR11.4, HR14.1, HR170, HR211, HR28.1 +22 more (list truncated in source)
`PRRSET2`	`COMPANY`, `EMPLOYEE`, `JOB-CODE`, `POSITION`, `PROCESS-LEVEL`, `DEPARTMENT`, `PAY-CODE`, `EFFECT-DATE*`, `SEQ-NBR`	KeyChange		BN150, PR521, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +22 more (list truncated in source)

Relations

One to one (6) — lookups and parents

Relation	Table	Rules	Condition	Field map
Company	PRSYSTEM	Required		`PRR-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Department	DEPTCODE	Required	When (PRR-DEPARTMENT != Spaces)	`PRR-COMPANY` → `DPT-COMPANY`, `PRR-PROCESS-LEVEL` → `DPT-PROCESS-LEVEL`, `PRR-DEPARTMENT` → `DPT-DEPARTMENT`
Employee	EMPLOYEE	Required		`PRR-COMPANY` → `EMP-COMPANY`, `PRR-EMPLOYEE` → `EMP-EMPLOYEE`
Jobcode	JOBCODE	Required	When PRR-JOB-CODE != Spaces	`PRR-COMPANY` → `JBC-COMPANY`, `PRR-JOB-CODE` → `JBC-JOB-CODE`
Paycode	PRPAYCODE	Required	When PRR-PAY-CODE != Spaces	`PRR-COMPANY` → `PCD-COMPANY`, `PRR-PAY-CODE` → `PCD-PAY-CODE`, `Spaces` → `PCD-PROCESS-LEVEL`, `Spaces` → `PCD-JOB-CODE`
Process Level	PRSYSTEM	Required	When (PRR-PROCESS-LEVEL != Spaces)	`PRR-COMPANY` → `PRS-COMPANY`, `PRR-PROCESS-LEVEL` → `PRS-PROCESS-LEVEL`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Position	PAPOSITION		Valid When (PRR-POSITION != Spaces)	`PRR-COMPANY` → `POS-COMPANY`, `PRR-POSITION` → `POS-POSITION`, → `POS-EFFECT-DATE`

Programs

Updated by (4)

HR11.1 Employee
HR14.1 Alternate Pay Rates
HR514 Alternate Rates Conversion
PA115 Employee Purge

Referenced by (72)

BN150 Life Insurance Reportable Income
BN305 Highly Compensated Employees
EXI2.1 Invoke for PRTRDPD
EXI4.1 Invoke for PRPRBPD
HR170 Human Resource Writer Report Request
HR211 Employee Listing
HR28.1 Employee Ethnicity
HR511 Employee Conversion
HR70.1 Human Resource Writer Inquiry
LP130 Absence Plan Payout
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA02.1 Position
PA100 Action Update
PA102 Position Update
PA13.1 Multiple Positions and Jobs
PA13.2 Multiple Position and Job History
PA311 Employee Profile
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
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