APPENDIX B: ASCII File Format Specifications

While the Unemployment Insurance Electronic Entry System allows for manual entry of data into screen formats, it also allows for users to upload a file containing data which was created on a mainframe, PC or elsewhere. As long as the file conforms to the specifications shown below for the given table and passes edits, the system will take it. Following each UI report table name is a list of expected data cells. The cell names are the same as those appearing on the report's table and match those displayed in the manual entry screens though the ordering may be different. Do not use leading zeros or commas in the entries.

The system will take five data types: date, smallint, integer, decimal, and character (char).

The date type is a numeric field in the form of mmddyyyy. The month, day, and year components of the date field can be separated by slash (/), dash (-), or nothing. Each date component must be a legitimate date (no month 13). When it is loaded into the entry system, other edits will check that it is a legitimate date for the specified report.

The smallint data type is a numeric field with a permitted range of -32,768 to +32,768.

The integer data type has a permitted range of -2,147,483,648 to +2,147,483,648.

The decimal field is represented by decimal(m,n), where m is <=32 significant digits (the precision) and n represents the number of digits to the right of the decimal point (the scale). The decimal data type is a numeric field with a range up to 32 significant digits with exponents in the range of -128 to +126. The decimal point must be included in the upload file.

Character is a letter or number represented by char(n), where n stands for the length of the character field.

The first line of the ASCII file must contain the related report date (rptdate).

EXCEPTIONS:

ETA 191. This report is different from the others because it is stored on two tables but uses only one upload file. The data for Section B of the report follows immediately after the Section A data. Section B consists of agency codes (c1) and expenditures for that agency (c2). As many pairs of c1 and c2 will be used as is necessary to record the data as indicated by the * shown in the file specifications.

ETA 204. This report is also stored in multiple tables. The data for Sections A and B are on one table and follow the general rules. The data for Section C is stored on one of two different tables depending if the data represent a State with a benefit ratio system (ar204b) or a reserve ratio system (ar204r) of taxing. Section C consists of reporting six elements, one on each line of the ASCII file, and repeating these six elements for each category associated with the specific taxing system.

ETA 9056 and ETA 9057 Skeleton-Load File Layouts. The ETA 9056 and ETA 9057 reports are also different because they require a subset of data (that is, skeleton data) loaded and verified before the rest of the data may be entered. The following are the file layouts for skeleton data for these reports. As the tables below show, the files must have at least two lines, each ending with a carriage return. The data elements of each line are delimited by space.

Line 1. Contains the quarter end date of the quarter to which the data applies, followed by a space and then the database table name, either ar9056 or ar9057 as appropriate.

Line 2 and all subsequent lines. Each line contains all the skeleton fields pertaining to a single case in the quality sample for the appropriate report delimited by a space with a carriage return at the end of each line.

Table: ar9056

Line 1	rptdate	rptname
Line 2	c1 Case ID decimal (5,0)	c2 Issue Code Char(2)	c9 Week Claimed char(1)	c10 Week End Date (mmddyyyy)	c24 Determination Date (mmddyyyy)

Example: 12311996 ar9056

103 10 y 08311996 09061996

104 29 n 08311996 09061996

105 40 n 08311996 09061996

Table: ar9057

Line 1	rptdate	rptname
Line 2	c1 Case ID decimal(5,0)	c35 Decision Date (mmddyyyy)	c39 Case Docket Number char(12)

Example: 12311996 ar9057

8 08311996 UT12345612a

9 08311996 UT12345612b

10 08311996 UT12345613a