AVPRPSVWLNG

(SQL View)
 Index Back

Purpose Code view

Contains all the assignment purposes in the system. Where asgn_cd_flg=Y.

SELECT A.PURPOSE_CD ,A.LANGUAGE_CD , A.DESCR , A.DESCRSHORT FROM PS_AV_PRPS_LNG A WHERE A.EFFDT IN ( SELECT MAX(A1.EFFDT) FROM PS_AV_PRPS_LNG A1 WHERE A1.PURPOSE_CD = A.PURPOSE_CD)

  • Related Language Record for AV_PRPS_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PURPOSE_CD Character(3) VARCHAR2(3) NOT NULL Role
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: AV_PRPS_TBL.DESCR