One entry per owner on ownership report.
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 |
owner_sequence |
int |
Sequence of each party to the application. |
owner_frn |
varchar(11) |
FCC Registration Number of party. |
owner_entity |
varchar(80) |
Entity name of party. |
owner_street |
varchar(80) |
Street address line 1 |
owner_street2 |
varchar(80) |
Street address line 2 |
owner_city |
varchar(80) |
City name |
owner_state |
varchar(2) |
Two letter street code |
owner_zip |
varchar(10) |
ZIP Code of party. |
listing_type |
varchar(1) |
Options: [O]wner, [R]espondent. |
tribal_nation |
varchar(1) |
Is this a tribal entity. |
voting_pct |
float |
Voting percentage. |
equity_pct |
float |
Equity percentage. |
assets_pct |
float |
Assets percentage. |
jointly_held |
varchar(1) |
Is the ownership interest jointly held? |
attrib_interest |
varchar(1) |
Does interest holder have an attributable interest in one or more broadcast stations that do not appear on this report? |
pi_attrib_creditor |
varchar(1) |
Positional interest – creditor. |
pi_attrib_investor |
varchar(1) |
Positional interest – investor |
pi_attrib_jsa |
varchar(1) |
Positional interest – joint sales agreement |
pi_attrib_lma |
varchar(1) |
Positional interest – local marketing agreement |
pi_director |
varchar(1) |
Positional interest – director |
pi_genl_partner |
varchar(1) |
Positional interest – general partner |
pi_lc_llc_pllc_member |
varchar(1) |
Positional interest – LC/LLC/PLLC member |
pi_limited_partner |
varchar(1) |
Positional interest – limited partner |
pi_officer |
varchar(1) |
Positional interest – officer |
pi_owner |
varchar(1) |
Positional interest – owner |
pi_parent_entity |
varchar(1) |
Positional interest – parent entry |
pi_stockholder |
varchar(1) |
Positional interest – stockholder |
pi_other |
varchar(1) |
Positional interest – other |
pi_other_desc |
varchar(255) |
Description of other positional interest if pi_other = Y. |
pi_respondent |
varchar(1) |
Positional interest – respondent |
citizenship |
varchar(2) |
Two character country code of applicant’s citizenship. |
gender |
varchar(1) |
Gender: [M]ale or [F]emale. |
ethnicity |
varchar(1) |
Ethnicity of owner: [N]ot Hispanic or Latino / [L]atino or hispanic |
race_afr_amer |
varchar(1) |
Race: African American |
race_indian_native |
varchar(1) |
Race: American Indian or Alaska Native |
race_asian |
varchar(1) |
Race: Asign |
race_hawaiian |
varchar(1) |
Race: Hawaiian or Pacific Islander |
race_white |
varchar(1) |
Race: White |
resp_attrib_exempt |
varchar(1) |
Is Respondent seeking an attribution exemption for any officer or director with duties wholly unrelated to the Licensee(s)? |
profession |
varchar(80) |
Principal profession or occupation |
whom_elected |
varchar(80) |
By whom elected. |