materialized views now joining on rmsid as rmsid is now being correctly populated in analysis records