HOME
CONTACT US
MEMBERSHIP
|
 |
Strengthening the workforce
system through information exchange, liaison and advocacy. |
Unemployment Insurance Wage Reporting ICESA Format
| June 02, 1998 |
ICESA FORMAT
Software Specifications and Edits for
Quarterly Unemployment Insurance Wage Reporting
(Year 2000 compliant)
Table of Contents
I. MAGNETIC MEDIA WAGE REPORTING REQUIREMENTS AND PROCEDURES
- Magnetic Media Reporting to State Unemployment Agencies
- Processing Schedule and Employer Retention
- Permission to Use Magnetic Media and the Submission of Test Files
- Transmittal Forms
- Use of Agent
- Tax Form Submission and Payment
II. DATA RECORD DESCRIPTIONS
- Transmitter Record
- Authorization Record
- Employer Record
- Employee Record
- Total Record
- Final Record
III. MAGNETIC TAPE TECHNICAL REQUIREMENTS FOR UNEMPLOYMENT INSURANCE REPORTING
- Basic Requirements
- Tape Density
- Internal Labels
- Tapemarks
- Character Sets
- Logical Record Length
- Physical Records
- Blocking Factor
- Consolidated Files
IV. DISKETTE TECHNICAL REQUIREMENTS FOR UNEMPLOYMENT INSURANCE REPORTING
- File Name
- Operating System
- Character Set
- Record Length
- Formatting
- Delimiters
- Multiple-Volume Submission
V. MAGNETIC TAPE SPECIFICATIONS
Code A - Transmitter Record
Code B - Authorization Record
Code E - Employer Record
Code S - Employee Record
Code T - Employee Record
Code F - Final Record
APPENDIX A: TELEPHONE NUMBERS FOR THE STATE UNEMPLOYMENT INSURANCE MAGNETIC MEDIA CONTACTS
APPENDIX B: FEDERAL INFORMATION PROCESSING STANDARD (FIPS 5-2) POSTAL ABBREVIATIONS AND NUMERIC CODES
APPENDIX C: ACCEPTABLE CHARACTER SETS
APPENDIX D: GLOSSARY
APPENDIX E: LABELS AND PACKAGING FOR MAGNETIC MEDIA REPORTS
External Labels
Packaging Magnetic Tapes for Mailing
I. MAGNETIC MEDIA WAGE REPORTING REQUIREMENTS AND PROCEDURES
This booklet contains the specifications and instructions for reporting Unemployment Insurance reports on magnetic media, i.e. magnetic tape, 3480 cartridge, and diskette. For purposes of this publication, the terms TAPE and 3480 CARTRIDGE are used interchangeably unless otherwise indicated. See Section V for the format for magnetic media reporting. The requirements shown in this booklet apply to all States, the District of Columbia, Puerto Rico and the Virgin Islands.
Magnetic Media Reporting to State Unemployment Insurance Agencies
Employers who wish to file State Unemployment Insurance wage and tax data on magnetic media may use the formats shown in this book; however, arrangements and approval for magnetic media reporting to State agencies must be made with each individual State.
Processing Schedule and Employer Retention
Files having improper format or other technical problems will be delayed. If a State is unable to process a file, the file will be returned to the transmitter along with an explanation of the problems that were encountered.
It is recommended that transmitters retain a backup copy of their magnetic media file.
Permission to Use Magnetic Media and the Submission of Test Files
Some States may require the completion of a magnetic media permission form. Some States may require the submission of test files.
Transmittal Forms
Some states may require paper transmittal forms to accompany a magnetic media file.
Use of Agent
Employers reported by agents are responsible for the accuracy and timeliness of their own reports. If an agent fails to meet the magnetic media filing requirements, the employers reported by the agent may be liable for any penalties.
Tax Form Submission and Payment
Some states may require that the tax forms and payments accompany the magnetic media in one package. Contact your state for specific forms submission and payment instructions.
II. DATA RECORD DESCRIPTIONS
The following is a description of the data records that are used to create magnetic media reports. Use the information provided below as well as the list of technical requirements and specifications in the other sections of this manual to prepare reports via magnetic media.
TRANSMITTER RECORD: CODE A
The Code A record identifies the organization submitting the file.
The Code A record must be the first data record on each tape and single diskette. (See Section IV for multiple volume diskette requirements.)
AUTHORIZATION RECORD: CODE B
The Code B record identifies the type of equipment used to generate the file.
The Code B record must be the second data record on each tape and single diskette. (See Section IV for multiple volume diskette requirements.)
The Code B record should contain the address where the file can be returned if the state is unable to process it. Address entries should be specific enough to ensure proper delivery and must be made precisely according to the specifications.
EMPLOYER RECORD: CODE E
The Code E record identifies an employer whose employee wage and tax information is being reported.
Generate a new Code E record each time it is necessary to change the information in any field on this record.
EMPLOYEE RECORD: CODE S
The Code S record is used to report wage and tax data for an employee.
A Code S record should follow its related code E record or it could follow an associated Code S record which in turn follows a related Code E record.
Do not generate a Code S record if only blanks would be entered after the record identifier.
Name Formats on the Code S Record
The employee name on the magnetic media file must agree with the spelling of the name on the individual's social security card.
Parts of a compound surname must be connected by a hyphen. Single-letter prefixes (e.g., "O," "D,") must not be separated from the rest of the surname by a blank, but should be connected by an apostrophe.
Punctuation may be used when appropriate.
Lower case letters are not acceptable.
Do not include any titles in the name. Titles make it difficult to determine an individual's name and may prevent properly crediting earnings data.
Money Amounts
All money fields are strictly numeric.
They must include dollars and cents with the decimal point assumed.
Do not use any punctuation in any money field.
NEGATIVE (CREDIT) MONEY AMOUNTS ARE NOT ALLOWED.
RIGHT JUSTIFY AND ZERO FILL ALL MONEY FIELDS.
IN A MONEY FIELD THAT IS NOT APPLICABLE, ENTER ZEROS.
TOTAL RECORD: CODE T
The Code T record contains the totals for all Code S records reported since the last Code E record.
A Code T record must be generated for each Code E record.
See the Employee Wage Record (Code S) description for information about reporting money amounts.
FINAL RECORD: CODE F
The Code F record indicates the end of the file and MUST be the last data record on each tape or single diskette. (See Section IV for multiple volume diskette requirements.)
The Code F record must appear only once on each file, after the last Code T record.
See the Employee Wage Record (Code S) description for information about reporting money amounts.
III. MAGNETIC TAPE TECHNICAL REQUIREMENTS FOR
UNEMPLOYMENT INSURANCE REPORTING
Basic Requirements
Data should be written on ½-inch magnetic tape, in the unpacked mode using only 9-track tapes or 3480 cartridges.
Each file should contain data for only one quarter. A reel or cartridge with multiple quarters will be rejected.
Tape Density
The acceptable recording densities for 9-track tapes are: 1600 and 6250 bytes per inch (BPI). The acceptable recording density for 3480 cartridges is 38,000 BPI.
Internal Labels
States will accept labeled magnetic tape files in accordance with the guidelines below. Labels must not contain security encoded bytes. If your system cannot produce labels as described below, send a no-label tape file; i.e., a tape file with data records only.
- Tapes with IBM OS/VS STANDARD header and trailer labels are preferred.
- Transmitters that cannot produce IBM OS/VS internal labels or no-label tapes may use other labels, as described below.
- Each segment (record) of a set of labels (i.e., VOL1 + HDR1 + HDR2 = a set of header labels) must contain 99 or fewer characters.
- Header and trailer labels must be written in the same density as the data records.
- Header labels must precede data and be separated from the data by one (1) tapemark.
- Trailer labels must follow the data and must be separated from the data by one (1) tapemark.
- Two (2) tapemarks must follow the trailer labels.
Tapemarks
A tapemark is a one-character physical record. As used on magnetic tape, it separates data from internal labels and one data file from another data file. It also indicates end-of-reel. The hexadecimal value for a tapemark is 13. The decimal value for a tapemark is 19. The octal value for a tapemark is 23. Never begin a magnetic tape with a tapemark; doing so signals end-of-reel and causes processing to terminate.
Separate data from internal labels with ONE (1) tapemark.
Indicate end-of-reel with TWO (2) tapemarks, as follows:
- If using trailer labels, write end-of-reel tapemarks directly after the trailer labels.
- If using no-label tape, write end-of-reel tapemarks directly after the last block of data.
Character Sets
Appendix C contains tables of character sets that can be translated. American Standard Code for Information Interchange (ASCII) and Extended Binary Coded Decimal Interchange Code (EBCDIC) will be accepted. Magnetic tape recorded in EBCDIC is preferred. LOWER CASE LETTERS ARE NOT ACCEPTABLE ON MAGNETIC TAPE.
Logical Record Length
Each record must be a uniform length of 275 (or 276) characters. A 275-character record is preferred. If your system cannot produce an odd number record length, a 276-character record will be accepted. In tape files with a record length of 276, the 276th character must contain a blank which is coded in the same character set as the first 275 characters. For example, if the first 275 characters are coded in or translated to EBCDIC, character 276 must also be coded in or translated to EBCDIC. Logical records MUST NOT be prefixed by record descriptor words or block descriptor words.
Physical Records
Each physical record (= a block of logical records) must be a uniform length. The length must be a multiple of the logical record length. Physical records MUST NOT be prefixed by block descriptor words. If a logical record length of 275 is being used, the largest acceptable physical record is 23,375. If a logical record length of 276 is being used, the largest acceptable physical record is 23,460. Any tape containing physical records larger than 23,460 characters in length will be returned unprocessed. Compressed files will not be accepted.
Blocking Factor
The blocking factor on magnetic tape files must not exceed 85. The use of 25 logical records per block on 9-track tapes and 85 logical records per block on 3480 cartridges is preferred.
One logical record per block on tape files from systems that cannot generate the record length of 275 or 276, with the physical record size a multiple of 275 or 276 is required.
Example: DECVAX Systems
When creating a magnetic tape, choose the option in your system which permits you to designate record length as well as blocksize. Also, be sure to remove line feed, carriage return and all other record delimiters from your records. These characters are often masked. If used in a magnetic tape, these characters create a record length that disagrees with these specifications.
Consolidated Files
Transmitters of Unemployment Insurance Information are urged to minimize the number of files they submit when reporting information for multiple employers or for multiple work sites of a single employer.
IV. DISKETTE TECHNICAL REQUIREMENTS FOR
UNEMPLOYMENT INSURANCE REPORTING
File Name
The file name must be UIWAGE.TXT. It MUST be in the root directory
A diskette must not contain more than one file. If more than one file of unemployment insurance wage information is being submitted, each file must be named UIWAGE.TXT and each file must be placed on a separate diskette. No files other than UIWAGE.TXT should be included on a diskette. (Exception--see "Multiple-Volume Submission" in this section.)
Transmitters of unemployment insurance wage information for multiple employers should avoid creating a separate file and a separate diskette for each employer.
Operating System
All 5¼" or 3½" diskettes must be created using an MS-DOS "double density" or "high density" operating system format.
If you do not have an MS-DOS operating system, you may still be able to create MS-DOS compatible diskette files. Some operating systems, e.g., UNIX, XENIX and APPLE, may have a DOS shell that can be used to create these files. For UNIX/XENIX based systems use DOSCP command to create an MS-DOS compatible file. Check your operating system manual.
Character Set
Data must be recorded on 5¼" or 3½" diskettes using the ASCII-1 character set. See Appendix C.
Note: EBCDIC and ASCII-2 are not acceptable for diskette reporting.
Record Length
Each record in a file MUST be 275 characters in length. Data must be entered in each record in the exact positions shown in Section V just as for magnetic tape format.
Formatting
Data sent on 5¼" or 3½" "double density" or "high density" diskettes MUST be formatted to the density specified by the diskette manufacturer.
Delimiters
Record delimiters must be used. They must follow the last character of each record.
The record delimiter must consist of two characters and those two characters must be carriage return and line feed. The ASCII-1 hexadecimal value for the carriage return character is 0D (zero and letter D); the ASCII-1 hexadecimal value for the line feed is 0A (zero and letter A). The ASCII-1 decimal values for the two characters are 13 and 10, respectively.
A record delimiter must appear immediately after the last character of each record. The carriage return character and the line feed character will be placed in positions 276 and 277, respectively.
DO NOT place a record delimiter before the first record of the file.
DO NOT place more than one record delimiter i.e., more than one carriage-return/line-feed combination, following a record.
DO NOT place record delimiters after a field within a record.
Multiple-Volume Submission
A multiple-volume diskette submission is a submission for which the number of data records exceeds the capacity of a single diskette, so the data must be continued on to one or more subsequent diskettes, i.e., volumes. A multiple-volume diskette submission properly begins with a Code A record on volume 1 and ends with a Code F record on the last volume.
Only the file "UIWAGE.TXT" on volume 1 of a multiple-volume diskette file should begin with a Code A record. Each volume after volume 1 should contain a file named "UIWAGE2.TXT" for the second volume and "UIWAGE3.TXT" for the third volume, etc. Each file should begin with the record which properly follows the last record on the preceding volume/file. For example, if volume 1 ends with a Code S record, volume 2 begins with the next code S record for that employer.
The external diskette labels for a multiple-volume submission MUST indicate the proper sequence (e.g., VOL 2 of 3) for processing.
V. MAGNETIC MEDIA SPECIFICATIONS
STANDARD MAGNETIC FORMAT FOR QUARTERLY WAGE REPORTING
RECORD NAME: A RECORD - TRANSMITTER RECORD RECORD LENTH = 275
Some locations/fields in this record are state specific and will be defined by those states as required. Individual states should be contacted for specific information. DATA TYPES: A/N = ALPHANUMERIC; LEFT JUSTIFIED AND BLANK FILLED N = NUMERIC; RIGHT JUSTIFIED, ZERO FILLED, UNSIGNED DO NOT INCLUDE DECIMAL IN FIELDS CONTAINING DOLLARS AND CENTS.
|
LOCATION |
FIELD NAME |
FIELD |
TYPE |
DESCRIPTION AND REMARKS |
|
1 - 1 |
|
Record Identifier |
|
1 |
|
A/N |
|
Constant "A" |
|
|
|
|
|
|
|
|
|
|
|
2 - 5 |
|
Year |
|
4 |
|
A/N |
|
Enter year for which this report is being prepared. |
|
|
|
|
|
|
|
|
|
|
|
6 - 14 |
|
Transmitter's Federal EIN |
|
9 |
|
A/N |
|
Enter only numeric characters; omit hyphens, prefixes and suffixes. |
|
|
|
|
|
|
|
|
|
|
|
15 - 18 |
|
Taxing Entity Code |
|
4 |
|
A/N |
|
Constant "UTAX" |
|
|
|
|
|
|
|
|
|
|
|
19 - 23 |
|
Blanks |
|
5 |
|
A/N |
|
Enter Blanks |
|
|
|
|
|
|
|
|
|
|
|
24 - 73 |
|
Transmitter Name |
|
50 |
|
A/N |
|
Enter the transmitter name of the organization submitting the file. |
|
|
|
|
|
|
|
|
|
|
|
74 - 113 |
|
Transmitter Street Address |
|
40 |
|
A/N |
|
Enter the street address of the organization submitting the file. |
|
|
|
|
|
|
|
|
|
|
|
114 - 138 |
|
Transmitter City |
|
25 |
|
A/N |
|
Enter the city of the organization submitting the file |
|
|
|
|
|
|
|
|
|
|
|
139 - 140 |
|
Transmitter State |
|
2 |
|
A/N |
|
Enter the standard two character FIPS postal abbreviation. See appendix B. |
|
|
|
|
|
|
|
|
|
|
|
141 - 153 |
|
Blanks |
|
13 |
|
A/N |
|
Enter blanks. |
|
|
|
|
|
|
|
|
|
|
|
154 - 158 |
|
Transmitter Zip Code |
|
5 |
|
A/N |
|
Enter a valid zip code. |
|
|
|
|
|
|
|
|
|
|
|
159 - 163 |
|
Transmitter Zip Code Extension |
|
5 |
|
A/N |
|
Use this field as necessary for the four digit extension of the zip code. Include hyphen in position 159. If unknown, fill with blanks. |
|
|
|
|
|
|
|
|
|
|
|
164 - 193 |
|
Transmitter Contact |
|
30 |
|
A/N |
|
Title of individual from transmitter organization, who is responsible for the accuracy and completeness of the wage report. |
|
|
|
|
|
|
|
|
|
|
|
194 - 203 |
|
Transmitter Contact Telephone Number |
|
10 |
|
A/N |
|
Telephone number at which the transmitter contact can be telephoned. |
|
|
|
|
|
|
|
|
|
|
|
204 - 207 |
|
Telephone Extension/Box |
|
4 |
|
A/N |
|
Enter transmitter telephone extension or message box. |
|
|
|
|
|
|
|
|
|
|
|
208 - 213 |
|
Media Transmitter/Authorization Number |
|
6 |
|
A/N |
|
Identifier assigned to the entity transmitting the media. |
|
|
|
|
|
|
|
|
|
|
|
214 - 214 |
|
C-3 Data |
|
1 |
|
A/N |
|
States requiring this data will define. If not required, enter blanks. |
|
|
|
|
|
|
|
|
|
|
|
215 - 219 |
|
Suffix Code |
|
5 |
|
A/N |
|
States requiring this data will define. If not required, enter blanks. |
|
|
|
|
|
|
|
|
|
|
|
220 - 220 |
|
Allocation Lists |
|
1 |
|
A/N |
|
States requiring this data will define. If not required, enter blanks. |
|
|
|
|
|
|
|
|
|
|
|
221 - 229 |
|
Service Agent I.D. |
|
9 |
|
A/N |
|
States requiring this data will define. If not required, enter blanks. |
|
|
|
|
|
|
|
|
|
|
|
230 - 242 |
|
Total Remittance Amount |
|
13 |
|
A/N |
|
States requiring this data will define. If not required, enter blanks. |
|
|
|
|
|
|
|
|
|
|
|
243 - 250 |
|
Media Creation Date |
|
8 |
|
A/N |
|
Enter date: MMDDYYYY. |
|
|
|
|
|
|
|
|
|
|
|
251 - 275 |
|
Blanks |
|
25 |
|
A/N |
|
Enter Blanks. |
STANDARD MAGNETIC FORMAT FOR QUARTERLY WAGE REPORTING
RECORD NAME: B RECORD - AUTHORIZATION RECORD RECORD LENTH = 275
Some locations/fields in this record are state specific and will be defined by those states as required. Individual states should be contacted for specific information. DATA TYPES: A/N = ALPHANUMERIC; LEFT JUSTIFIED AND BLANK FILLED N = NUMERIC; RIGHT JUSTIFIED, ZERO FILLED, UNSIGNED DO NOT INCLUDE DECIMAL IN FIELDS CONTAINING DOLLARS AND CENTS.
|
LOCATION |
FIELD NAME |
FIELD |
TYPE |
DESCRIPTION AND REMARKS |
|
1 - 1 |
|
Record Identifier |
|
1 |
|
A/N |
|
Constant "B" |
|
|
|
|
|
|
|
|
|
|
|
2 - 5 |
|
Payment Year |
|
4 |
|
A/N |
|
Enter the year for which this report is being prepared. |
|
|
|
|
|
|
|
|
|
|
|
6 - 14 |
|
Transmitter's Federal EIN |
|
9 |
|
A/N |
|
Enter only numeric characters; omit hyphens, prefixes and suffixes. |
|
|
|
|
|
|
|
|
|
|
|
15 - 22 |
|
Computer |
|
8 |
|
A/N |
|
Enter the manufacturer's name. |
|
|
|
|
|
|
|
|
|
|
|
23 - 24 |
|
Internal Label |
|
2 |
|
A/N |
|
SL = IBM standard label |
|
|
|
|
|
|
|
|
|
|
|
25 - 25 |
|
Blank |
|
1 |
|
A/N |
|
Enter blank. |
|
|
|
|
|
|
|
|
|
|
|
26 - 27 |
|
Density |
|
2 |
|
A/N |
|
"16" = 1600 BPI reel tape |
|
|
|
|
|
|
|
|
|
|
|
28 - 30 |
|
Recording Code (Character Set) |
|
3 |
|
A/N |
|
Enter "EBC" for EBCDIC; "ASC" for ASCIII. Always "ASC" for diskette. |
|
|
|
|
|
|
|
|
|
|
|
31 - 32 |
|
Number of Tracks |
|
2 |
|
A/N |
|
"09" = Reel tapes |
|
|
|
|
|
|
|
|
|
|
|
33 - 34 |
|
Blocking Factor |
|
2 |
|
A/N |
|
Enter the blocking factor of the file, not to exceed 85. |
|
|
|
|
|
|
|
|
|
|
|
35 - 38 |
|
Taxing Entity Code |
|
4 |
|
A/N |
|
Constant "UTAX" |
|
|
|
|
|
|
|
|
|
|
|
39 - 146 |
|
Blanks |
|
108 |
|
A/N |
|
Enter blanks |
|
|
|
|
|
|
|
|
|
|
|
147 - 190 |
|
Organization Name |
|
44 |
|
A/N |
|
The name of the organization to which the media should be returned. |
|
|
|
|
|
|
|
|
|
|
|
191 - 225 |
|
Street Address |
|
35 |
|
A/N |
|
The street address of the organization to which the media should be returned. |
|
|
|
|
|
|
|
|
|
|
|
226 - 245 |
|
City |
|
20 |
|
A/N |
|
The city of the organization to which the media should be returned. |
|
|
|
|
|
|
|
|
|
|
|
246 - 247 |
|
State |
|
2 |
|
A/N |
|
Enter the standard two character FIPS postal abbreviation. See appendix B. |
|
|
|
|
|
|
|
|
|
|
|
248 - 252 |
|
Blanks |
|
5 |
|
A/N |
|
Enter blanks. |
|
|
|
|
|
|
|
|
|
|
|
253 - 257 |
|
Zip Code |
|
5 |
|
A/N |
|
Enter a valid zip code. |
|
|
|
|
|
|
|
|
|
|
|
258 - 262 |
|
Zip Code Extension |
|
5 |
|
A/N |
|
Enter four digit extension of zip code, being sure to include the hyphen in position 258. If N/A, enter blanks. |
|
|
|
|
|
|
|
|
|
|
|
263 - 275 |
|
Blanks |
|
13 |
|
A/N |
|
Enter blanks. |
STANDARD MAGNETIC FORMAT FOR QUARTERLY WAGE REPORTING
RECORD NAME: E RECORD - EMPLOYER RECORD RECORD LENTH = 275
Some locations/fields in this record are state specific and will be defined by those states as required. Individual states should be contacted for specific information. DATA TYPES: A/N = ALPHANUMERIC; LEFT JUSTIFIED AND BLANK FILLED N = NUMERIC; RIGHT JUSTIFIED, ZERO FILLED, UNSIGNED DO NOT INCLUDE DECIMAL IN FIELDS CONTAINING DOLLARS AND CENTS.
|
LOCATION |
FIELD NAME |
FIELD |
TYPE |
DESCRIPTION AND REMARKS |
|
1 - 1 |
|
Record Identifier |
|
1 |
|
A/N |
|
Constant "E" |
|
|
|
|
|
|
|
|
|
|
|
2 - 5 |
|
Payment Year |
|
4 |
|
A/N |
|
Enter the year for which the report is being prepared. |
|
|
|
|
|
|
|
|
|
|
|
6 - 14 |
|
Federal EIN |
|
9 |
|
A/N |
|
Enter only numeric characters. Omit hyphens, prefixes and suffixes. |
|
|
|
|
|
|
|
|
|
|
|
15 - 23 |
|
Blanks |
|
9 |
|
A/N |
|
Enter blanks. |
|
|
|
|
|
|
|
|
|
|
|
24 - 73 |
|
Employer Name |
|
50 |
|
A/N |
|
Enter the first 50 positions of the employer's name, exactly as registered with the state unemployment insurance agency. |
|
|
|
|
|
|
|
|
|
|
|
74 - 113 |
|
Employer Street Address |
|
40 |
|
A/N |
|
Enter the street address of the employer. |
|
|
|
|
|
|
|
|
|
|
|
114 - 138 |
|
Employer City |
|
25 |
|
A/N |
|
Enter the city of employer's mailing address. |
|
|
|
|
|
|
|
|
|
|
|
139 - 140 |
|
Employer State |
|
2 |
|
A/N |
|
Enter the standard two character FIPS postal abbreviation of the employer's address. See appendix B. |
|
|
|
|
|
|
|
|
|
|
|
141 - 148 |
|
Blanks |
|
8 |
|
A/N |
|
Enter blanks. |
|
|
|
|
|
|
|
|
|
|
|
149 - 153 |
|
Zip Code Extension |
|
5 |
|
A/N |
|
Enter four digit extension of zip code, being sure to include the hyphen in position 149. If N/A, enter blanks. |
|
|
|
|
|
|
|
|
|
|
|
154 - 158 |
|
Zip Code |
|
5 |
|
A/N |
|
Enter valid zip code. |
|
|
|
|
|
|
|
|
|
|
|
159 - 159 |
|
Blank |
|
1 |
|
A/N |
|
Enter blank. |
|
|
|
|
|
|
|
|
|
|
|
160 - 160 |
|
Type of Employment |
|
1 |
|
A/N |
|
Enter the appropriate code: |
|
|
|
|
|
|
|
|
|
|
|
161 - 162 |
|
Blocking Factor |
|
2 |
|
A/N |
|
Enter blocking factor of the file, not to exceed 85. Enter blanks for diskette. |
|
|
|
|
|
|
|
|
|
|
|
163 - 166 |
|
Establishment Number or Coverage Group/PRU |
|
4 |
|
A/N |
|
Enter either the establishment number of the coverage group/PRU. Otherwise, enter blanks. |
|
|
|
|
|
|
|
|
|
|
|
167 - 170 |
|
Taxing Entity Code |
|
4 |
|
A/N |
|
Constant "UTAX" |
|
|
|
|
|
|
|
|
|
|
|
171 - 172 |
|
State Identifier Code |
|
2 |
|
A/N |
|
Enter the state FIPS postal numeric code for the state to which wages are being reported. |
|
|
|
|
|
|
|
|
|
|
|
173 - 187 |
|
State Unemployment Insurance Account Number |
|
15 |
|
A/N |
|
Enter state U.I. employer account number. |
|
|
|
|
|
|
|
|
|
|
|
188 - 189 |
|
Reporting Period |
|
2 |
|
A/N |
|
Enter the last month of the calendar quarter to which the report applies. |
|
|
|
|
|
|
|
|
|
|
|
190 - 190 |
|
No Workers/No Wages |
|
1 |
|
N |
|
0 = Indicates that the E record will not be followed by S, employee records. |
|
|
|
|
|
|
|
|
|
|
|
191 - 191 |
|
Tax Type Code |
|
1 |
|
A/N |
|
States requiring this data will define. If not required, enter blank. |
|
|
|
|
|
|
|
|
|
|
|
192 - 196 |
|
Taxing Entity Code |
|
5 |
|
A/N |
|
States requiring this data will define. If not required, enter blanks. |
|
|
|
|
|
|
|
|
|
|
|
197 - 203 |
|
State Control Number |
|
7 |
|
A/N |
|
States requiring this data will define. If not required, enter blanks. |
|
|
|
|
|
|
|
|
|
|
|
204 - 208 |
|
Unit Number |
|
5 |
|
A/N |
|
States requiring this data will define. If not required, enter blanks. |
|
|
|
|
|
|
|
|
|
|
|
209 - 255 |
|
Blanks |
|
47 |
|
A/N |
|
Enter blanks. |
|
|
|
|
|
|
|
|
|
|
|
256 - 256 |
|
Foreign Indicator |
|
1 |
|
A/N |
|
If data in positions 74 -158 is for a foreign address, enter the letter "X", else a blank. |
|
|
|
|
|
|
|
|
|
|
|
257 - 257 |
|
Blank |
|
1 |
|
A/N |
|
Enter blank. |
|
|
|
|
|
|
|
|
|
|
|
258 - 266 |
|
Other EIN |
|
9 |
|
A/N |
|
Enter blanks if no other EIN was used. |
|
|
|
|
|
|
|
|
|
|
|
267 - 275 |
|
Blanks |
|
9 |
|
A/N |
|
Enter blanks. |
STANDARD MAGNETIC FORMAT FOR QUARTERLY WAGE REPORTING
RECORD NAME: S RECORD - EMPLOYEE RECORD RECORD LENTH = 275
Some locations/fields in this record are state specific and will be defined by those states as required. Individual states should be contacted for specific information. DATA TYPES: A/N = ALPHANUMERIC; LEFT JUSTIFIED AND BLANK FILLED N = NUMERIC; RIGHT JUSTIFIED, ZERO FILLED, UNSIGNED DO NOT INCLUDE DECIMAL IN FIELDS CONTAINING DOLLARS AND CENTS.
|
LOCATION |
FIELD NAME |
FIELD |
TYPE |
DESCRIPTION AND REMARKS |
|
1 - 1 |
|
Record Identifier |
|
1 |
|
A/N |
|
Constant "S" |
|
|
|
|
|
|
|
|
|
|
|
2 - 10 |
|
Social Security Number |
|
9 |
|
A/N |
|
Employee's social security number; if not known enter the letter "I" in position 2 and blanks in position 3-10. |
|
|
|
|
|
|
|
|
|
|
|
11 - 30 |
|
Employee Last Name |
|
20 |
|
A/N |
|
Enter employee last name. |
|
|
|
|
|
|
|
|
|
|
|
31 - 42 |
|
Employee First Name |
|
12 |
|
A/N |
|
Enter employee first name. |
|
|
|
|
|
|
|
|
|
|
|
43 - 43 |
|
Employee Middle Initial |
|
1 |
|
A/N |
|
Enter employee middle initial. If no middle initial, enter blank. |
|
|
|
|
|
|
|
|
|
|
|
44 - 45 |
|
State Code |
|
2 |
|
A/N |
|
Enter the state FIPS postal numeric code for the state to which wages are being reported. |
|
|
|
|
|
|
|
|
|
|
|
46 - 49 |
|
Blanks |
|
4 |
|
A/N |
|
Enter blanks |
|
|
|
|
|
|
|
|
|
|
|
50 - 63 |
|
State QTR Total Gross Wages |
|
14 |
|
N |
|
Enter quarterly wages subject to all taxes. Include all tip income. |
|
|
|
|
|
|
|
|
|
|
|
64 - 77 |
|
State QTR Unemployment Insurance Total Wages |
|
14 |
|
N |
|
Enter quarterly wages subject to unemployment taxes. Include all tip income. |
|
|
|
|
|
|
|
|
|
|
|
78 - 91 |
|
State QTR Unemployment Insurance Excess Wages |
|
14 |
|
N |
|
Quarterly wages in excess of the state U.I. taxable wage base. |
|
|
|
|
|
|
|
|
|
|
|
92 - 105 |
|
State QTR Unemployment Insurance Taxable Wages |
|
14 |
|
N |
|
State QTR U.I. total wages less state QTR U.I. excess wages. |
|
|
|
|
|
|
|
|
|
|
|
106 - 120 |
|
Quarterly State Disability Insurance Taxable Wages |
|
15 |
|
N |
|
States requiring this data will define. If not required, enter zeros. |
|
|
|
|
|
|
|
|
|
|
|
121 - 129 |
|
Quarterly Tip Wages |
|
9 |
|
N |
|
Include all tip income. If not required, enter zeros. |
|
|
|
|
|
|
|
|
|
|
|
130 -131 |
|
Number of Weeks Worked |
|
2 |
|
A/N |
|
The number of weeks worked in the reporting period. |
|
|
|
|
|
|
|
|
|
|
|
132 - 134 |
|
Number of Hours Worked |
|
3 |
|
A/N |
|
The number of hours worked in the reporting period. |
|
|
|
|
|
|
|
|
|
|
|
135 - 142 |
|
Blanks |
|
8 |
|
A/N |
|
Enter blanks. |
|
|
|
|
|
|
|
|
|
|
|
143 - 146 |
|
Taxing Entity Code |
|
4 |
|
A/N |
|
Constant "UTAX" |
|
|
|
|
|
|
|
|
|
|
|
147 - 161 |
|
State Unemployment Insurance Account Number |
|
15 |
|
A/N |
|
Enter state UI employer account number. |
|
|
|
|
|
|
|
|
|
|
|
162 - 176 |
|
Unit/Division Location/Plant Code |
|
15 |
|
A/N |
|
The ID assigned to identify wages by work site. |
|
|
|
|
|
|
|
|
|
|
|
177 - 190 |
|
State Taxable Wages |
|
14 |
|
N |
|
Enter wages subject to state income tax. |
|
|
|
|
|
|
|
|
|
|
|
191 - 204 |
|
State Income Tax Withheld |
|
14 |
|
N |
|
Enter state income tax withheld. |
|
|
|
|
|
|
|
|
|
|
|
205 - 206 |
|
Seasonal Indicator |
|
2 |
|
A/N |
|
States requiring this data will define. If not required, enter blanks. |
|
|
|
|
|
|
|
|
|
|
|
207 - 207 |
|
Employer Health Insurance Code |
|
1 |
|
A/N |
|
States requiring this data will define. If not required, enter blank. |
|
|
|
|
|
|
|
|
|
|
|
208 - 208 |
|
Employee Health Insurance Code |
|
1 |
|
A/N |
|
States requiring this data will define. If not required, enter blank. |
|
|
|
|
|
|
|
|
|
|
|
209 - 209 |
|
Probationary Code |
|
1 |
|
A/N |
|
States requiring this data will define. If not required, enter blank. |
|
|
|
|
|
|
|
|
|
|
|
210 - 210 |
|
Officer Code |
|
1 |
|
A/N |
|
For employees who are officers of the corporation, enter "1"; Otherwise, enter "0." |
|
|
|
|
|
|
|
|
|
|
|
211 - 211 |
|
Wage Plan Code |
|
1 |
|
A/N |
|
States requiring this data will define. If not required, enter blank. |
|
|
|
|
|
|
|
|
|
|
|
212 - 212 |
|
Month 1 Employment |
|
1 |
|
A/N |
|
Enter "1" if employee covered by U.I. worked during or received pay for the pay period including the 12th day of the 1st month of the reporting period. |
|
|
|
|
|
|
|
|
|
|
|
213 - 213 |
|
Month 2 Employment |
|
1 |
|
A/N |
|
Enter "1" if employee covered by U.I. worked during or received pay for the pay period including the 12th day of the 2nd month of the reporting period. |
|
|
|
|
|
|
|
|
|
|
|
214 - 214 |
|
Month 3 Employment |
|
1 |
|
A/N |
|
Enter "1" if employee covered by U.I. worked during or received pay for the pay period including the 12th day of the 3rd month of the reporting period. |
|
|
|
|
|
|
|
|
|
|
|
215 - 220 |
|
Reporting Quarter and Year |
|
6 |
|
A/N |
|
Enter the last month and year for the calendar quarter for which this report applies, e.g., "031997" for Jan-Mar of 1997. |
|
|
|
|
|
|
|
|
|
|
|
221 - 226 |
|
Date First Employed |
|
6 |
|
A/N |
|
Enter the month and year, e.g., "031997" |
|
|
|
|
|
|
|
|
|
|
|
227 - 232 |
|
Date of Separation |
|
6 |
|
A/N |
|
Enter the month and year, e.g., "031997" |
|
|
|
|
|
|
|
|
|
|
|
233 - 275 |
|
Blanks |
|
43 |
|
A/N |
|
Enter blanks. |
STANDARD MAGNETIC FORMAT FOR QUARTERLY WAGE REPORTING
RECORD NAME: T RECORD - TOTAL RECORD RECORD LENTH = 275
Some locations/fields in this record are state specific and will be defined by those states as required. Individual states should be contacted for specific information. DATA TYPES: A/N = ALPHANUMERIC; LEFT JUSTIFIED AND BLANK FILLED N = NUMERIC; RIGHT JUSTIFIED, ZERO FILLED, UNSIGNED DO NOT INCLUDE DECIMAL IN FIELDS CONTAINING DOLLARS AND CENTS.
|
LOCATION |
FIELD NAME |
FIELD |
TYPE |
DESCRIPTION AND REMARKS |
|
1 - 1 |
|
Record Identifier |
|
1 |
|
A/N |
|
Constant "T" |
|
|
|
|
|
|
|
|
|
|
|
2 - 8 |
|
Total Number of Employees |
|
7 |
|
N |
|
The total number of "S" records reported. The total number of "S" records since the last "E" record. |
|
|
|
|
|
|
|
|
|
|
|
9 - 12 |
|
Taxing Entity Code |
|
4 |
|
A/N |
|
Constant "UTAX" |
|
|
|
|
|
|
|
|
|
|
|
13 - 26 |
|
State QTR Total Gross Wages For Employer |
|
14 |
|
N |
|
Quarterly gross wages subject to all taxes. Total of this field on all "S" records since the last "E" record. |
|
|
|
|
|
|
|
|
|
|
|
27 - 40 |
|
State QTR Unemployment Insurance Total Wages For Employer |
|
14 |
|
N |
|
Quarterly wages subject to State U.I. tax. Include all tip income. Total of this field on all "S" records since the last "E" record. |
|
|
|
|
|
|
|
|
|
|
|
41 - 54 |
|
State QTR Unemployment Insurance Excess Wages for Employer |
|
14 |
|
N |
|
Quarterly wages in excess of the state U.I. taxable wage base. Total of this field on all "S" records since the last "E" record. |
|
|
|
|
|
|
|
|
|
|
|
55 - 68 |
|
State QTR Unemployment Insurance Taxable Wages For Employer |
|
14 |
|
N |
|
State U.I. total wages less quarterly state U.I. excess wages. Total of this field on all "S" records since the last "E" record. |
|
|
|
|
|
|
|
|
|
|
|
69 - 81 |
|
Quarterly tip wages for employer |
|
13 |
|
N |
|
Enter all tip income. Total of this field on all "S" records since the last "E" record. |
|
|
|
|
|
|
|
|
|
|
|
82 -87 |
|
U.I. Tax Rate This Quarter |
|
6 |
|
A/N |
|
The employer U.I. tax rate for this reporting period. Decimal point followed by 5 digits, e.g., 2.8% = .02800. |
|
|
|
|
|
|
|
|
|
|
|
88 - 100 |
|
State QTR U.I. Taxes Due |
|
13 |
|
N |
|
U.I. taxes due. Quarterly state U.I. taxable wages times U.I. tax rate. |
|
|
|
|
|
|
|
|
|
|
|
101 - 111 |
|
Previous Quarter(s) Underpayment |
|
11 |
|
N |
|
States requiring this data will define. If not required, enter zeros. |
|
|
|
|
|
|
|
|
|
|
|
112 - 122 |
|
Interest |
|
11 |
|
N |
|
States requiring this data will define. If not required, enter zeros. |
|
|
|
|
|
|
|
|
|
|
|
123 - 133 |
|
Penalty |
|
11 |
|
N |
|
States requiring this data will define. If not required, enter zeros. |
|
|
|
|
|
|
|
|
|
|
|
134 - 144 |
|
Credit/Overpayment |
|
11 |
|
N |
|
States requiring this data will define. If not required, enter zeros. |
|
|
|
|
|
|
|
|
|
|
|
145 - 148 |
|
Employer Assessment Rate |
|
4 |
|
A/N |
|
States requiring this data will define. If not required, enter blanks. |
|
|
|
|
|
|
|
|
|
|
|
149 - 159 |
|
Employer Assessment Amount |
|
11 |
|
N |
|
States requiring this data will define. If not required, enter zeros. |
|
|
|
|
|
|
|
|
|
|
|
160 - 163 |
|
Employee Assessment Rate |
|
4 |
|
A/N |
|
States requiring this data will define. If not required, enter blanks. |
|
|
|
|
|
|
|
|
|
|
|
164 - 174 |
|
Employee Assessment Amount |
|
11 |
|
N |
|
States requiring this data will define. If not required, enter zeros. |
|
|
|
|
|
|
|
|
|
|
|
175 - 185 |
|
Total Payment Due |
|
11 |
|
N |
|
States requiring this data will define. If not required, enter zeros. |
|
|
|
|
|
|
|
|
|
|
|
186 - 198 |
|
Allocation Amount |
|
13 |
|
N |
|
States requiring this data will define. If not required, enter zeros. |
|
|
|
|
|
|
|
|
|
|
|
199 - 212 |
|
Wages Subject to State Income Tax |
|
14 |
|
N |
|
States requiring this data will define. If not required, enter zeros. |
|
|
|
|
|
|
|
|
|
|
|
213 - 226 |
|
State Income Tax Withheld |
|
14 |
|
N |
|
States requiring this data will define. If not required, enter zeros. |
|
|
|
|
|
|
|
|
|
|
|
227 - 233 |
|
Month 1 Employment for Employer |
|
7 |
|
A/N |
|
Total number of employees covered by U.I. who worked or received pay for the pay period including the 12th day of the 1st month of the reporting period. Total of this field on all "S" records since the last "E" record. |
|
|
|
|
|
|
|
|
|
|
|
234 - 240 |
|
Month 2 Employment for Employer |
|
7 |
|
A/N |
|
Total number of employees covered by U.I. who worked or received pay for the pay period including the 12th day of the 2nd month of the reporting period. Total of this field on all "S" records since the last "E" record. |
|
|
|
|
|
|
|
|
|
|
|
241 - 247 |
|
Month 3 Employment for Employer |
|
7 |
|
A/N |
|
Total number of employees covered by U.I. who worked or received pay for the pay period including the 12th day of the 3rd month of the reporting period. Total of this field on all "S" records since the last "E" record. |
|
|
|
|
|
|
|
|
|
|
|
248 - 250 |
|
County Code |
|
3 |
|
A/N |
|
States requiring this data will define. If not required, enter blanks. |
|
|
|
|
|
|
|
|
|
|
|
251 - 257 |
|
Outside County Employees |
|
7 |
|
A/N |
|
States requiring this data will define. If not required, enter blanks. |
|
|
|
|
|
|
|
|
|
|
|
258 - 267 |
|
Document Control Number |
|
10 |
|
A/N |
|
States requiring this data will define. If not required, enter blanks. |
|
|
|
|
|
|
|
|
|
|
|
268 - 275 |
|
Blanks |
|
8 |
|
A/N |
|
Enter blanks. |
STANDARD MAGNETIC FORMAT FOR QUARTERLY WAGE REPORTING
RECORD NAME: F RECORD - FINAL RECORD RECORD LENTH = 275
Some locations/fields in this record are state specific and will be defined by those states as required. Individual states should be contacted for specific information. DATA TYPES: A/N = ALPHANUMERIC; LEFT JUSTIFIED AND BLANK FILLED N = NUMERIC; RIGHT JUSTIFIED, ZERO FILLED, UNSIGNED DO NOT INCLUDE DECIMAL IN FIELDS CONTAINING DOLLARS AND CENTS.
|
LOCATION |
FIELD NAME |
FIELD |
TYPE |
DESCRIPTION AND REMARKS |
|
1 - 1 |
|
Record Identifier |
|
1 |
|
A/N |
|
Constant "F" |
|
|
|
|
|
|
|
|
|
|
|
2 - 11 |
|
Total Number of Employees in File |
|
10 |
|
N |
|
Enter the total number of "S" records in the entire file. |
|
|
|
|
|
|
|
|
|
|
|
12 - 21 |
|
Total Number of Employers in File |
|
10 |
|
N |
|
Enter the total number of "E" records in the entire file. |
|
|
|
|
|
|
|
|
|
|
|
22 - 25 |
|
Taxing Entity Code |
|
4 |
|
A/N |
|
Constant "UTAX" |
|
|
|
|
|
|
|
|
|
|
|
26 - 40 |
|
Quarterly Total Gross Wages in File |
|
15 |
|
N |
|
Quarterly 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 |
|
15 |
|
N |
|
Quarterly wages subject to state U.I. tax. Total of this field on all "S" records in the file. |
|
|
|
|
|
|
|
|
|
|
|
56 - 70 |
|
Quarterly State Unemployment Insurance Excess Wages in File |
|
15 |
|
N |
|
Quarterly wages in excess of the state U.I. taxable wage base. Total of this field on all "S" records in the file. |
|
|
|
|
|
|
|
|
|
|
|
71 - 85 |
|
Quarterly State Unemployment Insurance Taxable Wages in File |
|
15 |
|
N |
|
State U.I. gross/total wage less quarterly state U.I. excess wages. Total of this field on all "S" records in the file. |
|
|
|
|
|
|
|
|
|
|
|
86 - 100 |
|
Quarterly State Disability Insurance Taxable Wages in File |
|
15 |
|
N |
|
States requiring this data will define. If not required, enter zeros. |
|
|
|
|
|
|
|
|
|
|
|
101 - 115 |
|
Quarterly Tip Wages in File |
|
15 |
|
N |
|
Enter all tip income. Total of this field on all "S" records in the file. |
|
|
|
|
|
|
|
|
|
|
|
116 - 123 |
|
Month 1 Employment for Employers in File |
|
8 |
|
A/N |
|
Total number of employees covered by U.I. who worked or received pay for the pay period including the 12th day of the 1st month of the reporting period. Total of this field on all "S" records in the file. |
|
|
|
|
|
|
|
|
|
|
|
124 - 131 |
|
Month 2 Employment for Employers in File |
|
8 |
|
A/N |
|
Total number of employees covered by U.I. who worked or received pay for the pay period including the 12th day of the 2nd month of the reporting period. Total of this field on all "S" records in the file. |
|
|
|
|
|
|
|
|
|
|
|
132 - 139 |
|
Month 3 Employment for Employers in File |
|
8 |
|
A/N |
|
Total number of employees covered by U.I. who worked or received pay for the pay period including the 12th day of the 3rd month of the reporting period. Total of this field on all "S" records in the file. |
|
|
|
|
|
|
|
|
|
|
|
140 - 275 |
|
Blanks |
|
136 |
|
A/N |
|
Enter blanks. |
Appendix A
TELEPHONE NUMBERS FOR THE STATE UNEMPLOYMENT INSURANCE MAGNETIC
Personnel at these telephone numbers can give callers information on how to submit Unemployment Insurance information on magnetic media. THESE ARE NOT TOLL-FREE NUMBERS.
|
|
STATE |
|
|
TELEPHONE |
|
|
Alabama |
|
|
(205) 242-8459 |
|
|
Alaska |
|
|
|
|
|
Arizona |
|
|
(602) 542-3515 |
|
|
Arkansas |
|
|
(501) 682-3253 |
|
|
California |
|
|
(916) 654-6845 |
|
|
Colorado |
|
|
(303) 620-4790 |
|
|
Connecticut |
|
|
|
|
|
Delaware |
|
|
|
|
|
District of Columbia |
|
|
|
|
|
Florida |
|
|
(904) 921-3284 |
|
|
Georgia |
|
|
(404) 656-6244 |
|
|
Hawaii |
|
|
(808) 586-9075 |
|
|
|
|
|
(808) 586-8982 |
|
|
Idaho |
|
|
(208) 334-6363 |
|
|
Illinois |
|
|
(312) 793-7556 |
|
|
Indiana |
|
|
|
|
|
Indiana |
|
|
|
|
|
Iowa |
|
|
(515) 281-5339 |
|
|
Kansas |
|
|
(913) 296-5067 |
|
|
Kentucky |
|
|
(502) 564-2168 |
|
|
Louisiana |
|
|
|
|
|
Maine |
|
|
(207) 287-1244 |
|
|
Maryland |
|
|
(410) 767-2530 |
|
|
Massachusetts |
|
|
(617) 621-5016 |
|
|
Michigan |
|
|
|
|
|
Minnesota |
|
|
(612) 297-5260 |
|
|
Mississippi |
|
|
(601) 961-7768 |
|
|
Missouri |
|
|
(314) 751-2271 (314) 751-1427
|
|
|
Montana |
|
|
(406) 444-4269 |
|
|
Nebraska |
|
|
(402) 471-3407 |
|
|
Nevada |
|
|
(702) 687-3755 |
|
|
|
|
|
(702) 687-4487 |
|
|
New Hampshire |
|
|
|
|
|
New Jersey |
|
|
(609) 633-2154 |
|
|
New Mexico |
|
|
(505) 841-8559 |
|
|
New York |
|
|
|
|
|
North Carolina |
|
|
(919) 733-7395 |
|
|
North Dakota |
|
|
|
|
|
Ohio |
|
|
|
|
|
Oklahoma |
|
|
(405) 557-7170 |
|
|
Oregon |
|
|
(503) 378-3524 ext. 270 |
|
|
Pennsylvania |
|
|
(717) 783-5802 |
|
|
Puerto Rico |
|
|
|
|
|
Rhode Island |
|
|
|
|
|
South Carolina |
|
|
(803) 737-3080 |
|
|
South Dakota |
|
|
(605) 622-2317 |
|
|
Tennessee |
|
|
(615) 741-3121 |
|
|
Texas |
|
|
(512) 463-2508 |
|
|
Utah |
|
|
|
|
|
Vermont |
|
|
(802) 828-4225 |
|
|
Virgin Islands |
|
|
|
|
|
Virginia |
|
|
(804) 786-1159 |
|
|
Washington |
|
|
(206) 586-4863 |
|
|
West Virginia |
|
|
(304) 558-2662 |
|
|
Wisconsin |
|
|
(608) 267-2975 |
|
|
Wyoming |
|
|
|
APPENDIX B
FEDERAL INFORMATION PROCESSING STANDARD
(FIPS 5-2) POSTAL ABBREVIATIONS AND NUMERIC CODES
|
|
|
Abbreviation |
Numeric |
|
|
|
Alabama |
AL |
01 |
|
|
|
Alaska |
AK |
02 |
|
|
|
Arizona |
AZ |
04 |
|
|
|
Arkansas |
AR |
05 |
|
|
|
California |
CA |
06 |
|
|
|
Colorado |
CO |
08 |
|
|
|
Connecticut |
CT |
09 |
|
|
|
Delaware |
DE |
10 |
|
|
|
District of Columbia |
DC |
11 |
|
|
|
Florida |
FL |
12 |
|
|
|
Georgia |
GA |
13 |
|
|
|
Hawaii |
HI |
15 |
|
|
|
Idaho |
ID |
16 |
|
|
|
Illinois |
IL |
17 |
|
|
|
Indiana |
IN |
18 |
|
|
|
Iowa |
IA |
19 |
|
|
|
Kansas |
KS |
20 |
|
|
|
Kentucky |
KY |
21 |
|
|
|
Louisiana |
LA |
22 |
|
|
|
Maine |
ME |
23 |
|
|
|
Maryland |
MD |
24 |
|
|
|
Massachusetts |
MA |
25 |
|
|
|
Michigan |
MI |
26 |
|
|
|
Minnesota |
MN |
27 |
|
|
|
Mississippi |
MS |
28 |
|
|
|
Missouri |
MO |
29 |
|
|
|
Montana |
MT |
30 |
|
|
|
Nebraska |
NE |
31 |
|
|
|
Nevada |
NV |
32 |
|
|
|
New Hampshire |
NH |
33 |
|
|
|
New Jersey |
NJ |
34 |
|
|
|
New Mexico |
NM |
35 |
|
|
|
New York |
NY |
36 |
|
|
|
North Carolina |
NC |
37 |
|
|
|
North Dakota |
ND |
38 |
|
|
|
Ohio |
OH |
39 |
|
|
|
Oklahoma |
OK |
40 |
|
|
|
Oregon |
OR |
41 |
|
|
|
Pennsylvania |
PA |
42 |
|
|
|
Rhode Island |
RI |
44 |
|
|
|
South Carolina |
SC |
45 |
|
|
|
South Dakota |
SD |
46 |
|
|
|
Tennessee |
TN |
47 |
|
|
|
Texas |
TX |
48 |
|
|
|
Utah |
UT |
49 |
|
|
|
Vermont |
VT |
50 |
|
|
|
Virginia |
VA |
51 |
|
|
|
Washington |
WA |
53 |
|
|
|
West Virginia |
WV |
54 |
|
|
|
Wisconsin |
WI |
55 |
|
|
|
Wyoming |
WY |
56 |
|
TERRITORIES AND POSSESSIONS
|
|
American Samoa |
AS |
|
|
|
Guam |
GU |
|
|
|
Puerto Rico |
PR |
|
|
|
Virgin Islands |
VI |
|
|
|
Northern Mariana Islands |
MP |
|
MILITARY POST OFFICES (APO AND FPO)
|
|
Canada, Europe, Africa and the Middle East |
AE |
|
|
|
Central American and South America |
AA |
|
|
|
Alaska and the Pacific |
AP |
|
|
|
Contingency Operations |
AC |
|
APPENDIX C
ACCEPTABLE CHARACTER SETS
The following charts contain the character sets that can be directly read or translated. The translations are shown character for character; i.e., unpacked. EBCDIC is the standard character set used. The charts do not show every character for each character set, just the most commonly used characters.
|
EBCDIC |
||||
|
|
EBCDIC |
Hex |
Decimal |
|
|
|
|
|
|
|
|
|
O |
C0 |
192 |
|
|
|
A |
C1 |
193 |
|
|
|
B |
C2 |
194 |
|
|
|
C |
C3 |
195 |
|
|
|
D |
C4 |
196 |
|
|
|
E |
C5 |
197 |
|
|
|
F |
C6 |
198 |
|
|
|
G |
C7 |
199 |
|
|
|
H |
C8 |
200 |
|
|
|
I |
C9 |
201 |
|
|
|
J |
D1 |
209 |
|
|
|
K |
D2 |
210 |
|
|
|
L |
D3 |
211 |
|
|
|
M |
D4 |
212 |
|
|
|
N |
D5 |
213 |
|
|
|
O |
D6 |
214 |
|
|
|
P |
D7 |
215 |
|
|
|
Q |
D8 |
216 |
|
|
|
R |
D9 |
217 |
|
|
|
S |
E2 |
226 |
|
|
|
T |
E3 |
227 |
|
|
|
U |
E4 |
228 |
|
|
|
V |
E5 |
229 |
|
|
|
W |
E6 |
230 |
|
|
|
X |
E7 |
231 |
|
|
|
Y |
E8 |
232 |
|
|
|
Z |
E9 |
233 |
|
|
|
0 |
F0 |
240 |
|
|
|
1 |
F1 |
241 |
|
|
|
2 |
F2 |
242 |
|
|
|
3 |
F3 |
243 |
|
|
|
4 |
F4 |
244 |
|
|
|
5 |
F5 |
245 |
|
|
|
6 |
F6 |
246 |
|
|
|
7 |
F7 |
247 |
|
|
|
8 |
F8 |
248 |
|
|
|
9 |
F9 |
249 |
|
|
|
Blank |
40 |
64 |
|
|
|
-(Hyphen) |
60 |
96 |
|
|
|
'(Apostrophe) |
7D |
125 |
|
|
ASCII-1 |
|
ASCII-2 |
|||||
|
ASCII-1 |
|
HEX |
|
ASCII-2 |
|
HEX |
|
|
Decimal |
Character |
|
|
Decimal |
Character Value |
|
|
|
|
|
|
|
|
|
|
|
|
48 |
0 |
30 |
|
176 |
0 |
B0 |
|
|
49 |
1 |
31 |
|
177 |
1 |
B1 |
|
|
50 |
2 |
32 |
|
178 |
2 |
B2 |
|
|
51 |
3 |
33 |
|
179 |
3 |
B3 |
|
|
52 |
4 |
34 |
|
180 |
4 |
B4 |
|
|
53 |
5 |
35 |
|
181 |
5 |
B5 |
|
|
54 |
6 |
36 |
|
182 |
6 |
B6 |
|
|
55 |
7 |
37 |
|
183 |
7 |
B7 |
|
|
56 |
8 |
38 |
|
184 |
8 |
B8 |
|
|
57 |
9 |
39 |
|
185 |
9 |
B9 |
|
|
65 |
A |
41 |
|
193 |
A |
C1 |
|
|
66 |
B |
42 |
|
194 |
B |
C2 |
|
|
67 |
C |
43 |
|
195 |
C |
C3 |
|
|
68 |
D |
44 |
|
196 |
D |
C4 |
|
|
69 |
E |
45 |
|
197 |
E |
C5 |
|
|
70 |
F |
46 |
|
198 |
F |
C6 |
|
|
71 |
G |
47 |
|
199 |
G |
C7 |
|
|
72 |
H |
48 |
|
200 |
H |
C8 |
|
|
73 |
I |
49 |
|
201 |
I |
C9 |
|
|
74 |
J |
4A |
|
202 |
J |
CA |
|
|
75 |
K |
4B |
|
203 |
K |
CB |
|
|
76 |
L |
4C |
|
204 |
L |
CC |
|
|
77 |
M |
4D |
|
205 |
M |
CD |
|
|
78 |
N |
4E |
|
206 |
N |
CE |
|
|
79 |
O |
4F |
|
207 |
O |
CF |
|
|
80 |
P |
50 |
|
208 |
P |
DO |
|
|
81 |
Q |
51 |
|
209 |
Q |
D1 |
|
|
82 |
R |
52 |
|
210 |
R |
D2 |
|
|
83 |
S |
53 |
|
211 |
S |
D3 |
|
|
84 |
T |
54 |
|
212 |
T |
D4 |
|
|
85 |
U |
55 |
|
213 |
U |
D5 |
|
|
86 |
V |
56 |
|
214 |
V |
D6 |
|
|
87 |
W |
57 |
|
215 |
W |
D7 |
|
|
88 |
X |
58 |
|
216 |
X |
D8 |
|
|
89 |
Y |
59 |
|
217 |
Y |
D9 |
|
|
90 |
Z |
5A |
|
218 |
Z |
DA |
|
|
32 |
Blank |
20 |
|
160 |
Blank |
AO |
|
|
39 |
Apostrophe |
27 |
|
167 |
Apostrophe |
A7 |
|
|
45 |
Hyphen |
2D |
|
173 |
Hyphen |
AD |
|
APPENDIX D
GLOSSARY
AGENT - An organization (e.g., service bureau, parent company) authorized to submit wage and tax reports for one or more employers.
ASCII (American Standard Code for Information Interchange) - One of the acceptable character sets (See Appendix C) used for electronic processing of data.
BLOCK - PHYSICAL RECORD.
BLOCK DESCRIPTOR WORD (BDW) - A control field used in electronic data processing to identify the length of a physical record on a magnetic tape. The BDW usually precedes the physical record.
BPI - Bytes per inch. Same as CPI.
BYTE - A computer unit of measure; one byte contains eight bits and can store one character.
CHARACTER - A letter, number or punctuation symbol.
CHARACTER SET - A group of unique electronic definitions for all letters, numbers and punctuation symbols; example: EBCDIC, ASCII.
CHARACTERS PER INCH (CPI) - The number of characters recorded per inch on magnetic tape.
CONTROL WORD - One or more bytes/characters used in electronic data processing for internal processing instructions.
CPI - Characters per inch.
DECIMAL VALUE - A character's equivalent in a numbering system using base 10.
EBCDIC (Extended Binary Coded Decimal Interchange Code) - One of the acceptable character sets used for electronic processing of data. See Appendix C.
EIN - Employer Identification Number.
EMPLOYER IDENTIFICATION NUMBER - A nine digit number assigned by the IRS to an organization for federal tax reporting purposes. This number never begins with "69."
FILE (Multi-reel/Multiple Volume) - Multiple reel tape files should not be submitted. If the amount of information to be filed exceeds the capacity of a single reel, a second or additional reel can be filed. Each file must begin with a Code A record and end with a Code F record. However, multiple volume diskette files are acceptable. (See Section IV.)
HEADER LABELS - Sets of records that precede data records on a magnetic tape file. See Section III.
HEXADECIMAL - A numbering system using base 16 rather than base 10.
INTERNAL LABELS - Sets of records that precede (i.e., header labels) and follow (i.e., trailer labels) data records on a magnetic tape file. See Section III.
LOGICAL RECORD - For the purpose of this booklet, any of the required or optional records defined in Section V.
OCTAL - A numbering system using base 8 rather than base 10.
PHYSICAL RECORD - A number of logical records grouped and written together as a single unit on a magnetic tape. For reporting Unemployment Insurance data on magnetic tape, a physical record may contain a maximum of 85 logical records.
RECORD DESCRIPTOR WORD (RDW) - A control field used in electronic processing to identify the length of a logical record. The RDW usually precedes the logical record.
RECORDING CODE - Same as CHARACTER SET.
STATE UNEMPLOYMENT INSURANCE ACCOUNT NUMBER - An employer identification number assigned by a State to an employer for the purposes of filing Unemployment Insurance wage and tax reports to State agencies.
TAPEMARK - A single-character control record used for separating internal labels and files on magnetic tape. See Section III.
TRAILER LABELS - Sets of records that follow data records on a magnetic tape file. See Section III.
TRANSMITTER - Person, organization, or reporting agent submitting a magnetic media file.
APPENDIX E
LABELS AND PACKAGING FOR MAGNETIC MEDIA REPORTS
External Labels
States will specify the format of any required external label.
Packaging Magnetic Tapes for Mailing
Package the magnetic tape with an external label on each tape and with the appropriate transmittal forms, together in a box with proper padding to prevent damage in transit. It is not necessary to use an oversized box for a tape. Specially-sized boxes for magnetic tapes are available commercially. Use disposable tape containers as most states will not return special containers.