eLMS: owr

Basic information about the ownership report application that is not in table 'application'

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

organization_type

varchar(1)

Organization type. (C=Commercial, E=Noncommercial Educational)

contact_name

varchar(80)

Contact name as indicated on the application.

contact_organization

varchar(80)

Organization name associated with the contact.

contact_street

varchar(80)

Street address of the contact.

contact_street2

varchar(80)

Overflow of the street address to a second line (such as suite number)

contact_city

varchar(80)

City name of the contact.

contact_state

varchar(2)

Two letter state code of the contact.

contact_zip

varchar(10)

ZIP Code of the contact.

contact_tn

varchar(10)

Contact person’s telephone number.

contact_email

varchar(80)

Contact person’s e-mail address.

fee_exempt

varchar(1)

Is this application being submitted with a filing fee?

resp_nature

varchar(1)

Nature of respondent

resp_nature_other

varchar(255)

If “other” is selcted.

resp_relationship

varchar(1)

Relationship of the respondent to the underlying facility. (L) Licensee, (P) Permittee, (E) Entity required to file a Form 323 because it holds an attributable interest in one or more Licensees, (O) Other.

resp_relationship_other

varchar(255)

Free flow for relationship if (O) other is selected.

owr_purpose

varchar(1)

Purpose of ownership report: (B) Biennial, (C) Certification of accuracy of an initial or post-consummation ownership report filed by Permittee in conjunction with Permittee’s application for a station license, (V) Validation and resubmission of previously filed biennial report, (T) Transfer of control or assignment of license/permit, (P) Report filed by Permittee in conjunction with Permittee’s application for a station license, (R) Report by Permittee filing within 30 days after the grant of a construction permit for a new commercial AM, FM, or full power television broadcast station

related_file_no

varchar(10)

Related file number for purpose.  Used when owr_purpose is (C) or (V).

as_of_date

date

Date that the ownership report is effective as of.

resp_name

varchar(80)

Name of respondent.

resp_frn

varchar(11)

FRN of respondent.

resp_street

varchar(80)

Mailing address of respondent.

resp_street2

varchar(80)

Overflow of the street address to a second line (such as a suite number).

resp_city

varchar(80)

City name of the respondent.

resp_state

varchar(2)

Two letter state code of the respondent.

resp_zip

varchar(10)

ZIP Code of the respondent.

resp_tn

varchar(10)

Telephone number of the respondent.

resp_email

varchar(80)

Email address of the respondent.

organizational_chart

varchar(2000)

Organization chart of the respondent’s entity.

official_title

varchar(80)

Official title of the signatory to the application.

legal_title

varchar(80)

Legal title of the signatory to the application.

cert_tn

varchar(10)

Telephone number of the signatory to the application.

gov_bd_oth_entity

varchar(1)

Is the respondent’s governing board (or other governing entity) directly or indirectly under the control of another entity?

amendment_reason

varchar(255)

Reason for the filing of the amendment.

family_relationships

varchar(1)

Are any of the individuals listed as an attributable interest holder in the Respondent married to each other or related to each other as parent‐child or as siblings?

non_attrib

varchar(1)

Respondent certifies that any interests, including equity, financial, or voting interests, not reported in this filing are non-attributable.

attrib_exemption

varchar(1)

Is Respondent seeking an attribution exemption for any officer or director with duties wholly unrelated to the Licensee(s)?

newspaper

varchar(1)

 Does the Respondent or any reported interest holder hold an attributable interest in any newspaper entities in the same market as any station for which this report is filed, as defined in 47 C.F.R. Section 73.3555?