LM_LRQ_CDTL_LNG

(SQL View)
 Index Back

Learning Request view

This view returns details of learning requests that have categories specified.

SELECT A.LM_LRQ_ID , D.LANGUAGE_CD , D.LM_TITLE , C.LM_CS_LONG_NM , D.LM_LRQ_DESCR , D.LM_LRQ_COMMENTS , D.LM_GEN_FLD1 , D.LM_GEN_FLD2 , D.LM_GEN_FLD3 , D.LM_GEN_FLD4 , D.LM_GEN_FLD5 FROM PS_LM_LRN_REQ A , PS_LM_CATG_VW_LNG C , PS_LM_LRN_REQ_LANG D WHERE A.LM_CATG_ID = C.LM_CATG_ID AND A.LM_LRQ_STATUS IN ('1', '3') AND C.LANGUAGE_CD = D.LANGUAGE_CD AND A.LM_LRQ_ID = D.LM_LRQ_ID UNION ALL SELECT A1.LM_LRQ_ID , D1.LANGUAGE_CD , D1.LM_TITLE , C1.LM_CS_LONG_NM , D1.LM_LRQ_DESCR , D1.LM_LRQ_COMMENTS , D1.LM_GEN_FLD1 , D1.LM_GEN_FLD2 , D1.LM_GEN_FLD3 , D1.LM_GEN_FLD4 , D1.LM_GEN_FLD5 FROM PS_LM_LRN_REQ A1 , PS_LM_CATG_VW C1 , PS_LM_LRN_REQ_LANG D1 WHERE A1.LM_CATG_ID = C1.LM_CATG_ID AND A1.LM_LRQ_STATUS IN ('1', '3') AND A1.LM_LRQ_ID = D1.LM_LRQ_ID AND NOT EXISTS ( SELECT 'X' FROM PS_LM_CATG_VW_LNG H WHERE H.LM_CATG_ID = A1.LM_CATG_ID AND H.LANGUAGE_CD = D1.LANGUAGE_CD) UNION ALL SELECT A2.LM_LRQ_ID , C2.LANGUAGE_CD , A2.LM_TITLE , C2.LM_CS_LONG_NM ,A2.LM_LRQ_DESCR , A2.LM_LRQ_COMMENTS , A2.LM_GEN_FLD1 , A2.LM_GEN_FLD2 , A2.LM_GEN_FLD3 , A2.LM_GEN_FLD4 , A2.LM_GEN_FLD5 FROM PS_LM_LRN_REQ A2 , PS_LM_CATG_VW_LNG C2 WHERE A2.LM_CATG_ID = C2.LM_CATG_ID AND A2.LM_LRQ_STATUS IN ('1', '3') AND NOT EXISTS ( SELECT 'X' FROM PS_LM_LRN_REQ_LANG G WHERE G.LM_LRQ_ID = A2.LM_LRQ_ID AND G.LANGUAGE_CD = C2.LANGUAGE_CD)

  • Related Language Record for LM_LRQ_CTDTL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_LRQ_ID Number(10,0) DECIMAL(10) NOT NULL New field for ELM 9.0, stores unique identifier for a single learning request.
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 LM_TITLE Character(30) VARCHAR2(30) NOT NULL Field to store title of an object
    4 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object
    5 LM_LRQ_DESCR Character(254) VARCHAR2(254) NOT NULL New Field. Mixed case. Stores description of requested learning (as entered by requestor).
    6 LM_LRQ_COMMENTS Long Character CLOB New Field. Allows free-text entry of comments related to a request.
    7 LM_GEN_FLD1 Character(30) VARCHAR2(30) NOT NULL New field. Storage for generic field data.
    8 LM_GEN_FLD2 Character(30) VARCHAR2(30) NOT NULL New field. Storage for generic field data.
    9 LM_GEN_FLD3 Character(30) VARCHAR2(30) NOT NULL New field. Storage for generic field data.
    10 LM_GEN_FLD4 Character(30) VARCHAR2(30) NOT NULL New field. Storage for generic field data.
    11 LM_GEN_FLD5 Character(30) VARCHAR2(30) NOT NULL New field. Storage for generic field data.