eLMS: point_system

column

type

description

lms_application_id

varchar(32)

Primary index used for all applications.  Corresponds with the FCC’s application identifier used in LMS and therefore can be used to cross reference with FCC raw data.   Unless otherwise indicated, all relational tables in eLMS are linked by lms_application_id

fill_in

varchar(1)

local_orig

varchar(1)

Applicant pledges to 8 hours per day of local programming from within 20 miles for NCE stations and for LPFM stations, within 20 miles except in markets 1~50, where the distance is 10 miles.

main_studio

varchar(1)

Applicant pledges to maintain a main studio for at least 20 hours per week within 20 miles except in markets 1~50, where the distance is 10 miles.

studio_address1

varchar(80)

Street address for main studio.

studio_address2

varchar(80)

Second line of street address for main studio.

studio_city

varchar(80)

City name of main studio.

studio_street

varchar(2)

Two character state code for main studio.

studio_zip

varchar(10)

ZIP Code of main studio.

studio_phone

varchar(10)

Telephone number of main studio

cmty_presence

varchar(1)

Applicant claims that they have been local for the past 2 years.

local_and_main

varchar(1)

Applicant claims to be local and have a main studio (bonus point)

local_applicant

varhcar(1)

Applicant certifies that for at least the 24 months immediately prior to application, and continuing through the present, it qualifies as a local applicant pursuant to 47 C.F.R. Section 73.7000, that its governing documents require that such localism be maintained, and that it has placed documentation of its qualifications as an established local applicant in a local public inspection file and has submitted to the Commission copies of the documentation.

diversity_overlap

varchar(1)

Applicant certifies that the principal community (city grade) contour of the proposed station does not overlap the principal community contour of any other authorized station (comparing radio to radio and television to television, including non-fill-in translator stations, other than those identified in (b) below, in which any party to the application has an attributable interest as defined in 47 C.F.R. Section 73.3555, that its governing documents require that such diversity be maintained, and that it has placed documentation of its diversity qualifications in a local public inspection file and has submitted to the Commission copies of the documentation

diversity_attrib

varchar(1)

The applicant certifies that neither it nor any party to the application holds an attributable interest in any other broadcast station.

statewide_network

varchar(1)

Applicant certifies that (a) it has NOT claimed a credit for diversity of ownership above; (b) it is one of the three specific types of organizations described in 47 C.F.R. Section 73.7003(b)(3); and (c) it has placed documentation of its qualifications in a local public inspection file and has submitted to the Commission copies of the documentation.

technical_parameters

varchar(1)

Applicant certifies that the numbers in the boxes below accurately reflect the new area and population that its proposal would serve with a 60 dBu (FM) or Grade B (TV) signal measured in accordance with the standard predicted contours in 47 C.F.R. Sections 73.313(c) (FM), 73.683(TV) and 73.622(e) and that it has documented the basis for its calculations in the local public inspection file and has submitted copies to the Commission. Major modification applicants should include new area proposed only (exclude any area already within the station's existing service area). (Points, if any, will be determined by FCC)

new_area_sqkm

float

New area served in square kilometers (excluding areas of water)

pop_served

int

Population served based on the most recent census block data from the United States Census Bureau.

existing_auth

int

By placing a number below, the applicant certifies that it and any persons and organizations with attributable interests in the applicant pursuant to 47 C.F.R. Section 73.3555 have, as of the date of filing, existing authorizations for the following number of relevant broadcast stations. FM translator applicants should count all attributable full service radio stations, AM and FM, commercial and noncommercial and FM translator stations other than fill-in stations.

existing_fillin

int

(Fill-in Applicants Only.) By placing a number below, the applicant certifies that, in addition to the station identified in (a), it and any persons and organizations with attributable interests in the applicant pursuant to 47 C.F.R. Section 73.3555 have, as of the date of filing, existing authorizations for the following number of FM translators.

pending_apps

int

By placing a number below, the applicant certifies that it and any persons and organizations with attributable interests in the applicant pursuant to 47 C.F.R. Section 73.3555 have, as of the date of filing, pending applications for new or major changes to the following number of relevant broadcast stations. FM translator applicants should count all attributable full service radio stations, AM and FM, commercial and noncommercial and FM translator stations other than fill-in stations.

pending_fillin

int

Fill-in Applicants Only.) By placing a number below, the applicant certifies that, in addition to the station identified in (a), it and any persons and organizations with attributable interests in the applicant pursuant to 47 C.F.R. Section 73.3555 have, as of the date of filing, pending authorizations for the following number of FM translators.

tribal_org

varchar(1)

The applicant certifies it is a Tribe proposing to locate its transmitting antenna site on its Tribal Lands, or a Tribal organization proposing to locate its transmitting antenna site on the Tribal Lands of the Tribe or Tribes that own or control more than 51 percent of the organization.

cmty_presence_date

date

Provide the date on which the applicant qualified as local. See 47 C.F.R. Section 73.853(b).

cmty_presence_ind

varchar(1)

Applicant certifies that it has remained local at all times since this date.

fair_cert_first

varchar(1)

Applicant certifies that it providers first aural reception service.

fair_tribal

varchar(1)

Applicant certifies that it is a tribal applicant.

fair_first

varchar(1)

Applicant certifies that it will provide a first noncommercial aural service to at least 10 percent of the people living in the service contour and a minimum of 2000 people.

fair_second

varchar(1)

Applicant certifies that it will provide a second noncommercial aural service (or aggregated first/second service) to at least 10 percent of the people living in the service contour and a minimum of 2000 people.

fair_first_pop

fair_second_pop

prior_window

varchar(1)

Applicant certifies that they had filed in a prior filing window.

prior_cert

varchar(1)

Applicant certifies that the organization has been in continuous existence and that they hold no other NCE authorizations.

varchar(1)

LPFM pledges to operate at least 12 hours per day (pre-2012 LPFM rules).