eLMS: owr_owner

One entry per owner on ownership report.

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

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.