Schools and Libraries
About the Schools and Libraries Program:
- Overview of the Program
- Overview of the Process
- Outreach and Training
- Site Visits
- Filing Appeals
- Understanding Audits
Schools and Libraries Tools:
Electronic 471 Revised Funding Commitment Report
to the Service Provider for All Funding Years
Overview
Some service providers have requested an electronic file containing the variable information that is in the paper format of the Form 471 Funding Commitment Report attached to an original or revised FCDL to the service provider.
The implementation is to continue to produce paper letters in all cases, except SPINs assigned to the LEC group, and to create files to e-mail for those service providers requesting such a format. Each service provider will receive a separate file for each SPIN 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 is 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 no value ("| |"), 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 |
FUNDING COMMITMENT REPORT |
||
1 |
Service Provider Name: |
|
2 |
SPIN (Service Provider Identification Number) main unique identifier sorted |
9-digit numeric |
3 |
Funding year |
4-digit numeric |
4 |
Name of Billed Entity: |
Alphanumeric |
5 |
Billed Entity Address |
Alphanumeric |
6 |
Billed Entity Address 2 |
Alphanumeric |
7 |
Billed Entity City |
Alphanumeric |
8 |
Billed Entity State: |
2-character alphabetic |
9 |
Billed Entity Zip: |
5-digit numeric |
10 |
Billed Entity Number |
1-digit to 10-digit numeric |
11 |
Name of Contact Person |
Alphanumeric |
12 |
Preferred Mode of Contact |
Alphabetic |
13 |
Contact Information - Street Address |
Alphanumeric |
14 |
Contact Information - Street Address 2 |
Alphanumeric |
15 |
Contact Information - City Name |
Alphanumeric or no value |
16 |
Contact Information - State |
2-character alphabetic or no value |
17 |
Contact Information - Zip Code |
5-digit numeric or no value |
18 |
Contact Information - Fax Area Code |
3-digit numeric |
19 |
Contact Information - Fax Number |
7-digit numeric |
20 |
Contact Information - Fax Extension |
Numeric or no value |
21 |
Contact Information - Telephone Area Code |
3-digit numeric |
22 |
Contact Information - Telephone Number |
7-digit numeric |
23 |
Contact Information - Telephone Extension |
Numeric or no value |
24 |
Contact Information - E-mail Address |
Alphanumeric or "N/A" |
25 |
Form 471 Application Number (based on Funding Request Number) |
1-digit to 10-digit numeric |
26 |
Funding Request Number (FRN) |
1-digit to 10-digit numeric (based on FRN Sequence Number) |
27 |
Funding Status |
"Funded" or "Not Funded" |
28 |
Category of Service |
Alphabetic |
29 |
470 Application Number |
15-digit numeric |
30 |
Contract Number |
Alphanumeric or no value |
31 |
Billing Account Number |
Alphanumeric |
32 |
 Service Start Date (SSD) |
Date (MM/DD/YYYY format) |
33 |
Contract Expiration Date (CED) |
Date (MM/DD/YYYY format) or "N/A" |
34 |
Number of Months (e.g. 12) Recurring Service Provided in Funding Year |
Numeric |
35 |
Annual Pre-Discount Amount for Eligible Recurring Charges |
Numeric to two decimal places or $0.00 value |
36 |
Annual Pre-Discount Amount for Eligible Non-Recurring Charges |
Numeric to two decimal places or $0.00 value |
37 |
Pre-discount Amount |
Numeric to two decimal places |
38 |
Applicant's Discount Percentage Approved by SLD |
2-digit numeric or "N/A" (based on FRN discount percentage) |
39 |
Funding Commitment Decision |
Numeric to two decimal places (Committed Amt) |
40 |
FRN Reason Description |
Alphanumeric or no value |
41 |
Funding Commitment Decision Explanation |
Alphanumeric up to 200 characters or no value |
42 |
Applicant Revised FCDL Letter Date |
Date (MM/DD/YYYY format) |
43 |
Appeal Wave Number |
Alphanumeric (2-digit number followed by "A") CAN'T BE NULL. |
44 |
Last Allowable Date for Delivery and Installation for Non-Recurring Services |
Numeric in date format (mm/dd/yyyy). |
At the bottom of the file will be the text:
"SLD 471 Revised Funding to Service Provider ; Total Records: [record count]"
Sample FRN entry in e-mail file (pipe delimited)
143001356|2000|07/01/2000|06/30/2001|259|CENTRAL SCHOOL DISTRICT|123 NORTH MAIN ST|SMITH|NY|14855|
Michael Jones|MAIL|123 ABC Street|Westville|NY|14224|555|7777204||555|7777028||email@aol.com|
157|807310000029688|Funded|T|Telecommunications Services|N/A|42647|23 76859 4412|
07/01/2000|04/30/2001|2000.00|80|1600.00||Approved|06/01/2000|4|12640|(973) 884-8300|12/15/1999|
03/01/2000|50.00|10.00|40.00|10|400.00|1500.00|300.00|1200.00||06/01/2000|
