Re: Question on prompt tables in PeopleSoft

[Arun Kumar <arunkumar13@YAHOO.COM>]

I am not sure,
But I think you can use the key_type field in the
psrecfield table for the editable record. And ofcourse
if the editable record has effdt you would find the
effdt is also as the primary key.
You may want look for the fields with key_type = 'PK'
in the editable table and exclude the effdt.
--- helen rao <raoht@HOTMAIL.COM> wrote:
> The EDITTABLE field in PSRECFIELD only gives me the
> name of the prompt
> table. I need to determine the field in the PROMPT
> table that will be used.
>
>
> >From: Pamela Lantzy <PLantzy@UAMAIL.ALBANY.EDU>
> >Reply-To: sqr-users@list.iex.net
> >To: SQR-USERS@list.iex.net
> >Subject: Re: Question on prompt tables in
> PeopleSoft
> >Date: Fri, 3 Aug 2001 10:23:06 -0400
> >
> >You can get this information from table: PSRECFIELD
>  - field:EDITTABLE.
> >
> >
> >
> >  -----Original Message-----
> >From:   helen rao [mailto:raoht@HOTMAIL.COM]
> >Sent:   Friday, August 03, 2001 9:59 AM
> >To:     SQR-USERS@LIST.IEX.NET
> >Subject:        Question on prompt tables in
> PeopleSoft
> >
> >Hi,
> >
> >I need to write an sqr that will
> >-accept the name of a field(and its table) as input
> and
> >-return the prompt table(and the field in the
> prompt table) it is populated
> >from.
> >
> >For example, say, I have a field called 'EMPNO' in
> Record A. The prompt
> >table for this field is the record
> 'PERSONAL_DATA'(that has the field
> >'EMPLID'). Hence, 'EMPNO' in record A is populated
> from 'EMPLID' in record
> >'PERSONAL_DATA'.
> >When I input 'EMPNO' to my sqr, it should return
> 'EMPLID(PERSONAL_DATA)'.
> >
> >Now, How do I write a query for the above?
> >
> >Thanks,
> >hr
> >
>
>_________________________________________________________________
> >Get your FREE download of MSN Explorer at
> http://explorer.msn.com/intl.asp
>
>
>
_________________________________________________________________
> Get your FREE download of MSN Explorer at
http://explorer.msn.com/intl.asp


__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/