TS_UNDO_RDY_VW

(SQL View)
Index Back

Search Criteria - Undo Ready

Search 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