How can I review the web timesheets to make sure that the correct earnings codes and funding are being used?

There are two Banner reports you can use to check the earnings code and funding used, as well as the status of timesheets. Use PHR2TDN to see a copy of the actual timesheet, including timesheet approval routing information. Use PHR2TSF to get a report that can be opened in Excel that has the funding, grant number, grant name, and fund expenditure end date for each employee in a particular TKL.

How can I find the proxies for a timesheet approver?

Use PHR2TDN report in Banner to see a copy of the actual timesheet, including timesheet approvers and their proxies.

What tables and fields do I use in my query to identify the supervisor or Timesheet approver?

You can find the criteria to use for updating your queries in this Knowledge Base Article. This article also includes sample SQL. 

How can I determine the timesheet status so I can remind employees to submit timesheets or approvers to approve timesheets?

There are two Banner reports you can use to check the status of timesheets as well as the earnings code and funding used. Use PHR2TDN to see a copy of the actual timesheet, including timesheet approval routing information. Changing the “Time Sheet Status” value in PHR2TDN allows you to filter which timesheet status you see. Use PHR2TSF to get a report that can be opened in Excel. PHR2TSF can also be queried using a particular timesheet status. 

How often can I run the report?

You can run the report as frequently as you like for any pay year and run. Since you are running this report in Banner, whenever there is a change (i.e., an employee has submitted a timesheet), the next time you run the report, it will show the most recent information. 

How old is the data that populated the report?

The report shows you the live data at the time that the report is generated.

Who is allowed access to PHR2TDN and PHR2TSF? If a PI requests access, can we request it?

Those who have the security class of QHR_PPA_C have access to both reports. Be aware that this security class allows access to all job and paycheck information for all employees.

If a PI should have access to all job and paycheck information, then they can request this security access through the university security coordinator.

Need additional help or have questions?

Please contact ua-payroll@alaska.edu for additional assistance.  

To contact other UA HR teams, please visit our Contact Us page at https://alaska.edu/hr/contact.php.