RFND_ORG_DTL_VW

(SQL View)
 Index Back

Refund Detail View


SELECT a.business_unit , b.common_id , a.refund_nbr , a.line_seq_nbr , a.line_amt , a.ext_org_id , a.item_nbr , c.descr , 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 WHERE a.business_unit = b.business_unit AND a.item_nbr = b.item_nbr AND a.ext_org_id = b.common_id AND b.sa_id_type = 'O' AND a.business_unit = d.business_unit 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 c.eff_status = 'A'

  • Related Language Record: RFNDORGDTLVWLNG

  • 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 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
    3 REFUND_NBR Number(12,0) DECIMAL(12) NOT NULL Refund Nbr
    4 LINE_SEQ_NBR Number(3,0) SMALLINT NOT NULL Line Sequence Nbr
    5 LINE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Line Amount
    6 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    7 ITEM_NBR Character(15) VARCHAR2(15) NOT NULL Item Nbr
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 REFUND_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Refund Line Status
    C=Complete
    E=Entered
    P=Posted
    X=Cancelled
    10 REFUND_LINE_TYPE Character(1) VARCHAR2(1) NOT NULL Refund Line Type
    C=Charge
    P=Payment/Financial Aid
    11 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
    12 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
    13 ACCOUNT_NBR Character(10) VARCHAR2(10) NOT NULL Account Nbr
    14 ACCOUNT_TERM Character(4) VARCHAR2(4) NOT NULL Account Term
    15 ITEM_TERM Character(4) VARCHAR2(4) NOT NULL Item Term