| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| RPTNGYR | Reporting Year |
Integer | 2 | View | |
| MCRQGEMP | Medicare Qualified Govt Employee |
Boolean | 2 | View | |
| DEPRTMNT | Department |
String | 8 | View | |
| LASTNAME | Last Name |
String | 22 | View | |
| FRSTNAME | First Name |
String | 16 | View | |
| MIDLNAME | Middle Name |
String | 16 | View | |
| SEQNUMBR | Sequence Number |
Long Integer | 4 | 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 | |
| Foreign_Address | Foreign Address |
Boolean | 2 | View | |
| Foreign_StateProvince | Foreign State/Province |
String | 24 | View | |
| Foreign_Postal_Code | Foreign Postal Code |
String | 16 | View | |
| CCode | Country Code |
String | 8 | View | |
| W2CTRNBR | W2 Control Number |
String | 8 | View | |
| EMPLOYID | Employee ID |
String | 16 | View | |
| SOCSCNUM | Social Security Number |
String | 16 | View | |
| W2BFSTEM | W2 Box For Statutory Employee |
Boolean | 2 | View | |
| W2BFDCSD | W2 Box For Deceased |
Boolean | 2 | View | |
| W2BFPPLN | W2 Box For Pension Plan |
Boolean | 2 | View | |
| W2BFLREP | W2 Box For Legal Representative |
Boolean | 2 | View | |
| W2BF942E | W2 Box For 942 Employee |
Boolean | 2 | View | |
| W2BFSTTL | W2 Box For Subtotal |
String | 2 | View | |
| W2BFDCMP | W2 Box For Deferred Compensation |
Boolean | 2 | View | |
| WGTPCOMP | Wages, Tips, Other Compensation |
Currency | 10 | View | |
| FEDITXWH | Federal Income Tax W/H |
Currency | 10 | View | |
| SSECWAGS | Social Security Wages |
Currency | 10 | View | |
| SSTXWHLD | Social Security Tax Withheld |
Currency | 10 | View | |
| MCRWGTPS | Medicare Wages and Tips |
Currency | 10 | View | |
| MDCRTXWH | Medicare Tax Withheld |
Currency | 10 | View | |
| SSECTIPS | Social Security Tips |
Currency | 10 | View | |
| ALOCTIPS | Allocated Tips |
Currency | 10 | View | |
| ADEICPMT | Advance EIC Payment |
Currency | 10 | View | |
| DEPCRBFT | Dependent Care Benefits |
Currency | 10 | View | |
| NQLFPLNS | Nonqualified Plans |
Currency | 10 | View | |
| BNINCWGS | Benefits Included in Wages |
Currency | 10 | View | |
| W2FRMCTR | W2 Forms Counter |
Long Integer | 4 | View | |
| NOTEINDX | Note Index |
Currency | 10 | View | |
| STRINGARRAY_1 | String Array[1] |
String | 32 | View | |
| STRINGARRAY_2 | String Array[2] |
String | 32 | View | |
| STRINGARRAY_3 | String Array[3] |
String | 32 | View | |
| STRINGARRAY_4 | String Array[4] |
String | 32 | View | |
| STRINGARRAY_5 | String Array[5] |
String | 32 | View | |
| LONGINTARRAY_1 | Long Integer Array[1] |
Long Integer | 4 | View | |
| LONGINTARRAY_2 | Long Integer Array[2] |
Long Integer | 4 | View | |
| LONGINTARRAY_3 | Long Integer Array[3] |
Long Integer | 4 | View | |
| LONGINTARRAY_4 | Long Integer Array[4] |
Long Integer | 4 | View | |
| LONGINTARRAY_5 | Long Integer Array[5] |
Long Integer | 4 | View | |
| EMPLSUFF | Employee Suffix |
String | 6 | View |