Open Forum

SQL View of combined Payroll Code tables 

Jun 03, 2014 08:46 PM

By: Leslie Vail Date: 02/01/2014 Description: This creates a view that combines the Pay Code, Benefit and Deduction code tables into a single view. This can be used to create a great SmartList or Excel report so that you can view the current amounts from a single list. Tables included: UPR00400 (Pay Code) UPR00500 (Deduction Code) UPR00600 (Benefit Code) UPR00100 (Employee Master)

Statistics
1 Favorited
68 Views
2 Files
0 Shares
97 Downloads
Attachment(s)
sql file
Create view_Payroll_Codes.sql   25 KB   1 version
Uploaded - Jun 03, 2014
xlsx file
Payroll Codes.xlsx   83 KB   1 version
Uploaded - Jun 03, 2014

Related Entries and Links

No Related Resource entered.