LM_LQMGNL_CI_VW

(SQL View)
Index Back

Manager View of requests

Manager View of requests for catalog item only and no learners

SELECT C.OPRID , 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 , ' ' , A.LM_SEAT_REQ , A.LM_SEAT_AVL , A.LM_STTS_CHANGE_DT FROM PS_LM_LRN_REQ A , PS_LM_PERSON_OPRID C , PS_LM_CI_VW D WHERE A.LM_LRQ_STATUS IN ('1', '3') AND A.LM_REQUESTOR_ID = C.LM_PERSON_ID AND A.LM_CI_ID = D.LM_CI_ID AND NOT EXISTS( SELECT B.LM_LRQ_ID FROM PS_LM_LRN_REQ_LNR B WHERE B.LM_LRQ_ID = A.LM_LRQ_ID)

  • Related Language Record: LM_LRQMGRCI_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_LRQ_ID Number(10,0) DECIMAL(10) NOT NULL New field for ELM 9.0, stores unique identifier for a single learning request.
    4 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
    5 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object
    6 LM_LRQ_STATUS Character(1) VARCHAR2(1) NOT NULL New Field. Uppercase. Stores current status of learning request.
    1=Requested
    2=Inactive
    3=Offered
    7 LM_START_DT Date(10) DATE Start Date
    8 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
    9 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    10 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field
    11 LM_SEAT_REQ Number(10,0) DECIMAL(10) NOT NULL Number of Seat Request
    12 LM_SEAT_AVL Number(10,0) DECIMAL(10) NOT NULL Number of Seat Request
    13 LM_STTS_CHANGE_DT Date(10) DATE Status Chage Date