You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Inserting into job data manually

4 replies [Last post]
Guest's picture
Guest

Could you provide me with a list of things to keep in mind when manually inserting to job data like PS_JOB?

Also, what are all the tables affected when manually inserting to job data?

Hope you could help me. Thanks.

Lepa's picture
User offline. Last seen 1 year 24 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Inserting into job data manually

I'm not an HR person but why not turn SQL trace on before logging in to your PeopleSoft application? After you do that, navigate to the job data component and save a new record. You can then grab the trace file and get all needed insert statement.

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Ashar's picture
User offline. Last seen 4 years 5 weeks ago. Offline
Joined: 03/26/2008
Posts: 227
Re: Inserting into job data manually

I do not recommend inserting data into tables manually?
why don't you use CI instead?

gpawar.ps's picture
User offline. Last seen 9 years 48 weeks ago. Offline
Joined: 02/06/2009
Posts: 10
Re: Inserting into job data manually

Agree with Ashar.

Use CI for loading data into JOB record.

Regards,
Ganesh Pawar

Guest's picture
Guest (not verified)
Re: Inserting into job data manually

You will need to populate at least these: JOB, JOB_JR and COMPENSATION. That is off the top of my head. We have an SQR that gives annual pay raises that does exactly what you are trying to do. There are a *LOT* of fields in PS_JOB. In our case since we were updating COMPRATE we had to update several other fields (monthly and annual rates etc) at the same time, as well as effdt, effseq etc.