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 NameField TypeColumn TypeDescription
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    TS_SRCH_IDCharacter(30)VARCHAR2(30) NOT NULLText Search Identifier
    TS_RESULT_SEQNumber(5,0)INTEGER NOT NULLResult Sequence Number
    RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
    FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
    TS_NUM_PNLSNumber(4,0)SMALLINT NOT NULLNumber of Panels
    TS_TOO_LONGCharacter(1)VARCHAR2(1) NOT NULLToo Long
    TS_BASE_TEXTCharacter(254)VARCHAR2(254) NOT NULLBase Text
    TS_LANG_TEXTCharacter(254)VARCHAR2(254) NOT NULLNon-Base Text
    TS_RPLC_TEXTCharacter(254)VARCHAR2(254) NOT NULLReplacement Text
    TS_RPLCCharacter(1)VARCHAR2(1) NOT NULLReplace

    Y/N Table Edit

    Default: N

    TS_REPLACEDCharacter(1)VARCHAR2(1) NOT NULLReplaced

    Y/N Table Edit

    Default: N

    TS_UNDOCharacter(1)VARCHAR2(1) NOT NULLUndo

    Y/N Table Edit

    Default: N

    TS_UNDONECharacter(1)VARCHAR2(1) NOT NULLUndone

    Y/N Table Edit

    Default: N

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