LM_ORG_TU_LVW

(SQL View)
Index Back

ORG/TU view

View of TUs within an organization

SELECT DISTINCT C.LM_ORGANIZATION_ID , A.LM_TU_POOL_ID , D.LANGUAGE_CD , D.LM_TU_POOL_DESCR FROM PS_LM_TU_POOL_TBL A , PS_LM_MOP_OWNR_TBL B ,PS_LM_ORGANIZATION C , PS_LM_TU_POOL_LANG D WHERE A.LM_TU_POOL_ID = B.LM_MOP_ID AND B.LM_MOP_OWNER_ID = C.LM_ORGANIZATION_ID AND B.LM_MOP_TYPE = 'TUP' AND B.LM_MOP_OWNER_TYPE ='ORG' AND A.LM_TU_POOL_ID = D.LM_TU_POOL_ID

  • Related Language Record for LM_ORG_TU_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID
    2 LM_TU_POOL_ID Number(10,0) DECIMAL(10) NOT NULL Training Unit Pool No. Unique key for Training Unit Pool Record.
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 LM_TU_POOL_DESCR Character(40) VARCHAR2(40) NOT NULL Training Unit Pool Description.