Tracks additional data elements from LMS cancellation applications where the applicant states programming will resume on a different station.
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 |
cancel_sequence |
int |
Sequential numeric designation for each facility within the same lms_application_id |
facility_id |
int |
Facility ID of facility defined in facility_type |
file_number |
varchar(30) |
File number of authorization being cancelled. |
facility_type |
varchar(1) |
(M) facility in which programming will continue to be broadcast on. (F) facility that is being cancelled on this application. |
Changelog
- 5/14/22 - new table - added fields lms_application_id, cancel_sequence, facility_id, file_number and facility_type.