| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | PWAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 2 | PWDWK | Date - Worked | Date | Generic Edit | 6 | 0 | |
| 3 | PWPRTR | Transaction No. - Payroll | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 4 | PWCKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 5 | PWPAYD | Payroll ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 6 | PWPWPF | Prevailing Wage Adjustment Status | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 7 | PWPWPDBA | Prevailing Wage PDBA Code | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 8 | PWPWCF | Prevailing Wage Comparison Method | Character | UDC (07 PQ) | 1 | 0 | Allow NULL? |
| 9 | PWPWCM | Prevailing Wage Calculation Method | String | UDC (07 PT) | 2 | 0 | Allow NULL? |
| 10 | PWPWCR | Prevailing Wage Calculation Result | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 11 | PWPWAJCD | Prevailing Wage Adjustment PDBA Code | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 12 | PWPWAAMT | Prevailing Wage Adjustment Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 13 | PWPWTRNO | Prevailing Wage Transaction Number | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 14 | PWPWSMMF | Prevailing Wage Summarization Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 15 | PWPWJHRT | Prevailing Wage Job Hourly Rate | Numeric | Generic Edit | 15 | 3 | Allow NULL? |
| 16 | PWPWJFRT | Prevailing Wage Job Fringe Rate | Numeric | Generic Edit | 15 | 3 | Allow NULL? |
| 17 | PWBHRT | Rate - Base Hourly | Numeric | Generic Edit | 9 | 3 | Allow NULL? |
| 18 | PWPWEFRT | Prevailing Wage Employee Fringe Rate | Numeric | Generic Edit | 15 | 3 | Allow NULL? |
| 19 | PWCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 20 | PWPWCH01 | Prevailing Wage Generic Character 01 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 21 | PWPWCH02 | Prevailing Wage Generic Character 02 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 22 | PWPWCH03 | Prevailing Wage Generic Character 03 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 23 | PWPWCH04 | Prevailing Wage Generic Character 04 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 24 | PWPWJD01 | Prevailing Wage Generic Date 01 | Date | Generic Edit | 6 | 0 | |
| 25 | PWPWJD02 | Prevailing Wage Generic Date 02 | Date | Generic Edit | 6 | 0 | |
| 26 | PWPWJD03 | Prevailing Wage Generic Date 03 | Date | Generic Edit | 6 | 0 | |
| 27 | PWPWJD04 | Prevailing Wage Generic Date 04 | Date | Generic Edit | 6 | 0 | |
| 28 | PWPWST01 | Prevailing Wage Generic String 01 | String | Generic Edit | 20 | 0 | Allow NULL? |
| 29 | PWPWST02 | Prevailing Wage Generic String 02 | String | Generic Edit | 20 | 0 | Allow NULL? |
| 30 | PWPWST03 | Prevailing Wage Generic String 03 | String | Generic Edit | 40 | 0 | Allow NULL? |
| 31 | PWPWST04 | Prevailing Wage Generic String 04 | String | Generic Edit | 40 | 0 | Allow NULL? |
| 32 | PWPWMN01 | Prevailing Wage Difference Per Hour | Numeric | Generic Edit | 15 | 3 | Allow NULL? |
| 33 | PWPWMN02 | Prevailing Wage Generic Math Numeric 02 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 34 | PWPWMN03 | Prevailing Wage Generic Math Numeric 03 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 35 | PWPWMN04 | Prevailing Wage Generic Math Numeric 04 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 36 | PWUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 37 | PWPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 38 | PWJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 39 | PWUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 40 | PWUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
