Hello,
My name is Jason. This is my first of probably many, many posts in regards to this subject.
I work in the Training & Development department with a company here in St. Louis. I have a lot of background when it comes to general IT, so I am the designated project leader for a IT-based Training Initiative.
We have an extremely large amount of management trainees out in the field. We need to track information on the trainees, trainers, classes, etc. that we have active in the system.
As of this point, all of the tracking comes in over fax or through the mail and our admin has to keystroke all of this into a rather primative Access database. This is not where we need to be when it comes to tracking. We never seem to be up to date on information, etc., so I am heading up a project that would enable our Field Trainers access and make changes to trainee training records.
Our parent company utilizes PeopleSoft HRMS for basic HR stuff, however they use Version 7.0 (or 7.01) that does not support the functionality we require.
To that end, I've determined to create an extranet database application using SQL Server and ASP to handle everything we need. However, PeopleSoft does contain a lot of information that is useful and I would like to import data from the PeopleSoft DB our parent company uses into the SQL Server DB.
If there's anyone out there who has knowledge of or experience with this kind of thing, would you please give me an overview of what needs to happen to make this work out?
It doesn't need to be all that detailed, but just a list of steps that need to happen in this kind of project.
Thank you,
Jason Portell
St. Louis, MO