ACCT_PP_SS_VW2

(SQL View)
 Index Back

Term Summary SF


SELECT DISTINCT A.COMMON_ID , A.STRM , D.INSTITUTION , B.ISET_OVRD , C.DESCR , ' ' , 0 FROM PS_SF_PAYMENT A , PS_OPR_DEF_TBL_CS B , PS_TERM_VAL_TBL C , PS_BUS_UNIT_TBL_SF D , PSOPRDEFN E , PS_ISET_BU_DTL F WHERE A.INSTITUTION_SET <> ' ' AND A.INSTITUTION_SET = B.ISET_OVRD AND F.INSTITUTION_SET = B.ISET_OVRD AND F.BUSINESS_UNIT = D.BUSINESS_UNIT AND D.SF_ENABLE_WEB_PAY = 'Y' AND A.STRM = C.STRM AND A.SA_ID_TYPE = '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 A.CR_CARD_TRANS_SRC = 'P' AND A.COMMON_ID = E.EMPLID AND B.OPRID = E.OPRID AND A.INSTITUTION = D.INSTITUTION

  • Related Language Record: ACCT_PPSSVW2LNG

    • # 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 STRM Character(4) VARCHAR2(4) NOT NULL Term
    3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    4 INSTITUTION_SET Character(5) VARCHAR2(5) NOT NULL Institution Set
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    7 BALANCE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Charge Balance