SSF_CORE_ACC_VW

(SQL View)
 Index Back

NLD WorkCenter Bank Account


SELECT B.COMMON_ID , B.SSF_BANK_ACCT_ID , B.ACCT_STATUS , B.ACCOUNT_NAME , B.SSF_ACCT_NICKNAME , B.BANK_ACCT_TYP , B.BANK_CD , C.BANK_NM FROM PS_SSF_BANK_ACCT B , PS_BANK_EC_TBL C WHERE C.BANK_CD = B.BANK_CD AND C.COUNTRY_CD = B.COUNTRY_CD AND NOT EXISTS ( SELECT 'X' FROM PS_SSF_STU_BNK_NLD A WHERE A.COMMON_ID = B.COMMON_ID AND A.SA_ID_TYPE = B.SA_ID_TYPE AND B.SSF_BANK_ACCT_ID = A.SSF_BANK_ACCT_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
2 SSF_BANK_ACCT_ID Number(3,0) SMALLINT NOT NULL Unique Bank Account Identifier. It is a sequence number field, unique by COMMON_ID, SA_ID_TYPE.
3 ACCT_STATUS Character(1) VARCHAR2(1) NOT NULL Account Status
A=Active
I=Inactive
4 ACCOUNT_NAME Character(50) VARCHAR2(50) NOT NULL Account Name
5 SSF_ACCT_NICKNAME Character(50) VARCHAR2(50) NOT NULL Nickname on the Bank Accounts page.
6 BANK_ACCT_TYP Character(1) VARCHAR2(1) NOT NULL Bank Account Type
C=Checking
S=Savings
7 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID
8 BANK_NM Character(40) VARCHAR2(40) NOT NULL Bank Name