[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] Query Help
- Subject: Re: [sqr-users] Query Help
- From: Jiju <jijucvengal@gmail.com>
- Date: Wed, 18 Apr 2007 18:18:34 +0530
- Delivery-date: Wed, 18 Apr 2007 08:51:06 -0400
- Dkim-signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;b=USInUynZuu2yQS/sWXr36jfT8pMRBIQqa8LeY6sIMXNI9ozxDiuUpzEmPxifIh5ePoxB/uVO89ul9o6UGf367IuRMAjw6jkSC7lFszSgZweMgZwOg18pKFpsPW0R2UwgI8TCiRXDMVZmVmIMovik1WBHOAwWBEP7KapaFUBVGRc=
- Domainkey-signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;b=Z7/mW104JGly9DCmZE0aVzGelS30XQghJ1Q0/3FmxSe7KeB0HRkY9lJxeTXzv7QR5gfBLZuCLvsS9wkijoy819F5HyE5qpixCy/I433gwbYz07Kctf/x6fEBU24AF9QmhPgWNvP/VZoYcK6RoruP6cX2rosSalLCnNMH5aJJ+2A=
- In-reply-to: <BAY126-W30C34346ED5CE5681D1E7BFB510@phx.gbl>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- References: <BAY126-W30C34346ED5CE5681D1E7BFB510@phx.gbl>
Hey Veena,
Use PAY_CHECK to get the NET_PAY of the employees. You can refer to the
PAYCHECK_STATUS to see whether the paycheck has been calculated or not.
You may have to sum REG_HRS from PAY_EARNINGS and OTH_HRS from PAY_OTH_EARNS
to obtain the total reported hours....
Do you by any chance have Time and Labor interface here?? And are we talking
of salaried employees only??
-Jiju.
On 4/18/07, veena kolanu < veena_kolanu@hotmail.com> wrote:
>
> 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