LM_TU_ORG_VW

(SQL View)
 Index Back

TUs owned by Org view

TUs owned by Org view

SELECT A.LM_TU_POOL_ID , C.LM_ORGANIZATION_ID , A.LM_TU_POOL_NAME , C.LM_ORG_DESCR , A.LM_TU_POOL_DESCR , A.CURRENCY_CD , A.LM_CHARTFLD_TYPE , A.LM_CHARTFLD_VAL , A.LM_OWNER_ID , %subrec(LM_ROWAUDIT_SBR,A) FROM PS_LM_TU_POOL_TBL A , PS_LM_MOP_OWNR_TBL B , PS_LM_ORGANIZATION C WHERE A.LM_TU_POOL_ID = B.LM_MOP_ID AND B.LM_MOP_OWNER_ID = C.LM_ORGANIZATION_ID AND C.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_LM_ORGANIZATION D WHERE D.LM_ORGANIZATION_ID = C.LM_ORGANIZATION_ID AND D.EFFDT <= %CurrentDateIn) AND B.LM_MOP_TYPE = 'TUP' AND B.LM_MOP_OWNER_TYPE ='ORG'

  • Related Language Record: LM_TU_ORG_LG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_TU_POOL_ID Number(10,0) DECIMAL(10) NOT NULL Training Unit Pool No. Unique key for Training Unit Pool Record.
    2 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID
    3 LM_TU_POOL_NAME Character(20) VARCHAR2(20) NOT NULL Training Unit Pool
    4 LM_ORG_DESCR Character(50) VARCHAR2(50) NOT NULL Customer Description
    5 LM_TU_POOL_DESCR Character(40) VARCHAR2(40) NOT NULL Training Unit Pool Description.
    6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    7 LM_CHARTFLD_TYPE Character(18) VARCHAR2(18) NOT NULL ChartField Type...One of 16 ChartFields.
    8 LM_CHARTFLD_VAL Character(20) VARCHAR2(20) NOT NULL ChartField Value...Depending on ChartField Type, it would store one of the 16 Chartfield values supported.

    Prompt Table: LM_ACCOUNT_VW

    9 LM_OWNER_ID Number(15,0) DECIMAL(15) NOT NULL Owner ID
    10 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    11 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    12 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
    13 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid