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

2 replies [Last post]
Guest's picture
Guest

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.

oddsnends's picture
User offline. Last seen 9 years 7 weeks ago. Offline
Joined: 03/28/2008
Posts: 16
Re: How to configure security to be able to query JOB for ...

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.

Ashar's picture
User offline. Last seen 2 years 41 weeks ago. Offline
Joined: 03/26/2008
Posts: 227
Re: How to configure security to be able to query JOB for ...

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