I am implementing a new Applicant Tracking System and we are looking to write hired applicants DIRECTLY to the Applicant table. I am wondering if anyone has done this and if anyone has suggestions for me????
I know about PA531 but I want to script the whole thing so that the users do not have to run a bunch of different processes. They will need to run something from the ATS (hosted system) - then I want to have something setup to just write the information to PA31 automatically.
Thanks
Shane
Unless you are either REALLY REALLY SMART or REALLY REALLY STUPID, *NEVER* write directly to Lawson's database tables. There are relationships and OBJIDs that get created as part of data insertion that you probably don't know about or understand completely, and writing directly into tables can hose the relationships to the rest of it's associated data.
I'd stronlgy recommend writing your script to accumulate the input data into a csv file and use jqsubmit to execute PA531 so the data validation takes place.