The information you're looking for is in a table called psauthitem. The field 'authorizedactions' tells you what actions the oprclass has access to. ...
5007
Brian Parnes
brian.parnes@...
Jan 2, 2001 11:27 am
Here is a snippet from an SQR I wrote to report on Security that shows what the codes mean for the authorized actions... 'Key: A = Add, U = Update Display, L =...
5008
Weaver, Judith R
weaverjr@...
Jan 2, 2001 12:34 pm
Hi Brian Do you know where this info originates in PeopleSoft documentation? ... From: Brian Parnes [mailto:brian.parnes@...] Sent: Tuesday, January...
5009
Weaver, Judith R
weaverjr@...
Jan 2, 2001 1:02 pm
I've created a table (see below) to hold the codes for objecttype in projects to make it easier to query projects. Unfortunately, when creating an inquiry...
5010
Brian Parnes
brian.parnes@...
Jan 2, 2001 1:08 pm
Sorry... Don't know that I've ever seen it written down by PeopleSoft... I decoded it several years ago at another site when the functional staff requested a...
5011
Weaver, Judith R
weaverjr@...
Jan 2, 2001 1:25 pm
Think I found it -- there are two sqcs that have a lot of goodies in them: upgcodes.sqc and upg.sqc. upgcodes.sqc has the codes for menu item access as well...
5012
alcazar23@...
Jan 2, 2001 2:08 pm
Try running it to 'WINDOW' and see if you get the same error. Once you have run it to the window you can then print it. If you still receive an error then i...
5013
Elder, Corey
celder@...
Jan 2, 2001 2:16 pm
Check the "Display Zero" option on the Display Options section on the field in Application Designer for that panel. That will show zero values. Corey Elder ...
5014
Weaver, Judith R
weaverjr@...
Jan 2, 2001 2:33 pm
DUH! Thanks Corey ... From: Elder, Corey [mailto:celder@...] Sent: Tuesday, January 02, 2001 9:15 AM To: 'peoplesoft-fans@egroups.com' ...
5015
Huettinger, Frances
fhuettinger@...
Jan 2, 2001 4:54 pm
Thanks to anyone who has responded along the way. We just SQL altered ps_ledger_budg_drl to look like our demo. Looks like itemizations are working. I will...
5016
mahonj@...
Jan 2, 2001 6:53 pm
Hi, We're converting from Sybase to SQL Server before upgrading to version 8. Based on everything I've read, Peopletools is platform-independent. As a test,...
5017
Amy Harvel
aharvel@...
Jan 2, 2001 8:42 pm
We are in the planning phase of the HRMS 7.02 to 7.51 upgrade. Is there anyone out there that would be willing to share their complete project plan? We have...
5018
Pedersen, Chuck
Chuck.Pedersen@...
Jan 2, 2001 8:42 pm
We have 2 system administrators that handle all the security, along with coordinating all production moves. When adding or changing large groups of users r...
5019
Kim Ngo
kngo@...
Jan 2, 2001 8:42 pm
Thank you for your suggestion, I was able to make it work. Happy New Year to all. Kim ... From: Elder, Corey [mailto:celder@...] Sent:...
5020
Al Kanji
akanji@...
Jan 2, 2001 8:43 pm
I believe I had said that you ought to check your ledger definitions......and the chartfields associated with the ledgers...casue we had the same problem and...
5021
anagha bagde
anaghabagde@...
Jan 2, 2001 8:43 pm
Thanks, I can run it to window and print it. But I want to run it to printer. Whether changing of DLL's with new DLL's will help? ... ...
5022
Huettinger, Frances
fhuettinger@...
Jan 2, 2001 9:34 pm
Thanks for your additional response, Al. I DID think of what you said, after I finally figured out the problem. I just had not understood what you MEANT by...
5023
Huettinger, Frances
fhuettinger@...
Jan 2, 2001 9:44 pm
I am unable to press the icon on the Budgets Users tab. Once I have opened the phase and run BDPMON07 and 08, the first two icons are grayed out. Only the...
5024
Ginny Dugan-Earley
vduganea@...
Jan 2, 2001 10:08 pm
Last year the final changes for the year-end/W2 process were delivered in 99-G. We were told that we wouldn't need 00-A to do W-2 processing. I think this is...
5025
Lindstrom Jr, Arthur F
alindstrom@...
Jan 3, 2001 12:33 am
Jim, The bad news is that you need someone with some understanding of the Pennsylvania standard local tax codes. As of 7.5, PeopleSoft is using the state's...
5026
Hebert, Daniel W.
dwhebert@...
Jan 3, 2001 1:17 pm
Happy New Year to everyone, I have a PeopleSoft and Oracle question. We are using PeopleTools 7.53 with Oracle 8.0.4 as of today. The PeopleSoft DBA would...
5027
Elder, Corey
celder@...
Jan 3, 2001 2:16 pm
Have you thought about doing a Tools upgrade along with an Oracle upgrade? We are currently upgrading to Tools 7.6 from 7.56 so we can go from Oracle 8.0.5 to...
5028
Hebert, Daniel W.
dwhebert@...
Jan 3, 2001 2:22 pm
Hi Corey, Yes, I have considered doing a tools upgrade, but we are tentatively scheduled to ship our database to the PeopleSoft Upgrade lab at the end January....
5029
Elder, Corey
celder@...
Jan 3, 2001 2:42 pm
You could probably get away with running on an unsupported release. You could upgrade your development or test database and see what happens. If all goes...
5030
Amelia Emerson
apemerson@...
Jan 3, 2001 3:31 pm
Happy New Year to all PeopleSoft Fans! We could use some help with an nVision reporting problem in the new V7.5 E&G Financials database we just upgraded. We...
5031
Faridah Anuar
afaridah@...
Jan 3, 2001 4:07 pm
Hi, What is the correct syntax for executing count() in SQR? E.g. select count(*) from ps_employees and...make use of the result of the count to do some...
5032
Al Kanji
akanji@...
Jan 3, 2001 4:07 pm
Try recreating your query - in our upgrade sometimes the query objects from the old did not migrate correctly. Al ... From: Amelia Emerson...
5033
Elder, Corey
celder@...
Jan 3, 2001 4:12 pm
BEGIN-SELECT COUNT(*) &EMP_COUNT(or whatever variable you want to use) let #emp_count = &EMP_COUNT FROM PS_EMPLOYEES END-SELECT Then use the #emp_count...