CAMP_ATT_MTG_VW

(SQL View)
 Index Back

Campus Attendee Mtgs view

CAMP_ATT_MTG_VW is used to find all meetings within an event that a persons is scheduled to attend.

select b.campus_event_atnd ,b.campus_event_nbr ,b.event_mtg_nbr ,a.campus_mtg_loc ,a.descr ,a.meeting_dt ,a.meeting_time_start ,a.Meeting_time_end ,a.Ext_org_id ,a.facility_id ,b.evnt_atnd_stat from PS_EVENT_MTG a, ps_campus_mtg_sel b where b.campus_event_nbr = a.campus_event_nbr and b.event_mtg_nbr = a.event_mtg_nbr

  • Related Language Record: CMP_AT_MTGVW_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CAMPUS_EVENT_ATND Character(5) VARCHAR2(5) NOT NULL Campus Event Attendee

    Prompt Table: CAMPUS_EVNT_ATT

    2 CAMPUS_EVENT_NBR Character(9) VARCHAR2(9) NOT NULL Event ID

    Prompt Table: CAMPUS_EVENT

    3 EVENT_MTG_NBR Number(4,0) SMALLINT NOT NULL Event Meeting Nbr

    Prompt Table: EVENT_MTG

    4 CAMPUS_MTG_LOC Character(1) VARCHAR2(1) NOT NULL Campus Meeting Location
    C=Campus Facility
    E=External Org Facility
    O=Other Facility
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 MEETING_DT Date(10) DATE Meeting Date
    7 MEETING_TIME_START Time(15) TIMESTAMP Meeting Start Time
    8 MEETING_TIME_END Time(15) TIMESTAMP Meeting End Time
    9 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    10 FACILITY_ID Character(10) VARCHAR2(10) NOT NULL Facility ID
    11 EVNT_ATND_STAT Character(1) VARCHAR2(1) NOT NULL Event Meeting Attendee Status
    A=Attended
    I=Invited
    N=Will Not Attend
    Y=Will Attend