Applicant information on assignor and assignee..
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 |
applicant_type |
varchar(1) |
[F] assignor/transferor, [T] assignee/transferee, [L]icensee |
applicant_sequence |
int |
Sequence number within the F, T or L category. (Used mainly for multiple transferrors or trasnferees) |
applicant_name |
varchar(80) |
Name of the applicant. |
applicant_dba |
varchar(80) |
Doing business as... |
applicant_title | varchar(80) |
Title of applicant |
entity_type |
varchar(80) |
Type of entity |
applicant_frn |
varchar(12) |
FRN of the party mentioned |
applicant_street |
varchar(80) |
Mailing address for applicant – first line |
applicant_street2 |
varchar(80) |
Mailing address for applicant – second line |
applicant_street3 |
varchar(80) | Mailing address for applicant - third line |
applicant_city |
varchar(80) |
Mailing address – city |
applicant_state |
varchar(2) |
Mailing address – state |
applicant_zip |
varchar(10) |
Mailing address- ZIP code |
applicant_tn |
varchar(10) |
Applicant telephone number |
applicant_email |
varchar(80) |
Applicant e-mail address |
sign_name |
varchar(80) |
Name of signatory of the application. |
sign_title |
varchar(80) |
Title of signatory. |
sign_date |
varchar(10) |
Date of signing. |
last_update |
timestamp | Date and time when record was last updated. |