| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
TS_SRCH_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Text Search Identifier
|
| 3 |
TS_SRCH_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Search Status
C=Complete
I=In Process
N=New Search
R=Replace Complete
S=Search Complete
U=Undo Complete
Default Value: N
|
| 4 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 5 |
TS_SRCH_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Search Only (No Replace)
Y/N Table Edit
Default Value: N
|
| 6 |
TS_SRCH_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Search Type
B=Base Language
N=Non-Base Language
T=Both Base and Non-Base
Default Value: N
|
| 7 |
TS_SRCH_LONG |
Character(1) |
VARCHAR2(1) NOT NULL |
Search Long Fields
Y/N Table Edit
Default Value: N
|
| 8 |
TS_SRCH_RDY |
Character(1) |
VARCHAR2(1) NOT NULL |
Search Ready
Y/N Table Edit
Default Value: N
|
| 9 |
TS_RPLC_RDY |
Character(1) |
VARCHAR2(1) NOT NULL |
Replace Ready
Y/N Table Edit
Default Value: N
|
| 10 |
TS_UNDO_RDY |
Character(1) |
VARCHAR2(1) NOT NULL |
Undo Ready
Y/N Table Edit
Default Value: N
|
| 11 |
TS_SRCH_MEN |
Character(1) |
VARCHAR2(1) NOT NULL |
Menus
Y/N Table Edit
Default Value: Y
|
| 12 |
TS_EXCLUDE_AMPER |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude & from Menu Search
Y/N Table Edit
Default Value: Y
|
| 13 |
TS_SRCH_PNL |
Character(1) |
VARCHAR2(1) NOT NULL |
Pages
Y/N Table Edit
Default Value: Y
|
| 14 |
TS_SRCH_REC |
Character(1) |
VARCHAR2(1) NOT NULL |
Records, Fields, Xlats
Y/N Table Edit
Default Value: Y
|
| 15 |
TS_SRCH_MSG |
Character(1) |
VARCHAR2(1) NOT NULL |
Messages
Y/N Table Edit
Default Value: Y
|
| 16 |
TS_MSG_SET_LOWER |
Number(5,0) |
INTEGER NOT NULL |
Lower Message Set
Default Value: 1000
Prompt Table:
PSMSGSETDEFN
|
| 17 |
TS_MSG_SET_UPPER |
Number(5,0) |
INTEGER NOT NULL |
Upper Message Set
Default Value: 99999
Prompt Table:
PSMSGSETDEFN
|
| 18 |
TS_SRCH_BPS |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Processes
Y/N Table Edit
Default Value: Y
|
| 19 |
TS_SRCH_QRY |
Character(1) |
VARCHAR2(1) NOT NULL |
Queries and Strings
Y/N Table Edit
Default Value: Y
|
| 20 |
TS_SRCH_OTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Other System Objects
Y/N Table Edit
Default Value: Y
|
| 21 |
TS_SRCH_APP |
Character(1) |
VARCHAR2(1) NOT NULL |
Application Objects
Y/N Table Edit
Default Value: Y
|
| 22 |
PRCSINSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 23 |
TS_SRCH_DTTM |
DateTime(26) |
TIMESTAMP |
Search DateTime
|
| 24 |
TS_RPLC_DTTM |
DateTime(26) |
TIMESTAMP |
Replace DateTime
|
| 25 |
TS_UNDO_DTTM |
DateTime(26) |
TIMESTAMP |
Replace DateTime
|