eLMS: altc_details

Applicant information on assignor and assignee..

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

pro_forma

varchar(1)

Was this a pro forma transaction?

short_form_approp

varchar(1)

If pro-forma, certification of short form was appropriate?

voluntary

varchar(1)

[V]oluntary, [I]nvoluntary

comp_bidding

varchar(1)

Were any of the applications obtained through competitive bidding?

point_system

varchar(1)

Were any of the facilities obtained by NCE point system?

oper_4_years

varchar(1)

If point system, has the station operated for at least 4 years?

tribal_priority

varchar(1)

Were any facilities granted through 307(b) tribal priority?

tribal_4_years

varchar(1)

If tribal priority, has the station operated for at least 4 years?

tribal_both

varchar(1)

Are both the assignor and assignee eligible for tribal priority?

lpfm_18mo_cp

varchar(1)

Has the construction permit exceeded 18 months?

lpfm_73865_a1

varchar(1)

Has the facility satisfied §73.865(a)(1)?

lpfm_point_system

varchar(1)

Was the authorization obtained through a point system?

lpfm_4_years

varchar(1)

Has the LPFM station operated for at least 4 years (on point system)?

lpfm_local

varchar(1)

 

lpfm_attrib

varchar(1)

 

lpfm_prudent

varchar(1)

 

f_agr_voluntary

varchar(1)

Certifies that agreements were put in the public file.

f_agr_involuntary

varchar(1)

Certifies court orders and other docs are in public file on involuntary transactions.

f_char_issues

varchar(1)

Character issues for assignor/transferor

f_adverse

varchar(1)

Adverse findings for assignor/transferor

f_public_notice

varchar(1)

Local public notice has been given

f_auction_auth

varchar(1)

If the CP has been granted for at least 5 years and bidding credit was used

f_anti_discrim

varchar(1)

Anti-discrimination certification

t_agreements

varchar(1)

Assignee/tranferee put agreement in public file.

t_attrib

varchar(1)

Assignee/transferee has no attributable interests

t_cross_ownership

varchar(1)

Assignee/transferee cross ownership

t_family

varchar(1)

Does not present familial interests, future ownership interests, insulation

t_eligible_entity

varchar(1)

Applicant is an eligible entity.

t_gf_cluster

varchar(1)

Grandfathered cluster of stations.

t_gf_eligible_entity

varchar(1)

 

t_irrevoc_trust

varchar(1)

 

t_char_issues

varchar(1)

Character issues.

t_adverse

varchar(1)

 

t_financial

varchar(1)

Transferor/assignee has assets to run the station for 3 months.

t_program_svc

varchar(1)

 

t_auction

varchar(1)

 

t_eeo

varchar(1)

 

nce_attrib_points

varchar(1)

 

nce_overlap

varchar(1)

 

t_incubator

varchar(1)

Is the proposed facility the subject of an incubation proposal or a ‘reward’ waiver request under the Commission’s Broadcast Incubator Program?