Information about each service provided on an ancillary and supplemental service fee report..
|
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. |
