MTG_EVNT_TYP_LN

(SQL View)
 Index Back

Meeting Event Type View

MTG_EVNT_TYP_VW is a view of the Event Type Table, it has all the event types except for Courses. This is used as a prompt on the Campus Event table This is the related language table for MTG_EVNT_TYP_VW.

SELECT A.CAMPUS_EVENT_TYPE , A1.LANGUAGE_CD , A.EFFDT , A1.DESCR FROM PS_EVENT_TYPE_TBL A , PS_EVENT_TYPE_LANG A1 , PS_INSTALLATION_CC B WHERE A.CAMPUS_EVENT_TYPE <> B.EVENT_TYPE_CRS AND A.CAMPUS_EVENT_TYPE = A1.CAMPUS_EVENT_TYPE AND A.EFFDT = A1.EFFDT

  • Related Language Record for MTG_EVNT_TYP_VW

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

    Default Value: %date

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description