Applicant information on assignor and assignee..
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. |