DIR_DEP_DISTRIB

(SQL Table)
Index Back

Direct Dep Distributn Detail

Direct deposit instructions and prenote status by employee and priority. A view W3PY_DDP_DDB_VW based on this record has been created for the purpose of WEB-enabled Direct Deposit update. Changes made to the record DIR_DEP_DISTRIB would need to be analyzed and made to W3PY_DDP_DDB_VW, if necessary.

  • Parent record: DIRECT_DEPOSIT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date
    3 PRIORITY Number(3,0) SMALLINT NOT NULL Priority
    4 ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL Account Number
    5 COUNTRY_CD Character(3) VARCHAR2(3) NOT NULL Country Code
    6 ACCOUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Identifies a category of accounts that appears on the balance sheet or income statement of the enterprise. Each general ledger account (ACCOUNT) is associated with an account type (also called a ""monetary account type""). PeopleSoft delivers standard account types such as asset, liability, expense, and revenue.

    Prompt Table: ACCT_TYPE_TBL

    7 BANK_CD_HR Character(11) VARCHAR2(11) NOT NULL Bank Code
    8 BRANCH_EC_CD Character(17) VARCHAR2(17) NOT NULL Bank Branch ID
    9 DEPOSIT_AMT_HR Number(11,2) DECIMAL(10,2) NOT NULL Amount in Dollars
    10 AMOUNT_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Percent Amount
    11 PRENOTE_STATUS Character(1) VARCHAR2(1) NOT NULL Prenotification Status
    C=Confirmed
    N=New
    P=Pending
    R=Rejected
    S=Submitted
    12 PRENOTE_DATE Date(10) DATE Prenotification Date
    13 PRENOTE_REQD Character(1) VARCHAR2(1) NOT NULL Prenotification Required

    Y/N Table Edit

    14 LAST_ACTION Character(1) VARCHAR2(1) NOT NULL Last Action
    C=System
    D=Hire Process
    O=Online Operator
    W=Web User
    15 LAST_UPDATE_DATE Date(10) DATE Date of last update
    16 DEPOSIT_TYPE Character(1) VARCHAR2(1) NOT NULL Deposit Type
    A=Amount
    B=Balance of Net Pay
    P=Percent