LM_MOP_OWNER_IDLM_MOP_OWNER_TYPELEV=Learning Environment
ORG=Organization
PER=Person
LM_TU_POOL_IDLANGUAGE_CDLM_TU_OWR_LG_VW(SQL View) |
Index Back |
|---|---|
Lang rec for LM_TU_OWNER_VWRelated lang record for LM_TU_OWNER_VW |
| SELECT B.LM_MOP_OWNER_ID , B.LM_MOP_OWNER_TYPE , C.LM_TU_POOL_ID , A.LANGUAGE_CD , C.LM_TU_POOL_NAME , A.LM_TU_POOL_DESCR FROM PS_LM_TU_POOL_LANG A , PS_LM_TU_POOL_TBL C , PS_LM_MOP_OWNR_TBL B WHERE A.LM_TU_POOL_ID = C.LM_TU_POOL_ID AND A.LM_TU_POOL_ID = B.LM_MOP_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_MOP_OWNER_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Method of Payment Owner. Owner could be Organization, Person, Learning Environment etc. |
| 2 | LM_MOP_OWNER_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Method of Payment Owner Type. In 8.9, it could be organization, LE, Person etc.
LEV=Learning Environment ORG=Organization PER=Person |
| 3 | LM_TU_POOL_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Training Unit Pool No. Unique key for Training Unit Pool Record. |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | LM_TU_POOL_NAME | Character(20) | VARCHAR2(20) NOT NULL | Training Unit Pool |
| 6 | LM_TU_POOL_DESCR | Character(40) | VARCHAR2(40) NOT NULL | Training Unit Pool Description. |