PY_IC_DD_DTA_VW (SQL View)	Index Back
WEB - Payroll - DDP Data View Data View to support WEB-enabled Direct Deposit Update. This view restricts the data shown in this application to be the current data only. It joins DIR_DEP_DISTRIB with DIRECT_DEPOSIT to fetch the most current rows.

PY_IC_DD_DTA_VW

(SQL View)

WEB - Payroll - DDP Data View

Data View to support WEB-enabled Direct Deposit Update. This view restricts the data shown in this application to be the current data only. It joins DIR_DEP_DISTRIB with DIRECT_DEPOSIT to fetch the most current rows.

SELECT B.EMPLID , B.EFFDT , B.PRIORITY , B.ACCOUNT_NUM , B.ACCOUNT_TYPE , B.COUNTRY_CD , B.IAT_IND , B.BANK_CD , B.BRANCH_EC_CD , B.DEPOSIT_AMT , B.AMOUNT_PCT , B.LAST_ACTION , B.LAST_UPDATE_DATE , B.DEPOSIT_TYPE , B.PRENOTE_REQD , B.PRENOTE_STATUS , B.PRENOTE_DATE FROM PS_DIR_DEP_DISTRIB B

Parent record: DIRECT_DEPOSIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 PRIORITY Number(3,0) SMALLINT NOT NULL Priority

4 ACCOUNT_NUM Character(17) VARCHAR2(17) NOT NULL Account Number

5 ACCOUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Account Type
$=Issue Check
C=Checking
L=Liability
N=Non Applicable
S=Savings
X=Expense

6 COUNTRY_CD Character(3) VARCHAR2(3) NOT NULL Country Code
Default Value: USA
Prompt Table: COUNTRY1_VW

7 IAT_IND Character(1) VARCHAR2(1) NOT NULL International ACH Transaction Bank (or IAT) Indicator
Y/N Table Edit
Default Value: N

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

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

10 DEPOSIT_AMT Number(11,2) DECIMAL(10,2) NOT NULL Amount in Dollars

11 AMOUNT_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Percent Amount

12 LAST_ACTION Character(1) VARCHAR2(1) NOT NULL Last Action
C=System
D=Hire Process
O=Online User
S=Supplier Deduction File
W=Employee Self Service User

13 LAST_UPDATE_DATE Date(10) DATE Date of last update

14 DEPOSIT_TYPE Character(1) VARCHAR2(1) NOT NULL Deposit Type
A=Amount
B=Balance of Net Pay
P=Percent

15 PRENOTE_REQD Character(1) VARCHAR2(1) NOT NULL Prenotification Reqd
Y/N Table Edit
Default Value: Y

16 PRENOTE_STATUS Character(1) VARCHAR2(1) NOT NULL Prenotification Status
C=Completed
N=Not Submitted
P=Pending
R=Rejected
S=Submitted
Default Value: N

17 PRENOTE_DATE Date(10) DATE Prenotification Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	PRIORITY	Number(3,0)	SMALLINT NOT NULL	Priority
4	ACCOUNT_NUM	Character(17)	VARCHAR2(17) NOT NULL	Account Number
5	ACCOUNT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Account Type $=Issue Check C=Checking L=Liability N=Non Applicable S=Savings X=Expense
6	COUNTRY_CD	Character(3)	VARCHAR2(3) NOT NULL	Country Code Default Value: USA Prompt Table: COUNTRY1_VW
7	IAT_IND	Character(1)	VARCHAR2(1) NOT NULL	International ACH Transaction Bank (or IAT) Indicator Y/N Table Edit Default Value: N
8	BANK_CD	Character(11)	VARCHAR2(11) NOT NULL	Bank ID
9	BRANCH_EC_CD	Character(17)	VARCHAR2(17) NOT NULL	Bank Branch ID
10	DEPOSIT_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Amount in Dollars
11	AMOUNT_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Percent Amount
12	LAST_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Last Action C=System D=Hire Process O=Online User S=Supplier Deduction File W=Employee Self Service User
13	LAST_UPDATE_DATE	Date(10)	DATE	Date of last update
14	DEPOSIT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Deposit Type A=Amount B=Balance of Net Pay P=Percent
15	PRENOTE_REQD	Character(1)	VARCHAR2(1) NOT NULL	Prenotification Reqd Y/N Table Edit Default Value: Y
16	PRENOTE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Prenotification Status C=Completed N=Not Submitted P=Pending R=Rejected S=Submitted Default Value: N
17	PRENOTE_DATE	Date(10)	DATE	Prenotification Date