TS_RESULT_DATA

(SQL Table)
Index Back

Do This - Do That Result Data

Search Result Data (not including Messages)

  • Parent Record Of TS_RESULT_KEYS TS_RESULT_PNLS TS_RESULT_TXT
  • # 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_RESULT_SEQ 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