We have customized the paycheck and advice as do most clients, however, the Online Check Process (Manage Payroll Process / Use / Online Check) is not using the...
1319
Kathleen M Kozina
KKOZINA@...
Jan 3, 2000 6:40 pm
We are on release 7.02 and have just acquired a business in PA. I'm trying to understand PeopleSoft's setup of the local tax table and local tax reciprocity...
1320
Landicho, Mila
milagros@...
Jan 3, 2000 6:43 pm
Bob, We also customized our checks and advices; you need to make the following change below so your version of the check and advice SQR will be executed by the...
1321
plavert2@...
Jan 3, 2000 6:44 pm
Look at the process definitions for on-line check printing and make sure it is defined properly for the SQR program that you want to use. (In Peopletools) Paul...
1322
Bergeron, Marc, Herndon
BergeronM@...
Jan 3, 2000 6:44 pm
What is the name of the SQR user website? Does it have the Peoplesoft messages archived also or are they somewhere else? Thanks, Marc...
1323
John Hayes
owner@...
Jan 4, 2000 1:38 am
The web site is www.sqrug.com It does have an archive you can search. Although it's not PeopleSoft specific, there is some PS pertinent information relating...
1324
Joe Johnson
jejohn1216@...
Jan 4, 2000 1:39 am
I was wondering --- Is everyone ready to pick up with the study group again? I think we are on Chapter 5. Joe Johnson ;{) ...
1325
Samuel Fung
fungsamuel@...
Jan 4, 2000 1:39 am
Hi Marc, You can visit http://www.sqrug.com/ Hope this help you. Samuel ______________________________________________________...
1326
Dianne Rowland
dianne_rowland@...
Jan 4, 2000 2:03 pm
Sure. Sounds good to me. I think we covered Ch 5. Dianne ... From: Joe Johnson [mailto:jejohn1216@...] Sent: Monday, January 03, 2000 4:13 PM To:...
1327
Linda Silver
linda_silver@...
Jan 4, 2000 5:04 pm
Does anyone know if temporary tables can be created within an SQR? If so, could someone provide me an example of the syntax? thanks....
It probably depends on what database platform you're on. If you're using Informix, you can do it within a "begin-SQL" block. You would use the "CREATE TEMP...
1331
Manoj Gurjar
mgurjar@...
Jan 4, 2000 6:04 pm
Yes temporary tables can be created from within a SQR. It does depends on Database you are working on. Use something like this in a procedure: begin-sql create...
1332
Joan hsieh
joan.hsieh@...
Jan 4, 2000 6:05 pm
Hi Peoplesoft-fans, I am the oracle dba at TUFTS university. we had HRMS on live last year. This year we plan to have financial database go live on July lst. ...
1333
Dianne Rowland
dianne_rowland@...
Jan 4, 2000 6:06 pm
We're on PS Financials 7.52, NT, Oracle. Has anyone had any experience with a customer ID turning up missing? Is there anyway to delete a customer ID from...
1334
Bryan deSilva
improvisations@...
Jan 4, 2000 6:06 pm
RE: SQR-05 Are we ready to pick up the study group yetSorry I've been delayed in getting this going. We're finishing up moving home AND office this week. The...
1335
Michael George Lim
michaelgeorgeflim@...
Jan 4, 2000 6:21 pm
Hi Linda, In Oracle I know you can. Just define the SQL Create syntax within the Begin-SQL and End-SQL section. You can get the SQL Script by going to App...
1336
Durga Masanam
dmasanam@...
Jan 4, 2000 6:21 pm
Hi Dianne, I know we can inactivate a customer but this is a strange issue. Could you please give more details like panels and record definitions. Thanks, ...
1337
Pawlak, Mark
PawlakM@...
Jan 4, 2000 6:21 pm
There is an ID delete process setup in the menu Administer Workforce. This systematically goes through every table with emplid as a field and deletes the rows...
1338
Jaime Busse
jaime_busse@...
Jan 4, 2000 6:22 pm
hi all. here is a dba question - the developers had applied all the withholding fixes to our development database. Then we moved them over to the test...
1339
Pamela Lantzy
PLantzy@...
Jan 4, 2000 6:54 pm
How about taking a copy of the production database and making a test instance then moving your fixes from DEVL to TEST. ... From: Jaime Busse...
1340
Stefanie Vario
Svario@...
Jan 4, 2000 6:54 pm
We haven't found any easy way to just refresh the data because most of the time the fixes also involve changes to the structure of the tables. So, the DBA...
1341
Dianne Rowland
dianne_rowland@...
Jan 4, 2000 7:25 pm
I totally agree with this. That is what we do as well. It is much faster and more efficient as well, as not having to worry that something that was missed in...
1342
Dianne Rowland
dianne_rowland@...
Jan 4, 2000 7:37 pm
Thanks, I knew about that in HR which is why I was interested if there was something similar for Customers in Financials. Dianne ... From: Pawlak, Mark...
1343
Dianne Rowland
dianne_rowland@...
Jan 4, 2000 7:41 pm
A for example is that there is a record in ps_bi_hdr that has the bill_to_cust_id as a particular number, and when I look in the ps_customer table, there is no...
1344
Joan hsieh
joan.hsieh@...
Jan 5, 2000 2:49 am
Hi Mike, I cannot find this dbrefrsh data mover script. Would you please give me more information about this? I usually recycle the application server for...
1345
Sheila Wilkening
swilkening@...
Jan 5, 2000 2:50 am
Jaime, Depending on the database, the answer may be different. However, we run PeopleSoft on Oracle and this is how we deal with this issue. When the...
1346
Jaime Busse
Jaime_Busse@...
Jan 5, 2000 2:50 am
we didn't realize until the fixes were applied that we could use some newer data. I guess I will plan ahead next time. Thanks... ... From: Pamela Lantzy...
1347
Mike Fulce
m.fulce@...
Jan 5, 2000 2:50 am
Ditto. This is exactly what we have found as well. However, one of the "challenges" that this scenario doesn't always solve is moving "setup" or base table...
