CAMP_MTG_SEL_VW

(SQL View)
 Index Back

Campus Mtg Selections View

CAMP_MTG_SEL_VW is used to find all attendees for a particular event or meeting. It is used in the Attendee Summary panel.

select a.campus_event_nbr ,b.event_mtg_nbr ,a.campus_event_atnd ,a.name ,a.city ,a.state ,a.country ,a.descr ,b.evnt_atnd_stat from PS_CAMPUS_EVNT_ATT a, ps_campus_mtg_sel b where a.campus_event_nbr = b.campus_event_nbr and a.campus_event_atnd = b.campus_event_atnd

  • Related Language Record: CMPMTG_SELVW_LN

    • # 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

    Prompt Table: EVENT_MTG

    3 CAMPUS_EVENT_ATND Character(5) VARCHAR2(5) NOT NULL Campus Event Attendee

    Prompt Table: CAMPUS_EVNT_ATT

    4 NAME Character(50) VARCHAR2(50) NOT NULL Name
    5 CITY Character(30) VARCHAR2(30) NOT NULL City
    6 STATE Character(6) VARCHAR2(6) NOT NULL State
    7 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 EVNT_ATND_STAT Character(1) VARCHAR2(1) NOT NULL Event Meeting Attendee Status
    A=Attended
    I=Invited
    N=Will Not Attend
    Y=Will Attend