HI,

Can anybody help me out with the sql to get the list of tables having specific field as key in the entire database.

ex: In HCM I want to find the list of tables having EMPLID as key field.

Thanks in advance,

Regards
Mastan.

I am new to Peoplesoft Finance.
I want to know the how data will flow into General ledger.
i.e from AR to GL, AP to GL.
please help me regarding that if it possible give me the Imp table names for each Module.

Thanks,
Kiran Kumar

Hi,

When i ping my local node i am getting the error as "PSFT Authentication token failed for Node PSFT_HR". Can any please help in this regard.

I have also added my the local node in the navigation :- PeopleTools -> Security --> Security Objects --> Single Singon. Even then i am getting the above error.

Hi Can any body please tell me how to find out which record is a bolt on and which is delivered. e.g. if in PSRECDEFN or in any other record , any field through which this can be analyzed?

Can anyone tell me what's wrong with this function please?

/*Function to return a date a specified number business days from an input date */
Function getBusinessDays(&inputDate, &numDays) Returns date
/* Date variable to hold future date to be returned */
Local date &futureDate;

/* SQL Statement to return future date */

I want to do a validation that the user should not be allowed to make an entry in the timesheet page on weekday against a weekend TRC and vice-versa.

So can you please help me with the same? How to proceed for this?

I set up resume template and have content type in resume. I try apply job in candidate gateway. The first time it show template according to my set up but I try second time it don't show template same first. It doesn't show content type. Such as The first I can fill Language Skills(content type) but I apply the second time Language Skills field don't show on that resume. How can I do this?

What is Referential Integrity process in PeopleSoft. I saw in one of the PeopleSoft HRMS materials "If you change the holiday schedule associated with a workgroup, the Referential Integrity process will trigger Time Administration to process any time affected by the change in holiday schedule".

Can someone please explain what is this process and what it does?

My users want a page with 3 upload buttons, helping them upload 3 types of files to different URL destinations.

I'm not sure how i should do this (or is it possible). They just want the files to be uploaded to the file server so that from another page, other users can download the files by clicking a link.

As I see there is a built-in function using a sub-record which I will need to include in my primary record, I'm not sure how the 3 buttons/ files can be relating to a single sub-record. Can anyone help please? Thanks in advance.

hi, everybody, first that all, excuses for my bad english... im a junion analist, and i have to make a modification in a original peoplesoft page, the client want to put in the page 2 new fields one of them to select item witholding transaction, and the other one to enter the number of the witholding voucher, i did those, and i store it in a record made by myself, but now, they want to gray or ungray those new field depending the selection of a checkbox placed in the level 0 scroll of the page.