| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 05: Time Accounting and HRM Base | ||||||||||
| 1 | F069116 | Payroll Transaction Constants | 123 | YC | PRTX | Pre-Tax Deduction | String | UDC | 3 | 0 |
| 07: Payroll | ||||||||||
| 2 | F0701735 | Pretax Deduction Overrides | 3 | YC | PRTX | Pre-Tax Deduction | String | UDC | 3 | 0 |
| 3 | F0729 | Employee DBA Override Instructions | 16 | Y9 | PRTX | Pre-Tax Deduction | String | UDC | 3 | 0 |
| 08AD: ADP Integration | ||||||||||
| 4 | F051375 | ADP Payroll DBA Transaction Constants | 125 | AD | PRTX | Pre-Tax Deduction | String | UDC | 3 | 0 |
| 43: Procurement | ||||||||||
| 5 | F43121 | Purchase Order Receiver File | 62 | PR | TX | Purchasing Taxable (Y/N) | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
UDC 06 / 4K (Pre-Tax Deductions) stock values
| Value | Description | Special Handling Code | Hard Coded | |
|---|---|---|---|---|
| 1 | Default | Y | ||
| 2 | 125 | 125 Plan Deduction | Y | |
| 3 | 15Y | 403B CU 15 year | Y | |
| 4 | 401 | 401K Plan Deduction | Y | |
| 5 | 403 | 403b Deduction | Y | |
| 6 | 40M | 401m Contribution | Y | |
| 7 | 457 | 457 Deduction | Y | |
| 8 | 49A | 409A Deferral (Pretax Deduct) | Y | |
| 9 | 49B | 409A Deferral (benefit) | Y | |
| 10 | 49C | 409A Distribution (benefit) | Y | |
| 11 | A | 401A Deduction | Y | |
| 12 | BCU | 403bk Catch Up | Y | |
| 13 | CU | 457 Catch Up | Y | |
| 14 | CU2 | 457 Catch Up Catch Up | Y | |
| 15 | DC | Dependent Care | Y | |
| 16 | F12 | HSA 125 | Y | |
| 17 | FHS | HSA | Y | |
| 18 | FSA | Flexible Spending Account | Y | |
| 19 | GTL | Group Term Life | Y | |
| 20 | HCU | 125 Health Spend Acct Catch Up | Y | |
| 21 | HSA | 125 Health Spending Account | Y | |
| 22 | KCU | 401k Catch Up | Y | |
| 23 | ROT | Roth IRA Deduction | Y | |
| 24 | RPP | Registered Pension Plan, Can. | Y | |
| 25 | UN | Union Dues, Canada | Y |