eLMS: applist_tv

A master list of TV applications across several systems.  Does not include children’s television reports, repack reimbursement forms nor DTV transition CDBS filings.

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.

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: https://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 TV 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.