Used on applications for original construction permits to show parties to the application such as board members for nonprofit organizations and ownership structure for commercial entities.
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 |
party_sequence |
int |
Distinctly identifies this record within the application. The value represents the sequence that the party entity was placed on the application. |
party_name |
varchar(80) |
Name of entity. For names of individuals, the data is non-fielded (first, last and suffix on one line). |
party_title |
varchar(80) |
Title |
party_company |
varchar(80) |
Company or organization |
party_street |
varchar(80) |
First line of street address. If the “in care of” functionality in LMS is used, this line will include the name entered in that field and the street address will show in contact_street2 |
party_street2 |
varchar(80) |
Second line of street address. |
party_city |
varchar(80) |
City name |
party_state |
varchar(2) |
State code |
party_zip |
varchar(10) |
ZIP code |
party_tn |
varchar(10) |
Telephone number |
party_email |
varchar(80) |
Email address |
party_interest |
varchar(80) |
Party’s interest such as title (President, Vice President, etc.) |
party_citizenship |
varchar(2) |
Country code of party’s citizenship |
party_votes |
float |
Percentage of votes for designated entity |
party_assets |
float |
Percentage of assets for designated entity. Used mainly in commercial stations. |
party_cur_votes |
float |
Percentage of votes before transfer |
party_cur_assets |
float |
Percenage of assets before transfer |
party_type |
varchar(1) |
[P] parties to the application, [C] changes in interest |