Attempting to pull out data to create Timesheet report - help!

[Bonnie]

I am able to pull out the reported time from the timesheets but ran into a
few problems. (I'm working off the EPM timesheet and also pulling in custom
data)

1. I see a DayofWeek and DayofMonth field, but I cannot locate a MonthofYear.
2. I want to also add the entries for the Administrative time, but I cannot
locate where those values are stored. What's stranger is that those values
are also not populating when I do a regular Data Analysis view with the
timesheet data, totals, and timesheet classification. I know that there is
data there. Is there a bug?

Thanks in advance for your help. I'm in a horrible time crunch and any
assistance would be greatly appreciated.

 

[Bonnie]

1. I was able to resolve this one myself.
2. I also noticed that Unverified time was also missing. Anyone know where
that would be kept?