STDNT_RFND_VW

(SQL View)
Index Back

Refund Header View

This view is used as a prompt form Refund Number in COMM_VAR_DATA. Emplid is the primary key.

SELECT B.COMMON_ID ,A.EMPLID ,A.BUSINESS_UNIT ,A.REFUND_NBR ,B.ITEM_TERM ,A.REFUND_STATUS ,A.REFUND_METHODE ,C.REFUND_FORMAT ,A.ADDRESS_TYPE ,A.REFUND_DTTM ,A.VOUCHER_ID ,A.COMPANY ,A.PAYGROUP ,A.PAY_END_DT ,A.PAGE_NUM ,A.BATCH_ID ,B.ITEM_AMT ,A.REFUND_AMT ,A.CURRENCY_CD ,A.REFUND_TYPE FROM PS_REFUND_HDR A , PS_ITEM_SF B , PS_REFUND_DTL C WHERE B.SA_ID_TYPE = 'P' AND A.REFUND_STATUS IN ('A','B','P','C','D','P','S','V') AND A.EMPLID = B.COMMON_ID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.REFUND_NBR = B.REFUND_NBR AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.REFUND_NBR = C.REFUND_NBR AND C.LINE_SEQ_NBR = 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 REFUND_NBR Number(12,0) DECIMAL(12) NOT NULL Refund Nbr
5 STRM Character(4) VARCHAR2(4) NOT NULL Term
6 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
7 REFUND_METHODE Character(1) VARCHAR2(1) NOT NULL Refund Method
A=Accounts Payable
O=Other
P=Payroll
8 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
9 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type

Prompt Table: HCR_ADDR_TYP_I

10 REFUND_DTTM DateTime(26) TIMESTAMP Refund Date and Time
11 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
12 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
13 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
14 PAY_END_DT Date(10) DATE Pay Period End Date
15 PAGE_NUM Number(4,0) SMALLINT NOT NULL Page #
16 BATCH_ID Character(12) VARCHAR2(12) NOT NULL Batch ID
17 ITEM_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Item Amount
18 REFUND_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Refund Amount
19 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
20 REFUND_TYPE Character(1) VARCHAR2(1) NOT NULL Refund Type
C=Combined
F=Financial Aid
N=Non Financial
O=On-Line Request