LM_LELW_MSGSS_V

(SQL View)
 Index Back

Message Log Info View


SELECT E.HRS_VENDOR_ID , A.LM_SES_ID , B.LM_CI_ID , B.LM_ACT_ID , B.LM_LC_ID , A.LM_LELW_BAT_STATUS , A.LM_LELW_ACT_SES , E.HRS_VENDOR_SNAME , E.HRS_VENDOR_LNAME , B.LM_START_DTTM , B.LM_END_DTTM , B.TIMEZONE , B.LM_ACT_CD , B.LM_START_DT , B.LM_END_DT , A.LM_LELW_ERROR_ID , B.LM_LELW_VND_MTG_ID FROM PS_LM_LELW_SES_BAT A , PS_LM_LELW_SCACHE B , PS_HRS_VENDOR E WHERE A.LM_SES_ID=B.LM_SES_ID AND B.LM_LELW_VNDR_ID = E.HRS_VENDOR_ID AND E.HRS_VERSION = ( SELECT MAX(HRS_VERSION) FROM PS_HRS_VENDOR Z WHERE Z.HRS_VENDOR_ID = E.HRS_VENDOR_ID)

  • Related Language Record: LM_LELW_MSGSS_L

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_LELW_VNDR_ID Number(15,0) DECIMAL(15) NOT NULL Vendor ID
    2 LM_SES_ID Number(10,0) DECIMAL(10) NOT NULL Session ID
    3 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
    4 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    5 LM_LC_ID Number(10,0) DECIMAL(10) NOT NULL Learning Component ID - Blended Learning
    6 LM_LELW_BAT_STATUS Character(3) VARCHAR2(3) NOT NULL Batch Status
    10=Pending
    20=Error
    30=OIF Error
    40=Succeeded
    7 LM_LELW_ACT_SES Character(3) VARCHAR2(3) NOT NULL Action
    10=Create
    20=Edit
    30=Remove
    8 LM_LELW_SHRT_NM Character(10) VARCHAR2(10) NOT NULL Short Name
    9 LM_LELW_LONG_NM Character(244) VARCHAR2(244) NOT NULL Long Name
    10 LM_START_DTTM DateTime(26) TIMESTAMP Start Time
    11 LM_END_DTTM DateTime(26) TIMESTAMP End Time
    12 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
    13 LM_ACT_CD Character(30) VARCHAR2(30) NOT NULL Activity Code
    14 LM_START_DT Date(10) DATE Start Date
    15 LM_END_DT Date(10) DATE End Date
    16 LM_LELW_ERROR_ID Number(10,0) DECIMAL(10) NOT NULL Error ID
    17 LM_LELW_VND_MTG_ID Number(10,0) DECIMAL(10) NOT NULL Vendor Meeting ID