added data_end_date and pulled out the approved query to use in the score card