PYE_BANKACCT_VW

(SQL View)
 Index Back

Payee Bank Account

Global Payroll Self Service View on PYE_BANKACCT

SELECT EMPLID ,ACCOUNT_ID ,EFF_STATUS ,ACCOUNT_TYPE_PYE ,COUNTRY_CD ,BANK_CD ,BRANCH_EC_CD ,ACCOUNT_EC_ID ,CHECK_DIGIT ,CURRENCY_CD ,ACCOUNT_NAME ,INTL_BANK_ACCT_NBR ,ROLL_NAME ,ROLL_NUMBER ,ACCOUNT_NAME_AC ,IAT_IND 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

Default Value: A

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

Default Value: C

5 COUNTRY_CD Character(3) VARCHAR2(3) NOT NULL Country Code

Prompt Table: COUNTRY_TBL

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_EC_ID Character(35) VARCHAR2(35) NOT NULL Account Number used in banking.
9 CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL Check Digit
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

Prompt Table: CURRENCY_CD_TBL

11 ACCOUNT_NAME Character(50) VARCHAR2(50) NOT NULL Account Name
12 INTL_BANK_ACCT_NBR Character(34) VARCHAR2(34) NOT NULL IBAN International Bank Account Number
13 ROLL_NAME Character(50) VARCHAR2(50) NOT NULL Roll Name
14 ROLL_NUMBER Character(20) VARCHAR2(20) NOT NULL Roll Number
15 ACCOUNT_NAME_AC Character(40) VARCHAR2(40) NOT NULL This field stores the account name in an alternate character format
16 IAT_IND Character(1) VARCHAR2(1) NOT NULL International ACH Transaction Bank (or IAT) Indicator

Y/N Table Edit

Default Value: N