LM_TU_POOL_TBL

(SQL Table)
 Index Back

Training Unit (Method of Pymt)

Training Unit is a type of method of payment. It can be used for payment in enrollments. Training Unit owns Training Unit Pool Items.

  • Related Language Record: LM_TU_POOL_LANG

  • Parent Record Of LM_TUPL_ITM_TBL

    • # 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_TU_POOL_NAME Character(20) VARCHAR2(20) NOT NULL Training Unit Pool
    3 LM_TU_POOL_DESCR Character(40) VARCHAR2(40) NOT NULL Training Unit Pool Description.
    4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    5 LM_CHARTFLD_TYPE Character(18) VARCHAR2(18) NOT NULL ChartField Type...One of 16 ChartFields.

    Prompt Table: LM_CF_NAMES_VW

    6 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: %EDITTABLE

    7 LM_OWNER_ID Number(15,0) DECIMAL(15) NOT NULL Owner ID

    Prompt Table: LM_CUST_OWNR_VW

    8 LM_TU_POOL_USED Character(1) VARCHAR2(1) NOT NULL Y/N value if a TU pool has been used

    Y/N Table Edit

    9 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    10 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    11 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
    12 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid