REFUND_HDR_VW2

(SQL View)
 Index Back

Refund approval view

Select refund_hdr rows of data that require a refund approval

SELECT a.business_unit , a.refund_nbr , a.emplid , b.name , a.refund_amt , a.ref_appr_opr_1 , a.ref_appr_opr_2 , a.ref_appr_opr_3 , a.ref_appr_sw_1 , a.ref_appr_sw_2 , a.ref_appr_sw_3 FROM PS_REFUND_HDR a , PS_SCC_PRI_NAME_VW b WHERE a.emplid > ' ' AND a.emplid = b.emplid AND a.ref_appr_active_sw = 'Y' AND (a.ref_appr_sw_1 = 'P' OR a.ref_appr_sw_2 = 'P' OR a.ref_appr_sw_3 = 'P' ) AND a.refund_status IN ( 'P' , 'C')

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 NAME Character(50) VARCHAR2(50) NOT NULL Name
5 REFUND_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Refund Amount
6 REF_APPR_OPR_1 Character(30) VARCHAR2(30) NOT NULL Approval OPRID 1
7 REF_APPR_OPR_2 Character(30) VARCHAR2(30) NOT NULL Approval OPRID 2
8 REF_APPR_OPR_3 Character(30) VARCHAR2(30) NOT NULL Approval OPRID 3
9 REF_APPR_SW_1 Character(1) VARCHAR2(1) NOT NULL Approval Switch 1
A=Refund Approved
D=Refund Denied
N=No Approval Required
P=Pending Approval
10 REF_APPR_SW_2 Character(1) VARCHAR2(1) NOT NULL Approval Switch 2
A=Refund Approved
D=Refund Denied
N=No Approval Required
P=Pending Approval
11 REF_APPR_SW_3 Character(1) VARCHAR2(1) NOT NULL Approval Switch 3
A=Approved
D=Refund Denied
N=No Approval Required
P=Pending Approval