This page (revision-96) was last changed on 26-Nov-2021 10:22 by Meg McFarland

This page was created on 26-Nov-2021 10:22 by jmyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
96 26-Nov-2021 10:22 66 KB Meg McFarland to previous
95 26-Nov-2021 10:22 66 KB Meg McFarland to previous | to last
94 26-Nov-2021 10:22 66 KB Meg McFarland to previous | to last
93 26-Nov-2021 10:22 65 KB mmcfarland to previous | to last
92 26-Nov-2021 10:22 81 KB mmcfarland to previous | to last
91 26-Nov-2021 10:22 102 KB mmcfarland to previous | to last
90 26-Nov-2021 10:22 102 KB mmcfarland to previous | to last
89 26-Nov-2021 10:22 102 KB mmcfarland to previous | to last
88 26-Nov-2021 10:22 102 KB mmcfarland to previous | to last
87 26-Nov-2021 10:22 105 KB mmcfarland to previous | to last
86 26-Nov-2021 10:22 105 KB mmcfarland to previous | to last
85 26-Nov-2021 10:22 105 KB eyeung to previous | to last
84 26-Nov-2021 10:22 105 KB eyeung to previous | to last
83 26-Nov-2021 10:22 102 KB eyeung to previous | to last
82 26-Nov-2021 10:22 100 KB eyeung to previous | to last
81 26-Nov-2021 10:22 100 KB eyeung to previous | to last

Page References

Incoming links Outgoing links
Tax Reporting - US General
Tax Reporting - US General

Version management

Difference between version and

At line 381 changed 3 lines
;IDFD FORM:HL$US-W2-YYYY: Supplied, where ‘YYYY’ denotes the tax reporting year
;IDFD FORM TYPE:US EFW2 definition: Defines the W2 definition is for the EFW2 filing format
|IDFD FORM|HL$US-W2-YYYY|System supplied. ‘YYYY’ denotes the tax reporting year
|IDFD FORM TYPE|US EFW2 definition|Defines the W2 definition for EFW2 filing format
\\
At line 385 removed 2 lines
IDFD FORM: HL$US-W2-2016 - system supplied\\
IDFD FORM TYPE: US W2 EFW2 - defines the W2 definition for EFW2 filing format\\
At line 388 removed 121 lines
;Form Code ‘HL$US-W2-2016’ Identifiers:
||Field Identifier||Description||Suggested Field Source||Suggested Variable
|* SUB-ER-EIN|Submitter’s Employer EIN|Constant|9 character EIN
|* SUB-USER-ID|Submitter User Identification|Constant|8 character User ID assigned to the employee who is attesting to the accuracy of the file
|SUB-RESUB-IND|Resubmitt Indicator|Constant|Enter 1 if file is resubmitted, otherwise 0
|SUB-RESUB-WFID|Resubmitt SSA WFID from notice|Constant|If resubmitted, enter SSA WFID from notice
|SUB-VENDOR|Software Vendor Code|Constant|Enter your company data
|SUB-SOFTWARE|Submitter Software Code|Constant|Enter your company data
|SUB-COMP-NAME|Company Name receive EFW2|Constant|Enter Company name who receives EFW2
|SUB-COMP-LOCN|Company Location Address|Constant|Enter company’s location address\\ such as Attention, Suite, Room # etc
|SUB-COMP-DELIV|Company Delivery Address|Constant|Enter company’s delivery address\\such as Street or Post Office Box
|SUB-COMP-CITY|Company’s City|Constant|Enter company’s city
|SUB-COMP-STATE|Company’s State Abbrev|Constant|Enter company’s State Abbreviation
|SUB-COMP-ZIP|Company’s ZIP Code|Constant|Enter company’s ZIP code
|SUB-COMP-ZIP-EXT|Company’s ZIP Code Extension|Constant|Enter company’s ZIP code extension
|SUB-COMP-F-STATE|Company’s foreign State/province|Constant|Enter company’s foreign State/Province
|SUB-COMP-F-POST|Company’s foreign postal code|Constant|Enter company’s foreign postal code
|SUB-COMP-COUNTRY|Company’s country if applicable|Constant|Enter company’s Country if applicable
|* SUB-SUBM-NAME|Submitter Organization Name|Constant|Organization Name to receive unprocessed data
|* SUB-SUBM-LOCN|Submitter Location Address|Constant|Enter submitter location address\\ such as Attention, Suite, Room # etc
|* SUB-SUBM-DELIV|Submitter Delivery Address|Constant|Enter submitter delivery address\\such as Street or Post Office Box
|* SUB-SUBM-CITY|Submitter City|Constant|Enter submitter city
|* SUB-SUBM-STATE|Submitter State Abbrev|Constant|Enter submitter State Abbreviation
|* SUB-SUBM-ZIP|Submitter ZIP Code|Constant|Enter submitter ZIP code
|SUB-SUBM-ZIP-EXT|Submitter ZIP Code Extension|Constant|Enter submitter ZIP code extension
|SUB-SUBM-F-STATE|Submitter foreign State/province|Constant|Enter submitter foreign State/Province
|SUB-SUBM-F-POST|Submitter foreign postal code|Constant|Enter submitter foreign postal code
|SUB-SUBM-COUNTRY|Submitter country if applicable|Constant|Enter submitter Country, if applicable
|* SUB-CONT-NAME|Contact name for SSA|Constant|Enter your company data
|* SUB-CONT-TEL|Contact telephone # for SSA|Constant|Enter your company data
|SUB-CONT-TEL-EXT|Contact telephone extension|Constant|Enter your company data
|* SUB-CONT-EMAIL|Contact e-mail address for SSA|Constant|Enter your company data
|SUB-CONT-FAX|Contact FAX phone # for SSA|Constant|Enter your company data
|SUB-CONT-METH|Preferred Contact method|Constant|MUST be BLANK
|SUB-PREPARER|Preparer Code|Constant|Enter your company data
|SUB-3RD-PARTY-SICK|Third-Party Sick Pay Indicator|Constant|Enter your company data
|SUB-3RD-PARTY-TAX|Income Tax Withheld by 3rd Party|Constant|Enter your company data
|W2-ER-AGENT-IND|Agent Indicator Code|Constant|Enter appropriate code, if applicable
|W2-ER-FOR-EIN|Agent for which EIN|Constant|If you are an agent, enter the EIN for which you are an agent for
|W2-ER-TERM-BUS|Terminating business indicator|Constant|Enter appropriate code from SSA
|W2-ER-ESTAB|Establishment Number|Constant|Further identify within EIN
|W2-ER-OTHER-EIN|Other EIN|Constant|Other EIN used
|* W2-ER-EIN|Employer Identification Number|Data Base Column|DGV.GOVT_REGIST_NUMBER
|* W2-ER-NAME|Employer Name|Data Base Column|DED.ENTITY_NAME
|W2-ER-LOCN-ADDR|Employer Location Address|Constant|Employer’s location address\\such as Attention, Suite, Room # etc.\\DLN.ADDRESS_LINE_2 or DLN.MAIL_ADDRESS_LINE_2\\ \\Enter the word MAIL or blank\\To use Primary address, leave this blank\\To use Mailing address, enter the word MAIL\\System will derive the complete primary or mailing address and store in the Address Identifiers.
|W2-ER-DELIV-ADDR|Employer Delivery Address|Constant|Employer’s delivery address\\such as Street or Post Office Box\\DLN.ADDRESS_LINE_1 or DLN.MAIL_ADDRESS_LINE_1\\ \\Enter blank, system derived
|W2-ER-CITY|Employer City|Constant|Employer’s city\\DLN.LOCALITY or DLN.MAIL_LOCALITY\\Enter blank, system derived
|W2-ER-STATE|Employer State Abbrev|Constant|Employer’s State abbreviation\\DSP.STATE_PROVINCE_CODE\\Enter blank, system derived
|W2-ER-ZIP|Employer ZIP Code|Constant|Employer’s ZIP Code\\DLN.ZIP_POSTAL or DLN.MAIL_ZIP_POSTAL\\Enter blank, system derived
|W2-ER-ZIP-EXT|Employer ZIP Extension|Constant|Employer’s ZIP Code\\DLN.ZIP_POSTAL or DLN.MAIL_ZIP_POSTAL\\Enter blank, system derived
|W2-ER-F-STATE|Employer foreign State/province|Constant|Employer foreign state/province or Constant\\Enter the word NAME or blank
|W2-ER-F-POSTAL|Employer foreign postal code|Constant|Enter Employer foreign postal code or Constant
|W2-ER-COUNTRY|Employer country if applicable|Constant|Enter Employer country\\Enter blank, system derived
|W2-ER-F-COUNTRY|Employer foreign country|Constant|Enter the word NAME, ISO or blank
|W2-ER-TAX-JURIS|Tax Jurisdiction Code|Constant |Enter appropriate code or null
|W2-EE-SSN|Employee Social Security Number|Data Base Column|EID.GOVERNMENT_CODE
|W2-EE-FIRST-NAME|Employee First Name|Data Base Column|EID.FIRST_NAME
|W2-EE-MIDDLE|Employee Middle Name|Data Base Column|EID.MIDDLE_NAME
|W2-EE-LAST-NAME|Employee Last Name|Data Base Column|EID.LAST_NAME
|W2-EE-SUFFIX|Employee Suffix Name|Data Base Column|EID.RANK with derivation expression\\Decode(~,’01’,’JR’,’02’,’SR’,NULL)
|W2-EE-LOCN-ADDR|Employee Location Address|Constant|Employee’s location address\\such as Attention, Suite, Room # etc\\ \\EPS.ADDRESS_LINE_2\\EPS.MAIL_ADDRESS_LINE_2\\\ \\Enter the word MAIL or blank\\To use Primary address, leave this blank.\\To use Mailing address, enter the word MAIL.\\System will derive the complete primary or mailing address and store in the Address Identifiers.
|W2-EE-DELIV-ADDR|Employee Delivery Address|Constant|Employee’s delivery address\\such as Street or Post Office Box\\ \\EPS.ADDRESS_LINE_2 or EPS.MAIL_ADDRESS_LINE_2\\ \\Enter blank, system derived
|W2-EE-CITY|Employee City|Constant|Employee’s city\\EPS.LOCALITY or EPS.MAIL_LOCALITY\\Enter blank, system derived
|W2-EE-STATE|Employee State Abbrev|Constant|Employee’s State abbreviation\\DSP.STATE_PROVINCE_CODE\\Enter blank, system derived
|W2-EE-ZIP|Employee ZIP Code|Constant|Employee’s ZIP Code\\EPS.ZIP_POSTAL or EPS.MAIL_ZIP_POSTAL\\Enter blank, system derived
|W2-EE-ZIP-EXT|Employee ZIP Extension|Constant|Enter employee’s ZIP Code\\EPS.ZIP_POSTAL or EPS.MAIL_ZIP_POSTAL\\Use derivation expression substr(~,6) for ZIP extension
|W2-EE-F-STATE|Employee foreign State/province|Constant|Employee foreign state/province or Constant\\Enter the word NAME or blank
|W2-EE-F-POSTAL|Employee foreign postal code|Constant|Employee foreign postal code\\Enter blank, system derived
|W2-EE-COUNTRY|Employee country if applicable|Constant|Enter Employee country\\Enter blank, system derived
|W2-EE-F-COUNTRY|Employer foreign country|Constant|Enter the word NAME or the word ISO or blank
|W2-CONTROL-PRT|Print Control Number on Form|Constant|Null, 0 – Do not print Control Number on W2 Form\\1 - Print Control Number as defined in W2-CONTROL-NUM Identifier\\2 - Print Control Number as defined from RPYEU ‘Sort Level By’ prompt\\3 - Print W2-CONTROL-NUM Identifier and Person Code\\4 - Print ‘Sort Level By’ prompt and Person Code\\5 - Print ‘Sort Level By’ prompt and W2-CONTROL-NUM Identifier\\6 - Print ‘Sort Level By’ prompt and W2-CONTROL-NUM Identifier and Person Code
|W2-CONTROL-NUM|Control Number on Form|Data Base Column|Enter your company data
|W2-EXCLUDE-EE|Exclude Employee|Data Base Column|Enter your company data
|W2-FIT-WAGE|Wages, Tips, Other Compensation|Element|W2-BOX-01
|W2-FIT-TAX|Federal Income Tax Withheld|Element|W2-BOX-02
|W2-SSN-WAGE|Social Security Wages|Element|W2-BOX-03\\Derivation expression LEAST(~,113700.00) may be used for year 2013 max\\ \\System verify Box 3 + Box 7 does not exceed annual max, otherwise issue message
|W2-SSN-TAX|Social Security Tax Withheld|Element|W2-BOX-04\\Derivation expression LEAST(~,7049.40)may be used for year 2013 max
|W2-MEDI-WAGE|Medicare Wages and Tips|Element|W2-BOX-05
|W2-MEDI-TAX|Medicare Tax Withheld|Element|W2-BOX-06
|W2-SSN-TIP|Social Security Tips|Element|W2-BOX-07
|W2-ALLOC-TIP|Allocated Tips|Element|W2-BOX-08
|W2-EIC|Advanced EIC Credit|Element|W2-BOX-09
|W2-DEP-CARE|Dependent Care Benefit|Element|W2-BOX-10
|W2-NQUAL|Non Qualified Plans|Element|W2-BOX-11
|W2-NQUAL-457|Non Qualified Plans Sect 457|Element|W2-BOX-11-457
|W2-NQUAL-N457|Non Qualified Plans Not Sect 457|Element|W2-BOX-11-N457
|W2-CODE-A|Uncollect SSA/RRTA tax on tips|Pay Component|Enter your company data
|W2-CODE-B|Uncollect Medicare tax on tips|Pay Component|Enter your company data
|W2-CODE-C|Group Term Life Ins > 50000|Pay Component|Enter your company data
|W2-CODE-D|Deferred 401(k) cash|Pay Component|Enter your company data
|W2-CODE-E|Deferred 401(b) Salary reduction|Pay Component|Enter your company data
|W2-CODE-F|Deferred 408(k)(6) Salary reduct|Pay Component|Enter your company data
|W2-CODE-G|Deferred 457(b) compensation|Pay Component|Enter your company data
|W2-CODE-H|Deferred 501(c)18(D) tax exempt|Pay Component|Enter your company data
|W2-CODE-J|Non taxable sick pay|Pay Component|Enter your company data
|W2-CODE-K|20% excise parachute payment|Pay Component|Enter your company data
|W2-CODE-L|Employee business expense reimburse|Pay Component|Enter your company data
|W2-CODE-M|Uncollect SSA/RRTA group ins|Pay Component|Enter your company data
|W2-CODE-N|Uncollect medicare group ins|Pay Component|Enter your company data
|W2-CODE-P|Moving expense|Pay Component|Enter your company data
|W2-CODE-Q|Nontaxable combat pay|Pay Component|Enter your company data (obsoleted since Tax Year 2012)
|W2-CODE-R|Employer Contrib to MSA|Pay Component|Enter your company data
|W2-CODE-S|Salary reduction to 408(p)|Pay Component|Enter your company data
|W2-CODE-T|Adoption benefits|Pay Component|Enter your company data
|W2-CODE-V|Income of nonstat stock opt|Pay Component|Enter your company data
|W2-CODE-W|ER contrib Health Saving Account|Pay Component|Enter your company data
|W2-CODE-Y|Deferrals 409A Nonqual plan|Pay Component|Enter your company data
|W2-CODE-Z|Income 409A Nonqual plan|Pay Component|Enter your company data
|W2-CODE-AA|Roth contrib 401(k)|Pay Component|Enter your company data
|W2-CODE-BB|Roth contrib 403(b)|Pay Component|Enter your company data
|W2-CODE-CC|HIRE exempt wages|Pay Component|Enter your company data
|W2-CODE-DD|ER sponsored Health Coverage|Pay Component|Enter your company data
|W2-CODE-EE|Roth Contribution 457(b)|Pay Component|Enter your company data
\\ \\
The values from W2-OTHER-01 to W2-OTHER-20 are printed on W2 Form Box 14.
||Field Identifier||Description||Suggested Field Source||Suggested Variable
|W2-OTHER-01|Your company description|Pay Component|Enter your company data
|W2-OTHER-nn|Your company description|Pay Component|Enter your company data
|W2-OTHER-20|Your company description|Pay Component|Enter your company data
\\ \\
Please enter Box 14 Description in the Prompt field in the format of 14-xxxxxxx.
At line 510 changed 5 lines
The values from W2-USER-01 to W2-USER-20 are used by CLIENTS only, the values are not printed on the W2 form or file. These identifiers are used to obtain amounts to show on the RPYEU Summary report. Example: 125 plan, 401 plan, benefit amounts, or employer portion of certain employee contribution etc.
||Field Identifier||Description||Suggested Field Source||Suggested Variable
|W2-USER-01|Your company description|Pay Component|Enter your company data
|W2-USER-nn|Your company description|Pay Component|Enter your company data
|W2-USER-20|Your company description|Pay Component|Enter your company data
[{InsertPage page='IDFDV_Form_Definitions'}]
At line 516 removed 52 lines
The values from W2-HL-01 to W2-HL-10 are used by High Line only. These identifiers are used to obtain amounts to show on RPYEU Summary report or for other purposes. These are reserved areas for High Line to define additional new variables that are not available or defined when the programming is done. If needed, High Line will give instructions for users to set these up.
||Field Identifier||Description||Suggested Field Source||Suggested Variable
|W2-HL-01|High Line defined description|Pay Component|Enter your company data
|W2-HL-nn|High Line defined description|Pay Component|Enter your company data
|W2-HL-10|High Line defined description|Pay Component|Enter your company data
|| || || ||
|W2-STAT-EE|Statutory employee|Statistics|Enter your company data
|W2-RETIRE-PLAN|Retirement plan employee|Statistics|Enter your company data
|W2-3PARTY-SICK|Third-party sick pay|Statistics|Enter your company data
|| || || ||
|W2-SCHL-WAGE|School Taxable Wages|Element|W2-SCHL-WAGE
|W2-SCHL-TAX|School Tax|Element |W2-SCHL-TAX
|| || || ||
|W2-STATE-CODE|State Code|Data Base Column|DSP.STATE_PROVINCE_CODE
|W2-STATE-REGIST|State Registration I.D. No|Data Base Column|DGV.GOVT_REGIST_NUMBER
|W2-STATE-WAGE-HOME|State Wages and Tips (Home State)|Element|W2-STATE-WAGE-H
|W2-STATE-WAGE-WORK|State Wages and Tips (Work State)|Element|W2-STATE-WAGE-W
|W2-STATE-TAX-HOME|State Income Tax (Home State)|Element|W2-STATE-TAX-H
|W2-STATE-TAX-WORK|State Income Tax (Work State)|Element|W2-STATE-TAX-W
|| || || ||
|W2-SUI-WAGE-EE|State SUI Wages (Employee)|Element|W2-SUI-WAGE-EE
|W2-SUI-WAGE-ER|State SUI Wages (Employer)|Element|W2-SUI-WAGE-ER
|W2-SUI-TAX-EE|State SUI Tax (Employee contribution)|Element|W2-SUI-TAX-EE
|W2-SUI-TAX-ER|State SUI Tax (Employer contribution)|Element|W2-SUI-TAX-ER
|W2-SDI-WAGE-EE|State SDI Wages (Employee)|Element|W2-SDI-WAGE-EE
|W2-SDI-WAGE-ER|State SDI Wages (Employer)|Element|W2-SDI-WAGE-ER
|W2-SDI-TAX-EE|State SDI Tax (Employee contribution)|Element|W2-SDI-TAX-EE
|W2-SDI-TAX-ER|State SDI Tax (Employer contribution)|Element|W2-SDI-TAX-ER
|W2-SUI-HRS-WRK|SUI Hours Worked|Element|W2-SUI-HRS-WORK
|W2-SUI-WK-WRK|SUI Weeks Worked (From User)|Element|W2-SUI-WK-WORK
|W2-SUI-WEEKS-WRK|SUI Weeks Worked (Derived)|Not specified|System Derived, no need to set up
|W2-SUI-TAXABLE-WAGES|SUI Taxable Wages|Not specified|System Derived, no need to set up
|W2-SUI-EXCESS-WAGES|SUI Excess Wages|Not specified|System Derived, no need to set up
|W2-SUI-MTH1-WORK|SUI Worked on 12th day of mth 1|Not specified|System Derived, no need to set up
|W2-SUI-MTH2-WORK|SUI Worked on 12th day of mth 2|Not specified|System Derived, no need to set up
|W2-SUI-MTH3-WORK|SUI Worked on 12th day of mth 3|Not specified|System Derived, no need to set up
|W2-TIP-WAGE-WORK|Work State Tips Wages |Element|Tips Wages for each State
|W2-ST-TIP-WORK|Work State Tips|Pay Component|Tips for each State
|W2-WC-WORK|Workers Compensation Contribution|Element|W2-WC-WORK
|| || || ||
|W2-CNTY-NAME|County Name|Data Base Column|DCN.COUNTY_NAME
|W2-CN-WAGE-HOME|County Wages (Home County)|Element|W2-CNTY-WAGE-H
|W2-CN-WAGE-WORK|County Wages (Work County)|Element|W2-CNTY-WAGE-W
|W2-CN-TAX-HOME|County Tax (Home County)|Element|W2-CNTY-TAX-H
|W2-CN-TAX-WORK|County Tax (Work County)|Element|W2-CNTY-TAX-W
|| || || ||
|W2-CITY-NAME|City Name |Data Base Column|DTX.JURISDICTION_NAME
|W2-CI-WAGE-HOME|City Wages (Home City)|Element|W2-CITY-WAGE-H
|W2-CI-WAGE-WORK|City Wages (Work City)|Element|W2-CITY-WAGE-W
|W2-CI-TAX-HOME|City Tax (Home City)|Element|W2-CITY-TAX-H
|W2-CI-TAX-WORK|City Tax (Work City)|Element|W2-CITY-TAX-W
\\ \\
At line 794 changed 2 lines
|2-5|Payment Year. \\Defines the year this report is being prepared for.|From the user defined FROM-TO period, converted to YYYY
|6-14|Transmitter’s Federal EIN. \\Enter only numeric characters, omit hyphens, prefixes and suffixes.|Derived from [IDFDV] 'TRAN EIN’ Field Identifier.
|2-5|Payment Year \\Defines the year this report is being prepared for.|From the user defined FROM-TO period, converted to YYYY
|6-14|Transmitter’s Federal EIN \\Enter only numeric characters, omit hyphens, prefixes and suffixes.|Derived from [IDFDV] 'TRAN EIN’ Field Identifier.
At line 798 changed 4 lines
|24-73|Transmitter Name. \\The transmitter name of the organization submitting the file.|Derived from [IDFDV] ‘TRAN NAME’ Field Identifier.
|74-113|Transmitter Street Address. \\The street address of the organization submitting the file.|Derived from [IDFDV] ‘TRAN ADDRESS’ Field Identifier.
|114-138|Transmitter City.\\The City of the organization submitting the file.|Derived from [IDFDV] ‘TRAN CITY’ Field Identifier.
|139-140|Transmitter State. \\The standard two character FIPS postal abbreviation|Derived from [IDFDV] ‘TRAN STATE’ Field Identifier.
|24-73|Transmitter Name \\The transmitter name of the organization submitting the file.|Derived from [IDFDV] ‘TRAN NAME’ Field Identifier.
|74-113|Transmitter Street Address \\The street address of the organization submitting the file.|Derived from [IDFDV] ‘TRAN ADDRESS’ Field Identifier.
|114-138|Transmitter City\\The City of the organization submitting the file.|Derived from [IDFDV] ‘TRAN CITY’ Field Identifier.
|139-140|Transmitter State \\The standard two character FIPS postal abbreviation|Derived from [IDFDV] ‘TRAN STATE’ Field Identifier.
At line 803 changed 12 lines
|154-158|Transmitter ZIP Code. \\Enter a valid ZIP Code|Derived from [IDFDV] ‘TRAN ZIP CODE’ Field Identifier.
|159-163|Transmitter ZIP Code extension. \\Defines the four digit extension of ZIP code, if applicable. \\Includes a hyphen in position 159|Derived from [IDFDV] ‘TRAN ZIP EXTN’ Field Identifier (include ‘-‘ in position 159).
|164-193|Transmitter Contact. \\Title of individual from transmitter organization responsible for the accuracy of the wage report.|Derived from [IDFDV] ‘TRAN CONTACT’ Field Identifier.
|194-203|Transmitter Contact Telephone Number. \\Telephone number for the transmitter contact.|Derived from [IDFDV] ‘TRAN CONTACT PHONE’ Field Identifier.
|204-207|Telephone Extension/Box. \\The transmitter telephone extension or message box|Derived from [IDFDV] ‘TRAN CONTACT EXTN’ Field Identifier.
|208-213|Media Transmitter/Authorization Number. \\Identifier assigned to the entity transmitting the media.|Derived from [IDFDV] ‘TRAN MEDIA NUMBER’ Field Identifier.
|214-214|C-3 Data.|State Specific Data. If not used, enter blanks
|215-219|Suffix Code.|State Specific Data. If not used, enter blanks
|220-220|Allocation Lists.|State Specific Data. If not used, enter blanks
|221-229|Service Agent ID.|State Specific Data. If not used, enter blanks
|230-242|Total Remittance Amount.|State Specific Data. If not used, enter blanks
|243-250|Media Creation Date.\\Enter the date in the MMDDYYYY format|Derived from the System Date
|154-158|Transmitter ZIP Code \\Enter a valid ZIP Code|Derived from [IDFDV] ‘TRAN ZIP CODE’ Field Identifier.
|159-163|Transmitter ZIP Code extension \\Defines the four digit extension of ZIP code, if applicable. \\Includes a hyphen in position 159|Derived from [IDFDV] ‘TRAN ZIP EXTN’ Field Identifier (include ‘-‘ in position 159).
|164-193|Transmitter Contact \\Title of individual from transmitter organization responsible for the accuracy of the wage report.|Derived from [IDFDV] ‘TRAN CONTACT’ Field Identifier.
|194-203|Transmitter Contact Telephone Number \\Telephone number for the transmitter contact.|Derived from [IDFDV] ‘TRAN CONTACT PHONE’ Field Identifier.
|204-207|Telephone Extension/Box \\The transmitter telephone extension or message box|Derived from [IDFDV] ‘TRAN CONTACT EXTN’ Field Identifier.
|208-213|Media Transmitter/Authorization Number \\Identifier assigned to the entity transmitting the media.|Derived from [IDFDV] ‘TRAN MEDIA NUMBER’ Field Identifier.
|214-214|C-3 Data|State Specific Data. If not used, enter blanks
|215-219|Suffix Code|State Specific Data. If not used, enter blanks
|220-220|Allocation Lists|State Specific Data. If not used, enter blanks
|221-229|Service Agent ID|State Specific Data. If not used, enter blanks
|230-242|Total Remittance Amount|State Specific Data. If not used, enter blanks
|243-250|Media Creation Date\\Enter the date in the MMDDYYYY format|Derived from the System Date
At line 822 changed 4 lines
|2-5|Payment Year. \\ Enter the year for which this report is being prepared|
|6-14|Transmitter’s Federal EIN. \\Enter only numeric characters|Derived from [IDFDV] 'BASIC EIN' Field Identifier.
|15-22|Computer. \\Enter the manufacturer’s name|Derived from [IDFDV] ‘BASIC COMPUTER’ Field Identifier.
|23-24|Internal Label. \\SL, NS, NL or AL|Derived from [IDFDV] ‘BASIC INTERNAL LABEL’ Field Identifier.
|2-5|Payment Year \\ Enter the year for which this report is being prepared|
|6-14|Transmitter’s Federal EIN \\Enter only numeric characters|Derived from [IDFDV] 'BASIC EIN' Field Identifier.
|15-22|Computer \\Enter the manufacturer’s name|Derived from [IDFDV] ‘BASIC COMPUTER’ Field Identifier.
|23-24|Internal Label \\SL, NS, NL or AL|Derived from [IDFDV] ‘BASIC INTERNAL LABEL’ Field Identifier.
At line 827 changed 4 lines
|26-27|Density. \\16, 62 or 38|Derived from [IDFDV] ‘BASIC DESITY’ Field Identifier.
|28-30|Recording Code (Character Set). \\EBC.|Derived from [IDFDV] ‘BASIC RECOEDING MODE’ Field Identifier.
|31-32|Number of Tracks. \\09 or 18|Derived from [IDFDV] ‘BASIC RECORDING MODE’ Field Identifier.
|33-34|Blocking Factor. \\Enter the blocking factor of the file, not to exceed 85.|Derived from [IDFDV] ‘BLOCKING FACTOR’ Field Identifier.
|26-27|Density \\16, 62 or 38|Derived from [IDFDV] ‘BASIC DESITY’ Field Identifier.
|28-30|Recording Code (Character Set) \\EBC.|Derived from [IDFDV] ‘BASIC RECOEDING MODE’ Field Identifier.
|31-32|Number of Tracks \\09 or 18|Derived from [IDFDV] ‘BASIC RECORDING MODE’ Field Identifier.
|33-34|Blocking Factor \\Enter the blocking factor of the file, not to exceed 85.|Derived from [IDFDV] ‘BLOCKING FACTOR’ Field Identifier.
At line 833 changed 4 lines
|147-190|Organization Name. \\The name of the organization the media should be returned to|Derived from [IDFDV] ‘BASIC NAME’ Field Identifier.
|191-225|Street Address. \\The street address of the organization the media should be returned to|Derived from [IDFDV] ‘BASIC ADDRESS’ Field Identifier.
|226-245|City. \\The City of the organization the media should be returned to|Derived from [IDFDV] ‘BASIC CITY’ Field Identifier.
|246-247|State. \\Enter the standard two character FIPS postal abbreviation|Derived from [IDFDV] ‘BASIC STATE’ Field Identifier.
|147-190|Organization Name \\The name of the organization the media should be returned to|Derived from [IDFDV] ‘BASIC NAME’ Field Identifier.
|191-225|Street Address \\The street address of the organization the media should be returned to|Derived from [IDFDV] ‘BASIC ADDRESS’ Field Identifier.
|226-245|City \\The City of the organization the media should be returned to|Derived from [IDFDV] ‘BASIC CITY’ Field Identifier.
|246-247|State \\Enter the standard two character FIPS postal abbreviation|Derived from [IDFDV] ‘BASIC STATE’ Field Identifier.
At line 838 changed 2 lines
|253-257|ZIP Code. \\Enter a valid ZIP code|Derived from [IDFDV] ‘BASIC ZIP CODE’ Field Identifier.
|258-262|ZIP Code extension. \\Enter the four digit ZIP code extension, including the hyphen in position 258.\\The hyphen (‘-‘) must be included when defining the BASIC ZIP EXTN’ Field Identifier on IDFDV.|Derived from [IDFDV] ‘BASIC ZIP EXTN’ Field Identifier.
|253-257|ZIP Code \\Enter a valid ZIP code|Derived from [IDFDV] ‘BASIC ZIP CODE’ Field Identifier.
|258-262|ZIP Code extension \\Enter the four digit ZIP code extension, including the hyphen in position 258.\\The hyphen (‘-‘) must be included when defining the BASIC ZIP EXTN’ Field Identifier on IDFDV.|Derived from [IDFDV] ‘BASIC ZIP EXTN’ Field Identifier.
At line 847 changed 2 lines
|2-5|Payment Year. \\The year for which the report is being prepared|
|6-14|Federal EIN. \\Enter only numeric characters of the Federal EIN|
|2-5|Payment Year \\The year for which the report is being prepared|
|6-14|Federal EIN \\Enter only numeric characters of the Federal EIN|
At line 850 changed 4 lines
|24-73|Employer Name. \\Enter the first 50 positions of the employer’s name exactly as registered with the State UI agency.|Derived from the entity.
|74-113|Employer Street Address. \\The street address of the employer|Derived from the Entity Location.
|114-138|Employer City. \\The city of employer’s mailing address|Derived from the Entity Location.
|139-140|Employer State. \\Enter the standard two character FIPS postal abbreviation of the employer’s address|Derived from the Entity Location.
|24-73|Employer Name \\Enter the first 50 positions of the employer’s name exactly as registered with the State UI agency.|Derived from the entity.
|74-113|Employer Street Address \\The street address of the employer|Derived from the Entity Location.
|114-138|Employer City \\The city of employer’s mailing address|Derived from the Entity Location.
|139-140|Employer State \\Enter the standard two character FIPS postal abbreviation of the employer’s address|Derived from the Entity Location.
At line 855 changed 2 lines
|149-153|ZIP Code Extension. \\Enter four digit ZIP code extension, including the hyphen in position 149|Derived from the Entity Location.
|154-158|ZIP code. \\Enter a valid ZIP code|Derived from the Entity Location.
|149-153|ZIP Code Extension \\Enter four digit ZIP code extension, including the hyphen in position 149|Derived from the Entity Location.
|154-158|ZIP code \\Enter a valid ZIP code|Derived from the Entity Location.
At line 858 changed 3 lines
|160-160|Type of Employment.\\A: Agriculture \\F: Federal \\H: Household \\M: Military \\Q: Medicare Qualified Government Employees \\R: Regular, all others \\X: Railroad|Derived from [IDFDV] ‘TYPE OF EMPLOYMENT’ Field Identifier.
|161-162|Blocking Factor. \\Blocking factor of the file, not to exceed 85. Enter blanks for diskette|Derived from [IDFDV] ‘BLOCKING FACTOR’ Field Identifier.
|163-166|Establishment Number or Coverage Group/PRU. \\Enter either the establishment number of the coverage group/PRU, or Blank|Derived from [IDFDV] ‘ESTABLISHMENT NUMBER’ Field Identifier.
|160-160|Type of Employment\\A: Agriculture \\F: Federal \\H: Household \\M: Military \\Q: Medicare Qualified Government Employees \\R: Regular, all others \\X: Railroad|Derived from [IDFDV] ‘TYPE OF EMPLOYMENT’ Field Identifier.
|161-162|Blocking Factor \\Blocking factor of the file, not to exceed 85. Enter blanks for diskette|Derived from [IDFDV] ‘BLOCKING FACTOR’ Field Identifier.
|163-166|Establishment Number or Coverage Group/PRU \\Enter either the establishment number of the coverage group/PRU, or Blank|Derived from [IDFDV] ‘ESTABLISHMENT NUMBER’ Field Identifier.
At line 862 changed 8 lines
|171-172|State Identifier Code. \\Enter the State FIPS postal numeric code for the State that is being reported|
|173-187|State Unemployment Insurance Account Number. \\State UI employer account number|Derived from the IDGV State SUI Registration.
|188-189|Reporting Period. \\03, 06, 09 or 12|
|190-190|No Workers/No Wages. \\Enter ‘0’ to indicate that the ‘E’ record will not be followed by the ‘S’ record. Enter ‘1’ to indicate otherwise|
|191-191|Tax Type Code.|State Specific Data. If not used, enter blanks
|192-196|Taxing Entity Code.|State Specific Data. If not used, enter blanks
|197-203|State Control Number.|State Specific Data. If not used, enter blanks
|204-208|Unit Number.|State Specific Data. If not used, enter blanks
|171-172|State Identifier Code \\Enter the State FIPS postal numeric code for the State that is being reported|
|173-187|State Unemployment Insurance Account Number \\State UI employer account number|Derived from the IDGV State SUI Registration.
|188-189|Reporting Period \\03, 06, 09 or 12|
|190-190|No Workers/No Wages \\Enter ‘0’ to indicate that the ‘E’ record will not be followed by the ‘S’ record. Enter ‘1’ to indicate otherwise|
|191-191|Tax Type Code|State Specific Data. If not used, enter blanks
|192-196|Taxing Entity Code|State Specific Data. If not used, enter blanks
|197-203|State Control Number|State Specific Data. If not used, enter blanks
|204-208|Unit Number|State Specific Data. If not used, enter blanks
At line 871 changed one line
|256-256|Foreign Indicator. \\If data in positions 74-158 is for a foreign address, enter the letter ‘X’, otherwise, leave it blank|Derived from [IDFDV] ‘FOREIGN ADDR INDICATOR’ Field Identifier.
|256-256|Foreign Indicator \\If data in positions 74-158 is for a foreign address, enter the letter ‘X’, otherwise, leave it blank|Derived from [IDFDV] ‘FOREIGN ADDR INDICATOR’ Field Identifier.
At line 873 changed one line
|258-266|Other EIN. \\Enter blanks if no other EIN was used|Derived from [IDFDV] ‘OTHER EIN’ Field Identifier.
|258-266|Other EIN \\Enter blanks if no other EIN was used|Derived from [IDFDV] ‘OTHER EIN’ Field Identifier.
At line 881 changed one line
|2-10|Social Security Number. \\Employee’s social security number. If not known, enter ‘I’ in position 2 and blanks in position 3-10|
|2-10|Social Security Number \\Employee’s social security number. If not known, enter ‘I’ in position 2 and blanks in position 3-10|
At line 884 changed 2 lines
|43-43|Employee Middle Initial. \\Leave blank if no middle initial.|
|44-45|State Code. \\The state FIPS postal numeric code for the State being reported.|
|43-43|Employee Middle Initial \\Leave blank if no middle initial.|
|44-45|State Code \\The state FIPS postal numeric code for the State being reported.|
At line 887 changed 8 lines
|50-63|State QTR Total Gross Wages. \\Quarterly wages subject to all taxes.|Derived from [IDFDV] 'TOTAL GROSS WAGES' Field Identifier.
|64-77|State QTR Unemployment Insurance Total Wages. \\Quarterly wages subject to unemployment taxes.|Derived from [IDFDV] Field Identifier: Sequence 7200
|78-91|State QTR Unemployment Insurance Excess Wages. \\Quarterly wages in excess of the State UI taxable wage base.
|92-105|State QTR Unemployment Insurance Taxable Wages. \\State QTR UI total wages less State QTR UI excess wages.|
|106-120|Quarterly State Disability Insurance Taxable Wages.|Sate Specific Data. If not used, enter zero.
|121-129|Quarterly Tip Wages. \\Include all tip wages|
|130-131|Number of Weeks Worked. \\The number of weeks worked in the reporting period|Derived from [IDFDV] 'NUMBER OF WEEKS' Field Identifier. \\This can either be defined as a constant, be picked up from a pay component that was previously populated by a UserCalc, or, if left null, the system will compute the value.
|132-134|Number of Hours Worked.\\The number of hours worked in the reporting period|Derived from [IDFDV] 'HOURS ELEMENT' Field Identifier.
|50-63|State QTR Total Gross Wages \\Quarterly wages subject to all taxes.|Derived from [IDFDV] 'TOTAL GROSS WAGES' Field Identifier.
|64-77|State QTR Unemployment Insurance Total Wages \\Quarterly wages subject to unemployment taxes.|Derived from [IDFDV] Field Identifier: Sequence 7200
|78-91|State QTR Unemployment Insurance Excess Wages \\Quarterly wages in excess of the State UI taxable wage base.
|92-105|State QTR Unemployment Insurance Taxable Wages \\State QTR UI total wages less State QTR UI excess wages.|
|106-120|Quarterly State Disability Insurance Taxable Wages|Sate Specific Data. If not used, enter zero.
|121-129|Quarterly Tip Wages \\Include all tip wages|
|130-131|Number of Weeks Worked \\The number of weeks worked in the reporting period|Derived from [IDFDV] 'NUMBER OF WEEKS' Field Identifier. \\This can either be defined as a constant, be picked up from a pay component that was previously populated by a UserCalc, or, if left null, the system will compute the value.
|132-134|Number of Hours Worked\\The number of hours worked in the reporting period|Derived from [IDFDV] 'HOURS ELEMENT' Field Identifier.
At line 898 changed 8 lines
|162-176|Unit/Division Location/Plant Code. \\The ID assigned to identify wages by work site.|
|177-190|State Taxable Wages. \\Enter wages subject to State income tax.|
|191-204|State Income Tax withheld. \\Enter wages subject to State income tax.|
|205-206|Seasonal Indicator.|State Specific Data. If not used, enter blanks. \\Derived from [IDFDV] 'SEASONAL INDICATOR' Field Identifier.
|207-207|Employer Health Insurance Code.|State Specific Data. If not used, enter blanks.
|208-208|Employee Health Insurance Code.|State Specific Data. If not used, enter blanks.
|209-209|Probationary Code.|State Specific Data. If not used, enter blanks.
|210-210|Officer Code. \\Enter ‘1’ for Officers of the corporation. Otherwise enter ‘0’.|
|162-176|Unit/Division Location/Plant Code \\The ID assigned to identify wages by work site.|
|177-190|State Taxable Wages \\Enter wages subject to State income tax.|
|191-204|State Income Tax withheld \\Enter wages subject to State income tax.|
|205-206|Seasonal Indicator|State Specific Data. If not used, enter blanks. \\Derived from [IDFDV] 'SEASONAL INDICATOR' Field Identifier.
|207-207|Employer Health Insurance Code|State Specific Data. If not used, enter blanks.
|208-208|Employee Health Insurance Code|State Specific Data. If not used, enter blanks.
|209-209|Probationary Code|State Specific Data. If not used, enter blanks.
|210-210|Officer Code \\Enter ‘1’ for Officers of the corporation. Otherwise enter ‘0’.|
At line 907 changed 6 lines
|212-212|Month-1 Employment. \\Enter ‘1’ if the employee is covered by UI, worked or received pay for the pay period including the 12th day of the first reporting month. Otherwise enter ‘0’.|
|213-213|Month-2 Employment. \\Enter ‘1’ if the employee is covered by UI, worked or received pay for the pay period including the 12th day of the second reporting month. Otherwise enter ‘0’.|
|214-214|Month-3 Employment. \\Enter ‘1’ if the employee is covered by UI, worked or received pay for the pay period including the 12th day of the third reporting month. Otherwise enter ‘0’.|
|215-220|Reporting Quarter and Year. \\Enter the last month and year for the calendar period for the reporting period. Example: 062018 for Apr-June 2018|
|221-226|Date First Employed. \\Enter the month and year the employee was first employed, such as 072017|
|227-232|Date of Separation. \\Enter the month and year the employee separated, such as 112017|
|212-212|Month-1 Employment \\Enter ‘1’ if the employee is covered by UI, worked or received pay for the pay period including the 12th day of the first reporting month. Otherwise enter ‘0’.|
|213-213|Month-2 Employment \\Enter ‘1’ if the employee is covered by UI, worked or received pay for the pay period including the 12th day of the second reporting month. Otherwise enter ‘0’.|
|214-214|Month-3 Employment \\Enter ‘1’ if the employee is covered by UI, worked or received pay for the pay period including the 12th day of the third reporting month. Otherwise enter ‘0’.|
|215-220|Reporting Quarter and Year \\Enter the last month and year for the calendar period for the reporting period. Example: 062018 for Apr-June 2018|
|221-226|Date First Employed \\Enter the month and year the employee was first employed, such as 072017|
|227-232|Date of Separation \\Enter the month and year the employee separated, such as 112017|
At line 929 changed 17 lines
|112-122|Interest.|State Specific Data. If not used, enter blanks.
|123-133|Penalty.|State Specific Data. If not used, enter blanks.
|134-144|Credit/Overpayment.|State Specific Data. If not used, enter blanks.
|145-148|Employer Assessment Rate.|State Specific Data. If not used, enter blanks.
|149-159|Employer Assessment Amount.|State Specific Data. If not used, enter blanks.
|160-163|Employee Assessment Rate.|State Specific Data. If not used, enter blanks.
|164-174|Employee Assessment Amount.|State Specific Data. If not used, enter blanks.
|175-185|Total Payment Due.|State Specific Data. If not used, enter blanks.
|186-198|Allocation Amount.|State Specific Data. If not used, enter blanks.
|199-212|Wages subject to State Income Tax.|State Specific Data. If not used, enter blanks.
|213-226|State Income Tax withheld.|State Specific Data. If not used, enter blanks.
|227-233|Month-1 Employment for employer. \\Total number of employees covered by UI who worked or received pay for the pay period including the 12th day of the first reporting month.|Total for all ‘S’ records after the last ‘E’ record.
|234-240|Month-2 Employment. \\Total number of employees covered by UI who worked or received pay for the pay period including the 12th day of the second reporting month.|Total for all ‘S’ records after the last ‘E’ record.
|241-247|Month-3 Employment. \\Total number of employees covered by UI who worked or received pay for the pay period including the 12th day of the third reporting month.|Total for all ‘S’ records after the last ‘E’ record.
|248-250|Country Code.|State Specific Data. If not used, enter blanks.
|251-257|Outside Country Employees.|State Specific Data. If not used, enter blanks.
|258-267|Document Control Number.|State Specific Data. If not used, enter blanks.
|112-122|Interest|State Specific Data. If not used, enter blanks.
|123-133|Penalty|State Specific Data. If not used, enter blanks.
|134-144|Credit/Overpayment|State Specific Data. If not used, enter blanks.
|145-148|Employer Assessment Rate|State Specific Data. If not used, enter blanks.
|149-159|Employer Assessment Amount|State Specific Data. If not used, enter blanks.
|160-163|Employee Assessment Rate|State Specific Data. If not used, enter blanks.
|164-174|Employee Assessment Amount|State Specific Data. If not used, enter blanks.
|175-185|Total Payment Due|State Specific Data. If not used, enter blanks.
|186-198|Allocation Amount|State Specific Data. If not used, enter blanks.
|199-212|Wages subject to State Income Tax|State Specific Data. If not used, enter blanks.
|213-226|State Income Tax withheld|State Specific Data. If not used, enter blanks.
|227-233|Month-1 Employment \\Total number of employees covered by UI who worked or received pay for the pay period including \\the 12th day of the first reporting month.|Total for all ‘S’ records after the last ‘E’ record.
|234-240|Month-2 Employment \\Total number of employees covered by UI who worked or received pay for the pay period including \\the 12th day of the second reporting month.|Total for all ‘S’ records after the last ‘E’ record.
|241-247|Month-3 Employment \\Total number of employees covered by UI who worked or received pay for the pay period including the \\12th day of the third reporting month.|Total for all ‘S’ records after the last ‘E’ record.
|248-250|Country Code|State Specific Data. If not used, enter blanks.
|251-257|Outside Country Employees|State Specific Data. If not used, enter blanks.
|258-267|Document Control Number|State Specific Data. If not used, enter blanks.
At line 956 changed 9 lines
|26-40|Quarterly Total Gross Wages in File. \\QTR gross wages subject to all taxes.|Total of this field for all ‘S’ records in the file.
|41-55|Quarterly State Unemployment Insurance Total Wages in File. \\QTR wages subject to State UI tax.|Total of this field for all ‘S’ records in the file.
|56-70|Quarterly State Unemployment Insurance Excess Wages in File. \\QTR wages in excess of the State UI taxable wage base.|Total of this field for all ‘S’ records in the file.
|71-85|Quarterly State Unemployment Insurance Taxable Wages in File. \\State UI gross/total wage less quarterly State UI excess wages.|Total of this field for all ‘S’ records in the file.
|86-100|Quarterly State Disability Insurance Taxable Wages in File.|State Specific Data. If not used, enter zero.
|101-115|Quarterly Tip Wages in File. \\All tip income.|Total of this field on all ‘S’ records in the file.
|116-123|Month-1 Employment for employers in File. \\Total number of employees covered by UI who worked or received pay for the pay period including the 12th day of the first reporting month.|Total of this field on all ‘S’ records in the file.
|124-131|Month-2 Employment for employers in File. \\Total number of employees covered by UI who worked or received pay for the pay period including the 12th day of the second reporting month.|Total of this field on all ‘S’ records in the file.
|132-139|Month-3 Employment for employers in File. \\Total number of employees covered by UI who worked or received pay for the pay period including the 12th day of the third reporting month.|Total of this field on all ‘S’ records in the file.
|26-40|Quarterly Total Gross Wages in File \\QTR gross wages subject to all taxes.|Total of this field for all ‘S’ records in the file.
|41-55|Quarterly State Unemployment Insurance Total Wages in File \\QTR wages subject to State UI tax.|Total of this field for all ‘S’ records in the file.
|56-70|Quarterly State Unemployment Insurance Excess Wages in File \\QTR wages in excess of the State UI taxable wage base.|Total of this field for all ‘S’ records in the file.
|71-85|Quarterly State Unemployment Insurance Taxable Wages in File \\State UI gross/total wage less quarterly State UI excess wages.|Total of this field for all ‘S’ records in the file.
|86-100|Quarterly State Disability Insurance Taxable Wages in File|State Specific Data. If not used, enter zero.
|101-115|Quarterly Tip Wages in File \\All tip income.|Total of this field on all ‘S’ records in the file.
|116-123|Month-1 Employment \\Total number of employees covered by UI who worked or received pay for the pay period including the 12th day of the first reporting month.|Total of this field on all ‘S’ records in the file.
|124-131|Month-2 Employment \\Total number of employees covered by UI who worked or received pay for the pay period including the 12th day of the second reporting month.|Total of this field on all ‘S’ records in the file.
|132-139|Month-3 Employment \\Total number of employees covered by UI who worked or received pay for the pay period including the 12th day of the third reporting month.|Total of this field on all ‘S’ records in the file.
At line 969 changed one line
!!Appendix: State Reporting documents:
!!Appendix: State Reporting documents
This page (revision-96) was last changed on 26-Nov-2021 10:22 by Meg McFarlandTop