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.
|
column |
type |
description |
|
facility_id |
int |
FCC Facility ID. |
|
service_code |
varchar(10) |
|
|
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 |
Amends REC application ID. |
|
lms_application_id |
varchar(32) |
Hexidecimal application ID code used by LMS and eLMS. |
|
ibfs_application_key |
varchar(32) | Not used in TV applist. |
|
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: https://docs.fcc.gov/public/attachments/DOC-___A1.pdf |
|
application_status |
varchar(6) |
|
|
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. |
|
fac_country |
varchar(2) | Country code of facility. |
| pn_project_ind | varchar(1) |
Legacy application with data from the REC Public Notice Project. |
