BANK_ACTINFO_VW

(SQL View)
 Index Back

Bank Account Details View


SELECT A.SETID ,A.BANK_CD ,A.BANK_ACCT_KEY ,C.DESCR ,C.DESCR_AC ,B.DESCRSHORT ,B.BANK_ID_QUAL ,B.BNK_ID_NBR ,C.BRANCH_ID ,A.BANK_ACCOUNT_NUM ,A.CHECK_DIGIT ,A.DESCR ,A.DFI_ID_NUM ,A.DFI_ID_QUAL ,A.BANK_ACCT_TYPE FROM PS_BANK_CD_TBL B ,PS_BANK_ACCT_DEFN A ,PS_BANK_BRANCH_TBL C WHERE A.SETID = B.SETID AND A.BANK_CD = B.BANK_CD AND A.SETID = C.SETID AND A.BANK_CD = C.BANK_CD AND A.BRANCH_NAME = C.BRANCH_NAME

  • Related Language Record: BANK_ACCT_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.

    Prompt Table: SP_SETID_NONVW

    2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

    Prompt Table: BANK_CD_INT_VW

    3 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCR_AC Character(30) VARCHAR2(30) NOT NULL Alternate Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 BANK_ID_QUAL Character(3) VARCHAR2(3) NOT NULL "A bank/counterparty attribute that determines

    Prompt Table: BNK_ID_QUAL_VW

    8 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
    9 BRANCH_ID Character(10) VARCHAR2(10) NOT NULL The local branch office identifier associated with a given bank/counterparty.
    10 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
    11 CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL Check Digit
    12 NAME Character(50) VARCHAR2(50) NOT NULL Name
    13 DFI_ID_NUM Character(12) VARCHAR2(12) NOT NULL A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/coun
    14 DFI_ID_QUAL Character(2) VARCHAR2(2) NOT NULL A banking industry convention identifier utilized to drive data validation for a given bank/counterparty.
    01=Transit Number
    02=Swift ID/BIC
    03=CHIPS Participant ID
    04=Canadian Bank Branch/Institute
    05=CHIPS Universal ID
    ZZ=Mutually Defined
    15 BANK_ACCT_TYPE Character(2) VARCHAR2(2) NOT NULL An account attribute that describes the ostensible purposes of a given bank/counterparty account.
    01=Time Deposit
    03=Checking Account
    05=Stock
    06=Bond
    07=Life Insurance Value
    08=Retirement Account
    10=Business Account
    11=Trust Fund Account
    12=Stock & Bond Account
    13=Life Insurance Acct
    CA=Current Account
    CH=Charges Account
    DA=Demand Deposit
    LN=Loan
    RD=Return Items on DDA
    RS=Return Items-Savings
    SA=Settlement Account
    SV=Savings Account
    Z=Mutually Defined