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 486 Letter
Overview
Some service providers have requested an electronic letter, that is, a file containing the variable information that is in the paper format of the Form 486 Service Provider Confirmation letter.
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 email 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 |
Funding Request Number (FRN) |
1-digit to 10-digit numeric |
3 |
471 Application Number (based on Funding Request Number) |
1-digit to 10-digit numeric |
4 |
470 Application Number |
15-digit numeric |
5 |
Applicant name (of school, school district, library or consortium) |
Alphanumeric |
6 |
Contact name |
Alphanumeric |
7 |
Contact preferred mode |
"MAIL", "PHONE", "FAX", or "EMAIL" |
8 |
Contact street address |
Alphanumeric or no value |
9 |
Contact city name |
Alphanumeric or no value |
10 |
Contact state code |
2-character alphabetic or no value |
11 |
Contact zip5 code |
5-digit numeric or no value |
12 |
Contact zip4 code |
4-digit numeric or no value |
13 |
Contact fax area code |
3-digit numeric |
14 |
Contact fax number |
7-digit numeric |
15 |
Contact fax extension |
Numeric or no value |
16 |
Contact phone area code |
3-digit numeric |
17 |
Contact phone number |
7-digit numeric |
18 |
Contact phone extension |
Numeric or no value |
19 |
Contact e-mail address |
Alphanumeric or "N/A" |
20 |
FRN Funding Commitment Status |
Fund Year 7 - "Funded" or "Not Funded" |
21 |
Contract Number |
Alphanumeric or no value |
22 |
Service Description |
"Dedicated Services", "Internal Connections", "Internal Connections (Shared)", "Basic Maintenance", "Internet Access", or "Telecommunications Services" |
23 |
Service Shared |
"Shared" or "Not Shared" |
24 |
Billed Entity Number (BEN) |
1-digit to 10-digit numeric (value given if service uses site-specific discount; represents ID of the school or library entity receiving the service) or no value (if service uses shared discount) |
25 |
Entity Name |
Alphanumeric (if field #24 contains a value; represents name of the school or library entity receiving the service) |
26 |
Service Actual Start Date (SASD) |
Date (MM/DD/YYYY format) |
27 |
Contract Expiration Date (CED) |
Date (MM/DD/YYYY format) or "N/A" |
28 |
Fund Commitment Extended Cost Amount |
Numeric to two decimal places (represents cost of service in funding year period). |
29 |
Discount Percentage Approved by SLD |
2-digit numeric (represents FRN discount percentage) or "N/A" |
30 |
FRN Actual Committed Amount |
Numeric to two decimal places |
31 |
Retro Payment Indicator |
"Yes" or "No" (indicates if the applicant will request reimbursement for past expenses) |
32 |
FRN Cancel Indicator |
"Yes" or "No" (indicates if the FRN was canceled, i.e. due to being a duplicate of another FRN) |
33 |
Report Date |
Date (MM/DD/YYYY format) |
34 |
Billing Account Number |
Alphanumeric (maximum - 25) |
35 |
Fund Year |
4-digit numeric |
36 |
Fund Year Start Date |
MM/DD/YYYY format |
37 |
Fund Year End Date |
MM/DD/YYYY format |
38 |
Service Start Date Change Indicator |
"Yes" or "No" (indicates if the Service Start Date as provided by applicant was changed by the SLD. If Y, the Actual Service Start Date is not the date provided by the applicant) |
39 |
Service Start Date Change Explanation |
Reason Service Start Date was change. |
40 |
Funding Commitment Change Indicator |
"Yes" or "No" (indicates if the Funding Commitment amount in Item 30 was changed by the SLD from the amount sent in the FCDL. If Y, the Commitment Amount in 30 is not the Commitment Amount that was in the FCDL) |
At the bottom of the file will be the text:
"SLD 486 to Service Provider ; Total Records: [record count]"
Sample E-mail Letter
143001356|157|0000000259|807310000029688| CENTRAL S D|Michael Jones|MAIL|123 ABC Street|Smith City|AK|07777||777|7777777||888|8888888||email@aol.com|COMMITTED - FULL|T|Telecommunications
Services|Shared|||01/01/1999||2222.00|75|845.21|No|No|12/01/1999|1234567890123456789012345|1999|
07/01/1999|06/30/2000|Y|AVSCD|Y
143001356|158|0000000259|807310000029688| CENTRAL S D|Michael Jones|MAIL|123 ABC Street|Smith City|AK|07777||777|7777777||888|8888888||email@aol.com|COMMITTED - FULL|T|Telecommunications Services|Shared|||06/12/1998||2222.00|75|2736.30|No|No|12/01/1999|1234567890123456789012345|1999|
07/01/1999|06/30/2000|N||N
143001356|159|0000000259|807310000029688| CENTRAL S D|Michael Jones|MAIL|123 ABC Street|Smith City|AK|07777||777|7777777||888|8888888||email@aol.com|COMMITTED - FULL|T|Telecommunications
Services|Shared|||01/01/1999||2222.00|75|334.60|No|No|12/01/1999|123456789012345|1999|07/01/1999|
06/30/2000|N||N
143001356|160|0000000259|807310000029688| CENTRAL S D|Michael Jones|MAIL|123 ABC Street|Smith City|AK|07777||777|7777777||888|8888888||email@aol.com|FUNDED|T|Telecommunications
Services|Shared|||01/01/1999||2222.00|75|455.97|No|No|12/01/1999|1234567890|1999|07/01/1999|
06/30/2000|Y| YEAR 4 CIPA DEADLINE|Y
143001356|165|0000000259|807310000029688| CENTRAL S D|Michael Jones|MAIL|123 ABC Street|Smith City|AK|07777||777|7777777||888|8888888||email@aol.com|COMMITTED - FULL|T|Telecommunications Services|Shared|||01/01/1999||2222.00|75|190.79|No|No|12/01/1999|1234567890123456789012345|1999|
07/01/1999|06/30/2000|N||N
