APP_FEE_TBL

(SQL Table)
Index Back

Application Fee Table

  • Parent record: APP_FEE_CD_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 Fee Code

    Prompt Table: APP_FEE_CD_TBL

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

    Prompt Table: TERM_VAL_TBL

    4 SESSION_CODE Character(3) VARCHAR2(3) NOT NULL Session
    1=Regular Academic Session
    10W=10 Week
    12W=Twelve Week
    4W1=Four Week - First
    4W2=Four Week - Second
    4W3=Four Week - Third
    4W4=Four Week - Fourth
    6W1=Six Week - First
    6W2=Six Week - Second
    8W1=Eight Week - First
    8W2=Eight Week - Second
    A11=Medical Period 1, 4 Weeks
    A12=Medical Period 1, 8 Weeks
    A13=Medical Pd 1, 12 Weeks
    A21=Medical Period 2, 4 Weeks
    A22=Medical Period 2, 8 Weeks
    A23=Medical Period 2, 12 Week
    FYR=Full Year
    MIN=Mini Session
    OEE=Open Entry/Open Exit
    SM1=Semester 1
    SM2=Semester 2
    5 FEE_TRIGGER Character(12) VARCHAR2(12) NOT NULL Fee Trigger

    Prompt Table: FEE_TRIGGER_VW

    6 MAX_AMOUNT Number(17,2) DECIMAL(16,2) NOT NULL Maximum Amount
    7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: INSTALLATION.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    8 TRACK_PAY_METHOD Character(1) VARCHAR2(1) NOT NULL Track Payment Method

    Y/N Table Edit

    Default Value: N

    9 APP_TO_SF Character(1) VARCHAR2(1) NOT NULL Post to SF from App

    Y/N Table Edit

    Default Value: N

    10 ACCOUNT_TYPE_SF Character(3) VARCHAR2(3) NOT NULL Account Type

    Prompt Table: ACCT_TYP_TBL_SF

    11 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

    Prompt Table: SP_ITEMAP_NONVW

    12 PAID_ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Paid Item Type

    Prompt Table: SP_ITYPPY_NONVW

    13 WAIVER_ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Waiver Item Type

    Prompt Table: SP_ITEMWV_NONVW

    14 SF_TO_APP Character(1) VARCHAR2(1) NOT NULL Update App from SF

    Y/N Table Edit

    Default Value: N

    15 APPL_FEE_STAT_FROM Character(3) VARCHAR2(3) NOT NULL Application Fee Status From
    PEN=Pending
    REC=Received
    WAV=Waived
    16 APPL_FEE_STATUS Character(3) VARCHAR2(3) NOT NULL Application Fee Status
    DEF=Deferred Payment
    PEN=Pending
    REC=Received
    WRQ=Waiver Request
    WVD=Waived
    17 MIN_MAX_FEE_CODE Character(8) VARCHAR2(8) NOT NULL Min/Max Fee Code

    Prompt Table: MIN_MAX_FEE

    18 DUE_DATE_CODE Character(8) VARCHAR2(8) NOT NULL Due Date Code

    Prompt Table: DUE_DATE_CD_VW2

    19 APP_TO_GL Character(1) VARCHAR2(1) NOT NULL Post to GL from AAWS App

    Y/N Table Edit

    Default Value: N