| 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 | YLPWCF | Prevailing Wage Comparison Method | Character | UDC (07 PQ) | 1 | 0 | Allow NULL? |
| 9 | YLURCH01 | Union Rates Generic Character 01 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 10 | YLURCH02 | Union Rates Generic Character 02 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 11 | YLURCH03 | Union Rates Generic Character 03 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 12 | YLURCH04 | Union Rates Generic Character 04 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 13 | YLURMN01 | Union Rates Generic Math Numeric 01 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 14 | YLURMN02 | Union Rates Generic Math Numeric 02 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 15 | YLURMN03 | Union Rates Generic Math Numeric 03 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 16 | YLURMN04 | Union Rates Generic Math Numeric 04 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 17 | YLURST01 | Union Rates Generic String 01 | String | Generic Edit | 20 | 0 | Allow NULL? |
| 18 | YLURST02 | Union Rates Generic String 02 | String | Generic Edit | 20 | 0 | Allow NULL? |
| 19 | YLURST03 | Union Rates Generic String 03 | String | Generic Edit | 40 | 0 | Allow NULL? |
| 20 | YLURST04 | Union Rates Generic String 04 | String | Generic Edit | 40 | 0 | Allow NULL? |
| 21 | YLUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 22 | YLPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 23 | YLJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 24 | YLUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 25 | YLUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
