Pay Summary Groups

Contains pay summary group information. The system uses pay summary groups to represent a group of pay codes. All hours and wage amounts for a payment are stored by pay summary group in the Employee Payment Hours/Wages file. PR20.2 (Pay Summary Group) is the primary program that updates this file.

REFERENCED BY

BN150	HR170	HR70.1	PR521	EXI2.1	EXI4.1
LP130	PA495	PR127	PR128	PR130	PR131
PR132	PR134	PR135	PR136	PR137	PR139
PR141	PR160	PR180	PR188	PR197	PR227
PR250	PR251	PR252	PR253	PR260	PR261
PR262	PR27.1	PR27.2	PR270	PR271	PR29.1
PR295	PR297	PR299	PR32.1	PR32.2	PR33.1
PR33.2	PR33.3	PR35.1	PR35.2	PR35.3	PR35.4
PR35.5	PR35.6	PR35.8	PR35.9	PR36.1	PR37.1
PR45.1	PR51.1	PR52.1	PR529	PR530	PR560
PR582	PR82.1	PR84.1	PR85.1	PR86.1	UK102
UK141	UK50.3	UK50.4	UK560	ZP530	TA146
TA147	TA170	HPSG.1	PA82.1

UPDATED BY

BN66.1	HR00.1	HR01.1	PR115	PR140	PR189
PR195	PR20.2	PR20.8	PR220	PR80.1	PR80.4
PR89.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
PSG-COMPANY Element: Company Hr	Numeric 4	PR20.2
PSG-PAY-SUM-GRP Element: Pay Sum Grp	Alpha 3 Contains the user-defined pay summary group.	PR20.2
PSG-DESCRIPTION Element: Description	Alpha 30 (Lower Case) Contains the summary group description.	PR20.2
PSG-CHECK-DESC Element: Check Desc	Alpha 8 (Lower Case) Contains the pay summary group description that prints on the payment or pay receipt.	PR20.2
PSG-TIP-PAY-TYPE Element: Tip Pay Type	Numeric 1 Contains the tip pay type. The Tips system uses this field to distinguish between direct and indirect tips. 1 = Direct Tips 2 = Indirect Tips	PR20.2
PSG-ELIG-OT-PAY Element: Elig Ot Pay	Alpha 1 Contains the value that indicates if the pay associated with the pay summary group is eligible to be included in the calculation of the employee's regular rate. Y = Yes N = No	PR20.2
PSG-ELIG-OT-HRS Element: Elig Ot Hrs	Alpha 1 Contains the value that indicates if the hours associated with the pay summary group are eligible to be included in the calculation of the employee's regular rate. Y = Yes N = No	PR20.2
PSG-ELIG-PREM-PAY Element: Elig Prem Pay	Alpha 1 Contains the value that indicates if the premium portion of the pay associated with the pay summary group is eligible to be included in the calculation of the employee's regular rate of pay. Y = Yes N = No	PR20.2
PSG-ELIG-PREM-CRED Element: Elig Prem Cred	Alpha 1 Contains the value that indicates if the premium portion of pay associated with the pay summary group is eligible to be credited toward the total overtime due calculated by PR132 (FLSA Overtime Calculation). Y = Yes N = No	PR20.2
PSG-SUPP-TAX-CODE Element: Supp Tax Code	Alpha 2 Contains the value that indicates how the system calculates taxes on amounts associated with the pay summary group. E = U.S. Exempt M = U.S. Manual Override 1 = U.S. Flat Rate 2 = U.S. Separate Aggregation 3 = U.S. Rate Table 4 = U.S. Cumulative 5 = U.S. Aggreg With Pay Periods 6 = U.S. Wage Associated 8 = U.S. Regular Without Exemption 9 = U.S. System Selected 10 = U.S. Commission Cumulative C1 = Canada Regular Rate C2 = Canada Flat Rate C3 = Canada Concurrent C4 = Canada Bonus Retroactive C5 = Canada Wage Associated C6 = Canada System Selected CE = Canada Exempt CM = Canada Manual Override	PR20.2
PSG-CHANGE-FLAG Element: Change Flag	Alpha 1 Contains the value that indicates if changes have been made to the supplemental tax field.	PR115 PR20.2
PSG-COUNTRY-CODE Element: Country Code	Alpha 2 The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).	PR20.2
PSG-PAYMENT-TYPE Element: Payment Type	Alpha 2 C0 = Canada Regular C1 = Canada Supplemental C2 = Canada Commission	PR20.2
PSG-INCOME-TYPE Element: Income Type	Alpha 2 C0 = Canada Wage C1 = Canada Patronage C2 = Canada Lump Sum	PR20.2
PSG-REMUN-CODE Element: Remun Code	Alpha 4 C001 = Canada Regular E002 = US Pay Advances E003 = US Athletic Facilities E004 = US Non-Qual Plan Awrds and Prz E005 = US Back Pay E006 = US Bonuses E007 = US Business Expense E009 = US Gifts E010 = US Commissions E013 = US Discounts E014 = US Dismissal/Severance E015 = US Educational Assistance E016 = US Employment Agency E017 = US Qual Equip/Tool/Uniform E018 = US Business Use of Company Car E019 = US Personal Use of Company Car E020 = US No Additional Cost Services E021 = US Golden Parachute E022 = US Group Legal Services E023 = US Guaranteed Wage E024 = US Jury Duty Pay E025 = US Below Market Loans to Empl E026 = US Meals and Lodging E027 = US Supplemental Military Pay E028 = US Qualified Moving Expenses E029 = US Non-Cash Fringe E030 = US Outplacement Services E031 = US Overtime E032 = US Qualified Parking E033 = US Pre-employment Reimbursmnt E034 = US Probationary Pay E035 = US Regular Wages E036 = US Scholarships E037 = US Sick/Disability Pay E038 = US Standby/Idle Time E039 = US Stock Purch & Incentive Pln E040 = US Supper Money E041 = US Supplemental Unemployment E042 = US Taxes Paid by Employer E043 = US Tips E044 = US Travel; Exp Reimbursement E045 = US Tuition Reimbursement E046 = US Union Pay E047 = US Vacation Pay E048 = US Group Term Life G.T. 50000 E049 = US Ministers Housing Allowance E999 = US Custom Earnings E053 = HSA Self-Only E054 = HSA Family	PR20.2
PSG-TAX-FORM-TYPE Element: Tax Form Type	Numeric 1 0 = Non-U.S. 1 = W-2 2 = 1099-R 3 = 1099-DIV 4 = 1042-S 5 = 480.6	PR20.2
PSG-RPTABLE-1099R Element: Rptable 1099r	Numeric 2 00 = Non-US 01 = Oridinary income 02 = Capital gain 03 = Employee contributions 04 = Net unrealized appreciation 05 = Other	PR20.2

PAYSUMGRP FILE INDEX

PAYSUMGRP FILE RELATIONS

ONE TO ONE RELATIONS

PAYSUMGRP FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.