| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| RPTNGYR | Reporting Year |
Integer | 2 | View | |
| LASTNAME | Last Name |
String | 22 | View | |
| FRSTNAME | First Name |
String | 16 | View | |
| MIDLNAME | Middle Name |
String | 16 | View | |
| ADDRESS1 | Address 1 |
String | 62 | View | |
| ADDRESS2 | Address 2 |
String | 62 | View | |
| ADDRESS3 | Address 3 |
String | 62 | View | |
| CITY | City |
String | 36 | View | |
| STATE | State |
String | 30 | View | |
| ZIPCODE | Zip Code |
String | 12 | View | |
| EMPLOYID | Employee ID |
String | 16 | View | |
| SOCSCNUM | Social Security Number |
String | 16 | View | |
| DEPRTMNT | Department |
String | 8 | View | |
| GROSDIST | Gross Distribution |
Currency | 10 | View | |
| TXBAMNDT | Taxable Amount Not Determined |
Boolean | 2 | View | |
| TAMD1099 | Taxable Amt Dtrmnd 1099 |
Currency | 10 | View | |
| TOTDSTCB | Total Distribution CB |
Boolean | 2 | View | |
| CAPTLGAIN | Capital Gain |
Currency | 10 | View | |
| FEDITXWH | Federal Income Tax W/H |
Currency | 10 | View | |
| EMPLECTR | Employee Contributions |
Currency | 10 | View | |
| NTREALAP | Net Realized Appreciation |
Currency | 10 | View | |
| DSTCODE1 | Distribution Code 1 |
String | 2 | View | |
| DSTCODE2 | Distribution Code 2 |
String | 2 | View | |
| DSTCODE3 | Distribution Code 3 |
String | 2 | View | |
| IRASEPCB | IRA/SEP CB |
Boolean | 2 | View | |
| OTAM1099 | Other Amount 1099-R |
Currency | 10 | View | |
| OTPC1099 | Other Percentage 1099-R |
Currency | 10 | View | |
| TTLTDSTPC | Total Distribution Percentage |
Currency | 10 | View | |
| STATWGS1 | State Wages-1 |
Currency | 10 | View | |
| STATWGS2 | State Wages-2 |
Currency | 10 | View | |
| STAINTX1 | State Income Tax-1 |
Currency | 10 | View | |
| STAINTX2 | State Income Tax-2 |
Currency | 10 | View | |
| STATECD1 | State Code-1 |
String | 4 | View | |
| STATECD2 | State Code-2 |
String | 4 | View | |
| ESTIDNR1 | Employer State ID Number-1 |
String | 22 | View | |
| ESTIDBR2 | Employer State ID Number-2 |
String | 22 | View | |
| LCLWGES1 | Local Wages-1 |
Currency | 10 | View | |
| LCLWGS2 | Local Wages-2 |
Currency | 10 | View | |
| LCLINTX1 | Local Income Tax-1 |
Currency | 10 | View | |
| LCLINTX2 | Local Income Tax-2 |
Currency | 10 | View | |
| LCLCODE1 | Local Code-1 |
String | 8 | View | |
| LCLCODE2 | Local Code-2 |
String | 8 | View | |
| Y1099RFC | Year End 1099R Forms Count |
Long Integer | 4 | View | |
| EMPLSUFF | Employee Suffix |
String | 6 | View |