eLMS: altc_applicant

Applicant information on assignor and assignee..

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

applicant_type

varchar(1)

[F] assignor/transferor, [T] assignee/transferee, [L]icensee

applicant_name

varchar(80)

Name of the applicant.

applicant_dba

varchar(80)

Doing business as...

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_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.