| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| EMPLOYID | Employee ID |
String | 16 | View | |
| PERIODID | Period ID |
Integer | 2 | View | |
| YEAR1 | Year |
Integer | 2 | View | |
| Reported_Tips | Reported Tips |
Currency | 10 | View | |
| Charged_Tips | Charged Tips |
Currency | 10 | View | |
| FDTXTIPS | Federal Tax on Tips |
Currency | 10 | View | |
| FICASS_Tips_Fiscal | FICA/SS Tips Fiscal |
Currency | 10 | View | |
| FICSTPTX | FICA/SS Tax on Tips |
Currency | 10 | View | |
| Uncollected_FICASS_Tax_F | Uncollected FICA/SS Tax Fiscal |
Currency | 10 | View | |
| FICAMed_Tips_Fiscal | FICA/Med Tips Fiscal |
Currency | 10 | View | |
| FICMTPTX | FICA/Med Tax on Tips |
Currency | 10 | View | |
| Uncollect_FICAMed_Tx_Fis | Uncollected FICA/Med Tax Fiscal |
Currency | 10 | View | |
| Reported_Receipts | Reported Receipts |
Currency | 10 | View | |
| Charged_Receipts | Charged Receipts |
Currency | 10 | View | |
| Allocated_Tips_Fiscal | Allocated Tips Fiscal |
Currency | 10 | View | |
| Federal_Tips_Fiscal | Federal Tips Fiscal |
Currency | 10 | View |