06 standard extract non quarterly es2suen

© 2019 - State of Utah - Department of Technology Services
Jump to navigation Jump to search

Standard U-I Extract Non-quarterly (ES2SUEN)

ES2SUEN - Length 666 - Revised 1/30/2019

​Columns

LenKeyTypeCOBOL Field NameDescription & Notes
122KeyCharSUEN-STATE-FIPSState Federal Information Processing Standard Code (e.g. '01' = Alabama)
31715KeyCharSUEN-SwA-IDCombined U-I Account Number and Reporting Unit Number to Obtain the State Workforce Account Identification Number (broken out below)
31210RKeyCharSUEN-ACCTU-I Account Number Portion of the SWA ID
13175RKeyCharSUEN-RPT-UNITReporting Unit Number Portion on the SWA ID
18181 CharSUEN-CK-DIGITGenerally optional check digit (space, or 0-9 value)
19279 CharSUEN-FEINFederal Employee Identification Number (numeric or spaces if unchanged)
286235 CharSUEN-LEGAL-NAMELegal or Corporate Name of the Employer (Alpha-Numeric; spaces if unchanged, '>' if it should be blanked out
639735 CharSUEN-TRADE-NAMETrade or Doing-Business-As Name (spaces if unchanged; '>' if it should be blanked)
98981 CharSUEN-SPECIAL-INDThe special indicator (‘P’ = Professional Employer Organization; ‘T’ = Indian Tribal Council; space is unchanged; ‘M’ = Cannabis provider; ‘Y’ = Combination of PEO and Cannabis; ‘Z’ = Combination Indian Tribal and Cannabis; ‘>’ = blank out the current value)
9913335 CharSUEN-RPT-UNIT-DESCRReporting Unit Description; a Description that makes Sense to the Employer (spaces if unchanged; start with '>' means that it should be blanked out)
134244111 CharSUEN-PHYS-LOC-ADDRESSGroup-level of physical location address; broken out below
13416835R CharSUEN-PL-STREET2Second line of street address; equivalent to first line on IMT address; spaces mean that there is no change; '>' in the first character means that the field should be blanked out
16920335R CharSUEN-PL-STREET1First line of PLA street; equivalent to IMT address2; spaces mean no change; '>' in first character mean the field should be blanked out
20423330R CharSUEN-PL-CITYCity field of PLA; spaces = no change; '>' = blank out the field
2342352R CharSUEN-PL-STATEState field of PLA; spaces = no change; '>' = blank out the field
2362449R CharSUEN-PL-ZIPGrouped PLA 9-digit zip code; broken out below
2362405r CharSUEN-PL-ZIP-5PLA 5-digit ZIP code; spaces = no change; '>' in first character = blank out this field
2412444r CharSUEN-PL-ZIP-4PLA ZIP+4 extension; spaces = no change; '>' = blank out this field
24527935 CharSUEN-CONTACT-NAMEContact person's name; goes in the MOA 'C' record; spaces = no change; '>' = blank out this field
28031435 CharSUEN-CONTACT-TITLEContact person's title; goes in the MOA 'C' record; spaces = no change; '>' = blank out
315436122 CharSUEN-UI-TAX-ADDRESSGroup-level Unemployment Insurance Address; broken out below
3153151R CharSUEN-UI-ADDR-TYPEType of address; '1' = PLA, '2' = mailing, '3' = corporate headquarters; '9' = unknown; space = no change; '>' = blank out this field
31635035R CharSUEN-UI-2NDRY-ADDRSecondary UI address (equivalent to IMT first street address line); spaces = no change; '>' in first character means to blank out the field
35138535R CharSUEN-UI-DELIV-ADDRPrimary UI street address (equivalent to IMT second street address line); spaces = no change; '>' in first character = blank out the field
38641530R CharSUEN-UI-CITYUI city field; blank = no change; '>' = blank out the field
4164172R CharSUEN-UI-STATEUI state; blank = no change; '>' = blank out the field
4184269R CharSUEN-UI-ZIPCombined 9-digit UI Zip Code; broken out below
4184225r CharSUEN-UI-ZIP-55-digit ZIP code for UI address; spaces = no change; '>' = blank out the field
4234264r CharSUEN-UI-ZIP-4ZIP+4 extension for UI address; spaces = no change; '>' = blank out the field
4274293R CharSUEN-UI-COUNTRYCountry code used for UI address; little used for IMT, other than Canadian getting a 'CN' in the state code, and other beyond spaces besides USA getting a 'ZZ' in the state code; spaces = no change; '>' = blank out the field
4304367R CharSUEN-UI-FOREIGN-ZIPForeign ZIP code for UI address; used in place of IMT ZIP for foreign addresses
437558122 CharSUEN-MAILING-OTHER-ADDRESSGroup-level Mailing Other Address; broken out below
4374371R CharSUEN-MO-ADDR-TYPEAddress type for MOA; Goes to the MOA 'A' record; '1' = PLA; '2' = Mailing; '3' = Corporate; '9' = Unknown; '  ' = no change; '>' = blank out this field
43847235R CharSUEN-MO-2NDRY-ADDRSecondary street address of MOA; equivalent to first line of IMT; spaces = no change; '>' = blank out the field; stored in the MOA 'A' record
47350735R CharSUEN-MO-DELIV-ADDRDelivery address; equivalent to second line of IMT address; spaces = no change; '>' = blank out the field
50853710R CharSUEN-MO-CITYCity portion of MOA; spaces = no change; '>' = blank out the field
5385392R CharSUEN-MO-STATEState portion of MOA; spaces = no change; '>' = blank out the field
5405489R CharSUEN-MO-ZIPZIP code for MOA; broken out in the two lines that follow
5405445r CharSUEN-MO-ZIP-55-digit ZIP code for MOA; spaces = no change; '>' = blank out the field
5455484r CharSUEN-MO-ZIP-4ZIP+4 portion of MOA; spaces = no change; '>' = blank out the field
5495513R CharSUEN-MO-COUNTRYCountry code of MOA; if "CAN', will place 'CN' in state code; if any other non-blank, non-USA field, it will place 'ZZ' in the State code; spaces = no change; '>' = blank out the field
5525587R CharSUEN-MO-FOREIGN-ZIPForeign Zip code portion of MOA; used instead of ZIP code if present; spaces = no change; '>' = blank out the field
55957315 CharSUEN-PHONE-NUMGrouped phone number area, broken out below
5595613R CharSUEN-AREAArea code portion of phone number; spaces = no change; '>' = blank out the field
5625687R CharSUEN-PHONEGrouped phone number; breakout in two lines that follow
5625643r CharSUEN-PH-PFXFirst three digits of phone number; numeric gets placed
5655684r CharSUEN-PH-SFXSecond four digits of phone number; numeric gets placed
5695735R CharSUEN-PH-EXTFive-character extension phone number; non-blank, non-> is transferred
57458310 CharSUEN-FAX-PHONE-NUMGroup-level facsimile phone number; break-out is shown below
5745763R CharSUEN-FAX-AREAArea code for fax phone number – goes in "E" record for MOA if numeric
5775837R CharSUEN-FAX-PHONECombined fax phone number – breakout is in the two lines that follow
5775793r CharSUEN-FAX-PH-PFXFirst three digits of fax phone number – transfer to "E" record of MOA if numeric
5805834r CharSUEN-FAX-PH-SFXLast four digits of fax phone number – transfer to "E" record of MOA if numeric
5845918 CharSUEN-INIT-LIAB-DATEInitial liability date; format yyyymmdd; transferred if numeric
5925998 CharSUEN-END-LIAB-DATEEnd-of-liability date; format yyyymmdd; transferred if numeric
6006078 CharSUEN-REACT-DATEReactivation date; format yyyymmdd; transferred if numeric
6086158 CharSUEN-SETUP-DATESet-up date (not used often); format yyyymmdd;fransferred if numeric
6166161 CharSUEN-ORG-TYPE-CODEOrganization type code; "C' = Corporation; 'I' = Individual proprietorship; 'O' = Other; 'P' = Partnership; spaces = no change; '>' = blank out the field
61765135 CharSUEN-STATE-USEAdministrative state use field; transfers first 34 characters to state usage if non-blank and non-">"; spaces = no change; '>' = blank out the field
65266615 CharSUEN-STATE-USE-2Not used by the IMT File or the Micro File in loading

Non-quarterly Portion of the SUE or SQUID File

Data Set Name:                   ES2.SUE.NONQTR.FILE

Service Center DSN:           YBUssX.A145.SUE.NONQTR.FILE, ('ss' = State FIPS code)

Type of File:                         Sequential

File Layout:                          ES2SUEN

​The Non-quarterly SUE File (also known as the Standard QUEST U-I Data (SQUID) File) is processed as a blank file in the 084I job, and is converted to the IMT format with the 084G job. It is processed along with the quarterly file (ES2SUEQ) and the predecessor/successor file (ES2SUPS) to get the most from these files. In February of 2018, a new file was presented, called -.CENCO.NCA.ssnn.ADDRESS.TXT file identifying the address portion of the file that would have the NCA (non-classified accounts) processing of the quarterly data, the county/town location and the NAICS identification.​ ​ ​ ​ ​ ​


Related Links

Retrieved from "http://qcewsupportapps.com/index.php?title=06_standard_extract_non_quarterly_es2suen&oldid=4550"