eLMS: owr_org_chart

One entry per uploaded organization chart.

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

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.