GPMX_ACTN_RSLNG

(SQL View)
 Index Back

GPMX_ACTN_REASN_VW

Action Reason View Mexico This view is used to retrieve only Termination Values for Termination Reason

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

  • Related Language Record for GPMX_ACTN_RSN_V

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 ACTION Character(3) VARCHAR2(3) NOT NULL Action
    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