LM_WEB_MTG_VW

(SQL View)
 Index Back

Meeting Types View


SELECT A.HRS_VENDOR_ID , A.HRS_VERSION , A.LM_LELW_MTG_TYP_ID , A.LM_LELW_MTG_TYP_NM FROM PS_LM_WEB_MTG_TYP A WHERE A.HRS_VERSION IN ( SELECT MAX(B.HRS_VERSION) FROM PS_LM_WEB_MTG_TYP B WHERE A.HRS_VENDOR_ID = B.HRS_VENDOR_ID)

  • Parent record: LM_VENDOR_EXTD

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_VENDOR_ID Number(15,0) DECIMAL(15) NOT NULL Integration Vendor ID

    Prompt Table: LM_WEB_MTG_VW

    2 HRS_VERSION Number(15,0) DECIMAL(15) NOT NULL used as version for numerous integration objects
    3 LM_LELW_MTG_TYP_ID Number(10,0) DECIMAL(10) NOT NULL Meeting Type ID

    Prompt Table: LM_WEB_MTG_VW

    4 LM_LELW_MTG_TYP_NM Character(200) VARCHAR2(200) NOT NULL Meeting Type Name

    Prompt Table: LM_WEB_MTG_VW
    Set Control Field: LM_LELW_MTG_TYP_NM