ADM_WEB_COMM_VW

(SQL View)
 Index Back

Comm Event View - Web Prospect

This view displays all of the Comm Keys within an Event ID

SELECT a.institution , a.event_3cs_id , a.comm_key , b.descr FROM PS_EVNT_COMM_TBL a , ps_comm_spdkey_tbl b WHERE a.institution = b.institution AND a.comm_key = b.comm_key AND a.effdt = ( SELECT MAX(c.effdt) FROM PS_EVNT_COMM_TBL c WHERE c.institution = a.institution AND c.event_3cs_id = a.event_3cs_id AND c.comm_key = a.comm_key AND c.effdt <= %CurrentDateIn)

  • Related Language Record: ADMWEBCOMMVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    2 EVENT_3CS_ID Character(10) VARCHAR2(10) NOT NULL 3Cs event ID
    3 COMM_KEY Character(8) VARCHAR2(8) NOT NULL Communication Speed Key
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description