ITEM_RFNDD_VW

(SQL View)
 Index Back

Refund Update Item Sf


SELECT A.BUSINESS_UNIT , B.COMMON_ID , A.EMPLID , A.REFUND_EMPLID , A.REFUND_NBR , A.REFUND_TYPE , A.REFUND_AMT , A.REFUND_STATUS , A.ITEM_TYPE , B.ITEM_TERM , B.ITEM_TYPE_CD , C.DESCR , SUM(B.ITEM_BALANCE) FROM PS_REFUND_HDR A , PS_ITEM_SF B , PS_ITEM_TYPE_TBL C , PS_BUS_UNIT_TBL_SF D WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.COMMON_ID = A.EMPLID AND B.ITEM_TYPE = A.ITEM_TYPE AND B.REFUND_NBR = A.REFUND_NBR AND B.ITEM_TYPE = C.ITEM_TYPE AND B.BUSINESS_UNIT = D.BUSINESS_UNIT AND B.SA_ID_TYPE = 'P' AND C.SETID=( SELECT E.SETID FROM PS_SET_CNTRL_REC E WHERE E.RECNAME='ITEM_TYPE_TBL' AND E.SETCNTRLVALUE=D.INSTITUTION) AND C.EFFDT=( SELECT MAX(EFFDT) FROM PS_ITEM_TYPE_TBL Y WHERE Y.SETID=C.SETID AND Y.ITEM_TYPE=C.ITEM_TYPE AND Y.EFFDT <= %CurrentDateIn AND Y.EFF_STATUS = 'A' ) GROUP BY A.BUSINESS_UNIT , B.COMMON_ID , A.EMPLID , A.REFUND_EMPLID, A.REFUND_NBR , A.REFUND_TYPE , A.REFUND_AMT , A.REFUND_STATUS , A.ITEM_TYPE , B.ITEM_TERM , B.ITEM_TYPE_CD , C.DESCR

  • Related Language Record: ITEMRFNDDVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    4 REFUND_EMPLID Character(11) VARCHAR2(11) NOT NULL Refund ID
    5 REFUND_NBR Number(12,0) DECIMAL(12) NOT NULL Refund Nbr
    6 REFUND_TYPE Character(1) VARCHAR2(1) NOT NULL Refund Type
    C=Combined
    F=Financial Aid
    N=Non Financial
    O=On-Line Request
    7 REFUND_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Refund Amount
    8 REFUND_STATUS Character(1) VARCHAR2(1) NOT NULL Refund Status
    A=AP Interface Created
    B=Credit Pending
    C=Confirmed
    D=Credit Declined
    E=Entered
    I=Interfaced to Payroll
    P=Posted
    R=Reversed
    S=Paysheet Created
    V=Sent to ePayment Servicer
    X=Cancelled
    9 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

    Prompt Table: ITEM_TYPE_TBL

    10 STRM Character(4) VARCHAR2(4) NOT NULL Term
    11 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
    12 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    13 BALANCE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Charge Balance