A master list of international broadcast applications driven from CDBS and IBFS data (including archived records) and other data sources maintained by REC..
|
column |
type |
description |
|
facility_id |
int |
|
|
app_source |
char(1) |
Source of the application: (I) IBFS, (C) CDBS |
|
rec_application_id |
int |
REC common application ID. For CDBS and BAPS, this is the FCC application ID number. For eLMS and LMS, this is the REC generated compatible application ID. |
|
lms_application_id |
char(32) |
Currently not used for HF. Included to assure cross-application compatability. |
|
ibfs_filing_key |
int |
Cross reference to IBFS data. |
|
application_type |
varchar(10) |
Type of application filed. |
|
file_number |
varchar(30) |
File number in CDBS or IBFS. |
|
receipt_date |
date |
Date that the application was filed. |
|
application_status |
varchar(6) |
|
|
eng_data |
varchar(1) |
Includes engineering data. |
|
active_ind |
varchar(1) |
Includes the most current engineering data. |
|
status_date |
date |
Application status date. |
|
superceded |
char(1) |
Application has been superceded by an amendment. |
|
app_purpose |
varchar(10) |
Application purpose code |
|
altc |
varchar(1) |
Application involves an assignment of license/permit or transfer of control. |
|
baps |
varchar(1) |
Currently not used for HF. Included to assure cross-application compatability. |
|
fac_country |
varchar(2) |
Country of the facility (for HF, will always be ‘US’). |
| pn_project_ind |
varchar(1) |
Record in REC Public Notice Project. |
