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.
How to configure security to be able to query JOB for future dated hire rows
Mon, 04/13/2009 - 1:34pm
Trying to query the JOB record for future effective dated new hires. Query Manager by default joins in record EMPLMT_SRCH_QRY and future hires do not appear in this records. Is there something that has to be done to security types? Been researching this for over a month and haven't been able to find an answer. I know there's a way. Much appreciated.
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 |
Not sure this is a security issue. When you select the JOB record normally query will automatically place criteria to select the max(effdt) <= Current Date.
Have you modified that criteria?
Go to the Criteria Tab.
Click Edit button (along side the effective date field.
Change the 'Condition Type to 'effdt >'
In the Expression 2 Type Box make sure radio button 'Current Date' is selected
In the Effective Sequence Options Box you probably want 'First' (assuming you are looking for a 'HIR' action.
That should get you future dated HIR rows.
I think you need to take a look at your HRMS Security settings.
See if you have enabled the future effective dated rows for the Security Access Type.
Set Up HRMS -> Security -> Core Row Level Security -> Security Access Type -> Security Type Table
Also check the HRMS Security Install Settings where you configure the actions that trigger future effective dated security rows.
Set Up HRMS -> Security -> Core Row Level Security -> Security Installation Settings -> Security Install Settings
This is based on HRMS 8.9. Im not sure about other versions.
/Ashar
Post new comment