Resource Center Home
Resource Center Home

HR and Payroll for Dynamics GP

HR and Payroll for Dynamics GP

Comprehensive Leave Manager SQL Views

KB01-013

If you do not have SmartList Builder, you may be interested in a SQL view to display leave liability, leave transaction and summary information. The Views.zip folder contains four SQL views and a query named “Select Views.sql”. Run the query first because it will tell you which views already exist.

If you have SmartList Builder, you may want to checkout the SmartList Builder for Comprehensive Leave Manager article.

SL Leave Balances

Contains the Employees leave liability for all leave codes and employees. The report uses current pay code information assigned to the employee to calculate the liability.

 APR_PTO_Employee_Code_MSTR (APR_PTO00120),
     UPR_MSTR (UPR00100),
     APR_PTO_Employee_PayCode_MSTR (APR_PTO00140),
     UPR_MSTR_Pay_Type (UPR00400)

SL Leave Summary

Displays data for all employees and leave codes from the Employee Leave Maintenance and Employee Leave Summary window.

APR_PTO_Employee_Code_MSTR (APR_PTO00120)

SL Leave Trans

Displays transactional data for all employees and leave codes from the Employee Leave Transactions window.

APR_PTO_Employee_Trx (APR_PTO20200)

Leave Summary After Calculate

Displays employees and leave codes being processed this pay period and the leave balance amounts. This report only contains data during payroll processing. Run this report after calculate checks to verify leave earned, taken, pending and available amounts for this pay period.

APR_PTO_Employee_Code_WORK (APR_PTO10120),
UPR_MSTR (UPR00100)

Leave Trx after Calculate

Displays data for all employees and leave codes being processed this pay period and the leave balance amounts. This report only contains data during payroll processing. Run this report after calculate checks to verify leave earned, taken, pending and available amounts for this pay period.

APR_PTO_Employee_Code_WORK (APR_PTO10120),
UPR_MSTR (UPR00100)

Was this article helpful?
Views: 83