eLMS: applist_fm

A master list of FM broadcast applications driven from eLMS, LMS and CDBS data (including archived records) and other data sources maintained by REC..

Return to eLMS

Column

Type

description

facility_id

Int

FCC Facility ID.

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)

Type of application filed.

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)

Application status code.

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