added data layer queries, business validation, for alpha_report