Thursday, November 26, 2009

Special Actions


There are certain action in HRMS which can make the Inactive rows in the Job data active. Identification of these Actions will be helpful while development phase. Below is the query to identify those actions.


 

SELECT

A.ACTION

, A.ACTION_DESCR

FROM

PS_ACTION_TBL A

, PS_ACTION_STAT_TBL B

WHERE A.ACTION=B.ACTION

AND A.EFF_STATUS='A'

AND A.EFFDT= (SELECT
MAX (C.EFFDT)

FROM PS_ACTION_TBL C
WHERE A.ACTION=C.ACTION)

AND B.HR_STATUS_VALID='I'

The setting is done under
Setup HRMS
Product related
Workforce Administration
Actions

Here under the Organizational Relationship scroll, there is field
'Valid if Previous HR Status is: '. Providing Inactive will make
the action capable of
changing the inactive HR status active

3 comments:

  1. Awesome post. Do you mind if I ask what your source is for this information?

    ReplyDelete
  2. This is from the Project level experience

    ReplyDelete
  3. AnonymousJuly 18, 2011

    Pleasant Post. This post helped me in my university assignment. Thanks Alot

    ReplyDelete

Total Pageviews

Copyright © Tech & Management Notes