Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              PRRATES FILE

                          Alternate Pay Rates

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.

REFERENCED BY

HR170     HR211     HR511     HR650     HR70.1    PA311
PA502     PA513     PR13.1    PR13.5    PR13.6    PR13.8
AC541     AC542     BN150     PR128     PR131     PR132
PR134     PR136     PR32.2    PR33.2    PR33.3    PR35.1
PR35.2    PR35.3    PR35.4    PR35.5    PR35.6    PR35.8
PR36.1    PR530     PR82.1    UK102     UK120

UPDATED BY

HR14.1    HR514

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PRR-COMPANY          Numeric 4                                   HR14.1  HR514
Company              The company number represents an
                     established company and is entered on
                     all function codes.

PRR-EMPLOYEE         Numeric 9                                   HR14.1  HR514
Employee             Employee number is assigned to each
                     person employed by the firm.  It is used
                     to correlate all of the information
                     related to that person.

PRR-SEQ-NBR          Numeric 4                                   HR14.1  HR514
Sequence Number      An automatically assigned sequence
                     number.

PRR-JOB-CODE         Alpha 9                                     HR14.1  HR514
Job Code             Contains the user-defined job code.

PRR-PAY-CODE         Alpha 4                                     HR14.1  HR514
Payment Code         Contains the pay code. A pay code is a
                     user-defined code that identifies a kind
                     of pay.

PRR-PAY-RATE         Signed 13.4                                 HR14.1  HR514
Rate of Pay          Contains an alternate rate of pay for
                     the employee.

PRR-EFFECT-DATE      Numeric 8  (yyyymmdd)                       HR14.1  HR514
Effective Date       Contains the effective date of the
                     alternate pay rate. The effective date
                     is compared to the time record date when
                     defaulting the alternate rate.

PRR-END-DATE         Numeric 8  (yyyymmdd)                       HR14.1  HR514
Ending Date          Contains the last date the alternate
                     rate is effective. The ending date is
                     compared to the time record date when
                     defaulting the alternate rate.

PRR-POSITION         Alpha 12                                    HR14.1  HR514
Position             Contains the user-defined code that
                     represents a position in the company.

PRR-PROCESS-LEVEL    Alpha 5                                     HR14.1  HR514
Process Level        This field contains the process level,
                     which is the reporting hierarchy below
                     company.

PRR-DEPARTMENT       Alpha 5                                     HR14.1  HR514
Department           Contains the department.

PRR-CURRENCY-CODE    Alpha 5                                     HR14.1  HR514
Currency Code        This field contains the company base
                     currency code established in Company
                     (GL10.1 ).

PRR-CURR-ND          Numeric 1                                   HR14.1  HR514
Currency Number of   Represents the number of decimals
Decimals             defined for the currency of the object.

                         PRRATES FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PRRSET1   COMPANY                                                HR14.1  HR170
          EMPLOYEE                                               HR211   HR511
          SEQ-NBR                                                HR514   HR650
                                                                 HR70.1  PA311
                                                                 PA502   PA513
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PRRSET2   COMPANY       KeyChange                                AC541   AC542
          EMPLOYEE                                               BN150   PR128
          JOB-CODE                                               PR131   PR132
          POSITION                                               PR134   PR136
          PROCESS-LEVEL                                          PR32.2  PR33.2
          DEPARTMENT                                             PR33.3  PR35.1
          PAY-CODE                                               PR35.2  PR35.3
          EFFECT-DATE*                                           PR35.4  PR35.5
          SEQ-NBR                                                PR35.6  PR35.8
                                                                 PR36.1  PR530
                                                                 PR82.1  UK102
                                                                 UK120

                         PRRATES FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

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

                         PRRATES FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Position       PAPOSITION
                            Valid When (PRR-POSITION != Spaces )

                            PRR-COMPANY          -> POS-COMPANY
                            PRR-POSITION         -> POS-POSITION
                                                    POS-EFFECT-DATE