SSF_STBANKWC_VW

(SQL View)
 Index Back

NLD WorkCenter Bank Account


SELECT A.COMMON_ID , A.SSF_BANK_ACCT_ID , B.ACCT_STATUS , A.EFFDT , B.ACCOUNT_NAME , B.SSF_ACCT_NICKNAME , B.BANK_ACCT_TYP , A.ACAD_YEAR , A.SSF_TUIT_CH_NLD , A.ACCOUNT_ID , B.BANK_CD , C.BANK_NM FROM PS_SSF_STU_BNK_NLD A , 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 ( A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_SSF_STU_BNK_NLD A_ED WHERE A.COMMON_ID = A_ED.COMMON_ID AND A.SA_ID_TYPE = A_ED.SA_ID_TYPE AND A_ED.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(A_ES.EFFSEQ) FROM PS_SSF_STU_BNK_NLD A_ES WHERE A.COMMON_ID = A_ES.COMMON_ID AND A.SA_ID_TYPE = A_ES.SA_ID_TYPE AND A.EFFDT = A_ES.EFFDT) AND 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 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 ACCOUNT_NAME Character(50) VARCHAR2(50) NOT NULL Account Name
6 SSF_ACCT_NICKNAME Character(50) VARCHAR2(50) NOT NULL Nickname on the Bank Accounts page.
7 BANK_ACCT_TYP Character(1) VARCHAR2(1) NOT NULL Bank Account Type
C=Checking
S=Savings
8 ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year
9 SSF_TUIT_CH_NLD Character(1) VARCHAR2(1) NOT NULL Tuition Check NLD
10 ACCOUNT_ID Number(3,0) SMALLINT NOT NULL Account ID
11 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID
12 BANK_NM Character(40) VARCHAR2(40) NOT NULL Bank Name