CC_USERTYPEVW

(SQL View)
 Index Back

opralias Type view without non

This view is based on PSUSERTYPEVW excluding the "non" value

SELECT A.OPRALIASTYPE , A.DESCR FROM PSOPRALIASTYPE A , PSUSERTYPEON B WHERE A.OPRALIASTYPE = B.OPRALIASTYPE AND A.OPRALIASTYPE = 'EMP'

  • Related Language Record: CCUSERTYPEVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRALIASTYPE Character(3) VARCHAR2(3) NOT NULL User ID Type
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description