Hi,
I am a novice user for PS 9.0 , i want to know the information about PS delivered table, what is the purpose of that PS table and whats the purpose of fields.
Does we have any reference(DOC,URL) which track this type of information.That would be great for a me.Thanks in advance.

Hi there,
I guess your confused about what a "PS delivered" table is. All the tables you see in the post are PS peopletools delivered tables. There are hundred other more Financial, HR (depending on your PS module) delivered tables.

Please start a forum topic if you want more info.

Hi,
Thanks a lot for such a useful information. As a PeopleSoft apps DBA, information given by you helped me alot.

Appreciate

Hi,

I'm trying to find out the Meta table which stores App designer-created HTML objects(not to be confused with HTML areas)

Please help me with this

Thanks,
Dan

Dan, look into the below table, they should be there.

SELECT *
  FROM pscontdefn

Thanks Lepa....but i'm not able to find the actual HTML text defined within this table....

Lemme brief you on what i'm trying to do.....I have to use some lengthy text data(which exceeds the limit in message catalog) in an application engine....I put this in a HTML and tried to use the GetHTMLText function to fetch the data.....but unfortunately, this built in function is not allowed to be used within an AE program....

I'm trying to find out the table which stores the HTML data so that I can query and fetch it directly....

Any further pointers on this would be greatly appreciated!

TIA!
Dan

Hello PSFT Guru,

I am not a PSFT DBA, but researching on the peoplesoft Supply Chain Management (SCM) tables.
My question is - do we have any weblink/document or a good book providing information on module-wise PSFT tables?
I will elaborate my problem-
For example - I am looking at Purchase Order page of PSFT SCM module. I want to know- which Peoplesoft table stores information written on Create Purchase Order Page in peoplesoft.
Specifically I am also looking at tables storing configuration/set up for Peoplesoft Supply Chain Management (SCM) module.

Thanks!
~Ambarish Vaidya, Chartered Accountant

Hi there, can anyone tell me where are the database error messages are stored in PS. Maybe a error generated from a SQL class statement..

Hi,

I need to find all the records in a given component. I need to do this for many peolesoft components. Does anybody have a query which takes component name as input and the list of all records in that component as output. Please help.

I've posted your question on the forum so everyone can benefit from it. I've also gave you the solution. Here is the link http://www.compshack.com/forum/peoplesoft/peoplesoft-technical/how-to-find-all-records-used-peolesoft-component

Hi
We on tools 8.49 but these two records contain no data:
PSQRYEXECLOG & PSQRYSTATS

Must some auditing be switched on before data is recorded?
Thanks

Hello,

do you happen to know in which table i get the Title found on the search page of a component ?
When entering the page "Process schedule > Process" the title that appears is " Process " , and i want to know in which table is that found, so i could add for different languages in its LANG table

If you happen to know that would be soooo helpful

THank you

Basically it comes from the component properties.

If we had given message catalogue message set/number then it will be fetched from the psmsgcatdefn record.

Regards,
Hari.A

thank you for your help..
i went on to create a PLSQL finding all tables containing the wording i wanted to change.. took some time
but i found out it was in the table :
PSMENUITEMLANG

Thank you

Check the PSMSGCATDEFN record. Peoplesoft has delivered message set numbers up to 20000. Check this and let me know if you are looking for this.

Regards,
Hari.A

Hi ,

I do not have any date columns in my PSFT tables.If i want to check the latest records, is their any possibility to get that information

Do you want to find the latest record/table created?

If so query this table PSRECDEFN. You will find all records details.

Do you want to find the latest row of data inserted to a record?

If so query the audit records, you will find all the details about that new row.

Hope I answered to your question. Pls let me know if am not answering to your question.

Thanks,
Hari.A

Thanks Hari,

Let me explain the problem.I am trying to figure out a logic for incremental load in Informatica.And my tables are not containing any date columns.Say suppose I had run a load last month 22 and I want to run a incremental load today,which should populate the data from 22 of last month till today.So is there any table which could give me the information when these records are getting inserted

As per my understanding, you are saying the last run date as you are running the load the load on 22 last month and making a note of this date manually. Also you have any date columns in the table

If you are loading data from file to table then
Before loading the data in to table do a compare between current file and the last run file. Find the differences and load the difference into the table

Or Let say if you are loading data from table to file then
Load the entire data into the file and the do a compare between current file and the last run file. Find the differences and load the difference into the new file.

This process will not be limited to the data that came newly to the system after 22nd last month. This process will find all the rows that are changed from the previous load irrespective of the date.

Regards,
Hari.A

Hi,

I need to know all the people tools Meta-tables related to Integration broker. I have to update the App Message definition without creating a new version. As App message is referenced in run time tables , peoplesoft does not allow me to edit anything related to App Message via interface or app designer.
I think of directly updating DB table , can anyone tell whether this option would work?

Thanks in advance!!!

-Amit.

while looking at the page hit ctrl+J or (IE only) right click and select "view source"

We use a tool called Saphir from Silwood Technology that is all about browsing the metadata in a PeopleSoft system. It show tables and fields with the nice 'English' descriptions, let's you navigate around relationships, and also groups tables by module. It also shows tables in data model form, optionally in things like ERwin or Visio

I was just on their site and was hopping they will list the price for such a tool. Thanks for the info :)

Hello Friends,
Is there any tool to see the PeopleTools Table Definitions ? Please tell me if any one you know that.

Thanks
Veerakarthi

Hi,

I am using PSPNLFIELD along with PSDBFIELD to retrieve fields available on a page. The information about Field Type, Format of a field is stored in form of digits in the meta-tables. Which is not understandable.

How to get information of FieldType, Format for a field in interpretable form.

Regards,
Dhaneshwar

you need a case statement in your selelct from PSDBFIELD.

CASE FIELDTYPE
WHEN 0 THEN 'Character'
WHEN 1 THEN 'Long Character'
WHEN 2 THEN 'Number'
WHEN 3 THEN 'Signed Number'
WHEN 4 THEN 'Date'
WHEN 5 THEN 'Time'
WHEN 6 THEN 'DateTime'
WHEN 8 THEN 'Image'
WHEN 9 THEN 'Image Reference'
ELSE TO_CHAR(FIELDTYPE)
END CASE

Hi,

I am using PS 8.9 and was wondering if there is a table that stores record counts for all tables in PS?

Thanks,
Jesse

Hi,
Is there a way i can determine how many times a PSQuery was executed? I am currently using Peoplesoft 7.6 version.

James

Hi All,

i have upgraded peoplesoft application ELM from 9.0 to 9.1 . now i want to know application version in database part . can u plz say me the query to find out version of application.

Thanks in advance

Thanks,
Sriram
Mailid:srirams086@gmail.com

Hi,
I am using one table as input for the app engine.
when i am running the app engine, it is failing with error message as First operand of . is NULL.But the emplid which is shown in log message is not in input table.
so want to confirm that, is it a cache issue ? clearing the cache of process scheduler will solve the issue?
Please help me on this.

Thanks in advance

Surya.

hi all,
how can we find out already delivered tables

is it like this

SELECT * FROM PS_%
or
SELECT * FROM PS_PSU_%

Hi Shalini,

If you want to find all delivered records , like record name starting from PS then use following Query,

Select recname from PSRECDEFN where recname like 'PS%'

Very very useful

Did any one know in which table the comments (on general tab in properties) of every object stores?

User have PSFN access till 19th aug 2015 , someone have deactivated the profile i.e(user not having primary permission list) . How to trace the log file or the info like who done that and why ?

Thanks ,
Anupama.

Is there a way to find the page in PeopleSoft based on URL Description or URL Identifier from URL Maintenance? If not please suggest a way. All I have is URL Identifier with me

Great detail!

Any idea what record contains the data for whether a field is required or not?

How do I find the PTools record(s) orpage behind the Grid Properties page in Application Designer. That is, when you open a given page, select a grid on that page, then right click and select 'Page Field Properties'. When the new Grid Properties subpage pops up and you go to the Use Tab, that is the record(s)/page I am looking for. We recently implemented Fluid, and now our scrolls don't all work correctly, and we need to manually script a change to the Grid Layout value on this page. Thanks so much for your help!