LM_LQMGNL_CI_VW(SQL View) |
Index Back |
---|---|
Manager View of requestsManager 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) |
# | 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 |