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.

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 , B.NICK_NAME , B.PY_BANKACCCRYPT 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

    Prompt Table: PNA_BANK_VW

    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
    J=Job Data
    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

    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
    18 NICK_NAME Character(20) VARCHAR2(20) NOT NULL Nick Name for Direct Deposit Accounts
    19 PY_BANKACCCRYPT Character(100) VARCHAR2(100) NOT NULL Encrypted Bank Account