TS_UNDO_RDY_VW(SQL View) |
Index Back |
---|---|
Search Criteria - Undo ReadySearch Criteria - Ready for Undo |
SELECT OPRID, TS_SRCH_ID, TS_SRCH_STATUS, LANGUAGE_CD, TS_SRCH_LONG, TS_EXCLUDE_AMPER, TS_MSG_SET_LOWER, TS_MSG_SET_UPPER, TS_SRCH_TYPE , TS_SRCH_ONLY, TS_SRCH_RDY, TS_RPLC_RDY, TS_UNDO_RDY, TS_SRCH_PNL, TS_SRCH_MEN, TS_SRCH_REC, TS_SRCH_MSG, TS_SRCH_BPS, TS_SRCH_QRY, TS_SRCH_OTH, TS_SRCH_APP, PRCSINSTANCE, TS_SRCH_DTTM , TS_RPLC_DTTM, TS_UNDO_DTTM FROM PS_TS_PROFILE WHERE TS_SRCH_STATUS = 'R' AND TS_UNDO_RDY = 'Y' |
# | 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_LONG | Character(1) | VARCHAR2(1) NOT NULL |
Search Long Fields
Y/N Table Edit Default Value: N |
6 | TS_EXCLUDE_AMPER | Character(1) | VARCHAR2(1) NOT NULL |
Exclude & from Menu Search
Y/N Table Edit Default Value: Y |
7 | TS_MSG_SET_LOWER | Number(5,0) | INTEGER NOT NULL | Lower Message Set |
8 | TS_MSG_SET_UPPER | Number(5,0) | INTEGER NOT NULL | Upper Message Set |
9 | 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 |
10 | TS_SRCH_ONLY | Character(1) | VARCHAR2(1) NOT NULL |
Search Only (No Replace)
Y/N Table Edit Default Value: N |
11 | TS_SRCH_RDY | Character(1) | VARCHAR2(1) NOT NULL |
Search Ready
Y/N Table Edit Default Value: N |
12 | TS_RPLC_RDY | Character(1) | VARCHAR2(1) NOT NULL |
Replace Ready
Y/N Table Edit Default Value: N |
13 | TS_UNDO_RDY | Character(1) | VARCHAR2(1) NOT NULL |
Undo Ready
Y/N Table Edit Default Value: N |
14 | TS_SRCH_PNL | Character(1) | VARCHAR2(1) NOT NULL |
Pages
Y/N Table Edit Default Value: Y |
15 | TS_SRCH_MEN | Character(1) | VARCHAR2(1) NOT NULL |
Menus
Y/N Table Edit Default Value: Y |
16 | TS_SRCH_REC | Character(1) | VARCHAR2(1) NOT NULL |
Records, Fields, Xlats
Y/N Table Edit Default Value: Y |
17 | TS_SRCH_MSG | Character(1) | VARCHAR2(1) NOT NULL |
Messages
Y/N Table Edit Default Value: Y |
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 |