One entry per uploaded organization chart.
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 |
org_sequence |
int |
Sequence of the organization chart within the application ID. |
file_name |
varchar(80) |
File name of the document uploaded (usually with a .pdf or .doc extension) |
file_id |
varchar(32) |
Hexadecimal identifier of the file on the FCC’s LMS server |
uploaded_by |
varchar(1) |
[A]pplicant, [I]nternal (FCC staff) |
attachment_type |
varchar(80) |
Type of attachment. |
attachment_description |
varchar(255) |
Description of the attached document. |