SSF_ISET_ITG_VW

(SQL View)
 Index Back

Item SF View

This view is used to identify charges that can be paid given an Institution Set.

SELECT B.COMMON_ID , B.BUSINESS_UNIT , B.CHARGE_PRIORITY , Z.ITEM_NBR , Z.ITEM_AMT , Z.ITEM_TYPE , Z.APPLIED_AMT , Z.ITEM_TERM , Z.ACCOUNT_TERM , Z.ACCOUNT_NBR , Z.ITEM_BALANCE , Z.CURRENCY_CD , Z.ITEM_AMT - Z.APPLIED_AMT FROM PS_ITEM_SF Z ,PS_SSF_ISET_ITM_VW B WHERE Z.BUSINESS_UNIT = B.BUSINESS_UNIT AND Z.COMMON_ID = B.COMMON_ID AND Z.ITEM_NBR_SOURCE = B.ITEM_NBR AND (Z.ITEM_AMT >= 0) AND Z.ITEM_AMT - Z.APPLIED_AMT > 0 AND Z.ITEM_AMT > 0 AND (Z.ITEM_STATUS = 'A' OR Z.ITEM_STATUS = ' ')

# 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 CHARGE_PRIORITY Character(8) VARCHAR2(8) NOT NULL Charge Priority List
4 ITEM_NBR Character(15) VARCHAR2(15) NOT NULL Item Nbr
5 ITEM_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Item Amount
6 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
7 APPLIED_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Applied Amount
8 ITEM_TERM Character(4) VARCHAR2(4) NOT NULL Item Term
9 ACCOUNT_TERM Character(4) VARCHAR2(4) NOT NULL Account Term
10 ACCOUNT_NBR Character(10) VARCHAR2(10) NOT NULL Account Nbr
11 ITEM_BALANCE Signed Number(18,2) DECIMAL(16,2) NOT NULL Item Balance
12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
13 BALANCE_REMAIN Signed Number(18,2) DECIMAL(16,2) NOT NULL Remaining Balance