RE: [sqr-users] Query Help

["Alexander, Steven" <Steven.Alexander@sanjoseca.gov>]

Normally, the hourly rate times the number of hours worked is a rough
definition of gross pay.  Net pay will usually be less than that because
taxes and deductions are subtracted from gross pay.

What did you mean by "hourly rate specified for the state?"

PS_PAY_EARNINGS has the SHIFT_RT, HOURLY_RT, FLSA_RT, OVERRIDE_HOURLY_RT,
COMPRATE_USED_REG, and COMPRATE_USED_OT fields.  (COMP refers to
compensation)  It also has the RATE_USED field to indicate (to some extent)
which rate Peoplesoft used.  It also has the REG_PAY_HRS, REG_HRS, OT_HRS,
REG_EARN_HRS to hold the number of hours worked.

PS_PAY_OTH_EARNS has the ERNCD, OTH_HRS, OTH_PAY, OTH_EARNS, RATE_USED,
COMPRATE, and COMPRATE_USED fields.

You should interview the Payroll manager and inspect some existing data in
both tables to see how your organization uses those tables and fields.  It
may be too complex for a single SQL statement to be optimized.

You mentioned "hours worked," so you'll want to eliminate the
PS_PAY_OTH_EARNS with ERNCD for paid time off (vacation, sick, bereavement,
jury duty, etc.) and for pay that is unrelated to hours (bonus, commission,
expense reimbursement).

PS_PAY_CHECK has PAYCHECK_STATUS.  Do you want to exclude checks that have
been reversed or are the reversing checks (with all negative dollar
amounts)?  You may wish to include only calculated and confirmed checks.



-----Original Message-----
From: sqr-users-bounces+steven.alexander=sanjoseca.gov@sqrug.org
[mailto:sqr-users-bounces+steven.alexander=sanjoseca.gov@sqrug.org] On
Behalf Of veena kolanu
Sent: Tuesday, April 17, 2007 12:01 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Query Help

Hi,
My name is Veena and I am new to peoplesoft HRMS Development. I need some
help with the query .
I need to develop a Query to identify calculated pay checks that fall below
certain minimum net pay limit. 
The minimum amount is to be calculatedas the hourly rate specified for the
state times number of hours Worked.
 
Please Help ASAP
Thanks
Veena
_________________________________________________________________
Explore the seven wonders of the world
http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users