Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Historical Payroll Data

Status
Not open for further replies.
Bubbalouie

Bubbalouie

Technical User
Mar 25, 2009
107
US
Hi,

I was hoping this was going to be in the FAQs but no such luck!

Our payroll Dept wants a report that will show an Employee ID, Employee Name, Gross Wages, Overtime Hourly Wages, Overtime Salary Wages and a Workers Compensation Code for any yearly period.

I think if I knew which tables to look at I could whip up a SQL report for them but I have no idea which tables to look at.

If anyone knows what those tables are (or a good source for me to look up that info) I'd sure appreciate a heads up.

Thanks In Advance!
 
Status
Not open for further replies.

Similar threads

ACCT PDC
  • Locked
  • Question
Switched to DirectDeposit Payroll and now entries not carrying through to bank reconciliation
Replies
1
Views
414
ACCT PDC
ACCT PDC
svrcrown
  • Locked
  • Question
Payroll & FI integration query PEO/ASO model
Replies
0
Views
121
svrcrown
svrcrown
Barnyc
  • Locked
  • Question
Historical Aged Debts
Replies
2
Views
107
Barnyc
Barnyc
firemedicandy
  • Locked
  • Question
GP payroll issues, too many entries for one person?
Replies
0
Views
73
firemedicandy
firemedicandy
cat24
  • Locked
  • Question
Open Credit Memo needs to be applied to Historical Invoice
Replies
6
Views
184
VicRosenberg
VicRosenberg

Part and Inventory Search

Sponsor

Back
Top