AV_IACTNTPVWLNG

(SQL View)
 Index Back

Initiative Action type codes

Initiative Action type codes. Where intv_actn_flg='Y'

SELECT A.ACTN_TYPE_CD , A.EFFDT , A.LANGUAGE_CD , A.DESCRSHORT , A.DESCR FROM PS_AV_ACTN_TYP_LNG A , PS_AV_ACTN_TYP_TBL B WHERE A.ACTN_TYPE_CD = B.ACTN_TYPE_CD AND A.EFFDT = B.EFFDT AND B.INTV_ACTN_FLG='Y'

  • Related Language Record for AV_I_ACTN_TP_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ACTN_TYPE_CD Character(6) VARCHAR2(6) NOT NULL Action Type Code
    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_TYP_TBL.DESCR

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