eLMS: applist_hf

A master list of international broadcast applications driven from CDBS and IBFS data (including archived records) and other data sources maintained by REC..

Return to eLMS

column

type

description

facility_id

int

FCC Facility ID.

app_source

char(1)

Source of the application: (I) IBFS, (C) CDBS

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

char(32)

Currently not used for HF.  Included to assure cross-application compatability.

ibfs_filing_key

int

Cross reference to IBFS data.

application_type

varchar(10)

Type of application filed.

file_number

varchar(30)

File number in CDBS or IBFS.

receipt_date

date

Date that the application was filed.

application_status

varchar(6)

Application status code.

eng_data

varchar(1)

Includes engineering data.

active_ind

varchar(1)

Includes the most current engineering data.

status_date

date

Application status date.

superceded

char(1)

Application has been superceded by an amendment.

app_purpose

varchar(10)

Application purpose code

altc

varchar(1)

Application involves an assignment of license/permit or transfer of control.

baps

varchar(1)

Currently not used for HF.  Included to assure cross-application compatability.

fac_country

varchar(2)

Country of the facility (for HF, will always be ‘US’).

pn_project_ind

varchar(1)

Record in REC Public Notice Project.