What are the tax codes used by the third-party tax filing extracts?

The third-party tax filing extracts identify wage and tax data through 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
CO0050850HT CO0050850HT_ER	Occupational Privilege Tax	Glendale, Colorado Occupational Privilege tax for employee and employer Note: In this case, 005 represents the geocode for Arapahoe county, and 0850 represents the geocode for Glendale.
DEPLI_EE DEPLI_ER	State Parental Leave	Delaware Parental Leave Insurance for employee and employer
DEPLI_ER	State Parental Leave	Employer Delaware Parental Leave Insurance
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
MAMISC_ER	State Other	Massachusetts Employer Medical Assistance Contribution
MEDICARE_EE MEDICARE_ER	Federal	Medicare tax for employee and employer
MEDICARE_EE_SUR	Federal	Employee Medicare surcharge tax Note: ADP requires you pass this tax code on the quarterly tax file only.
MNFLISX_EE MNFLISX_ER	State Family Leave	Minnesota Family Leave Insurance tax for employee and employer Note: Used only for cases where: Employer is exempt from SUI and subject to PFML Employee is exempt from SUI and subject to PFML
MNMLISX_EE MNMLISX_ER	State Family Leave	Minnesota Medical Leave Insurance tax for employee and employer Used only for cases where: Employer is exempt from SUI and subject to PFML Employee is exempt from SUI and subject to PFML
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	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 SS_ER	Federal	Social Security tax for employee and employer
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 VTMISC_ER	State Other	Vermont Child Care Contribution for employee and employer
WAFLI_EE WAFLI_EF	State Family Leave	Washington FLI tax for employee and employer
WALTC_EE	State Long Term Care	Washington Long Term Care (LTC) employee tax
WAMLI_EE WAMLI_ER	State Medical Leave	Washington MLI employee tax for employee and employer