Cindy, I printed 1099's the past 2 years using peoplesoft, but I am not working with it this year. When I did it Peoplesoft delivers sqr's to print 1099's and...
Pawlak, Mark
PawlakM@...
Oct 1, 1999 12:16 pm
2438
Can someone send me the minimum Hardware requirements needed for the following? Operating System: NT RDBMS: SQL Server 7.0 PeopleSoft version: 7.5x ...
Anthony Abraham
akeem.abraham@...
Oct 1, 1999 10:35 am
2439
John, Yes, you can issue a commit within your SQR. In your example I do not see where this would be a problem since the commit is done at the end of the ...
John A. Hayes
owner@...
Oct 1, 1999 12:35 pm
2440
Glenn, Check out an employee in the Tax_Distrib table. If the greatest effective dated row has a (zero) for distribution percentage, you will have pay ...
Dave.Anderson@...
Oct 1, 1999 1:43 pm
2441
Glenn, We had problems using our new version of PAYUPDT, We generally get 3 or 4 batches of timecards. It turned out that some of the time on the last batch ...
Tonie Salzano
salzano@...
Oct 1, 1999 3:10 pm
2442
The commit is causing your driving select to be closed and reopened from the beginning (i.e. no CURSOR WITH HOLD). To avoid this problem you need to modify...
Victor Loghin
vgl_ca@...
Oct 1, 1999 3:11 pm
2443
We are currently in the design phase of PS HR 7.5 working with MicroSoft SQL database. We are using a small database at this time during initial design. We...
bari.s.kaplan@...
Oct 1, 1999 4:21 pm
2444
We worked with our Quality Control Group (QCG)to establish this process for PS migrations: Our developers create a standard Change Control request when...
vduganea@...
Oct 1, 1999 4:25 pm
2445
We also have a 'home-grown' time system. We put all of the hours, including REG and OT into 'Other Earnings' so that they won't get changed. Ginny "rick...
vduganea@...
Oct 1, 1999 4:32 pm
2446
Rick, Your problem occurs when the "Automatic Paysheet Update" flag in the Pay Group table is set to "Y"es. Any changes (job, tax, additional pay data, etc.)...
Mitchum, Allen - AD/C...
AMitchum@...
Oct 1, 1999 4:52 pm
2447
HELP..... DOES ANYONE HAVE ANY EXPERIENCE WITH CREATING DBF FILE USING SQR !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ARE YOU ABLE TO UPLOAD THESE...
Carshena Yeargins
cyeargins@...
Oct 1, 1999 6:43 pm
2448
Rick, You may also want to look at Report ID R-RLS-7X86N in Customer Connection. This addresses the problem with regular hours being overridden for hourly ...
Mitchum, Allen - AD/C...
AMitchum@...
Oct 1, 1999 7:39 pm
2449
Hi all, Thank you again to those of you who gave suggestions to help us solve this mystery of missing paysheet (pay_earnings) rows and about 50 hourly...
Ackerson, Glenn
Gsacker@...
Oct 1, 1999 10:53 pm
2450
I don't have my DB2 messages and codes book in front of me, but isn't a -803 a duplicate key value? john_sayr-@... wrote: original...
drnichols@...
Oct 2, 1999 1:05 am
2451
we are ps 7.5 hr,pr,ben on db2/aix we are looking for ways to shorten the time it creates to copy instances between environments (ie copy production back to ...
cbthompson@...
Oct 2, 1999 1:06 am
2452
We create a lot of flat files that we in turn import into either MS Access or Excel. If there is a way to create a dbf or xls file from SQR we'd be very...
Dianne Rowland
dianne_rowland@...
Oct 4, 1999 12:04 pm
2453
Carshena, start access select file, new select blank database key a new db name click create then select file, get external data, import in the file name box...
Sills, Scott
sillssc@...
Oct 4, 1999 12:54 pm
2454
Hello Dianne, I found a sqc from www.sqrug.com website; that converts text files into dbf files. I have attached the files,maybe this can help you. ... ...
Carshena Yeargins
cyeargins@...
Oct 4, 1999 1:44 pm
2455
a correction, this sqc and text file can be found in the psusers egroups valult...
Sills, Scott
sillssc@...
Oct 4, 1999 1:55 pm
2456
Hi all, I currently receive many files in Excel format with data that is used in a Sqr. I currently convert the file to a comma seperated file and read the CSV...
Rick Doherty
Rick_Doherty@...
Oct 4, 1999 4:20 pm
2457
I am trying to use ziv flag. The solution i want is if the user runs the sqr in the client the program should use -ziv flag. If he is running in server the...
bln@...
Oct 4, 1999 5:42 pm
2458
To be able to do that you should write a sqc that is called after the report is complete and check to ensure that it was run on the client. Then call the ...
Robert Stojkovic
rstojkovic@...
Oct 4, 1999 6:48 pm
2459
You didn't say what type of server you are running, so I'll model my response to what I've seen the most - UNIX. This should be no problem. Go ahead and add...
John A. Hayes
owner@...
Oct 4, 1999 6:57 pm
2460
How about adding the ziv flag to the process-type of SQR (within process-scheduler) that run on the client? Choose process-type. Choose your operating system...
SNafissi@...
Oct 4, 1999 9:10 pm
2461
Anyone have any experience with the payroll interface and multiple job rows (Sequence Numbers) with the same effective date? Example: A separate row is written...
cara.wiggins@...
Oct 4, 1999 9:55 pm
2462
I looked up HNTAX007.sqr and could not figure out where $priorCompany and $priorName come from. I tracked sqc files, but could not find these variables...
xlle@...
Oct 5, 1999 2:16 am
2463
Jennifer, I wrote a utility called SQR Tree for Windows that shows a tree structure of the procedure calls in an SQR. It has the ability to drill down on...
Ivory, Wayne
wayne.ivory@...
Oct 5, 1999 3:02 am
2464
Cara.. Anytime you insert a row that has the same EFFDT, the EFFSEQ should increment by 1. That is a standard functionality of the PS system. Sam <<<...
Sam Spritzer
SSpritzer@...
Oct 5, 1999 11:14 am
2465
Thanks Sam. We've got the EFFSEQ functionality down. My question is how to set up the payroll interface to properly compare and export the rows to ensure the...
cara.wiggins@...
Oct 5, 1999 1:20 pm
2466
Cara... Is it possible for you to give a brief example of what it is doing vs. what you want it to do...and you don't have to include all of the columns from...