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
AC541 AC542 BN150 HPSG.1 HR170 HR70.1
PR128 PR131 PR132 PR134 PR136 PR141
PR195 PR220 PR260 PR27.1 PR270 PR295
PR297 PR298 PR32.2 PR33.2 PR33.3 PR35.1
PR35.2 PR35.3 PR35.4 PR35.5 PR35.6 PR35.8
PR36.1 PR51.1 PR52.1 PR530 PR560 PR82.1
PR85.1 PR86.1 UK102 TA170 UK120 UK60.1
UK70.1
UPDATED BY
BN09.2 PR115 PR20.2 HR00.1 HR01.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PSG-COMPANY Numeric 4 BN09.2 PR20.2
Company The company number represents an
established company and is entered on
all function codes.
PSG-PAY-SUM-GRP Alpha 3 BN09.2 PR20.2
Payment Summary Contains the user-defined pay summary
Group group.
PSG-DESCRIPTION Alpha 30 (Lower Case) BN09.2 PR20.2
Description Contains the summary group description.
PSG-CHECK-DESC Alpha 8 (Lower Case) BN09.2 PR20.2
Payment Description Contains the pay summary group
description that prints on the payment
or pay receipt.
PSG-TIP-PAY-TYPE Numeric 1 BN09.2 PR20.2
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 BN09.2 PR20.2
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 BN09.2 PR20.2
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 BN09.2 PR20.2
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 BN09.2 PR20.2
Elig Prem Cred 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
PSG-SUPP-TAX-CODE Alpha 2 BN09.2 PR20.2
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
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 BN09.2 PR115
Change Flag Contains the value that indicates if PR20.2
changes have been made to the
supplemental tax field.
PSG-COUNTRY-CODE Alpha 2 PR20.2
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
Payment Type C0 = Canada Regular
C1 = Canada Supplemental
C2 = Canada Commission
PSG-INCOME-TYPE Alpha 2 PR20.2
Income Type C0 = Canada Wage
C1 = Canada Patronage
C2 = Canada Lump Sum
PSG-REMUN-CODE Alpha 4 PR20.2
Remun Code C001 = Canada Bonus
PSG-TAX-FORM-TYPE Numeric 1 PR20.2
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
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 AC541 AC542
PAY-SUM-GRP BN09.2 BN150
HPSG.1 HR00.1
HR01.1 HR170
HR70.1 PR128
PR131 PR132
PR134 PR136
PR141 PR195
PR197 PR20.2
PR20.3 PR20.4
PR20.5 PR20.6
PR220 PR260
PR27.1 PR270
PR295 PR297
PR298 PR32.2
...
PSGSET2 COMPANY Subset PR115
PAY-SUM-GRP Where CHANGE-FLAG != Spaces
PSGSET3 COMPANY PR20.2
COUNTRY-CODE
PAY-SUM-GRP
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
|
