TS_RESULT_DATA(SQL Table) |
Index Back |
---|---|
Do This - Do That Result DataSearch Result Data (not including Messages) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). | |
2 | Character(30) | VARCHAR2(30) NOT NULL | Text Search Identifier | |
3 | Number(5,0) | INTEGER NOT NULL | Result Sequence Number | |
4 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
5 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
6 | TS_NUM_PNLS | Number(4,0) | SMALLINT NOT NULL | Number of Panels |
7 | TS_TOO_LONG | Character(1) | VARCHAR2(1) NOT NULL | Too Long |
8 | TS_BASE_TEXT | Character(254) | VARCHAR2(254) NOT NULL | Base Text |
9 | TS_LANG_TEXT | Character(254) | VARCHAR2(254) NOT NULL | Non-Base Text |
10 | TS_RPLC_TEXT | Character(254) | VARCHAR2(254) NOT NULL | Replacement Text |
11 | TS_RPLC | Character(1) | VARCHAR2(1) NOT NULL |
Replace
Y/N Table Edit Default Value: N |
12 | TS_REPLACED | Character(1) | VARCHAR2(1) NOT NULL |
Replaced
Y/N Table Edit Default Value: N |
13 | TS_UNDO | Character(1) | VARCHAR2(1) NOT NULL |
Undo
Y/N Table Edit Default Value: N |
14 | TS_UNDONE | Character(1) | VARCHAR2(1) NOT NULL |
Undone
Y/N Table Edit Default Value: N |