| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 05A: PeopleSoft HR & PR Foundation | ||||||||||
| 1 | F060116 | Employee Master Information | 74 | YA | FICM | Tax Calc Method | Character | UDC | 1 | 0 |
| 2 | F0601161 | Point-In-Time Employee Master | 76 | PT | FICM | Tax Calc Method | Character | UDC | 1 | 0 |
| 3 | F060116W | EE Master Request File | 74 | YA | FICM | Tax Calc Method | Character | UDC | 1 | 0 |
| 4 | F060116Z | Unedited Quick Hire Transaction File | 52 | SZ | FICM | Tax Calc Method | Character | UDC | 1 | 0 |
| 05T: Time Entry | ||||||||||
| 5 | F06116 | Employee Transaction Detail File | 144 | YT | FICM | Tax Calc Method | Character | UDC | 1 | 0 |
| 6 | F06116Z1 | Employee Transactions - Batch File | 157 | VL | FICM | Tax Calc Method | Character | UDC | 1 | 0 |
| 7 | F06116Z2 | ESS Timecard History | 157 | VM | FICM | Tax Calc Method | Character | UDC | 1 | 0 |
| 8 | F06278 | Retro Timecard Detail File | 143 | YT | FICM | Tax Calc Method | Character | UDC | 1 | 0 |
| 08AD: ADP Integration | ||||||||||
| 9 | F05137 | ADP Employee Master Information | 43 | AD | FICM | Tax Calc Method | Character | UDC | 1 | 0 |
| 18: Timecard Automation | ||||||||||
| 10 | F186602 | Labor Rules Tag File | 150 | TF | FICM | Tax Calc Method | 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 / TM (Tax Method) stock values
| Value | Description | Special Handling Code | Hard Coded | |
|---|---|---|---|---|
| 1 | Normal Tax Methods | N | ||
| 2 | 0 | Low Income Exemption | Y | |
| 3 | 1 | Spcl Tax, Fica/Med/FUTA Exempt | Y | |
| 4 | 2 | Federal/State Exempt | Y | |
| 5 | 3 | State Exempt | Y | |
| 6 | 4 | Medicare Qualified Employee(3) | N | |
| 7 | 5 | Exempt from FICA/MEDICARE (4 | N | |
| 8 | 6 | Fica/Med/FUTA Exempt | Y | |
| 9 | 7 | Exempt from EI | N | |
| 10 | 8 | Exempt from CPP & QPP | N | |
| 11 | 9 | CA EI/CPP & QPP Exempt | Y | |
| 12 | A | Agricultural Employee | Y | |
| 13 | B | Exempt from PPIP - CA | Y | |
| 14 | C | Contract Employee (C) | N | |
| 15 | D | Exempt from EI/PPIP - CA | Y | |
| 16 | E | US - State Exempt Only | Y | |
| 17 | F | Federal & State exempt | Y | |
| 18 | H | NonResident Alien | Y | |
| 19 | J | Pensioner, EI Exempt - CA | Y | |
| 20 | K | Pensioner,CPP/QPP Exempt - CA | Y | |
| 21 | L | Alabama Construction Fee - US | Y | |
| 22 | M | Pensioner, PPIP Exempt | Y | |
| 23 | N | Non-Resident of Canada | N | |
| 24 | O | Pensioner, EI/PPIP Exempt | Y | |
| 25 | P | Pension Employee (2) | N | |
| 26 | Q | NonResident Alien | Y | |
| 27 | R | Puerto Rico | N | |
| 28 | S | Special Taxes | Y | |
| 29 | T | Special Taxes, Fica Exempt | Y | |
| 30 | U | Special Taxes, Fica/Med Exempt | Y | |
| 31 | V | Spcl Tax, Low Income Exemption | Y | |
| 32 | W | Exempt from EI/PPIP/CPP/QPP | Y | |
| 33 | X | Federal/State Exempt | Y | |
| 34 | Y | State Exempt | Y | |
| 35 | Z | Override to Use Normal Tax | Y | |
| 36 | [ | Pensioner, EI/PPIP/CPP/QPP | Y | |
| 37 | { | Pensioner, PPIP/CPP/QPP | Y |