BANK_INTACCT_VW (SQL View)	Index Back
Internal Account Search View View used for adding and updating internal accounts

BANK_INTACCT_VW

(SQL View)

Internal Account Search View

View used for adding and updating internal accounts

SELECT SETID ,BANK_CD ,BANK_CD_CPTY ,BANK_ACCT_KEY ,ACCT_STATUS FROM PS_BANK_ACCT_DEFN WHERE BANK_CD<>BANK_CD_CPTY

# 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_SVCR Character(5) VARCHAR2(5) NOT NULL Represents the internal servicer counterparty in a relationship that pairs differing sets
Prompt Table: BANK_CD_SVCR_VW

3 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

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
Prompt Table: BANK_ACTINT_VW2

5 ACCT_STATUS Character(1) VARCHAR2(1) NOT NULL Account Status - Active/Inactive
A=Active
I=Inactive

#	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_SVCR	Character(5)	VARCHAR2(5) NOT NULL	Represents the internal servicer counterparty in a relationship that pairs differing sets Prompt Table: BANK_CD_SVCR_VW
3	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
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 Prompt Table: BANK_ACTINT_VW2
5	ACCT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Account Status - Active/Inactive A=Active I=Inactive