BANK_INTACT_VW2

(SQL View)
Index Back

Internal Account Search View

This view is dependent upon the Servicer and Owner of the bank account

SELECT DISTINCT A.SETID , A.BANK_CD_CUST , A.COUNTERPARTY , B.BANK_ACCOUNT_NUM , B.DESCRSHORT , B.DESCR FROM PS_BANK_ACCT_CPTY A , PS_BANK_ACCT_DEFN B WHERE A.SETID = B.SETID AND A.BANK_CD = B.BANK_CD AND A.COUNTERPARTY = B.BANK_CD_CPTY

  • Related Language Record: BANK_INTACT_LG2
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 BANK_CD_CUST Character(5) VARCHAR2(5) NOT NULL Represents the customer bank or counterparty in a relationship that pairs differing sets of b

    Prompt Table: BANK_CD_INT_VW

    3 BANK_CD_SVCR Character(5) VARCHAR2(5) NOT NULL Represents the internal servicer counterparty in a relationship that pairs differing sets

    Prompt Table: BANK_CD_INT_VW

    4 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description