GPSC_SSB_BFL_VW

(SQL View)
Index Back

Bank Accounts Summary Record.

Fluid Bank Accounts Summary Record.

SELECT EMPLID , ACCOUNT_ID , EFF_STATUS , ACCOUNT_TYPE_PYE , BANK_CD , BRANCH_EC_CD , INTL_BANK_ACCT_NBR , ACCOUNT_EC_ID , ROLL_NAME , ROLL_NUMBER , COUNTRY_CD , ACCOUNT_NAME , CURRENCY_CD , HSC_BANKACCCRYPT, HSC_BANKACCCRYPT3 FROM PS_PYE_BANKACCT

# 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
4 ACCOUNT_TYPE_PYE Character(1) VARCHAR2(1) NOT NULL Payee Bank Account Type
A=Current Account
B=Building Society Roll Number
C=Checking
G=Giro Account
R=Regular
S=Savings
T=Salary Account
5 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID

Prompt Table: BANK_EC_TBL

6 BRANCH_EC_CD Character(17) VARCHAR2(17) NOT NULL Bank Branch ID

Prompt Table: %GP_EDIT_FLD1

7 INTL_BANK_ACCT_NBR Character(34) VARCHAR2(34) NOT NULL IBAN International Bank Account Number
8 ACCOUNT_EC_ID Character(35) VARCHAR2(35) NOT NULL Account Number used in banking.
9 ROLL_NAME Character(50) VARCHAR2(50) NOT NULL Roll Name
10 ROLL_NUMBER Character(20) VARCHAR2(20) NOT NULL Roll Number
11 COUNTRY_CD Character(3) VARCHAR2(3) NOT NULL Country Code
12 ACCOUNT_NAME Character(50) VARCHAR2(50) NOT NULL Account Name
13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: COUNTRY_CUR_TBL.CURRENCY_CD

Prompt Table: CURRENCY_CD_TBL

14 HSC_BANKACCCRYPT Character(100) VARCHAR2(100) NOT NULL Encrypted Bank Account
15 HSC_BANKACCCRYPT3 Character(100) VARCHAR2(100) NOT NULL Encrypted Bank Account