HRMS TABLES
Forum » Forum / Help » HRMS TABLES
Started by: DURGAVAJHULADURGAVAJHULA
On: 1276577874|%e %b %Y, %H:%M %Z|agohover
Number of posts: 2
rss icon RSS: New posts
Summary:
Can i find all the list of hrms tables in one table
Unfold All | Fold All | +More options
Fold
HRMS TABLES
DURGAVAJHULADURGAVAJHULA 1276577874|%e %b %Y, %H:%M %Z|agohover

I want to know all the hrms tables available in peoplesoft. can i find the list of all hrms table names in one table, if so please provide the name of that table.

Reply  |  Options
Unfold HRMS TABLES by DURGAVAJHULADURGAVAJHULA, 1276577874|%e %b %Y, %H:%M %Z|agohover
Fold
Re: HRMS TABLES
PrajPraj 1276750413|%e %b %Y, %H:%M %Z|agohover

If you are just after tables, start with the following query:

select RECNAME, RECDESCR
from PSRECDEFN
where RECTYPE = 0
and RECNAME not like 'PS%'
order by RECNAME;

A RECTYPE of 0 indicates a table. The condition RECNAME not like 'PS%' excludes the PeopleTools tables which (largely) start with PSabc (e.g. PSOPRDEFN).

Reply  |  Options
Unfold Re: HRMS TABLES by PrajPraj, 1276750413|%e %b %Y, %H:%M %Z|agohover
New Post
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License