eLMS: altc_consummation

Data from consummation notices.

Return to eLMS

column

type

description

lms_application_id

varchar(32)

Primary index used for all applications.  Corresponds with the FCC’s application identifier used in LMS and therefore can be used to cross reference with FCC raw data.   Unless otherwise indicated, all relational tables in eLMS are linked by lms_application_id

transaction_date

date

Date that the consummation notice was filed.

new_frn

varchar(11)

FRN of the licensee post-consummation

altc_application_id

varchar(32) LMS/eLMS application ID of the associated assignment application.

extend_first

varchar(1) Is this the first time this consummation was extended?

extend_second

varchar(1) Is this the second time this consummation was extended?