Third-Party Tax Filing Extract Tax Codes

The third-party tax filing extracts identify wage and tax data with tax codes. The Third-Party Tax Filing Interface uses these codes to communicate the necessary info to your third-party tax filing supplier.

A tax code is unique to Oracle Cloud and is a concatenation of:

• Tax name, such as:

  • FIT

  • FLI

  • SIT

  • SS

• State abbreviation, such as:

  • IN

  • OH

• Geocode county data, such as:

  • 059 for Orange County, Indiana

  • 043 for Erie County, Ohio

• Geocode city data, such as 2200 for Sandusky, Ohio

• Regional identifier, such as:

  • CNTY

  • CITY

  • SCH

  • HT

  • MH

• Tax type, such as:

  • EE for "employee tax"

  • ER for "employer tax"

• Other identifiers, such as R for "resident tax"

The third-party tax filing supplier uses these codes to map to their internal tax identifiers for reporting.

Here are some examples.

Tax code	Jurisdiction	What it represents
FIT	Federal	Federal income tax (FIT)
FUTA	Federal	Federal unemployment tax (FUTA)
GAFUTA	State	Georgia federal unemployment taxable wages Note: Used for current and former FUTA credit reduction states. Only taxable wages are passed. Used by ADP for state credit-reduction calculations. Refer to ADP documentation for further details.
GASIT	State	Georgia state income tax (SIT)
GASUI	State	Georgia state unemployment (SUI) tax
IN117CNTY	County	Orange county, Indiana nonresident tax
IN117CNTYR	County	Orange county, Indiana resident tax
KY00005SCH	School	Fayette county, Kentucky school district tax Note: In this case, 00005 represents the geocode for the Fayette county school district.
KY015CNTYMH	County Other	Boone County, Kentucky Mental Health nonresident tax
KY037CNTYMSC	County Miscellaneous	Campbell County, Kentucky Senior Citizen nonresident tax
MEDICARE_EE	Federal	Employee Medicare tax
MEDICARE_EE_SUR	Federal	Employee Medicare surcharge tax Note: ADP requires you pass this tax code on the quarterly tax file only.
MEDICARE_ER	Federal	Employer Medicare tax
NJFLI_EE	State Family Leave	New Jersey Family Leave Insurance (FLI) employee tax
NY0052010CITYR NY0472010CITYR NY0612010CITYR NY0812010CITYR NY0852010CITYR	City	New York City, New York resident taxes Note: For full-year residents in these tax codes, the extract always passes federal wage balances from FIT tax code for quarterly and yearly wage balances. For part-year residents, the city wage balances are passed.
NY1193230CITY	City	Yonkers, New York nonresident tax Note: For Yonkers, the extract always passes federal wage balances from the FIT tax code for quarterly and yearly wage balances.
NY1193230CITYR	City	Yonkers, New York resident tax Note: For Yonkers, the extract always passes federal wage balances from the FIT tax code for quarterly and yearly wage balances.
NYFLI_EE	State Family Leave	New York FLI employee tax Note: Not all third-party suppliers support the filing of this tax.
OH0432200CITY	City	Sandusky, Ohio nonresident tax Note: In this case, 043 represents the geocode for Erie county, and 2200 is the geocode for Sandusky. Nonresident tax codes apply to cities and counties only, excluding Pennsylvania Act 32 jurisdictions.
OH0432200CITYR	City	Sandusky, Ohio resident tax Note: In this case, 043 represents the geocode for Erie county, and 2200 is the geocode for Sandusky. Resident tax codes apply to cities and counties only, excluding Pennsylvania Act 32 jurisdictions.
OR0390180MSC_EE OR0390180MSC_ER	City Other	Eugene, Oregon Safety Tax for employee and employer Note: In this case, 039 represents the geocode for Lane county, and 0180 represents the geocode for Eugene.
ORMETRO_EE	State Other	Portland Oregon Metro Supportive Housing Services employee tax
ORTRANSIT_EE	State Other	Oregon Transportation employee tax
PA0193435HT	Local Services Tax	Butler county, Middlesex township, Pennsylvania local services tax (LST) Note: In this case, 019 represents the geocode for Butler county, and 3435 represents the geocode for Middlesex township.
PA0655656CITY	Pennsylvania Act 32 Locals	Jefferson county, Washington township, city, and school district tax Note: Pennsylvania Act 32 tax codes represent the worked jurisdiction of where the wages and taxes are remitted. The city and school info is combined and reported to the worked jurisdiction tax code.
SS_EE	Federal	Employee Social Security tax
SS_ER	Federal	Employer Social Security tax
STATE Name Missing	State	For scenarios where incorrect data prevents the state name from being derived, the audit report displays this as the tax code. Note: The output file truncates this to STATE Name Miss. You must correct the data before submitting your final file to your tax-filing supplier. For further info, see Troubleshoot the Third-Party Tax Filing Interface in the Help Center.
VTMISC_EE	State Other	Employee Vermont Child Care Contribution
VTMISC_ER	State Other	Employer Vermont Child Care Contribution
WAFLI_EE	State Family Leave	Washington FLI employee tax Note: This tax code includes both FLI and medical leave (MLI) employee contributions.
WALTC_EE	State Long Term Care	Washington Long Term Care (LTC) employee tax
WAMLI_ER	State Medical Leave	Washington MLI employer tax