DIR_DEP_DISTRIB(SQL Table) |
Index Back |
---|---|
Direct Dep Distributn DetailDirect 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. |
# | 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 |