EVENT_LOC_VW

(SQL View)
 Index Back

Event Location View

This View is used to display the location of the primary meeting on the CAMPUS_EVENT panel.

select a.campus_event_nbr, a.event_mtg_nbr, a.descr, a.campus_mtg_loc from PS_EVENT_MTG a

  • Related Language Record: EVENT_LOC_VWLNG

  • Parent record: CAMPUS_MTG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CAMPUS_EVENT_NBR Character(9) VARCHAR2(9) NOT NULL Event ID

    Prompt Table: CAMPUS_EVENT

    2 EVENT_MTG_NBR Number(4,0) SMALLINT NOT NULL Event Meeting Nbr
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 CAMPUS_MTG_LOC Character(1) VARCHAR2(1) NOT NULL Campus Meeting Location
    C=Campus Facility
    E=External Org Facility
    O=Other Facility