| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | YLUN | Union Code | String | UDC (06 UN) | 6 | 0 | Allow NULL? |
| 2 | YLMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 3 | YLEFTB | Date - Beginning Effective | Date | Generic Edit | 6 | 0 | |
| 4 | YLEFTE | Date - Ending Effective | Date | Generic Edit | 6 | 0 | |
| 5 | YLJBCD | Job Type (Craft) Code | String | UDC (06 G) | 6 | 0 | Allow NULL? |
| 6 | YLJBST | Job Step | String | UDC (06 GS) | 4 | 0 | Allow NULL? |
| 7 | YLSHFT | Shift Code | Character | UDC (06 SH) | 1 | 0 | Allow NULL? |
| 8 | YLPHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 | Allow NULL? |
| 9 | YLPBRT | Rate - Distribution (or Billing) | Numeric | Generic Edit | 9 | 3 | Allow NULL? |
| 10 | YLLF | Labor Distribution Multiplier | Numeric | Generic Edit | 5 | 4 | Allow NULL? |
| 11 | YLLMTH | Labor Distribution Method | Character | UDC (07 LT) | 1 | 0 | Allow NULL? |
| 12 | YLPPRT | Rate - Piecework | Numeric | Generic Edit | 9 | 3 | Allow NULL? |
| 13 | YLWAGD | Wage Decision Number | String | Generic Edit | 20 | 0 | Allow NULL? |
| 14 | YLOH1 | Rate - Overtime | Numeric | Generic Edit | 15 | 3 | Allow NULL? |
| 15 | YLOH2 | Rate - Double Time | Numeric | Generic Edit | 15 | 3 | Allow NULL? |
| 16 | YLOH3 | Rate - Triple Time | Numeric | Generic Edit | 15 | 3 | Allow NULL? |
| 17 | YLOH4 | Rate - Holiday | Numeric | Generic Edit | 15 | 3 | Allow NULL? |
| 18 | YLOBJ | Object Account | String | Generic Edit | 6 | 0 | Allow NULL? |
| 19 | YLUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 20 | YLPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 21 | YLUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 22 | YLWCMP | Worker's Comp. Insurance Code | String | UDC (00 W) | 4 | 0 | Allow NULL? |
| 23 | YLOR1 | Rate - Billing Overtime | Numeric | Generic Edit | 9 | 3 | Allow NULL? |
| 24 | YLOR2 | Rate - Double Time Billing | Numeric | Generic Edit | 9 | 3 | Allow NULL? |
| 25 | YLOR3 | Rate - Triple Time Billing | Numeric | Generic Edit | 9 | 3 | Allow NULL? |
| 26 | YLOR4 | Rate - Holiday Billing | Numeric | Generic Edit | 9 | 3 | Allow NULL? |
| 27 | YLB2RT | Rate - Burden | Numeric | Generic Edit | 9 | 3 | Allow NULL? |
| 28 | YLOU1 | Rate - Overtime Burden-2 | Numeric | Generic Edit | 9 | 3 | Allow NULL? |
| 29 | YLOU2 | Rate - Double Time Burden-2 | Numeric | Generic Edit | 9 | 3 | Allow NULL? |
| 30 | YLOU3 | Rate - Triple Time Burden-2 | Numeric | Generic Edit | 9 | 3 | Allow NULL? |
| 31 | YLOU4 | Rate - Holiday Burden-2 | Numeric | Generic Edit | 9 | 3 | Allow NULL? |
| 32 | YLOT1 | Rate - Overtime | Numeric | Generic Edit | 15 | 3 | Allow NULL? |
| 33 | YLOT2 | Rate - Double Time | Numeric | Generic Edit | 9 | 3 | Allow NULL? |
| 34 | YLOT3 | Rate - Triple Time | Numeric | Generic Edit | 9 | 3 | Allow NULL? |
| 35 | YLOT4 | Rate - Holiday | Numeric | Generic Edit | 9 | 3 | Allow NULL? |
| 36 | YLBDRT | Rate - Recharge Burden | Numeric | Generic Edit | 9 | 3 | Allow NULL? |
| 37 | YLWET | Sub Class - Workers Comp | Character | UDC (07 WH) | 1 | 0 | Allow NULL? |
| 38 | YLRBOB | Burden Obj. Account - Recharge | String | Generic Edit | 6 | 0 | Allow NULL? |
| 39 | YLRBO2 | Burden Obj. Account - Recharge 2 | String | Generic Edit | 6 | 0 | Allow NULL? |
| 40 | YLUNRTEEFLG | Union Rate Employee Level Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
