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)

Does the LPFM propsoed assignee certify they are considered a local organization under §73.853?

lpfm_attrib

varchar(1)

Proposed assignee certifies that they have no prohibited attributable interest for the assignment of an LPFM station.

lpfm_prudent

varchar(1)

Assignor certifies that the consideration for the LPFM assignment was limited to reasonable and prudent expenses.

f_agr_voluntary

varchar(1)

Certifies that agreements were put in the public file. (Assignor,or for transfer of control applications, the licensee.)

f_agr_involuntary

varchar(1)

Certifies court orders and other docs are in public file on involuntary transactions. (Assignor,or for transfer of control applications, the licensee.)

f_char_issues

varchar(1)

Character issues for assignor/transferor (Assignor,or for transfer of control applications, the licensee.)

f_adverse

varchar(1)

Adverse findings for assignor/transferor (Assignor,or for transfer of control applications, the licensee.)

f_public_notice

varchar(1)

Local public notice has been given (Assignor,or for transfer of control applications, the licensee.)

f_auction_auth

varchar(1)

If the CP has been granted for at least 5 years and bidding credit was used (Assignor,or for transfer of control applications, the licensee.)

f_anti_discrim

varchar(1)

Anti-discrimination certification (Assignor,or for transfer of control applications, the licensee.)

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)

Applicant certifies that it will come into compliance by divesting the necessary station(s) within 12 months of the consummation of this transaction to an eligible entity.

t_irrevoc_trust

varchar(1)

Applicant certifies that it will come into compliance by divesting the necessary station(s) within 12 months of the consummation of this transaction to an irrevocable trust.

t_char_issues

varchar(1)

Assignee certifies no character issues.

t_adverse

varchar(1)

Assignee certifies no advise findings.

t_financial

varchar(1)

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

t_program_svc

varchar(1)

Assignee program service qaulfiication.

t_auction

varchar(1)

Assignee certifies that 5 years has passed since the issuance of the CP being acquired in an auction through the use of a bidding credit.

t_eeo

varchar(1)

Applicant proposes to have 5 or more full time employees.

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?

nce_prev_eleg

varchar(1) NCE assignee has been previously granted a broadcast license.
nce_prev_eleg_file varchar(20)

File number of previously granted NCE broadcast license.

t_jsa

varchar(1) Assignee holder of joint sales agreement.

lic_agr_voluntary

varchar(1)

Certifies that agreements were put in the public file. (Used in Transfer of Control for licensee.)

lic_agr_involuntary

varchar(1)

Certifies court orders and other docs are in public file on involuntary transactions. (Used in Transfer of Control for licensee.)

lic_char_issues

varchar(1)

Character issues for licensee.

lic_adverse

varchar(1)

Adverse findings for licensee.

lic_public_notice

varchar(1)

Local public notice has been given (Used in Transfer of Control for licensee.)

lic_auction_auth

varchar(1)

If the CP has been granted for at least 5 years and bidding credit was used (Used in Transfer of Control for licensee.)

lic_anti_discrim

varchar(1)

Anti-discrimination certification (Used in Transfer of Control for licensee.)

chg_attrib

varchar(1) In Changes in Interest, Applicant certifies that equity and financial interests not set forth by the transferee are nonattributable.

party_attrib

varchar(1) In Parties to the Application, Applicant certifies that equity and financial interests not set forth by the transferee are nonattributable.