SSF_RF_PSHUP_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , B.REFUND_NBR , B.EMPLID , A.COMPANY , A.PAYGROUP , 'Y' , D.SEQNO , 0 , A.DEPTID , A.JOBCODE , B.ERNCD , A.BUSINESS_UNIT_HR , D.LINE_AMT , B.REFUND_STATUS FROM PS_BUS_UNIT_TBL_SF A , PS_REFUND_HDR B , PS_REFUND_DTL D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.BUSINESS_UNIT = D.BUSINESS_UNIT AND B.REFUND_NBR = D.REFUND_NBR AND B.REFUND_STATUS IN ('P','I') AND B.REFUND_METHODE = 'P'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_SF Character(5) VARCHAR2(5) NOT NULL Stdnt Fin 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 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
5 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
6 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?
7 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
8 SEPCHK Number(1,0) SMALLINT NOT NULL Separate check number.
9 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
10 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
11 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
12 BUSINESS_UNIT_HR Character(5) VARCHAR2(5) NOT NULL Business Unit for HRMS
13 LINE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Line Amount
14 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