eLMS: altc_facility

Facilities associated with a specific assignment/transfer application..

Return to eLMS

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.