LM_TU_OWNER_VW

(SQL View)
 Index Back

TU OwnerID

TU OwnerID

SELECT B.LM_MOP_OWNER_ID , B.LM_MOP_OWNER_TYPE , A.LM_TU_POOL_ID , A.LM_TU_POOL_NAME , A.LM_TU_POOL_DESCR , A.CURRENCY_CD , A.LM_CHARTFLD_TYPE , A.LM_CHARTFLD_VAL , A.LM_OWNER_ID , A.LM_TU_POOL_USED , %subrec(LM_ROWAUDIT_SBR,A) FROM PS_LM_TU_POOL_TBL A , PS_LM_MOP_OWNR_TBL B WHERE A.LM_TU_POOL_ID = B.LM_MOP_ID AND B.LM_MOP_TYPE = 'TUP'

  • Related Language Record: LM_TU_OWR_LG_VW

    • # 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 LM_TU_POOL_NAME Character(20) VARCHAR2(20) NOT NULL Training Unit Pool
    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_TU_POOL_USED Character(1) VARCHAR2(1) NOT NULL Y/N value if a TU pool has been used
    11 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    12 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    13 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
    14 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid