AV_IACSTATVWLNG

(SQL View)
 Index Back

Intv Action status codes.

Initiative Action Status Codes

SELECT A.ACTN_STAT_CD ,A.EFFDT , B.LANGUAGE_CD ,B. DESCRSHORT , B.DESCR FROM PS_AV_ACTN_STA_TBL A , PS_AV_ACTN_STA_LNG B WHERE A.ACTN_STAT_CD = B.ACTN_STAT_CD AND A.EFFDT = B.EFFDT AND A.INTV_ACTN_FLG='Y'

  • Related Language Record for AV_I_AC_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