Retirement of legacy application list

For several years, REC had used a master application table (MAT) which was used to combine applications from CDBS, LMS and various internal databases such as the Radio History Project.  This single database table has become very big and bulky over the years.  

With the deployment of eLMS, we established several smaller application databases divided by service and use (AM, FM, TV, DTV transition, Repack and Kidvid) and many applications were migrated to the new application lists that exist within eLMS; however, several applications were still using the legacy database. 

This heavy maintenance removed the final dependencies on the legacy MAT and transitioned remaining dependencies to the eLMS archectecture. 

While most of the changes were internal, there were a few external changes:

FCCdata – Changed application list source from legacy to eLMS for AM History Grid.

FCCdata – Changed application list source from legacy to eLMS for FM History Grid.  History Grid will now use eLMS as a source for the technical data on applications appearing in eLMS, otherwise it will fall back to CDBS data.

FCCdata - Modified an internal program that keeps a master list of tower locations in all areas that are covered by FCCdata to use LMS data instead of the data from the legacy application list.  This change may also resolve a long-standing trouble issue where there were facilities missing from the tower payload lists.

We are aware of some cosmetic issues with FCCdata such as some applications appearing on the right side application list with yellow backgrounds.  These are minor issues that do not impact the use of the system and will be addressed at a later time. 

The elimination of the MAT will also help us address some of the issues of heavy database usage during the morning loads.  As previously announced in the changelog, we are changing how we update our tables to a more efficient manner.  We will be monitoring database quality as a result.  As always, if you experience any issues that we are not specifically aware of, please let us know.

After consideration, we have elected to keep the existing "Every Nook and Cranny" (ENAC) table system.  ENAC is used mainly for LPFM channel searches by combining technical information from across several tables and databases into a single database table in order to improve response times and take unncessary loads off of the database.

LPFM.APP has been restored and the warning messages have been removed from myLPFM. 

 

Date: 
Sunday, November 27, 2022
Systems affected: 
FCCdata.org
myLPFM v3
eLMS
DataStore
Issue type: 
Enhancement