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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PRR-COMPANY PK
COMPANY		Numeric 4—HR14.1, HR514
#PRR-EMPLOYEE PK
EMPLOYEE		Numeric 9Employee 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 4An automatically assigned sequence number.HR14.1, HR514
#PRR-JOB-CODE SET2
JOB_CODE		Alpha 9Contains the user-defined job code.HR14.1, HR514
#PRR-PAY-CODE SET2
PAY_CODE		Alpha 4Contains 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.4Contains an alternate rate of pay for the employee.HR14.1, HR514
#PRR-EFFECT-DATE SET2
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 SET2
POSITION		Alpha 12Contains the user-defined code that represents a position in the company.HR14.1, HR514
#PRR-PROCESS-LEVEL SET2
PROCESS_LEVEL		Alpha 5—HR14.1, HR514
#PRR-DEPARTMENT SET2
DEPARTMENT		Alpha 5Contains the department.HR14.1, HR514
#PRR-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).HR14.1, HR514
#PRR-CURR-ND
CURR_ND		Numeric 1The 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 CreationHR14.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 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
PRRSET1
  1. COMPANY
  2. EMPLOYEE
  3. SEQ-NBR
PrimaryBN305, HR11.1, HR11.2, HR11.4, HR14.1, HR170, HR211, HR28.1 +22 more (list truncated in source)
PRRSET2
  1. COMPANY
  2. EMPLOYEE
  3. JOB-CODE
  4. POSITION
  5. PROCESS-LEVEL
  6. DEPARTMENT
  7. PAY-CODE
  8. EFFECT-DATE ↓
  9. SEQ-NBR
KeyChangeBN150, PR521, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +22 more (list truncated in source)

Relations

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

One to one (6) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
PRR-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
DepartmentDEPTCODERequiredWhen (PRR-DEPARTMENT != Spaces)
PRR-COMPANY→DPT-COMPANY
PRR-PROCESS-LEVEL→DPT-PROCESS-LEVEL
PRR-DEPARTMENT→DPT-DEPARTMENT
EmployeeEMPLOYEERequired
PRR-COMPANY→EMP-COMPANY
PRR-EMPLOYEE→EMP-EMPLOYEE
JobcodeJOBCODERequiredWhen PRR-JOB-CODE != Spaces
PRR-COMPANY→JBC-COMPANY
PRR-JOB-CODE→JBC-JOB-CODE
PaycodePRPAYCODERequiredWhen PRR-PAY-CODE != Spaces
PRR-COMPANY→PCD-COMPANY
PRR-PAY-CODE→PCD-PAY-CODE
Spaces→PCD-PROCESS-LEVEL
Spaces→PCD-JOB-CODE
Process LevelPRSYSTEMRequiredWhen (PRR-PROCESS-LEVEL != Spaces)
PRR-COMPANY→PRS-COMPANY
PRR-PROCESS-LEVEL→PRS-PROCESS-LEVEL

One to many (1) — child tables

RelationTableRulesConditionField map
PositionPAPOSITIONValid When (PRR-POSITION != Spaces)
PRR-COMPANY→POS-COMPANY
PRR-POSITION→POS-POSITION
—→POS-EFFECT-DATE

Programs

Updated by (4)

Referenced by (72)