eLMS: ancillary_services

Information about each service provided on an ancillary and supplemental service fee report..

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

service_sequence

int

Sequential number to uniquely identify each record in this application ID.

service_descrip

varchar(80)

Description of service.

gross_revenue

varchar(20) Gross revenues from this service.

bitstream_used

varchar(20) Amount of bitstream used.

callsign

varchar(20) Call sign of facility with ancillary service.

comm_city

varchar(80) Community of license.

comm_state

varchar(2) State of license.
licensee varchar(80)

Name of licensee.