REFUND_DTL_VW

(SQL View)
 Index Back

Refund Detail View


SELECT a.business_unit , a.refund_nbr , a.line_seq_nbr , b.common_id , a.line_amt , a.emplid , a.refund_emplid , a.item_nbr , c.descr , g.refund_status , a.refund_line_status , a.refund_line_type , a.refund_format , a.erncd , b.account_nbr , b.account_term , b.item_term FROM ps_refund_dtl a , ps_item_sf b , PS_ITEM_TYPE_TBL c , ps_bus_unit_tbl_sf d , ps_refund_hdr g WHERE a.business_unit = b.business_unit AND a.item_nbr = b.item_nbr AND a.emplid = b.common_id AND b.sa_id_type = 'P' AND a.business_unit = d.business_unit AND a.business_unit = g.business_unit AND a.refund_nbr = g.refund_nbr AND b.item_type = c.item_type 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(f.effdt) FROM PS_ITEM_TYPE_TBL f WHERE c.setid = f.setid AND c.item_type = f.item_type AND f.effdt <= %CurrentDateIn AND f.eff_status = 'A')

  • Related Language Record: REFUNDDTLVWLNG

  • Parent record: REFUND_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 REFUND_NBR Number(12,0) DECIMAL(12) NOT NULL Refund Nbr
    3 LINE_SEQ_NBR Number(3,0) SMALLINT NOT NULL Line Sequence Nbr
    4 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
    5 LINE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Line Amount
    6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    7 REFUND_EMPLID Character(11) VARCHAR2(11) NOT NULL Refund ID
    8 ITEM_NBR Character(15) VARCHAR2(15) NOT NULL Item Nbr
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    10 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
    11 REFUND_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Refund Line Status
    C=Complete
    E=Entered
    P=Posted
    X=Cancelled
    12 REFUND_LINE_TYPE Character(1) VARCHAR2(1) NOT NULL Refund Line Type
    C=Charge
    P=Payment/Financial Aid
    13 REFUND_FORMAT Character(1) VARCHAR2(1) NOT NULL Refund Format
    A=Automatic Check
    C=Credit Card
    D=Direct Deposit
    E=Electronic Check
    P=Paper Check
    14 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
    15 ACCOUNT_NBR Character(10) VARCHAR2(10) NOT NULL Account Nbr
    16 ACCOUNT_TERM Character(4) VARCHAR2(4) NOT NULL Account Term
    17 ITEM_TERM Character(4) VARCHAR2(4) NOT NULL Item Term