| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | J7YR | Year - Calendar Year | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 2 | J7HMCO | Company - Home | String | Generic Edit | 5 | 0 | Allow NULL? |
| 3 | J7MCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 4 | J7HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 | Allow NULL? |
| 5 | J7AN8 | Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 6 | J7SSN | Employee Tax ID | String | Generic Edit | 20 | 0 | Allow NULL? |
| 7 | J7TARA | Tax Area (Work) | String | Generic Edit | 10 | 0 | Allow NULL? |
| 8 | J7TAXX | Tax Identification Number | String | Generic Edit | 20 | 0 | Allow NULL? |
| 9 | J7T4PP | Canada - Pension Plan Number | String | UDC (77 PN) | 10 | 0 | Allow NULL? |
| 10 | J7T4PA | Canada - Pension Adjustment | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 11 | J7T4PT | Amount - Federal Income Tax - Pension | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 12 | J7T4AP | Canada - T4A Pension Adj. Print Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 13 | J7T4PN | Canada - Pension T4A | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 14 | J7T4IN | Canada - Other Income | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 15 | J7T4LS | Canada - Pension Lump Sum | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 16 | J7T4PL | Canada - Patronage Allocation | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 17 | J7T4SC | Canada - S.E. Commissions | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 18 | J7T4PS | Canada - Pension (Past Services) | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 19 | J7T4AN | Canada - Annuities | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 20 | J7T4RA | Canada - Retiring Allowance | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 21 | J7T4R1 | Canada - Retiring Allow Not Eligible | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 22 | J7WST | Work State | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 23 | J7WCNT | Work County | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 24 | J7WCTY | Work City | Numeric | Generic Edit | 4 | 0 | Allow NULL? |
| 25 | J7USER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 26 | J7PID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 27 | J7UPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 28 | J7DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 | Allow NULL? |