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
|