| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SEARCH_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Search Name
|
| 2 |
USERID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID
|
| 3 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 4 |
OPRID2 |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID
Prompt Table:
OPRID_VW
|
| 5 |
TR_OP_OPRID |
Character(4) |
VARCHAR2(4) NOT NULL |
Bool operator for first line
<>=not =
===
BET=between
BNG=begins with
CNTN=contains
NOTA=not applied
Default Value: BNG
|
| 6 |
EVENT_CODE |
Character(15) |
VARCHAR2(15) NOT NULL |
Event code that corresponds to a specific type of event. Can be used for finer filtering of events.
Prompt Table:
TR_EVENT_CD_TBL
|
| 7 |
EVENT_CD_LIST |
Character(250) |
VARCHAR2(250) NOT NULL |
Event Code
|
| 8 |
TR_OP_EVENT_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Bool operator for first line
BNG=begins with
CNTN=contains
IN=in
NOT=not in
NOTA=not applied
Default Value: BNG
|
| 9 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 10 |
TO_DATE |
Date(10) |
DATE |
To Date
|
| 11 |
TR_OP_DATE |
Character(4) |
VARCHAR2(4) NOT NULL |
Bool operator for first line
<=<
<==<=
<>=not =
===
>=>
>==>=
BET=between
NOTA=not applied
Default Value: =
|
| 12 |
EVENT_SEVERITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Severity level of a given event.
D=Debug
E=Error
I=Information
N=Note
W=Warning
|
| 13 |
EVENT_SEVERITY_LST |
Character(20) |
VARCHAR2(20) NOT NULL |
Event Severity
|
| 14 |
TR_OP_SEVERITY |
Character(4) |
VARCHAR2(4) NOT NULL |
Bool operator for first line
IN=in
NOT=not in
NOTA=not applied
Default Value: IN
|
| 15 |
EVENT_TRACKING_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID.
Prompt Table:
TR_EVNTRK_ID_VW
|
| 16 |
EVENT_TRACKING_ID2 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Event Tracking ID
Prompt Table:
TR_EVNTRK_ID_VW
|
| 17 |
TR_OP_TRCK_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
Bool operator for first line
<=<
<==<=
<>=not =
===
>=>
>==>=
BET=between
NOTA=not applied
Default Value: =
|
| 18 |
TR_FIELDVALUE1 |
Character(35) |
VARCHAR2(35) NOT NULL |
Field Value
|
| 19 |
TR_FIELDVALUE2 |
Character(35) |
VARCHAR2(35) NOT NULL |
Field Value2
|
| 20 |
TR_FIELDVALUE3 |
Character(35) |
VARCHAR2(35) NOT NULL |
Field Value3
|
| 21 |
TR_FIELDVALUE4 |
Character(250) |
VARCHAR2(250) NOT NULL |
Field Value4
|
| 22 |
TR_FIELDVALUE5 |
Character(30) |
VARCHAR2(30) NOT NULL |
Field Value5
|
| 23 |
TR_FIELDVALUE1_TO |
Character(35) |
VARCHAR2(35) NOT NULL |
Field Value1 to
|
| 24 |
TR_FIELDVALUE2_TO |
Character(35) |
VARCHAR2(35) NOT NULL |
Field Value2 to
|
| 25 |
TR_FIELDVALUE3_TO |
Character(35) |
VARCHAR2(35) NOT NULL |
Field Value3 to
|
| 26 |
TR_FIELDVALUE4_TO |
Character(35) |
VARCHAR2(35) NOT NULL |
Field Value4 to
|
| 27 |
TR_FIELDVALUE1_LST |
Character(254) |
VARCHAR2(254) NOT NULL |
Field Value1
|
| 28 |
TR_FIELDVALUE2_LST |
Character(254) |
VARCHAR2(254) NOT NULL |
Field Value2
|
| 29 |
TR_FIELDVALUE3_LST |
Character(254) |
VARCHAR2(254) NOT NULL |
Field Value3
|
| 30 |
TR_OP_FLD1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Expression Type
<=<
<==<=
===
>=>
>==>=
BET=between
BNG=begins with
CNTN=contains
IN=in
NOT=not =
NOTA=not applied
Default Value: =
|
| 31 |
TR_OP_FLD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Expression Type
<=<
<==<=
<>=not =
===
>=>
>==>=
BET=between
BNG=begins with
CNTN=contains
IN=in
NOT=not in
NOTA=not applied
Default Value: =
|
| 32 |
TR_OP_FLD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Expression Type
<=<
<==<=
===
>=>
>==>=
BET=between
BNG=begins with
CNTN=contains
IN=in
NOT=not =
NOTA=not applied
Default Value: =
|
| 33 |
EVENT_LOG_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Source
BKN=Bank Transfers
BOK=Book to Bank Reconciliation
BSM=Bank Statement
BST=Bank Statement Load
CFI=Cash Forecast Import
DEA=Deals
EFT=EFT Requests
EQT=Equities
FEE=Fees
HDG=Hedge
IDF=Investment Pools - Definition
IPR=Investment Pools - Participant
PMD=Payment Processing
PMF=Payment File
PYM=Payment Acknowledgements
SRT=Securities
|