Learning to run queries from the PP QDB takes time and practice. Payroll Services offers a PP QDB Clinic through the Staff Development in-service training program that can be helpful to those users who need beginning level assistance in developing queries. Samples of some of the queries demonstrated in the clinic can be accessed by selecting the appropriate query from the Table of Contents shown on the left. Some helpful hints when structuring queries are shown below. In queries always include both the unit code, which tells you which bargaining unit is associated with the title, and the representation code, which tells you whether or not the employee is covered by the bargaining unit.
Data are available for the most recent three ledger year months.
This flag appears only in the four historical employee QDB tables for the purpose of distinguishing current rows from historical rows of data. The BIQuery query software offers a data values icon that is displayed to the right of the list icon in the Qualification Edit Box. The icon looks like two downward arrows. Its purpose is to search the table for the data values that are available for the attribute you have selected to qualify. However, the PP QDB data base is too large for this feature to work efficiently.