SSF_REF_CNTL_VW

(SQL View)
 Index Back

Refund approval view

Select refund_hdr rows of data that require a refund approval

SELECT DISTINCT b.oprclass , a.business_unit , a.refund_emplid , b.name , a.refund_nbr , a.refund_dttm , a.refund_status , b.last_name_srch , b.first_name_srch , a.batch_id FROM ps_refund_hdr a , PS_REFUND_DTL d , PS_PEOPLE_SRCH b WHERE a.refund_emplid = b.emplid AND a.refund_status IN ('A','B','C','D','P','S','I') AND a.refund_methode = 'P' AND a.business_unit = d.business_unit AND a.refund_nbr = d.refund_nbr AND d.refund_format IN ('A','D','P')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT

Prompt Table: SP_BU_SF_NONVW

3 REFUND_EMPLID Character(11) VARCHAR2(11) NOT NULL Refund ID

Prompt Table: PEOPLE_SRCH

4 NAME Character(50) VARCHAR2(50) NOT NULL Name
5 REFUND_NBR Number(12,0) DECIMAL(12) NOT NULL Refund Nbr
6 REFUND_DTTM DateTime(26) TIMESTAMP Refund Date and Time
7 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
8 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
9 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
10 BATCH_ID Character(12) VARCHAR2(12) NOT NULL Batch ID

Prompt Table: REF_BATCH_ID_VW