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
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||
---|---|---|---|---|---|---|---|---|
DDC-COMPANY Element: Company Hr | Numeric 4 |
|
||||||
DDC-DED-CODE Element: Deduction | Alpha 4 Contains user-defined deductions. |
|
||||||
DDC-DESCRIPTION Element: Description | Alpha 30 (Lower Case) Contains the deduction description. |
|
||||||
DDC-CHECK-DESC Element: Check Desc L | Alpha 15 (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. |
|
||||||
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/Net 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 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. |
|
||||||
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) 22 = 457(b) 25 = 457(f) |
|
||||||
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 |
|
||||||
DDC-REQ-CODE Element: Req Code | Alpha 3 Contains the required code linked to the deduction (Required Deduction Header file record). |
|
||||||
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. |
|
||||||
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 |
|
||||||
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 |
|
||||||
DDC-EFFECT-DATE Element: Effect Date | Numeric 8 (yyyymmdd) Contains the effective date of the deduction. |
|
||||||
DDC-END-DATE Element: End Date | Numeric 8 (yyyymmdd) Contains the ending date for taking the deduction. |
|
||||||
DDC-ACR-DIST-CO Element: Company | Numeric 4 Contains the distribution company portion of the deduction accrual account. |
|
||||||
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. |
|
||||||
DDC-ACR-ACCOUNT Element: Account | Numeric 6 Contains the account portion of the deduction accrual account. |
|
||||||
DDC-ACR-SUB-ACCT Element: Sub Acct | Numeric 4 Contains the subaccount portion of the deduction accrual account. |
|
||||||
DDC-EXP-DIST-CO Element: Company | Numeric 4 Contains the distribution company portion of the deduction expense account for company-paid deductions. |
|
||||||
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. |
|
||||||
DDC-EXP-ACCOUNT Element: Expense Account | Numeric 6 Contains the account portion of the deduction expense account for company-paid deductions. |
|
||||||
DDC-EXP-SUB-ACCT Element: Expense Subaccount | Numeric 4 Contains the subaccount portion of the deduction expense account for company-paid deductions. |
|
||||||
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 |
|
||||||
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 |
|
||||||
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. |
|
||||||
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. |
|
||||||
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 |
|
||||||
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 |
|
||||||
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) |
|
||||||
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 |
|
||||||
DDC-TAX-CATEGORY Element: Tax Category | Numeric 2 Contains the tax category defined for the deduction. |
|
||||||
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. |
|
||||||
DDC-MONTHLY-LIMIT Element: Monthly Limit | Signed 11.2 Contains the deduction limit that can be taken in a single month. |
|
||||||
DDC-PAY-PRD-LIMIT Element: Pay Period Limit | Signed 11.2 Contains the deduction limit that can be taken in a pay period. |
|
||||||
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 |
|
||||||
DDC-FORMULA-NUMBER Element: Formula Number | Numeric 4 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 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 |
|
||||||
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 |
|
||||||
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. |
|
||||||
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 |
|
||||||
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 |
|
||||||
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. |
|
||||||
DDC-UPDATE-AP Element: Update Ap | Alpha 1 Indicates whether invoice transactions are created for PR199 (Payroll Close) is run. Y = Yes N = No |
|
||||||
DDC-VENDOR Element: Vendor | Alpha 9 (Right Justified) The vendor's identification code. |
|
||||||
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 |
|
||||||
DDC-AMOUNT-2 Element: Amount 2 | Signed 13.4 Used for the calculation type. |
|
||||||
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 |
|
||||||
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). |
|
||||||
DDC-CLIENT-CREDIT Element: Client Credit | Alpha 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 ). |
|
||||||
DDC-CURR-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||||
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 |
|
||||||
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 |
|
||||||
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. |
|
||||||
DDC-EXCLUDE-AMT Element: Exclude Amt | Signed 13.4 |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
DDC-OVR-EXP-DED Element: Ovr Exp Def | Alpha 1 1 = No 2 = Yes |
|
||||||
DDC-POST-FLAG Element: Post Flag | Alpha 1 |
|
||||||
DDC-ADDL-TAX-CODE Element: Addl Tax Code | Numeric 2 09 = Substitute Lump Sum Tax |
|
||||||
DDC-CLAIM-CODE-DFT Element: Claim Code | Alpha 3 A = Engage BSI Claim Code Lookup B = Basic Personal Amount |
|
||||||
DDC-JOIN-LEAVE-FLG Element: Join Leave Flg | Alpha 1 |
|
||||||
DDC-RECOV-FLAG Element: Recov Flag | Alpha 1 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
DDCSET1 |
COMPANY DED-CODE |
|
| ||||||||||||||||||||||||||||||||||||||||||||||||
DDCSET2 |
COMPANY DED-CLASS DED-CODE |
|
| ||||||||||||||||||||||||||||||||||||||||||||||||
DDCSET3 |
COMPANY REQ-CODE DED-CODE |
|
| ||||||||||||||||||||||||||||||||||||||||||||||||
DDCSET5 |
COMPANY DED-CODE |
|
| ||||||||||||||||||||||||||||||||||||||||||||||||
DDCSET6 |
COMPANY TAX-AUTH-TYPE TAX-CATEGORY DED-CODE |
|
| ||||||||||||||||||||||||||||||||||||||||||||||||
DDCSET7 |
COMPANY TAX-ID-CODE TAX-CATEGORY FORMULA-NUMBER DED-CODE |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Accrual Acct | GLMASTER |
Required
| ||||||||||||||||||||||||
Acct Category | ACACCTCAT |
Required
| ||||||||||||||||||||||||
Activity | ACACTIVITY |
Required
| ||||||||||||||||||||||||
Company | PRSYSTEM |
Required
| ||||||||||||||||||||||||
Ded Class | DCCLASS |
Required
| ||||||||||||||||||||||||
Default Tax Id | PRTAXID |
Required
| ||||||||||||||||||||||||
Expense Acct | GLMASTER |
Required
| ||||||||||||||||||||||||
Linked Ded | DEDCODE |
Required
| ||||||||||||||||||||||||
Matched Ded | DEDCODE |
Required
| ||||||||||||||||||||||||
Pay Class | PAYCLASS |
Required
| ||||||||||||||||||||||||
Req Code | REQCODE |
Required
| ||||||||||||||||||||||||
Tax Category | PRTAXCAT |
Not Required
| ||||||||||||||||||||||||
Tax Id Code | PRTAXAUTH |
Required
| ||||||||||||||||||||||||
Tax Province | PRPROVINCE |
Not Required
| ||||||||||||||||||||||||
Tax State | PRSTATE |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Emp Deductions | EMDEDMASTR |
Delete Restricted
| ||||||||||||
Pl Accr Accts | PRDEDACCTS |
Delete Cascades
| ||||||||||||
Pl Exp Accts | PRDEDACCTS |
Delete Cascades
| ||||||||||||
Tbl Exempt Ded | TAXIDEXMP |
Delete Cascades
|
All trademarks and registered trademarks are the property of their
respective owners.