TS_RESULT_DATA

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 Field Type Column Type Description
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    TS_SRCH_ID Character(30) VARCHAR2(30) NOT NULL Text Search Identifier
    TS_RESULT_SEQ Number(5,0) INTEGER NOT NULL Result Sequence Number
    RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    TS_NUM_PNLS Number(4,0) SMALLINT NOT NULL Number of Panels
    TS_TOO_LONG Character(1) VARCHAR2(1) NOT NULL Too Long
    TS_BASE_TEXT Character(254) VARCHAR2(254) NOT NULL Base Text
    TS_LANG_TEXT Character(254) VARCHAR2(254) NOT NULL Non-Base Text
    TS_RPLC_TEXT Character(254) VARCHAR2(254) NOT NULL Replacement Text
    TS_RPLC Character(1) VARCHAR2(1) NOT NULL Replace

    Y/N Table Edit

    Default: N

    TS_REPLACED Character(1) VARCHAR2(1) NOT NULL Replaced

    Y/N Table Edit

    Default: N

    TS_UNDO Character(1) VARCHAR2(1) NOT NULL Undo

    Y/N Table Edit

    Default: N

    TS_UNDONE Character(1) VARCHAR2(1) NOT NULL Undone

    Y/N Table Edit

    Default: N

    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19