LM_OPRIDLM_LE_IDLM_FILTER_NAMELANGUAGE_CDLM_MGR_FLT_LVW(SQL View) |
Index Back |
|---|---|
Manager Filter ViewManager Filter View |
| SELECT A.LM_OPRID , A.LM_LE_ID , A.LM_FILTER_NAME , B.LANGUAGE_CD , B.LM_FILTER_DESCR , B.LM_SHORT_DESCR FROM PS_LM_MGR_FLT_TBL A , PS_LM_FILTER_LNG B WHERE A.LM_LE_ID = B.LM_LE_ID AND A.LM_FILTER_NAME = B.LM_FILTER_NAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_OPRID |
Character(30) | VARCHAR2(30) NOT NULL | Operator ID Used for Announcements |
| 2 | LM_LE_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Learning Environment ID - System Generated number |
| 3 | LM_FILTER_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Filter Name |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | LM_FILTER_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Description |
| 6 | LM_SHORT_DESCR | Character(15) | VARCHAR2(15) NOT NULL | Short Description |