Can anyone help me with sample queries to join job table with pay check or pay earns tables where you only have the line # instead of the emplid?

Views: 7

Reply to This

Replies to This Discussion

Hi Krishna,

Having just the line number is not enough to uniquely identify a pay check. You would need more fields such as the Company, Pay Period End Date, Pay Group and Page Number. Once you can uniquely identify the pay check then you can use the emplid on the Pay Check table to join the Job table.

Hope this helps.
Simon

RSS

© 2012   Created by PSoftPros.

Badges  |  Report an Issue  |  Terms of Service