PY_IC_DD_AUDIT

(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 AUDIT_OPRID Character(30) VARCHAR2(30) NOT NULL The OPRID of the user who made the changes audited on an audit record.
    2 AUDIT_STAMP DateTime(26) TIMESTAMP Date and Time Stamp
    3 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
    A=Add
    C=Change Old (PPR Only)
    D=Delete
    K=Change - Old Values
    N=Change - New Values
    O=Change - Original Values
    4 AUDIT_FLAG Character(1) VARCHAR2(1) NOT NULL Audit Flag
    A=After
    B=Before
    5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    6 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    7 PRIORITY Number(3,0) SMALLINT NOT NULL Priority
    8 ACCOUNT_NUM Character(17) VARCHAR2(17) NOT NULL Account Number
    9 ACCOUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Account Type
    $=Issue Check
    C=Checking
    L=Liability
    N=Non Applicable
    S=Savings
    X=Expense
    10 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID
    11 BRANCH_EC_CD Character(17) VARCHAR2(17) NOT NULL Bank Branch ID
    12 DEPOSIT_AMT Number(11,2) DECIMAL(10,2) NOT NULL Amount in Dollars
    13 AMOUNT_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Percent Amount
    14 PRENOTE_STATUS Character(1) VARCHAR2(1) NOT NULL Prenotification Status
    C=Completed
    N=Not Submitted
    P=Pending
    R=Rejected
    S=Submitted

    Default Value: N

    15 PRENOTE_DATE Date(10) DATE Prenotification Date
    16 PRENOTE_REQD Character(1) VARCHAR2(1) NOT NULL Prenotification Reqd

    Y/N Table Edit

    17 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
    18 LAST_UPDATE_DATE Date(10) DATE Date of last update
    19 DEPOSIT_TYPE Character(1) VARCHAR2(1) NOT NULL Deposit Type
    A=Amount
    B=Balance of Net Pay
    P=Percent
    20 NICK_NAME Character(20) VARCHAR2(20) NOT NULL Nick Name for Direct Deposit Accounts