|
|
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 HR11.1 HR11.2 HR170 HR211
HR511 HR650 HR70.1 PA02.1 PA100 PA102
PA13.1 PA13.2 PA502 PA513 PA52.1 PA52.3
PA52.4 PA52.5 PR06.1 PR08.1 PR110 PR113
PR114 PR120 PR125 PR127 PR128 PR13.1
PR13.2 PR13.5 PR13.6 PR13.7 PR13.8 PR130
PR131 PR132 PR134 PR136 PR139 PR14.1
PR140 PR141 PR142 PR15.1 PR15.2 PR160
PR180 PR189 PR195 PR198 PR20.1 PR20.5
PR205 PR214 PR220 PR225 PR226 PR227
PR23.1 PR239 PR240 PR241 PR242 PR243
PR244 PR245 PR246 PR247 PR248 PR25.2
PR250 PR251 PR252 PR253 PR26.1 PR26.2
PR260 PR27.1 PR275 PR276 PR280 PR282
PR283 PR29.1 PR290 PR291 PR292 PR294
PR295 PR297 PR298 PR299 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 PR418
PR45.1 PR46.2 PR47.1 PR47.2 PR50.1 PR50.2
PR50.3 PR50.4 PR51.1 PR51.2 PR51.3 PR514
PR52.1 PR529 PR530 PR560 PR80.1 PR80.2
PR80.3 PR82.1 PR82.2 PR82.3 PR85.1 PR86.1
PR89.1 UK102 UK13.1 UK141 UK145 UK183
UK184 UK201 UK202 UK46.2 UK47.1 UK47.2
UK50.1 UK50.2 UK50.3 UK50.5 UK560 TA147
UK120 PR03.1 PR206
UPDATED BY
BN00.1 BN10.1 BN15.1 BN510 PR02.1 PR05.1
PR115 HR00.1 HR01.1 PBIP.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DDC-COMPANY Numeric 4 BN10.1 BN510
Element: 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
Element: Deduction Contains user-defined deductions. PR05.1
DDC-DESCRIPTION Alpha 30 (Lower Case) BN10.1 BN510
Element: Description Contains the deduction description. PR05.1 PR25.2
PR46.2 UK46.2
DDC-CHECK-DESC Alpha 8 (Lower Case) PR02.1 PR05.1
Element: Payment DescriContains 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
Element: Calculation TyContains the type of calculation PR05.1 PR25.2
defined for the deduction. The PR46.2 UK46.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
Element: Amount or PercContains 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
Element: 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
Element: 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
Element: Required Code Contains the required code linked to
the deduction (Required Deduction Header
file record).
DDC-DED-CLASS Alpha 3 BN10.1 PR05.1
Element: Deduction ClasContains 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
Element: Deduction PrioContains 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
Element: Arrears IndicaContains 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
Element: Date Contains the effective date of the PR05.1
deduction.
DDC-END-DATE Numeric 8 (yyyymmdd) BN10.1 BN510
Element: Date Contains the ending date for taking the PR05.1
deduction.
DDC-ACR-DIST-CO Numeric 4 AC542 PR05.1
Element: Acr Dist Co Contains the distribution company PR195 PR197
portion of the deduction accrual PR82.1 PR85.1
account.
DDC-ACR-ACCT-UNIT Alpha 15 AC542 PR05.1
Accrual Accounting Contains the accounting unit portion of PR195 PR197
Unit the deduction accrual account. When it PR82.1 PR85.1
is left blank, the system performs a
default to the process level, company,
then the employee record.
DDC-ACR-ACCOUNT Numeric 6 AC542 PR05.1
Accrual Account Contains the account portion of the PR195 PR197
Number deduction accrual account. PR82.1 PR85.1
DDC-ACR-SUB-ACCT Numeric 4 AC542 PR05.1
Accrual Subaccount Contains the subaccount portion of the PR195 PR197
Number deduction accrual account. PR82.1 PR85.1
DDC-EXP-DIST-CO Numeric 4 AC542 PR05.1
Element: Exp Dist Co Contains the distribution company PR195 PR197
portion of the deduction expense account PR82.1 PR85.1
for company-paid deductions.
DDC-EXP-ACCT-UNIT Alpha 15 AC542 PR05.1
Expense Accounting Contains the accounting unit portion of PR195 PR197
Unit the deduction expense account for PR82.1 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 AC542 PR05.1
Element: Expense AccounContains the account portion of the PR195 PR197
deduction expense account for PR82.1 PR85.1
company-paid deductions.
DDC-EXP-SUB-ACCT Numeric 4 AC542 PR05.1
Element: Expense SubaccContains the subaccount portion of the PR195 PR197
deduction expense account for PR82.1 PR85.1
company-paid deductions.
DDC-CHANGE-FLAG Alpha 1 PR02.1 PR05.1
Element: 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
Element: 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
Element: 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
Element: Deduction CyclContains 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
Element: MTD Wages IndiContains 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
Element: Tax Category Contains the tax category defined for
the deduction.
DDC-TAX-ID-CODE Alpha 10 PR05.1
Element: 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
Element: Monthly Limit Contains the deduction limit that can
be taken in a single month.
DDC-PAY-PRD-LIMIT Signed 11.2 PR05.1
Element: Pay Period LimContains the deduction limit that can
be taken in a pay period.
DDC-PRINT-FLAG Alpha 1 BN10.1 BN510
Element: 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
Element: Formula NumberContains 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
Element: Prior SUI WageContains 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
Element: 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 AC542 PR05.1
Element: Activity Activities are the processes or PR195 PR197
procedures that produce work. Cost PR82.1 PR85.1
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
DDC-ACCT-CATEGORY Alpha 5 AC542 PR05.1
Element: Account CategoAccount categories are groupings of PR195 PR197
costs, revenues, or a combination of PR82.1 PR85.1
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
Element: 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
Element: 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
Element: 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
Element: Vendor ID The vendor's identification code.
DDC-CREATE-BY-EMP Alpha 1 PR05.1
Element: 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
Element: Amount 2 Used for the calculation type.
DDC-GARNISHMENT Alpha 1 PR05.1
Element: Garnishment Used to select deductions, define the
invoice source for AP Interface, and for
performing edits.
Y = Yes
N = No
DDC-EDI Alpha 1
Element: Edi
DDC-COUNTRY-CODE Alpha 2 PR05.1
Element: 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
Element: Client Credit
DDC-CYC1 Derived
Element: Cyc1
DDC-CYC2 Derived
Element: Cyc2
DDC-CYC3 Derived
Element: Cyc3
DDC-CYC4 Derived
Element: Cyc4
DDC-CYC5 Derived
Element: Cyc5
DDC-CYC6 Derived
Element: Cyc6
DDC-CYC7 Derived
Element: Cyc7
DDC-CYC8 Derived
Element: Cyc8
DDC-CYC9 Derived
Element: Cyc9
DDC-ACR-DIST-CO-D Derived
Element: Acr Dist Co D
DDC-EXP-DIST-CO-D Derived
Element: Exp Dist Co D
DDC-CURRENCY-CODE Alpha 5 PR05.1
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
DDC-CURR-ND Numeric 1 PR05.1
Account Currency
Code
DDC-US-TAX-STATUS Derived
Element: Us Tax Status
DDC-CA-BEN-TAX-STS Derived
Element: Ca Ben Tax Sts
DDC-EDM-PROCESS Alpha 1 PR05.1
Element: Edm Process " "
1 = Process once per pay period
DDC-OTD-PROCESS Alpha 1 PR05.1
Element: 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
DDC-ACCR-AU-FLAG Alpha 1
Element: Accr Au Flag 1 = Accrue to Pay Acct Unit
DDC-REMIT-TO-CODE Alpha 4 PR05.1
Purchase From
Location Code
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 PBIP.1 PR02.1
DED-CODE PR197 PR205
PR227 PR240
PR241 PR242
PR243 PR244
PR245 PR252
PR275 PR297
PR298 PR299
DDCSET3 COMPANY KeyChange, Subset HR11.1 HR511
REQ-CODE Where REQ-CODE != Spaces PA100 PA52.1
DED-CODE PA52.4 PA52.5
PR03.1 PR13.1
PR13.5 PR14.1
PR15.2 PR205
DDCSET5 COMPANY Subset PR115 PR140
DED-CODE Where CHANGE-FLAG = "Y" PR189 PR80.1
DDCSET6 COMPANY KeyChange, Subset PR206 UK145
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 HR11.1
TAX-CATEGORY And END-DATE = Zeroes HR11.2 HR511
FORMULA-NUMBER HR650 PA02.1
DED-CODE PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR05.1 PR110
PR113 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
...
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 PRX-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
Pl Accr Accts PRDEDACCTS Delete Cascades
DDC-COMPANY -> PDG-COMPANY
DDC-DED-CODE -> PDG-DED-CODE
"A" -> PDG-RECORD-TYPE
PDG-PROCESS-LEVEL
Pl Exp Accts PRDEDACCTS Delete Cascades
DDC-COMPANY -> PDG-COMPANY
DDC-DED-CODE -> PDG-DED-CODE
"E" -> PDG-RECORD-TYPE
PDG-PROCESS-LEVEL
Tbl Exempt Ded TAXIDEXMP Delete Cascades
DDC-COMPANY -> TID-COMPANY
"D" -> TID-PAY-DED-FLAG
DDC-DED-CODE -> TID-PAY-CODE
TID-DED-CODE
|
