BANK_ACCT_LNX (SQL View)	Index Back
Bank Accounts Union To improve performance in multi language environments

BANK_ACCT_LNX

(SQL View)

Bank Accounts Union

To improve performance in multi language environments

SELECT B.SETID , B.BANK_CD , B.BANK_CD_CPTY , B.BANK_ACCT_KEY , B.LANGUAGE_CD , B.DESCR FROM PS_BANK_ACCT_LNG B WHERE B.LANGUAGE_CD IN ( SELECT DISTINCT LANGUAGE_CD FROM PS_BANK_CD_LNG) UNION SELECT C.SETID , C.BANK_CD , C.BANK_CD_CPTY , C.BANK_ACCT_KEY , D.FIELDVALUE , C.DESCR FROM PS_BANK_ACCT_DEFN C , PSXLATITEM D WHERE FIELDNAME = 'LANGUAGE_CD' AND NOT EXISTS ( SELECT 'X' FROM PS_BANK_ACCT_LNG L WHERE L.SETID = C.SETID AND L.BANK_CD = C.BANK_CD AND L.BANK_CD_CPTY = C.BANK_CD_CPTY AND L.BANK_ACCT_KEY = C.BANK_ACCT_KEY AND L.LANGUAGE_CD = D.FIELDVALUE)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

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

3 BANK_CD_CPTY Character(5) VARCHAR2(5) NOT NULL An internal key field convention that facilitates the system distinction between banks and counterparties.

4 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

5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
3	BANK_CD_CPTY	Character(5)	VARCHAR2(5) NOT NULL	An internal key field convention that facilitates the system distinction between banks and counterparties.
4	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
5	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description