| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | YHTRTE | Code - Transaction | Character | UDC | 1 | 0 | Allow NULL? |
| 2 | YHJBCD | Job Type (Craft) Code | String | UDC (06 G) | 6 | 0 | Allow NULL? |
| 3 | YHJBST | Job Step | String | UDC (06 GS) | 4 | 0 | Allow NULL? |
| 4 | YHUN | Union Code | String | UDC (06 UN) | 6 | 0 | Allow NULL? |
| 5 | YHMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 6 | YHAJBC | Alternate Job Type (Craft) Code | String | UDC (06 G) | 6 | 0 | Allow NULL? |
| 7 | YHAJBS | Alternate Job Step | String | UDC (06 GS) | 4 | 0 | Allow NULL? |
| 8 | YHLHRT | Rate - Hourly(Lower) | Numeric | Generic Edit | 9 | 3 | Allow NULL? |
| 9 | YHUHRT | Rate - Hourly(Upper) | Numeric | Generic Edit | 9 | 3 | Allow NULL? |
| 10 | YHRPTC | Class - Report | Character | UDC (07 RU) | 1 | 0 | Allow NULL? |
| 11 | YHEJBC | EEO Job Type (Craft) Code | String | UDC (06 G) | 6 | 0 | Allow NULL? |
| 12 | YHCEDT | Certified Edit Flag | Character | UDC (07 CF) | 1 | 0 | Allow NULL? |
| 13 | YHJOBT | Code - Tip Category | Character | UDC | 1 | 0 | Allow NULL? |
| 14 | YHSEC1 | Security Codes - Payroll 001 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 15 | YHSEC2 | Security Codes - Payroll 002 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 16 | YHSEC3 | Security Codes - Payroll 003 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 17 | YHSEC4 | Security Codes - Payroll 004 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 18 | YHSEC5 | Security Codes - Payroll 005 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 19 | YHEFTB | Date - Beginning Effective | Date | Generic Edit | 6 | 0 | |
| 20 | YHEFTE | Date - Ending Effective | Date | Generic Edit | 6 | 0 | |
| 21 | YHHMIN | Hours - Minimum | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 22 | YHHMAX | Hours - Maximum | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 23 | YHNJCD | Job Category at Next Level | String | UDC (06 G) | 6 | 0 | Allow NULL? |
| 24 | YHNJST | Job Step at Next Level | String | UDC (06 GS) | 4 | 0 | Allow NULL? |
| 25 | YHCOLR | Rate - Cola/Retroactive | Numeric | Generic Edit | 9 | 4 | Allow NULL? |
| 26 | YHCOLA | Amount - Cola/Retroactive | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 27 | YHCRAR | Rate(A) - Cola/Retroactive | Numeric | Generic Edit | 9 | 4 | Allow NULL? |
| 28 | YHCRAA | Amount(A) - Cola/Retroactive | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 29 | YHCRBR | Rate(B) - Cola/Retroactive | Numeric | Generic Edit | 9 | 4 | Allow NULL? |
| 30 | YHCRAB | Amount(B) - Cola/Retroactive | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 31 | YHCRCR | Rate(C) - Cola/Retroactive | Numeric | Generic Edit | 9 | 4 | Allow NULL? |
| 32 | YHCRAC | Amount(C) - Cola/Retroactive | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 33 | YHCRDR | Rate(D) - Cola/Retroactive | Numeric | Generic Edit | 9 | 4 | Allow NULL? |
| 34 | YHCRAD | Amount(D) - Cola/Retroactive | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 35 | YHCLSH | Classification Hierarchy | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 36 | YHPDBA | DBA Code | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
