PAYSUMGRP FILE
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 ET530 ETI2.1 HPSG.1 HR170
HR70.1 LP130 PA495 PA82.1 PR127 PR128
PR130 PR131 PR132 PR134 PR136 PR139
PR140 PR141 PR160 PR180 PR188 PR189
PR195 PR197 PR220 PR227 PR252 PR260
PR261 PR262 PR27.1 PR27.2 PR270 PR29.1
PR295 PR297 PR299 PR32.2 PR33.2 PR33.3
PR35.1 PR35.2 PR35.3 PR35.4 PR35.5 PR35.6
PR35.8 PR35.9 PR36.1 PR45.1 PR51.1 PR51.3
PR52.1 PR529 PR530 PR560 PR80.1 PR80.2
PR82.1 PR84.1 PR85.1 PR86.1 PR89.1 UK102
UK141 UK50.3 UK50.4 UK560 TA146 TA147
TA170
UPDATED BY
PR115 PR20.2 HR00.1 HR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PSG-COMPANY Numeric 4 PR20.2
Element: Company Hr
PSG-PAY-SUM-GRP Alpha 3 PR20.2
Element: Pay Sum Grp Contains the user-defined pay summary
group.
PSG-DESCRIPTION Alpha 30 (Lower Case) PR20.2
Element: Description Contains the summary group description.
PSG-CHECK-DESC Alpha 8 (Lower Case) PR20.2
Element: Check Desc Contains the pay summary group
description that prints on the payment
or pay receipt.
PSG-TIP-PAY-TYPE Numeric 1 PR20.2
Element: Tip Pay Type Contains the tip pay type. The Tips
system uses this field to distinguish
between direct and indirect tips.
1 = Direct Tips
2 = Indirect Tips
PSG-ELIG-OT-PAY Alpha 1 PR20.2
Element: Elig Ot Pay 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
PSG-ELIG-OT-HRS Alpha 1 PR20.2
Element: Elig Ot Hrs 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
PSG-ELIG-PREM-PAY Alpha 1 PR20.2
Element: Elig Prem Pay 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
PSG-ELIG-PREM-CRED Alpha 1 PR20.2
Element: Elig Prem CredContains 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
PSG-SUPP-TAX-CODE Alpha 2 PR20.2
Element: Supp Tax Code 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
PSG-CHANGE-FLAG Alpha 1 PR115 PR20.2
Element: Change Flag Contains the value that indicates if
changes have been made to the
supplemental tax field.
PSG-COUNTRY-CODE Alpha 2 PR20.2
Element: Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
PSG-PAYMENT-TYPE Alpha 2 PR20.2
Element: Payment Type C0 = Canada Regular
C1 = Canada Supplemental
C2 = Canada Commission
PSG-INCOME-TYPE Alpha 2 PR20.2
Element: Income Type C0 = Canada Wage
C1 = Canada Patronage
C2 = Canada Lump Sum
PSG-REMUN-CODE Alpha 4 PR20.2
Element: Remun Code 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
PSG-TAX-FORM-TYPE Numeric 1 PR20.2
Element: Tax Form Type 0 = Non-U.S.
1 = W-2
2 = 1099-R
3 = 1099-DIV
4 = 1042-S
5 = 480.6
PSG-RPTABLE-1099R Numeric 2 PR20.2
Element: Rptable 1099r 00 = Non-US
01 = Oridinary income
02 = Capital gain
03 = Employee contributions
04 = Net unrealized appreciation
05 = Other
PAYSUMGRP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PSGSET1 COMPANY BN150 BN66.1
PAY-SUM-GRP ET530 ETI2.1
HPSG.1 HR00.1
HR01.1 HR170
HR70.1 LP130
PA495 PA82.1
PR127 PR128
PR130 PR131
PR132 PR134
PR136 PR139
PR140 PR141
PR160 PR180
PR188 PR189
PR195 PR197
PR20.2 PR20.3
...
PSGSET2 COMPANY Subset PR115 PR140
PAY-SUM-GRP Where CHANGE-FLAG != Spaces PR189
PSGSET3 COMPANY BN66.1 PR139
COUNTRY-CODE PR140 PR189
PAY-SUM-GRP PR195 PR20.2
PR80.1 PR89.1
PAYSUMGRP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PSG-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
PAYSUMGRP FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Pay Classes PSGRELATE Delete Restricted
PSG-COMPANY -> PSR-COMPANY
PSG-PAY-SUM-GRP -> PSR-PAY-SUM-GRP
PSR-PAY-CLASS
Pay Codes PRPAYCODE Delete Restricted
PSG-COMPANY -> PCD-COMPANY
PSG-PAY-SUM-GRP -> PCD-PAY-SUM-GRP
PCD-PAY-CODE
PCD-PROCESS-LEVEL
PCD-JOB-CODE
Psg Taxes PSGTAXES Delete Cascades
PSG-COMPANY -> PTX-COMPANY
PSG-PAY-SUM-GRP -> PTX-PAY-SUM-GRP
PTX-TAX-AUTH-TYPE
Taxidexmp TAXIDEXMP Delete Cascades
PSG-COMPANY -> TID-COMPANY
"P" -> TID-PAY-DED-FLAG
PSG-PAY-SUM-GRP -> TID-PAY-CODE
TID-DED-CODE
|
