Callsign requests data.
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 |
req_call_sign |
varchar(10) |
Requested call sign. |
file_number |
varchar(20) | File number of original construction permit related to an initial call sign request. |
effective_date |
date | Effective date of the call sign |
consent_ind | varchar(1) |
Has consent been received by the other station to duplicate the call sign in a different service. |
lic1_cur_call |
varchar(10) | For call sign exchanges, current call sign for licensee # 1. |
lic1_req_call |
varchar(10) | For call sign exchanges, requested call sign for licensee # 1 |
lic2_cur_call |
varchar(10) | For call sign exchanges, current call sign for licensee # 2. |
lic2_req_call |
varchar(10) |
For call sign exchanges, requested call sign for licensee # 2. |
contract_ind |
varchar(1) | Is there a contract included for the call sign exchange? |