OPT_FEE_VAL

(SQL Table)
 Index Back

Optional Fee Values

  • Parent record: OPT_FEE_TBL

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

    Default Value: OPT_FEE_TBL.SETID

    Prompt Table: OPT_FEE_TBL

    2 FEE_CD Character(6) VARCHAR2(6) NOT NULL Fee Code

    Default Value: OPT_FEE_TBL.FEE_CD

    Prompt Table: OPT_FEE_TBL

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: OPT_FEE_TBL.EFFDT

    4 VALID_VALUE Character(6) VARCHAR2(6) NOT NULL Valid Value
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: OPT_FEE_VAL.DESCR

    7 INITIAL_VALUE Character(1) VARCHAR2(1) NOT NULL Initial Value

    Y/N Table Edit

    Default Value: N