That did it. That created the EMPLINK data in the empmaster table that then would link up with the PRChkDtl EMPLINK. Thank you SO much!
Mike..
Mike..
--- In vantage@yahoogroups.com, John Driggers <waffqle@...> wrote:
>
> Go to payroll employee maint.
>
> In the actions menu there is an option for 'generate employee links'. This
> will create the links between the tables and populate the empty fields.
> You'll need to re-run this anytime you add/remove employees.
>
> I believe they do this so that normal users with BAQ access can't get into
> PR info. At least I recall hearing that somewhere.
>
> On Mon, Jun 4, 2012 at 1:09 PM, Vic Drecchio <vic.drecchio@...>wrote:
>
> > **
> >
> >
> > Out of curiosity I checked the Training DB. EmpLink is populated in PRCheck
> > and PRChkDtl but not in PREmpMas.
> >
> > The Data Dictionary says it's usually blank.... so that's useless. In fact
> > it says for PREmpMas.EmpLink: ".This field is normally blank, which means
> > file joins are impossible. This value can be set/reset only by the payroll
> > manager via an option in system maintenance."
> >
> > Hmm.. This is a good question.
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of
> > Vic Drecchio
> > Sent: Monday, June 04, 2012 12:54 PM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] Re: ODBC for Payroll in Vantage 8.03
> >
> >
> > Sorry, hit SEND too quickly.
> >
> > That EmpLink field is in both tables.
> >
> > If I recall correctly there is a PREmpMas table. It's an extension of
> > EmpBasic. but it has your EmpLink field.
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > Behalf Of
> > flexial_ma
> > Sent: Monday, June 04, 2012 12:45 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: ODBC for Payroll in Vantage 8.03
> >
> > I'm actually looking at PRChkDtl and PRCheck and I've got them working now
> > but I cannot figure out what to link to find out the ID of the employee the
> > check is written for. I see the EMPLINK field but it doesn't link back to
> > anywhere I can find a EMPID for. Any ideas?
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> , "Vic
> > Drecchio" <vic.drecchio@> wrote:
> > >
> > > Are you looking for LaborHed and LaborDtl?
> > >
> > >
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ] On
> > Behalf Of
> > > Mike Abell
> > > Sent: Monday, June 04, 2012 9:41 AM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > Subject: RE: [Vantage] ODBC for Payroll in Vantage 8.03
> > >
> > >
> > >
> > >
> > >
> > > No, just when I look in the payroll type tables, there's nothing in there
> > > shown and I expected there to be some which led me to believe that
> > "maybe"
> > > it just wasn't letting me access them.
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ] On
> > > Behalf Of Jose Gomez
> > > Sent: Monday, June 04, 2012 8:38 AM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > Subject: Re: [Vantage] ODBC for Payroll in Vantage 8.03
> > >
> > > It should allow you to access ANY tables within Progress. Are you getting
> > a
> > > specific error?
> > >
> > > *Jose C Gomez*
> > > *Software Engineer*
> > > *
> > > *
> > > *checkout my new blog <http://www.usdoingstuff.com> *
> > > *
> > > *T: 904.469.1524 mobile
> > > E: jose@ <mailto:jose%40josecgomez.com>
> > > http://www.josecgomez.com
> > > <http://www.linkedin.com/in/josecgomez>
> > <http://www.facebook.com/josegomez>
> > > <http://www.google.com/profiles/jose.gomez> <
> > http://www.twitter.com/joc85>
> > > <http://www.josecgomez.com/professional-resume/>
> > > <http://www.josecgomez.com/feed/>
> > > <http://www.usdoingstuff.com>
> > >
> > > *Quis custodiet ipsos custodes?*
> > >
> > > On Mon, Jun 4, 2012 at 9:34 AM, flexial_ma <mike.abell@
> > <mailto:mike.abell@%0b%3cmailto:mike.abell@%0b>
> > <mailto:mike.abell@%0b>
> > > <mailto:mike.abell%40kingston-asfc.com> >wrote:
> > >
> > > > **
> > > >
> > > >
> > > > I am needing to create some reports using ODBC that use the payroll
> > > > tables in Vantage. We are on Progress 10.1. I have the sysprogress
> > > > user setup and all and it's working but I don't believe that allows me
> > > > to access the payroll tables in the Vantage database. I'm using
> > > > Crystal Reports outside of Vantage using ODBC as this is my prefereed
> > > method for designing reports.
> > > > Thanks!
> > > >
> > > > Mike..
> > > >
> > > >
> > > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > > ------------------------------------
> > >
> > > 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/.
> > <http://groups.yahoo.com/group/vantage/files/>
> > <http://groups.yahoo.com/group/vantage/files/>
> > > <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/linksYahoo! Groups Links
> > >
> > >
> > >
> > > No virus found in this message.
> > > Checked by AVG - www.avg.com
> > > Version: 2012.0.2178 / Virus Database: 2425/5044 - Release Date: 06/04/12
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> > No virus found in this message.
> > Checked by AVG - www.avg.com
> > Version: 2012.0.2178 / Virus Database: 2425/5044 - Release Date: 06/04/12
> >
> > [Non-text portions of this message have been removed]
> >
> > No virus found in this message.
> > Checked by AVG - www.avg.com
> > Version: 2012.0.2178 / Virus Database: 2425/5044 - Release Date: 06/04/12
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
>
>
> --
> *John Driggers*
> *High End Dev, System Design, Profit Drinking*
> *
> **:: 904.404.9233*
> *:: waffqle@...*
> *:: NO FAXES*
>
> *
>
> *
>
>
> [Non-text portions of this message have been removed]
>