cancel
Showing results for 
Search instead for 
Did you mean: 
jimbofoxman
Level 2

Where is employee time sheets stored?

What table are employees hours worked stored?  Trying to use QODBC and Microsoft Access together.  I can link to the Employee table just fine.  I can run Employee Earnings Summary and see the hours worked on a particular day but where to find that information in table form?  Is it "Time Tracking"?  If so, I can never import or link that.  It causes Access to stop responding.

2 Comments 2
Charies_M
Moderator

Where is employee time sheets stored?

Hi there, jimbofoxman.

 

Thanks for reaching out to us. I want to make sure you get the right support you need.

We do have a separate forum where you can get help with integrations. You can visit our Intuit Developer Community Site. They'll be the best experts to handle this concern and share insights about integrations about QODBC and Microsoft Access.


You can raise your questions by visiting our Intuit Developer portal through this link: https://developer.intuit.com/us.

If there's anything else I can assist you with, please don't hesitate to leave me a reply below.

qbteachmt
Level 15

Where is employee time sheets stored?

You asked a mix of things:

"I can run Employee Earnings Summary"

 

That's Paycheck data. That's pay period based. For each Date, you can run More Reports in Excel for Employee Time & costs as Projected paycheck data in Excel format.

 

"and see the hours worked on a particular day but where to find that information in table form?  Is it "Time Tracking"?"

 

Yes. It isn't Timesheets. It is Time Records. Each Time Record or task is Stand Alone. The Single-Activity view shows it. The Weekly view Presents it in that combined perspective.

 

Here:

https://doc.qodbc.com/qodbc/usa/

https://doc.qodbc.com/qodbc/usa/Relation.php?tableName=TimeTracking

https://doc.qodbc.com/qodbc/usa/Jumpins.php?tableName=TimeTracking

https://doc.qodbc.com/qodbc/usa/TableDetails.php?tableName=TimeTracking

https://doc.qodbc.com/qodbc/usa/TableList.php?categoryName=

Need to get in touch?

Contact us