GP_EEBNKACT_VW

(SQL View)
 Index Back

Payee Bank Account

Global Payroll self service view of PYE_BANKACCT, providing active employee personal bank account information.

SELECT EMPLID ,ACCOUNT_ID ,EFF_STATUS ,ACCOUNT_TYPE_PYE ,COUNTRY_CD ,BANK_CD ,BRANCH_EC_CD ,ACCOUNT_NAME ,ACCOUNT_EC_ID ,ROLL_NAME ,ROLL_NUMBER ,CHECK_DIGIT ,CURRENCY_CD FROM PS_PYE_BANKACCT WHERE EFF_STATUS = 'A'

# 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 COUNTRY_CD Character(3) VARCHAR2(3) NOT NULL Country Code
6 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID

Prompt Table: BANK_EC_TBL

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

Prompt Table: %GP_EDIT_FLD1

8 ACCOUNT_NAME Character(50) VARCHAR2(50) NOT NULL Account Name
9 ACCOUNT_EC_ID Character(35) VARCHAR2(35) NOT NULL Account Number used in banking.
10 ROLL_NAME Character(50) VARCHAR2(50) NOT NULL Roll Name
11 ROLL_NUMBER Character(20) VARCHAR2(20) NOT NULL Roll Number
12 CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL Check Digit
13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code