Instruction Guide

for 

Rural Development

Electronic Reporting of Annual Status for Guaranteed Rural Housing Loans

� TOC \o "1-3" �Introduction	� GOTOBUTTON _Toc375038282  � PAGEREF _Toc375038282 �2��

File Preparation Instructions	� GOTOBUTTON _Toc375038283  � PAGEREF _Toc375038283 �4��

Flat Sequential File	� GOTOBUTTON _Toc375038284  � PAGEREF _Toc375038284 �4��

Business Scenario for ASCII Flat Sequential File Format	� GOTOBUTTON _Toc375038285  � PAGEREF _Toc375038285 �7��

ANSI X.12 Format	� GOTOBUTTON _Toc375038286  � PAGEREF _Toc375038286 �7��

Business Scenario for ANSI X.12 Format	� GOTOBUTTON _Toc375038287  � PAGEREF _Toc375038287 �13��

EDI Data Mapping and Transmission Options	� GOTOBUTTON _Toc375038288  � PAGEREF _Toc375038288 �16��

Create Flat File, Perform EDI Data Mapping, and Transmit Data on a Local PC	� GOTOBUTTON _Toc375038289  � PAGEREF _Toc375038289 �16��

Service Bureau Creates Flat File, Performs EDI Data Mapping, and Transmits Data	� GOTOBUTTON _Toc375038290  � PAGEREF _Toc375038290 �17��

Service Bureau Only Creates Flat File and then EDI Data Mapping and Transmission Performed on a Local PC	� GOTOBUTTON _Toc375038291  � PAGEREF _Toc375038291 �17��

Transmission Instructions	� GOTOBUTTON _Toc375038292  � PAGEREF _Toc375038292 �17��

Transmitting using Windows Communications	� GOTOBUTTON _Toc375038293  � PAGEREF _Toc375038293 �18��

Receiving EDI Acknowledgments	� GOTOBUTTON _Toc375038294  � PAGEREF _Toc375038294 �18��

��

Instruction Guide

for 

Rural Development

Electronic Reporting of Annual Status

 for Guaranteed Rural Housing Loans

Introduction

The U.S. Department of Agriculture (USDA),  Rural Development (RD) is conducting an Electronic Data Interchange (EDI) pilot project to allow lenders/servicers to electronically submit their guaranteed Rural Housing (RH) loan status reports.

All lenders are encouraged to participate in this pilot and a 30-day extension may be granted to lenders submitting data electronically.  The extensions applies only to new participants and does not include the lenders that participated in the pilot test.  The purpose of the extension is to allow for completion of a test and final transmission.     

This pilot project was initiated to evaluate the use of electronic commerce with commercial financial institutions that are participating in the Guaranteed Loan program as lenders and/or servicers.  The primary objective is to establish a foundation with links upon which the USDA RD can build expanded electronic commerce applications.  Even though this project is limited to one report and one guaranteed loan program area, it will hopefully, establish a working procedure which can be refined and improved for use by all Lenders to meet various requirements in the future.

The RH status report data will be accepted by RD in the EDI ANSI X.12 format or in an ASC II flat sequential file format.  Whichever format is used, the pilot project EDI transmission must occur, on or before January 31, 1997, at 7:00 p.m. Central time, for the annual RH status report unless an extension is granted then the date will be March 3, 1997.

Attached are the specifications for creating a standard flat file with the guaranteed RH loan data and instructions for mapping this flat file into an EDI Transaction Set 203, Secondary Mortgage Market Investor Report.  Also included are business scenarios and options for creating EDI messages, even if you are supported by a service bureau, and transmitting the files to RD.

Any lender wanting to send data electronically is asked to contact our EDI coordinator as soon as possible and provide the following information.

Identify the option your organization has selected for formatting the data, either ANSI X.12 Transaction Set 203 format or ASC II flat sequential file.

Identify a date when your organization can send a test transmission to RD along with a hard copy listing of transmission.

If you have any questions, please call our EDI coordinator at (314) 539-6134. If you would prefer to mail your information, the mailing address is:

LaVern Watson

Mail Code FC-350

Rural Development

1520 Market Street

St. Louis, MO  63103

�

File Preparation Instructions

The information you will need to extract for each guaranteed Rural Housing loan from your system/records includes the following data as of December 31: the Borrower’s ID; your Loan Number; our Agency Loan Number; Borrower’s Name; Unpaid Principal; Unpaid Interest; determination if real estate taxes, flood insurance, and hazard insurance are current; determination if the guarantee should be terminated; determination of the loan’s payment status; the Amount the loan is Ahead/Behind; and the Date of Loan.

Flat Sequential File

Below, is an outline of how this RH status information should be formatted into a ASCII flat sequential file that will be acceptable by RD.

Header Record

Element Name�

Type/

Size�

Position�

Valid Values�

�

RD Identifier�

Text, 6�

1 - 6�

Must equal “RDFSFT” for test transmission or “RDFSFP” for production transmission�

�

Trading Partner ID�

Text, 13�

7 - 19�

Insert “S” and then Lender’s Internal Revenue Service Tax Identification Number followed by the Lender’s Branch Number assigned by RD.  If this is a transmission by the central office for all branches use “000” for the Lender Branch Number.�

�

Program Type�

Text, 2�

20 - 21 �

Insert RH for Rural Housing loans.�

�

Report Type �

Text, 1�

22�

Insert A for Annual reports (RH only).�

�

Total Detail Records�

Number, 4�

23 - 26�

Total number of detail records included in this transmission.  Right justify and zero fill.�

�

Detail Record(s)

Element Name�

Type/

Size�

Position�

Valid Values�

�

As Of Date�

Date, 8�

1 - 8�

Insert Date of status report expressed as YYYYMMDD.�

�

Lender ID Number�

Number, 9�

9 - 17�

Insert the Lender’s Internal Revenue Service Tax Identification Number.�

�

Lender Loan Nbr�

Text, 16�

18 - 33�

Insert Lender’s assigned Loan Number.  Left justify and blank fill.�

�

Borrower ID�

Number, 9�

34 - 42�

Insert Borrower’s Social Security or Internal Revenue Service Tax Identification Number.�

�

Borrower Name�

Text, 38�

43 - 80�

Insert Borrower’s Name - abbreviate when necessary.  Left justify and blank fill.�

�

Agency Loan Nbr�

Number, 2�

81 - 82�

Insert Guaranteed Loan Number assigned by RHS.  If it is unknown, insert “50”.�

�

Unpaid Principal�

Number, 14�

83 - 96�

Insert current unpaid principal balance on the loan as of the date of report expressed as PIC 9(12)V99.  Right justify and zero fill.�

�

Unpaid Interest�

Number, 14�

97 - 110�

Insert the current unpaid interest balance on the loan as of the date of the report expressed as PIC 9(12)V99.  Right justify and zero fill.�

�

RE Tax Current�

Text, 1�

111�

Insert Y if Real Estate taxes are current, N if not.�

�

Flood Ins Current�

Text, 1�

112�

Insert Y if flood insurance payments are current, N if not, or leave blank if the property is not subject to flood insurance.�

�

Hazard Ins Current�

Text, 1�

113�

Insert Y if hazard insurance payments are current, N if not, or leave blank if the property is not subject to hazard insurance.�

�

Terminate Guarantee�

Text, 1�

114�

Insert Y to terminate the guarantee or N to continue with the guarantee.  Guarantees should be terminated only if the loan has been paid in full or the lender and borrower decide to continue with the loan without the guarantee.�

�

Payment Status Cde�

Text, 1�

115�

Insert A if the account is ahead of schedule, B if the account is behind schedule, and C if the account is current.  If B is entered Form RHS 1980-81, “Guaranteed Rural Housing Loan Default Status” must be prepared by Lender.�

�

Amount Ahd/Bhnd�

Number, 14�

116 - 129�

Insert the amount the account is ahead or behind schedule expressed as PIC 9(12)V99 (total principal and interest only without late fees or taxes and insurance).  Insert 14 zeroes if Payment Status Code is C. Right justify and zero fill.�

�

Date of Loan�

Date, 8�

130 - 137�

Insert the original loan date expressed as YYYYMMDD.�

�

�

Business Scenario for ASCII Flat Sequential File Format

A lender has one borrower with one RH loan that has the following status information as of December 31, 1996.  The following example illustrates how a lender would report this status information to RD using an ASCII flat sequential file.

The following table provides information about the Lender and the loan. 

Trading Partner ID�

S111111111001�

�

Lender ID Number�

111111111�

�

Borrower ID �

9988776655�

�

Borrower Name�

John Paul Smith�

�

Rural Development Loan Number�

50�

�

Lender Loan Number�

123456789ABCDEFG�

�

The following table provides information to be reported to Rural Development regarding the loan activity as of December 31, 1996.

Unpaid Principal�

45,896.56�

�

Unpaid Interest�

23,458.97�

�

Real Estate Tax Current�

Y�

�

Flood Insurance Current�

Y�

�

Hazard Insurance Current�

Y�

�

Terminate Guarantee�

N�

�

Payment Status Code�

B�

�

Amount Ahead/Behind�

456.12�

�

Date of Loan�

11/01/1994�

�

The following illustrates how the flat sequential would look with this sample data. 

�����RDFSATS111111111001RHA0001

���������������19961231111111111123456789ABCDEFG9988776655JOHN PAUL SMITH                       500000000458965600000002345897YYYNB0000000004561219941101

�

ANSI X.12 Format 

The flat sequential file format will be accepted for the December 31, 1996, reporting period but eventually the reports will only be accepted electronically in an ANSI X.12 format.  Below are the specifications for how to map the flat sequential file identified above into the EDI Transaction Set 203, Secondary Mortgage Market Investor Report, as it exists in the  Release 3050.

Position Number/Segment ID�

Reference Description�

Data Element�

Code Guidance�

�

ISA (Interchange Control Header)�

ISA01�

I01�

Must equal “00” which indicates an original transmission.�

�

�

ISA02�

I02�

Insert ten (10) ASCII spaces.�

�

�

ISA03�

I03�

Must equal “00” which indicates no password required.�

�

�

ISA04�

I04�

Insert ten (10) ASCII spaces.�

�

�

ISA05�

I05�

Must equal “ZZ” which indicates the following data is mutually defined.�

�

�

ISA06�

I06�

Insert Trading Partner ID

(For self-reporters, the nine-digit Lender ID Number preceded by an “S” followed by the Lender’s Branch Number assigned by RD.  If this is a transmission by the central office for all branches use “000” for the Lender Branch Number.  For a Service Bureau, the bureau ID assigned by RD.)�

�

�

ISA07�

I05�

Must equal “ZZ” which indicate the following data is mutually defined.�

�

�

ISA08�

I07�

Insert “RDFSAT” for test transmission or “RDFSAP” for production transmission, left-justify and blank fill. �

�

�

ISA09�

I08�

Transmission date expressed in YYYYMMDD format.�

�

�

ISA010�

I09�

Transmission time expressed in HHMM format.�

�

�

ISA11�

I10�

Must equal “U” to indicate U.S. EDI Community of ASC X12�

�

�

ISA12�

I11�

Control Version Number is 00305�

�

�

ISA13�

I12�

The Interchange Control Number is a sequential number beginning with “0000000001” and incremented by 1.  When “9999999999” is reached, begin again at “0000000001”.  The control number in the ISA segment (ISA13) must be identical to the control number in the IEA segment (IEA02).�

�

�

ISA14�

I13�

Use Code “0” if no Functional Acknowledgment is requested or use code “1” to request a Functional Acknowledgement.�

�

�

ISA15�

I14�

Use code “T” to indicate test data for transition testing.  When notified by RD that you have completed the transition testing, use Code “P” to indicate production data.  Do not use Code “P” until notified by RD. �

�

�

ISA16�

I15�

Use the ASCII “Greater Than” symbol (>) to designate the Component Element delimiter.�

�

GS (Functional Group Header)�

GS01�

479�

Must equal “MH” which indicates Secondary Mortgage Market Investor Report (203).�

�

�

GS02�

142�

Insert Trading Partner ID

(For self-reporters, the nine-digit Lender ID number assigned by RD preceded by an “S” followed by the Lender’s Branch Number assigned by RD.  If this is a transmission by the central office for all branches use “000” for the Lender Branch Number.  For a Service Bureau, the bureau ID assigned by RD.)�

�

�

GS03�

124�

Insert “RDFSAT” for test transmission or “RDFSAP” for production transmission, left-justify and blank fill. �

�

�

GS04�

373�

Transmission date expressed in YYYYMMDD format.�

�

�

GS05�

337�

Transmission time expressed in HHMM format.�

�

�

GS06�

28�

Sequential number beginning with “0000000001” and incremented by 1.  When “9999999999” is reached, begin again at “0000000001”.  The control number in the GS segment (GS06) must be identical to the control number in the GE segment (GE02).�

�

�

GS07�

455�

Must equal “X” which indicates Accredited Standards Committee X12.�

�

�

GS08�

480�

The Version/Release/Industry Identifier code is 003050�

�

010/ST�

ST01�

143�

Must equal “203”�

�

�

ST02�

329�

Transaction Set Control Number generated by sender’s translation software.�

�

020/BGN�

BGN01�

353�

Must equal “00” which indicates original transaction set.�

�

�

BGN02�

127�

Must equal “RHAEDI”�

�

�

BGN03�

373�

Insert Transmission Date expressed as YYYYMMDD.�

�

�

BGN04�

337�

Insert Transmission Time expressed as HHMM.�

�

�

BGN05�

623�

Must equal “CT” for Central Time.�

�

030/DTP�

DTP01�

374�

Must equal “730” which indicates Reporting Cycle Date.�

�

�

DTP02�

1250�

Must equal “D8” to indicate the following date will be expressed as YYYYMMDD.�

�

�

DTP03�

1251�

Insert the As of Date formatted as YYYYMMDD.�

�

040/REF�

REF01�

128�

Must equal “V8” to indicate institution number.�

�

�

REF02�

127�

Insert Trading Partner ID (For self-reporters, the nine-digit  Lender ID number assigned by RD preceded by an “S” followed by the Lender’s Branch Number assigned by RD.  If this is a transmission by the central office for all branches use “000” for the Lender Branch Number.  For a Service Bureau, the bureau ID assigned by RD.)  �

�

010/LX�

LX01�

554�

Insert Line Number in the transaction set.�

�

020/REF�

REF01�

128�

Must equal “V8” to indicate institution number.�

�

�

REF02�

127�

Insert Lender ID Number.�

�

020/REF�

REF01�

128�

Must equal “ZZ” to indicate mutually defined.�

�

�

REF02�

127�

Insert Borrower’s Name.�

�

020/REF�

REF01�

128�

Must equal “ZZ” to indicate mutually defined.�

�

�

REF02�

127�

Insert answers to Real Estate Tax Current, Flood Insurance Current, Hazard Insurance Current, and Terminate Guarantee questions.  If Flood Insurance and Hazard Insurance are not applicable to the loan, insert an ASCII space in its appropriate place.�

�

050/RLT�

RLT01�

128�

Must equal “LD” to indicate Loan Number.�

�

�

RLT02�

127�

Insert the Loan Number assigned by RD.  (If unknown insert “50”.)�

�

�

RLT03�

128�

Must equal “AAU” to indicate General Number.�

�

�

RLT04�

127�

Insert the Lender’s Loan Number.�

�

�

RLT10�

128�

Must equal “3H” to indicate case number.�

�

�

RLT11�

127�

Insert the Borrower ID which is the borrower’s social security or Internal Revenue Service Tax Identification Number.�

�

060/DTP�

DTP01�

374�

Must equal “547” to indicate original loan date.�

�

�

DTP02�

1250�

Must equal “D8” to indicate the following date will be expressed as YYYYMMDD.�

�

�

DTP03�

1251�

Insert the Date of Loan expressed as YYYYMMDD.�

�

070/AMT�

AMT01�

522�

Must equal “YB” to indicate Unpaid Principal Balance.�

�

�

AMT02�

782�

Insert the Unpaid Principal balance as of the date of status.�

�

070/AMT�

AMT01�

522�

Must equal “BV” to indicate uncollected interest.�

�

�

AMT02�

782�

Insert the Unpaid Interest as of the date of status.�

�

070/AMT�

AMT01�

522�

Use code “YQ” if the payment status is A for ahead, “YR” if payment status is B for behind, or “VP” if payment status is C for current.�

�

�

AMT02�

782�

Insert the Amount Ahead/Behind as of the date of status.�

�

190/SE�

SE01�

96�

Insert the total number of segments including the ST and SE.�

�

�

SE02�

329�

Insert transaction set control number assigned by sender’s translation software�

�

GE (Functional Group Trailer)�

GE01�

97�

Insert number of transaction sets included in the functional group terminated by the trailer containing this data element.�

�

�

GE02�

28�

Insert the control number in the GE segment (GE02) which must be identical to the control number in the GS segment (GS06).�

�

IEA (Interchange Control Trailer)�

IEA01�

116�

Insert a count of the number of functional groups included in an interchange.�

�

�

IEA02�

112�

Insert the control number in the IEA segment (IEA02) which must be identical to the control number in the ISA segment (ISA13).�

�

�

Business Scenario for ANSI X.12 Format

The table presented on the following pages displays each line of the EDI transmission for the business scenario presented above.  An explanation of each segment and data element is also provided.  The EDI transmission includes only Transaction Set 203; it does not include the envelop (i.e., ISA/IEA, GS/GE).

EDI Transmission�

Data�

Explanation�

Ref. Des.�

�

ST*203*0001 ~�

ST�

ST is the Transaction Set Header segment ID.�

�

�

�

203�

203 indicates transaction set 203.�

ST01�

�

�

0001�

0001 is the control number assigned by the Lender translation software.�

ST02�

�

BGN*00*RHAEDI*19970105*0830*CT~�

BGN�

BGN is the Beginning Segment ID.�

�

�

�

00�

00 indicates that this is an original transaction being reported.�

BGN01�

�

�

RHAEDI�

RHAEDI is the reference number for the transaction set.  �

BGN02�

�

�

19970105

�

19970105 is the transmission date (01/05/1997).�

BGN03�

�

�

0830�

0830 indicates the transmission time (8:30 a.m.).�

BGN04�

�

�

CT�

CS indicates Central Time.�

BGN05�

�

DTP*130*D8*19961231~�

DTP�

DTP is the Date, Time or Period segment ID.�

�

�

�

730�

730 indicates the cycle date.�

DTP01�

�

�

D8�

D8 indicates the format is YYYYMMDD.�

DTP02�

�

�

19961231�

19961231 indicates the December 1996 reporting cycle.�

DTP03�

�

REF*V8*S111111111001~�

REF�

REF is the Reference Number segment ID.�

�

�

�

V8�

V8 indicates the institution number.�

REF01�

�

�

S111111111001�

S111111111001 is the trading partner ID for this Servicer.�

REF02�

�

LX*001~�

LX�

LX is the Assigned Number segment ID.�

�

�

�

001�

001 is an assigned number.�

LX01�

�

REF*V8*111111111~�

REF�

REF is the Reference Number segment ID.�

�

�

�

V8�

V8 indicates the institution number.�

REF01�

�

�

111111111�

111111111 is the Lender ID Number.�

REF02�

�

REF*ZZ*JOHN PAUL SMITH~�

REF�

REF is the Reference Number segment ID.�

�

�

�

ZZ�

ZZ indicates the institution number.�

REF01�

�

�

JOHN PAUL SMITH�

JOHN PAUL SMITH is the borrower’s name.�

REF02�

�

REF*ZZ*YYYN~�

REF�

REF is the Reference Number segment ID.�

�

�

�

ZZ�

ZZ indicates mutually defined.�

REF01�

�

�

YYYN�

Y indicates yes to Real Estate Tax Current

Y indicates yes to Flood Insurance Current

Y indicates yes to Hazard Insurance Current

N indicates No to Terminate Guarantee

�

REF02�

�

RLT*LD*50*AAU*123456789ABCDEFG******3H*9988776655~�

RLT�

RLT is the Real Estate Loan Type segment ID.�

�

�

�

LD�

LD indicates the loan number.�

RLT01�

�

�

50�

50 is the Rural Development loan number.�

RLT02�

�

�

AAU�

AAU indicates the general agency number.�

RLT03�

�

�

123456789ABCDEFG�

123456789ABCDEFG is the Lender’s loan number.�

RLT04�

�

�

3H�

3H indicates the Case Number.�

RLT10�

�

�

9988776655�

9988776655 indicates the Borrower ID.�

RLT11�

�

DTP*547*D8*19941101~�

DTP�

DTP is the Date or Time or Period segment ID.�

�

�

�

547�

547 indicates Date of Loan.�

DTP01�

�

�

D8�

D8 indicates the date format is YYYYMMDD.�

DTP02�

�

�

19941101�

19941101 is the date the loan (11/01/1994).�

DTP03�

�

AMT*YB*4589656~�

AMT�

AMT is the Amount segment ID.�

�

�

�

YB�

YB indicates the actual unpaid principal balance of the loan.�

AMT01�

�

�

4589656�

4589659 is the UPB of the loan ($45,896.56).�

AMT02�

�

AMT*BV*2345897~�

AMT�

AMT is the Amount segment ID.�

�

�

�

BV�

BV is the uncollected interest.�

AMT01�

�

�

2345897�

2345897 is the unpaid interest for this loan ($23,458.97).�

AMT02�

�

AMT*YR*45612~�

AMT�

AMT is the Amount segment ID.�

�

�

�

YR�

YR indicates a behind payment status ahead/behind.�

AMT01�

�

�

45612�

45612 is the amount ahead/behind ($456.12).�

AMT02�

�

SE*15*0001~�

SE�

SE is the Transaction Set Trailer segment ID.�

�

�

�

15�

15 is the number of segments in the transmission.�

SE01�

�

�

0001�

0001 is the control number.�

SE02�

�

The following illustrates how the transaction set 203 would look with this sample data. 

ISA*00*bbbbbbbbbb*00*bbbbbbbbbb*ZZ*S111111111001bb*ZZ*RDFSATbbbbbbbbb*19970105*0805*U*00305*0000000001*0*T*>~GS*MH*S111111111001*RDFSAT*19970105*0805*0000000001*X*003050~ST*203*0001~BGN*00*RHAEDI*19970105*0830*CT~DTP*130*D8*19961231~ REF*V8*S111111111001~ LX*001~ REF*V8*111111111~ REF*ZZ*JOHN PAUL SMITH~REF*ZZ*YYYN~RLT*LD*50*AAU*123456789ABCDEFG******3H*9988776655~ DTP*547*D8*19941101~ AMT*YB*4589656~ AMT*BV*2345897~ AMT*YR*45612~ SE*15*0001~GE*1*0000000001~IEA*1*0000000001

(b=blank)

�

RD has requested the EDI Transaction Set 203 be modified to accommodate the three yes/no questions in a more appropriate location and, therefore, the data mapping specifications will change once these modifications has been approved and implemented.  The requested changes are only minor and will hopefully be implemented in mid 1997.  RD does encourage the  use of the EDI ANSI X12 format for transmitting data, since this has become the industry standard for electronic commerce and will eventually be RD standard.  

EDI Data Mapping and Transmission Options

RD will receive these status report transmissions at an EDI Communications PC which can be accessed using a modem and standard communication software, such as one provided with Windows or can be accessed by a service bureau.  

EDI data mapping and/or electronic transmissions may be new technologies for some lenders or may typically be performed by the lender’s service bureau for a fee.  This should not inhibit lenders from participating in electronic transmission. Even if a lender is a service bureau client, both the EDI data mapping and transmission can be performed with little or no reliance on a service bureau directly from their location.  Below are three approaches.

Create Flat File, Perform EDI Data Mapping, and Transmit Data on a Local PC

If your guaranteed loan data is stored on a computer at your establishment or if your guaranteed loan data is stored remotely, such as at a service bureau, you can extract the necessary data from it’s storage location on the computer using a information retrieval and data management software application, such as Easy Tri Eve, and store the extracted data on your microcomputer in an ASCII flat sequential file.  If this file is not formatted exactly as specified above (but without the header record), you can modify the file using a word processor or a spreadsheet application and save again as an ASCII file format. Once the file is formatted properly, it is ready to be transmitted.

If the flat file is created on a microcomputer that has Windows and communication capabilities, you can purchase a PC based EDI Data Mapping software package and hire a consultant to do the data mapping.  The cost for the software and the expense of hiring a consultant to prepare the program for mapping the flat file into the EDI message would be  approximately $2,000.00.  This option is not costly and can be established quickly when knowledgeable consultants are involved.  This option will also involve the expense of the telephone call for each transmission.

Service Bureau Creates Flat File, Performs EDI Data Mapping, and Transmits Data

If your guaranteed loan data is stored in the portfolio management software provided by a service bureau,  you can hire the service bureau to do the EDI data mapping and place your  EDI messages in a file on their computer system where you can retrieve it. You can then download the file to a microcomputer that has communication capabilities and transmit it. 

The cost of this option is unknown and will probably be recurring each time the file is created.  Also, the expense of the telephone call for each transmission would be incurred.

Service Bureau Only Creates Flat File and then EDI Data Mapping and Transmission Performed on a Local PC

If your guaranteed loan data is stored in the portfolio management software provided by a service bureau,  you can hire the service bureau to create a flat sequential file formatted exactly as specified above (but without the header record) and place the file on their computer system where you can retrieve it. You can then download the file to a microcomputer that has communication capabilities.

If the microcomputer has Windows capabilities, you can purchase a PC based EDI Data Mapping software package and hire a consultant to do the data mapping.  The cost for the software and the expense of hiring a consultant to prepare the program for mapping the flat file into the EDI message would be approximately $2,000.00.

After the data mapping program is executed and the EDI message file is created, the communication software would be executed and the EDI message file transmitted.

This option will involve a service fee to the service bureau which is unknown.  All other aspects of this option are not costly and can be established quickly when knowledgeable consultants are involved.  This option will also involve the expense of the telephone call for each transmission.

Transmission Instructions

Any standard communication software can be used for transmitting the data to the EDI Communication PC.  When the communication software is executed, the RD modem line would be dialed at (816) 823-1036.  Once a connection is established to the EDI Communication PC a message will be displayed indicating the system is for authorized use only.  At this point the data file containing the electronic status reports would be selected and transmitted directly to RD’s EDI communications PC. 

Transmitting using Windows Communications

When using the Windows  communication package, the following steps should be followed.

Step 1 - Select the “Terminal” icon which is typically found in the “Accessories” group from the Program Manager window.

Step 2 - Select “Settings” from the Menu Bar and then select “Communications” from the drop down menu.  In the dialog box make the following selections.

Baud Rate 		- anything below 28,800

Data Bits 		- 8

Stop Bits		- 1

Parity 		- None

Flow Control	- None

Step 3 - Select “Settings” from the Menu Bar and then select “Phone Number” from the drop down menu.  In the dialog box enter 18168231036.

Step 4 - Select “Phone” from the Menu Bar and then select “Dial” from the drop down menu.

Step 5 - Once the screen displays a message regarding authorized use only, select “Transfers” from the Menu Bar and select “Send Binary File” from the drop down menu.  Select the protocol “XMODEM” and then select the appropriate file and it will begin to transmit.

Receiving EDI Acknowledgments

A lender may receive EDI acknowledgments from the EDI Communication PC by following the steps outlined below.

Step 1 - Create a ASC II flat file with just the Trading Partner ID used in creating the EDI transaction set 203 only preceded by an “O” instead of an “S”.

Step 2 - Follow the instructions for transmitting to the EDI Communication PC and “send” the ASC II flat file that was just created.  Once the EDI Communication PC receives this file, the download procedure is automatically initiated.  This process is defaulted to the ZMODEM protocol.  The download procedure will open the lender’s receiving mailbox 

�PAGE  �19�

�PAGE  �14�

� PAGE �