This is the lead table for all eLMS supported applications. Older applications such as CDBS, BAPS and REC Radio History Project as well as international broadcast station applications handled through IBFS will start using the tables:
- applist_am
- applist_dtv
- applist_kidvid
- applist_fm
- applist_repack
- applist_dtv
The column lms_application_id will be the link to most of the other eLMS tables.
Assignment of license/Transfer of Control (ALTC) applications:
ALTC applications (purpose codes “AGN” and “TC”) will have a “skeleton” record in application. Most information about these applications are in the altc_applicant, altc_details and altc_facility tables. Like renewals, ALTC applications use “child facilities” to allow for multiple facilities to be included on a single application. Only the head file number will be shown in application.
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 |
rec_application_id |
int |
User friendly all-numeric application identifier used in REC systems in order to be compatible with all-numeric application identifiers in CDBS. This value is not recognized at the FCC. |
file_number |
varchar(20) |
Zero-filled file number assigned by the FCC’s LMS system. Legacy CDBS records will have the file prefix and the application reference number in the single string. |
facility_id |
int |
|
lead_callsign |
varchar(20) |
Call sign of the facility. For FM boosters, this may be the call sign of the primary station as opposed to the booster (with the numeric suffix). |
date_submitted |
date |
Date submitted to the FCC. |
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 |
app_status |
varchar(3) |
|
status_date |
date |
Date of status change. |
expiration_date |
date |
Expiration date of construction permit or license. |
current_record |
varchar(1) |
Indicates that the application record is “current”. |
app_service |
varchar(6) |
|
app_purpose |
varchar(5) |
|
frn |
varchar(11) |
FCC Registration Number |
fee_exempt |
varchar(1) |
Is the applicant exempt from FCC application Fees? |
fee_exempt_reason |
varchar(200) |
Reason for fee exemption. |
reg_fee_exempt |
varchar(1) |
Is the applicant exempt from FCC regulatory Fees? |
waiver |
varchar(1) |
Application requests a waiver of FCC rules? |
waiver_count |
int |
Total number of rule sections in the waiver request. |
applicant_name |
varchar(80) |
Name of the applicant. |
applicant_dba |
varchar(80) |
Doing business as... |
applicant_street |
varchar(80) |
Mailing address for applicant – first line |
applicant_street2 |
varchar(80) |
Mailing address for applicant – second line |
applicant_city |
varchar(80) |
Mailing address – city |
applicant_state |
varchar(2) |
Mailing address – state |
applicant_zip |
varchar(10) |
Mailing address- ZIP code |
applicant_tn |
varchar(10) |
Applicant telephone number |
applicant_email |
varchar(80) |
Applicant e-mail address |
sign_name |
varchar(80) |
Name of signatory of the application. |
sign_title |
varchar(80) |
Title of signatory. |
sign_date |
varchar(10) |
Date of signing. |
comm_city |
varchar(80) |
Community of license – city |
comm_state |
varchar(2) |
Community of license – state |
auto_pta |
varchar(1) |
Station operating under automatic program test authority |
req_pta |
varchar(1) |
Applicant is requesting program test authority |
country_code |
varchar(2) |
Country (US/MX/CA/BV). |
cdbs_conv_status |
varchar(1) |
CDBS conversion status: (F) fully converted through eLMS parsing system. (M) fully converted through record conversion. (P) partially converted through record conversion. (P) records will include all engineering information but may be missing some administrative information. (P) records should be further reviewed if used for filings. |
cancellation | varchar(1) |
Is the applicant cancelling the entire facility? |
cancel_continue | varchar(1) |
Programming will continue on a different station. |
cancel_mvpd |
varchar(1000) |
Names of cable and satellite providers that will continue to carry the programs. |
main_studio_ind |
varchar(1) | Application is a change in main studio |
withdraw_file_number |
varchar(30) | File number of application being withdrawn. |
Changelog
- 5/14/22 - added new fields: cancellation, cancel continue, cancel_mvpd.
- 8/7/22 - added new fields: main_studio_ind, withdraw_file_number from eLMS 5/19/22.
- 7/30/23 - extended app_purpose to int(5).