eLMS: alien_ownership

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

foreign_government

varchar(1)

Is the applicant a foreign government or the representative of any foreign government as specified in Section 310(a) of the Communications Act?

is_alien

varchar(1)

Is the applicant an alien or the representative of an alien? (Section 310(b)(1))

foreign_corp

varchar(1)

Is the applicant a corporation, or non-corporate entity, that is organized under the laws of any foreign government? (Section 310(b)(2))

one_fifth

varchar(1)

Is the applicant an entity of which more than one-fifth of the capital stock, or other equity or voting interest, is owned of record or voted by aliens or their representatives or by a foreign government or representative thereof or by any entity organized under the laws of a foreign country? (Section 310(b)(3))

one_fourth

varchar(1)

Is the applicant directly or indirectly controlled by any other entity of which more than one-fourth of the capital stock, or other equity or voting interest, is owned of record or voted by aliens, their representatives, or by a foreign government or representative thereof, or by any entity organized under the laws of a foreign country? (Section 310(b)(4))

decl_ruling

varchar(1)

Has the applicant received a declaratory ruling(s) under Section 310(b)(4) of the Communications Act?

decl_ruling_id

varchar(80)

Enter the citation of the applicable declaratory ruling by DA/FCC number or the FCC Record citation, release date, or any other identifying information.

chg_since_decl

varchar(1)

Has there been any change in the applicant's foreign ownership since issuance of the declaratory ruling(s) cited in response to Question 6?

chg_id

varchar(80)

Enter the File or Docket Number of the Petition for Declaratory Ruling that the applicant has filed for its foreign ownership in connection with this application pursuant to Section 310(b)(4) of t-he Communications Act.

decl_compliance

varchar(1)

Does the applicant certify that it is in compliance with the terms and conditions of the foreign ownership declaratory ruling(s) cited in response to Question 6?

is_decl_ruling

varchar(1)

In connection with this application, is the applicant filing a foreign ownership Petition for Declaratory Ruling pursuant to Section 310(b)(4) of the Communications Act?