PAYSUMGRP – Pay Summary Groups

System: Payroll (PR)
Prefix: PSG
Primary key: COMPANY, PAY-SUM-GRP
Fields: 18
Updated by: 4 programs
Referenced by: 79 programs

PAYSUMGRP is the Pay Summary Groups table in Lawson Payroll (prefix PSG). It is indexed by COMPANY, PAY-SUM-GRP (PSGSET1); alternate indexes: PSGSET2 and PSGSET3. It is related 1:1 to PRSYSTEM and 1:M to PSGRELATE, PRPAYCODE, PSGTAXES and TAXIDEXMP. It is updated by HR00.1, HR01.1, PR115 and PR20.2 and referenced by BN150, BN66.1, EXI2.1, EXI4.1, HPSG.1, HR170, HR70.1, LP130 and 71 more. The table has 18 fields, 3 indexes and 5 documented relations.

About PAYSUMGRP

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.

Fields (18)

Column = COBOL field name without the PSG- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`PSG-COMPANY` PK COMPANY	Numeric 4	—	PR20.2
`PSG-PAY-SUM-GRP` PK PAY_SUM_GRP	Alpha 3	Contains the user-defined pay summary group.	PR20.2
`PSG-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	Contains the summary group description.	PR20.2
`PSG-CHECK-DESC` CHECK_DESC	Alpha 15 (Lower Case)	Contains the pay summary group description that prints on the payment or pay receipt.	PR20.2
`PSG-TIP-PAY-TYPE` 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` 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` 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` 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` 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` 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` 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` 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` PAYMENT_TYPE	Alpha 2	— `C0` Canada Regular `C1` Canada Supplemental `C2` Canada Commission	PR20.2
`PSG-INCOME-TYPE` INCOME_TYPE	Alpha 2	— `C0` Canada Wage `C1` Canada Patronage `C2` Canada Lump Sum `C5` Canada Non-periodic Bonus	PR20.2
`PSG-REMUN-CODE` 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` 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` 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` PRINT_FLAG	Alpha 1	— `Y` Yes `N` No	—

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`PSGSET1`	`COMPANY`, `PAY-SUM-GRP`	Primary		BN150, BN66.1, HPSG.1, HR00.1, HR01.1, HR170, HR70.1, PR521 +22 more (list truncated in source)
`PSGSET2`	`COMPANY`, `PAY-SUM-GRP`	Subset	Where CHANGE-FLAG != Spaces	PR115, PR140, PR189
`PSGSET3`	`COMPANY`, `COUNTRY-CODE`, `PAY-SUM-GRP`			BN66.1, PR139, PR140, PR189, PR195, PR20.2, PR80.1, PR80.4 +2 more

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Company	PRSYSTEM	Required		`PSG-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`

One to many (4) — child tables

Relation	Table	Rules	Field map
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`

Programs

Updated by (4)

HR00.1 Company
HR01.1 Process Level
PR115 Deduction, Garnishment Fee, Pay Summary Grp Update
PR20.2 Pay Summary Group

Referenced by (79)

BN150 Life Insurance Reportable Income
BN66.1 Estimated Pay Calculation
EXI2.1 Invoke for PRTRDPD
EXI4.1 Invoke for PRPRBPD
HPSG.1 Pay Summary Group Selection Invoke
HR170 Human Resource Writer Report Request
HR70.1 Human Resource Writer Inquiry
LP130 Absence Plan Payout
PA495 IPEDS Report
PA82.1 Salary Encumbrance Inquiry
PR127 Year-End Parameters Copy/Delete
PR128 Offset Time Record Creation
PR131 Retroactive Pay Calculation
PR132 FLSA Overtime Calculation
PR134 Automatic Time Records
PR135 Time Record Edit
PR136 Missing Time Records
PR137 Batch Time Record Update
PR139 Arrears Automation
PR140 Earnings and Deductions Calculation
PR141 Payroll Register
PR160 Payment Print
PR180 Manual Payment Print
PR188 Payroll Hours Update
PR189 Gross Up Calculation
PR195 Accrual Program
PR197 Payroll Close
PR220 Pay Code Listing
PR227 Year-End Parameter Report
PR250 1099-R Form Reporting
PR251 1099-R File Creation
PR252 United States Territory W-2 Form Printing
PR253 1099-R Reporting
PR260 Payment Detail Listing
PR261 Payment Detail Listing By Report Entity
PR262 Taxable Wage CSV
PR27.1 Year-End Parameters
PR27.2 Tax Authority Year-End Parameters
PR270 Employee Wage Report
PR271 US Affordable Care Act
PR29.1 Pension Payment Maintenance
PR295 Distribution History Report
PR297 W-2 Forms
PR299 EFW2 File Creation
PR32.1 Employee Daily Time Entry
PR32.2 Employee Daily Time Entry
PR33.1 Speed Entry Setup
PR33.2 Speed Entry by Number
PR33.3 Speed Entry by Name
PR35.1 Time Entry
PR35.2 Detail Time Entry
PR35.3 Speed Time Entry
PR35.4 Step and Grade, Grade Range Time Entry
PR35.5 Attendance Time Entry
PR35.6 Activity Time Entry
PR35.8 Position Time Entry
PR35.9 Reason Code Time Entry
PR36.1 Time Record Entry
PR36.4 Manual Time Record Maintenance
PR37.1 Batch Time Control
PR45.1 Error Processing
PR51.1 Pay Stub Inquiry
PR52.1 Payroll History - Year To Date
PR521 Nonstandard Pay and Work Period CSV Load
PR529 Pension Payroll Conversion
PR530 Time Record Interface CSV
PR560 Payroll History Load CSV
PR582 Mass Adjustment Load
PR80.1 Manual Check
PR80.2 Manual Payment Print
PR80.4 Manual Payment
PR82.1 Adjustment
PR84.1 Seniority Recalculation Inquiry
PR85.1 Bank Account Reconciliation
PR86.1 Payment Replacement
PR89.1 Payment Modeling
PRAT.1 Alltax connection test
TA147 Canada Vacation Audit
UK102 Bonus Pay Update