ERE_BANK_ESP_VW

(SQL View)
Index Back

Permanent ERE employees

Employee population for a permanent ERE

SELECT A.EMPLID , A.ACCOUNT_ID , A.ACCOUNT_NAME , A.EFF_STATUS , A.ACCOUNT_TYPE_PYE , %Substring(A.BANK_CD,1,4) %Concat %Substring(A.BRANCH_EC_CD,1,4) , A.CHECK_DIGIT %Concat %Substring(A.ACCOUNT_EC_ID,1,10) , A.INTL_BANK_ACCT_NBR FROM PS_PYE_BANKACCT A WHERE A.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERS_SRCH_GBL

2 ACCOUNT_ID Number(3,0) SMALLINT NOT NULL Account ID
3 ACCOUNT_NAME Character(50) VARCHAR2(50) NOT NULL Account Name
4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

5 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

Default Value: C

6 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID

Prompt Table: BANK_EC_TBL

7 ACCOUNT_EC_ID Character(35) VARCHAR2(35) NOT NULL Account Number used in banking.
8 INTL_BANK_ACCT_NBR Character(34) VARCHAR2(34) NOT NULL IBAN International Bank Account Number