Automatically assign colum value using Before Record Added event

Hi!
I have a list page on a table, LeaveRequest and I am trying to insert automatically a value into a column (LeaveRequest.Approver) based on the userid in the list page(inline Add). The value comes from another table, Employee based on the userid. User do not see the column(Approver) in the list page. I have added the following code in the "Before Record Added" event in the add page, but it's giving error when try to insert the record in the list page.
*
$rs = DB::Query('SELECT FROM Employee WHERE EmpNo=:session.userid');
$values["Approver"] = $rs->value("ReportingMgr");
return true;

Any help would be highly appreciated.
Thank you,
Abhi