Facilities associated with a specific assignment/transfer application..
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 |
altc_file_number |
varchar(20) |
File number of the assignment application. |
altc_main_file_number |
varchar(20) |
Main file number for a large application. |
facility_sequence |
int |
Used to distinguish specific facilities covered in an ALTC application. |
facility_id |
int |
Facility ID of associated station. |
service_code |
varchar(8) |
Associated station’s service code. |
comm_city |
varchar(80) |
Community of license |
comm_state |
varchar(2) |
State of license |
consummation_status |
varchar(1) |
Status of the consummation: (blank) has not filed a notice, (Y) facility was consummated, (N) facility was not consummated. |
consummation_date |
date |
Date that the consummation notice was filed. |
consummation_file_no |
varchar(12) |
File number of consummation. |
consummation_app_id |
varchar(32) |
LMS Application ID of related Consummation Notice. |
rebroadcast_auth |
varchar(1) | Written authority has been obtained to rebroadcast the primary station. |
rebroadcast_facility |
int | Facility ID of station being rebroadcast. |
rebroadcast_74_1232_d |
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. |
rebroadcast_fill_in | varchar(1) |
Translator is providing a fill-in service. |
rebroadcast_74_1232_e |
varchar(1) | Applicant certifies that it is in compliance with 47 C.F.R. Section 74.1232(e), which prohibits a FM translator station whose coverage contour extends beyond the protected contour of the commercial FM primary 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 connection with, the primary station. |
last_updated |
timestamp | Date and time when record was last updated. |