OPRIDLM_PERSON_IDLM_LRQ_ID1=Requested
2=Inactive
3=Offered
1=No Preference
2=Online
3=Classroom
4=Live Webcast
LM_LRQLRN_CT_VW(SQL View) |
Index Back |
|---|---|
Learner View of requestsLearner View of requests for categories only |
| SELECT C.OPRID , C.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 , A.LM_REQUESTOR_ID , A.LM_STTS_CHANGE_DT FROM PS_LM_LRN_REQ A , PS_LM_LRN_REQ_LNR B , PS_LM_PERSON_OPRID C 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 = 0 |
| # | 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_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | ELM Person 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_CATG_ID | Number(10,0) | DECIMAL(10) NOT NULL | Category ID - System generated number used to uniquely identify a Category. |
| 5 | LM_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Field to store title 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_REQUESTOR_ID | Number(15,0) | DECIMAL(15) NOT NULL | Requestor |
| 11 | LM_STTS_CHANGE_DT | Date(10) | DATE | Status Chage Date |