Re: [sqr-users] Converting Peoplesoft EMPLID programatically

["Larry Roux" <LRoux@syr.edu>]

This question would be better posted to the ps.tech listserv

You have to do this with much care as not all fields that hold an
EMPLID are actually called EMPLID.  (PeopleSoft's process misses these
too)

What you may want to do is something like this:

step 0: Purge tables that are not necessary (logs, etc)
1) create a temp table with one field RECNAME
2) find all the tables with fields containing EMPLID, then check if
there are rows in that table (I would bet you don't have rows in 50% of
the PS tables).  If so insert the table name in the temp table
3) Now select all the rows from PS_PERSONAL_DATA.  For each of these,
do an update on the tables in the temp table updating the ID.
4) Update the statistics on all the tables in your DB.

That will take a loooooong time - although 10,000 is not very many
people.  It all depends how much data you have.  You may also need to
add indexes to speed things up.




Larry Roux
Syracuse University
lroux@syr.edu


>>> MCKEON@shands.ufl.edu 2/1/2005 12:19:31 PM >>>
We have been asked to convert the "emplid" field in Peoplesoft to a
new
value (badge ID) for all 10,000 employees.  As it is the key field on
so
many records in Peoplesoft, I know this will be a challenge.
Peoplesoft
has a delivered online function that will do the conversion to all the
necessary tables (even applicant tables) for a single emplid.   At the
moment my best plan is to look a the Peoplecode and try and embed it
in
an SQR program .  Has anyone done this, or perhaps accomplished the
conversion another way ?
 
 
Jenny Mckeon
Shands Healthcare, Info. Svcs.
Application Systems Analyst
(352) 265-0680, ext. 8-5232
internet:mckeon@shands.ufl.edu 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users