AV_PRPS_VW

(SQL View)
 Index Back

Purpose Code view

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

SELECT PURPOSE_CD , A.DESCR , A.DESCRSHORT , A.STAFF_FLAG , A.UNIT_FLAG , A.VOLUNTEER_FLAG , A.PURPOSE_TYPE FROM PS_AV_PRPS_TBL A WHERE A.EFFDT IN ( SELECT MAX(A1.EFFDT) FROM PS_AV_PRPS_TBL A1 WHERE A1.PURPOSE_CD = A.PURPOSE_CD) AND EFF_STATUS='A'

  • Related Language Record: AVPRPSVWLNG

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

    Default Value: AV_PRPS_TBL.DESCR

    4 STAFF_FLAG Character(1) VARCHAR2(1) NOT NULL Staff

    Y/N Table Edit

    Default Value: N

    5 UNIT_FLAG Character(1) VARCHAR2(1) NOT NULL Unit

    Y/N Table Edit

    Default Value: N

    6 VOLUNTEER_FLAG Character(1) VARCHAR2(1) NOT NULL Volunteer

    Y/N Table Edit

    Default Value: N

    7 PURPOSE_TYPE Character(3) VARCHAR2(3) NOT NULL Purpose Type
    ADM=Administrator Code
    ASG=Assignment Code