DEDCODE – Deduction

System
Payroll (PR)
Prefix
DDC
Primary key
COMPANY, DED-CODE
Fields
82
Updated by
82 programs
Referenced by
136 programs

DEDCODE is the Deduction table in Lawson Payroll (prefix DDC). It is indexed by COMPANY, DED-CODE (DDCSET1); alternate indexes: DDCSET2, DDCSET3, DDCSET5, DDCSET6 and DDCSET7. It is related 1:1 to GLMASTER, ACACCTCAT, ACACTIVITY, PRSYSTEM, DCCLASS, PRTAXID, DEDCODE, PAYCLASS and 5 more and 1:M to EMDEDMASTR, PRDEDACCTS and TAXIDEXMP. It is updated by BN00.1, BN15.1, BN150, BN305, EXI2.1, EXI4.1, HR00.1, HR01.1 and 74 more and referenced by BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN20.1 and 128 more. The table has 82 fields, 6 indexes and 19 documented relations.

About DEDCODE

Contains information about deductions. The calculation type defined for the deduction determines how PR140 (Earnings and Deductions Calculation) calculates the deduction amount. For efficiency, the system also stores in the Employee Deduction file record, many of the fields in the Deduction file record. PR05.1 (Deduction) is the primary program that updates this file. The Benefits system creates a Deduction file record when a flex benefits plan uses a taxable amount code. The taxable amount deduction represents the company flex dollars that are added to an employee's pay.

Fields (82)

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

Field / columnTypeDescription & valuesUpdated by
DDC-COMPANY PK
COMPANY
Numeric 4PR05.1
DDC-DED-CODE PK
DED_CODE
Alpha 4Contains user-defined deductions.PR05.1
DDC-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)Contains the deduction description.PR05.1, PR25.2, PR46.2
DDC-CHECK-DESC
CHECK_DESC
Alpha 15 (Lower Case)Contains the description that prints on reports generated by PR140 (Earnings and Deductions Calculation), and on payment stubs or pay receipts if the deduction class associated with the deduction does not have a payment description assigned to it.PR02.1, PR05.1
DDC-CALC-TYPE
CALC_TYPE
Alpha 1Contains the type of calculation defined for the deduction. The calculation type determines how the system calculates the deduction.
  • E Pct of Emp Deduction
  • H Amount per Hour
  • N Pct of Disposable/Net Wages
  • P Percent
  • A Flat Amount
  • D Amount per Day
  • B Pct of Base Per Hour
  • 1 Flat Amt + % of Gross Pay
  • 2 Pct of Disp/Net W/Min Flat Amt
  • X Custom Calculation
  • T Tax
  • 7 Flat Amt + % Pay > Exclude Amt
PR05.1, PR25.2, PR46.2
DDC-AMOUNT-PERC
AMOUNT_PERC
Signed 13.4Contains a value that represents either an amount or a percent depending on the calculation type defined for the deduction. For calculation types A (Flat Amount), H (Amount Per Hour), or D (Amount Per Day), the system considers the value an amount. For calculation types E (Pct of Emp Ded), P (Percent), N (Pct of Disposable), or B (Pct of Base per Hour), the system considers the value a percent. Calculation type W (Withholding) deductions are based on tax tables, and no value is entered in the Amount or Percent field. The value of this field defaults to the Next Amount field in the Employee Deduction file.PR05.1
DDC-TAX-STATUS
TAX_STATUS
Alpha 2Contains the value that determines how taxable wages are affected by withholding deductions. " " = Taxable
  • E Exempt
  • X Exempt Table
  • 01 401(k)
  • 02 403(b)
  • 03 408(k) SEP
  • 04 457
  • 05 7701(j)
  • 06 Section 125
  • 07 Dental (Sec 125)
  • 08 Group Life (Sec 125)
  • 09 Health Ins (Sec 125)
  • 10 Dep Care/Separate (Sec 125)
  • 11 Dep Care/Married (Sec 125)
  • 12 New Jersey Cash Out
  • C1 RRSP
  • C2 RPP
  • C3 Provincial medicare premiums
  • C4 Employer provided hlth/dental
  • C5 Group life
  • C6 Union dues
  • C7 Court ordered alimony or maint
  • C8 Charitable donations
  • C9 Accidental Death and Dismember
  • Q1 CIP
  • Q2 CIP2
  • 16 401(k) Roth
  • 17 403(b) Roth
  • 20 HSA Self-Only (Sec 125)
  • 21 HSA Family (Sect 125)
  • 22 457(b)
  • 25 457(f)
PR05.1
DDC-ADJUST-PAY
ADJUST_PAY
Alpha 1Contains the value that determines how a deduction affects an employee's gross pay.
  • A Add to Net
  • S Employee Paid
  • C Company Paid
PR05.1
DDC-REQ-CODE
REQ_CODE
Alpha 3Contains the required code linked to the deduction (Required Deduction Header file record).PR05.1
DDC-DED-CLASS
DED_CLASS
Alpha 3Contains the deduction class associated with the deduction. The deduction class is validated in the Deduction Class file.PR05.1
DDC-DED-PRIORITY
DED_PRIORITY
Numeric 1Contains the value that determines the order in which deductions are taken within certain types of deductions. See the Payroll Procedures Manual for more information. 1 9PR05.1
DDC-ARREARS
ARREARS
Alpha 1Contains the value that determines whether the system takes all, nothing, or as much as possible if there is not sufficient funds to take the entire deduction,
  • A All Or None - Create Arrears
  • D All Or None - No Arrears
  • N Net To Zero - No Arrears
  • Y Net To Zero - Create Arrears
PR05.1
DDC-EFFECT-DATE
EFFECT_DATE
Numeric 8 (yyyymmdd)Contains the effective date of the deduction.PR05.1
DDC-END-DATE
END_DATE
Numeric 8 (yyyymmdd)Contains the ending date for taking the deduction.PR05.1
DDC-ACR-DIST-CO
ACR_DIST_CO
Numeric 4Contains the distribution company portion of the deduction accrual account.PR05.1, PR195, PR197, PR582, PR82.1, PR85.1
DDC-ACR-ACCT-UNIT
ACR_ACCT_UNIT
Alpha 15Contains the accounting unit portion of the deduction accrual account. When it is left blank, the system performs a default to the process level, company, then the employee record.PR05.1, PR195, PR197, PR582, PR82.1, PR85.1
DDC-ACR-ACCOUNT
ACR_ACCOUNT
Numeric 6Contains the account portion of the deduction accrual account.PR05.1, PR195, PR197, PR582, PR82.1, PR85.1
DDC-ACR-SUB-ACCT
ACR_SUB_ACCT
Numeric 4Contains the subaccount portion of the deduction accrual account.PR05.1, PR195, PR197, PR582, PR82.1, PR85.1
DDC-EXP-DIST-CO
EXP_DIST_CO
Numeric 4Contains the distribution company portion of the deduction expense account for company-paid deductions.PR05.1, PR195, PR197, PR582, PR82.1, PR85.1
DDC-EXP-ACCT-UNIT
EXP_ACCT_UNIT
Alpha 15Contains the accounting unit portion of the deduction expense account for company-paid deductions. When left blank, the company paid deduction expenses are allocated to the appropriate accounting unit, account and subaccount associated with the different types of pay that an employee receives.PR05.1, PR195, PR197, PR582, PR82.1, PR85.1
DDC-EXP-ACCOUNT
EXP_ACCOUNT
Numeric 6Contains the account portion of the deduction expense account for company-paid deductions.PR05.1, PR195, PR197, PR582, PR82.1, PR85.1
DDC-EXP-SUB-ACCT
EXP_SUB_ACCT
Numeric 4Contains the subaccount portion of the deduction expense account for company-paid deductions.PR05.1, PR195, PR197, PR582, PR82.1, PR85.1
DDC-CHANGE-FLAG
CHANGE_FLAG
Alpha 1This field is set to Y (Yes) when a deduction is changed in PR05.1 (Deduction). The next time you run PR140 (Earnings and Deductions Calculations), the system updates Employee Deduction file records that have not been overridden, to reflect the changes.
  • Y Yes
PR02.1, PR05.1, PR115
DDC-USED-FLAG
USED_FLAG
Alpha 1Contains the value that identifies if the deduction has been used. Once a deduction is assigned to a benefit plan, it cannot be assigned to another.
  • Y Yes
BN00.1, BN15.1
DDC-MATCHED-DED
MATCHED_DED
Alpha 4Contains the employee-paid deduction on which the matching company-paid deduction is calculated. Must be a valid employee-paid deduction in the Deduction file.PR05.1
DDC-PAY-CLASS
PAY_CLASS
Alpha 3If the deduction is calculated on a specific type of pay, this field contains the pay class that identifies the type of pay used to calculate the deduction. Must be valid in the Pay Class file.PR05.1
DDC-EXCLUDE-FLAG
EXCLUDE_FLAG
Alpha 1Contains the value that determines if the deduction should be excluded from the calculation of disposable income for garnishment purposes.
  • Y Yes
  • N No
PR05.1
DDC-DED-CYCLE
DED_CYCLE
Alpha 1 Occurs 9 Times ×9Contains the value that determines in which payroll cycles a withholding deduction is taken and taxable wages are updated, or taxable wages are updated but the deduction is not taken.
  • X Take Deduction
  • T Update Taxable Only
PR05.1
DDC-MTD-WAGES-IND
MTD_WAGES_IND
Alpha 1Contains the value that indicates if a monthly limit is defined for the deduction.
  • Y Yes(Month)
  • N No
  • Q Yes(Quarter)
  • A Yes(Annual)
PR05.1
DDC-WC-TABLE-FLAG
WC_TABLE_FLAG
Alpha 1Contains the value that indicates if the deduction amount is based on a workers compensation premium table.
  • Y Yes
  • N No
PR05.1
DDC-TAX-CATEGORY
TAX_CATEGORY
Numeric 2Contains the tax category defined for the deduction.PR05.1
DDC-TAX-ID-CODE
TAX_ID_CODE
Alpha 10Contains the tax authority defined for the deduction. The tax authority provides a link between the Payroll system and the BSI Software, Inc. tax tables.PR05.1
DDC-MONTHLY-LIMIT
MONTHLY_LIMIT
Signed 11.2Contains the deduction limit that can be taken in a single month.PR05.1
DDC-PAY-PRD-LIMIT
PAY_PRD_LIMIT
Signed 11.2Contains the deduction limit that can be taken in a pay period.PR05.1
DDC-PRINT-FLAG
PRINT_FLAG
Alpha 1Contains the value that indicates if company-paid deductions print on the payment.
  • Y Yes
  • N No
PR05.1
DDC-FORMULA-NUMBER
FORMULA_NUMBER
Numeric 4Contains the value (1-9) that indicates which tax formula the system uses to calculate the deduction. The values identify custom data defined for a tax in the BSI tax tables.PR05.1
DDC-PRIOR-SUI-WAGE
PRIOR_SUI_WAGE
Alpha 1Contains the value that indicates if the system uses prior states unemployment taxable wages in the calculation of taxable wages for the employee's current unemployment state.
  • Y Yes
  • N No
PR05.1
DDC-TAX-AUTH-TYPE
TAX_AUTH_TYPE
Alpha 2Contains the tax authority type.
  • FD Federal
  • ST State
  • CI City
  • CN County
  • SD School District
  • TD Transportation District
  • FD Federal
PR05.1
DDC-ACTIVITY
ACTIVITY
Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.PR05.1, PR195, PR197, PR582, PR82.1, PR85.1
DDC-ACCT-CATEGORY
ACCT_CATEGORY
Alpha 5Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thruPR05.1, PR195, PR197, PR582, PR82.1, PR85.1
DDC-SELF-ADJ-TAX
SELF_ADJ_TAX
Alpha 1Contains the value that determines if the selected ceiling tax deduction self adjusts each payroll cycle.
  • Y Self Adjust
  • Q Self Adjust Quarterly Formula
  • N Don't self adj except YTD tax
  • I Don't self adj; ignore YTD tax
PR05.1
DDC-LINKED-DED
LINKED_DED
Alpha 4Contains the linked deduction to be used for after tax deductions when the federal limit is reached for the pretax deduction.PR05.1
DDC-UPDATE-AP
UPDATE_AP
Alpha 1Indicates whether invoice transactions are created for PR199 (Payroll Close) is run.
  • Y Yes
  • N No
PR05.1
DDC-VENDOR
VENDOR
Alpha 9 (Right Justified)The vendor's identification code.PR05.1
DDC-CREATE-BY-EMP
CREATE_BY_EMP
Alpha 1Defines whether an invoice is created by employee or in summary for the deduction. If by employee an invoice number is unique for each employee. Invoices for garnishments would be created by employee. Invoices for taxes and benefits are usually created in summary. Created invoices by employee lets you create separate AP checks for each invoice and to print each invoice separately on the AP check stub.
  • Y Yes
  • N No
PR05.1
DDC-AMOUNT-2
AMOUNT_2
Signed 13.4Used for the calculation type.PR05.1
DDC-GARNISHMENT
GARNISHMENT
Alpha 1Used to select deductions, define the invoice source for AP Interface, and for performing edits.
  • Y Yes
  • N No
PR05.1
DDC-EDI
EDI
Alpha 1
DDC-COUNTRY-CODE
COUNTRY_CODE
Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).PR05.1
DDC-CLIENT-CREDIT
CLIENT_CREDIT
Alpha 1
DDC-CYC1
CYC1
Derived
DDC-CYC2
CYC2
Derived
DDC-CYC3
CYC3
Derived
DDC-CYC4
CYC4
Derived
DDC-CYC5
CYC5
Derived
DDC-CYC6
CYC6
Derived
DDC-CYC7
CYC7
Derived
DDC-CYC8
CYC8
Derived
DDC-CYC9
CYC9
Derived
DDC-ACR-DIST-CO-D
ACR_DIST_CO_D
Derived
DDC-EXP-DIST-CO-D
EXP_DIST_CO_D
Derived
DDC-CURRENCY-CODE
CURRENCY_CODE
Alpha 5This field contains the company base currency code established in Company (GL10.1 ).PR05.1
DDC-CURR-ND
CURR_ND
Numeric 1The number of decimals assigned to a particular account as determined by the account currency.PR05.1
DDC-US-TAX-STATUS
US_TAX_STATUS
Derived
DDC-CA-BEN-TAX-STS
CA_BEN_TAX_STS
Derived
DDC-EDM-PROCESS
EDM_PROCESS
Alpha 1" "
  • 1 Process once per pay period
PR05.1
DDC-OTD-PROCESS
OTD_PROCESS
Alpha 1" "
  • 0 Process None
  • 1 Process up to 1
  • 2 Process up to 2
  • 3 Process up to 3
  • 4 Process up to 4
  • 5 Process up to 5
  • 6 Process up to 6
  • 7 Process up to 7
  • 8 Process up to 8
  • 9 Process up to 9
PR05.1
DDC-ACCR-AU-FLAG
ACCR_AU_FLAG
Alpha 1
  • 1 Accrue to Pay Acct Unit
DDC-REMIT-TO-CODE
REMIT_TO_CODE
Alpha 4A user-defined code that represents a vendor's remittance address.PR05.1
DDC-EXCLUDE-AMT
EXCLUDE_AMT
Signed 13.4PR05.1
DDC-CREATE-DATE
CREATE_DATE
Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the creation of this record. Updated by PR05.PR05.1
DDC-CREATE-TIME
CREATE_TIME
Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was created. Updated by PR05.PR05.1
DDC-CREATE-USER-ID
CREATE_USER_ID
Alpha 10 (Lower Case)Contains the user ID of the person who created this record. Updated by PR05.PR05.1
DDC-DATE-STAMP
DATE_STAMP
Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record. Updated by PR05.PR02.1, PR05.1
DDC-TIME-STAMP
TIME_STAMP
Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed. Updated by PR05.PR02.1, PR05.1
DDC-USER-ID
USER_ID
Alpha 10 (Lower Case)Contains the user ID of the person who last changed this record. Updated by PR05.PR02.1, PR05.1
DDC-OVR-EXP-DED
OVR_EXP_DED
Alpha 1
  • 1 No
  • 2 Yes
PR05.1
DDC-POST-FLAG
POST_FLAG
Alpha 1
DDC-ADDL-TAX-CODE
ADDL_TAX_CODE
Numeric 2
  • 09 Substitute Lump Sum Tax
PR05.1
DDC-CLAIM-CODE-DFT
CLAIM_CODE_DFT
Alpha 3
  • A Engage BSI Claim Code Lookup
  • B Basic Personal Amount
PR05.1
DDC-JOIN-LEAVE-FLG
JOIN_LEAVE_FLG
Alpha 1
DDC-RECOV-FLAG
RECOV_FLAG
Alpha 1

Indexes (6)

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

IndexKeysFlagsConditionUsed in
DDCSET1COMPANY, DED-CODEPrimaryBN00.1, BN100, BN101, BN102, BN103, BN104, BN105, BN145 +22 more (list truncated in source)
DDCSET2COMPANY, DED-CLASS, DED-CODEKeyChangeHR00.1, HR01.1, PR02.1, PR205, PR227, PR240, PR241, PR242 +9 more
DDCSET3COMPANY, REQ-CODE, DED-CODEKeyChange, SubsetWhere REQ-CODE != SpacesHR11.1, HR511, LT101, LT111, PA100, PA52.1, PA52.4, PA52.5 +6 more
DDCSET5COMPANY, DED-CODESubsetWhere CHANGE-FLAG = "Y"PR115, PR140, PR189, PR80.1, PR80.4
DDCSET6COMPANY, TAX-AUTH-TYPE, TAX-CATEGORY, DED-CODEKeyChange, SubsetWhere CALC-TYPE = "T"PR11.3, PR287, PR292, PR297, PR299
DDCSET7COMPANY, TAX-ID-CODE, TAX-CATEGORY, FORMULA-NUMBER, DED-CODEKeyChange, SubsetWhere TAX-ID-CODE != Spaces And END-DATE = ZeroesBN150, BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 +22 more (list truncated in source)

Relations

One to one (15) — lookups and parents

RelationTableRulesConditionField map
Accrual AcctGLMASTERRequiredDDC-COMPANYGLM-COMPANY, DDC-ACR-ACCT-UNITGLM-ACCT-UNIT, DDC-ACR-ACCOUNTGLM-ACCOUNT, DDC-ACR-SUB-ACCTGLM-SUB-ACCOUNT
Acct CategoryACACCTCATRequiredWhen DDC-ACCT-CATEGORY != SpacesDDC-ACCT-CATEGORYAAX-ACCT-CATEGORY
ActivityACACTIVITYRequiredWhen DDC-ACTIVITY != SpacesDDC-ACTIVITYACV-ACTIVITY
CompanyPRSYSTEMRequiredDDC-COMPANYPRS-COMPANY, SpacesPRS-PROCESS-LEVEL
Ded ClassDCCLASSRequiredWhen DDC-DED-CLASS != SpacesDDC-COMPANYDCL-COMPANY, DDC-DED-CLASSDCL-DED-CLASS
Default Tax IdPRTAXIDRequiredDDC-TAX-ID-CODEPTI-TAX-ID-CODE, ZeroesPTI-COMPANY, SpacesPTI-PROCESS-LEVEL
Expense AcctGLMASTERRequiredWhen DDC-EXP-ACCOUNT != Zeroes Or DDC-EXP-ACCT-UNIT != SpacesDDC-COMPANYGLM-COMPANY, DDC-EXP-ACCT-UNITGLM-ACCT-UNIT, DDC-EXP-ACCOUNTGLM-ACCOUNT, DDC-EXP-SUB-ACCTGLM-SUB-ACCOUNT
Linked DedDEDCODERequiredWhen DDC-LINKED-DED != SpacesDDC-COMPANYDDC-COMPANY, DDC-LINKED-DEDDDC-DED-CODE
Matched DedDEDCODERequiredWhen DDC-MATCHED-DED != SpacesDDC-COMPANYDDC-COMPANY, DDC-MATCHED-DEDDDC-DED-CODE
Pay ClassPAYCLASSRequiredWhen DDC-PAY-CLASS != SpacesDDC-COMPANYPCL-COMPANY, DDC-PAY-CLASSPCL-PAY-CLASS
Req CodeREQCODERequiredWhen DDC-REQ-CODE != SpacesDDC-COMPANYRQC-COMPANY, DDC-REQ-CODERQC-REQ-CODE
Tax CategoryPRTAXCATNot RequiredValid When DDC-TAX-CATEGORY != ZeroesDDC-COUNTRY-CODEPXC-COUNTRY-CODE, DDC-ADJUST-PAYPXC-ADJUST-PAY, DDC-TAX-CATEGORYPXC-TAX-CATEGORY
Tax Id CodePRTAXAUTHRequiredWhen DDC-CALC-TYPE = "T"DDC-TAX-ID-CODEPRX-TAX-ID-CODE
Tax ProvincePRPROVINCENot RequiredPRX-TAX-PROVINCEPPV-PROVINCE
Tax StatePRSTATENot RequiredValid When PRX-TAX-STATE != SpacesPRX-TAX-STATEPSA-STATE

One to many (4) — child tables

RelationTableRulesConditionField map
Emp DeductionsEMDEDMASTRDelete RestrictedDDC-COMPANYEDM-COMPANY, DDC-DED-CODEEDM-DED-CODE, EDM-EMPLOYEE, EDM-SEQ-NBR
Pl Accr AcctsPRDEDACCTSDelete CascadesDDC-COMPANYPDG-COMPANY, DDC-DED-CODEPDG-DED-CODE, "A"PDG-RECORD-TYPE, PDG-PROCESS-LEVEL
Pl Exp AcctsPRDEDACCTSDelete CascadesDDC-COMPANYPDG-COMPANY, DDC-DED-CODEPDG-DED-CODE, "E"PDG-RECORD-TYPE, PDG-PROCESS-LEVEL
Tbl Exempt DedTAXIDEXMPDelete CascadesDDC-COMPANYTID-COMPANY, "D"TID-PAY-DED-FLAG, DDC-DED-CODETID-PAY-CODE, TID-DED-CODE

Programs

Updated by (82)

Referenced by (136)