ACCT_PPSSVW2LNG

(SQL View)
 Index Back

Rel Lang Term Summary SF

ACCT_PPSSVW2LNG is the language record view related to ACCT_PP_SS_VW2. A related language record enables text fields on a table to be translated into various languages for use in other countries.

SELECT DISTINCT A.COMMON_ID , A.STRM , D.INSTITUTION , C.LANGUAGE_CD , C.DESCR FROM PS_SF_PAYMENT A , PS_OPR_DEF_TBL_CS B , PS_TERM_VAL_LANG 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 for ACCT_PP_SS_VW2

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description