eLMS: contact_info

Contact representative information.  An application may have more than one row with each one distinguished by contact_sequence.

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

contact_sequence

int

Distinctly identifies this record within the application.  The value represents the sequence that the contact representative was placed on the application.

contact_name

varchar(80)

Non-fielded name (first, last and suffix on one line) of contact rep.

contact_title

varchar(80)

Title

contact_company

varchar(80)

Company or organization

contact_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

contact_street2

varchar(80)

Second line of street address.

contact_city

varchar(80)

City name

contact_state

varchar(2)

State code

contact_zip

varchar(10)

ZIP code

contact_tn

varchar(10)

Telephone number

contact_email

varchar(80)

Email address

contact_type_code

char(1)

Type of contact: T = Technical contact, L = Legal contact, O = Other

contact_type_other

varchar(80)

currently not used. 

contact_altc

varchar(1)

[F] assignor, [T] assignee, [L] licensee