SSF_EXT_BNK_VW

(SQL View)
 Index Back

SELECT DISTINCT A.COMMON_ID , A.SSF_BANK_ACCT_ID , B.ACCOUNT_NAME , B.SSF_ACCT_NICKNAME ,C.DESCR FROM PS_SSF_COR_BNK_NLD A ,PS_SSF_BANK_ACCT B ,PS_EXT_ORG_TBL C WHERE A.COMMON_ID = B.COMMON_ID AND A.SA_ID_TYPE = B.SA_ID_TYPE AND A.SSF_BANK_ACCT_ID = B.SSF_BANK_ACCT_ID AND B.ACCT_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_SSF_COR_BNK_NLD A1 WHERE A.COMMON_ID = A1.COMMON_ID AND A.SA_ID_TYPE = A1.SA_ID_TYPE AND A1.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(A2.EFFSEQ) FROM PS_SSF_COR_BNK_NLD A2 WHERE A.COMMON_ID = A2.COMMON_ID AND A.SA_ID_TYPE = A2.SA_ID_TYPE AND A2.EFFDT = A.EFFDT) AND B.COMMON_ID = C.EXT_ORG_ID AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_EXT_ORG_TBL C1 WHERE C.EXT_ORG_ID = C1.EXT_ORG_ID AND C1.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
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 ACCOUNT_NAME Character(50) VARCHAR2(50) NOT NULL Account Name
4 SSF_ACCT_NICKNAME Character(50) VARCHAR2(50) NOT NULL Nickname on the Bank Accounts page.
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description