|
|
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 BN31.1
BN31.2 BN32.1 BN32.2 BN32.3 BN335 BN340
BN45.1 BN531 BN65.1 BN71.1 BN72.1 BS13.1
BS14.1 BS15.1 BS32.1 HDDC.1 HR11.1 HR11.2
HR170 HR211 HR511 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 PR14.1
PR141 PR142 PR15.1 PR15.2 PR160 PR180
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 PR265 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
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 PR52.1 PR529
PR530 PR560 PR82.1 PR82.2 PR85.1 PR86.1
UK102 UK141 UK145 UK183 UK184 UK201
UK202 UK46.2 UK47.1 UK47.2 UK50.1 UK50.2
UK50.3 UK50.5 TA147 TP135 TP140 PR03.1
PR206
UPDATED BY
BN00.1 BN15.1 PR02.1 PR05.1 PR115 HR00.1
HR01.1 PBIP.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DDC-COMPANY Numeric 4 PR05.1
Element: Company Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
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: 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 PR05.1 PR25.2
Element: Calculation TyContains 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
DDC-AMOUNT-PERC Signed 13.4 PR05.1
Element: Amount or PercContains 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
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: Required Code Contains the required code linked to
the deduction (Required Deduction Header
file record).
DDC-DED-CLASS Alpha 3 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 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 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) PR05.1
Element: Effective DateContains the effective date of the
deduction.
DDC-END-DATE Numeric 8 (yyyymmdd) PR05.1
Element: Ending Date Contains the ending date for taking the
deduction.
DDC-ACR-DIST-CO Numeric 4 PR05.1 PR197
Element: Company Contains the distribution company PR82.1 PR85.1
portion of the deduction accrual
account.
DDC-ACR-ACCT-UNIT Alpha 15 PR05.1 PR197
Element: Accounting UniContains the accounting unit portion of PR82.1 PR85.1
the deduction accrual account. When it
is left blank, the system performs a
default to the process level, company,
then the employee record.
DDC-ACR-ACCOUNT Numeric 6 PR05.1 PR197
Element: Account Contains the account portion of the PR82.1 PR85.1
deduction accrual account.
DDC-ACR-SUB-ACCT Numeric 4 PR05.1 PR197
Element: Subaccount Contains the subaccount portion of the PR82.1 PR85.1
deduction accrual account.
DDC-EXP-DIST-CO Numeric 4 PR05.1 PR197
Element: Company Contains the distribution company PR82.1 PR85.1
portion of the deduction expense account
for company-paid deductions.
DDC-EXP-ACCT-UNIT Alpha 15 PR05.1 PR197
Expense Accounting Contains the accounting unit portion of PR82.1 PR85.1
Unit 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.
DDC-EXP-ACCOUNT Numeric 6 PR05.1 PR197
Element: Expense AccounContains the account portion of the PR82.1 PR85.1
deduction expense account for
company-paid deductions.
DDC-EXP-SUB-ACCT Numeric 4 PR05.1 PR197
Element: Expense SubaccContains the subaccount portion of the PR82.1 PR85.1
deduction expense account for
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 PR05.1
Matched Deduction Contains the employee-paid deduction on
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 PR05.1
Element: Payment 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: 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 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 PR05.1 PR197
Element: Activity Activities are the processes or PR82.1 PR85.1
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 PR197
Element: Account CategoAccount categories are groupings of PR82.1 PR85.1
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
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 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 Represents the number of decimals
Code defined for the currency of the object.
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
Remit To Location A user-defined code that represents a
Code vendor's remittance address.
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 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN335 BN340
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HDDC.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
DED-CODE Where CHANGE-FLAG = "Y"
DDCSET6 COMPANY KeyChange, Subset PR206 UK145
TAX-AUTH-TYPE Where CALC-TYPE = "T"
TAX-CATEGORY
DED-CODE
DDCSET7 COMPANY KeyChange, Subset BN150 HR11.1
TAX-ID-CODE Where TAX-ID-CODE != Spaces HR11.2 HR511
TAX-CATEGORY And END-DATE = Zeroes PA02.1 PA100
FORMULA-NUMBER PA102 PA13.1
DED-CODE 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 PR134
PR136 PR206
...
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
|
