| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | PFAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 2 | PFPWPDBA | Prevailing Wage PDBA Code | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 3 | PFPDBA | DBA Code | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 4 | PFPRTR | Transaction No. - Payroll | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 5 | PFDWK | Date - Worked | Date | Generic Edit | 6 | 0 | |
| 6 | PFPWFRT | Prevailing Wage Fringe Rate | Numeric | Generic Edit | 15 | 3 | Allow NULL? |
| 7 | PFPWAR | Prevailing Wage Annualize Rate Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 8 | PFPWHR | Prevailing Wage Hours | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 9 | PFPWMULT | Prevailing Wage Multiplier | Numeric | Generic Edit | 5 | 2 | Allow NULL? |
| 10 | PFCKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 11 | PFPAYD | Payroll ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 12 | PFPWCH05 | Prevailing Wage Generic Character 05 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 13 | PFPWCH06 | Prevailing Wage Generic Character 06 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 14 | PFPWCH07 | Prevailing Wage Generic Character 07 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 15 | PFPWJD05 | Prevailing Wage Generic Date 05 | Date | Generic Edit | 6 | 0 | |
| 16 | PFPWJD06 | Prevailing Wage Generic Date 06 | Date | Generic Edit | 6 | 0 | |
| 17 | PFPWJD07 | Prevailing Wage Generic Date 07 | Date | Generic Edit | 6 | 0 | |
| 18 | PFPWST05 | Prevailing Wage Generic String 05 | String | Generic Edit | 20 | 0 | Allow NULL? |
| 19 | PFPWST06 | Prevailing Wage Generic String 06 | String | Generic Edit | 20 | 0 | Allow NULL? |
| 20 | PFPWST07 | Prevailing Wage Generic String 07 | String | Generic Edit | 40 | 0 | Allow NULL? |
| 21 | PFPWMN05 | Prevailing Wage Generic Math Numeric 05 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 22 | PFPWMN06 | Prevailing Wage Generic Math Numeric 06 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 23 | PFPWMN07 | Prevailing Wage Generic Math Numeric 07 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 24 | PFUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 25 | PFPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 26 | PFJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 27 | PFUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 28 | PFUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
