AVPRPSUNTVWLNG

(SQL View)
 Index Back

Asg Purpose Unit View

This view limits is a prompt box view that only displays assignment purposes that are setup for units.

SELECT A.PURPOSE_CD , A.EFFDT , A.LANGUAGE_CD , A.DESCR FROM PS_AV_PRPS_LNG A ,PS_AV_PRPS_TBL B WHERE B.UNIT_FLAG = 'Y' AND B.PURPOSE_TYPE = 'ASG' AND A.PURPOSE_CD=B.PURPOSE_CD AND A.EFFDT=B.EFFDT

  • Related Language Record for AV_PRPS_UNT_VW

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