OPT_FEE_TRM_EFF

(SQL Table)
 Index Back

Optional Fee Effdts for a Term

  • Parent record: OPT_FEE_TRM_LD

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

    Default Value: OPT_FEE_TERM.SETID

    Prompt Table: OPT_FEE_TRM_LD

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

    Default Value: OPT_FEE_TERM.FEE_CD

    Prompt Table: OPT_FEE_TRM_LD

    3 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Default Value: OPT_FEE_TERM.STRM

    Prompt Table: OPT_FEE_TRM_LD

    4 ACADEMIC_LOAD Character(1) VARCHAR2(1) NOT NULL Academic Load
    F=Enrolled Full-Time
    H=Enrolled Half-Time
    L=Less than Half-Time
    N=No Unit Load
    P=Enrolled Part-Time
    T=Three Quarter Time

    Default Value: OPT_FEE_TRM_LD.ACADEMIC_LOAD

    Prompt Table: OPT_FEE_TRM_LD

    5 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Default Value: A