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	BN66.1	HPSG.1	HR170	HR70.1	PR521
EXI2.1	EXI4.1	LP130	PA495	PA82.1	PR127
PR128	PR131	PR132	PR134	PR135	PR136
PR137	PR139	PR140	PR141	PR160	PR180
PR188	PR189	PR195	PR197	PR220	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	PR36.4
PR37.1	PR45.1	PR51.1	PR52.1	PR529	PR530
PR560	PR582	PR80.1	PR80.2	PR80.4	PR82.1
PR84.1	PR85.1	PR86.1	PR89.1	PRAT.1	UK102
TA147

UPDATED BY

PR115

PR20.2

HR00.1

HR01.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 L	Alpha 15 (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 C6 = Canada YTD Bonus Method 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 C5 = Canada Non-periodic Bonus	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 E051 = US Income Under Section 409A E052 = US Transportation CHV E055 = US Commuter Benefits E067 = US Tips Non-Taxable E068 = US Diff Pay - Active Mil Duty E070 = US EE Adult Child Hlth Ins E071 = US ER Adult Child Hlth Ins I001 = Basic I002 = HRA I003 = Conveyance I004 = Education I005 = LTA I006 = Gratuity I007 = Leave Salary I008 = Medical I009 = Othr Inc - OneTime Tax I099 = Allowances I010 = Perquisites I011 = Other Inc - Non Tax	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
PSG-PRINT-FLAG Element: Print Flag	Alpha 1 Y = Yes N = No

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.