One entry per document.
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 |
doc_sequence |
int |
Sequence of document in this application ID. |
doc_description |
varchar(255) |
Description of the document. |
doc_parties |
varchar(255) |
The name of the parties that the contract/agreement are with. |
execution_date |
date |
The date that the contract was executed. This normally appears as month and year with the date being 01. |
expiration_date |
date |
The date that the contract would expire. This normally appears as month and year with the date being 01. If there is no expiration date, it will appear as 0000-00-00. |
no_exp_date |
varchar(1) |
If there is no expiration date. |
agreement_type |
varchar(1) |
Agreement type: J=Joint Sales Ageement, N-Network Affilliation Agreement, L-Local Marketing Agreement, O-Other |
agreement_other |
varchar(255) |
Description of agreement if [O] is selected for agreement_type. |