DEDGROUP – No description in the Lawson data dictionary

System: Payroll (PR)
Prefix: DDG
Primary key: COMPANY, COUNTRY-CODE, DED-GROUP, DED-CODE
Fields: 5
Updated by: 1 program
Referenced by: 10 programs

DEDGROUP is a Lawson Payroll table (prefix DDG); no description in the lawson data dictionary. It is indexed by COMPANY, COUNTRY-CODE, DED-GROUP, DED-CODE (DDGSET1); alternate indexes: DDGSET2. It is related 1:1 to PRSYSTEM, INSTCTRYCD and DEDCODE. It is updated by PR02.2 and referenced by PDDG.1, PR227, PR243, PR244, PR245, PR252, PR27.1, PR276 and 2 more. The table has 5 fields, 2 indexes and 3 documented relations.

About DEDGROUP

No description in the Lawson data dictionary.

Fields (5)

Column = COBOL field name without the DDG- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / column	Type	Description & values	Updated by
#`DDG-COMPANY` PK COMPANY	Numeric 4	—	PR02.2
#`DDG-COUNTRY-CODE` PK COUNTRY_CODE	Alpha 2	—	PR02.2
#`DDG-DED-GROUP` PK DED_GROUP	Alpha 10	The name of the Deduction Group	PR02.2, PR276
#`DDG-DESC` DESC	Alpha 30 (Lower Case)	The description of the Deduction Group	PR02.2
#`DDG-DED-CODE` PK DED_CODE	Alpha 4	Deduction codes connected to the deduction group	PR02.2, PR276

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`DDGSET1`	`COMPANY` `COUNTRY-CODE` `DED-GROUP` `DED-CODE`	Primary		PDDG.1, PR02.2, PR227, PR243, PR244, PR245, PR252, PR27.1 +3 more
`DDGSET2`	`COMPANY` `COUNTRY-CODE` `DED-CODE` `DED-GROUP`			—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)

One to one (3) — lookups and parents

Relation Table Rules Condition Field map

Company

PRSYSTEM

Required

`DDG-COMPANY`	→	`PRS-COMPANY (PRSSET1)`
`Spaces`	→	`PRS-PROCESS-LEVEL`

Country Code

INSTCTRYCD

Required

DDG-COUNTRY-CODE → INT-COUNTRY-CODE

Ded Code

DEDCODE

Required

`DDG-COMPANY`	→	`DDC-COMPANY`
`DDG-DED-CODE`	→	`DDC-DED-CODE`

Programs

Updated by (1)

PR02.2 Deduction Group

Referenced by (10)

PDDG.1 Deduction Class Selection Invoke
PR227 Year-End Parameter Report
PR243 Releve Slips
PR244 Releve Magnetic Media
PR245 Releve Reports
PR252 United States Territory W-2 Form Printing
PR27.1 Year-End Parameters
PR276 Employee Deduction Report
PR297 W-2 Forms
PR299 EFW2 File Creation

DEDGROUP – No description in the Lawson data dictionary

About DEDGROUP

Fields (5) Copy as SQL

Indexes (2)

Relations

One to one (3) — lookups and parents

Programs

Updated by (1)

Referenced by (10)

Fields (5)