Schools and Libraries

About the Schools and Libraries Program:

Schools and Libraries Tools:

Electronic 471 Receipt Acknowledgment Letter to Service Provider

Receive Funding Commitment Decision Letter

Overview

Some service providers have requested an electronic letter, that is, a file containing the variable information that is in the Form 471 Receipt Acknowledgment Letter for service providers.

The implementation is to continue to produce paper letters in all cases and to create files to e-mail for those service providers requesting such a format. Each service provider will receive a file with information relevant to it. The filename will be the same as the service provider's e-mail address.

In the e-mail files, there will be one or more FRN records. Each record ends in a carriage return and contains fields of information which are pipe delimited (separated by a vertical bar "|"). These fields are described in the table below.

If there is more than one FRN record in the e-mail file, the service provider's SPIN value will be repeated for each record. Also, if a 471 application is referenced more than once among the FRN records in the same e-mail file, the 471 application data will also be repeated for each applicable FRN record. If a field in the FRN record contains only a blank space ("| |"), this means there is no data for that field (e.g., a Contact Phone Extension value).

Layout of the E-mail File

Field #	Description	Valid Data
1	SPIN (Service Provider Identification Number) main unique identifier sorted	9-digit numeric
2	Fund Year Start Date	Date (MM/DD/YYYY format)
3	Fund Year End Date	Date (MM/DD/YYYY format)
4	Funding Request Number (FRN)	1-digit to 10-digit numeric
5	471 Application number	1-digit to 10-digit numeric
6	470 ApplicationÂ Number	15-digit numeric
7	Applicant name	Alphanumeric
8	Applicant street address1	Alphanumeric
9	Applicant city	Alphanumeric
10	Applicant state code	2-character alphabetic
11	Applicant zip5 code	5-digit numeric
12	Applicant zip4 code	4-digit numeric or blank
13	Applicant Area Code	3-digit numeric
14	Applicant Phone Number	7-digit numeric
15	Applicant Phone Extension	Numeric or blank
16	Contact name	Alphanumeric
17	Contact street address	Alphanumeric or blank
18	Contact city name	Alphanumeric or blank
19	Contact state code	2-character alphabetic or blank
20	Contact zip5 code	5-digit numeric or blank
21	Contact zip4 code	4-digit numeric or blank
22	Contact phone area code	3-digit numeric or blank
23	Contact phone number	7-digit numeric or blank
24	Contact phone extension	Numeric or blank
25	Service Ordered	Alphabetic
26	Fund Commitment Pre-Discount Annual Cost	2-decimal point numeric
27	Discount Percentage	Numeric
28	Entity Number of Applicant	1-digit to 10-digit numeric
29	Contract Number	Alphanumeric or blank
30	Billing Account Number	Alphanumeric or blank
31	Allowable Contract Date	Date (MM/DD/YYYY format)
32	Contract Award Date	Date (MM/DD/YYYY format) or blank
33	Service Start Date	Date (MM/DD/YYYY format)
34	Contract Expiration Date	Date (MM/DD/YYYY format) or blank
35	Funding Commitment Request Amt	2-decimal point numeric calculated from #26 multiplied by #27 and divided by 100; note that value does not reflect future Funding Commitment Decision value

Sample FRN entry in e-mail file (pipe delimited)

143001192|07/01/1999|06/30/2000|151048|112264|752300000109891|MURPHYSBORO COMMUNITY UNIT SCHOOL DIST|
819 WALNUT ST|MURPHYSBORO|IL|62966|2126|618|6843781| |Steve Carrington|819 WALNUT ST|MURPHYSBORO|IL|
62966|2126|618|6843781| |Telecommunications Services|5880.00|74

Sample FRN entry in e-mail file (pipe delimited)

Step 5 Assist Applicants with Application Review Step 7 Begin Providing Services

Last modified on 2/25/2008