TS_PROFILE_TXT

index back

Search Criteria - Text

Search Criteria - Text

  • Parent record: TS_PROFILE
  • PeopleSoft Field Name Field Type Column Type Description
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Default: TS_PROFILE.OPRID

    TS_SRCH_ID Character(30) VARCHAR2(30) NOT NULL Text Search Identifier

    Default: TS_PROFILE.TS_SRCH_ID

    TS_SRCH_BASE_TEXT Character(30) VARCHAR2(30) NOT NULL Base Search Text
    TS_SRCH_LANG_TEXT Character(30) VARCHAR2(30) NOT NULL Non-Base Search Text
    TS_RPLC_LANG_TEXT Character(30) VARCHAR2(30) NOT NULL Replacement Text
    TS_BASE_MATCHTYPE Character(1) VARCHAR2(1) NOT NULL Base Text Matching Type
    E=Exact Text Match
    F=Full Word Match
    P=Like Text Match

    Default: F

    TS_LANG_MATCHTYPE Character(1) VARCHAR2(1) NOT NULL Lang Text Matching Type
    E=Exact Text Match
    F=Full Word Match
    P=Like Text Match

    Default: F

    TS_BASE_MATCH_CASE Character(1) VARCHAR2(1) NOT NULL Base Match Case

    Y/N Table Edit

    Default: N

    TS_LANG_MATCH_CASE Character(1) VARCHAR2(1) NOT NULL Lang Match Case

    Y/N Table Edit

    Default: N

    TS_RPLC_MATCH_CASE Character(1) VARCHAR2(1) NOT NULL Replace Text Case
    N=Overwrite Text
    Y=Preserve Original Case

    Default: Y

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