OT Report

Thanks for the tip. I will try this and see what I can come up with.

Thanks again.

Jim Moore
GD-OTS (DRI)

-----Original Message-----
From: Zerfass Jim [mailto:jimzerfass@...]
Sent: Thursday, February 14, 2002 5:42 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] OT Report


I find using the Export Utility the easiest way to get
at payroll data. The trick is that the user running
the export must be authorized to access the PayClass.

Below is the Query I use to capture Vacation Pay for a
given time period. For Holiday pay, just replace the
"VAC" filter to whatever PayType you have setup for
Holiday Pay ie."HOL".

for each PRChkDtl Where PRChkDtl.Company = cur-comp
and PRChkDtl.CheckDate >= 02/12/2002 and
PRChkDtl.CheckDate <= 02/12/2002 and
PRchkDtl.PayTypeID = "VAC" no-lock,
each PREmpMas Where PREmpMas.Company =
PRChkDtl.Company
and PREmpMas.EmpLink = PRChkDtl.EmpLink no-lock
BY PREmpMas.JCDept:

Good Luck



__________________________________________________
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Can someone help me with an overtime report that would automatically pull
the holiday hours for a certain time period.
I have a report that uses labor hours, but I am needing something based on
the payroll side, not labordtl,
since hours based on payroll tables would include holiday hours. At least I
believe they would! ?

IE... 29 actual worked hours + 16 Holiday hours = 45 or 5 OT hours.

Any ideas?

Thanks.

Jim Moore
General Dynamics-OTS (DRI)
jmoore@...-ots.com
Hi Jim,

Off the top of my head, if you need to access the payroll tables for
holiday or vacation hours paid, you'll have to use a Progress program
running from the Vantage menu to get that data, with variable
PROverrideCode defined.

You could use Results to accomplish this, but Provision would be much
better.

Good Luck,

Lonnie

--- In vantage@y..., "Moore, Jim (DRI)" <jmoore@d...> wrote:
> Can someone help me with an overtime report that would
automatically pull
> the holiday hours for a certain time period.
> I have a report that uses labor hours, but I am needing something
based on
> the payroll side, not labordtl,
> since hours based on payroll tables would include holiday hours. At
least I
> believe they would! ?
>
> IE... 29 actual worked hours + 16 Holiday hours = 45 or 5 OT hours.
>
> Any ideas?
>
> Thanks.
>
> Jim Moore
> General Dynamics-OTS (DRI)
> jmoore@d...
The Export Utility will also handle payroll data.
-----Original Message-----
From: lonniedrew [mailto:lonniedrew@...]
Sent: Wednesday, February 13, 2002 2:55 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: OT Report


Hi Jim,

Off the top of my head, if you need to access the payroll tables for
holiday or vacation hours paid, you'll have to use a Progress program
running from the Vantage menu to get that data, with variable
PROverrideCode defined.

You could use Results to accomplish this, but Provision would be much
better.

Good Luck,

Lonnie

--- In vantage@y..., "Moore, Jim (DRI)" <jmoore@d...> wrote:
> Can someone help me with an overtime report that would
automatically pull
> the holiday hours for a certain time period.
> I have a report that uses labor hours, but I am needing something
based on
> the payroll side, not labordtl,
> since hours based on payroll tables would include holiday hours. At
least I
> believe they would! ?
>
> IE... 29 actual worked hours + 16 Holiday hours = 45 or 5 OT hours.
>
> Any ideas?
>
> Thanks.
>
> Jim Moore
> General Dynamics-OTS (DRI)
> jmoore@d...


Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
I find using the Export Utility the easiest way to get
at payroll data. The trick is that the user running
the export must be authorized to access the PayClass.

Below is the Query I use to capture Vacation Pay for a
given time period. For Holiday pay, just replace the
"VAC" filter to whatever PayType you have setup for
Holiday Pay ie."HOL".

for each PRChkDtl Where PRChkDtl.Company = cur-comp
and PRChkDtl.CheckDate >= 02/12/2002 and
PRChkDtl.CheckDate <= 02/12/2002 and
PRchkDtl.PayTypeID = "VAC" no-lock,
each PREmpMas Where PREmpMas.Company =
PRChkDtl.Company
and PREmpMas.EmpLink = PRChkDtl.EmpLink no-lock
BY PREmpMas.JCDept:

Good Luck



__________________________________________________
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com