TUIT_EXPEN_TBL

(SQL Table)
 Index Back

Training Expense Type

Administer Training/Budget Training tuition expense types.

  • Related Language Record: TRN_EXPNTP_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TUIT_EXPENSE_TYPE Character(10) VARCHAR2(10) NOT NULL Tuition Expense Type
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %Date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 REIMB_PCT_WRK_REL Number(3,0) SMALLINT NOT NULL % Reimbursable-Work-Related
    7 REIMB_PCT_NON_WRK Number(3,0) SMALLINT NOT NULL % Reimbursable-Non-Work-Relat
    8 REIMB_LIMIT_SW Character(1) VARCHAR2(1) NOT NULL Limited Reimbursement

    Y/N Table Edit

    Default Value: N

    9 REIMB_LIMIT_AMT Number(19,3) DECIMAL(18,3) NOT NULL Reimbursable Limit Amount
    10 REIMB_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    11 REIMB_COST_UNIT_CD Character(10) VARCHAR2(10) NOT NULL Cost Unit

    Default Value: STUD/H

    Prompt Table: COST_UNIT_VW

    12 CHARGEABLE_SW_FRA Character(1) VARCHAR2(1) NOT NULL Chargeable switch

    Y/N Table Edit

    Default Value: N

    13 LIMIT_SW_FRA Character(1) VARCHAR2(1) NOT NULL Limited Amount

    Y/N Table Edit

    Default Value: N

    14 LIMIT_AMT_FRA Number(19,3) DECIMAL(18,3) NOT NULL Limit Amount
    15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    16 COST_UNIT_CD Character(10) VARCHAR2(10) NOT NULL Cost Unit

    Default Value: STUD/H

    Prompt Table: TD_COST_UNIT_VW

    17 TYPE_2483_FRA Character(3) VARCHAR2(3) NOT NULL 2483 Type
    EQU=Equipment
    FUR=Furniture
    ILE=Instructor Lodging & Transport
    INS=Instructor
    LAT=Student Lodging & Transport.
    NIN=Non Instructor
    RES=Student Restaurant
    18 GVT_COSTTYPE Character(1) VARCHAR2(1) NOT NULL Cost Type
    D=Direct
    I=Indirect
    19 PER_UNIT_COST Number(19,3) DECIMAL(18,3) NOT NULL Per Unit Cost
    20 CURRENCY_CD1 Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    21 COST_UNIT_CD1 Character(10) VARCHAR2(10) NOT NULL Cost Unit

    Prompt Table: AL_COST_UNIT_VW