EM_BU_BANK_VW (SQL View)	Index Back
Banks based on Tableset Cntrl Returns a list of banks available to a user based on the setid established for banks in Tableset Control. This is only for the BD Model.

EM_BU_BANK_VW

(SQL View)

Banks based on Tableset Cntrl

Returns a list of banks available to a user based on the setid established for banks in Tableset Control. This is only for the BD Model.

SELECT DISTINCT A.BUSINESS_UNIT , B.SETID , C.BANK_CD , C.DESCR , C.DESCRSHORT , C.DESCR_AC FROM PS_EM_BUY_REG_TBL A , PS_SET_CNTRL_REC B , PS_BANK_CD_TBL C WHERE B.SETCNTRLVALUE = A.BUSINESS_UNIT AND B.RECNAME = 'BANK_CD_TBL' AND C.SETID = B.SETID AND C.AP = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
Prompt Table: SETID_TBL

3 EM_BANK_CD Character(5) VARCHAR2(5) NOT NULL A unique key identifier that represents a bank or counterparty.

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
Prompt Table: EM_BANK_DSCR_VW

5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

6 DESCR_AC Character(30) VARCHAR2(30) NOT NULL Alternate Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty. Prompt Table: SETID_TBL
3	EM_BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	A unique key identifier that represents a bank or counterparty.
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description Prompt Table: EM_BANK_DSCR_VW
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
6	DESCR_AC	Character(30)	VARCHAR2(30) NOT NULL	Alternate Description