| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | Y1UN | Union Code | String | UDC (06 UN) | 6 | 0 | Allow NULL? |
| 2 | Y1JBCD | Job Type (Craft) Code | String | UDC (06 G) | 6 | 0 | Allow NULL? |
| 3 | Y1JBST | Job Step | String | UDC (06 GS) | 4 | 0 | Allow NULL? |
| 4 | Y1EXR | Name - Remark Explanation | String | Generic Edit | 30 | 0 | Allow NULL? |
| 5 | Y1PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 6 | Y1DISO | DBA Type | Character | UDC (05 DI) | 1 | 0 | Allow NULL? |
| 7 | Y1PGRP | Deduct/Benefit Override Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 8 | Y1PSDT | Date - Pay Starts | Date | Generic Edit | 6 | 0 | |
| 9 | Y1PTDT | Date - Pay Stops | Date | Generic Edit | 6 | 0 | |
| 10 | Y1SFLG | Void Flag (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 11 | Y1DTAB | Table Code | String | Generic Edit | 5 | 0 | Allow NULL? |
| 12 | Y1DESQ | Source of Calculation | Character | UDC (06 DB) | 1 | 0 | Allow NULL? |
| 13 | Y1SBL | Subledger - G/L | String | Generic Edit | 8 | 0 | Allow NULL? |
| 14 | Y1LT | Ledger Types | String | UDC (09 LT) | 2 | 0 | Allow NULL? |
| 15 | Y1RTAM | Amount or Rate | Numeric | Generic Edit | 9 | 4 | Allow NULL? |
| 16 | Y1GPA | Amount - Gross Pay | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 17 | Y1PPDL | Pay Period Limit | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 18 | Y1MDL | Monthly Limit | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 19 | Y1ADL | Annual Limit | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 20 | Y1PPPL | Limit on Pay Period Percent | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 21 | Y1NP | Number of Deduction Periods | Numeric | Generic Edit | 4 | 0 | Allow NULL? |
| 22 | Y1AD | Amount - Due | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 23 | Y1HMIN | Hours - Minimum | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 24 | Y1HMAX | Hours - Maximum | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 25 | Y1SEC$ | Security Indicator | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 26 | Y1ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 27 | Y1DEP1 | Deduction Period 1 | Character | UDC (05A DD) | 1 | 0 | Allow NULL? |
| 28 | Y1DEP2 | Deduction Period 2 | Character | UDC (05A DD) | 1 | 0 | Allow NULL? |
| 29 | Y1DEP3 | Deduction Period 3 | Character | UDC (05A DD) | 1 | 0 | Allow NULL? |
| 30 | Y1DEP4 | Deduction Period 4 | Character | UDC (05A DD) | 1 | 0 | Allow NULL? |
| 31 | Y1DEP5 | Deduction Period 5 | Character | UDC (05A DD) | 1 | 0 | Allow NULL? |
| 32 | Y1DEP6 | Deduction Period 6 | Character | UDC (05A DD) | 1 | 0 | Allow NULL? |
| 33 | Y1PDED | DBA For Prior Limit | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 34 | Y1DGRP | Group Limit Code | String | UDC (06 GR) | 2 | 0 | Allow NULL? |
| 35 | Y1DPRI | Order To Adjust Ded | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 36 | Y1ARRR | Arrearage Method | Character | UDC (05A AR) | 1 | 0 | Allow NULL? |
| 37 | Y1QDL | Quarterly Limit | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 38 | Y1ACEQ | Accrual Equivalent | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 39 | Y1AMTS | Amount or Rate - Secondary | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 40 | Y1SADL | Annual Limit (Level 2) | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 41 | Y1CMAX | Inception to Date Limit | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 42 | Y1AR1Y | Accrual Rollover - First Year | Character | UDC (07 AU) | 1 | 0 | Allow NULL? |
| 43 | Y1ARSY | Accrual Rollover - Subsequent Years | Character | UDC | 1 | 0 | Allow NULL? |
| 44 | Y1RTAB | Rollover Table | String | Generic Edit | 5 | 0 | Allow NULL? |
| 45 | Y1CTAB | Rollover Table -Subsequent Year | String | Generic Edit | 5 | 0 | Allow NULL? |
| 46 | Y1MCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 47 | Y1ODBA | Optional DBA Processing Flag | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 48 | Y1ZOVR | Override Flag | Character | UDC (05 YB) | 1 | 0 | Allow NULL? |
| 49 | Y1USER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 50 | Y1PID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 51 | Y1UPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 52 | Y1GVCH | A/P Voucher (Y N) | Character | UDC (05 YB) | 1 | 0 | Allow NULL? |
| 53 | Y1DEFR | Date Effective Rate Control | Character | UDC (07 RN) | 1 | 0 | Allow NULL? |
