TS_PROFILE

index back

Do This - Do That Criteria

Search Criteria

  • Parent record of TS_PROFILE_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_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: N

    LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
    TS_SRCH_ONLY Character(1) VARCHAR2(1) NOT NULL Search Only (No Replace)

    Y/N Table Edit

    Default: N

    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: N

    TS_SRCH_LONG Character(1) VARCHAR2(1) NOT NULL Search Long Fields

    Y/N Table Edit

    Default: N

    TS_SRCH_RDY Character(1) VARCHAR2(1) NOT NULL Search Ready

    Y/N Table Edit

    Default: N

    TS_RPLC_RDY Character(1) VARCHAR2(1) NOT NULL Replace Ready

    Y/N Table Edit

    Default: N

    TS_UNDO_RDY Character(1) VARCHAR2(1) NOT NULL Undo Ready

    Y/N Table Edit

    Default: N

    TS_SRCH_MEN Character(1) VARCHAR2(1) NOT NULL Menus

    Y/N Table Edit

    Default: Y

    TS_EXCLUDE_AMPER Character(1) VARCHAR2(1) NOT NULL Exclude & from Menu Search

    Y/N Table Edit

    Default: Y

    TS_SRCH_PNL Character(1) VARCHAR2(1) NOT NULL Pages

    Y/N Table Edit

    Default: Y

    TS_SRCH_REC Character(1) VARCHAR2(1) NOT NULL Records, Fields, Xlats

    Y/N Table Edit

    Default: Y

    TS_SRCH_MSG Character(1) VARCHAR2(1) NOT NULL Messages

    Y/N Table Edit

    Default: Y

    TS_MSG_SET_LOWER Number(5,0) INTEGER NOT NULL Lower Message Set

    Default: 1000

    Prompt Table: PSMSGSETDEFN

    TS_MSG_SET_UPPER Number(5,0) INTEGER NOT NULL Upper Message Set

    Default: 99999

    Prompt Table: PSMSGSETDEFN

    TS_SRCH_BPS Character(1) VARCHAR2(1) NOT NULL Business Processes

    Y/N Table Edit

    Default: Y

    TS_SRCH_QRY Character(1) VARCHAR2(1) NOT NULL Queries and Strings

    Y/N Table Edit

    Default: Y

    TS_SRCH_OTH Character(1) VARCHAR2(1) NOT NULL Other System Objects

    Y/N Table Edit

    Default: Y

    TS_SRCH_APP Character(1) VARCHAR2(1) NOT NULL Application Objects

    Y/N Table Edit

    Default: Y

    PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    TS_SRCH_DTTM DateTime(26) TIMESTAMP Search DateTime
    TS_RPLC_DTTM DateTime(26) TIMESTAMP Replace DateTime
    TS_UNDO_DTTM DateTime(26) TIMESTAMP Replace DateTime
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19