Deduction

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.

REFERENCED BY

BN100	BN101	BN102	BN103	BN104	BN105
BN145	BN150	BN20.1	BN215	BN245	BN27.1
BN305	BN31.1	BN31.2	BN32.1	BN32.2	BN32.3
BN335	BN340	BN45.1	BN531	BN65.1	BN71.1
BN72.1	BN729	BN991	BS13.1	BS14.1	BS15.1
BS32.1	XB910	HR170	HR211	HR70.1	HR93.5
PR521	EXI2.1	EXI4.1	LP130	LP140	PA02.1
PA102	PA115	PA13.1	PA13.2	PA502	PA513
PR110	PR113	PR120	PR125	PR127	PR128
PR130	PR131	PR132	PR134	PR135	PR136
PR137	PR139	PR141	PR142	PR192	PR197
PR198	PR214	PR220	PR225	PR226	PR23.1
PR239	PR246	PR247	PR248	PR249	PR25.2
PR250	PR251	PR253	PR26.1	PR26.2	PR260
PR261	PR262	PR266	PR27.1	PR27.2	PR275
PR276	PR279	PR280	PR283	PR29.1	PR290
PR291	PR292	PR294	PR295	PR32.1	PR32.2
PR33.1	PR33.2	PR33.3	PR35.1	PR35.2	PR35.3
PR35.4	PR35.5	PR35.6	PR35.8	PR35.9	PR36.1
PR37.1	PR39.1	PR39.2	PR418	PR45.1	PR46.2
PR47.1	PR47.2	PR50.1	PR50.2	PR50.3	PR50.4
PR51.1	PR51.2	PR514	PR52.1	PR529	PR530
PR539	PR560	PR582	PR597	PR68.1	PR82.1
PR82.2	PR82.3	PR85.1	PR86.1	UK102	UK46.2
UK47.1	UK47.2	UK560	XR275	XR885	TA147

UPDATED BY

BN00.1	BN15.1	PR02.1	PR05.1	PR05.6	PR05.7
PR115	BN66.1	HDDC.1	HR00.1	HR01.1	HR11.1
HR511	PA100	PA52.1	PA52.4	PA52.5	PR06.1
PR08.1	PR11.3	PR114	PR13.1	PR13.5	PR14.1
PR140	PR15.2	PR160	PR180	PR189	PR195
PR20.1	PR205	PR227	PR240	PR241	PR242
PR243	PR244	PR245	PR252	PR282	PR297
PR299	PR80.1	PR80.2	PR80.4	PR89.1	UK13.1
UK141	UK145	UK183	UK184	UK201	UK202
UK50.2	UK50.3	PR274	PR03.1	PR206	PR287

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
DDC-COMPANY Element: Company Hr	Numeric 4	PR05.1
DDC-DED-CODE Element: Deduction	Alpha 4 Contains user-defined deductions.	PR05.1
DDC-DESCRIPTION Element: Description	Alpha 30 (Lower Case) Contains the deduction description.	PR05.1 PR25.2 PR46.2 UK46.2
DDC-CHECK-DESC Element: Check Desc	Alpha 8 (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 Element: Calc Type	Alpha 1 Contains 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/New 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 UK46.2
DDC-AMOUNT-PERC Element: Amount Perc	Signed 13.4 Contains 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 Element: Tax Status	Alpha 2 Contains the value that determines how taxable wages are affected by withholding deductions. 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) " " = Taxable 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)	PR05.1
DDC-ADJUST-PAY Element: Adjust Pay	Alpha 1 Contains 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 Element: Req Code	Alpha 3 Contains the required code linked to the deduction (Required Deduction Header file record).	PR05.1
DDC-DED-CLASS Element: Ded Class	Alpha 3 Contains the deduction class associated with the deduction. The deduction class is validated in the Deduction Class file.	PR05.1
DDC-DED-PRIORITY Element: Ded Priority	Numeric 1 Contains 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 9	PR05.1
DDC-ARREARS Element: Arrears	Alpha 1 Contains 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 Element: Effect Date	Numeric 8 (yyyymmdd) Contains the effective date of the deduction.	PR05.1
DDC-END-DATE Element: End Date	Numeric 8 (yyyymmdd) Contains the ending date for taking the deduction.	PR05.1
DDC-ACR-DIST-CO Element: Company	Numeric 4 Contains the distribution company portion of the deduction accrual account.	PR05.1 PR195 PR197 PR582 PR82.1 PR85.1
DDC-ACR-ACCT-UNIT Element: Acct Unit	Alpha 15 Contains 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 Element: Account	Numeric 6 Contains the account portion of the deduction accrual account.	PR05.1 PR195 PR197 PR582 PR82.1 PR85.1
DDC-ACR-SUB-ACCT Element: Sub Acct	Numeric 4 Contains the subaccount portion of the deduction accrual account.	PR05.1 PR195 PR197 PR582 PR82.1 PR85.1
DDC-EXP-DIST-CO Element: Company	Numeric 4 Contains 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 Expense Accounting Unit	Alpha 15 Contains 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 Element: Expense Account	Numeric 6 Contains 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 Element: Expense Subaccount	Numeric 4 Contains the subaccount portion of the deduction expense account for company-paid deductions.	PR05.1 PR195 PR197 PR582 PR82.1 PR85.1
DDC-CHANGE-FLAG Element: Change Flag	Alpha 1 This 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 Element: Used Flag	Alpha 1 Contains 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 Element: Matched Ded	Alpha 4 Contains 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 Element: Pay Class	Alpha 3 If 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 From Disposable Income	Alpha 1 Contains 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 Element: Ded Cycle	Alpha 1 Occurs 9 Times Contains 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 Element: MTD Wages Indicator	Alpha 1 Contains 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 Element: Wc Table Flag	Alpha 1 Contains 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 Element: Tax Category	Numeric 2 Contains the tax category defined for the deduction.	PR05.1
DDC-TAX-ID-CODE Element: Tax ID Code	Alpha 10 Contains 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 Element: Monthly Limit	Signed 11.2 Contains the deduction limit that can be taken in a single month.	PR05.1
DDC-PAY-PRD-LIMIT Element: Pay Period Limit	Signed 11.2 Contains the deduction limit that can be taken in a pay period.	PR05.1
DDC-PRINT-FLAG Element: Print Flag	Alpha 1 Contains the value that indicates if company-paid deductions print on the payment. Y = Yes N = No	PR05.1
DDC-FORMULA-NUMBER Element: Formula Number	Numeric 1 Contains 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 Element: Prior SUI Wage	Alpha 1 Contains 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 Element: Tax Auth Type	Alpha 2 Contains the tax authority type. FD = Federal ST = State CI = City CN = County SD = School District TD = Transportation District FD = Federal	PR05.1
DDC-ACTIVITY Element: Activity	Alpha 15 Activities 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 Element: Acct Category	Alpha 5 Account 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 thru	PR05.1 PR195 PR197 PR582 PR82.1 PR85.1
DDC-SELF-ADJ-TAX Element: Self Adj Tax	Alpha 1 Contains 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 Element: Linked Ded	Alpha 4 Contains 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 Element: Update Ap	Alpha 1 Indicates whether invoice transactions are created for PR199 (Payroll Close) is run. Y = Yes N = No	PR05.1
DDC-VENDOR Element: Vendor	Alpha 9 (Right Justified) The vendor's identification code.	PR05.1
DDC-CREATE-BY-EMP Element: Create By Emp	Alpha 1 Defines 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 Element: Amount 2	Signed 13.4 Used for the calculation type.	PR05.1
DDC-GARNISHMENT Element: Garnishment	Alpha 1 Used to select deductions, define the invoice source for AP Interface, and for performing edits. Y = Yes N = No	PR05.1
DDC-EDI Element: Edi	Alpha 1
DDC-COUNTRY-CODE Element: Country Code	Alpha 2 The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).	PR05.1
DDC-CLIENT-CREDIT Element: Client Credit	Alpha 1	PR05.1
DDC-CYC1 Element: Cyc1	Derived
DDC-CYC2 Element: Cyc2	Derived
DDC-CYC3 Element: Cyc3	Derived
DDC-CYC4 Element: Cyc4	Derived
DDC-CYC5 Element: Cyc5	Derived
DDC-CYC6 Element: Cyc6	Derived
DDC-CYC7 Element: Cyc7	Derived
DDC-CYC8 Element: Cyc8	Derived
DDC-CYC9 Element: Cyc9	Derived
DDC-ACR-DIST-CO-D Element: Acr Dist Co D	Derived
DDC-EXP-DIST-CO-D Element: Exp Dist Co D	Derived
DDC-CURRENCY-CODE Element: Currency Code	Alpha 5 This field contains the company base currency code established in Company (GL10.1 ).	PR05.1
DDC-CURR-ND Element: Acct Nd	Numeric 1 The number of decimals assigned to a particular account as determined by the account currency.	PR05.1
DDC-US-TAX-STATUS Element: Us Tax Status	Derived
DDC-CA-BEN-TAX-STS Element: Ca Ben Tax Sts	Derived
DDC-EDM-PROCESS Element: Edm Process	Alpha 1 " " 1 = Process once per pay period	PR05.1
DDC-OTD-PROCESS Element: 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 Element: Accr Au Flag	Alpha 1 1 = Accrue to Pay Acct Unit
DDC-REMIT-TO-CODE Element: Remit To Code	Alpha 4 A user-defined code that represents a vendor's remittance address.	PR05.1
DDC-EXCLUDE-AMT Element: Exclude Amt	Signed 13.4	PR05.1
DDC-CREATE-DATE Element: Date Stamp	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 Element: Time Stamp	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 Element: 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 Element: 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 Element: 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 Element: 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 Element: Ovr Exp Def	Alpha 1 Add field for PR197 processing of company paid deduction expenses. 1 = No 2 = Yes	PR05.1
DDC-POST-FLAG Element: Post Flag	Alpha 1

DEDCODE FILE INDEX

DEDCODE FILE RELATIONS

ONE TO ONE RELATIONS

DEDCODE FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.