|
|
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
BN100 BN101 BN102 BN103 BN104 BN105
BN145 BN150 BN20.1 BN215 BN245 BN305
BN31.1 BN31.2 BN32.1 BN32.2 BN32.3 BN335
BN340 BN45.1 BN531 BN65.1 BN66.1 BN71.1
BN72.1 BS13.1 BS14.1 BS15.1 BS32.1 ET530
ET700 ETI1.1 ETI2.1 HDDC.1 HR11.1 HR11.2
HR170 HR211 HR511 HR70.1 LP130 PA02.1
PA100 PA102 PA115 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 PR14.2 PR140 PR141
PR142 PR15.1 PR15.2 PR160 PR180 PR189
PR195 PR197 PR198 PR20.1 PR20.5 PR205
PR214 PR220 PR225 PR226 PR227 PR23.1
PR239 PR240 PR241 PR242 PR243 PR244
PR245 PR246 PR247 PR248 PR249 PR25.2
PR250 PR251 PR252 PR253 PR26.1 PR26.2
PR260 PR261 PR262 PR266 PR27.1 PR27.2
PR275 PR276 PR279 PR280 PR282 PR283
PR29.1 PR290 PR291 PR292 PR294 PR295
PR297 PR299 PR32.2 PR33.2 PR33.3 PR35.1
PR35.2 PR35.3 PR35.4 PR35.5 PR35.6 PR35.8
PR35.9 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 PR539 PR560 PR68.1 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 PR274 PR03.1 PR206 PR287
UPDATED BY
BN00.1 BN15.1 PR02.1 PR05.1 PR115 HR00.1
HR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DDC-COMPANY Numeric 4 PR05.1
Element: Company Hr
DDC-DED-CODE Alpha 4 PR05.1
Element: Deduction Contains user-defined deductions.
DDC-DESCRIPTION Alpha 30 (Lower Case) PR05.1 PR25.2
Element: Description Contains the deduction description. PR46.2 UK46.2
DDC-CHECK-DESC Alpha 8 (Lower Case) PR02.1 PR05.1
Element: Check Desc 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 PR05.1 PR25.2
Element: Calc Type Contains the type of calculation PR46.2 UK46.2
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
DDC-AMOUNT-PERC Signed 13.4 PR05.1
Element: Amount Perc 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.
DDC-TAX-STATUS Alpha 2 PR05.1
Element: Tax Status 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
DDC-ADJUST-PAY Alpha 1 PR05.1
Element: Adjust Pay Contains the value that determines how
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: Req Code Contains the required code linked to
the deduction (Required Deduction Header
file record).
DDC-DED-CLASS Alpha 3 PR05.1
Element: Ded Class Contains the deduction class associated
with the deduction. The deduction class
is validated in the Deduction Class
file.
DDC-DED-PRIORITY Numeric 1 PR05.1
Element: Ded 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 PR05.1
Element: Arrears 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) PR05.1
Element: Effect Date Contains the effective date of the
deduction.
DDC-END-DATE Numeric 8 (yyyymmdd) PR05.1
Element: End Date Contains the ending date for taking the
deduction.
DDC-ACR-DIST-CO Numeric 4 ET530 PR05.1
Element: Company Contains the distribution company PR195 PR197
portion of the deduction accrual PR82.1 PR85.1
account.
DDC-ACR-ACCT-UNIT Alpha 15 ET530 PR05.1
Element: Acct Unit Contains the accounting unit portion of PR195 PR197
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 ET530 PR05.1
Element: Account Contains the account portion of the PR195 PR197
deduction accrual account. PR82.1 PR85.1
DDC-ACR-SUB-ACCT Numeric 4 ET530 PR05.1
Element: Sub Acct Contains the subaccount portion of the PR195 PR197
deduction accrual account. PR82.1 PR85.1
DDC-EXP-DIST-CO Numeric 4 ET530 PR05.1
Element: Company 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 ET530 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 ET530 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 ET530 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 Flag 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 PR05.1
Element: Matched Ded 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.
DDC-PAY-CLASS Alpha 3 PR05.1
Element: Pay Class 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.
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: Ded 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
Element: MTD Wages IndiContains the value that indicates if a
monthly limit is defined for the
deduction.
Y = Yes(Month)
N = No
Q = Yes(Quarter)
A = Yes(Annual)
DDC-WC-TABLE-FLAG Alpha 1 PR05.1
Element: Wc Table Flag Contains the value that indicates if
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 PR05.1
Element: Print Flag Contains the value that indicates if
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 ET530 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 ET530 PR05.1
Element: Acct Category Account 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.
Valid account category types are:
cost
revenue
accrual
pass thru
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.
Y = Self Adjust
Q = Self Adjust Quarterly Formula
N = Don't self adj except YTD tax
I = Don't self adj; ignore YTD tax
DDC-LINKED-DED Alpha 4 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 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
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
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
Element: Remit To Code A user-defined code that represents a
vendor's remittance address.
DDC-EXCLUDE-AMT Signed 13.4 PR05.1
Element: Exclude Amt
DEDCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DDCSET1 COMPANY BN00.1 BN100
DED-CODE BN101 BN102
BN103 BN104
BN105 BN145
BN15.1 BN150
BN20.1 BN215
BN245 BN305
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN335
BN340 BN45.1
BN531 BN65.1
BN66.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
...
DDCSET2 COMPANY KeyChange HR00.1 HR01.1
DED-CLASS PR02.1 PR205
DED-CODE PR227 PR240
PR241 PR242
PR243 PR244
PR245 PR252
PR274 PR275
PR279 PR297
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 PR252
TAX-AUTH-TYPE Where CALC-TYPE = "T" PR287 PR297
TAX-CATEGORY PR299 UK145
DED-CODE
DDCSET7 COMPANY KeyChange, Subset BN150 BN305
TAX-ID-CODE Where TAX-ID-CODE != Spaces ET530 ETI2.1
TAX-CATEGORY And END-DATE = Zeroes HR11.1 HR11.2
FORMULA-NUMBER HR511 LP130
DED-CODE PA02.1 PA100
PA102 PA115
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
...
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
|
