LM_LE_OPRID_VW(SQL View) |
Index Back |
---|---|
Search view for reports |
SELECT DISTINCT B.LM_LE_ID , B.LM_LE_LONG_NM FROM PS_LM_OPRID_LE_VW A , PS_LM_LE_VW B WHERE A.LM_LE_ID=B.LM_LE_ID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | LM_LE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Learning Environment ID - System Generated number |
2 | LM_LE_LONG_NM | Character(60) | VARCHAR2(60) NOT NULL | Learning Environment Long Name |