SSF_SL_XREF_VW

(SQL View)
Index Back

Item XREF Charge View


SELECT a.business_unit ,a.common_id ,a.item_nbr ,b.ssf_sl_loan_nbr , b.ssf_sl_file_nbr ,b.ssf_received_amt ,a.item_nbr_charge ,a.item_nbr_payment ,a.account_nbr ,a.account_term ,a.item_type ,a.item_term ,a.item_amt ,a.contract_num ,a.xref_dt ,a.xref_amt ,a.xref_status ,a.payment_id_nbr ,a.item_type_cd ,a.sf_reversal_ind FROM ps_item_xref_vw a ,PS_SSF_SL_PAY_BU b WHERE a.business_unit=b.business_unit AND a.common_id = b.emplid AND a.sa_id_type = 'P' AND a.payment_id_nbr = b.payment_id_nbr AND A.item_nbr = a.item_nbr_charge

# 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 ITEM_NBR Character(15) VARCHAR2(15) NOT NULL Item Nbr
4 SSF_SL_LOAN_NBR Number(3,0) SMALLINT NOT NULL StudyLink loan number unique for each student.
5 SSF_SL_FILE_NBR Number(12,0) DECIMAL(12) NOT NULL Unique system assigned number identifying a file coming from StudyLink.
6 SSF_RECEIVED_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL Received Amount
7 ITEM_NBR_CHARGE Character(15) VARCHAR2(15) NOT NULL Item Nbr Charge
8 ITEM_NBR_PAYMENT Character(15) VARCHAR2(15) NOT NULL Item Nbr Payment
9 ACCOUNT_NBR Character(10) VARCHAR2(10) NOT NULL Account Nbr
10 ACCOUNT_TERM Character(4) VARCHAR2(4) NOT NULL Account Term
11 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
12 ITEM_TERM Character(4) VARCHAR2(4) NOT NULL Item Term
13 ITEM_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Item Amount
14 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
15 XREF_DT Date(10) DATE Item Cross Reference Date
16 XREF_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL Item Cross Reference Amount
17 XREF_STATUS Character(1) VARCHAR2(1) NOT NULL Xref Status
D=Default
O=Override
R=Refund
U=User Directed Payment
18 PAYMENT_ID_NBR Number(12,0) DECIMAL(12) NOT NULL Payment ID Nbr
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
20 SF_REVERSAL_IND Character(1) VARCHAR2(1) NOT NULL Reversal Indicator