User login
Sponsored links
Recent blog posts
- Unwanted Save Warnings in Display Only Pages
- Breadcrumb SQL to find the Navigation path for the component in the PIA
- Application Designer Index naming convention
- How to create Trigger in DB2
- Emplid increment automatically
- How can we romove multiple duplicate rows of data printing under each Print command in SQR Program?
- How can we call Dynamic Calling section in Peoplesoft Application Engine program?
- How can we write multiple SQL Commands/Statements under one Action by using one function?
- Peoplesoft BU VS Record Groups VS Record Group Controls VS Control Table VS Table set Sharing VS Table SETID?
- Difference between Custom and Customised objects in Peoplesoft?
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
Tue, 02/17/2009 - 11:11am
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.
Bookmark/Search this post with
Unanswered Forum Posts
| Title | Under | Posted on |
|---|---|---|
| MD5 - SHA checksum of a file. | PeopleSoft Technical | 02/07/2012 - 5:29am |
| nVision Tabular Report through PIA with prompts | PeopleSoft Technical | 02/02/2012 - 10:07pm |
| Can we create an AE to mass update Position - Jobcode data? | PeopleSoft Technical | 01/18/2012 - 3:11am |
| Pay Components on job data can be defaulted and setup based on the rules? | PeopleSoft Functional | 01/05/2012 - 4:58am |
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
I do not recommend inserting data into tables manually?
why don't you use CI instead?
Agree with Ashar.
Use CI for loading data into JOB record.
Regards,
Ganesh Pawar
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.
Post new comment