CCUSERTYPEVWLNG

(SQL View)
 Index Back

opralias Type view without non

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

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

  • Related Language Record for CC_USERTYPEVW

    • # 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
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code