GPAR_ACT_RS_LNG

(SQL View)
Index Back

Action Reason Related Language

Action Reason Related Language Record This view is used to retrieve only Termination Values for Termination Reason

SELECT ACTION , EFFDT , LANGUAGE_CD , ACTION_DESCR , ACTION_DESCRSHORT FROM PS_ACTION_LNG A WHERE A.ACTION IN ( SELECT ACTION FROM PS_GPAR_ACT_RSN_VW)

  • Related Language Record for GPAR_ACT_RSN_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ACTION Character(3) VARCHAR2(3) NOT NULL Action
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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