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.