BNK_CD_EMPL_VW

(SQL View)
 Index Back

Employee Banks/Counterparties

Prompting view that shows only those Employee bank codes that have accounts defined. Used on records where bank code/account are entered in combination.

select distinct A.setid, A.bank_cd, A.descr, A.descrshort from PS_BANK_CD_TBL A, ps_bank_acct_defn B where A.setid = B.setid and A.bank_cd = B.bank_cd and A.bank_type = 'E' and B.bank_acct_qual = 'E'

# 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 Character(5) VARCHAR2(5) NOT NULL Bank Code

Prompt Table: BANK_CD_TBL

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description