"Efficiency" reports design (Vantage 8.03) question

Yahoo Archive
1
The Job Operation has the information on an operational level.



Charlie Smith

2W Technologies LLC, Sr. Business Consultant

Phone: (312) 533-4033 x8046

(860) 620-9553

Fax: (847) 374-3620

2W Tech on Facebook
<http://www.facebook.com/pages/Chicago-IL/2W-Technologies-LLC/1391945694
32409> www.2WTech.com <http://www.2wtech.com/>



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Vic Drecchio
Sent: Monday, September 10, 2012 12:40 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] "Efficiency" reports design (Vantage 8.03)
question...





I'd start with JobAsmbl. Pull it up in the Data Dictionary. It has
actual
and estimated hours in it per Job.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Mike Abell
Sent: Monday, September 10, 2012 12:13 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] "Efficiency" reports design (Vantage 8.03)
question...

Can someone give me some guidance on what tables I might pull from in
the
Vantage DB to figure out the following scenarios:

1. I'm looking for places that hours "worked / charged" to a job do not
match hours "estimated" for that work.

2. Actual worked hours vs. estimated work hours broken down by two
versions,
daily and weekly

Any help/guidance will be greatly appreciated.

Mike Abell
Systems Analyst / Network Administrator
Flexial - BOA Group - Cookeville, Tennessee
Office: 931.432.1853 ext 302
Mobile: 615.418.3055
email: MAbell@... <mailto:MAbell%40flexial.com>
<mailto:MAbell%40flexial.com>
<mailto:MAbell@... <mailto:MAbell%40flexial.com>
<mailto:MAbell%40flexial.com> >

[Non-text portions of this message have been removed]

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2197 / Virus Database: 2437/5260 - Release Date:
09/10/12

-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2197 / Virus Database: 2437/5260 - Release Date:
09/10/12

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
2
Can someone give me some guidance on what tables I might pull from in the Vantage DB to figure out the following scenarios:


1. I'm looking for places that hours "worked / charged" to a job do not match hours "estimated" for that work.

2. Actual worked hours vs. estimated work hours broken down by two versions, daily and weekly

Any help/guidance will be greatly appreciated.

Mike Abell
Systems Analyst / Network Administrator
Flexial - BOA Group - Cookeville, Tennessee
Office: 931.432.1853 ext 302
Mobile: 615.418.3055
email: MAbell@...<mailto:MAbell@...>



[Non-text portions of this message have been removed]
3
I'd start with JobAsmbl. Pull it up in the Data Dictionary. It has actual
and estimated hours in it per Job.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mike Abell
Sent: Monday, September 10, 2012 12:13 PM
To: vantage@yahoogroups.com
Subject: [Vantage] "Efficiency" reports design (Vantage 8.03) question...





Can someone give me some guidance on what tables I might pull from in the
Vantage DB to figure out the following scenarios:

1. I'm looking for places that hours "worked / charged" to a job do not
match hours "estimated" for that work.

2. Actual worked hours vs. estimated work hours broken down by two versions,
daily and weekly

Any help/guidance will be greatly appreciated.

Mike Abell
Systems Analyst / Network Administrator
Flexial - BOA Group - Cookeville, Tennessee
Office: 931.432.1853 ext 302
Mobile: 615.418.3055
email: MAbell@... <mailto:MAbell%40flexial.com>
<mailto:MAbell@... <mailto:MAbell%40flexial.com> >

[Non-text portions of this message have been removed]



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2197 / Virus Database: 2437/5260 - Release Date: 09/10/12




-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2197 / Virus Database: 2437/5260 - Release Date: 09/10/12

[Non-text portions of this message have been removed]