eLMS: applist_dtv

Applications related to the DTV transition.

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.

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)

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.

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.