eLMS: attachments

A table that refers to the exhibits filed with broadcast applications. The attachments are hosted at the FCC LMS website. This table will also be used for FCC decision letters in dismissals and pleadings.

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

attachment_id

varchar(32)

Used in FCC LMS to internally identify a specific document.  Documents can be retrieved from the FCC LMS server at:
enterpriseefiling.fcc.gov/dataentry/api/download/attachment/[attachment_id]

file_name

varchar(80)

Public file name.  Usually with a .pdf, .txt, .doc or .docx extension.

uploaded_by

varchar(1)

Originator of the attachment:  A = applicant , I = internally by FCC staff

attachment_type

varchar(1)

Type of file uploaded:  A = All purpose, B = Basic eligibility questions, F = Fees - waivers and exemptions, L = Licensing certifications, T = Technical certifications 

file_description

varchar(255)

Free flow description of the file uploaded.

letter_date date

Not used.