cosmetic
major revision, densified for every respective test administered, also CTEs
added NOLOCK
added NOLOCK
redirected to static table