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 |