National Lifeline Accountability Database (NLAD)

Vermont Migration to NLAD

Service providers in Vermont will migrate their consumer records to the National Lifeline Accountability Database (NLAD) between September 18 and November 1, 2017.

FCC Order DA 17-729: WCB grants request of the Vermont DPS to participate in NLAD

Pre-production (testing and training) environment: Log in

Production (live) environment: Log In

Changes for Vermont Service Providers

Starting November 1, 2017, the Vermont DCF will no longer perform eligibility checking or maintain eligibility records, and other changes will occur.

Starting on November 1:

  • Service providers will be responsible for confirming subscriber eligibility prior to enrollment
  • Service providers can no longer use the VT DCF Lifeline certification (application) form.
  • Service providers must keep NLAD up-to-date of any change to internal company records according to the Lifeline Program Rules, Section 54.404.
  • Service providers will be responsible for conducting annual recertification for consumers. There is an option to elect USAC to conduct recertification on a company's behalf for future years.

Service providers should create processes and procedures for their staff to meet these new requirements starting November 1.

Help and Access

Help: Submit any questions to NLAD Support, and refer to the NLAD User Guide (available inside NLAD) or the NLAD training videos for assistance.

NLAD Access: The company's "497 Officer" in E-File should log into NLAD using their E-File credentials to designate an "NLAD/ETC administrator," and add sub-accounts.

Training: Training will be available in September and October via webinar. USAC will send training invitations to Vermont service providers via email. Register now for these training sessions:

Process and Schedule

This schedule is subject to change. Please refer to your emails from USAC for the most up-to-date information. USAC will send email notices to remind service providers of upcoming deadlines.

Receive Customer Data

September 18

On this date, the Vermont DCF will send each service provider a list of their customer eligibility data, including name, DOB, SSN, address, and phone number. This is the data service providers will use to populate NLAD and conduct data scrubbing.

Pre-Production (Testing and Training)

September 18 – October 1, 2017

During this time, service providers can access the NLAD pre-production environment to test the system and train their staff.

Service providers can submit a subset of their Lifeline Program subscriber list (up to 1,000 records) to the NLAD pre-production environment to perform end-to-end testing and conduct training for their staff. Upload the sample using the NLAD Input Template (CSV file).

Data Scrubbing (Production Environment)

October 2 – November 1, 2017

During this time, service providers can "scrub" their subscriber list by submitting the data to the NLAD production environment and making data corrections based on the error messages they receive.

Service providers can continue to resubmit their data as often as possible to correct errors during this timeframe. They must submit a complete subscriber list each time, not just corrected data. See below for data scrubbing instructions.

Final Data Submission

November 1, 2017

On this date, carriers are required to submit their final "clean" subscriber list to the NLAD production environment. They must complete this data transmission to the production environment no later than 11:59 PM on 11/1. This submission must be a complete, clean set of all Lifeline Program subscribers.

Live in NLAD

November 2, 2017

On this date, USAC will begin migrating carrier data into NLAD "live" production. USAC will notify carriers once the data is migrated and carriers are "live" in NLAD. Upon notification, carriers will be required to use NLAD to add, enroll, edit, and de-enroll subscribers from this date forward.

At this time, service providers will only submit transaction data, not complete refreshes.

Following November 1, 2017, USAC will continue to scrub the data that was migrated into NLAD. USAC will notify service providers of the processes to clean up subscriber records.

Data Scrubbing Process

Data scrubbing is the process to prepare your data for NLAD. Upload the file to the production environment, review the resulting error codes, make corrections and re-upload the file until it is "clean" (no errors appear). The data scrubbing process is:

  • Download the NLAD Input Template (CSV file) and add your subscriber records (provided by the VT DCF) to all applicable columns. A list of input fields, including restrictions, is available on our website. Review this sample file as a guide.
    • Create one upload template per SAC (study area code)
    • USAC recommends using a small sample of records – 20 rows or less – for your first upload so you can learn the data scrubbing process with a manageable amount of data.
    • For the "eligibility code," use code E14 to indicate that the customer's eligibility was approved by a state administrator.
  • Save your completed template as a CSV file using the NLAD naming convention.
    • The NLAD naming convention is to begin the file name with your 6-digit SAC, followed by up to 44 optional alphanumeric characters. For example: 123456_VT_09-15-17_v2.csv
  • Log into the NLAD production environment
  • Select "Upload Subscriber File" from the left-hand menu under "Subscriber Management"
  • Select the "Choose File" button at the top to select your completed input template, then the "Upload" button to upload your file to NLAD.
  • See if your file was accepted
    • If your file is accepted and there are no errors the status column on the "Upload Subscriber File" page will show "Success"
    • If your file is not accepted, the page will show "Rejected" in the status column because there is some data in a field that does not meet the NLAD file validations. Please update the file according to the validations and resubmit.
  • For a file that is successfully uploaded but contains "Errors" in the status column, select the "Download File" option to review the errors and their corresponding subscriber records.
    • The error codes will appear in the "MSG_Code" column of the downloadable rejection file. A list of error codes is available, and if you need assistance interpreting the error codes, contact USAC for assistance.
  • Return to your original file and make corrections to the fields that caused errors.
  • Continue uploading the file, reviewing error codes, and making corrections until the file is "clean" (no errors appear) and "Success" appears in the status column.
    • You must upload the entire subscriber file each time. It is not sufficient to only upload records with corrected errors.
  • Once the file's status column on the "Upload Subscriber File" page shows a "Success" status, the scrubbing process is complete for that SAC.
  • Upload a "clean" file to the NLAD production (live) environment on the Final Data Submission Date, November 1, 2017.