Data from consummation notices.
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? |