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 BN500 BN531 BN65.1 BN66.1 BN71.1 BN72.1 BS13.1 BS14.1 BS15.1 BS32.1 HDDC.1 HR11.1 HR170 HR211 HR511 HR70.1 PA100 PA52.1 PA52.4 PA52.5 PR06.1 PR11.1 PR114 PR128 PR13.1 PR13.2 PR131 PR132 PR134 PR136 PR137 PR139 PR14.1 PR140 PR141 PR142 PR15.1 PR15.2 PR150 PR160 PR180 PR195 PR199 PR20.1 PR20.5 PR205 PR206 PR214 PR220 PR225 PR226 PR23.1 PR239 PR25.2 PR26.1 PR26.2 PR260 PR265 PR27.1 PR275 PR276 PR280 PR290 PR291 PR292 PR294 PR295 PR297 PR298 PR32.1 PR32.2 PR33.1 PR33.2 PR33.3 PR35.1 PR35.2 PR35.3 PR35.4 PR35.5 PR35.6 PR35.8 PR36.1 PR37.1 PR39.1 PR39.2 PR45.1 PR50.1 PR50.2 PR50.3 PR50.4 PR51.1 PR51.2 PR514 PR52.1 PR530 PR560 PR63.1 PR80.1 PR80.2 PR82.1 PR82.2 PR85.1 PR86.1 PR89.1 UK102 UK330 UK120 PR03.1 UPDATED BY BN00.1 BN10.1 BN15.1 BN510 PR02.1 PR05.1 PR115 HR00.1 HR01.1 PBIP.1 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 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 calculation type determines how the system calculates the deduction. E = Percent of Employee Deduction H = Amount per Hour N = Percent of Disposable Income P = Percent W = Withholding A = Flat Amount D = Amount per Day B = Percent of Base Rate Per Hour 1 = Flat Amt + % of Gross Pay 2 = Pct of Disp W/Min Flat Amt X = User Exit DDC-GARNISH-ID Alpha 10 Garnishment Contains a value that identifies the Identification deduction as a garnishment deduction. Validated in the Garnishment Parameters file. 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 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 PR150 Acr Dist Co Contains the distribution company PR195 PR199 portion of the deduction accrual PR82.1 PR85.1 account. DDC-ACR-ACCT-UNIT Alpha 15 PR05.1 PR150 Accrual Accounting Contains the accounting unit portion of PR195 PR199 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 PR05.1 PR150 Accrual Account Contains the account portion of the PR195 PR199 Number deduction accrual account. PR82.1 PR85.1 DDC-ACR-SUB-ACCT Numeric 4 PR05.1 PR150 Accrual Subaccount Contains the subaccount portion of the PR195 PR199 Number deduction accrual account. PR82.1 PR85.1 DDC-EXP-DIST-CO Numeric 4 PR05.1 PR150 Exp Dist Co Contains the distribution company PR195 PR199 portion of the deduction expense account PR82.1 PR85.1 for company-paid deductions. DDC-EXP-ACCT-UNIT Alpha 15 PR05.1 PR150 Expense Accounting Contains the accounting unit portion of PR195 PR199 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 PR05.1 PR150 Expense Account Contains the account portion of the PR195 PR199 deduction expense account for PR82.1 PR85.1 company-paid deductions. DDC-EXP-SUB-ACCT Numeric 4 PR05.1 PR150 Expense Subaccount Contains the subaccount portion of the PR195 PR199 deduction expense account for PR82.1 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 PR80.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 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. Activities and cost object activities are used synonymously in the Activity Management system. Direct costs are posted to activities, and indirect costs are allocated to activities based on activity drivers. Activities are grouped or organized by activity levels. There are two kinds of activities: "posting allowed" and "summary only." Use posting level activities to budget and maintain all posted transactions. Summary activities or macro activities combine information and balances from lower level activities for reporting and inquiries. 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 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-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 DEDCODE FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN DDCSET1 COMPANY BN00.1 BN10.1 DED-CODE 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 BN72.1 BS13.1 ... DDCSET2 COMPANY KeyChange HR00.1 HR01.1 DED-CLASS PBIP.1 PR02.1 DED-CODE PR205 PR27.1 PR275 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 PR14.1 PR15.2 PR205 DDCSET5 COMPANY Subset PR115 PR140 DED-CODE Where CHANGE-FLAG = "Y" 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 Required When DDC-TAX-CATEGORY != Zeroes DDC-ADJUST-PAY -> PXC-ADJUST-PAY DDC-TAX-CATEGORY -> PXC-TAX-CATEGORY Tax Id Code PRTAXAUTH Required When DDC-CALC-TYPE = "W" DDC-TAX-ID-CODE -> PRX-TAX-ID-CODE 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 |