| # |
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
Prompt Table:
ACCTYPE_DD_VW
|
| 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 |
PRENOTE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Prenotification Status
C=Completed
N=Not Submitted
P=Pending
R=Rejected
S=Submitted
Default Value: N
|
| 13 |
PRENOTE_DATE |
Date(10) |
DATE |
Prenotification Date
|
| 14 |
PRENOTE_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Prenotification Reqd
Y/N Table Edit
Default Value: N
|
| 15 |
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
|
| 16 |
LAST_UPDATE_DATE |
Date(10) |
DATE |
Date of last update
|
| 17 |
DEPOSIT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Deposit Type
A=Amount
B=Balance of Net Pay
P=Percent
|