eLMS: application

Return to eLMS

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 (ATLC) 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

FCC facility ID number

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)

Current status of application from LMSbot or LMS raw data.

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)

Service code

app_purpose

varchar(4)

Application Type Code

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.