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 PR128 PR131
PR132 PR134 PR136 PR137 PR141 PR150
PR160 PR180 PR195 PR199 PR220 PR260
PR27.1 PR270 PR295 PR297 PR298 PR32.1
PR32.2 PR33.1 PR33.2 PR33.3 PR35.1 PR35.2
PR35.3 PR35.4 PR35.5 PR35.6 PR35.8 PR36.1
PR37.1 PR45.1 PR51.1 PR52.1 PR530 PR80.1
PR80.2 PR82.1 PR85.1 PR86.1 UK102 UK330
TA170 UK120 UK60.1 UK70.1
UPDATED BY
BN09.2 PR140 PR20.2 HR00.1 HR01.1 PBIP.1
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 = Exempt
M = Manual Override
1 = Flat Rate
2 = Separate Aggregation
3 = Rate Table
4 = Cumulative
5 = Aggregation With Pay Periods
6 = Wage Associated
8 = Regular Without Exemption
9 = System Selected
PSG-CHANGE-FLAG Alpha 1 BN09.2 PR140
Change Flag Contains the value that indicates if PR20.2
changes have been made to the
supplemental tax field.
PAYSUMGRP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PSGSET1 COMPANY BN09.2 BN150
PAY-SUM-GRP HPSG.1 HR00.1
HR01.1 HR170
HR70.1 PBIP.1
PR128 PR131
PR132 PR134
PR136 PR137
PR140 PR141
PR150 PR160
PR180 PR195
PR199 PR20.2
PR20.3 PR20.4
PR20.5 PR20.6
PR220 PR260
PR27.1 PR270
...
PSGSET2 COMPANY Subset PR140
PAY-SUM-GRP Where CHANGE-FLAG != Spaces
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
|