GPS_ADP_ACT_VW

(SQL View)
 Index Back

Current Actions

Contains all the ACTIONS that are possible to be applied to a JOB row. If the row is defined as SYSTEM_DATA then the user can only change the EFF_STATUS and the DESCR, DESCRSHORT. Customers can add their own Actions.

SELECT A.ACTION ,A.EFF_STATUS ,A.ACTION_DESCR ,A.ACTION_DESCRSHORT FROM PS_ACTION_TBL A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_ACTION_TBL B WHERE A.ACTION = B.ACTION AND B.EFFDT <= %CurrentDateIn) UNION SELECT C.ACTION ,C.EFF_STATUS ,C.ACTION_DESCR ,C.ACTION_DESCRSHORT FROM PS_GPS_ADP_ACT_TBL C WHERE C.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_ACTION_TBL D WHERE C.ACTION = D.ACTION AND D.EFFDT <= %CurrentDateIn)

  • Related Language Record: ACTIONVW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ACTION Character(3) VARCHAR2(3) NOT NULL Action
    2 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    3 ACTION_DESCR Character(50) VARCHAR2(50) NOT NULL Action Description
    4 ACTION_DESCRSHORT Character(30) VARCHAR2(30) NOT NULL Short Description for an Action