FILE DESCRIPTION: E-TRAC.CLIENT.TAPE 7/6/2001

DESCRIPTION:

The E-TRAC.CLIENT.TAPE is a format used by e-Trac clients to submit data on a periodic basis to the e-Trac Insurance Tracking System.

FORMAT:

1) Data will be in ASCII format.

2) Alpha and Alpha/Numeric fields will be left justified with trailing spaces.

3) Numeric fields will be right justified. Field types 'I' or 'V' have leading spaces. Field type 'L' has leading zeroes.

4) 'Over punch' characters are not allowed on numeric fields. Negative numbers must have a leading '-' minus character.

5) Dates will be formatted CCYYMMDD.

6) Identify physical media with the proper return address and creation date.

NARRATIVE:

This format consists of at a minimum, a single record per loan, with optionally an additional 8 records per loan for multiple collateral.

FIELD TYPES:

L = Integer field - zero filled

I = Integer field

V = Numeric field - implied decimal point

C = Alpha-numeric field

SUBMISSION:

The preferred method of data submission is via email attachment or FTP. We can act either as the client or host of a FTP session. Please see the instructions for both email and FTP submission methods at the end of this document. Alternate methods include diskette or reel tape. Data submitted on reel tape must conform to the following specifications: coding: EBCDIC, density: 800,1600 or 6250, labeled or unlabeled (please specify), maximum block size: 10K bytes. Data may be optionally submitted on data cartridge.

File Definition

DATAFILE NAME: E-TRAC.CLIENT.TAPE 7/ 6/2001

33 ITEMS: STARTING IN POSITION 1

COL ITEM NAME WDTH OPUT TYP N.DEC ALTERNATE NAME

1 CLIENT 4 4 L 0

5 LOAN-NUMBER 11 11 L 0

16 COLLATERAL-NO 1 1 I -

17 SORT-NAME 30 30 C -

47 NAME 30 30 C -

77 ADR-1 30 30 C -

107 ADR-2 30 30 C -

137 CITY 21 21 C -

158 FILL-1 1 1 C -

159 STATE 2 2 C -

161 FILL-2 1 1 C -

162 ZIP 5 5 I -

167 BRANCH 3 3 L 0

170 RECORD-TYPE 1 1 I -

171 PROP-TYPE 4 4 C -

175 LOAN-TYPE 4 4 C -

179 CURRENT-BALANCE 8 8 I -

187 LOAN-DATE 8 8 I -

195 MATURE-DATE 8 8 I -

203 OFFICER 4 4 C -

207 PADR-1 30 30 C -

237 PCITY 21 21 C -

258 FILL-3 1 1 C -

259 PSTATE 2 2 C -

261 FILL-4 1 1 C -

262 PZIP 5 5 I -

267 COLL-YEAR 4 4 I -

271 COLL-SERIAL 6 6 C -

277 COLL-DESC 30 30 C -

307 REPO/FORCL-FLAG 1 1 C -

308 PAYOFF-DATE 8 8 I -

316 USER-DATA 4 4 C -

320 FILL-5 31 31 C -

DATA DICTIONARY

Required elements are in bold/italic type.

Field Description: CLIENT-NO File Position: 1 Length: 4

Narrative: This field contains the users client number as assigned by e-Trac.

Field Description: LOAN-NUMBER File Position: 5 Length: 11

Narrative: Insert your loan number. If your key has less than 11 digits, right justify and zero fill.

Field Description: COLLATERAL-NO File Position: 16 Length: 1

Narrative: If multiple collateral secure this loan, create one record for each piece (up to nine) and number them sequentially beginning with 1. Insert a one if there is only one piece of collateral securing this loan.

Field Description: SORT-NAME File Position: 17 Length: 30

Narrative: Insert the sort-name field if available. Blank fill if no sort-name field is available.

Field Description: NAME File Position: 47 Length: 30

Narrative: Insert the primary name.

Field Description: ADR-1 File Position: 77 Length: 30

Narrative: Insert the first address line.

Field Description: ADR-2 File Position: 107 Length: 30

Narrative: Insert the second address line.

Field Description: CITY File Position: 137 Length: 21

Narrative: Insert the city name.

Field Description: FILL-1 File Position: 158 Length: 1

Narrative: Blank fill.

Field Description: STATE File Position: 159 Length: 2

Narrative: Insert the two character state abbreviation.

Field Description: FILL-2 File Position: 161 Length: 1

Narrative: Blank fill.

Field Description: ZIP File Position: 162 Length: 5

Narrative: Insert the five-digit zip code

Alternate mailing address submission

If it is not possible to provide the mailing city, state and zip in separate fields, they may be provided as a single combined 30-character field by using positions 137 through 166 (CITY, FILL-1, STATE, FILL-2 & ZIP).

Field Description: BRANCH File Position: 167 Length: 3

Narrative: Insert your branch code and provide a list of names and addresses.

Field Description: RECORD-TYPE File Position: 170 Length: 1

Narrative: This field indicates which type of record is present as follows:

0 = N/A 2 = Mobile Home 4 = Second Mortgage 6-9 = N/A

1 = Consumer Loan 3 = Mortgage 5 = Lease

Field Description: PROP-TYPE File Position: 171 Length: 4

Narrative: Insert your property-type code and provide a list of codes and definitions.

Field Description: LOAN-TYPE File Position: 175 Length: 4

Narrative: Insert your loan-type code and provide a list of codes and definitions.

Field Description: CURRENT-BALANCE File Position: 179 Length: 8

Narrative: Insert the current outstanding balance in whole dollars.

Field Description: LOAN-DATE File Position: 187 Length: 8

Narrative: Insert the loan origination date in the format CCYYMMDD.

CC = the century, YY = year, MM = month, DD = day.

Field Description: MATURE-DATE File Position: 195 Length: 8

Narrative: Insert the loan/lease maturity date in the format detailed in position 187 LOAN-DATE.

Field Description: OFFICER File Position: 203 Length: 4

Narrative: Insert the loan officer identification code.

Field Description: PADR-1 File Position: 207 Length: 30

Narrative: For RECORD-TYPE = 2,3, & 4 insert the property street address. For RECORD-TYPE = 1 or 5 do the same if the equipment location differs from the mailing address.

Field Description: PCITY File Position: 237 Length: 21

Narrative: Insert the city name.

Field Description: FILL-3 File Position: 258 Length: 1

Narrative: Blank fill.

Field Description: PSTATE File Position: 259 Length: 2

Narrative: Insert the two character state abbreviation.

Field Description: FILL-4 File Position: 261 Length: 1

Blank fill.

Field Description: PZIP File Position: 262 Length: 5

Narrative: Insert the five-digit zip code

Alternate property address submission

If it is not possible to provide the mailing city, state and zip in separate fields, they may be provided as a single combined 30-character field by using positions 137 through 166 (CITY, FILL-1, STATE, FILL-2 & ZIP).

Field Description: COLL-YEAR File Position: 267 Length: 4

Narrative: For RECORD-TYPE = 1,2 & 5 insert the collateral year of manufacture.

Field Description: COLL-SERIAL File Position: 271 Length: 6

Narrative: Insert the last six digits of the serial number.

Field Description: COLL-DESC File Position: 277 Length: 30

Narrative: Insert the collateral description, i.e. the vehicle make and model. If your loan servicing system has separate fields for the make and model, combine them in this field.

Field Description: REPO/FORCL-FLAG File Position: 307 Length: 1

Narrative: Insert by RECORD-TYPE as follows:

RECORD-TYPE FLAG DESCRIPTION

1,2,3,4,5 <blank> Normal status

1 R Repossession

2,3,4,5 F Foreclosure

Field Description: PAYOFF-DATE File Position: 308 Length: 8

Narrative: Insert the payoff-date when the loan pays off.

Field Description: USER-DATA File Position: 316 Length: 4

Narrative: This area is reserved for user-defined data.

Field Description: FILL-5 File Position: 320 Length: 31

Narrative: Filler area - blank fill.

e-Trac Data Submission via email

These instructions assume you are using Microsoft Windows 95 or 98 and Outlook to send and receive email. They also assume that the file to be transmitted is on the sending system, and that an Internet connection has already been established.

1. Create a new email message directed to custdata@seattlespecialty.com

· Click [File], [New], [Mail Message]

· The blank message will appear. Type the address above in the first line, ‘To…’

· Include your financial institution name in the ‘Subject’ such as ‘Equality State Bank data’

· Insert any descriptive information in the body of the message as desired.

2. Attach the data file to the message.

· Click [Insert], [File] or click on the paperclip icon and a dialog box will open.

· Move to the drive and directory containing the file to be sent. Double click on the file name, or single click and click on [OK].

· Make sure that ‘Attachment’ is selected under ‘Insert as’. (Attachment is the default)

· The file will appear as an icon as the bottom of your message.

· Repeat these three steps if additional files are to be included in this message.

· Click [Send] to send the message.

e-Trac Data Submission via FTP

Seattle Specialty provides a secure FTP site for the submission of client via Internet FTP (file transfer protocol). The site does not allow for anonymous usage, so you will be provided with a user name and password to use the site.

Your user name is:

Your password is:

Windows 95/98/2000, etc all come with a built in FTP client. You can also use graphical FTP programs, such as CuteFTP (http://www.globalscape.com/), Bulletproof FTP (http://www.bpftp.com/) or others. Call if you have any questions in this regard.

The address for the FTP server is 63.145.197.9. You will have read/write authority. You will not be able to delete files on the server.

Please send an email message to custdata@seattlespecialty.com indicating the transfer has been completed. Contact the Information Systems department at Seattle Specialty if you have any questions at (800) 597-1866.