| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | PHAN8 | Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | PHPWPDBA | Prevailing Wage PDBA Code | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 3 | PHPDBA | DBA Code | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 4 | PHPRTR | Transaction No. - Payroll | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 5 | PHDWK | Date - Worked | Date | Generic Edit | 6 | 0 | |
| 6 | PHPWFRT | Prevailing Wage Fringe Rate | Numeric | Generic Edit | 15 | 3 | Allow NULL? |
| 7 | PHPWAR | Prevailing Wage Annualize Rate Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 8 | PHPWHR | Prevailing Wage Hours | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 9 | PHPWMULT | Prevailing Wage Multiplier | Numeric | Generic Edit | 5 | 2 | Allow NULL? |
| 10 | PHCKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 11 | PHPWCH05 | Prevailing Wage Generic Character 05 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 12 | PHPWCH06 | Prevailing Wage Generic Character 06 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 13 | PHPWCH07 | Prevailing Wage Generic Character 07 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 14 | PHPWJD05 | Prevailing Wage Generic Date 05 | Date | Generic Edit | 6 | 0 | |
| 15 | PHPWJD06 | Prevailing Wage Generic Date 06 | Date | Generic Edit | 6 | 0 | |
| 16 | PHPWJD07 | Prevailing Wage Generic Date 07 | Date | Generic Edit | 6 | 0 | |
| 17 | PHPWST05 | Prevailing Wage Generic String 05 | String | Generic Edit | 20 | 0 | Allow NULL? |
| 18 | PHPWST06 | Prevailing Wage Generic String 06 | String | Generic Edit | 20 | 0 | Allow NULL? |
| 19 | PHPWST07 | Prevailing Wage Generic String 07 | String | Generic Edit | 40 | 0 | Allow NULL? |
| 20 | PHPWMN05 | Prevailing Wage Generic Math Numeric 05 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 21 | PHPWMN06 | Prevailing Wage Generic Math Numeric 06 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 22 | PHPWMN07 | Prevailing Wage Generic Math Numeric 07 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 23 | PHUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 24 | PHPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 25 | PHJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 26 | PHUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 27 | PHUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
