HD_ACTREASON_VW

(SQL View)
Index Back

Current Action/Reasons

Same to view SET_ACTN_REASON_VW. But AAF need use SETID as field name, so the value can be get from the AAF by policy page.

SELECT ACTION ,ACTION_REASON ,EFF_STATUS ,DESCR ,DESCRSHORT FROM PS_ACTN_REASON_VW

  • Related Language Record: ACTN_RSN_VW_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ACTION Character(3) VARCHAR2(3) NOT NULL Action

    Prompt Table: ACTION_TBL

    2 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description