SSF_SS_PEND_PAY

(SQL View)

SELECT A.SF_PMT_REF_NBR , B.BUSINESS_UNIT , A.COMMON_ID , D.INSTITUTION_SET , A.LAST_DTTM_UPDATE ,%CurrentDateIn , SUM(B.PAYOUT_AMT) , ' ' , A.CR_CARD_DIGITS , ' ' , A.TENDER_CATEGORY , B.ITEM_TERM FROM PS_SF_PAYMENT A , PS_SF_PAYMENT_DTL B , PS_ISET_BU_DTL D WHERE A.SF_PMT_REF_NBR = B.SF_PMT_REF_NBR AND B.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.SEQNUM = B.SEQNUM AND A.SA_ID_TYPE = 'P' AND A.SEQNUM = ( SELECT MAX(C.SEQNUM) FROM PS_SF_PAYMENT C WHERE A.SF_PMT_REF_NBR = C.SF_PMT_REF_NBR AND A.SEQNUM = C.SEQNUM) AND A.CR_CARD_TRANS_SRC = 'P' AND ((A.SF_PAYMENT_STATUS = 'S' OR A.SF_PAYMENT_STATUS = 'A' OR A.SF_PAYMENT_STATUS = 'B') AND A.SF_POST_STATUS <> 'S') AND B.PAYOUT_AMT > 0 GROUP BY A.SF_PMT_REF_NBR , B.BUSINESS_UNIT , A.COMMON_ID , D.INSTITUTION_SET, A.POSTED_DATE , A.CR_CARD_DIGITS, A.TENDER_CATEGORY, A.LAST_DTTM_UPDATE, ITEM_TERM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SF_PMT_REF_NBR Character(12) VARCHAR2(12) NOT NULL Reference Nbr

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value

4 INSTITUTION_SET Character(5) VARCHAR2(5) NOT NULL Institution Set

5 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

6 SSF_POSTED_DATE Date(10) DATE Date Posted

7 PAYOUT_AMT Number(17,2) DECIMAL(16,2) NOT NULL Pay Out Amt

8 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

9 CR_CARD_DIGITS Character(4) VARCHAR2(4) NOT NULL Card Number's Last Four Digits

10 SSF_DESCR Character(30) VARCHAR2(30) NOT NULL Student Financials' Description

11 TENDER_CATEGORY Character(3) VARCHAR2(3) NOT NULL Tender Category
CC=Credit Card
CCI=Credit Card In
CCO=Credit Card Out
CK=Check
CKI=Check In
CKO=Check Out
CS=Cash
CSI=Cash In
CSO=Cash Out
DB=Debit Card
DBI=Debit Card In
DBO=Debit Card Out
DD=Direct Deposit
DDI=Direct Debit
DDO=Direct Deposit
EC=Electronic Check
TP=Third Party Check
TPI=Third Party Check In
WIR=Wire Transfer

12 ITEM_TERM Character(4) VARCHAR2(4) NOT NULL Item Term

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SF_PMT_REF_NBR	Character(12)	VARCHAR2(12) NOT NULL	Reference Nbr
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	COMMON_ID	Character(11)	VARCHAR2(11) NOT NULL	Common ID to store Personal ID / Ext Org ID value
4	INSTITUTION_SET	Character(5)	VARCHAR2(5) NOT NULL	Institution Set
5	LAST_DTTM_UPDATE	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
6	SSF_POSTED_DATE	Date(10)	DATE	Date Posted
7	PAYOUT_AMT	Number(17,2)	DECIMAL(16,2) NOT NULL	Pay Out Amt
8	ITEM_TYPE	Character(12)	VARCHAR2(12) NOT NULL	Item Type
9	CR_CARD_DIGITS	Character(4)	VARCHAR2(4) NOT NULL	Card Number's Last Four Digits
10	SSF_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Student Financials' Description
11	TENDER_CATEGORY	Character(3)	VARCHAR2(3) NOT NULL	Tender Category CC=Credit Card CCI=Credit Card In CCO=Credit Card Out CK=Check CKI=Check In CKO=Check Out CS=Cash CSI=Cash In CSO=Cash Out DB=Debit Card DBI=Debit Card In DBO=Debit Card Out DD=Direct Deposit DDI=Direct Debit DDO=Direct Deposit EC=Electronic Check TP=Third Party Check TPI=Third Party Check In WIR=Wire Transfer
12	ITEM_TERM	Character(4)	VARCHAR2(4) NOT NULL	Item Term