eLMS: renewal

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

group_sequence

int

Used when multiple facilities are on the same renewal application ID.  Facilities with a value of 2 or higher is usually a translator.

facility_id

int

FCC Facility Identifier for this specific facility.

service_code

varchar(6)

Service code of the specific facility.

char_issues

varchar(1)

Licensee certifies that neither the licensee nor any party to the application has or has had any interest in, or connection with, any broadcast application in any proceeding where character issues were left unresolved, or were resolved adversely against the applicant or any party to the application;

char_issues_raised

varchar(1)

Licensee certifies that neither the licensee nor any party to the application has or has had any interest in, or connection with, any pending broadcast application in which character issues have been raised..

adverse_findings

varchar(1)

Licensee certifies that, with respect to the licensee and each 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.

meets_733555

varchar(1)

The licensee certifies that, with respect to the station(s) for which renewal is requested, it complied with 47 CFR Section 73.3555.

alien_ownership

varchar(1)

Licensee certifies that it complies with the provisions of Section 310 of the Communications Act of 1934, as amended, relating to interests of aliens and foreign governments.

non_discrim

varchar(1)

Commercial licensee certifies that its advertising sales agreements do not discriminate on the basis of race or ethnicity and that all such agreements held by the licensee contain non-discrimination clauses. Noncommercial licensees should select "not applicable."

ownership_report

varchar(1)

Licensee certifies that the station's Biennial Ownership Report (FCC Form 323 or 323-E) has been filed with the Commission, as required by 47 C.F.R. Sections 73.3615 and 74.797.

eeo_report

varchar(1)

The station's Broadcast EEO Program Report (FCC Form 396), has been filed with the Commission, as required by 47 C.F.R. Section 73.2080(f)(1).

eeo_file_number

varchar(10)

File number of EEO report.

public_file

varcahr(1)

Licensee certifies that the documentation required by 47 C.F.R. Section 73.3526 or 73.3527, as applicable, has been uploaded to the station's public inspection file as and when required.

min_oper_sched

varchar(1)

Licensee certifies that, during the preceding license term, the station has not been silent (or operating for less than its prescribed minimum operating hours) for any period of more than 30 days.

silent_station

varchar(1)

Licensee certifies that the station is currently on the air broadcasting programming intended to be received by the public.

discontinued_ops

varchar(1)

Licensee certifies that during the preceding license term, the station has not been silent for any consecutive 12-month period.

env_effects

varchar(1)

Licensee certifies that the specified facility complies with the maximum permissible radio frequency electromagnetic exposure limits for controlled and uncontrolled environments.

fcc_violations

varchar(1)

Licensee certifies that, with respect to the station(s) for which renewal is requested, there have been no violations by the licensee of the Communications Act of 1934, as amended, or the rules or regulations of the Commission during the preceding license term. If "No", the licensee must submit an explanatory exhibit providing complete descriptions of all violations.

rebroadcast

varchar(1)

Licensee certifies that the station is currently rebroadcasting the signal of an FM, AM, or LPFM station.

rebroadcast_facility

int

Facility ID of station being rebroadcast.

rebroadcast_consent

varchar(1)

Licensee certifies that it has obtained written authority from the licensee of the primary station identified above for retransmitting the primary station's programming

meets_741232d

varchar(1)

Licensee certifies that it is in compliance with 47 C.F.R. Section 74.1232(d), which prohibits the common ownership of: (1) a commercial primary FM station and a FM translator station whose coverage contour extends beyond the protected contour of the commercial FM primary station being broadcast, and (2) a commercial primary AM Station and a FM translator station whose 60 dBu contour exceeds the greater of either: (a) the 2 mV/m daytime contour of the commercial AM primary station being rebroadcast, or (b) a 25-mile radius centered at the transmitter site of the commercial primary AM station being rebroadcast. This restriction also applies to any person or entity having any interest in, or any connection with, the primary FM station or primary AM station.

meets_741232e

varchar(1)

Licensee certifies that it is in compliance with 47 C.F.R. Section 74.1232(e) which prohibits: (1) a FM translator station whose coverage contour extends beyond the protected contour of the commercial FM primary station being rebroadcast, and (2) a FM translator station whose 60 dBu contour exceeds the greater of: (a) the 2 mV/m daytime contour of the commercial AM primary station being broadcast, or (b) a 25-mile radius centered at the transmitter site of the commercial primary AM station being rebroadcast, from receiving support (except for specified technical assistance), before, during, or after construction, directly or indirectly, from the primary station, or any person or entity having any interest in, or any connection with, the primary station.

operating_parameters

varchar(1)

Licensee certifies that during the preceding license term, the station has operated pursuant to authorized operating parameters, either pursuant to the terms of its license, special temporary authority, or as otherwise permitted under the Commission’s rules.

eeo_website

varchar(1)

The station has posted its most recent Broadcast EEO Public File Report on the station's website, as required by 47 CFR Section 73.2080(c)(6).

kidvid_commercials

varchar(1)

For the period of time covered by this application, the licensee certifies that it has complied with the limits on commercial matter as set forth in 47 CFR Section 73.670 and the Commission’s commercial limit policies related to host-selling and program-length commercials.

kidvid_reports

varchar(1)

For the period of time covered by this application, the licensee certifies that it has filed with the Commission, and incorporates by reference, the Children's Television Programming Reports (FCC Form 2100, Schedule H) as described in 47 CFR Section 73.3526, containing all required information.

core_programming

varchar(1)

For the period of time covered by this application, the licensee certifies that the station has complied with the Core Programming criteria and Core Programming Processing Guidelines, as required by the Commission's rules that were in effect at the time the Core Program was aired.

ei_symbol

varchar(1)

The licensee certifies that, as required by 47 CFR Section 73.671(c)(5), it identifies each Core Program using the E/I symbol throughout the airing of each program.

program_guides

varchar(1)

The licensee certifies that it provides information identifying each Core Program aired on its station to publishers of program guides, as required by 47 CFR Section 73.673.

kidvid_publication

varchar(1)

The licensee certifies that prior to January 21, 2020, it publicized the existence and location of the station's Children's Television Programming Reports (FCC Form 2100, Schedule H) as required by 47 CFR Section 73.3526(e)(11)(iii).

class_a_eligible

varchar(1)

Licensee certifies that its station does, and will continue to, broadcast: (a) a minimum of 18 hours per day; and (b) an average of at least 3 hours per week of programming each quarter produced within the market area served by the station, or by a group of commonly controlled low power or Class A stations whose predicted noise-limited contours are contiguous. See 47 CFR Section 73.6001.