Schools and Libraries

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"
Fund Year 6, 7 & 8
"COMMITTED - FULL" or "COMMITTED - PARTIAL"

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.
AVSCD - violated Allowable Contract Date.
YEAR 4 CIPA DEADLINE - Filed after 10/28 deadline
120-DAY 486 DEADLINE - Filed more than 120 days after SSD or FCDL

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

 


Last modified on 2/25/2008