A master list of FM 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) |
Service Code |
|
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 FM 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 |
|
hist_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 code of facility. |
|
pn_project_ind |
varchar(1) | Legacy application that includes data from the REC Public Notice Project. |
Changelog
- 5/14/22: new column: pn_project_ind
