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 |