Contact representative information. An application may have more than one row with each one distinguished by contact_sequence.
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_street3 |
varchar(80) | Third 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_foreign_code |
varchar(20) | Telephone number foreign country code. |
contact_foreign_tn |
varchar(80) | Foreign 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 |