LM_LRQMGR_CI_VW

(SQL View)
 Index Back

Manager View of requests

Manager View of requests for catalog item only

SELECT C.OPRID , C.LM_MANAGER_ID , C.LM_PERSON_ID , A.LM_LRQ_ID , A.LM_CI_ID , D.LM_CS_LONG_NM , 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_MGR_SRCH_VW C , PS_LM_CI_VW D , 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 B.LM_PERSON_ID = C.LM_PERSON_ID AND A.LM_CI_ID = D.LM_CI_ID AND B.LM_PERSON_ID = E.LM_PERSON_ID AND E.LM_ACTIVE='Y'

  • Related Language Record: LM_LRQMGR_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 LM_MANAGER_ID Number(15,0) DECIMAL(15) NOT NULL Manager ID
    3 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    4 LM_LRQ_ID Number(10,0) DECIMAL(10) NOT NULL New field for ELM 9.0, stores unique identifier for a single learning request.
    5 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
    6 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object
    7 LM_LRQ_STATUS Character(1) VARCHAR2(1) NOT NULL New Field. Uppercase. Stores current status of learning request.
    1=Requested
    2=Inactive
    3=Offered
    8 LM_START_DT Date(10) DATE Start Date
    9 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
    10 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    11 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field
    12 LM_STTS_CHANGE_DT Date(10) DATE Status Chage Date