EX_EE_PYMT2_TAO(SQL Table) |
Index Back |
|---|---|
Payee Bank Information - Temp |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: EX_EE_ORG_DTA.EMPLID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | BANK_SETID |
Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 4 | BANK_CD |
Character(5) | VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
EX_PAYEE_BNK_VW
|
| 5 | BANK_CD_CPTY |
Character(5) | VARCHAR2(5) NOT NULL |
An internal key field convention that facilitates the system distinction between banks and counterparties.
Default Value: EX_EE_PYMNT_DTL.BANK_CD |
| 6 | BANK_ACCT_KEY |
Character(4) | VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
Prompt Table: EX_PAYEE_ACC_VW |
| 7 | DFLT_ACCT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Default Account
Y/N Table Edit Default Value: N |
| 8 | ACCT_SOURCE | Character(2) | VARCHAR2(2) NOT NULL |
Payee Account Source
EX=Expenses PY=Payroll Default Value: EX |
| 9 | PRENOTE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Prenotification Status
C=Confirmed N=New P=Pending R=Rejected S=Submitted Default Value: N |
| 10 | PRENOTE_DATE | Date(10) | DATE | Prenotification Date |
| 11 | PRENOTE_REQD | Character(1) | VARCHAR2(1) NOT NULL |
Prenotification Required
Y/N Table Edit Default Value: INSTALLATION_EX.PRENOTE_REQD |
| 12 | PRENOTE_WAIT_DAYS | Number(3,0) | SMALLINT NOT NULL |
Prenote Wait Days (U.S.)
Default Value: 10 |