How quickly do you need to have this file?
One file per employee?
One file per day that shows all new employees added that day?
If you can do this once daily, I would write an SQR that is run on a daily
basis, via a batch scheduler process, and it would extract the daily
information. The SQR can write the extracted data to a flat file, or to a
report.... your decision.
If you need this data immediately after the employee is added in PeopleSoft,
then you can write PeopleCode and attach the code to the 'SavePostChg' event on
the record. The PeopleCode on this event can write/append to a flat file or it
could initiate a SQR process passing the EMPLID as a parameter.
Hope this helps a little.
Nadav Karpenkop <nadavk@BUSINESSLAYERS.COM> on 07/19/2000 05:45:30 AM
Please respond to sqr-users@list.iex.net
To: SQR-USERS@list.iex.net
cc: (bcc: Rick Creel/IT/Aon Consulting)
Subject: Integrate to PeopleSoft [.]
Hi
I want to integrate to PeopleSoft , so while I'm creating a new employee in
the PeopleSoft and the operation
succeeded I want to write the new employee's details ( First Name , Last
Name , Department )
who was created to a file(from this point I know what to do).
I'm trying to catch the new employee event In the PeopleSoft and while it
happens and
succeeds ,I what to get the new employee details.
My question is : Should I do it from the PeopleCode or With SQR or maybe
both.
What is the right way to do it,I'll be more then happy to hear.
Lots & Lots of Thanks
Nadav
Title: Integrate to PeopleSoft
Hi
I want to integrate to PeopleSoft , so while I'm creating a new employee in the PeopleSoft and the operation
succeeded I want to write the new employee's details ( First Name , Last Name , Department )
who was created to a file(from this point I know what to do).
I'm trying to catch the new employee event In the PeopleSoft and while it happens and
succeeds ,I what to get the new employee details.
My question is : Should I do it from the PeopleCode or With SQR or maybe both.
What is the right way to do it,I'll be more then happy to hear.
Lots & Lots of Thanks
Nadav