AVACTNSTATVWLNG

(SQL View)
 Index Back

Action status view

Used to eliminate the complete code. Used as a prompt for the mass assignments panel.

SELECT ACTN_STAT_CD , EFFDT , LANGUAGE_CD , DESCRSHORT , DESCR FROM PS_AV_ACTN_STA_LNG WHERE ACTN_STAT_CD <> 'CMP'

  • Related Language Record for AV_ACTN_STAT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ACTN_STAT_CD Character(3) VARCHAR2(3) NOT NULL Action Status
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: AV_ACTN_STA_TBL.DESCR

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description