ACTN_REASON_VW

(SQL View)
 Index Back

Current Action/Reasons

ACTN_REASON_TBL is an edit table. Use it to record combinations of action codes and the reason codes that are valid for an action. For example, two valid reasons for a termination action might be attendance and misconduct.

SELECT ACT.ACTION ,ACT.ACTION_REASON ,ACT.EFF_STATUS ,ACT.DESCR ,ACT.DESCRSHORT FROM PS_ACTN_REASON_TBL ACT WHERE %EffdtCheck(ACTN_REASON_TBL, ACT, %CurrentDateIn)

  • Related Language Record: ACTN_RSN_VW_LNG

  • Parent Record Of ACTN_RSN_COMM ACT_RSN_TBL_AUS ACT_RSN_TBL_GER ACT_RSN_TBL_MEX

    • # 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