SP_ITYPAP_NONVW

(SQL View)
 Index Back

Payment Item Types for App Fee


SELECT A.SETID , A.TENDER_CATEGORY , A.ITEM_TYPE , A.DESCR , A.ITEM_TYPE_CD , A.KEYWORD1 , A.KEYWORD2 , A.KEYWORD3 FROM PS_ITEM_TYPE_TBL A WHERE A.EFF_STATUS='A' AND A.EFFDT= ( SELECT MAX(B.EFFDT) FROM PS_ITEM_TYPE_TBL B WHERE A.SETID=B.SETID AND A.ITEM_TYPE=B.ITEM_TYPE AND B.EFFDT <= %CurrentDateIn) AND A.ITEM_TYPE_CD = 'P' AND A.TENDER_CATEGORY <> ' '

  • Related Language Record: SPITYPAPNONVWLN

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

    Prompt Table: SP_SETID_NONVW

    2 TENDER_CATEGORY Character(3) VARCHAR2(3) NOT NULL Tender Category
    CC=Credit Card
    CCI=Credit Card In
    CCO=Credit Card Out
    CK=Check
    CKI=Check In
    CKO=Check Out
    CS=Cash
    CSI=Cash In
    CSO=Cash Out
    DB=Debit Card
    DBI=Debit Card In
    DBO=Debit Card Out
    DD=Direct Deposit
    DDI=Direct Debit
    DDO=Direct Deposit
    EC=Electronic Check
    TP=Third Party Check
    TPI=Third Party Check In
    WIR=Wire Transfer
    3 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

    Prompt Table: ITEM_TYPE_1_TBL

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 ITEM_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Item Type Code
    A=Application Fee
    B=Billing Only
    C=Charge
    D=Deposit
    F=Financial Aid
    G=GL Interface Only
    H=Withholding
    I=Interest
    L=Pre-Paid Tuition
    P=Payment
    R=Refund
    T=Transfers
    V=Contributor Relations
    W=Waiver
    X=Write-off
    Z=Pay Plan Credit
    6 KEYWORD1 Character(10) VARCHAR2(10) NOT NULL Key Word

    Prompt Table: %EDITTABLE

    7 KEYWORD2 Character(10) VARCHAR2(10) NOT NULL Key Word 2

    Prompt Table: %EDITTABLE2

    8 KEYWORD3 Character(10) VARCHAR2(10) NOT NULL Key Word 3

    Prompt Table: %EDITTABLE3