Applications related to the DTV transition.
|
column |
type |
description |
|
facility_id |
int |
|
|
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 |
REC application ID that this application is an amendment to. |
|
lms_application_id |
varchar(32) |
Hexidecimal application ID code used by LMS and eLMS. |
|
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. |
|
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 |
|
history_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 of facility. |
| pn_project_ind | int |
Indicates record is part of the REC Public Notice Project. |
