TERM_FE_CD_TBL

(SQL Table)
 Index Back

Term Fee Code Table

  • Related Language Record: TERM_FE_CD_LNG

  • Parent Record Of TERM_FEE_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_CS.SETID

    Prompt Table: SP_SETID_NONVW

    2 FEE_CODE Character(6) VARCHAR2(6) NOT NULL Term Fee Code
    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 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

    Default Value: TERM_FE_CD_TBL.DESCR

    6 CHARGE_BY Character(1) VARCHAR2(1) NOT NULL Charge By
    C=Charge By Class
    S=Charge By Session
    T=Charge By Term

    Default Value: T

    7 FEE_CLASS Character(3) VARCHAR2(3) NOT NULL Fee Class

    Prompt Table: FEE_CLASS_TBL

    8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: INSTALLATION.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    9 USE_UNIT Character(1) VARCHAR2(1) NOT NULL Use Unit Option
    A=Anticipated Units
    B=Billing Units

    Default Value: B

    10 USE_ANTIC_UNIT_IND Character(1) VARCHAR2(1) NOT NULL Use Antic if enrollment exists

    Y/N Table Edit

    Default Value: Y