U H system home U H system home U H S Search

Training Materials

Helpful HR Queries

Several departments have asked for HR queries that could help track payroll transactions. The following HR queries can be accessed in HR Reporting (SARPT) or Production (SAPRD). Navigation in either database is View, Navigator Display or Go, PeopleTools, Query. These queries can be modified in the HR Reporting database by changing a field or criteria (refer to your Query/Crystal Manuals). For example, a query can be modified to pull all the encumbrance for a specific cost center by pulling the Account Code field using the "like" operator. Also, please remember to do a "Save As" when saving a modification.

1. HR_ENC_SEARCH- pulls the encumbrance entries for a specific position number and employee. This will show any current charges (encumbrance or release) on a specific position that may not be reflected in the HR reports until the close of the month.

2. HR_ACCTG_LN_BY_EMPLID_FY- Pulls accounting entries for a specific employee and fiscal year. (NOTE- This query pulls from the same table that is used on the Journal Detail Report so the Journal Line Reference is the check number.)

3. HR_ACCTG_LN_BY_CHK- pulls all accounting transactions for a particular check (earnings, deductions, and taxes). This query can be used to track payroll reallocations (history).

For questions, please contact Carla (34275) or Rebekah (34382).



U H system footer - links to other U H campuses within the U H system as well as links to Texas Websites, how to report copyright infringement, the interim privacy policy, U H S contact information and a feedback form U H home page U H Clear Lake home page U H Downtown home page U H Victoria home page U H System at Cinco Ranch U H System at Sugarland UH System Distance Education State of Texas Compact with Texans Statewide Search Reporting Copyright Infringements Privacy and Policies contact uh system feedback