eLMS: applist_repack
A master summary of applications filed by FM and TV stations during the repack seeking compensation.
|
column |
type |
description |
|
facility_id |
int |
FCC Facility ID. |
|
service_code |
varchar(10) | Facility service code. |
|
app_source |
varchar(1) | Source of application: [L] LMS, [E] eLMS. |
|
rec_application_id |
int |
|
|
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 Repack applist. |
|
application_type |
varchar(10) |
|
|
file_number |
varchar(30) |
Application file number. |
|
receipt_date |
date |
Date that the application was filed. |
|
date_accepted |
date | Date accepted for filing. |
|
public_notice |
int | Document number of FCC public notice. |
|
application_status |
varchar(6) |
|
|
status_date |
date |
Application status date. |
|
eng_data |
varchar(1) | Not used in Repack applist. |
|
active_ind |
varchar(1) | Not used in Repack applist. |
|
superceded |
varchar(1) |
Application has been superceded by an amendment. |
| legacy_id | int |
Not used in Repack applist. |
|
history_id |
int | Not used in Repack applist. |
|
app_purpose |
varchar(10) |
Application purpose code. |
|
altc |
varchar(1) | Not used in Repack applist. |
|
ownership_report |
varchar(1) | Not used in Repack applist. |
|
is_aux |
varchar(1) | Not used in Repack applist. |
| baps | varchar(1) |
Not used in Repack applist. |
| fac_country |
varchar(2) |
Not used in Repack applist. |
|
pn_project_ind |
int | Not used in Repack applist. |
