eLMS: legal

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

oblig_terms

varchar(1)

Licensee/Permittee certifies that all terms, conditions, and obligations set forth in the underlying construction permit have been fully met.

changed_circum

varchar(1)

Licensee/Permittee certifies that, apart from changes already reported, no cause or circumstance has arisen since the grant of the underlying construction permit which would result in any statement or representation contained in the construction permit application to be now incorrect.

char_issues

varchar(1)

Applicant certifies that neither the applicant nor any party to the application has or had any interest in, or connection with:(a) any broadcast application in any proceeding where character issues were left unresolved or were resolved adversely against the applicant or party to the application; or(b) any pending broadcast application in which character issues have been raised.

adverse_findings

varchar(1)

Applicant certifies that, with respect to the applicant and any party to the application, no adverse finding has been made, nor has an adverse final action been taken by any court or administrative body in a civil or criminal proceeding brought under the provisions of any laws related to any of the following: any felony; mass media-related antitrust or unfair competition; fraudulent statements to another governmental unit; or discrimination.

program_service

varchar(1)

Applicant certifies that it is cognizant of and will comply with its obligations as a Commission licensee to present a program service responsive to the issues of public concern facing the station's community of license and service area.

public_notice

varchar(1)

Applicant certifies that it has or will comply with the public notice requirements of 47 C.F.R. Section 73.3580.

eeo

varchar(1)

If the applicant proposes to employ five or more full-time employees, applicant certifies that it is filing simultaneously with this application a Model EEO Program Report.

common_fx

varchar(1)

Applicant certifies that it is not the licensee or permittee of the commercial primary station being rebroadcast and that neither it nor any parties to the application have any interest in or connection with the commercial primary station being rebroadcast? See 47 C.F.R. Section 74.1232(d).

fillin

varchar(1)

Applicant certifies that the FM translator's (a) 1mV/m coverage contour does not extend beyond the protected contour of the commercial FM primary station to be rebroadcast, or (b) entire 1mV/m coverage contour is contained within the greater of either: (i) the 2 mV/m daytime contour of the commercial AM primary station to be rebroadcast, or (ii) a 25-mile radius centered at the commercial AM primary station's transmitter site.

support_comp

varchar(1)

The applicant, if for a commercial FM translator station with a coverage contour extending beyond the protected contour of the commercial primary station being rebroadcast, certifies that it has not received any support, before or after constructing, directly or indirectly, from the licensee/permittee of the primary station or any person with an interest in or connection with the licensee or permittee of the primary station, except for technical assistance as provided for under 47 C.F.R. Section 74.1232(e).

rebroadcast

varchar(1)

For applicants proposing translator rebroadcasts that are not the licensee of the primary station, the applicant certifies that written authority has been obtained from the licensee of the station whose programs are to be retransmitted.

station_ready

varchar(1)

Applicant certifies that station is now in satisfactory operating condition and ready for regular operation.

lpfm_priority

varchar(1)

If the applicant is submitting multiple applications, is this application the "priority" application? See Creation of a Low Power Radio Service, Memorandum Opinion and Order on Reconsideration, 15 FCC Rcd 19208, 19239-40, 79-80, paras. 79-80 (2000).

prev_nce_file

varchar(50)

The applicant certifies that the Commission has previously granted a broadcast application identified here by file number that found this applicant qualified as a noncommercial educational entity with a qualifying educational program, and that the applicant will use the proposed station to advance a program similar to that the Commission has found qualifying in applicant's previous application.

nce_governance

varchar(50)

The applicant certifies that its governing documents (e.g., articles of incorporation, by-laws, charter, enabling statute, and/or other pertinent organizational document) permit the applicant to advance an educational program and that there is no provision in any of those documents that would restrict the applicant from advancing an educational program or complying with any Commission rule, policy, or provision of the Communications Act of 1934, as amended.

lpfm_hq

varchar(1)

it is a nonprofit educational institution or organization that is physically headquartered or has a campus within 16.1 kilometers (10 miles), if applicant is in the top 50 urban markets, or 32.1 kilometers (20 miles) if applicant is outside the top 50 urban markets, of the proposed transmitting antenna site set forth in this application

lpfm_board

varchar(1)

it is a nonprofit educational institution or organization that has 75 percent of its board members residing within 16.1 kilometers (10 miles), if applicant is in the top 50 urban markets, or 32.1 kilometers (20 miles) if applicant is outside the top 50 urban markets, of the proposed transmitting antenna site set forth in this application

lpfm_tribal

varchar(1)

it is a Tribe and its Tribal Lands, as that term is defined in Section 73.7000 of the Commission's rules, are within the service area of the proposed LPFM station; or it is a Tribal organization owned or controlled by a Tribe (or Tribes) and such Tribe's (or Tribes') Tribal Lands, as that term is defined in Section 73.7000 of the Commission's rules, are within the service area of the proposed LPFM station. See 47 C.F.R. Sections 73.853(c) and 73.7000.

lpfm_public_safety

varchar(1)

it proposes a public safety radio service and has jurisdiction within the service area of the proposed LPFM station.

lpfm_attrib

varchar(1)

no party to this application has an attributable interest in any non-LPFM broadcast station, including any full power AM or FM station, FM translator station, full or low power television station, or any other media subject to the Commission's broadcast ownership restrictions

lpfm_attrib_full

varchar(1)

no party to this application has pending an application for a low power FM, full power AM or FM station, FM translator station, or full or low power television station

family

varchar(1)

the applicant is in compliance with the Commission's policies relating to media interests of immediate family members

investors

varchar(1)

the applicant is in compliance with the Commission's policies relating to investor insulation and the non-participation of non-party investors and creditors.

lpfm_pirate

varchar(1)

The applicant certifies, under penalty of perjury, that neither the applicant nor any party to the application has engaged in any manner, individually or with other persons, groups, organizations, or other entities, in the unlicensed operation of any station in violation of Section 301 of the Communications Act of 1934, as amended, 47 U.S.C. Section 301.

cert_assets

varchar(1)

The applicant certifies that sufficient net liquid assets are on hand or that sufficient funds are available from committed sources to construct and operate the requested facilities for three months without revenue.

nce_307b

varchar(1)

Applicant certifies that this application does not propose a modification to an authorization that was awarded on the basis of a preference for fair distribution of service pursuant to 47 U.S.C. Section 307(b).

nce_737003

varchar(1)

Applicant certifies that this application does not propose a modification to an authorized station that received a credit for superior technical parameters under the point system selection method in 47 C.F.R. Section 73.7003.

auction_auth

varchar(1)

If the application is being submitted to obtain a construction permit for which the applicant was the winning bidder in an auction, then the applicant certifies, pursuant to 47 C.F.R. Section 73.5005(a), that it has attached an exhibit containing the information required by 47 C.F.R. Sections 1.2107(d), 1.2110(i), 1.2112(a) and 1.2112(b), if applicable.

tribal_priority

varchar(1)

Is the Applicant applying for an FM allotment set forth in a Public Notice announcing a Tribal Threshold Qualifications window?

rulemaking

varchar(1)

This application is being submitted concurrently with a Petition for Rulemaking or Counterproposal to Amend the FM Table of Allotments (47 C.F.R. Section 73.202) to add a new FM channel allotment. The petitioner/counter-proponent certifies that, if the FM channel allotment requested is allotted, petitioner/counter- proponent will apply to participate in the auction of the channel allotment requested and specified in this application

retrans_auth

varchar(1)

The applicant certifies that it is the licensee of the primary station or the applicant certifies that written authority has been obtained from the licensee of the primary station whose programming is to be retransmitted.

attrib_equity

varchar(1)

Applicant certifies that equity and financial interests not listed in the Parties to the Application section are non-attributable pursuant to the notes to 47 C.F.R. Section 73.3555.

attrib_broadcast

varchar(1)

Does the applicant or any party to the application have an attributable interest in any other broadcast station(s).

attrib_jsa

varchar(1)

Is the applicant or any party to the application the holder of an attributable radio joint sales agreement or an attributable radio time brokerage agreement in the same market as the station subject to this application?

attrib_multi_owner

varchar(1)

Applicant certifies that the proposed facility complies with the Commission's multiple ownership rules.

attrib_family

varchar(1)

Applicant certifies that the proposed facility:(a) does not present an issue under the Commission's policies relating to media interests of immediate family members;(b) complies with the Commission's policies relating to future ownership interests; and(c) complies with the Commission's restrictions relating to the insulation and non-participation of non-party investors and creditors.

eleg_entity

varchar(1)

Does the Applicant claim status as an "eligible entity," that is, an entity that qualifies as a small business under the Small Business Administration's size standards for its industry grouping (as set forth in 13 C.F.R. § 121.201, and holds:(a) 30 percent or more of the stock or partnership interests and more than 50 percent of the voting power of the corporation or partnership that will own the media outlet; or(b) 15 percent or more of the stock or partnership interests and more than 50 percent of the voting power of the corporation or partnership that will own the media outlet, provided that no other person or entity owns or controls more than 25 percent of the outstanding stock or partnership interests; or(c) more than 50 percent of the voting power of the corporation that will own the media outlet (if such corporation is a publicly traded company)?

cert_grant

varchar(1)

The applicant certifies that this application is contingent upon receipt of a grant from a charitable organization, the approval of the budget of a school or university, or an appropriation from a state, county, municipality or other political supervision.

nce_type

varchar(1)

Type of NCE licensee: (I) Institution, (O) Organization, (G) Government

nce_current

varchar(1)

Applicant is currently an NCE based on file number (attached to application)

incubator

LPFM organization type: (E) Educational Organization, (T) Tribal Organization, (P) Public Safety Organization.