eLMS: vacant_fm_allotments

This is a manually maintained table that mirrors the FM Table of Allotments in §73.202 of the Commission's Rules. It is intended to be a reference in order for other legacy REC systems to know when a certain record received in LMS raw data is actually related to a potentially vacant allotment.  Since the conversion to LMS, this information has not been otherwise clear like it was in CDBS.

Return to eLMS

column

type

description

allot_id

int

Unique identifer with REC for the allotment. Not relaed to any other table.

allot_channel

int

Channel number of the allotment

allot_class

varchar(2)

Service class of the allotment.

comm_city

varchar(80)

Community of license

comm_state

varchar(2)

State of license

nce_reserved

varchar(1) "Y" if allotment is reserved for noncommercial educational purposes.