Basic information about the ownership report application that is not in table 'application'
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? |