EVT_CLASS_LNGVW

(SQL View)
 Index Back

Prompt View for Event Class

EVT_CLASS_LNGVW is the language record related to EVT_CLASS_VW. This is a prompt view for the event class for Passive Events.

SELECT A.EVENT_CLASS , A.LANGUAGE_CD , A.DESCR FROM PS_BAS_ETCLASS_LNG A , PS_BAS_EVT_CLASS B WHERE A.EVENT_CLASS=B.EVENT_CLASS AND B.EFF_STATUS = 'A' AND B.EVENT_CLASS_USE <> 'O'

  • Related Language Record for EVT_CLASS_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EVENT_CLASS Character(3) VARCHAR2(3) NOT NULL Event Classification
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description