SSF_EMPL_BNK_VW

(SQL View)

SELECT A.COMMON_ID , A.SSF_BANK_ACCT_ID , B.ACCOUNT_NAME , B.SSF_ACCT_NICKNAME ,B.BANK_ACCT_TYP FROM PS_SSF_STU_BNK_NLD A ,PS_SSF_BANK_ACCT B 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_STU_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_STU_BNK_NLD A2 WHERE A.COMMON_ID = A2.COMMON_ID AND A.SA_ID_TYPE = A2.SA_ID_TYPE AND A2.EFFDT = A.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 ACCOUNT_ID Number(3,0) SMALLINT NOT NULL Account ID

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 BANK_ACCT_TYP Character(1) VARCHAR2(1) NOT NULL Bank Account Type
C=Checking
S=Savings

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	ACCOUNT_ID	Number(3,0)	SMALLINT NOT NULL	Account ID
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	BANK_ACCT_TYP	Character(1)	VARCHAR2(1) NOT NULL	Bank Account Type C=Checking S=Savings