LM_LRQMG_CT_VW2

(SQL View)
 Index Back

Manager View of requests

Manager View of requests for categories only

SELECT B.LM_PERSON_ID , A.LM_LRQ_ID , A.LM_CATG_ID , A.LM_TITLE , A.LM_LRQ_STATUS , A.LM_FROM_DT , A.LM_LRQ_METHOD , A.LM_ACT_ID , E.LM_NAME_DISPLAY , A.LM_STTS_CHANGE_DT FROM PS_LM_LRN_REQ A , PS_LM_LRN_REQ_LNR B , PS_LM_PERS_DTL_VW E WHERE A.LM_LRQ_ID = B.LM_LRQ_ID AND B.LM_LRQ_LRNR_STTS = '1' AND A.LM_LRQ_STATUS IN ('1', '3') AND A.LM_CI_ID = 0 AND B.LM_PERSON_ID = E.LM_PERSON_ID

  • Related Language Record: LM_LRQMGRT_LVW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    2 LM_LRQ_ID Number(10,0) DECIMAL(10) NOT NULL New field for ELM 9.0, stores unique identifier for a single learning request.
    3 LM_CATG_ID Number(10,0) DECIMAL(10) NOT NULL Category ID - System generated number used to uniquely identify a Category.
    4 LM_TITLE Character(30) VARCHAR2(30) NOT NULL Field to store title of an object
    5 LM_LRQ_STATUS Character(1) VARCHAR2(1) NOT NULL New Field. Uppercase. Stores current status of learning request.
    1=Requested
    2=Inactive
    3=Offered
    6 LM_START_DT Date(10) DATE Start Date
    7 LM_LRQ_METHOD Character(1) VARCHAR2(1) NOT NULL Method field in learning request o know if learner prefers self-paced or scheduled learning.
    1=No Preference
    2=Online
    3=Classroom
    4=Live Webcast
    8 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    9 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field
    10 LM_STTS_CHANGE_DT Date(10) DATE Status Chage Date