eLMS: owr_docs

One entry per document.

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

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.