|
|
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 HPSG.1 HR170 HR70.1 PA495 PA82.1
PR127 PR128 PR130 PR131 PR132 PR134
PR136 PR141 PR160 PR180 PR188 PR220
PR227 PR252 PR260 PR27.1 PR270 PR29.1
PR295 PR297 PR298 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 PR82.1
PR84.1 PR85.1 PR86.1 UK102 UK141 UK50.3
UK50.4 TA146 TA147 TA170 TP130 TP135
TP140 TP30.1 TP30.2
UPDATED BY
PR115 PR20.2 HR00.1 HR01.1 PBIP.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PSG-COMPANY Numeric 4 PR20.2
Element: Company Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
PSG-PAY-SUM-GRP Alpha 3 PR20.2
Payment Summary Contains the user-defined pay summary
Group 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: Payment DescriContains 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
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 Bonus
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 HPSG.1
PAY-SUM-GRP HR00.1 HR01.1
HR170 HR70.1
PA495 PA82.1
PBIP.1 PR127
PR128 PR130
PR131 PR132
PR134 PR136
PR141 PR160
PR180 PR188
PR197 PR20.2
PR20.3 PR20.4
PR20.5 PR20.6
PR220 PR227
PR252 PR260
...
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
|
