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).
|
|
