DEDCODE FILE
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
AC541 AC542 BN100 BN101 BN102 BN103
BN104 BN105 BN145 BN150 BN20.1 BN215
BN245 BN31.1 BN31.2 BN32.1 BN32.2 BN32.3
BN335 BN340 BN45.1 BN500 BN531 BN65.1
BN66.1 BN71.1 BN72.1 BS13.1 BS14.1 BS15.1
BS32.1 HDDC.1 HR170 HR211 HR511 HR650
HR70.1 PA502 PA513 PR06.1 PR08.1 PR114
PR125 PR128 PR13.1 PR13.2 PR13.5 PR13.6
PR13.7 PR13.8 PR131 PR132 PR134 PR136
PR139 PR14.1 PR141 PR142 PR15.1 PR15.2
PR195 PR198 PR20.1 PR20.5 PR205 PR206
PR214 PR220 PR225 PR226 PR23.1 PR239
PR246 PR247 PR25.2 PR26.1 PR26.2 PR260
PR265 PR27.1 PR275 PR276 PR280 PR282
PR283 PR290 PR291 PR292 PR294 PR295
PR297 PR298 PR32.2 PR33.2 PR33.3 PR35.1
PR35.2 PR35.3 PR35.4 PR35.5 PR35.6 PR35.8
PR36.1 PR39.1 PR39.2 PR46.2 PR47.1 PR47.2
PR50.1 PR50.2 PR50.3 PR50.4 PR51.1 PR51.2
PR514 PR52.1 PR530 PR560 PR82.1 PR82.2
PR85.1 PR86.1 PR89.1 UK102 UK120 PR03.1
UPDATED BY
BN00.1 BN10.1 BN15.1 BN510 PR02.1 PR05.1
PR115 HR00.1 HR01.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DDC-COMPANY Numeric 4 BN10.1 BN510
Company The company number represents an PR05.1
established company and is entered on
all function codes.
DDC-DED-CODE Alpha 4 BN10.1 BN510
Deduction Contains user-defined deductions. PR05.1
DDC-DESCRIPTION Alpha 30 (Lower Case) BN10.1 BN510
Description Contains the deduction description. PR05.1 PR25.2
PR46.2
DDC-CHECK-DESC Alpha 8 (Lower Case) PR02.1 PR05.1
Payment Description 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.
DDC-CALC-TYPE Alpha 1 BN10.1 BN510
Calculation Type Contains the type of calculation PR05.1 PR25.2
defined for the deduction. The PR46.2
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
DDC-AMOUNT-PERC Signed 13.4 BN10.1 BN510
Amount or Percent Contains a value that represents either PR05.1
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.
DDC-TAX-STATUS Alpha 2 BN10.1 BN510
Tax Status Contains the value that determines how PR05.1
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
DDC-ADJUST-PAY Alpha 1 BN10.1 BN510
Adjust Pay Contains the value that determines how PR05.1
a deduction affects an employee's gross
pay.
A = Add to Net
S = Employee Paid
C = Company Paid
DDC-REQ-CODE Alpha 3 PR05.1
Required Code Contains the required code linked to
the deduction (Required Deduction Header
file record).
DDC-DED-CLASS Alpha 3 BN10.1 PR05.1
Deduction Class Contains the deduction class associated
with the deduction. The deduction class
is validated in the Deduction Class
file.
DDC-DED-PRIORITY Numeric 1 BN10.1 PR05.1
Deduction Priority 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
DDC-ARREARS Alpha 1 BN10.1 PR05.1
Arrears Indicator 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
DDC-EFFECT-DATE Numeric 8 (yyyymmdd) BN10.1 BN510
Effective Date Contains the effective date of the PR05.1
deduction.
DDC-END-DATE Numeric 8 (yyyymmdd) BN10.1 BN510
Ending Date Contains the ending date for taking the PR05.1
deduction.
DDC-ACR-DIST-CO Numeric 4 PR05.1 PR195
Acr Dist Co Contains the distribution company PR197 PR82.1
portion of the deduction accrual PR85.1
account.
DDC-ACR-ACCT-UNIT Alpha 15 PR05.1 PR195
Accrual Accounting Contains the accounting unit portion of PR197 PR82.1
Unit the deduction accrual account. When it PR85.1
is left blank, the system performs a
default to the process level, company,
then the employee record.
DDC-ACR-ACCOUNT Numeric 6 PR05.1 PR195
Accrual Account Contains the account portion of the PR197 PR82.1
Number deduction accrual account. PR85.1
DDC-ACR-SUB-ACCT Numeric 4 PR05.1 PR195
Accrual Subaccount Contains the subaccount portion of the PR197 PR82.1
Number deduction accrual account. PR85.1
DDC-EXP-DIST-CO Numeric 4 PR05.1 PR195
Exp Dist Co Contains the distribution company PR197 PR82.1
portion of the deduction expense account PR85.1
for company-paid deductions.
DDC-EXP-ACCT-UNIT Alpha 15 PR05.1 PR195
Expense Accounting Contains the accounting unit portion of PR197 PR82.1
Unit the deduction expense account for PR85.1
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.
DDC-EXP-ACCOUNT Numeric 6 PR05.1 PR195
Expense Account Contains the account portion of the PR197 PR82.1
deduction expense account for PR85.1
company-paid deductions.
DDC-EXP-SUB-ACCT Numeric 4 PR05.1 PR195
Expense Subaccount Contains the subaccount portion of the PR197 PR82.1
deduction expense account for PR85.1
company-paid deductions.
DDC-CHANGE-FLAG Alpha 1 PR02.1 PR05.1
Change Flag This field is set to Y (Yes) when a PR115
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
DDC-USED-FLAG Alpha 1 BN00.1 BN15.1
Used 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
DDC-MATCHED-DED Alpha 4 BN10.1 BN510
Matched Deduction Contains the employee-paid deduction on PR05.1
Code which the matching company-paid
deduction is calculated. Must be a valid
employee-paid deduction in the Deduction
file.
DDC-PAY-CLASS Alpha 3 BN10.1 BN510
Payment Class If the deduction is calculated on a PR05.1
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.
DDC-EXCLUDE-FLAG Alpha 1 PR05.1
Exclude From Contains the value that determines if
Disposable Income the deduction should be excluded from
the calculation of disposable income for
garnishment purposes.
Y = Yes
N = No
DDC-DED-CYCLE Alpha 1 Occurs 9 Times PR05.1
Deduction Cycle 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
DDC-MTD-WAGES-IND Alpha 1 PR05.1
MTD Wages Indicator Contains the value that indicates if a
monthly limit is defined for the
deduction.
Y = Yes
N = No
DDC-WC-TABLE-FLAG Alpha 1 PR05.1
Workers Comp Table Contains the value that indicates if
Flag the deduction amount is based on a
workers compensation premium table.
Y = Yes
N = No
DDC-TAX-CATEGORY Numeric 2 PR05.1
Tax Category Contains the tax category defined for
the deduction.
DDC-TAX-ID-CODE Alpha 10 PR05.1
Tax ID Code 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.
DDC-MONTHLY-LIMIT Signed 11.2 PR05.1
Monthly Limit Contains the deduction limit that can
be taken in a single month.
DDC-PAY-PRD-LIMIT Signed 11.2 PR05.1
Pay Period Limit Contains the deduction limit that can
be taken in a pay period.
DDC-PRINT-FLAG Alpha 1 BN10.1 BN510
Print Flag Contains the value that indicates if PR05.1
company-paid deductions print on the
payment.
Y = Yes
N = No
DDC-FORMULA-NUMBER Numeric 1 PR05.1
Formula Number 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.
DDC-PRIOR-SUI-WAGE Alpha 1 PR05.1
Prior SUI Wage 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
DDC-TAX-AUTH-TYPE Alpha 2 PR05.1
Tax Auth Type Contains the tax authority type.
FD = Federal
ST = State
CI = City
CN = County
SD = School District
TD = Transportation District
FD = Federal
DDC-ACTIVITY Alpha 15 PR05.1
Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
DDC-ACCT-CATEGORY Alpha 5 PR05.1
Account Category 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.
DDC-SELF-ADJ-TAX Alpha 1 PR05.1
Self Adj Tax Contains the value that determines if
the selected ceiling tax deduction self
adjusts each payroll cycle.
DDC-LINKED-DED Alpha 4 BN10.1 PR05.1
Linked Ded Contains the linked deduction to be
used for after tax deductions when the
federal limit is reached for the pretax
deduction.
DDC-UPDATE-AP Alpha 1 PR05.1
Update Ap Indicates whether invoice transactions
are created for PR199 (Payroll Close) is
run.
Y = Yes
N = No
DDC-VENDOR Alpha 9 (Right Justified) PR05.1
Vendor ID The vendor's identification code.
DDC-CREATE-BY-EMP Alpha 1 PR05.1
Create By Emp 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
DDC-AMOUNT-2 Signed 13.4 PR05.1
Amount 2 Used for the calculation type.
DDC-GARNISHMENT Alpha 1 PR05.1
Garnishment Used to select deductions, define the
invoice source for AP Interface, and for
performing edits.
Y = Yes
N = No
DDC-EDI Alpha 1
Edi
DDC-COUNTRY-CODE Alpha 2 PR05.1
Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
DDC-CLIENT-CREDIT Alpha 1 PR05.1
Client Credit
DDC-CYC1 Derived
Cyc1
DDC-CYC2 Derived
Cyc2
DDC-CYC3 Derived
Cyc3
DDC-CYC4 Derived
Cyc4
DDC-CYC5 Derived
Cyc5
DDC-CYC6 Derived
Cyc6
DDC-CYC7 Derived
Cyc7
DDC-CYC8 Derived
Cyc8
DDC-CYC9 Derived
Cyc9
DDC-ACR-DIST-CO-D Derived
Acr Dist Co D
DDC-EXP-DIST-CO-D Derived
Exp Dist Co D
DDC-CURRENCY-CODE Alpha 5 PR05.1
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
DDC-CURR-ND Numeric 1 PR05.1
Currency Number of Represents the number of decimals
Decimals defined for the currency of the object.
DDC-US-TAX-STATUS Derived
Us Tax Status
DDC-CA-BEN-TAX-STS Derived
Ca Ben Tax Sts
DDC-EDM-PROCESS Alpha 1 PR05.1
Edm Process " "
1 = Process once per pay period
DDC-OTD-PROCESS Alpha 1 PR05.1
Otd Process " "
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
DEDCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DDCSET1 COMPANY AC541 AC542
DED-CODE BN00.1 BN10.1
BN100 BN101
BN102 BN103
BN104 BN105
BN145 BN15.1
BN150 BN20.1
BN215 BN245
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN335
BN340 BN45.1
BN500 BN510
BN531 BN65.1
BN66.1 BN71.1
...
DDCSET2 COMPANY KeyChange HR00.1 HR01.1
DED-CLASS PR02.1 PR197
DED-CODE PR205 PR27.1
PR275
DDCSET3 COMPANY KeyChange, Subset HR511 PR03.1
REQ-CODE Where REQ-CODE != Spaces PR13.1 PR13.5
DED-CODE PR14.1 PR15.2
PR205
DDCSET5 COMPANY Subset PR115
DED-CODE Where CHANGE-FLAG = "Y"
DDCSET6 COMPANY KeyChange, Subset
TAX-AUTH-TYPE Where CALC-TYPE = "T"
TAX-CATEGORY
DED-CODE
DDCSET7 COMPANY KeyChange, Subset AC541 AC542
TAX-ID-CODE Where TAX-ID-CODE != Spaces BN150 HR511
TAX-CATEGORY And END-DATE = Zeroes HR650 PA502
FORMULA-NUMBER PA513 PR05.1
DED-CODE PR128 PR13.1
PR13.5 PR13.6
PR13.8 PR131
PR132 PR134
PR136 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR530 PR82.1
...
DEDCODE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accrual Acct GLMASTER Required
DDC-COMPANY -> GLM-COMPANY
DDC-ACR-ACCT-UNIT -> GLM-ACCT-UNIT
DDC-ACR-ACCOUNT -> GLM-ACCOUNT
DDC-ACR-SUB-ACCT -> GLM-SUB-ACCOUNT
Acct Category ACACCTCAT Required
When DDC-ACCT-CATEGORY != Spaces
DDC-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Activity ACACTIVITY Required
When DDC-ACTIVITY != Spaces
DDC-ACTIVITY -> ACV-ACTIVITY
Company PRSYSTEM Required
DDC-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Ded Class DCCLASS Required
When DDC-DED-CLASS != Spaces
DDC-COMPANY -> DCL-COMPANY
DDC-DED-CLASS -> DCL-DED-CLASS
Default Tax Id PRTAXID Required
DDC-TAX-ID-CODE -> PTI-TAX-ID-CODE
Zeroes -> PTI-COMPANY
Spaces -> PTI-PROCESS-LEVEL
Expense Acct GLMASTER Required
When DDC-EXP-ACCOUNT != Zeroes
Or DDC-EXP-ACCT-UNIT != Spaces
DDC-COMPANY -> GLM-COMPANY
DDC-EXP-ACCT-UNIT -> GLM-ACCT-UNIT
DDC-EXP-ACCOUNT -> GLM-ACCOUNT
DDC-EXP-SUB-ACCT -> GLM-SUB-ACCOUNT
Linked Ded DEDCODE Required
When DDC-LINKED-DED != Spaces
DDC-COMPANY -> DDC-COMPANY
DDC-LINKED-DED -> DDC-DED-CODE
Matched Ded DEDCODE Required
When DDC-MATCHED-DED != Spaces
DDC-COMPANY -> DDC-COMPANY
DDC-MATCHED-DED -> DDC-DED-CODE
Pay Class PAYCLASS Required
When DDC-PAY-CLASS != Spaces
DDC-COMPANY -> PCL-COMPANY
DDC-PAY-CLASS -> PCL-PAY-CLASS
Req Code REQCODE Required
When DDC-REQ-CODE != Spaces
DDC-COMPANY -> RQC-COMPANY
DDC-REQ-CODE -> RQC-REQ-CODE
Tax Category PRTAXCAT Not Required
Valid When DDC-TAX-CATEGORY != Zeroes
DDC-COUNTRY-CODE -> PXC-COUNTRY-CODE
DDC-ADJUST-PAY -> PXC-ADJUST-PAY
DDC-TAX-CATEGORY -> PXC-TAX-CATEGORY
Tax Id Code PRTAXAUTH Required
When DDC-CALC-TYPE = "T"
DDC-TAX-ID-CODE -> PRX-TAX-ID-CODE
Tax Province PRPROVINCE Not Required
PRX-TAX-PROVINCE -> PPV-PROVINCE
Tax State PRSTATE Not Required
Valid When DDC-TAX-STATE != Spaces
PRX-TAX-STATE -> PSA-STATE
DEDCODE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Emp Deductions EMDEDMASTR Delete Restricted
DDC-COMPANY -> EDM-COMPANY
DDC-DED-CODE -> EDM-DED-CODE
EDM-EMPLOYEE
EDM-SEQ-NBR
Tbl Exempt Ded TAXIDEXMP Delete Cascades
DDC-COMPANY -> TID-COMPANY
"D" -> TID-PAY-DED-FLAG
DDC-DED-CODE -> TID-PAY-CODE
TID-DED-CODE
|
