SSF_SS_POST_PAY

(SQL View)
 Index Back

Posted Payments - Student


SELECT A.BUSINESS_UNIT , A.COMMON_ID , A.SA_ID_TYPE , A.PAYMENT_ID_NBR , D.INSTITUTION_SET , A.PAYMENT_METHOD , A.PAYMENT_AMT , A.SF_REVERSAL_IND , A.REF1_DESCR , A.TENDER_CATEGORY , A.ITEM_TYPE , A.POSTED_DATE , A.STRM , A.CONTRACT_NUM , A.CURRENCY_CD , A.SF_PMT_REF_NBR , A.CR_CARD_DIGITS , B.DESCR , B.ITEM_TYPE_CD FROM PS_PAYMENT_TBL A , PS_ITEM_TYPE_TBL B , PS_BUS_UNIT_TBL_SF C , PS_ISET_BU_DTL D WHERE SA_ID_TYPE = 'P' AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.ITEM_TYPE = B.ITEM_TYPE AND B.SETID = ( SELECT E.SETID FROM PS_SET_CNTRL_REC E WHERE E.SETCNTRLVALUE = C.INSTITUTION AND E.RECNAME = 'ITEM_TYPE_TBL') AND B.EFFDT = ( SELECT MAX(F.EFFDT) FROM PS_ITEM_TYPE_TBL F WHERE F.SETID = B.SETID AND F.ITEM_TYPE = B.ITEM_TYPE AND F.EFFDT <= A.POSTED_DATE) AND A.PAYMENT_AMT > 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
3 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
O=Organization
P=Person
4 PAYMENT_ID_NBR Number(12,0) DECIMAL(12) NOT NULL Payment ID Nbr
5 INSTITUTION_SET Character(5) VARCHAR2(5) NOT NULL Institution Set
6 PAYMENT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
CC=Credit Card
CHK=Check
CSH=Cash
DB=Debit Card
EC=Electronic Check
EFT=Electronic Funds Transfer
LBX=Lockbox
TPC=Third Party Check
WIR=Wire Transfer
7 SSF_PAYMENT_AMT Number(19,3) DECIMAL(18,3) NOT NULL Payment Amount
8 SF_REVERSAL_IND Character(1) VARCHAR2(1) NOT NULL Reversal Indicator
9 REF1_DESCR Character(30) VARCHAR2(30) NOT NULL Reference Nbr
10 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
11 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
12 SSF_POSTED_DATE Date(10) DATE Date Posted
13 STRM Character(4) VARCHAR2(4) NOT NULL Term
14 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
16 SF_PMT_REF_NBR Character(12) VARCHAR2(12) NOT NULL Reference Nbr
17 CR_CARD_DIGITS Character(4) VARCHAR2(4) NOT NULL Card Number's Last Four Digits
18 SSF_DESCR Character(30) VARCHAR2(30) NOT NULL Student Financials' Description
19 ITEM_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Item Type Code
A=Application Fee
B=Billing Only
C=Charge
D=Deposit
F=Financial Aid
G=GL Interface Only
H=Withholding
I=Interest
L=Pre-Paid Tuition
P=Payment
R=Refund
T=Transfers
V=Contributor Relations
W=Waiver
X=Write-off
Z=Pay Plan Credit