Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting fields for table

Status
Not open for further replies.
kensington43

kensington43

Technical User
Nov 29, 2005
50
US
How can I find out all the fields available in a PeopleSoft Table?

I use Describe TableName in Oracle but not sure about PeopleSoft.

Please advise.
 
Sort by date Sort by votes
Do a select on PSRECFIELD order by either RECNAME or FIELDNAME.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

peoplesoft18
  • Locked
  • Question
Peoplesoft Payroll for North America
Replies
0
Views
149
peoplesoft18
peoplesoft18
jcw12000
  • Locked
  • Question
ERD or List of all tables and table descriptions for Account Payable module NEED UGENT
Replies
0
Views
118
jcw12000
jcw12000
Dimitrie1
  • Locked
  • Question
derived fields
Replies
0
Views
59
Dimitrie1
Dimitrie1
vrijhof
  • Locked
  • Question
profile fields and real-time advisor
Replies
0
Views
63
vrijhof
vrijhof
rsadasivam
  • Locked
  • Question
Need to Begin_Date and End_Date columns to an EFFDT table.
Replies
2
Views
154
jmanj
jmanj

Part and Inventory Search

Sponsor

Back
Top