A master list of AM broadcast applications driven from eLMS, LMS and CDBS data (including archived records) and other data sources maintained by REC..
column |
Type |
description |
facility_id |
Int |
|
service_code |
varchar(10) |
|
app_source |
char(1) |
Source of the application: (E) eLMS, (L) LMS, (C) CDBS raw data, (P) REC Public Notice Project, (B) REC BAPS data, (H) REC Radio History Project |
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. |
amends_appid |
Int |
REC common application ID this application amends. |
lms_application_id |
varchar(32) |
Hexidecimal application ID code used by LMS and eLMS. |
application_type |
varchar(10) |
|
file_number |
varchar(30) |
File number. For CDBS, BAPS, PN Project and Radio History Project, this includes the file prefix and application reference number in a single string. |
receipt_date |
Date |
Date that the application was filed. |
date_accepted |
date |
Date that the application was accepted for filing. |
public_notice |
int |
FCC Application Public Notice: (docs.fcc.gov/public/attachments/DOC-___A1.pdf) |
application_status |
varchar(6) |
|
status_date |
Date |
Application status date. |
eng_data |
char(1) |
Application has AM engineering data |
active_ind |
char(1) |
Engineering record is active and protected. |
superceded |
char(1) |
Application has been superceded by an amendment. |
legacy_id |
Int |
Public Notice Project legacy ID |
history_id |
Int |
Radio History Project History ID |
app_purpose |
varchar(10) |
Application purpose code |
altc |
varchar(1) |
Application involves an assignment of license/permit or transfer of control. |
ownership_report |
varchar(1) |
Application is an ownership report. |
is_aux |
varchar(1) |
Application is for an auxiliary facility |
baps |
varchar(1) |
Interal REC indicator to indicate that the CDBS application has BAPS data. |
fac_country |
varchar(2) |
Country the facility is located in. |
pn_project_ind |
varchar(1) | Legacy application that includes data from the REC Public Notice Project. |
Changelog
- 5/14/22 added new column: pn_project_ind