eLMS: fm_ind

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

env_effect

varchar(1)

Would a Commission grant of Authorization for this location be an action which may have a significant environmental effect? (See 47 C.F.R. Section 1.1306)

meet_spacing

varchar(1)

Does the proposed facility comply with the applicable engineering standards and assignment requirements of 47 C.F.R. Sections 73.203, 73.207, 73.213, 73.315, 73.509, 73.515, 73.525, and 73.1125?

req_73215

varchar(1)

Does the proposed facility request processing pursuant to the contour protection provisions of 47 C.F.R Section 73.215?

change_col

varchar(1)

Is the application being submitted to change the facility’s community of license? 

fill_in_or_fb

varchar(1)

Does the applicant certify that the proposal is for a fill-in translator or booster?

meets_741204

varchar(1)

Does the applicant certify that the proposal complies with Sections 74.1204, 74.1205, 74.1232, 74.1234 and 74.1235?

meets_73807

varchar(1)

Does the applicant certify that the proposed facility complies with the engineering requirements of 47 CFR Section 73.807(a) through (g), 73.825 and 73.827(a)?

tpo_cert

varchar(1)

Does the operating transmitter power output produce the authorized effective radiated power?

fac_const

varchar(1)

The facility was constructed as authorized in the underlying construction permit or complies with 47 C.F.R. Section 74.1251?

spec_conditions

varchar(1)

Was the facility constructed in compliance with all special operating conditions, terms, and obligations described in the construction permit?

change_erp_tpo

varchar(1)

Is this application being filed to authorize a change in Effective Radiated Power and/or a change in transmitter output power, and/or replacing a directional or non-directional antenna and/or deleting contour protection status and/or correcting coordinates, as authorized by 47 CFR Sections 73.1690(c)(1) through (c)(11)?

aux_convert

varchar(1)

Is this application being filed pursuant to 47 CFR Section 73.1675(c)(1) to request authorization to use a formerly licensed main facility as an auxiliary facility and/or change the ERP of the proposed auxiliary facility?

chg_lic_status

varchar(1)

Is this application being filed to authorize a change in license status from commercial to non-commercial or from noncommercial to commercial, pursuant to 47 CFR Section 73.1690(c)(9)?

chg_hours_operation

varchar(1)

Is this application being filed to authorize a change in hours of operation?

replace_antenna

varchar(1)

Is this application being filed to authorize the replacement of the licensed nondirectional antenna with another nondirectional antenna within 2 meters above or 4 meters below the licensed antenna center of radiation? See 47 CFR Section 73.875(c)(1)?

replace_feedline

varchar(1)

Is this application being filed to authorize a replacement of the transmission line that resulted in a change in licensed transmitter power output, but not the effective radiated power? See 47 CFR Section 73.875(c)(2)?

site_available

varchar(1)

Applicant certifies that they have received reasonable assurance to use the proposed site.

site_assurance

varchar(1)

If the site is not owned by the applicant, a the owner or their representative has been contacted.

site_contact_name

varchar(80)

Site contact name.

site_contact_phone

varchar(10)

Site contact phone number.

site_contact_type

varchar(1)

Site contact type.  [O] Tower owner, [A] Agent, [R] Authorized Representative.