Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             PRMINWAGE FILE

                              Minimum Wage

This file contains minimum wage information by tax authority. Minimum wage is
verified in the calculation of overtime.

REFERENCED BY

PR139     PR140     PR195     PR206     PR80.1    PR89.1
PR132

UPDATED BY

PR06.1    PR06.3

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PMW-TAX-ID-CODE      Alpha 10                                    PR06.3
Tax Id Code          Contains the tax authority.

PMW-EFFECT-DATE      Numeric 8  (yyyymmdd)                       PR06.3
Effective Date       Contains the effective date of the
                     minimum wage.

PMW-MINIMUM-WAGE     Signed 5.2                                  PR06.3
Minimum Wage         Contains the amount of the minimum wage.

PMW-TAX-STATE        Alpha 2                                     PR06.1  PR06.3
State Taxing         Contains the value that identifies the
Authority Code       state for which the minimum wage is
                     defined.

                         PRMINWAGE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PMWSET1   TAX-ID-CODE                                            PR06.1  PR06.3
          EFFECT-DATE*                                           PR139   PR140
                                                                 PR195   PR206
                                                                 PR80.1  PR89.1

PMWSET2   TAX-STATE     KeyChange                                PR132
          EFFECT-DATE*
          TAX-ID-CODE

                         PRMINWAGE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Tax Id Code    PRTAXAUTH    Required

                            PMW-TAX-ID-CODE    -> PRX-TAX-ID-CODE