Data elements from renewal applications. Renewal applicants have a parent application for which child facilities can also be specified. If a parent renewal application addresses multiple facilities, there will be a record for the parent facility and for each child (distinguished by group sequence). Some certification questions only appear on the parent record (group sequence=1) but not on the child records
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. |