REFUND_DTLEX_VW

(SQL View)
 Index Back

Refund Detail Extra View


select a.business_unit, a.refund_nbr, a.line_seq_nbr, a.line_amt, a.emplid, a.refund_emplid, a.item_nbr, c.descr, b.refund_status, a.refund_line_status, a.refund_line_type, a.refund_format, a.erncd from ps_refund_dtl a, ps_refund_hdr b, PS_ITEM_TYPE_TBL c, ps_bus_unit_tbl_sf d where a.business_unit = b.business_unit and a.refund_nbr = b.refund_nbr and a.business_unit = d.business_unit and a.item_nbr = '000000000000000' 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: REFUNDTLEXVWLNG

  • 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 LINE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Line Amount
    5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    6 REFUND_EMPLID Character(11) VARCHAR2(11) NOT NULL Refund ID
    7 ITEM_NBR Character(15) VARCHAR2(15) NOT NULL Item Nbr
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 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
    10 REFUND_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Refund Line Status
    C=Complete
    E=Entered
    P=Posted
    X=Cancelled
    11 REFUND_LINE_TYPE Character(1) VARCHAR2(1) NOT NULL Refund Line Type
    C=Charge
    P=Payment/Financial Aid
    12 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
    13 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code