| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | ZDAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 2 | ZDSSN | Employee Tax ID | String | Generic Edit | 20 | 0 | Allow NULL? |
| 3 | ZDTAXFNO | Tax File Number | String | Generic Edit | 11 | 0 | Allow NULL? |
| 4 | ZDEDTF | EffectiveFromDate | Date | Generic Edit | 6 | 0 | |
| 5 | ZDEDTT | EffectiveThruDate | Date | Generic Edit | 6 | 0 | |
| 6 | ZDSCLDER | Derived Tax Scale | String | Generic Edit | 3 | 0 | Allow NULL? |
| 7 | ZDSCALE | Tax scale | String | UDC (75 SC) | 3 | 0 | Allow NULL? |
| 8 | ZDSPECTC | Special Tax Certificate Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 9 | ZDSPECTRT | Special Tax Rate | Numeric | Generic Edit | 7 | 4 | Allow NULL? |
| 10 | ZDSTDEBT | Student Debt Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 11 | ZDCLDSUPF | Child Support Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 12 | ZDMAINJ | Main Job Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 13 | ZDINCLVL1 | Income level 01 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 14 | ZDINCFLG1 | Income In Excess Flag 01 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 15 | ZDINCLVL2 | Income level 02 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 16 | ZDINCFLG2 | Income In Excess Flag 02 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 17 | ZDINCLVL3 | Income level 03 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 18 | ZDINCFLG3 | Income In Excess Flag 03 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 19 | ZDHRSLVL | Hours Level | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 20 | ZDHRSFLG | Hours in Excess Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 21 | ZDWHDPAY | Withholding Payments flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 22 | ZDEXTPAY | Extra Emolument Payments Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 23 | ZDSPFLG01 | Spare Flag 01 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 24 | ZDSPFLG02 | Spare Flag 02 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 25 | ZDERNPRX | Earner Premium Exempt Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 26 | ZDUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 27 | ZDUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 28 | ZDPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 29 | ZDJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 30 | ZDUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 31 | ZDNZSLPO | NZ Student Loan Percent Override | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 32 | ZDNZSLFAO | NZ Student Loan Fixed Amount Override | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 33 | ZDNZSLARR | NZ Student Loan Annual Rate of Repayment | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 34 | ZDNZSLEFD | NZ Student Loan Effective From Date | Date | Generic Edit | 6 | 0 | |
| 35 | ZDNZSLETD | NZ Student Loan Effective Thru Date | Date | Generic Edit | 6 | 0 | |
| 36 | ZDNZSLPP | NZ Student Loan Penalty Percent | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 37 | ZDNZSLPA | NZ Student Loan Penalty Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 38 | ZDNZSLPFD | NZ Student Loan Penalty From Date | Date | Generic Edit | 6 | 0 | |
| 39 | ZDNZSLPTD | NZ Student Loan Penalty Thru Date | Date | Generic Edit | 6 | 0 | |
| 40 | ZDNZSLVP | NZ Student Loan Voluntary Percent | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 41 | ZDNZSLVA | NZ Student Loan Voluntary Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 42 | ZDNZSLVFD | NZ Student Loan Voluntary From Date | Date | Generic Edit | 6 | 0 | |
| 43 | ZDNZSLVTD | NZ Student Loan Voluntary Thru Date | Date | Generic Edit | 6 | 0 | |
| 44 | ZDNZSLTH | Include Threshold | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 45 | ZDNZSLCIRT | Include Threshold Commisioners Deduction | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 46 | ZDNZSLAD | SLCIR Amount Due | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 47 | ZDNZCF1 | Future Character 1 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 48 | ZDNZCF2 | Future Character 2 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 49 | ZDNZCF3 | Future Character 3 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 50 | ZDNZCF4 | Future Character 4 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 51 | ZDNZDF1 | Future Date 1 | Date | Generic Edit | 6 | 0 | |
| 52 | ZDNZDF2 | Future Date 2 | Date | Generic Edit | 6 | 0 | |
| 53 | ZDNZDF3 | Future Date 3 | Date | Generic Edit | 6 | 0 | |
| 54 | ZDNZDF4 | Future Date 4 | Date | Generic Edit | 6 | 0 | |
| 55 | ZDNZNF1 | Future Numeric 1 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 56 | ZDNZNF2 | Future Numeric 2 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 57 | ZDNZNF3 | Future Numeric 3 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 58 | ZDNZNF4 | Future Numeric 4 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 59 | ZDNZSF1 | Future String 1 | String | Generic Edit | 50 | 0 | Allow NULL? |
| 60 | ZDNZSF2 | Future String 2 | String | Generic Edit | 50 | 0 | Allow NULL? |
| 61 | ZDNZSF3 | Future String 3 | String | Generic Edit | 50 | 0 | Allow NULL? |
| 62 | ZDNZSF4 | Future String 4 | String | Generic Edit | 50 | 0 | Allow NULL? |
